SMF 1.1.4 to vB 3.7.2 issue

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • terabyte
    Member
    • Jan 2008
    • 69
    • 3.8.x

    SMF 1.1.4 to vB 3.7.2 issue

    Helllo,

    I have problem already at the 3:rd step: Import usergroup

    First I get this error:
    Code:
    ImpEx Database errormysql error: Invalid SQL: 
         INSERT INTO usergroup
         (
          importusergroupid, title, description,
          usertitle, passwordexpires, passwordhistory,
          pmquota, pmsendmax,
          opentag, closetag, canoverride,
          ispublicgroup, forumpermissions, pmpermissions,
          calendarpermissions, wolpermissions, adminpermissions,
          genericpermissions, genericoptions, attachlimit,
          avatarmaxwidth, avatarmaxheight, avatarmaxsize,
          profilepicmaxwidth, profilepicmaxheight, profilepicmaxsize,
          signaturepermissions, sigpicmaxwidth, sigpicmaxheight,
          sigpicmaxsize, sigmaximages, sigmaxsizebbcode, sigmaxchars,
          sigmaxrawchars, sigmaxlines
         )
         VALUES
         (
          '69',
          'Imported Users',
          'Usergroup description',
          '',
          0,
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          '',
          ''
         )
     
    mysql error: Incorrect integer value: '' for column 'passwordhistory' at row 1
    mysql error number: 1366
    Date: Saturday 28th 2008f June 2008 03:23:12 AM
    Database: thaiforum
    MySQL error:
    Then I go further anyway to "Usergroups to import per cycle (must be greater than 1)" and after that I get:

    Code:
     
    ImpEx Database errormysql error: Invalid SQL: SELECT * FROM membergroups ORDER BY ID_GROUP LIMIT , 50
    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 ' 50' at line 1
    mysql error number: 1064
    Date: Saturday 28th 2008f June 2008 03:23:48 AM
    Database: thailandforum
    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 ' 50' at line 1
    In the second step, seem like the quesry is wrong. Should be "... LIMIT 1, 50" I guess.

    Help appritiated.

    (Latest ImpEx used)
  • Jerry
    Senior Member
    • Dec 2002
    • 9137
    • 1.1.x

    #2
    At the bottom of ImpExConfig.php set this ;

    PHP Code:
    define('forcesqlmode'true); 
    I wrote ImpEx.

    Blog | Me

    Comment

    • terabyte
      Member
      • Jan 2008
      • 69
      • 3.8.x

      #3
      Thank for the fast help. It worked like a charm!

      Comment

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