Weird error at step 4

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Kenny250285
    New Member
    • Nov 2000
    • 23

    Weird error at step 4

    Hi,

    I install the vbb and everything goes ok untill this by step 4:

    Source:

    <html>
    <!--
    --><head><title>vBulletin Install Wizard 1.1.5 - Set up tables</title></head>
    <body><p>Setting up tables...</p>
    <!-- Database error in vBulletin Installer: Invalid SQL: CREATE TABLE session (
    sessionid MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL,
    userid SMALLINT UNSIGNED NOT NULL,
    ipaddress CHAR(20) NOT NULL,
    lastactivity INT UNSIGNED NOT NULL,
    location CHAR(250) NOT NULL,
    PRIMARY KEY(sessionid)
    )
    mysql error: parse error near 'NOT NULL,
    userid SMALLINT UNSIGNED NOT NULL,
    ipaddre' at line 2
    mysql error number: 1064
    Date: Tuesday 30th of January 2001 02:49:57 AM
    Script: /admin/install.php3?step=4
    Referer: [url]http://xxxxxxxx/admin/install.php3?step=3[/url]
    -->
    </td></tr></table>
    <p>There seems to have been a slight problem with the database.
    Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>

    I don't know what this error is!

    Please help me,

    Kenny

  • PeF
    Senior Member
    • Oct 2000
    • 767

    #2
    Solved on ICQ. Old version of MySQL (3.21.xx). ;)

    Comment

    • Q31
      New Member
      • Feb 2001
      • 6

      #3
      i get the same error.. only with a very lil difference..

      ----
      <html>
      <!--
      --><head><title>vBulletin Install Wizard 1.1.5 - Set up tables</title></head>
      <body><p>Setting up tables...</p><br>
      <b>Warning</b>: MySQL: Unable to save result set in <b>/usr/local/share/doc/apache/board/admin/db_mysql.php</b> on line <b>89</b><br>

      <!-- Database error in vBulletin Installer: Invalid SQL: CREATE TABLE announcement (
      announcementid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
      title CHAR(50) NOT NULL,
      userid SMALLINT UNSIGNED NOT NULL,
      startdate INT UNSIGNED NOT NULL,
      enddate INT UNSIGNED NOT NULL,
      pagetext MEDIUMTEXT NOT NULL,
      forumid SMALLINT NOT NULL,
      PRIMARY KEY(announcementid)
      )
      mysql error:
      mysql error number: 0
      Date: Wednesday 07th of February 2001 12:14:47 AM
      Script: /board/admin/install.php?step=4
      Referer: [url]http://[/url]*.*.*.*/board/admin/install.php?step=3
      -->
      </td></tr></table>
      <p>There seems to have been a slight problem with the database.
      Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>
      ---

      is that the same problem with an old mysql version, cause i have these to installed on my system...

      mysql-client-3.23.26 Multithreaded SQL database (client)
      mysql-server-3.23.26 Multithreaded SQL database (server)

      so i can't see how they should be old... but maybe an error in the install in one of them ??

      thanx in advanced Q31

      Comment

      • GewGaw
        New Member
        • Feb 2001
        • 11

        #4
        I am getting the same error with the following configuration:
        - FreeBSD
        - Apache 1.3.17
        - MySQL 3.23.23
        - PHP 4.0.3pl1

        The problem is identical to the one mention above however, in my MySQL error log it is showing Aborted connections with the following: (Got an error reading communication packets).

        This problem only seemed to appear after an upgrade from Apache 1.3.12 to 1.3.17.

        (MySQL, PHP have been recompiled after the apache upgrade)

        Comment

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