Hello @asmecher
So I ran this query for all 13 bad records.
SELECT a.article_id, a.journal_id, s.section_id, j.path
FROM articles a
INNER JOIN sections s on (a.journal_id = s.journal_id)
INNER JOIN journals j on (s.journal_id = j.journal_id)
WHERE a.article_id = 30380 OR a.article_id = 31796 OR a.article_id = 31831 OR a.article_id = 58835 OR a.article_id = 58848 OR a.article_id = 58864 OR a.article_id = 58882
OR a.article_id = 58883 OR a.article_id = 58887 OR a.article_id = 58900 OR a.article_id = 58903 OR a.article_id = 58998 OR a.article_id = 59004
and manually edit field section_id of each record of articles table using the very first section_id (multiple section_id but same path/slug returned for a given journal as mentioned above) so that I can continue with upgrade process OJS 2.4.8-3 to OJS 3.1.1-4. The upgrade process successfully passed this error but now it ran into another error below:
-----
(mysql): UPDATE review_assignments SET quality = NULL WHERE quality = 0
-----
-----
(mysql): UPDATE users u, (SELECT user_id, GROUP_CONCAT(DISTINCT setting_value SEPARATOR ’ ') AS groupedGossips FROM user_settings WHERE setting_name = ‘gossip’ AND setting_value <> ‘’ GR OUP BY user_id) us SET u.gossip = us.groupedGossips WHERE us.user_id = u.user_id
-----
1260: Row 8 was cut by GROUP_CONCAT()
ADOConnection._Execute(UPDATE users u , (SELECT user_id, GROUP_CONCAT(DISTINCT setting_value SEPARATOR ’ ') AS groupedGossips FROM user_settings WHERE s…, false)% line 1051, file: /var/www/html/ojs-3.1.1-4/lib/pkp/lib/adod b/adodb.inc.php
ADOConnection.Execute(UPDATE users u, (SELECT user_id, GROUP_CONCAT(DISTINCT setting_value SEPARATOR ’ ') AS groupedGossips FROM user_sett ings WHERE s…)% line 446, file: /var/www/html/ojs-3.1.1-4/lib/pkp/classes/install/Installe r.inc.php
Installer.executeSQL(UPDATE users u, (SELECT user_id, GROUP_CONCAT(DISTINCT setting_value SEPARATOR ’ ') AS groupedGossips FROM user_settings WHER E s…)% line 441, file: /var/www/html/ojs-3.1.1-4/lib/pkp/classes/install/Installer.inc.php
Installer.executeSQL(Array[19])% line 399, file: /var/www/ht ml/ojs-3.1.1-4/lib/pkp/classes/install/Installer.inc.php
Installer.executeAction(Array[3])% line 265, file: /var/www/html/ojs -3.1.1-4/lib/pkp/classes/install/Installer.inc.php
ERROR: Upgrade failed: DB: Row 8 was cut by GROUP_CONCAT()
for this error I think I will have to modify query in 3.1.1_update.xml file to set group concat max length to longer such as
SET GLOBAL group_concat_max_len=4294967295;
but not so sure where to put the line?
Some help, tips, or pointers that could help me would be much appreciated.
Dung.