Announcement

Collapse
No announcement yet.

Impex Database Error

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

  • jaffa123
    replied
    Originally posted by Trevor Hannant View Post
    If you edit the file impex/index.php and change TYPE=MyISAM to ENGINE=MyISAM located at or near line 271, this should resolve this for you.

    You can perform multiple imports - there is also the option to associate users to existing accounts if the email address matches.
    Thanks Trevor, just tried that and it still doesn't work. I have a white screen with only this displayed: {"product":1,"version":"4.2.0","plugin_version":"1.4.8"}

    - - - Updated - - -

    I disabled vBSSO and now it the Import screen appears.

    Now to work out how to use this import thing. I have over 6000 wordpress users I want to import into vBulletin - yikes!

    Leave a comment:


  • Trevor Hannant
    replied
    If you edit the file impex/index.php and change TYPE=MyISAM to ENGINE=MyISAM located at or near line 271, this should resolve this for you.

    You can perform multiple imports - there is also the option to associate users to existing accounts if the email address matches.

    Leave a comment:


  • jaffa123
    started a topic Impex Database Error

    Impex Database Error

    Hello All

    I'm new to vBulletin and I am trying to import users from a csv file. I figured out I need Impex so I downloaded that, edited the config and logged in. When I click import now I see this: {"product":1,"version":"4.2.0","plugin_version":"1.4.8"}

    Initaially I had this message:

    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: Tuesday 11th 2012f December 2012 11:22:17 PM
    Database: xxxx_forum
    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

    No idea how to resolve this, any tips?

    Thanks



    - - - Updated - - -

    Just another question: is it easier to import from one database to vbulletin? For example, I want to import all my wordpress users into my vbulletin so they have the same username and passwords. What is the best way to do this?

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