Error on update query – not using site table prefix

Douglas Lee 3 years, 9 months ago

When doing updates I noticed this in the log (subbed dbname for our database name):

WordPress database error Table ‘dbname.wp_options’ doesn’t exist for query SELECT wpscm_options.option_name as option_name, wpscm_options.option_value as option_value FROM wp_options WHERE option_name LIKE ‘fv_player_pro_transcript_%’ made by do_action_ref_array(‘fv_player_pro_update_transcript_cache’), WP_Hook->do_action, WP_Hook->apply_filters, FV_Player_Pro_Trascript->update_transcript_cache

It is not applying the proper table prefix, wpscm in our case, and so therefore cannot find the ‘wp_options’ table as it should be ‘wpscm_options’. It gets it right in the field list but not in the FROM clause.

First, this should be fixed, but then how do we ensure the right queries are run for our site?

Viewing 2 replies - 1 through 2 (of 2 total)

Douglas Lee 4 years ago

Seems line 318 of transcript.class.php:

Needed {$wpdb->prefix}options instead of just wp_options in the FROM clause.

Martin 4 years ago

Hello Douglas,

thank you very much for letting us know about the issue. It seems this slipped our attention.

I put in the fix, it will be part of the next FV Player Pro release.

If you want to get it right now you can deactivate and delete the FV Player Pro plugin and then let wp-admin -> Settings -> FV Player reinstall the Pro pack for you. Or you can grab a fresh ZIP file of FV Player Pro from https://foliovision.com/my-licenses and reinstall from that.

Thanks,
Martin

Viewing 2 replies - 1 through 2 (of 2 total)