Announcement

Collapse
No announcement yet.

[3.0.7] Avatar/database error.

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

  • ShadyNight
    replied
    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.

    *SIGH*

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

    Leave a comment:


  • Steve Machol
    replied
    That error is from a hack you've installed. Specifically you have a duplicate 'imagecategory' field in one of the hacked tables.

    Leave a comment:


  • ShadyNight
    started a topic [3.0.7] Avatar/database error.

    [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:

    Code:
     [font=Arial][size=2]
    Database error in vBulletin 3.0.7:
     
    Invalid SQL: 
     
    SELECT avatar.*, imagecategory.title AS category
     
    FROM avatar AS avatar LEFT JOIN imagecategory AS imagecategory
     
    USING(imagecategoryid)
     
    LEFT JOIN imagecategory AS imagecategory
     
    USING(imagecategoryid) LEFT JOIN user AS user ON
     
    (user.avatarid=avatar.avatarid)
     
    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
     
    [/size][/font]
    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?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X