Announcement

Collapse
No announcement yet.

When a message is deleted and you click...

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

  • When a message is deleted and you click...

    When a messages i deleted and you click to then view the message we get this sql error. Any help is greatly appreciated.

    Database error in vBulletin 3.0.7:

    Invalid SQL:
    SELECT
    post.*, post.username AS postusername, post.ipaddress AS ip,
    user.*, userfield.*, usertextfield.*,
    userfield.field6 AS rpgname,
    user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,
    rpg_items_user.*,
    rpg_battle_stats.*,
    rpg_race.name AS rpgracename,
    rpg_race.alignment AS rpgalignmentname,
    rpg_class.name AS classname,
    rpg_class.folder AS classfolder,
    rpg_element.name AS elename,
    rpg_clan.title AS clantitle,

    icon.title as icontitle, icon.iconpath,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
    ,avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline
    ,level,
    NOT ISNULL(deletionlog.primaryid) AS isdeleted,
    post_parsed.pagetext_html, post_parsed.hasimages

    FROM post AS post
    LEFT JOIN user AS user ON(user.userid = post.userid)
    LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
    LEFT JOIN rpg_items_user AS rpg_items_user ON(rpg_items_user.userid=user.userid)
    LEFT JOIN rpg_battle_stats AS rpg_battle_stats ON(rpg_battle_stats.userid=user.userid)
    LEFT JOIN rpg_class AS rpg_class ON(rpg_class.id=user.rpgclass)
    LEFT JOIN rpg_element AS rpg_element ON(rpg_element.elementid=user.element)
    LEFT JOIN rpg_clan AS rpg_clan ON(rpg_clan.clanid=user.clan)
    LEFT JOIN rpg_race AS rpg_race ON(rpg_race.raceid=user.rpgrace)
    AND rpg_race.alignmentid=user.alignment

    LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
    LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
    LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
    LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
    LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
    WHERE post.postid = 9044

    mysql error: Column: 'type' in on clause is ambiguous

    mysql error number: 1052

    Date: Sunday 01st of May 2005 09:37:02 AM
    Script: http://www.crimsonsuns.com/showpost....tcount=&p=9044
    Referer:
    Username: mdsbrain
    IP Address: 138.88.31.192

  • #2
    You are not using default files, it looks to me that you are having issues with hacks.

    You should contact the author of the hack, or ask for help in general at vBulletin.org, as we are unable to support modified boards.

    Comment


    • #3
      Originally posted by Zachery
      You are not using default files, it looks to me that you are having issues with hacks.

      You should contact the author of the hack, or ask for help in general at vBulletin.org, as we are unable to support modified boards.
      Alright thank you for pointing me in the right direction.

      Comment

      Loading...
      Working...
      X