Embedded Vimeo-URL lost after update from 2.7.12 to 3.2.4

@paulhogan,

Sorry this wasn’t flawless it sounds…

Video (and audio) embed metakeys changed in 3.x so in the 3.0.0 upgrade routine they are rewritten.

From 2.x -> 3.2.4 there are two different upgrade routines that run and with 711 the first one will take a while.

You can see the info on the upgrades at https://lifterlms.com/docs/lifterlms-database-updates/

Are you certain both updates have completed? Check your database version under your LifterLMS System Report and let me know the version of the DB

Additionally, if something failed during the upgrade the data is all still in the database and you could run the update query manually via phpMyAdmin, this would be the query for the video updates:

For lessons:

UPDATE wp_postmeta AS m
INNER JOIN wp_posts AS p ON p.ID = m.post_ID
SET m.meta_key = '_llms_video_embed'
WHERE p.post_type = 'lesson' AND m.meta_key = '_video_embed';

For courses:

UPDATE wp_postmeta AS m
INNER JOIN wp_posts AS p ON p.ID = m.post_ID
SET m.meta_key = '_llms_video_embed'
WHERE p.post_type = 'course' AND m.meta_key = '_video_embed';

If you have a custom table prefix replace the table names in the queries with the correct prefix for your database.

Hope that helps,

Hi Thomas,

thanks for your quick answer. The LifterLMS System Report says my Mysql Version is 5.6.19. I try to execute your SQL commands via phpMyAdmin but I received only error messages like “#1064 – 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 ” at line 1″.

I’m not a MySQL expert. It is quite possible that I did something wrong. Do you still have an idea to retrieve the data? Otherwise I have to reenter all 711 Vimeo URLs. ??

Kind regards,

Hey @ paulhogan,

I’m really sorry but I have no other solutions other than the database queries.

I think you problably copied the empty line from my query above, I’m not sure why it added a return at the beginng of the line, please try without the empty line.

Thanks,

Hi Thomas,

I tried it so and it works better without the embedded “'”

But now I have another error message:

————–
SQL-Befehl:

UPDATE lms_10_postmeta AS m INNER JOIN lms_10_posts AS p ON p.ID = m.post_ID SET m.meta_key = _llms_video_embed WHERE p.post_type = lesson AND m.meta_key = _video_embed

MySQL meldet: Dokumentation
#1054 – Unknown column ‘lesson’ in ‘where clause’
————–

I try it with the German word “lektion” but I received the same error message. What do I wrong?

Kind regards,

Try this:

UPDATE lms_10_postmeta AS m INNER JOIN lms_10_posts AS p ON p.ID = m.post_ID SET m.meta_key = "_llms_video_embed" WHERE p.post_type = "lesson" AND m.meta_key = "_video_embed";

Database keys/values are not translated, the issue is that the quotes were removed, usually single quotes work but maybe you need to use double quotes.

Take care,

• This reply was modified 7 years, 10 months ago by Thomas Patrick Levy. Reason: trailing semicolon