I upgraded a Tiki21.5 from the release package to a 21.8.
Database upgrade failed with the following errors:
Update completed.
Failed: 20120423_add_page_refs_tiki
Failed: 20151203_tiki_score_revamp_tiki
Queries executed successfully: 14
Error in 20120423_add_page_refs_tiki
ALTER TABLE tiki_page_references ADD UNIQUE INDEX uk1_tiki_page_ref_biblio_code (page_id, biblio_code)
Duplicate key name 'uk1_tiki_page_ref_biblio_code'
Error in 20120423_add_page_refs_tiki
ALTER TABLE tiki_page_references ADD INDEX idx_tiki_page_ref_title (title)
Duplicate key name 'idx_tiki_page_ref_title'
Error in 20120423_add_page_refs_tiki
ALTER TABLE tiki_page_references ADD INDEX idx_tiki_page_ref_author (author)
Duplicate key name 'idx_tiki_page_ref_author'
Error in 20151203_tiki_score_revamp_tiki
ALTER TABLE tiki_score ADD COLUMN reversalEvent varchar(255)
Duplicate column name 'reversalEvent'
Error in 20151203_tiki_score_revamp_tiki
# Insert old values from tiki_score into new format
INSERT INTO tiki_score (event, data)
SELECT "tiki.user.login" AS event, concat('[{"ruleId":"User logs in","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":%22%22,"expiration":""}]') AS data FROM tiki_score WHERE event='login'
Unknown column 'score' in 'field list'
Error 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":%22%22,"expiration":""},{"ruleId":"Have your profile seen","recipientType":"user","recipient":"object","score":"',max(case when event = 'profile_is_seen' then score else 0 end),'","validObjectIds":%22%22,"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error 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":%22%22,"expiration":""}]') AS data FROM tiki_score WHERE event='friend_new'
Unknown column 'score' in 'field list'
Error 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":%22%22,"expiration":""},{"ruleId":"Receive message","recipientType":"user","recipient":"object","score":"',max(case when event = 'message_receive' then score else 0 end),'","validObjectIds":%22%22,"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error 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":%22%22,"expiration":""}]') AS data FROM tiki_score WHERE event='article_new'
Unknown column 'score' in 'field list'
Error 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":%22%22,"expiration":""},{"ruleId":"Have your article read","recipientType":"user","recipient":"author","score":"',max(case when event = 'article_is_read' then score else 0 end),'","validObjectIds":%22%22,"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error 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":%22%22,"expiration":""}]') AS data FROM tiki_score WHERE event='fgallery_new'
Unknown column 'score' in 'field list'
Error 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":%22%22,"expiration":""}]') AS data FROM tiki_score WHERE event='fgallery_new_file'
Unknown column 'score' in 'field list'
Error 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":%22%22,"expiration":""},{"ruleId":"Have your file downloaded","recipientType":"user","recipient":"owner","score":"',max(case when event = 'fgallery_is_downloaded' then score else 0 end),'","validObjectIds":%22%22,"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error 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":%22%22,"expiration":""}]') AS data FROM tiki_score WHERE event='igallery_new'
Unknown column 'score' in 'field list'
Error 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":%22%22,"expiration":""}]') AS data FROM tiki_score WHERE event='igallery_new_img'
Unknown column 'score' in 'field list'
Error 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":%22%22,"expiration":""},{"ruleId":"Have your image seen","recipientType":"user","recipient":"owner","score":"',max(case when event = 'igallery_img_seen' then score else 0 end),'","validObjectIds":%22%22,"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error 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":%22%22,"expiration":""}]') AS data FROM tiki_score WHERE event='blog_new'
Unknown column 'score' in 'field list'
Error 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":%22%22,"expiration":""}]') AS data FROM tiki_score WHERE event='blog_post'
Unknown column 'score' in 'field list'
Error 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":%22%22,"expiration":""},{"ruleId":"Have your blog read","recipientType":"user","recipient":"author","score":"',max(case when event = 'blog_is_read' then score else 0 end),'","validObjectIds":%22%22,"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error 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":%22%22,"expiration":""}]') AS data FROM tiki_score WHERE event='wiki_new'
Unknown column 'score' in 'field list'
Error 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":%22%22,"expiration":""}]') AS data FROM tiki_score WHERE event='wiki_edit'
Unknown column 'score' in 'field list'
Error 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":%22%22,"expiration":""}]') AS data FROM tiki_score WHERE event='wiki_attach_file'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
# Remove unnecessary fields
ALTER TABLE tiki_score DROP COLUMN score
Can't DROP 'score'; check that column/key exists
Error in 20151203_tiki_score_revamp_tiki
ALTER TABLE tiki_score DROP COLUMN expiration
Can't DROP 'expiration'; check that column/key exists
Error in 20151203_tiki_score_revamp_tiki
ALTER TABLE tiki_score DROP COLUMN validObjectIds
Can't DROP 'validObjectIds'; check that column/key exists
Error in 20151203_tiki_score_revamp_tiki
# Import legacy score from users table
INSERT INTO tiki_object_scores (triggerObjectType, triggerObjectId, triggerUser, triggerEvent, ruleId, recipientObjectType, recipientObjectId, pointsAssigned, pointsBalance, date)
SELECT 'legacy_score', '0', login, 'tiki.legacy.score', 'Legacy Score', 'user', login, score, score, UNIX_TIMESTAMP() FROM users_users
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
# Drop users score column, we now use pointsBalance from tiki_object_scores table
ALTER TABLE users_users DROP COLUMN score
Can't DROP 'score'; check that column/key exists
The URL for the show2.tiki.org instance that demonstrates this bug is at: http://bsfez-11581-8354.show2.tiki.org. Note that if you get a popup asking for a username/password, please just enter "show" and "show". This is different from the initial login and password for a new Tiki which is "admin" and "admin".
For the install log, see http://bsfez-11581-8354.show2.tiki.org/info.txt
Note that if you see PHP errors or a Tiki claiming to be missing third party software, the instance creation is probably not finished. Please wait a couple minutes and reload.
Snapshots are database dumps of the configuration that developers can download for debugging. Once you have reproduced your bug on the show2.tiki.org instance, create a snapshot that can then be downloaded by developers for further investigation.
Snapshots can be accessed at: http://bsfez-11581-8354.show2.tiki.org/snapshots/. Note that if you get a popup asking for a username/password, please just enter "show" and "show".
Create new snapshotTo help developers solve the bug, we kindly request that you demonstrate your bug on a show.tikiwiki.org instance. To start, simply select a version and click on "Create show.tikiwiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show.tikiwiki.org.
filename | created | hits | comment | version | filetype | ||
---|---|---|---|---|---|---|---|
No attachments for this item |