Impex error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Omeka
    Senior Member
    • Jul 2004
    • 427
    • 5.7.0

    Impex error

    I configured the config file, the two databases are on the same server, but when I click on Import I see this error in the database. Php version 5.4, by vbulletin 4.2.1 to 4.2.1. thanksI configured the config file, the two databases are on the same server, but when I click on Import I see this error in the database. Php version 5.4. Thanks



    ImpEx Database error

    mysql error: Invalid SQL: CREATE TABLE 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: Saturday 22nd 2014f November 2014 10:27:35 AM
    Database: nonsolo3_test
    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
    
    https://traduzioni-italiane.it/
  • ozzy47
    Senior Member
    • Oct 2009
    • 215

    #2
    Edit your /impex/index.php file and about halfway down is this line:

    HTML Code:
    ) TYPE=MyISAM
    Change it to this:

    HTML Code:
    ) ENGINE=MyISAM
    My Mods also available at OzzModz.com

    New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders!
    Stop Spam Now The era of Big Spam is over.

    Vote to bring back hooks in vB5, http://tracker.vbulletin.com/browse/VBV-10333

    Comment

    • Omeka
      Senior Member
      • Jul 2004
      • 427
      • 5.7.0

      #3
      Very well, thank you for a lifetime. Happy weekend
      https://traduzioni-italiane.it/

      Comment

      • ozzy47
        Senior Member
        • Oct 2009
        • 215

        #4
        Not a problem, glad to help.
        My Mods also available at OzzModz.com

        New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders!
        Stop Spam Now The era of Big Spam is over.

        Vote to bring back hooks in vB5, http://tracker.vbulletin.com/browse/VBV-10333

        Comment

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