[lierduh]

Originally Posted by esfron

Uploaded script again (from vbulletin.org), installed on a fresh vb 3.0.3.

Same mysql error:

Database error in vBulletin 3.0.3:

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 3

mysql error number: 1064

Date: Saturday 23rd of October 2004 03:03:04 AM
Script: http://www.xxxxxxx/forumtest/gateway.php?debug=1
Referer:
Username: Unregistered
IP Address: xxxxx


Any idea ?

According to the error messsage, the problem is "SET value = ", it is empty instead of a number. The number is fetched through:

"SELECT MAX(postid) as postid FROM post"

This is a very standard query and should work. If you can run MySQL query either through shell or phpmyadmin etc, try out that query and see what error do you get. By the way, what version of MySQL do you run?