Re: Aw: Unknown column 'nbreads' in 'field list'
> > After upgrading to 1.9.3.1 my old Articles are not showing up.
> >
> >
> > Context:
> > File /cgi-system/php.cgi
> > Url /tiki-read_article.php?articleId=127
> > Query:
> > update `tiki_articles` set `nbreads`=`nbreads`+1 where `articleId`=?
> >
> > Error Message Unknown column 'nbreads' in 'field list'
> >
> >
> > I've looked in tikilib.php any help would be very appreciated.
> > (I've been using TikiWiki for some years now and it's been just great! thanks!)
>
> Hello guys,
>
> i have a similar problem with tiki.
>
> I want to show / list my articles, that works.
> Now I click on one article and this error comes open:
>
> update `tiki_articles` set `nbreads`=`nbreads`+1 where `articleId`=?
>
>
> What can I do?
You have to update your database with the statements in the other post here. "reads" is a reserved word in recent MySQL versions, so the columns are called "nbreads" now. There's an error if the templates are updated, which specify "nbreads" now, and the database isn't updated to match.
-- Gary - zukakakina.com