|
|
Joined: Jun 2006
Posts: 136
member
|
|
member
Joined: Jun 2006
Posts: 136 |
Sat, Mar 24 2007 12:03:10 +0800
Veen Script: /home/webadmin/jakchat.com/html/forums/scripts/showmembers.inc.php - Line: 215
SELECT t1.USER_DISPLAY_NAME,t1.USER_REGISTERED_ON,t2.USER_HOMEPAGE,t2.USER_TOTAL_POSTS,t1.USER_MEMBERSHIP_LEVEL,t1.USER_ID,t2.USER_AVATAR,t2.USER_AVATAR_WIDTH,t2.USER_AVATAR_HEIGHT
FROM ubbt_USERS as t1,
ubbt_USER_PROFILE as t2
WHERE t1.USER_IS_APPROVED = 'yes'
AND t1.USER_ID <> 1
AND t1.USER_IS_BANNED = '0'
AND t1.USER_ID = t2.USER_ID
AND (t1.USER_IS_UNDERAGE <> '1' OR t1.USER_IS_UNDERAGE IS NULL)
AND t1.USER_DISPLAY_NAME LIKE 'p%'
ORDER BY t1.USER_DISPLAY_NAME ASC
LIMIT -25, 25
- 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 '-25, 25' at line 11
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Hmm, that's an odd one. Seems the limit statement is messed up. Did this show up on the first page or on a subsequent page of the results?
|
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
|
member
Joined: Jun 2006
Posts: 136 |
this was the first entry in a log file. it seems i get MySQL errors logged nearly every single day.
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Ok, so what I did for this is put a check in place to make sure the limit statement can never contain a negative value.
|
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
|
member
Joined: Jun 2006
Posts: 136 |
this may be related, or it may be different. below is a series of MySQl errors that happened at about the same time, once again involving activetopics: Wed, Mar 28 2007 02:47:52 +0800
87.118.106.4 Script: /home/webadmin/jakchat.com/html/forums/scripts/activetopics.inc.php - Line: 137
select t1.FORUM_ID,t1.FORUM_TITLE,t3.POST_SUBJECT,t3.POST_ICON,t3.POST_POSTED_TIME,t2.TOPIC_LAST_POSTER_NAME,t3.POST_BODY,t2.TOPIC_ID,t3.POST_ID
from ubbt_FORUMS as t1,
ubbt_TOPICS as t2,
ubbt_POSTS as t3
where t1.FORUM_ID in()
and t2.TOPIC_LAST_REPLY_TIME > 1174931272
and t2.FORUM_ID = t1.FORUM_ID
and t2.TOPIC_IS_APPROVED = 1
and t2.TOPIC_LAST_POST_ID = t3.POST_ID
order by t2.TOPIC_LAST_REPLY_TIME desc
limit 25
- 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 ')
and t2.TOPIC_LAST_REPLY_TIME > 1174931272
and t2.FORUM_ID
Wed, Mar 28 2007 02:47:57 +0800
87.118.106.4 Script: /home/webadmin/jakchat.com/html/forums/scripts/activetopics.inc.php - Line: 137
select t1.FORUM_ID,t1.FORUM_TITLE,t3.POST_SUBJECT,t3.POST_ICON,t3.POST_POSTED_TIME,t2.TOPIC_LAST_POSTER_NAME,t3.POST_BODY,t2.TOPIC_ID,t3.POST_ID
from ubbt_FORUMS as t1,
ubbt_TOPICS as t2,
ubbt_POSTS as t3
where t1.FORUM_ID in()
and t2.TOPIC_LAST_REPLY_TIME > 1174844877
and t2.FORUM_ID = t1.FORUM_ID
and t2.TOPIC_IS_APPROVED = 1
and t2.TOPIC_LAST_POST_ID = t3.POST_ID
order by t2.TOPIC_LAST_REPLY_TIME desc
limit 25
- 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 ')
and t2.TOPIC_LAST_REPLY_TIME > 1174844877
and t2.FORUM_ID
Wed, Mar 28 2007 02:48:02 +0800
87.118.106.4 Script: /home/webadmin/jakchat.com/html/forums/scripts/activetopics.inc.php - Line: 137
select t1.FORUM_ID,t1.FORUM_TITLE,t3.POST_SUBJECT,t3.POST_ICON,t3.POST_POSTED_TIME,t2.TOPIC_LAST_POSTER_NAME,t3.POST_BODY,t2.TOPIC_ID,t3.POST_ID
from ubbt_FORUMS as t1,
ubbt_TOPICS as t2,
ubbt_POSTS as t3
where t1.FORUM_ID in()
and t2.TOPIC_LAST_REPLY_TIME > 1174412882
and t2.FORUM_ID = t1.FORUM_ID
and t2.TOPIC_IS_APPROVED = 1
and t2.TOPIC_LAST_POST_ID = t3.POST_ID
order by t2.TOPIC_LAST_REPLY_TIME desc
limit 25
- 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 ')
and t2.TOPIC_LAST_REPLY_TIME > 1174412882
and t2.FORUM_ID
|
|
|
|
0 members (),
563
guests, and
80
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
