Database error in vBulletin

[AlShammari]

Hello

I face this problem whene I was install the vBulletin

Database error in vBulletin :

Invalid SQL:

CREATE TABLE access (
	userid INT UNSIGNED NOT NULL DEFAULT '0',
	forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY userid (userid, forumid)
);

MySQL Error  : Table 'access' already exists
Error Number : 1050
Date         : Tuesday, September 18th 2007 @ 02:48:30 AM
Script       : http://members.lycos.co.uk/miske/install/install.php?step=3&____ord____=1190076391
Referrer     : http://members.lycos.co.uk/miske/install/install.php?step=3
IP Address   : 168.187.11.130
Username     : 
Classname    : vb_database

[Kirk Y]

What exactly are you trying to do? Importing from another board or installing a fresh board? Basically this error means that there is already a table in the database you're telling vBulletin to install to.

[AlShammari]

thanks alot

and what about this error?

Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT COUNT(threadid) AS total FROM thread WHERE postuserid=;

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 '' at line 1
Error Number : 1064
Date         : Wednesday, September 19th 2007 @ 02:53:15 PM
Script       : http://www.temo.com/vb/showthread.php?t=1849&highlight=demo
Referrer     : http://www.temo.com/vb/search.php?searchid=3673
IP Address   : 168.187.11.130
Username     : temo
Classname    : vB_Database

[Dismounted]

Try disabling all your modifications.

[AlShammari]

Originally Posted by Dismounted

Try disabling all your modifications.

the problem happen after i change user id from Mysql

[Eikinskjaldi]

Did you change it in all 20-30 tables that use some form of userid, or did you just hopelessly corrupt your forum by only changing it in the user table?

[AlShammari]

change it in user table

[Eikinskjaldi]

Originally Posted by AlShammari

change it in user table

Well you'd better change it back then. Because the userid is used all over vb in various fields, and just changing the value in the user table will cause...well...errors liek the one you are getting.

[AlShammari]

Originally Posted by Eikinskjaldi

Well you'd better change it back then. Because the userid is used all over vb in various fields, and just changing the value in the user table will cause...well...errors liek the one you are getting.

i change it back
but still have the problem

[AlShammari]

I still has Database error
I change the id number from data base from user table
and change it back