Architecture / Installation

Posted by Gary Cunningham-Lee 04 May 2006 07:31 GMT-0000 posts: 4656

The tiki_articles and tiki_submissions tables of your Tiki database need to be updated. See the last several lines of tiki1.8to1.9.sql:

# fixed reserved word use in mysql
ALTER TABLE `tiki_articles` change `reads` `nbreads` int(14) default NULL ;
ALTER TABLE `tiki_submissions` change `reads` `nbreads` int(14) default NULL ;
ALTER TABLE `tiki_articles` DROP INDEX `reads`, ADD INDEX `nbreads` ( `nbreads` ) ;
ALTER TABLE `tiki_submissions` DROP INDEX `reads`, ADD INDEX `nbreads` ( `nbreads` ) ;

"reads" is a reserved word in MySQL starting with version 4.1, so it can't be used as a column name, thus the update here. You can use a MySQL client like phpMyAdmin or I guess use Tiki's install page to do the update.

-- Gary - themes.tw.o