vBulletin Modifications

SQL Error, Help?

Welcome to vBHackers.com! - vBHackers Updates:

Go Back   vBulletin Modifications > General vBulletin Section > General vBulletin Support

Reply
 
LinkBack Thread Tools
Old 10-04-2007, 07:10 PM   #1
Satan knows what goes
Join Date: Sep 2007
Location: Stalk much?
DevilWearsPrada is on a distinguished road

Default SQL Error, Help?

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.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Old 10-04-2007, 07:11 PM   #2
Junior Member
Join Date: Sep 2005
schussel is on a distinguished road

Default

the resulting sql error message would be waaaaay more helpful




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 10-04-2007, 07:19 PM   #3
Satan knows what goes
Join Date: Sep 2007
Location: Stalk much?
DevilWearsPrada is on a distinguished road

Default

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




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 10-04-2007, 08:14 PM   #4
Michael Biddle
Staff
Michael Biddle's Avatar
Join Date: Feb 2005
Real Name: Michael Biddle
Location: Anaheim
Michael Biddle is on a distinguished road

Default

You must first be a registered member to view any code.
  1. There should not be a table_prefix in the WHERE clause
  2. What is $locationfieldselect?
__________________
Support will ONLY be offered through forums
Michael Biddle / vBHackers.com
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.

Crawlability Network: vBulletin SEO | vBulletin Hackers




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 10-04-2007, 08:33 PM   #5
Satan knows what goes
Join Date: Sep 2007
Location: Stalk much?
DevilWearsPrada is on a distinguished road

Default

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

Thank you whitemike! works fine now!




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

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


All times are GMT -3. The time now is 06:30 AM.


SEO by vBSEO 3.2.0 ©2008, Crawlability, Inc. (Patent Pending)