Database fix error ("1709 Index column size too large") after upgrading from 3.6.5 to 3.8.2

Need help upgrading your Joomla! website or converting to Joomla! 3.x?

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Post Reply
mare88
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Fri Jun 28, 2013 12:12 pm

Database fix error ("1709 Index column size too large") after upgrading from 3.6.5 to 3.8.2

Post by mare88 » Mon Dec 04, 2017 3:05 pm

Hello all,

I tried to upgrade my site from 3.6.5 to 3.8.2. The Database though seem to have multiple issues (you may find them below). When I click on 'fix', this message appears: "1709 Index column size too large. The maximum column size is 767 bytes."

These are the database issues:
'Warning: Database is not up to date'

Database schema version (3.6.3-2016-08-16) does not match CMS version (3.8.2-2017-10-14).
Table 'sgeorge_ucm_content' does not have column 'core_title' with type varchar(400). (From file 3.7.0-2017-01-08.sql.)
Table 'sgeorge_ucm_content' does not have column 'core_alias' with type varchar(400). (From file 3.7.0-2017-01-08.sql.)
Table 'sgeorge_contact_details' does not have column 'alias' with type varchar(400). (From file 3.7.0-2017-02-17.sql.)
Table 'sgeorge_contact_details' does not have column 'language' with type varchar(7). (From file 3.7.0-2017-02-17.sql.)
Table 'sgeorge_languages' does not have column 'asset_id' with type int(10) unsigned. (From file 3.7.0-2017-03-03.sql.)
Table 'sgeorge_menu_types' does not have column 'asset_id' with type int(10) unsigned. (From file 3.7.0-2017-03-03.sql.)
Table 'sgeorge_finder_links' does not have column 'description' with type text;. (From file 3.7.0-2017-03-19.sql.)
Table 'sgeorge_menu' does not have column 'checked_out_time' with type datetime. (From file 3.7.3-2017-06-03.sql.)
Table 'sgeorge_fields_groups' does not have column 'params'. (From file 3.8.0-2017-07-28.sql.)
Table 'sgeorge_content' does not have index 'idx_alias'. (From file 3.8.2-2017-10-14.sql.)

Sadly I haven't managed to find any solutions by searching the forum. Have no idea how to proceed frow on. Could you please help me?

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 19494
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: Database fix error ("1709 Index column size too large") after upgrading from 3.6.5 to 3.8.2

Post by leolam » Tue Dec 05, 2017 4:22 am

First try to go to phpMyAdmin and run the 'repair database" and see if that resolves so you can run the fix. If that does not resolve you will need to roll back to your backup of 3.6.5 and fix on that version the database first before redoing the upgrade

Leo 8)
Joomla's #1 Professional Support Provider:
-> Joomla Professional Support: https://gws-desk.com -
-> Joomla Specialized Hosting Solutions: https://gws-host.com -
-> Joomla Webmaster Services: gws-webmaster.services


Post Reply

Return to “Migrating and Upgrading to Joomla! 3.x”