No announcement yet.

Signature Error on Forum

  • Filter
  • Time
  • Show
Clear All
new posts

  • Signature Error on 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 :
    IP Address : X.X.X.X
    Username : ar15dcm
    Classname : vB_Database_MySQL MySQL Version : '

    Last edited by Joe D.; Fri 22 Mar '13, 8:17am.
    Dean Miller, W4DDM

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


    • #3
      Only text in the signature, same error.
      Dean Miller, W4DDM


      • #4
        Thank You, I've entered a bug report here- - I will keep an eye out if a solution is posted before the site upgrades to the next version.


        • #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 - Full / Mobile
          Vote for your favorite feature requests and the bugs you want to see fixed.


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