Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (tradge, id242), 35 Guests and 15 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 12/20/11
Posts: 25
Top Posters (30 Days)
Ruben 49
DennyP 24
Gizmo 23
Dunny 17
SteveS 14
AllenAyres 12
dbremer 10
drkknght00 9
SD 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#170757 - 12/20/06 09:41 PM SQL error -10, 11
Bill B Offline

member
Registered: 10/29/06
Posts: 189
Loc: Issaquah, WA
Getting 5 or 6 of these every day in my error log.

ORDER BY t1.TOPIC_LAST_REPLY_TIME DESC
LIMIT -10, 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 '-10, 11' at line 13
_________________________
--BIll B
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#170760 - 12/20/06 09:46 PM Re: SQL error -10, 11 [Re: Bill B]
ntdoc Offline
Registered: 11/09/06
Posts: 3384
What version of MySQL are you running?
Top
#170779 - 12/20/06 11:55 PM Re: SQL error -10, 11 [Re: ntdoc]
Bill B Offline

member
Registered: 10/29/06
Posts: 189
Loc: Issaquah, WA
V 4.1.21
_________________________
--BIll B
Top
#170813 - 12/21/06 11:14 AM Re: SQL error -10, 11 [Re: Bill B]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
That's odd, it's like missing a good chunk of the actual query. Does it say what script it's coming from?
Top
#170863 - 12/22/06 12:03 PM Re: SQL error -10, 11 [Re: Rick]
Bill B Offline

member
Registered: 10/29/06
Posts: 189
Loc: Issaquah, WA
Script: /home/virtual/site40/fst/var/www/html/forum/scripts/postlist.inc.php - Line: 632
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
from ubbt_TOPICS as t1
left join ubbt_USERS as t2 on t1.USER_ID = t2.USER_ID
left join ubbt_USER_PROFILE as t3 on t1.USER_ID = t3.USER_ID
where t1.FORUM_ID = 1
and t1.TOPIC_IS_STICKY = '0'

AND t1.TOPIC_IS_APPROVED = '1'
ORDER BY t1.TOPIC_LAST_REPLY_TIME DESC
LIMIT -10, 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 '-10, 11' at line 13
_________________________
--BIll B
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33841 Topics
181696 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image