Quote:
Originally Posted by panda1
Rik,
Every think went fine with me but when trying to run gateway.php i received the following error:
------------------------------------------------
Database error in vBulletin 3.6.5:
Invalid SQL:
UPDATE nntp_settings
SET value = WHERE varname = 'last_postid';
MySQL Error : 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 'WHERE varname = 'last_postid'' at line 2
Error Number : 1064
Date : Wednesday, April 18th 2007 @ 04:59:06 PM
Script : http://forums.networkingland.com/adm...cron&cronid=19
Referrer : http://forums.networkingland.com/admincp/index.php
IP Address : 212.35.77.232
Username : admin
Classname : vB_Database
--------------------------------------------------
any help to fix this
Panda
|
Panda:
Sorry, I'm not much of help with mySQL. But it looks to me that a variable is not set since the
line "SET value = (some value should be here) WHERE varname = 'last_postid';" is missing a value which should be in your nntp settings. See the "Last Max postid" variable in your NNTP Gateway Settings.
I'd make sure you have the defaults all set there and leave nothing blank.
-- Rik