Announcement

Collapse
No announcement yet.

Problems at "access" table creation

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • sean1
    replied
    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.

    Leave a comment:


  • CyberLeish
    replied
    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?

    Leave a comment:


  • CyberLeish
    replied
    I'm using

    http://www.cheapnet.co.uk

    will try the solution you suggest

    Leave a comment:


  • Wayne Luke
    replied
    What host are you using?

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

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

    Leave a comment:


  • CyberLeish
    replied
    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: '[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
    Last edited by CyberLeish; Sat 27 Apr '02, 7:33am.

    Leave a comment:


  • CyberLeish
    started a topic Problems at "access" table creation

    Problems at "access" table creation

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X