• Skip to content
  • Skip to primary sidebar
  • Skip to footer

Foliovision

Main navigation

  • Weblog
    • FV Player
    • WordPress
    • Video of the Week
    • Case Studies
    • Business
  • About
    • Testimonials
    • Meet the Team
    • We Support
    • Careers
    • Contact
    • Pricing
  • Products
  • Support
    • FV Player Docs
    • Pro Support
  • Login
  • Basket is empty

Error on update query – not using site table prefix

Foliovision › Forums › FV Player › Bug Reports › Error on update query – not using site table prefix

  • Douglas Lee 4 years, 2 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)
Reply To: Error on update query – not using site table prefix



Please Sign in or Register to upload files.

Related Posts

  1. Vimeo Issue with wp_options table

    Vimeo Issue with wp_options table

  2. URGENT massive site performance risk: `update_option()` fails `autoload = no`

    URGENT massive site performance risk: `update_option()` fails `autoload = no`

  3. Table styles overriden by template table styles

    Table styles overriden by template table styles

Primary Sidebar

Sign in Register
FV Player Docs Post New Topic

Welcome

to Foliovision support forums! We'll be happy to provide free support to resolve all the reported bugs. You always can start by specifying your OS and browser and steps to reproduce the bug.

If you need help with the installation on your site, please submit a request for a Pro Support Incident. We'll have you up and running in no time, with detailed instructions on how to resolve your issue yourself in the future.

Facing a hard to solve WordPress problem? On a tight deadline?

Let us take care of it for you
right now.

Pro Support Buy FV Player

Footer

Our Plugins

  • FV WordPress Flowplayer
  • FV Thoughtful Comments
  • FV Simpler SEO
  • FV Antispam
  • FV Gravatar Cache
  • FV Testimonials

Free Tools

  • Pandoc Online
  • Article spinner
  • WordPress Password Finder
  • Delete LinkedIn Account
  • Responsive Design Calculator
Foliovision logo
All materials © 2025 Foliovision s.r.o. | Panská 12 - 81101 Bratislava - Slovakia | info@foliovision.com
  • This Site Uses Cookies
  • Privacy Policy
  • Terms of Service
  • Site Map
  • Contact
  • Tel. ‭+421 2/5292 0086‬

We are using cookies to give you the best experience on our website.

You can find out more about which cookies we are using or switch them off in .

Powered by  GDPR Cookie Compliance
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

Necessary Cookies

Strictly Necessary Cookie allow you to log in and download your software or post to forums.

We use the WordPress login cookie and the session cookie.

If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.

Support Cookies

Foliovision.com uses self-hosted Rocket.chat and self-hosted Freescout support desk to provide support for FV Player users. These cookies allow our visitors to chat with us and/or submit support tickets.

We are delighted to recommend self-hosted Rocket.chat and especially Freescout to other privacy-conscious independent publishers who would prefer to self-host support.

Please enable Strictly Necessary Cookies first so that we can save your preferences!

3rd Party Cookies

This website uses Google Analytics and Statcounter to collect anonymous information such as the number of visitors to the site, and the most popular pages.

Keeping this cookie enabled helps us to improve our website.

We reluctantly use Google Analytics as it helps us to test FV Player against popular Google Analytics features. Feel free to turn off these cookies if they make you feel uncomfortable.

Statcounter is an independent Irish stats service which we have been using since the beginning of recorded time, sixteen years ago.

Please enable Strictly Necessary Cookies first so that we can save your preferences!