mysql error number: 1064 in step 3.

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • dpg
    New Member
    • Dec 2004
    • 8
    #1

    mysql error number: 1064 in step 3.

    In step 3 i get the following error, the pasted text below is from the email.

    Database error in vBulletin :

    Invalid SQL:

    CREATE TABLE xzxcpsession (

    userid INT UNSIGNED NOT NULL DEFAULT '0',

    hash VARCHAR(32) NOT NULL DEFAULT '',

    dateline INT UNSIGNED NOT NULL DEFAULT '0',

    PRIMARY KEY (userid, hash)

    )

    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 'hash VARCHAR(32) NOT NULL DEFAULT '',

    dateline INT UNSIGNED N

    mysql error number: 1064

    Date: Friday 10th of December 2004 07:18:30 PM

    Script: http://www.xazax.com/forum2/install/install.php?step=3

    Referer: http://www.xazax.com/forum2/install/install.php?step=2

    IP Address: 213.148.227.4
    ==========================================================
    below the text from step 3 and the source of it.

    Step 3) Creating Tables
    Creating xzxaccess table
    Creating xzxadminhelp table
    Creating xzxadministrator table
    Creating xzxadminlog table
    Creating xzxadminutil table
    Creating xzxannouncement table
    Creating xzxattachment table
    Creating xzxattachmenttype table
    Creating xzxattachmentviews table
    Creating xzxavatar table
    Creating xzxbbcode table
    Creating xzxcalendar table
    Creating xzxcalendarcustomfield table
    Creating xzxcalendarmoderator table
    Creating xzxcalendarpermission table
    Creating xzxcpsession table

    There seems to have been a slight problem with the database.
    Please try again by pressing the refresh button in your browser.
    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
    We apologise for any inconvenience.

    ==========================================================
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
    <title>vBulletin 3.0 Install Script Step 3) Creating Tables</title>
    <link rel="stylesheet" href="../cpstyles/vBulletin_3_Default/controlpanel.css" />
    <style type="text/css">
    #all {
    margin: 10px;
    }
    #all p, #all td, #all li, #all div {
    font-size: 11px;
    font-family: verdana, arial, helvetica, sans-serif;
    }
    </style>
    </head>
    <body style="margin:0px">
    <table cellpadding="4" cellspacing="0" border="0" width="100%" class="navbody" style="borderutset 2px">
    <tr>
    <td width="160"><img src="../cpstyles/vBulletin_3_Default/cp_logo.gif" alt="" title="vBulletin 3 &copy;2000 - 2004 Jelsoft Enterprises Ltd." /></td>
    <td style="padding-left:100px">
    <b>vBulletin 3.0 Install Script</b><br />
    (Please be patient as some parts may take some time)<br />
    <br />
    <b style="font-size:10pt;">Step 3) Creating Tables</b> (Step 3 of 13)</td>
    </tr>
    </table>
    <div id="all">
    <p style="font-size:10pt;"><b><u>Step 3) Creating Tables</u></b></p>
    <ul><li>Creating xzxaccess table</li>
    <!--
    CREATE TABLE xzxaccess (
    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)
    )
    -->
    <li>Creating xzxadminhelp table</li>
    <!--
    CREATE TABLE xzxadminhelp (
    adminhelpid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    script VARCHAR(50) NOT NULL DEFAULT '',
    action VARCHAR(25) NOT NULL DEFAULT '',
    optionname VARCHAR(25) NOT NULL DEFAULT '',
    displayorder SMALLINT UNSIGNED NOT NULL DEFAULT '1',
    volatile SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (adminhelpid),
    UNIQUE KEY phraseunique (script, action, optionname)
    )
    -->
    <li>Creating xzxadministrator table</li>
    <!--
    CREATE TABLE xzxadministrator (
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    adminpermissions INT UNSIGNED NOT NULL DEFAULT '0',
    navprefs VARCHAR(250) NOT NULL,
    cssprefs VARCHAR(250) NOT NULL,
    notes MEDIUMTEXT NOT NULL,
    PRIMARY KEY (userid)
    )
    -->
    <li>Creating xzxadminlog table</li>
    <!--
    CREATE TABLE xzxadminlog (
    adminlogid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    dateline INT UNSIGNED NOT NULL DEFAULT '0',
    script VARCHAR(50) NOT NULL DEFAULT '',
    action VARCHAR(20) NOT NULL DEFAULT '',
    extrainfo VARCHAR(200) NOT NULL DEFAULT '',
    ipaddress CHAR(15) NOT NULL DEFAULT '',
    PRIMARY KEY (adminlogid)
    )
    -->
    <li>Creating xzxadminutil table</li>
    <!--
    CREATE TABLE xzxadminutil (
    title VARCHAR(50) NOT NULL DEFAULT '',
    text MEDIUMTEXT NOT NULL,
    PRIMARY KEY (title)
    )
    -->
    <li>Creating xzxannouncement table</li>
    <!--
    CREATE TABLE xzxannouncement (
    announcementid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
    title VARCHAR(250) NOT NULL DEFAULT '',
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    startdate INT UNSIGNED NOT NULL DEFAULT '0',
    enddate INT UNSIGNED NOT NULL DEFAULT '0',
    pagetext MEDIUMTEXT NOT NULL,
    allowhtml SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    allowbbcode SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    allowsmilies SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    forumid SMALLINT NOT NULL DEFAULT '0',
    views INT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (announcementid),
    KEY forumid (forumid)
    )
    -->
    <li>Creating xzxattachment table</li>
    <!--
    CREATE TABLE xzxattachment (
    attachmentid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    dateline INT UNSIGNED NOT NULL DEFAULT '0',
    thumbnail_dateline INT UNSIGNED NOT NULL DEFAULT '0',
    filename VARCHAR(100) NOT NULL DEFAULT '',
    filedata MEDIUMTEXT NOT NULL,
    visible SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    counter SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    filesize INT UNSIGNED NOT NULL DEFAULT '0',
    postid INT UNSIGNED NOT NULL DEFAULT '0',
    filehash CHAR(32) NOT NULL DEFAULT '',
    posthash CHAR(32) NOT NULL DEFAULT '',
    thumbnail MEDIUMTEXT NOT NULL,
    thumbnail_filesize INT UNSIGNED NOT NULL,
    PRIMARY KEY (attachmentid),
    KEY filesize (filesize),
    KEY filehash (filehash),
    KEY userid (userid),
    KEY posthash (posthash, userid),
    KEY postid (postid)
    )
    -->
    <li>Creating xzxattachmenttype table</li>
    <!--
    CREATE TABLE xzxattachmenttype (
    extension CHAR(20) NOT NULL DEFAULT '',
    mimetype VARCHAR(255) NOT NULL DEFAULT '',
    size INT UNSIGNED NOT NULL DEFAULT '0',
    width SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    height SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    enabled SMALLINT UNSIGNED NOT NULL DEFAULT '1',
    display SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (extension)
    )
    -->
    <li>Creating xzxattachmentviews table</li>
    <!--
    CREATE TABLE xzxattachmentviews (
    attachmentid INT UNSIGNED NOT NULL DEFAULT '0',
    KEY postid (attachmentid)
    )
    -->
    <li>Creating xzxavatar table</li>
    <!--
    CREATE TABLE xzxavatar (
    avatarid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
    title VARCHAR(100) NOT NULL DEFAULT '',
    minimumposts SMALLINT NOT NULL DEFAULT '0',
    avatarpath VARCHAR(100) NOT NULL DEFAULT '',
    imagecategoryid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    displayorder SMALLINT UNSIGNED NOT NULL DEFAULT '1',
    PRIMARY KEY (avatarid)
    )
    -->
    <li>Creating xzxbbcode table</li>
    <!--
    CREATE TABLE xzxbbcode (
    bbcodeid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
    bbcodetag VARCHAR(200) NOT NULL DEFAULT '',
    bbcodereplacement MEDIUMTEXT NOT NULL,
    bbcodeexample VARCHAR(200) NOT NULL DEFAULT '',
    bbcodeexplanation MEDIUMTEXT NOT NULL,
    twoparams SMALLINT NOT NULL DEFAULT '0',
    title VARCHAR(100) NOT NULL DEFAULT '',
    buttonimage VARCHAR(250) NOT NULL DEFAULT '',
    PRIMARY KEY (bbcodeid),
    UNIQUE KEY uniquetag (bbcodetag, twoparams)
    )
    -->
    <li>Creating xzxcalendar table</li>
    <!--
    CREATE TABLE xzxcalendar (
    calendarid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    title VARCHAR(255) NOT NULL DEFAULT '',
    description VARCHAR(100) NOT NULL DEFAULT '',
    displayorder SMALLINT NOT NULL DEFAULT '0',
    neweventemail VARCHAR(255) NOT NULL DEFAULT '',
    moderatenew SMALLINT NOT NULL DEFAULT '0',
    startofweek SMALLINT NOT NULL DEFAULT '0',
    options INT UNSIGNED NOT NULL DEFAULT '0',
    cutoff SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    eventcount SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    birthdaycount SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    startyear SMALLINT UNSIGNED NOT NULL DEFAULT '2000',
    endyear SMALLINT UNSIGNED NOT NULL DEFAULT '2006',
    holidays INT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (calendarid),
    KEY displayorder (displayorder)
    )
    -->
    <li>Creating xzxcalendarcustomfield table</li>
    <!--
    CREATE TABLE xzxcalendarcustomfield (
    calendarcustomfieldid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    calendarid INT UNSIGNED NOT NULL DEFAULT '0',
    title VARCHAR(255) NOT NULL DEFAULT '',
    description MEDIUMTEXT NOT NULL,
    options MEDIUMTEXT NOT NULL,
    allowentry SMALLINT NOT NULL DEFAULT '1',
    required SMALLINT NOT NULL DEFAULT '0',
    length SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (calendarcustomfieldid),
    KEY calendarid (calendarid)
    )
    -->
    <li>Creating xzxcalendarmoderator table</li>
    <!--
    CREATE TABLE xzxcalendarmoderator (
    calendarmoderatorid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    calendarid INT UNSIGNED NOT NULL DEFAULT '0',
    neweventemail SMALLINT NOT NULL DEFAULT '0',
    permissions INT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (calendarmoderatorid),
    KEY userid (userid, calendarid)
    )
    -->
    <li>Creating xzxcalendarpermission table</li>
    <!--
    CREATE TABLE xzxcalendarpermission (
    calendarpermissionid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    calendarid INT UNSIGNED NOT NULL DEFAULT '0',
    usergroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    calendarpermissions INT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (calendarpermissionid),
    KEY calendarid (calendarid),
    KEY usergroupid (usergroupid)
    )
    -->
    <li>Creating xzxcpsession table</li>
    <!--
    CREATE TABLE xzxcpsession (
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    hash VARCHAR(32) NOT NULL DEFAULT '',
    dateline INT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (userid, hash)
    )
    -->
    <html><head><title> Database Error</title><style type="text/css"><!--.error { font: 11px tahoma, verdana, arial, sans-serif; }--></style></head>
    <body></table></td></tr></table></form>
    <blockquote><p class="error">&nbsp;</p><p class="error"><b>There seems to have been a slight problem with the database.</b><br />
    Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p><p class="error">An E-Mail has been dispatched to our <a href="     Staff</a>, who you can also contact if the problem persists.</p><p class="error">We apologise for any inconvenience.</p></blockquote>
    <!--
    Database error in vBulletin :
    Invalid SQL:
    CREATE TABLE xzxcpsession (
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    hash VARCHAR(32) NOT NULL DEFAULT '',
    dateline INT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (userid, hash)
    )
    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 'hash VARCHAR(32) NOT NULL DEFAULT '',
    dateline INT UNSIGNED N
    mysql error number: 1064
    Date: Friday 10th of December 2004 06:12:37 PM
    Script:     http://www.xazax.com/forum2/install/install.php?step=3
    Referer: http://www.xazax.com/forum2/install/install.php?step=2
    IP Address: 213.148.227.4
    -->
    </body></html>
    Tags: None
    • Steve Machol
      Former Customer Support Manager
      • Jul 2000
      • 154488
      #2
      The first thing I recommend is that you reupload all the original vB non-image files. Make sure you upload these in ASCII format and overwrite the ones on the server.
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography

      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        • dpg
          New Member
          • Dec 2004
          • 8
          #3
          I don't have to upload, server is in the other room on my LAN

          but i recopied them, got rid of the old database

          Same problem again

            Comment

            • Steve Machol
              Former Customer Support Manager
              • Jul 2000
              • 154488
              #4
              Hmmm...I don't see how this error could occur with the original files and a fresh database. Fill out a support ticket at:

              404 Not Found 1
              http://www.vbulletin.com/members/membersupport_contactform.php
              vBulletin Community Software


              Be sure to include the login info to your Admin CP, phpMyAdmin and FTP. Please also include a complete description of the problem.
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography

              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment

                • dpg
                  New Member
                  • Dec 2004
                  • 8
                  #5
                  I don't get it either...

                  i don't use PHPMYADMIN or FTP for that site, or any of my databases runnin on that server... and how can i put my login info for the admincp up, it will not install

                  But i tried to refresh step 3

                  and got this error

                  Database error in vBulletin :

                  Invalid SQL:

                  CREATE TABLE xzxaccess (

                  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 'xzxaccess' already exists

                  mysql error number: 1050

                  Date: Friday 10th of December 2004 10:58:00 PM

                  Script: http://www.xazax.com/forum2/install/install.php?step=3

                  Referer:

                  IP Address: 213.148.227.4
                  Last edited by dpg; Fri 10 Dec '04, 1:17pm.

                    Comment

                    • Steve Machol
                      Former Customer Support Manager
                      • Jul 2000
                      • 154488
                      #6
                      Fill out the support ticket so we can help.
                      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                      Change CKEditor Colors to Match Style (for 4.1.4 and above)

                      Steve Machol Photography

                      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                        Comment

                        • dpg
                          New Member
                          • Dec 2004
                          • 8
                          #7
                          No need for that anymore

                          i upgraded my Mysql version from 4.1.0 alpha to 4.1.7
                          Now it works fine

                          Silly thing is i used the vBulletin 3 Test Script and it checked out okay with the 4.1.0 a version

                          I hope this info will help others to


                          thx for the quick responses anyway

                            Comment

                            • Steve Machol
                              Former Customer Support Manager
                              • Jul 2000
                              • 154488
                              #8
                              There is at least one serious bug in MySQL 4.1.7 that you should be aware of:

                              http://www.vbulletin.com/forum/bugs.php?do=view&bugid=3495
                              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                              Change CKEditor Colors to Match Style (for 4.1.4 and above)

                              Steve Machol Photography

                              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                                Comment

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