Database errors when upgrading from Tiki 12.9 to Tiki 15.5
- Status
- Closed
- Subject
- Database errors when upgrading from Tiki 12.9 to Tiki 15.5
- Version
- 12.x
15.x - Category
- Error
- Resolution status
- New
- Submitted by
- Fabio Montefuscolo
- Lastmod by
- Fabio Montefuscolo
- Rating
- Description
I'm trying to upgrade a Tiki 12.9 site to Tiki 15.5 site. Composer runs fine, but when updating database I got several erros after run this command:
Copy to clipboardphp console.php database:updateError
php console.php database:updateCopy to clipboardError 0 in 20151203_tiki_score_revamp_tiki #Add needed columns ALTER TABLE tiki_score change event event varchar(255); #increase varchar length ALTER TABLE tiki_score ADD COLUMN data TEXT You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ALTER TABLE tiki_score ADD COLUMN data TEXT' at line 3 Error 1 in 20151203_tiki_score_revamp_tiki # Insert old values from tiki_score into new format # Insert user stuff. Login, message, friend pts. INSERT INTO tiki_score (event, data) SELECT "tiki.user.login" AS event, concat('[{"ruleId":"User logs in","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='login' Unknown column 'data' in 'field list' Error 2 in 20151203_tiki_score_revamp_tiki INSERT INTO tiki_score (event, data) SELECT "tiki.user.view" AS event, concat('[{"ruleId":"See other user''s profile","recipientType":"user","recipient":"user","score":"',max(case when event = 'profile_see' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your profile seen","recipientType":"user","recipient":"object","score":"',max(case when event = 'profile_is_seen' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1 Unknown column 'data' in 'field list' Error 3 in 20151203_tiki_score_revamp_tiki INSERT INTO tiki_score (event, data) SELECT "tiki.user.friend" AS event, concat('[{"ruleId":"Make friends","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='friend_new' Unknown column 'data' in 'field list' Error 4 in 20151203_tiki_score_revamp_tiki INSERT INTO tiki_score (event, data) SELECT "tiki.user.message" AS event, concat('[{"ruleId":"Send message","recipientType":"user","recipient":"user","score":"',max(case when event = 'message_send' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Receive message","recipientType":"user","recipient":"object","score":"',max(case when event = 'message_receive' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1 Unknown column 'data' in 'field list' Error 5 in 20151203_tiki_score_revamp_tiki # Articles INSERT INTO tiki_score (event, data) SELECT "tiki.article.create" AS event, concat('[{"ruleId":"Publish new article","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='article_new' Unknown column 'data' in 'field list' Error 6 in 20151203_tiki_score_revamp_tiki INSERT INTO tiki_score (event, data) SELECT "tiki.article.view" AS event, concat('[{"ruleId":"Read an article","recipientType":"user","recipient":"user","score":"',max(case when event = 'article_read' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your article read","recipientType":"user","recipient":"author","score":"',max(case when event = 'article_is_read' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1 Unknown column 'data' in 'field list' Error 7 in 20151203_tiki_score_revamp_tiki # File Gallery INSERT INTO tiki_score (event, data) SELECT "tiki.filegallery.create" AS event, concat('[{"ruleId":"Create new file gallery","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='fgallery_new' Unknown column 'data' in 'field list' Error 8 in 20151203_tiki_score_revamp_tiki INSERT INTO tiki_score (event, data) SELECT "tiki.file.create" AS event, concat('[{"ruleId":"Upload new file to gallery","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='fgallery_new_file' Unknown column 'data' in 'field list' Error 9 in 20151203_tiki_score_revamp_tiki INSERT INTO tiki_score (event, data) SELECT "tiki.file.download" AS event, concat('[{"ruleId":"Download other user''s file","recipientType":"user","recipient":"user","score":"',max(case when event = 'fgallery_download' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your file downloaded","recipientType":"user","recipient":"owner","score":"',max(case when event = 'fgallery_is_downloaded' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1 Unknown column 'data' in 'field list' Error 10 in 20151203_tiki_score_revamp_tiki # Image Gallery INSERT INTO tiki_score (event, data) SELECT "tiki.imagegallery.create" AS event, concat('[{"ruleId":"Create new image gallery","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='igallery_new' Unknown column 'data' in 'field list' Error 11 in 20151203_tiki_score_revamp_tiki INSERT INTO tiki_score (event, data) SELECT "tiki.image.create" AS event, concat('[{"ruleId":"Upload new image to gallery","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='igallery_new_img' Unknown column 'data' in 'field list' Error 12 in 20151203_tiki_score_revamp_tiki INSERT INTO tiki_score (event, data) SELECT "tiki.image.view" AS event, concat('[{"ruleId":"See other user''s image","recipientType":"user","recipient":"user","score":"',max(case when event = 'igallery_see_img' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your image seen","recipientType":"user","recipient":"owner","score":"',max(case when event = 'igallery_img_seen' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1 Unknown column 'data' in 'field list' Error 13 in 20151203_tiki_score_revamp_tiki #Blogs INSERT INTO tiki_score (event, data) SELECT "tiki.blog.create" AS event, concat('[{"ruleId":"Create new blog","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='blog_new' Unknown column 'data' in 'field list' Error 14 in 20151203_tiki_score_revamp_tiki INSERT INTO tiki_score (event, data) SELECT "tiki.blogpost.create" AS event, concat('[{"ruleId":"Post in a blog","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='blog_post' Unknown column 'data' in 'field list' Error 15 in 20151203_tiki_score_revamp_tiki INSERT INTO tiki_score (event, data) SELECT "tiki.blog.view" AS event, concat('[{"ruleId":"Read other user''s blog","recipientType":"user","recipient":"user","score":"',max(case when event = 'blog_read' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your blog read","recipientType":"user","recipient":"author","score":"',max(case when event = 'blog_is_read' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1 Unknown column 'data' in 'field list' Error 16 in 20151203_tiki_score_revamp_tiki # Wikis INSERT INTO tiki_score (event, data) SELECT "tiki.wiki.create" AS event, concat('[{"ruleId":"Create a wiki page","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='wiki_new' Unknown column 'data' in 'field list' Error 17 in 20151203_tiki_score_revamp_tiki INSERT INTO tiki_score (event, data) SELECT "tiki.wiki.update" AS event, concat('[{"ruleId":"Edit an existing wiki page","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='wiki_edit' Unknown column 'data' in 'field list' Error 18 in 20151203_tiki_score_revamp_tiki INSERT INTO tiki_score (event, data) SELECT "tiki.wiki.attachfile" AS event, concat('[{"ruleId":"Attach file to wiki page","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='wiki_attach_file' Unknown column 'data' in 'field list' Error 19 in 20151203_tiki_score_revamp_tiki #remove old scores from the tiki_score table DELETE FROM tiki_score WHERE data is null Unknown column 'data' in 'where clause'System details
1. MySQL versionCopy to clipboardroot@45af11331f6a:/# mysql --version mysql Ver 15.1 Distrib 10.2.10-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 root@45af11331f6a:/# mysqld --version mysqld Ver 10.2.10-MariaDB-10.2.10+maria~jessie for debian-linux-gnu on x86_64 (mariadb.org binary distribution)
2. PHP VersionCopy to clipboardroot@6575eef728ba:/var/www/html# php --version PHP 5.6.33 (cli) (built: Jan 9 2018 02:55:39) Copyright (c) 1997-2016 The PHP Group Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies with Xdebug v2.5.5, Copyright (c) 2002-2017, by Derick Rethans
3. PHP modulesCopy to clipboardroot@6575eef728ba:/var/www/html# php -m [PHP Modules] apcu calendar Core ctype curl date dom ereg fileinfo filter ftp gd hash iconv json libxml mbstring mcrypt memcached mysqli mysqlnd openssl pcre PDO pdo_sqlite Phar posix readline Reflection session SimpleXML SPL sqlite3 standard tokenizer xdebug xml xmlreader xmlwriter Zend OPcache zip zlib [Zend Modules] Xdebug Zend OPcache- Importance
- 3
- Priority
- 15
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 6544
- Created
- Saturday 20 January, 2018 22:05:41 UTC
by Fabio Montefuscolo - LastModif
- Wednesday 13 June, 2018 22:34:37 UTC