Upgrade 3.4.8 to 3.7.2 - Warning JInstaller: :Install: Error SQL Index column size too large - Joomla! Forum - community, help and support

-

hi
running
php - 5.6.30
mariadb - 10.1.24
db server connection collation - utf8mb4_unicode_ci - think causing problem

i upgraded joomla 3.4.8 3.7.2 , got following error:
warning
jinstaller: :install: error sql index column size large. maximum column size 767 bytes.
files update: sql error file db function failed error number 1709
index column size large. maximum column size 767 bytes.
sql =
alter table `#__ucm_content` modify `core_title` varchar(400) not null default '';

yet "joomla version update status" was
your site has been updated. joomla version 3.7.2.

the table column "core_title" in question set varchar(255), tried changing manually phpmyadmin, mysql not allow changed varchar(4oo), received same error warning

the database set collation utf8mb4_unicode_ci, don't know why

i think there innodb storage limitation when using db collation - utf8mb4_unicode_ci, or @ least according google researches

can change collation utf8_general_ci or cause more problems

is real problem needs fixing or can carry on "core_title" set varchar(255)

am right believe cause problem if try install component name on 255 characters

someone posted error in dutch language forum, https://forum.joomla.org/viewtopic.php?t=949765, wasn't answered, if can help, please point other post answer well

best regards

ashley in spain

try upgrade 3.5.1 first.





Comments

Post a Comment

Popular posts from this blog

Falang and too many redirects - Joomla! Forum - community, help and support

-
hello i don't know if i'm posting in right place , i'm apologise have searched solution long time , couldn't find . my problem starts when have install component falang (translation component ). after time decided uninstall , problem starts. go extension tab meny in left column press manage button, list on right found falang component , delete it, when did website not accessible did stupidest thing install falang package file 1 more time , here problem, when trying open website message showing: "website redirected many times. try clearing cookies. err_too_many_redirects" i have cleared cookies didn't help. have used tool "header checker tool" , result "301 moved permanently " please because don't know do. thank you setka Board index Joomla! 3.x - Ask Support Questions Here Extensions for Joomla! 3.x
Read more

Infinite loop detected in JErrorInfinite loop detected in JError - Joomla! Forum - community, help and support

-
after migrating site new server see error below infinite loop detected in jerrorinfinite loop detected in jerror please can me it means there mis-configuration configuration.php file. can refer post - viewtopic.php?t=830509 https://docs.joomla.org/infinite_loop_d ... joomla_1.7 Board index Joomla! 3.x - Ask Support Questions Here General Questions/New to Joomla! 3.x
Read more

logged out from joomla! - Joomla! Forum - community, help and support

-
Image
good morning you! since joomla! version still running on 3.7.5, trying update current version 23.8.1. tried, got white page due incompatibility 1 of extension (page builder pro). decided first upgrade extension, , trying again. tried update, received error message of dublicated tables. went phpmyadmin , deleted these tables manually. same error appeared again, when tried update part. extension. in order rid of extension, tried remove extension via extension manager. hit "remove" button, got logged out. while trying log admin, got message: you not have access administrator section of site. . yes, changed _user table in phpmyadmin, , checked configuration.php, i'm still not able lock admin. however, checked , browsed internet solution, couldn't find hint, excepted, had similar issue , asked post output of "forum assistant". have no idea if narrow problem, @ least gotta try! of appreciated! thank in advance! part i: forum post assistant (v1.3.5) : 2nd november ...
Read more