SQL error in 1.8 upgrade
I'm trying to update my db tables from 1.7.4 to 1.8, but errors are stopping the process when I try to run comments_fix1.7to1.8.sql. The existing tiki_comments table gets renamed to old_tiki_comments and the new tiki_comments gets made. But the next SQL statement
"# Move over all the md5 stuff to the new format.
insert into tiki_comments select
tc.threadId,
concat('wiki page', tp.pagename) 'object',
tc.parentId,
tc.userName,
tc.commentDate,
tc.hits,
tc.type,
tc.points,
tc.votes,
tc.average,
tc.title,
tc.data,
tc.hash,
tc.user_ip,
tc.summary,
tc.smiley,
tc.message_id,
tc.in_reply_to
from old_tiki_comments tc, tiki_pages tp
where tc.object = md5'wiki page', tp.pageName;"
produces this error:
"SQL-query :
INSERT INTO tiki_comments
SELECT tc.threadId, concat( 'wiki page', tp.pagename ) 'object', tc.parentId, tc.userName, tc.commentDate, tc.hits, tc.type, tc.points, tc.votes, tc.average, tc.title, tc.data, tc.hash, tc.user_ip, tc.summary, tc.smiley, tc.message_id, tc.in_reply_to
FROM old_tiki_comments tc, tiki_pages tp
WHERE tc.object = md5( concat( 'wiki page', tp.pageName ) )
MySQL said:
Unknown column 'tc.message_id' in 'field list'"
My server setup is Linux/MySQL 4.0.15 and I'm using phpMyAdmin 2.5.2. Does anyone have an idea why this statement is failing? Thanks for your help.
-- Gary