Status: offline

Jokke_K

Forum User
Newbie
Registered: 02/24/04
Posts: 9
Hello,

I'm getting following error message in error.log:

Sat Aug 1 14:04:28 2009 - 1064: 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 'SET commentcode = '1' WHERE sid = '20070108213841653'' at line 1. SQL in question: UPDATE SET commentcode = '1' WHERE sid = '20070108213841653'

when accessing articles.

Ideas? I forget to update some file?

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Hmm, I guess that's a missing global declaration in the story class. Try this:

Open system/classes/story.class.php and find the function DisplayElements (line 1459):
Text Formatted Code
    function DisplayElements($item = 'title')
    {
        global $_CONF;

Change that global declaration like so:
Text Formatted Code
    function DisplayElements($item = 'title')
    {
        global $_CONF, $_TABLES;

See if that helps.

bye, Dirk

Status: offline

Jokke_K

Forum User
Newbie
Registered: 02/24/04
Posts: 9
Thanks,

Problem solved.