Architecture / Installation

Posted by Gary Cunningham-Lee 14 Apr 2006 04:34 GMT-0000 posts: 4656

> > Hi I am having a problem with my installation... i am using (DreamHost Mysql5.0.18)
> >
> > Print operations failed
> > Command: CREATE TABLE tiki_articles (
> > ....
> > reads int(14) default NULL,
> > ...
> >
> >
> > Command: CREATE TABLE tiki_submissions (
> > ...
> > reads int(14) default NULL,
> > ...
> > Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'reads int(14) default NULL,
>
> >
> > How do i solve this? Thanks
>
> reads becomes a reserved word in MySQL 5.0, so Tiki versions at least up through 1.9.2 aren't compatible. Judging from changes in CVS, apparently "nbreads" (for number of reads) will replace the reserved word in future Tiki versions. In the meantime, I guess you could change "reads" to "nbreads" in the sql statement that isn't working (the CVS version of tiki.sql uses "nbreads" here) and get the CVS versions of lib/artlib.php and templates/tiki-view_articles.tpl so they'll be using a valid query.
>
> Other page files may cause errors as well (when you view them). I believe lib/statslib.php may also have to be updated to replace "reads". There may be other files as well, but I haven't checked thoroughly.
>
> I'm not sure if there are any other issues with Tiki 1.9.2 and MySQL 5.0, but I'm running with that configuration at http://www.pegasosppc.jp pretty smoothly — though not all features are activated.
>
> — Gary - zukakakina.com