Quote:
Originally Posted by bryan09
I got this problem when I inserted the above code ..
Code:
ERROR: Unknown Punctuation String @ 9
STR: ->
SQL: $DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET open = 0
WHERE forumid IN (36) AND open = 1 AND sticky = 0 AND lastpost < " . intval(TIMENOW - (86400 * 30))
)
SQL-query:
$DB_site->query(" UPDATE " . TABLE_PREFIX . "thread SET open = 0 WHERE forumid IN (36) AND open = 1 AND sticky = 0 AND lastpost < " . intval(TIMENOW - (86400 * 30)) )
MySQL said:
#1064 - You have an error in your SQL syntax near '$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET open = 0
WHERE for' at line 1
|
I just got the same error.
Please let me know what I maybe doing wrong?