• 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

Database Error when encoding new coconut job

[Solved]

Foliovision › Forums › FV Player › Troubleshooting › Database Error when encoding new coconut job

  • Nathan 3 years, 6 months ago

    Hi,

    Every time I try to setup a new coconut encode job I get a database error pop up and noting get added to the job list. I have successfully created by Digital Ocean and Coconut account and apis and completed the wizard setup successfully. I can see my video in the digial ocean space and select it to setup the new job. But every time i hit encode it fails with the database error message.

    capture-13
    Capture
Viewing 7 replies - 1 through 7 (of 7 total)
  • Martin 3 years ago

    Hello Nathan,

    please, try reinstalling FV Player Coconut from a fresh ZIP from https://foliovision.com/my-licenses

    To do that you will have to first deactivate and delete the current FV Player Coconut plugin you are using. WordPress will warn you that you might loose settings and data, but it’s not the case with our plugin, no settings now videos will be lost. Or you can just replace the plugin files via FTP.

    Let us know, if it helped. I think there was a bug in the database table creation code.

    Thanks,
    Martin

    Nathan 3 years ago

    Unfortunately deleting a re-installing the plugin from a new zip didn’t make a difference.

    Martin 3 years ago

    Hello Nathan,

    something must be preventing the database table creation.

    Please check your PHP error logs. If you are not sure about how to check the PHP error log, the server technical support should be able to give you a hand.

    Or you can install this plugin which makes a list of these errors available in wp-admin: https://wordpress.org/plugins/error-log-monitor/

    Then just go to wp-admin -> FV Player -> Coconut jobs again and another error should be recorded in the logs.

    Thanks,
    Martin

    Nathan 3 years ago

    Looks like the jobs database table is missing and not getting created:

    WordPress database error Table 'sls_wordpress.wp_fv_player_encoding_jobs' doesn't exist for query SELECT * FROM wp_fv_player_encoding_jobs WHERE ( status = 'completed' OR status = 'processing' OR ( status = 'error' AND date_created >= DATE_SUB( NOW(), INTERVAL 12 HOUR ) ) ) AND target NOT LIKE '%-auto-trailer'  ORDER BY date_created DESC made by do_action('wp_ajax_load_coconut_jobs'), WP_Hook->do_action, WP_Hook->apply_filters, FV_Player_Coconut_Browser->load_assets, FV_Player_Coconut_Browser->get_formatted_assets_data, referer: ..../wp-admin/admin.php?page=fv_player
    Nathan 3 years ago

    I also found this for the error in the table creation:

    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'error varchar(1024),\n      mime varchar(64),\n      args TEXT,\n      result TEXT,' at line 12 for query CREATE TABLE wp_fv_player_encoding_jobs (\n      id bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n      id_video bigint(20) unsigned NOT NULL,\n      job_id bigint(20) unsigned NOT NULL,\n      date_created datetime NOT NULL,\n      date_checked datetime NOT NULL,\n      source varchar(1024) NOT NULL,\n      target varchar(1024) NOT NULL,\n      type varchar(64) NOT NULL,\n      status varchar(64) NOT NULL,\n      progress varchar(64)\n      error varchar(1024),\n      mime varchar(64),\n      args TEXT,\n      result TEXT,\n      output TEXT,\n      video_data TEXT,\n      author bigint(20) unsigned NOT NULL default '0',\n      PRIMARY KEY  (id),\n      KEY source (source(191)),\n      KEY type (type),\n      KEY status (status)\n    )DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by do_action('fv-player_page_fv_player_coconut'), WP_Hook->do_action, WP_Hook->apply_filters, FV_Player_Coconut->tools_panel, FV_Player_Coconut->tools_panel_jobs, FV_Player_Coconut->plugin_update_database, dbDelta, referer:
    Nathan 3 years ago

    I found the issue in your plugin php, the line:

    error varchar(1024)

    is missing a “,” at th end of the line

    Martin 3 years ago

    Hello Nathan,

    thank you for sending over the fix!

    I guess most MySQL servers do not mind this mistake, but in your case it did cause the issue.

    Please reinstall FV Player Coconut from a fresh ZIP from https://foliovision.com/my-licenses again. Then it will work.

    Thanks,
    Martin

Viewing 7 replies - 1 through 7 (of 7 total)
Reply To: Database Error when encoding new coconut job



Please Sign in or Register to upload files.

Related Posts

  1. How to finish or restart Coconut wizard, stopped before BunnyCDN setup

    How to finish or restart Coconut wizard, stopped before BunnyCDN setup

  2. Coconut Encoding without DigitalOcean

    Coconut Encoding without DigitalOcean

  3. Coconut Jobs – error “api_version_not_valid”

    Coconut Jobs – error “api_version_not_valid”

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!