[eoc_Jason]

I think I found the solution to the random errors that were popping up saying user.ratetradetotal doesn't exist. If you change the SQL query in the showthread.php (step 3 in the install.txt file), instead of tacking on ",ratetradetotal" to one of the left joins, add the ",ratetradetotal" to the end of the SELECT line, and you *shouldn't* get any more errors...

This info will be corrected in the next version when I ge a chance to release it.

05-06-03 at 12:52 PM bowhunt said this in Post #75
I have installed this on vB 2.3 and everything works great except for this morning I have received 3 Errors. I have looked and I think there might be a problem as it is addressing there is no ratetradetotal....

Here is the error...

Database error in vBulletin 2.3.0:

Invalid SQL:
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid,ratetradetotal
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid = '954692'

mysql error: Table 'gunsnet.ratetradetotal' doesn't exist

mysql error number: 1146

Date: Tuesday 06th of May 2003 11:48:08 AM
Script: http://www.gunsnet.net/forums/forums...&postid=954692
Referer: http://www.gunsnet.net/forums/showth...692#post954692


eoc Jason, I want to first thank you for an awesome program and second you think we may be able to fix this?

I did personally change the USER table to reflect the change --> ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL;


Thanks