Sql Error

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*,
userfield.field 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,
avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,

NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM vb3_post AS post
LEFT JOIN vb3_user AS user ON(user.userid = post.userid)
LEFT JOIN vb3_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vb3_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN vb3_icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN vb3_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb3_customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN vb3_deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN vb3_editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN vb3_post_parsed AS post_parsed ON(post_parsed.postid = post.postid)

WHERE post.postid IN (0,4692,4764,5247)
ORDER BY dateline

mysql error: Unknown table 'rpg_items_user'

mysql error number: 1051

Date: Friday 08th of July 2005 09:29:40 PM
Script: http://www.unlimitedgamer.net/forum/...read.php?t=772
Referer: http://www.unlimitedgamer.net/forum/...splay.php?f=20
Username: Kakashi
IP Address: 69.251.214.143

in phpmyadmin it calls rpg_items_user vb3_rpg_items_user
but when i change the table in the showthread to vb3_.. it just gives me can't find this table bs.. :/

[Link14716]

Originally Posted by Itachi0009

in phpmyadmin it calls rpg_items_user vb3_rpg_items_user
but when i change the table in the showthread to vb3_.. it just gives me can't find this table bs.. :/

The error is because the query is telling it to select from those tables, but it doesn't actually select the tables (in the FROM portion of the query). Are you sure you applied all the file edits? If this hack modifies the top portion of the query, it should modify the bottom of the query to add a JOIN on the needed tables.

[Itachi0009]

wow i feel so stupid... it would seem i had another error, and when i repaired it i fixed it. But then i went to undo what i thought would fix it, and undid one of the amends to the showthread file...

so dumb

thanks though :P