Hello! I've tried to update my site from 3.6.5 version to 3.7.0 (and even 3.8.2) but I get errors (you may find them below) on the Database. Clicking 'fix' won't help, as another error occurs ('1709 Index column size too large. The maximum column size is 767 bytes.').
The errors of the Database are:
Database schema version (3.6.3-2016-08-16) does not match CMS version (3.7.0-2017-04-19).
Table 'd7ybc_ucm_content' does not have column 'core_title' with type varchar(400). (From file 3.7.0-2017-01-08.sql.)
Table 'd7ybc_ucm_content' does not have column 'core_alias' with type varchar(400). (From file 3.7.0-2017-01-08.sql.)
Table 'd7ybc_contact_details' does not have column 'alias' with type varchar(400). (From file 3.7.0-2017-02-17.sql.)
Table 'd7ybc_contact_details' does not have column 'language' with type varchar(7). (From file 3.7.0-2017-02-17.sql.)
Table 'd7ybc_languages' does not have column 'asset_id' with type int(10) unsigned. (From file 3.7.0-2017-03-03.sql.)
Table 'd7ybc_menu_types' does not have column 'asset_id' with type int(10) unsigned. (From file 3.7.0-2017-03-03.sql.)
Table 'd7ybc_finder_links' does not have column 'description' with type text;. (From file 3.7.0-2017-03-19.sql.)
Could you please help me out, as I need to proceed?
Thank you in advance,
Nadia
AS Templates
POSTED: 2017-12-05
Hello NADIA88,
What is your MySQL server version, please be sure you have at least 5.7.
Please check the following pasts, hope they will help you:
https://forum.joomla.org/viewtopic.php?t=913699
https://stackoverflow.com/questions/42043205/how-to-fix-mysql-index-column-size-too-large-laravel-migrate
Get an access to all 94 items designed and developed by AS Designing team plus all the future items
which will be released over the course of your club subscription.
Price starting from $59.00
The errors of the Database are:
Database schema version (3.6.3-2016-08-16) does not match CMS version (3.7.0-2017-04-19).
Table 'd7ybc_ucm_content' does not have column 'core_title' with type varchar(400). (From file 3.7.0-2017-01-08.sql.)
Table 'd7ybc_ucm_content' does not have column 'core_alias' with type varchar(400). (From file 3.7.0-2017-01-08.sql.)
Table 'd7ybc_contact_details' does not have column 'alias' with type varchar(400). (From file 3.7.0-2017-02-17.sql.)
Table 'd7ybc_contact_details' does not have column 'language' with type varchar(7). (From file 3.7.0-2017-02-17.sql.)
Table 'd7ybc_languages' does not have column 'asset_id' with type int(10) unsigned. (From file 3.7.0-2017-03-03.sql.)
Table 'd7ybc_menu_types' does not have column 'asset_id' with type int(10) unsigned. (From file 3.7.0-2017-03-03.sql.)
Table 'd7ybc_finder_links' does not have column 'description' with type text;. (From file 3.7.0-2017-03-19.sql.)
Could you please help me out, as I need to proceed?
Thank you in advance,
Nadia
What is your MySQL server version, please be sure you have at least 5.7.
Please check the following pasts, hope they will help you:
https://forum.joomla.org/viewtopic.php?t=913699
https://stackoverflow.com/questions/42043205/how-to-fix-mysql-index-column-size-too-large-laravel-migrate
Regards, AS Team.