Announcement

Collapse
No announcement yet.

Impex fails because of strict mode on new server

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

  • Impex fails because of strict mode on new server

    I have installed impex into my new vbulletin 4 forum and would just like to import the user accounts over from my old site which is running vbulletin 3.8.4

    when i import the usergroups i get an error the same as this...

    (which is taken from this thread)

    ImpEx Database errormysql error: Invalid SQL:
    INSERT INTO ranks
    (importrankid, minposts, ranklevel, rankimg, usergroupid, type, stack, display)
    VALUES
    (
    1,
    1,
    1,
    'images/ranks/siteartist.jpg',
    0,
    '0',
    '',
    ''
    )
    mysql error: Incorrect integer value: '' for column 'stack' at row 1
    mysql error number: 1366
    i am aware that the target server obviously does not like the empty string quotes for an integer field and this is due to the @@sql_mode being set to strict???

    is there any other way around this or do i have to try and put the server in non strict mode?

    FIXED: I used the SQL commands suggested in the thread mentioned above and then restarted the mysql server.

    This allowed everything to be imported.
    Last edited by Mr Baldman; Fri 22nd Jan '10, 6:09am. Reason: Fixed
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X