I'm getting errors in my error log now that I've upgraded to 7.5.7. They read:
Sun, Dec 16 2012 04:44:11 -0500
Script: E:\forums\scripts\postlist.inc.php - Line: 511
select t1.TOPIC_ID,t1.POST_ID,t2.USER_DISPLAY_NAME,t1.TOPIC_CREATED_TIME,t1.TOPIC_LAST_REPLY_TIME,t1.TOPIC_SUBJECT,
t1.TOPIC_STATUS,t1.TOPIC_IS_APPROVED,t1.TOPIC_ICON,t1.TOPIC_VIEWS,t1.TOPIC_REPLIES,t1.TOPIC_TOTAL_RATES,
t1.TOPIC_RATING,t3.USER_NAME_COLOR,t2.USER_MEMBERSHIP_LEVEL,t1.USER_ID,t1.TOPIC_IS_STICKY,t1.TOPIC_LAST_POSTER_ID,
t1.TOPIC_LAST_POSTER_NAME,t1.TOPIC_LAST_POST_ID,t1.TOPIC_IS_EVENT,t1.TOPIC_HAS_FILE,t1.TOPIC_HAS_POLL,t1.TOPIC_POSTER_NAME,t1.TOPIC_THUMBNAIL,t4.POST_BODY,t3.USER_GROUP_IMAGES
from ubbt7_TOPICS as t1
left join ubbt7_USERS as t2 on t1.USER_ID = t2.USER_ID
left join ubbt7_USER_PROFILE as t3 on t1.USER_ID = t3.USER_ID
left join ubbt7_POSTS as t4 on t1.POST_ID = t4.POST_ID
where t1.FORUM_ID = 175
and t1.TOPIC_IS_STICKY = '0'
AND t1.TOPIC_IS_APPROVED = '1'
ORDER BY t1.TOPIC_LAST_REPLY_TIME desc
LIMIT -20, 11
- 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 '-20, 11' at line 14
My reading of the SQL syntax finds:
"LIMIT takes one or two numeric arguments, which must both be nonnegative integer constants (except when using prepared statements)."
So the -20 is negative. Is this considered a "prepared statement"?