Announcement

Collapse
No announcement yet.

MyISAM database error won't allow Impex to run

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

  • MyISAM database error won't allow Impex to run

    I've read the entire thread at https://www.vbulletin.com/forum/show...database-error and nothing I try will resolve the issue.

    I have the following error at /forums/impex/
    Code:
    ImpEx Database error
    
    mysql error: Invalid SQL: CREATE TABLE vchat_impexerror (
    						errorid bigint(20) unsigned NOT NULL auto_increment,
    						errortype varchar(10) NOT NULL default '',
    						classnumber varchar(3) NOT NULL default '',
    						importid bigint(20) NOT NULL default 0,
    						error varchar(250) default 'NULL',
    						remedy varchar(250) default 'NULL',
    						PRIMARY KEY (errorid)
    					) 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 9
    
    
    mysql error number: 1064
    
    
    Date: Tuesday 15th 2012f May 2012 04:59:55 PM
    Database: lungtxp_vbull
    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 9
    I can't find what "line 9" it refers to but everyone says it's because MySQL 5+ changed from TYPE= to ENGINE= but the source forum field is indeed "Type" with the variable "MyISAM" throughout and nothing will let me change that field.

    I am trying to migrate MyBB 1.4.13 with PHP 5.2.17 and MySQLi 5.5.21.

    I can't migrate until I can get past this screen. Thanks!

  • #2
    Did you update the impex/index.php file from TYPE to ENGINE?
    Vote for:

    - *Admin Settable Paid Subscription Reminder Timeframe*
    -
    *PM - Add ability to reply to originator only*
    - Add Admin ability to auto-subscribe users to specific channel(s)
    - "Quick Route" Interface...

    Comment


    • #3
      Yes, and when I update line 271 from TYPE=MyISAM to ENGINE=MyISAM, I get the following error:
      Code:
      ImpEx Database error
      
      
      mysql error: Link-ID == false, connect failed
      
      
      mysql error: 
      
      
      Date: Wednesday 16th 2012f May 2012 09:15:03 AM
      Database: lungtxp_chat
      MySQL error:
      That is the complete error, breaking at the colon.

      Comment


      • #4
        mysql error: Link-ID == false, connect failed

        That's your error there - it can't connect to the database at the time.
        Vote for:

        - *Admin Settable Paid Subscription Reminder Timeframe*
        -
        *PM - Add ability to reply to originator only*
        - Add Admin ability to auto-subscribe users to specific channel(s)
        - "Quick Route" Interface...

        Comment

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