Problems at "access" table creation

[CyberLeish]

Please help!

I have access to my database I can drop create etc using the php-myadmin software with no problems. It is a specified db address of

db.cheapnet.co.uk

rather than localhost so I set the config to reflect this. Vbulletin install finds and connects to the database no problem then gets stuck with the creation of the first table.

It seems to create a table called "access" which if i check in php-myadmin does appear as created. However I get the error from vbulletin of...


Database error in vBulletin Installer :

Invalid SQL: CREATE TABLE access (
userid int(10) unsigned DEFAULT '0' NOT NULL,
forumid smallint(5) unsigned DEFAULT '0' NOT NULL,
accessmask smallint(5) unsigned DEFAULT '0' NOT NULL
)
mysql error: Table 'access' already exists

mysql error number: 1050

Date: Saturday 27th of April 2002 03:46:37 PM
Script: /~a1144349/boards/admin/install.php?step=4
Referer: http://members.cheapnet.co.uk/~a1144...all.php?step=3


the fact that is connects to the dastabase and creates (in name at least) the table suggests my config details are correct.

Suggestions please

[CyberLeish]

Additional...

I dropped the faulty access table and tried again this time choosing to "clear" the database.

database cleared... fine
table access created... fine
altering table access... there is a problem.

Database error in vBulletin Installer :

Invalid SQL: ALTER TABLE access ADD UNIQUE (userid,forumid)
mysql error: Access denied for user: 'a1144349[email protected]' to database 'a1144349'

mysql error number: 1044

Date: Saturday 27th of April 2002 04:22:36 PM
Script: /~a1144349/boards/admin/install.php?step=4
Referer: http://members.cheapnet.co.uk/~a1144...all.php?step=3

[Wayne Luke]

What host are you using?

If you are using vServers go into the install.php file and change the following line:

$onvservers=0; // set this to 1 if you're on Vservers and get disconnected after running an ALTER TABLE command 

to:

$onvservers=1; // set this to 1 if you're on Vservers and get disconnected after running an ALTER TABLE command 

[CyberLeish]

I'm using

http://www.cheapnet.co.uk

will try the solution you suggest

[CyberLeish]

Great I progressed to have all tables apparently created and altered but at the end of that step it reports...


The script reported errors in the installation of the tables. Only continue if you are sure that they are not serious.

The errors were:

Error number: 1044

Error description: Access denied for user: '[email protected]' to database 'a1144349'


I'm going to continue it but not happy having that error in case it comes back to bite me once the boards are running - any suggestions what is going wrong now?

[sean1]

Cyberleish

I had a similar error at about the same stage of Install and carried on, did you recieve any advice as to whether this will haunt you later.