Can’t create new video after last update

Hello Gomez,

1. I found that the editing did not work with Gutenberg after a recent fix to Mailchimp preview mode.

Please upgrade to FV Player 7.5.26.7210 which was released now and your issue should be fixed.

If that won’t fix the issue for you – do you mean that when you add a new player, you can see the [fvplayer id="..."] shortcode in your post and it appears in wp-admin -> FV Player, but nothing shows on the page? Then please provide a link to a test page which is affected by this.

2. About the player editing issue – please open your browser developer console, here’s how: https://kb.mailster.co/how-can-i-open-the-browsers-console/

Then open your page with FV Player on it and try to edit it. You should see messages appearing on the console, similar to this;

FV Player Editor: Loading...
FV Player Editor: Attaching click actions...
FV Player Editor: Loading for TinyMCE in Text Mode...
FV Player Editor: Loading shortcode: fvplayer id="547"
FV Player Editor: Loading shortcode player id: 547
FV Player Editor: Running fv_player_db_load Ajax.
FV Player Editor: Finished fv_player_db_load Ajax.
{id: '547', author: '50', changed_by: '50', date_created: '2022-05-25 14:16:16', date_modified: '2022-05-25 14:16:16', …}
FV Player Editor: current_video_db_id: 667
fv-player-editor-video-opened 0
FV Player Editor: Video meta 'timeline_previews_job_id' not found for #667
FV Player Editor: Video meta 'timeline_previews_job_status' not found for #667
FV Player: Chromecast listener unavailable
FV Player Editor: No changes to save.

Please send it over so that we can see what leads to the error.

Thanks,
Martin

Hello Gomez,

1. It’s strange if you are not seeing the new videos which you added at all.

FV Player 7.5.25 did add the splash_attachment_id field to the videos table. Perhaps the upgrade routine failed for you, although we ensure the database is updated anytime you open FV Player Editor.

Please send over wp-admin -> Settings -> FV Player -> Tools -> System Info, so that we can check if it’s there.

You can also run this SQL query if you know how to access phpMyAdmin for your website database:

ALTER TABLE wp_fv_player_videos ADD COLUMN splash_attachment_id bigint(20) unsigned

That might fix the issue. It will not fix the broken FV Player instances, but you should be able to insert new ones.

If not, we need to check the PHP errors.

Ultimately we need to figure out why did the database upgrade process fail and provide a way of retrying it.

2. I was able to reproduce this issue when I damaged the database on purpose.

Thanks,
Martin

Hello Gomez,

I’m mystified why the database upgrade fails to execute the query:

ALTER TABLE wp_fv_player_videos ADD COLUMN splash_attachment_id bigint(20) unsigned

Please access your web host database management tool and try to run the query there. Perhaps it will show the error which is preventing the database upgrade process from finishing. Alternatively you can use the WP phpMyAdmin plugin, but I would recommend you to remove it once you are done.

Thanks,
Martin

Hello Gomez,

please reinstall FV Player from this link: https://github.com/foliovision/fv-wordpress-flowplayer/archive/master.zip

To do that you will have to first deactivate and delete the current FV Player 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.

Then it should finally work.

It’s weird that you were able to even install FV Player if your database server limits the table row size to just 8126 bytes. So something has changed on your database server it seems and now any change to the table was no longer permitted. So I set these table fields to be smaller where possible.

Thanks,
Martin

Hello Gomez,

only FV Player Pro needs to be uninstalled.

Thanks,
Martin