SQL error updating to v6.1.0

  • Resolved bluerobot

    (@bluerobot)


    3 years ago

    What’s the best way to update the keys?

    Modern Events Calendar Lite
    You have version 5.22.3 installed. Update to 6.1.0

    WordPress database error Specified key was too long; max key length is 1000 bytes for query ALTER TABLE wp_mec_bookings ADD KEY event_id (event_id,ticket_ids,status,confirmed,verified,date);

    If I run it in PHPMyAdmin I get…

    MySQL said:
    #1071 – Specified key was too long; max key length is 1000 bytes

    My wp_mec_bookings table collation is utf8mb4_unicode_520_ci, could that be the issue?

Viewing 1 replies (of 1 total)
  • Plugin Contributor webnus

    (@webnus)

    Hello @bluerobot,

    We examined your topic. The issue is probably related to Database settings because we don’t have the problem on our end. Please change the encoding of the database tables of your website to utf8_general_ci and test again. If it didn’t run again, you can ignore this because in practice it doesn’t have an effect on the functionality of the system and the system will work even without it.

    Best Regards

Viewing 1 replies (of 1 total)
  • The topic ‘SQL error updating to v6.1.0’ is closed to new replies.