PDA

View Full Version : error trouble


salata
09-18-2007, 01:43 PM
Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT username as un, field15 FROM userfield uf, user u WHERE
u.userid = uf.userid and
uf.userid IN (,575);

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 '575)' at line 3
Error Number : 1064
Date : Tuesday, September 18th 2007 @ 10:36:38 AM
Script : http://xxx.com/forums/index.php
Referrer : http://xxx.com/forums/admincp/index.php?do=head
IP Address : x.x.x.x
Username : Salata


can someone tell me where this error is located? it pops up randomly

ericgtr
09-18-2007, 06:00 PM
From the looks of it, it's most likely a mod that is calling up field15. Check out your User Profile Fields in the Admin CP and see what is in field15, that will probably point you into the direction of the mod. At least that way you can disable it until you get it sorted.

Paul M
09-18-2007, 06:05 PM
You have a faulty modification installed.

The actual error is the value missing from the IN(,575).

salata
09-19-2007, 04:11 PM
is there anyway to pin point this error? i undone changes i made and i still get that error but this changes all the time now IN (,575); the number always changes

Paul M
09-19-2007, 06:30 PM
Disable all your modifications. Upload the original index.php