Out of range value adjusted for column 'signaturepermissions' at row 1

[Heavier]

When doing the "import usergroups" module of Impex, i get this error

ImpEx Database errormysql error: Invalid SQL: 
                    INSERT INTO vb_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
                    (
                        '1',
                        'ImpEx - Unregistered / Not Logged In',
                        '',
                        'Guest',
                        0,
                        '0',
                        '50',
                        '0',
                        '',
                        '',
                        '0',
                        '0',
                        '131073',
                        '0',
                        '1',
                        '0',
                        '0',
                        '1',
                        '32',
                        '0',
                        '80',
                        '80',
                        '20000',
                        '100',
                        '100',
                        '65535',
                        '',
                        '',
                        '',
                        '',
                        '',
                        '',
                        '',
                        '',
                        ''
                    )
                

mysql error: Out of range value adjusted for column 'signaturepermissions' at row 1

mysql error number: 1264

Date: Sunday 25th 2007f March 2007 01:33:45 PM
Database: x1
MySQL error:

I've tried disabling all products and plugins in both the source and target forum, but still no luck; same error.

[Heavier]

I've found a similar problem only in chinese

http://forum.vbulletin-china.cn/showthread.php?t=303

it's the only instance of this happening to someone else my google-fu can churn up.

[Marco van Herwaarden]

Please open a Support Ticket with all relevant details.

[Jerry]

This comes from running MySQL in STRICT mode, try setting this in ImpExConfig.php and retrying :

define('forcesqlmode', true); 

[Heavier]

Thank you. That was the problem.