Results 1 to 8 of 8

Thread: Update ERROR SQL

  1. #1
    Join Date
    Feb 2007
    Posts
    3

    Question Update ERROR SQL

    I backed up my db, uploaded files to upgrade from CMPS v3.0 RC1 to v3.2.3.
    Changed modules persmissions to 777
    had disabled vbadvanced plugin
    ran the install file and got this error below -

    Since it basically screwed up my whole forum, I re-uploaded the v3.0 rc1 files and it is back to normal.

    How do I fix this?

    ----------------------------------------------------------------------------------------------

    Database error in vBulletin 3.8.8:

    Invalid SQL:

    CREATE TABLE vb_adv_pages_user (
    pageid int(10) unsigned NOT NULL default '0',
    userid int(10) unsigned NOT NULL default '0',
    layout text NOT NULL,
    UNIQUE KEY pageid (pageid,userid)
    ) TYPE=MyISAM;

    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 'TYPE=MyISAM' at line 6
    Error Number : 1064
    Request Date : Thursday, February 19th 2015 @ 06:02:17 PM
    Error Date : Thursday, February 19th 2015 @ 06:02:17 PM
    Script : xxx/admincp/vbacmps_install.php
    Referrer : xxx/admincp/vbacmps_install.php
    IP Address : xxx
    Username : xxxxx
    Classname : vB_Database_MySQLi
    MySQL Version : 5.6.22

  2. #2

    Default

    I also have the same error. Does anyone knows how to handle it?

  3. #3
    Join Date
    Feb 2006
    Posts
    1

    Default

    replacing TYPE=MyISAM with ENGINE=MyISAM in the File 'vbacmps_install.php'

  4. #4
    Join Date
    Jul 2005
    Posts
    10

    Default

    As above, TYPE was removed as a keyword in MySQL and replaced by ENGINE, so replace its use anywhere.

  5. #5
    Join Date
    Aug 2008
    Posts
    5

    Default

    Guys this doesn't help as i have the same problem but TYPE=MyISAM doesn't exist, there is a variable $enginevar=MyISAM any ideas?

  6. #6
    Join Date
    Aug 2008
    Posts
    5

    Default

    The $enginevar referrs to ENGINE so i am at a loss???
    Database error in vBulletin 3.8.6:

    Invalid SQL:

    CREATE TABLE vb_adv_pages_user (
    pageid int(10) unsigned NOT NULL default '0',
    userid int(10) unsigned NOT NULL default '0',
    layout text NOT NULL,
    UNIQUE KEY pageid (pageid,userid)
    ) TYPE=MyISAM;

    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 'TYPE=MyISAM' at line 6
    Error Number : 1064
    Request Date : Sunday, June 19th 2016 @ 08:29:49 PM

  7. #7
    Join Date
    Aug 2008
    Posts
    5

    Default

    Sorted now, there were a couple of instances of TYPE that were set as $enginevar

  8. #8
    Join Date
    Apr 2006
    Location
    Detroit
    Posts
    49

    Default

    To install....

    Along with replacing TYPE=MyISAM with ENGINE=MyISAM in the File 'vbacmps_install.php'
    also
    In the admincp/vbacmps_install.php find and remove

    Code:
        if (version_compare(MYSQL_VERSION, '4.0.18', '<')) 
        { 
            $enginevar = 'TYPE'; 
        }

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. mysql error in update counters
    By Lionel in forum Bugs From 1.0 RC1
    Replies: 1
    Last Post: 08-12-2007, 11:37 AM
  2. database error installing games after 1.0.1 update
    By jrofosho in forum Troubleshooting, Problems, Questions
    Replies: 11
    Last Post: 12-01-2005, 08:04 PM
  3. Error after Update
    By TraumTeam in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 10-05-2005, 03:23 PM
  4. error after update scripts
    By parisdns in forum Troubleshooting & Problems
    Replies: 7
    Last Post: 06-06-2005, 11:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •