Announcement

Collapse
No announcement yet.

Unable to Install Database error MySQL Error : Can't create table '.\mysql\user.frm

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

  • Unable to Install Database error MySQL Error : Can't create table '.\mysql\user.frm

    Dear All,

    I am very new User just bought the licence first time and installing it. When I reach the 2nd step I am getting the following error; please help its very urgent!

    Database error in vBulletin :
    Invalid SQL:
    CREATE TABLE user (
    userid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    usergroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    membergroupids CHAR(250) NOT NULL DEFAULT '',
    displaygroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    username VARCHAR(100) NOT NULL DEFAULT '',
    password CHAR(32) NOT NULL DEFAULT '',
    passworddate date NOT NULL DEFAULT '0000-00-00',
    email CHAR(100) NOT NULL DEFAULT '',
    styleid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    parentemail CHAR(50) NOT NULL DEFAULT '',
    homepage CHAR(100) NOT NULL DEFAULT '',
    icq CHAR(20) NOT NULL DEFAULT '',
    aim CHAR(20) NOT NULL DEFAULT '',
    yahoo CHAR(32) NOT NULL DEFAULT '',
    msn CHAR(100) NOT NULL DEFAULT '',
    skype CHAR(32) NOT NULL DEFAULT '',
    showvbcode SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    showbirthday SMALLINT UNSIGNED NOT NULL DEFAULT '2',
    usertitle CHAR(250) NOT NULL DEFAULT '',
    customtitle SMALLINT NOT NULL DEFAULT '0',
    joindate INT UNSIGNED NOT NULL DEFAULT '0',
    daysprune SMALLINT NOT NULL DEFAULT '0',
    lastvisit INT UNSIGNED NOT NULL DEFAULT '0',
    lastactivity INT UNSIGNED NOT NULL DEFAULT '0',
    lastpost INT UNSIGNED NOT NULL DEFAULT '0',
    lastpostid INT UNSIGNED NOT NULL DEFAULT '0',
    posts INT UNSIGNED NOT NULL DEFAULT '0',
    reputation INT NOT NULL DEFAULT '10',
    reputationlevelid INT UNSIGNED NOT NULL DEFAULT '1',
    timezoneoffset CHAR(4) NOT NULL DEFAULT '',
    pmpopup SMALLINT NOT NULL DEFAULT '0',
    avatarid SMALLINT NOT NULL DEFAULT '0',
    avatarrevision INT UNSIGNED NOT NULL DEFAULT '0',
    profilepicrevision INT UNSIGNED NOT NULL DEFAULT '0',
    sigpicrevision INT UNSIGNED NOT NULL DEFAULT '0',
    options INT UNSIGNED NOT NULL DEFAULT '15',
    birthday CHAR(10) NOT NULL DEFAULT '',
    birthday_search DATE NOT NULL DEFAULT '0000-00-00',
    maxposts SMALLINT NOT NULL DEFAULT '-1',
    startofweek SMALLINT NOT NULL DEFAULT '1',
    ipaddress CHAR(15) NOT NULL DEFAULT '',
    referrerid INT UNSIGNED NOT NULL DEFAULT '0',
    languageid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    emailstamp INT UNSIGNED NOT NULL DEFAULT '0',
    threadedmode SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    autosubscribe SMALLINT NOT NULL DEFAULT '-1',
    pmtotal SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    pmunread SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    salt CHAR(3) NOT NULL DEFAULT '',
    ipoints INT UNSIGNED NOT NULL DEFAULT '0',
    infractions INT UNSIGNED NOT NULL DEFAULT '0',
    warnings INT UNSIGNED NOT NULL DEFAULT '0',
    infractiongroupids VARCHAR (255) NOT NULL DEFAULT '',
    infractiongroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    adminoptions INT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (userid),
    KEY usergroupid (usergroupid),
    KEY username (username),
    KEY birthday (birthday, showbirthday),
    KEY birthday_search (birthday_search)
    );
    MySQL Error : Can't create table '.\mysql\user.frm' (errno: -1)
    Error Number : 1005
    Date : Wednesday, October 31st 2007 @ 10:13:16 AM
    Script : http://localhost/forums/install/install.php?do=
    Referrer : http://localhost/forums/install/inst...3&emptydb=true
    IP Address : 127.0.0.1
    Username :
    Classname : vB_Database

  • #2
    Contact the hosting provider, asking them why you can't write to the disk. Error -1 can be a lot of things.

    Comment


    • #3
      Its my own PC, I am deploying it on local Intranet. Its creating all the other table before the user one. And every time it breaks at creating the user table.

      I am running Windows XP Professional (This is test environment). Do I need to give additional rights???

      Comment


      • #4
        do you have enough disk space in the partition which has mysql data on it ? what version of PHP/MySQL you using ?

        ran scandisk and your hard drive manufacturer's disk diagnostic software yet ? could be bad sectors are that area of the disk ?
        :: Always Back Up Forum Database + Attachments BEFORE upgrading !
        :: Nginx SPDY SSL - World Flags Demo [video results]
        :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

        Comment


        • #5
          Solved it.

          It got nothing to do with disk space; since I am very new I installed it on the root user. Which conincided with the system table 'USER'.

          Solution:
          Reinstalled new MYSQL created a user and installed it again it works!

          Comment


          • #6
            Ah i see
            :: Always Back Up Forum Database + Attachments BEFORE upgrading !
            :: Nginx SPDY SSL - World Flags Demo [video results]
            :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...
            X