Announcement

Collapse
No announcement yet.

Impex error

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

  • Omeka
    started a topic Impex error

    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
    

  • ozzy47
    replied
    Not a problem, glad to help.

    Leave a comment:


  • Omeka
    replied
    Very well, thank you for a lifetime. Happy weekend

    Leave a comment:


  • ozzy47
    replied
    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

    Leave a comment:

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