NoGi Posted March 14, 2015 Share Posted March 14, 2015 So, how many here are using utf8mb4 collation instead of just utf8? I've been running into a number of issues now with the upgrade where queries are hitting the character limit when varchar(255) is being used as opposed to varchar(191) Link to comment Share on other sites More sharing options...
Ahmad E. Posted March 14, 2015 Share Posted March 14, 2015 Using it on my 3.4.7 install and my 4 testsite. No issues yet.Using it on my 3.4.7 since a few months. Link to comment Share on other sites More sharing options...
NoGi Posted March 14, 2015 Author Share Posted March 14, 2015 Yeah I am not seeing any issue on 3.4.7, just on the upgrade process to 4. Have you checked to see if all your tables are utfmb4 and not a mixture of utf8 and utfmb4? Link to comment Share on other sites More sharing options...
Ahmad E. Posted March 14, 2015 Share Posted March 14, 2015 They all are utfmb4, not a mix. I did a test upgrade to rc4, it worked fine. Didn't test with rc5 yet and probably won't. Link to comment Share on other sites More sharing options...
steve00 Posted March 14, 2015 Share Posted March 14, 2015 So, how many here are using utf8mb4 collation instead of just utf8? I've been running into a number of issues now with the upgrade where queries are hitting the character limit when varchar(255) is being used as opposed to varchar(191)When upgrading 3.4.7 forum to v4 had to convert database to utf8 (as you have to), I had to use utf8mb4 and not utf8 as when tried utf8 it always 'crashed' ... tried about 4 times then tried the utf8mb4 and all went ok with no problems (shame the convertor didn't only offer utf8mb4 as upgrading stated has to be upgraded to utf8 ... no mention at all to use utf8mb4) Link to comment Share on other sites More sharing options...
NoGi Posted March 17, 2015 Author Share Posted March 17, 2015 I don't know what's going on with mine. Since making them all UTF8MB4, I get this error when trying to upgrade:[pid 8304] [client 11.222.33.444:64481] PHP Fatal error: Uncaught exception 'RuntimeException' with message 'COULD_NOT_WRITE_FILE' in /var/www/html/forum/system/Log/Disk.php:225\nStack trace:\n#0 /var/www/html/forum/system/Db/Exception.php(109): IPS\\Log\\_Disk->write('Table 'shrimpke...', 'sql')\n#1 /var/www/html/forum/system/Db/Db.php(363): IPS\\Db\\_Exception->__construct('Table 'shrimpke...', 1146, NULL, 'REPLACE INTO `c...', Array)\n#2 /var/www/html/forum/system/Db/Db.php(621): IPS\\_Db->preparedQuery('REPLACE INTO `c...', Array)\n#3 /var/www/html/forum/system/Session/Front.php(254): IPS\\_Db->replace('core_sessions', Array, true)\n#4 [internal function]: IPS\\Session\\_Front->write('jp94tb6ff2hl9ju...', '')\n#5 {main}\n thrown in /var/www/html/forum/system/Log/Disk.php on line 225 [Sat Mar 14 23:35:01.846889 2015] [:error] [pid 30029] [client 11.222.33.444:57922] PHP Fatal error: Uncaught exception 'RuntimeException' with message 'COULD_NOT_WRITE_FILE' in /var/www/html/forum/system/Log/Disk.php:225\nStack trace:\n#0 /var/www/html/forum/system/Db/Exception.php(109): IPS\\Log\\_Disk->write('Table 'shrimpke...', 'sql')\n#1 /var/www/html/forum/system/Db/Db.php(363): IPS\\Db\\_Exception->__construct('Table 'shrimpke...', 1146, NULL, 'REPLACE INTO `c...', Array)\n#2 /var/www/html/forum/system/Db/Db.php(621): IPS\\_Db->preparedQuery('REPLACE INTO `c...', Array)\n#3 /var/www/html/forum/system/Session/Front.php(254): IPS\\_Db->replace('core_sessions', Array, true)\n#4 [internal function]: IPS\\Session\\_Front->write('t7hvva2l4dur6g4...', '')\n#5 {main}\n thrown in /var/www/html/forum/system/Log/Disk.php on line 225 [Sat Mar 14 23:35:58.275431 2015] [:error] [pid 22393] [client 11.222.33.444:34160] PHP Fatal error: Uncaught exception 'IPS\\Db\\Exception' with message 'Table 'forum_ipb.core_sessions' doesn't exist' in /var/www/html/forum/system/Db/Db.php:363\nStack trace:\n#0 /var/www/html/forum/system/Db/Db.php(621): IPS\\_Db->preparedQuery('REPLACE INTO `c...', Array)\n#1 /var/www/html/forum/system/Session/Front.php(254): IPS\\_Db->replace('core_sessions', Array, true)\n#2 [internal function]: IPS\\Session\\_Front->write('sn51cquocn2371l...', '')\n#3 {main}\n thrown in /var/www/html/forum/system/Db/Db.php on line 363 [Sat Mar 14 23:36:02.136498 2015] [:error] [pid 22391] [client 11.222.33.444:46626] PHP Fatal error: Uncaught exception 'IPS\\Db\\Exception' with message 'Table 'forum_ipb.core_sessions' doesn't exist' in /var/www/html/forum/system/Db/Db.php:363\nStack trace:\n#0 /var/www/html/forum/system/Db/Db.php(621): IPS\\_Db->preparedQuery('REPLACE INTO `c...', Array)\n#1 /var/www/html/forum/system/Session/Front.php(254): IPS\\_Db->replace('core_sessions', Array, true)\n#2 [internal function]: IPS\\Session\\_Front->write('fcr6kka21u495hi...', '')\n#3 {main}\n thrown in /var/www/html/forum/system/Db/Db.php on line 363 [Sat Mar 14 23:36:08.697083 2015] [:error] [pid 30360] [client 11.222.33.444:45280] PHP Fatal error: Uncaught exception 'IPS\\Db\\Exception' with message 'Table 'forum_ipb.core_sessions' doesn't exist' in /var/www/html/forum/system/Db/Db.php:363\nStack trace:\n#0 /var/www/html/forum/system/Db/Db.php(621): IPS\\_Db->preparedQuery('REPLACE INTO `c...', Array)\n#1 /var/www/html/forum/system/Session/Front.php(254): IPS\\_Db->replace('core_sessions', Array, true)\n#2 [internal function]: IPS\\Session\\_Front->write('mded85ac67g1b33...', '')\n#3 {main}\n thrown in /var/www/html/forum/system/Db/Db.php on line 363 [Sat Mar 14 23:36:23.595359 2015] [:error] [pid 30353] [client 11.222.33.444:57714] PHP Fatal error: Uncaught exception 'IPS\\Db\\Exception' with message 'Unknown column 'lang_order' in 'order clause'' in /var/www/html/forum/system/Db/Db.php:363\nStack trace:\n#0 /var/www/html/forum/system/Db/Select.php(321): IPS\\_Db->preparedQuery('SELECT * FROM `...', Array)\n#1 /var/www/html/forum/system/Db/Select.php(219): IPS\\Db\\_Select->runQuery()\n#2 /var/www/html/forum/system/Lang/Lang.php(103): IPS\\Db\\_Select->setKeyField('lang_id')\n#3 /var/www/html/forum/system/Member/Member.php(1442): IPS\\_Lang::languages()\n#4 /var/www/html/forum/system/Member/Member.php(403): IPS\\_Member->language()\n#5 [internal function]: IPS\\_Member->get_name()\n#6 /var/www/html/forum/system/Patterns/ActiveRecord.php(273): call_user_func(Array)\n#7 /var/www/html/forum/system/Session/Admin.php(107): IPS\\Patterns\\_ActiveRecord->__get('name')\n#8 [internal function]: IPS\\Session\\_Admin->write('23bvhnkvu1sdcou...', '')\n#9 [internal function]: session_write_close()\n#10 {main}\n thrown in /var/www/html/forum/system/Db/Db.php on line 363 [Sat Mar 14 23:37:23.310977 2015] [:error] [pid 30029] [client 11.222.33.444:33141] PHP Fatal error: Uncaught exception 'IPS\\Db\\Exception' with message 'Unknown column 'lang_order' in 'order clause'' in /var/www/html/forum/system/Db/Db.php:363\nStack trace:\n#0 /var/www/html/forum/system/Db/Select.php(321): IPS\\_Db->preparedQuery('SELECT * FROM `...', Array)\n#1 /var/www/html/forum/system/Db/Select.php(219): IPS\\Db\\_Select->runQuery()\n#2 /var/www/html/forum/system/Lang/Lang.php(103): IPS\\Db\\_Select->setKeyField('lang_id')\n#3 /var/www/html/forum/system/Member/Member.php(1442): IPS\\_Lang::languages()\n#4 /var/www/html/forum/system/Member/Member.php(403): IPS\\_Member->language()\n#5 [internal function]: IPS\\_Member->get_name()\n#6 /var/www/html/forum/system/Patterns/ActiveRecord.php(273): call_user_func(Array)\n#7 /var/www/html/forum/system/Session/Front.php(244): IPS\\Patterns\\_ActiveRecord->__get('name')\n#8 [internal function]: IPS\\Session\\_Front->write('s97ktn96s8oc0q2...', '')\n#9 [internal function]: session_write_close()\n#10 {main}\n thrown in /var/www/html/forum/system/Db/Db.php on line 363 [Sat Mar 14 23:38:21.968487 2015] [:error] [pid 30598] [client 11.222.33.444:33446] PHP Fatal error: Uncaught exception 'IPS\\Db\\Exception' with message 'Unknown column 'lang_order' in 'order clause'' in /var/www/html/forum/system/Db/Db.php:363\nStack trace:\n#0 /var/www/html/forum/system/Db/Select.php(321): IPS\\_Db->preparedQuery('SELECT * FROM `...', Array)\n#1 /var/www/html/forum/system/Db/Select.php(219): IPS\\Db\\_Select->runQuery()\n#2 /var/www/html/forum/system/Lang/Lang.php(103): IPS\\Db\\_Select->setKeyField('lang_id')\n#3 /var/www/html/forum/system/Member/Member.php(1442): IPS\\_Lang::languages()\n#4 /var/www/html/forum/system/Member/Member.php(403): IPS\\_Member->language()\n#5 [internal function]: IPS\\_Member->get_name()\n#6 /var/www/html/forum/system/Patterns/ActiveRecord.php(273): call_user_func(Array)\n#7 /var/www/html/forum/system/Session/Front.php(244): IPS\\Patterns\\_ActiveRecord->__get('name')\n#8 [internal function]: IPS\\Session\\_Front->write('4q9iidd6lsb0r9r...', '')\n#9 [internal function]: session_write_close()\n#10 {main}\n thrown in /var/www/html/forum/system/Db/Db.php on line 363 [Sat Mar 14 23:38:48.342329 2015] [:error] [pid 22784] [client 11.222.33.444:60051] PHP Fatal error: Uncaught exception 'IPS\\Db\\Exception' with message 'Unknown column 'lang_order' in 'order clause'' in /var/www/html/forum/system/Db/Db.php:363\nStack trace:\n#0 /var/www/html/forum/system/Db/Select.php(321): IPS\\_Db->preparedQuery('SELECT * FROM `...', Array)\n#1 /var/www/html/forum/system/Db/Select.php(219): IPS\\Db\\_Select->runQuery()\n#2 /var/www/html/forum/system/Lang/Lang.php(103): IPS\\Db\\_Select->setKeyField('lang_id')\n#3 /var/www/html/forum/system/Member/Member.php(1442): IPS\\_Lang::languages()\n#4 /var/www/html/forum/system/Member/Member.php(403): IPS\\_Member->language()\n#5 [internal function]: IPS\\_Member->get_name()\n#6 /var/www/html/forum/system/Patterns/ActiveRecord.php(273): call_user_func(Array)\n#7 /var/www/html/forum/system/Session/Front.php(244): IPS\\Patterns\\_ActiveRecord->__get('name')\n#8 [internal function]: IPS\\Session\\_Front->write('2vvof2s1ju4bfpj...', '')\n#9 [internal function]: session_write_close()\n#10 {main}\n thrown in /var/www/html/forum/system/Db/Db.php on line 363 I can confirm that the database is not corrupt and works fine under 3.4.7, just can't upgrade to RC5 now. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.