Signature Error on vBulletin.com Forum

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ar15dcm
    Senior Member
    • Apr 2012
    • 136
    • 4.2.X

    Signature Error on vBulletin.com Forum

    When trying to set my signature here on this forum, I get the following error;


    Error saving signature: An unexpected error was returned: ' Database error in vBulletin 5.0.0: Invalid SQL:

    UPDATE filedata SET refcount = (refcount - 1) WHERE filedataid IN (60043) /**decrementFiledataRefcount**/;
    MySQL Error : BIGINT UNSIGNED value is out of range in '(`vbcom_forum`.`filedata`.`refcount` - 1)'
    Error Number : 1690
    Request Date : Friday, March 22nd 2013 @ 07:15:13 AM
    Error Date : Friday, March 22nd 2013 @ 07:15:13 AM
    Script : http:///forum/ajax/api/user/saveSignature
    Referrer : http://www.vbulletin.com/forum/settings/profile
    IP Address : X.X.X.X
    Username : ar15dcm
    Classname : vB_Database_MySQL MySQL Version : '

    Last edited by BirdOPrey5; Fri 22 Mar '13, 8:17am.
    Dean Miller, W4DDM
    www.HiramMaxim.Net
  • BirdOPrey5
    Senior Member
    • Jul 2008
    • 9613
    • 5.6.3

    #2
    Did you try making a signature without the attachment reference? That looks like the issue.

    Comment

    • ar15dcm
      Senior Member
      • Apr 2012
      • 136
      • 4.2.X

      #3
      Only text in the signature, same error.
      Dean Miller, W4DDM
      www.HiramMaxim.Net

      Comment

      • BirdOPrey5
        Senior Member
        • Jul 2008
        • 9613
        • 5.6.3

        #4
        Thank You, I've entered a bug report here- http://tracker.vbulletin.com/browse/VBV-8671 - I will keep an eye out if a solution is posted before the site upgrades to the next version.

        Comment

        • Wayne Luke
          vBulletin Technical Support Lead
          • Aug 2000
          • 73981

          #5
          This has occurred elsewhere. It occurs when refcount isn't updated and then subsequently subtracted from. You can't put negative numbers in an unsigned integer.
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API

          Comment

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