Announcement

Collapse
No announcement yet.

dotNetBB > vB 3.6.8 p2

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

  • dotNetBB > vB 3.6.8 p2

    I'm experiencing a problem importing from dotnetBB to 3.6.8 p2 as follows :-

    Clean Import
    Source - dotnetBB 2.42EC SP3
    Target - vB 3.6.8p2
    Module 001
    MySQL error

    Code:
    ImpEx Database errormysql error: Invalid SQL: 
                        INSERT INTO mst_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 with no group',
                            'Usergroup description',
                            '',
                            0,
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            '',
                            ''
                        )
                    
    
    mysql error: Incorrect integer value: '' for column 'passwordhistory' at row 1
    
    mysql error number: 1366
    
    Date: Thursday 20th 2008f March 2008 02:48:18 PM
    Database: beo2forum
    MySQL error: Incorrect integer value: '' for column 'passwordhistory' at row 1
    Many thanks in advance for any assistance you may be able to give,

    Irksome

  • #2
    My apologies - a quick search threw up the solution from Jerry.

    Set this at the bottom of ImpExConfig.php :

    PHP Code:
    define('forcesqlmode', true);

    MySQL is running in strict mode.

    Comment


    • #3
      i do that but the porblem is still happened

      Comment


      • #4
        Originally posted by elrafei View Post
        i do that but the porblem is still happened
        That error comes from MySQL running in STRICT mode, if you have set that in the ImpExConfig.php and it is still happening I'd think that means that ImpEx can't change the mode during run time, you will have to get the host to remove the mode type for the import.
        I wrote ImpEx.

        Blog | Me

        Comment

        Related Topics

        Collapse

        Working...
        X