Announcement

Collapse
No announcement yet.

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

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

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

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

    Code:
    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.

  • #2
    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.

    Comment


    • #3
      Please open a Support Ticket with all relevant details.
      Want to take your board beyond the standard vBulletin features?
      Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

      Comment


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

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

        Blog | Me

        Comment


        • #5
          Thank you. That was the problem.

          Comment

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