PDA

View Full Version : help please. sql error

GigaSb
02-15-2009, 04:39 AM
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
02-15-2009, 04:54 AM
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

define('DISABLE_HOOKS', true);
GigaSb
02-15-2009, 04:24 PM
i only got it 1 time to my mail.. website is running..
GigaSb
02-18-2009, 08:00 PM
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
02-18-2009, 08:24 PM
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
02-19-2009, 08:03 AM
but to what modification its belong to ?
Marco van Herwaarden
02-19-2009, 09:26 AM
Script : http://site.co.il/friends.php?u=17 (http://site.co.il/friends.php?u=17)

friends.php is not a default vBulletin file.
GigaSb
02-19-2009, 11:57 AM
ok, problem solved thanks.