Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jun 2006
Posts: 136
O
member
member
O Offline
Joined: Jun 2006
Posts: 136
Code
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


Okusi Associates -- Indonesian business and management services
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
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
O
member
member
O Offline
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.


Okusi Associates -- Indonesian business and management services
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
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
O
member
member
O Offline
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:

Code
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 


Okusi Associates -- Indonesian business and management services

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
0 members (), 744 guests, and 147 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)