Announcement

Collapse
No announcement yet.

Clean import from PHPBB2.0.22 to VB3.6.8

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

  • Clean import from PHPBB2.0.22 to VB3.6.8

    First thing. I didn't even see vb 3.6.8 included in the conversion list so I selected the nearest version to it.

    Everything was smooth until I attempt to import usergroups

    ImpEx Database errormysql error: Invalid SQL:
    INSERT INTO apusergroup
    (
    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',
    'Active Imported Users',
    'Usergroup description',
    '',
    0,
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    ''
    )

    mysql error: Incorrect integer value: '' for column 'passwordhistory' at row 1
    mysql error number: 1366
    Date: Sunday 26th 2003f January 2003 04:35:09 AM
    Database: forum
    MySQL error:

  • #2
    If you are not using Impex 1.83, then please download and use that version.

    Then if you still have this problem, edit the ImpExConfig.php file and change this line :

    define('forcesqlmode', false);

    to

    define('forcesqlmode', true);
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Thank you. When I read the
      "Using includes/config.php for target config."

      I went and changed that forcesqlmode = true. Never thought about checking the impex config.

      Comment


      • #4
        Glad it worked.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Originally posted by Alibi View Post
          Thank you. When I read the
          "Using includes/config.php for target config."

          I went and changed that forcesqlmode = true. Never thought about checking the impex config.
          Put on the todo list.
          I wrote ImpEx.

          Blog | Me

          Comment

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