No announcement yet.

[3.0.7] Avatar/database error.

  • Filter
  • Time
  • Show
Clear All
new posts

  • [3.0.7] Avatar/database error.

    I did a search to see if Iam the only one who is having the problem, but could find nothing....

    When anyone tries to use the "edit avatar" from the userCP they recive this error:

    Database error in vBulletin 3.0.7:
    Invalid SQL: 
    SELECT avatar.*, imagecategory.title AS category
    FROM avatar AS avatar LEFT JOIN imagecategory AS imagecategory
    LEFT JOIN imagecategory AS imagecategory
    USING(imagecategoryid) LEFT JOIN user AS user ON
    WHERE minimumposts <= 1935
    AND avatar.imagecategoryid=7
    AND avatarid<>0
    ORDER BY avatar.displayorder
    LIMIT 0,25
    mysql error: Not unique table/alias: 'imagecategory'
    mysql error number: 1066
    I DO have the petz and arcade hack, but it worked fine before I upgraded to 3.07, I have reverted all the templates that needed reverting (and then some, opps ) I also have the vbPortal. This just started to happen today as far as I know? (unless no one has changed thier avatar in the last 3 weeks since upgrading?)

    I know you guys don't usually give support to a hacked board, but please? Even a hint?

  • #2
    That error is from a hack you've installed. Specifically you have a duplicate 'imagecategory' field in one of the hacked tables.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    • #3
      But I haven't installed any new hacks (that I can think of??) And when I did a search of the Database for the imagecategory, I couldn't find any that were duplicated??

      I don't suppose there is a chance it's something else huh? hmm and the error doesn't even begin to tell me where it might be either.


      Okay thanks, Steve. Apperciate it, just wish I could figure it out. *pout*


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