Action Required

[WhiskeyOSS]

I got this error trying to do a clean install does this mean the sql data base is unusable ?

Action Required
An error has occurred with your database. Please contact vBulletin Support for assistance.
Module: install, Step 2 Database Error:1005
Can't create table 'whiskey_teamsr.access' (errno: -1)
Query:

CREATE TABLE access ( userid INT UNSIGNED NOT NULL DEFAULT '0', nodeid SMALLINT UNSIGNED NOT NULL DEFAULT '0', accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY userid (userid, nodeid)) ENGINE = InnoDB


An error has occurred with your database. Please contact vBulletin Support for assistance.
Module: install, Step 2 Database Error:1005
Can't create table 'whiskey_teamsr.access' (errno: -1)
Query:

CREATE TABLE access ( userid INT UNSIGNED NOT NULL DEFAULT '0', nodeid SMALLINT UNSIGNED NOT NULL DEFAULT '0', accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY userid (userid, nodeid)) ENGINE = InnoDB

[Mark.B]

If you're trying a clean install, try deleting the database you have created and setting up another one 9make sure you change config.php to match).
Does the same problem occur?

[WhiskeyOSS]

I did try that mark and came up short handed they are going to move me to a different server because the data base is not connecting thru the cpanel or is what i am being told. this is getting tiresome to be honest.

[Yves R.]

MySQL error 1005 means you don't have CREATE permission to create tables into MySQL.

[Mark.B]

It sounds like you don't have the CREATE permission in MySQL.

Edit - utterly Ninja'd

[WhiskeyOSS]

Not sure mark the host worked on it for 12 hours straight and could not get the sql data base to be seen by cpanel however phpmyadmin could see the data base but I have no way of deleting the old one at this point I am stuck waiting for them to get me a new hosting server set up .. .

[Mark.B]

Not sure mark the host worked on it for 12 hours straight and could not get the sql data base to be seen by cpanel however phpmyadmin could see the data base but I have no way of deleting the old one at this point I am stuck waiting for them to get me a new hosting server set up .. .

If your host is struggling for 12 hours to get a straightforward MySQL setup in place then it might be time to consider a new host.

[WhiskeyOSS]

If your host is struggling for 12 hours to get a straightforward MySQL setup in place then it might be time to consider a new host.

yeah that would be the normal route to take but I have paid this in advance for 12 months and no hope of a refund..

[Mark.B]

yeah that would be the normal route to take but I have paid this in advance for 12 months and no hope of a refund..

Sometimes it's still worth cutting your losses. I don't honestly hold out much hope if what you say is correct.

[WhiskeyOSS]

Sometimes it's still worth cutting your losses. I don't honestly hold out much hope if what you say is correct.

yep it is we are considering renting a virtural server, because we are still waiting for them to set us up an new hosting plan that normally takes 15 min.. ..

[Zachery]

I'm not normally in the habbit of saying this, but if the webhosting company isn't delivering the services paid for, over several days, I'd advise asking for a refund, if you can't get a refund, I suspect you could get a charge back with your credit card company. But it should only be used as a last resort. I'd say they should at least refund you for the time left.

[WhiskeyOSS]

I will deal with the money issue later I need to get this website a rolling as it stands I am going to run a private vb5 site and put my vb4 site back up .. it is so much less confusion that way .. vb5 being a beta and being live right now is not the greatist thing as some of you guys tried to tell my tired old arse. lol...