help please. sql error

[GigaSb]

Invalid SQL:

SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb
FROM userlist AS userlist
INNER JOIN user AS user ON (user.userid = userlist.relationid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)

WHERE userlist.userid = 17
AND userlist.type = 'buddy'
AND userlist.friend = 'yes'
LIMIT 0,;

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 '' at line 10
Error Number : 1064
Request Date : Sunday, February 15th 2009 @ 08:40:43 AM
Error Date : Sunday, February 15th 2009 @ 08:40:43 AM
Script : http://mysite.co.il/friends.php?u=17
Referrer : http://mysite.co.il/showthread.php?t=660
IP Address : XX.XXX.X.XXX
Username : Splinter
Classname : vB_Database
MySQL Version :

[Lynne]

Try disabling your plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

PHP Code:

define('DISABLE_HOOKS', true); 


[GigaSb]

i only got it 1 time to my mail.. website is running..

[GigaSb]

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb
FROM userlist AS userlist
INNER JOIN user AS user ON (user.userid = userlist.relationid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)

WHERE userlist.userid = 17
AND userlist.type = 'buddy'
AND userlist.friend = 'yes'
LIMIT 0,;

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 '' at line 10
Error Number : 1064
Request Date : Wednesday, February 18th 2009 @ 07:18:07 PM
Error Date : Wednesday, February 18th 2009 @ 07:18:07 PM
Script : http://site.co.il/friends.php?u=17
Referrer : http://site.co.il/index.php
IP Address : XX.XXX.195.76
Username : Splinter
Classname : vB_Database

well.. again.. x2 times to my email
disabling the plugins will make my mods not to work ??

[Lynne]

It is a problem with your modification. You should post in the modification thread for help with the error or read the thread and see if it's already been addressed.

[GigaSb]

but to what modification its belong to ?

[Marco van Herwaarden]

Script : http://site.co.il/friends.php?u=17

friends.php is not a default vBulletin file.

[GigaSb]

ok, problem solved thanks.