Announcement

Collapse
No announcement yet.

Yabb 2.2.3 flat file import

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

  • Yabb 2.2.3 flat file import

    I cant see how I can modify the impex config script to import from a yabb 2.2.3 database. The options for source seemto be mysql or mssql - nothing for text.

    Am I missing something ? is there an example script for yabb?

  • #2
    Originally posted by sandy771 View Post
    I cant see how I can modify the impex config script to import from a yabb 2.2.3 database. The options for source seemto be mysql or mssql - nothing for text.

    Am I missing something ? is there an example script for yabb?
    OK - sorted that bit.

    Now I have another problem. When I click the check database button I get the following error, where do I start trying to correct this.

    ImpEx Database errormysql error: Invalid SQL:
    INSERT INTO vbusergroup
    (
    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 24th 2010f April 2010 08:39:39 AM
    Database: forum
    MySQL error: Incorrect integer value: '' for column 'passwordhistory' at row 1

    Comment


    • #3
      Hi Paul, answered your Support ticket on this....
      Vote for:

      - *Admin Settable Paid Subscription Reminder Timeframe*
      -
      *PM - Add ability to reply to originator only*
      - Add Admin ability to auto-subscribe users to specific channel(s)
      - "Quick Route" Interface...

      Comment


      • #4
        Posted on here before I saw the support email address.

        Forum all imported now and seems to be working OK - thanks for your help.

        Comment


        • #5
          No problem.

          For info in case anyone else has this issue, edit the ImpExConfig.php and change this line:

          define('forcesqlmode', false);

          To this:

          define('forcesqlmode', true);

          Then try again.
          Vote for:

          - *Admin Settable Paid Subscription Reminder Timeframe*
          -
          *PM - Add ability to reply to originator only*
          - Add Admin ability to auto-subscribe users to specific channel(s)
          - "Quick Route" Interface...

          Comment

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