Quote:
Originally Posted by bennac40
I get a database error when I try to add items.
Invalid SQL:
SELECT COUNT(userid) as countuser
FROM `user`
WHERE userid in (0,555 Beach Club (Tanger));;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Beach Club (Tanger))' at line 3
Error Number : 1064
Request Date : Thursday, February 12th 2009 @ 01:45:48 PM
Error Date : Thursday, February 12th 2009 @ 01:45:48 PM
Script : http://forum.xxxxx.com/admincp/kbank...do_type_update
Referrer : http://forum.xxxxxx.com/admincp/kban...do=type_update
IP Address : xxx.xxx.xxx.xxx
Username : xxxx
Classname : vB_Database
MySQL Version : 5.0.67-community
can anyone help please
|
Do NOT use username in Manufactures fields. You just need to place the userid of them (you can add multiple manufactures by separating userids with commas). Please try again