SQL Error, Help?

DevilWearsPrada · 10-04-2007, 07:10 PM

I have a hack that is meant to show a certain usergroups's members and it keeps giving SQL errors, first it was a table didn't exist then something else after that, I can't get it to work.

The Original SQL Query

You must first be a registered member to view any code.

I'm using VB 3.6.7 if that helps at all.

Thanks in advance.

schussel · 10-04-2007, 07:11 PM

the resulting sql error message would be waaaaay more helpful

DevilWearsPrada · 10-04-2007, 07:19 PM

Ok well here is the first one that says the table doesn't exist.

Database error in vBulletin 3.6.7:

Quote:

Invalid SQL:

SELECT user.*, user.options
FROM vb_user AS user
LEFT JOIN vb_userfield AS userfield ON(userfield.userid = user.userid)
WHERE vb_user.usergroupid = 12;

MySQL Error : Unknown table 'vb_user' in where clause
Error Number : 1109
Date : Thursday, October 4th 2007 @ 04:14:07 PM
Script : /showgroups.php?do=contributors
Referrer :
IP Address : ----------
Username : ---------
Classname : vb_database

10-04-2007, 08:14 PM

You must first be a registered member to view any code.

There should not be a table_prefix in the WHERE clause
What is $locationfieldselect?

DevilWearsPrada · 10-04-2007, 08:33 PM

$locationfirledselect I assume is connected to being online or not.

Thank you whitemike! works fine now!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with VB sql	Guns4hire	General vBulletin Support	7	04-06-2007 05:17 PM
Help with sql error	harmor	General vBulletin Support	5	03-23-2006 02:56 PM
Got one sql error....plz help...	mant3ra	General vBulletin Support	6	11-27-2005 04:43 PM
ThanksBot v1.0 sql error :(	mant3ra	General vBulletin Support	0	11-07-2005 02:47 PM
sanitize input for sql	Idan	General vBulletin Support	0	09-29-2005 03:05 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)