[Pokerbanter]

Hey, thanks for this great mod!

However we are having some issues and I think it is this causing them. Basically, when I enable the shop, I can't view some profiles or add people as friends and some other stuff. Here is the error I get when I click on a users profile with the shop enabled...

Database error in vBulletin 3.7.4:

Invalid SQL:
SELECT
					COUNT(t.itemid) as cnt_items, s.*
					FROM pokebxperience_shop_ta as t
					INNER JOIN pokebxperience_shop as s ON s.itemid=t.itemid
					WHERE
					sell=0 AND
					(t.buyer=4 AND t.userid=0)
					GROUP BY t.itemid;

MySQL Error   : Unknown column 'sell' in 'where clause'
Error Number  : 1054
Request Date  : Friday, February 20th 2009 @ 02:13:34 PM
Error Date    : Friday, February 20th 2009 @ 02:13:34 PM
Script        : http://pokerbanter.com/forum/member.php?u=4
Referrer      : http://pokerbanter.com/forum/
IP Address    : 80.76.127.70
Username      : Admin
Classname     : vb_database
MySQL Version : 4.1.19-standard-log"

When I disable the shop the forum runs fine!!

Also, I can't seem to get "Custom points" to stick to users when I award them. Any ideas?

Thanks in advance.

If you have posted the answers to this previously then I do apologise, but I doubt I could manage 153 pages of posts!!