Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
7 registered (AllenAyres, Angie P, Harold, Island Piper, jmt123, Rick, Ultimatelunker), 20 Guests and 28 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 02/14/08
Posts: 2
Top Posters (30 Days)
Rick 110
Gizmo 100
Thelockman 57
driv 50
AllenAyres 40
Morgan 39
blaaskaak 30
ntdoc 28
flyboy105 28
ScriptKeeper 27
Latest Photos
XTERRA K9 Challenge
DEG Metro Stars: Jamie Storr
My new girlfriend
testing photo upload in ie7
Fall foilage in New England
Topic Options
Rate This Topic
#202384 - 12/03/07 02:34 AM Using Watch Lists gives SQL error
Yomar Offline
member

Registered: 09/02/04
Posts: 157
Loc: Leiden, The Netherlands
When I try to add forums to my Watch Lists, I get the following error:

 Code:
We encountered a problem. The reason reported was 
Script: /var/www/vhosts/www.forumsatril.com/HTML/ubbthreads7/scripts/tab_forums.inc.php
Line#: 113
SQL 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 8
SQL Error #: 1064
Query: select t.TOPIC_ID,t.POST_ID,t.USER_ID,t.TOPIC_SUBJECT,t.TOPIC_ICON,t.TOPIC_CREATED_TIME,u.USER_DISPLAY_NAME,t.TOPIC_LAST_REPLY_TIME,t.FORUM_ID from ubbt_TOPICS as t, ubbt_USERS as u where TOPIC_IS_APPROVED = '1' and t.USER_ID = u.USER_ID and t.FORUM_ID IN ( '1', '2', '3', '4' ) order by t.TOPIC_LAST_REPLY_TIME desc limit 

Please click back to return to the previous page. 


Help?

Top
#202385 - 12/03/07 02:49 AM Re: Using Watch Lists gives SQL error [Re: Yomar]
Yomar Offline
member

Registered: 09/02/04
Posts: 157
Loc: Leiden, The Netherlands
Sorry, just noticed this is a known bug already. Fixed!

Top


Shout Box

Today's Birthdays
The Spin Master
Recent Topics
Make this topic a global announcement
by Morgan
Today at 01:35 PM
Duplicanting moderators
by ehm1
Today at 11:25 AM
Utimate Lunker
by Ultimatelunker
Today at 09:17 AM
Subject line and Watched topics in Quick Reply form?
by medencev
Today at 06:35 AM
Moderators can't read despite the moderators settings are ok
by Morgan
Today at 03:14 AM
Forum Stats
4094 Members
33 Forums
30219 Topics
153009 Posts

Max Online: 978 @ 06/24/07 08:19 PM