Results 1 to 2 of 2

Thread: SQL error

  1. #1
    Join Date
    Jan 2017
    Posts
    2

    Default SQL error

    Hello, when i try to install CMPS 3.2.3 on vBulletin 3.8.9, i have this error:

    Code:
    Database error in vBulletin 3.8.9:
    
    Invalid SQL:
    
    		CREATE TABLE IF NOT EXISTS vb_adv_setting (
    			varname varchar(100) NOT NULL default '',
    			grouptitle varchar(50) NOT NULL default '',
    			value mediumtext NOT NULL,
    			defaultvalue varchar(250) NOT NULL default '',
    			optioncode mediumtext NOT NULL,
    			displayorder smallint(3) unsigned NOT NULL default '0',
    			serialize smallint(3) unsigned NOT NULL default '0'
    		) TYPE=MyISAM;
    
    MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 9
    Error Number  : 1064
    Request Date  : Thursday, January 19th 2017 @ 03:00:17 PM
    Error Date    : Thursday, January 19th 2017 @ 03:00:17 PM
    Script        : http://xxxxxxxxxxxxx.org/forums/admincp/vbacmps_install.php
    Referrer      : http://xxxxxxxxxxxxxx.org/forums/admincp/vbacmps_install.php
    IP Address    : 185.22.110.227
    Username      : quentin
    Classname     : vB_Database_MySQLi
    MySQL Version : 10.0.29-MariaDB
    Do you have an idea to problem ?

  2. #2
    Join Date
    Jan 2017
    Posts
    2

    Default

    Find!

    In vbacmps_install.php file, find: (line 3354 and 4306)
    Code:
    $enginevar = 'TYPE';
    Replace by:
    Code:
    $enginevar = 'ENGINE';

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 07-02-2010, 06:25 PM
  2. Replies: 3
    Last Post: 08-25-2008, 02:16 PM
  3. Replies: 3
    Last Post: 04-28-2008, 03:26 PM
  4. Replies: 3
    Last Post: 02-01-2007, 12:38 PM

Posting Permissions

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