Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
5 registered (cascadeclimbers, DougMM, Gizmo, smallufo, Thelockman), 30 Guests and 21 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 09/18/08
Posts: 9
Top Posters (30 Days)
Ruben Rocha 179
Gizmo 112
Rick 106
Thelockman 79
driv 43
AllenAyres 35
ntdoc 28
Ian 24
Sirdude 23
ScriptKeeper 20
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
Topic Options
Rate This Topic
#212290 - 05/15/08 04:54 AM SQL Errors?
badfrog Offline
newbie

Registered: 05/13/08
Posts: 35
ok, upgraded to 7.3 yesterday, some users are gettign SQL errors, I was able to duplicate it myself finally by using firefox and trying to browse the forums while not logged in.

UBB Message
We encountered a problem. The reason reported was

Script: /var/www/virtual/v/a/vannin.com/www/threads/scripts/postlist.inc.php
Line#: 520
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 14
SQL Error #: 1064
Query: 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 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 left join ubbt_POSTS as t4 on t1.POST_ID = t4.POST_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

Please click back to return to the previous page.

Top
#212306 - 05/15/08 06:09 AM Re: SQL Errors? [Re: badfrog]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7903
Loc: Aberdeen, WA
Responded in opened support ticket. You'll want to check in the control panel under Display Options -> Primary -> TOpic Display Options, check to make sure that the Default Replies Per Page has a value, default is normally 10.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#212330 - 05/15/08 08:17 AM Re: SQL Errors? [Re: Rick]
badfrog Offline
newbie

Registered: 05/13/08
Posts: 35
did that, will see what happens.

Top
#212502 - 05/16/08 11:58 AM Re: SQL Errors? [Re: badfrog]
ntdoc Offline

***

Registered: 11/08/06
Posts: 3202
So does everything seem okay now?

Top


Shout Box

Today's Birthdays
No Birthdays
Recent Topics
I'm the Admin but.....
by David DelMonte
Today at 11:12 AM
Fatal error: Smarty::require_once
()

by ThreadsUser
Today at 08:17 AM
PayPal batch file for ID'ing expired and failed payment subscriptions?
by Mitch P.
Today at 06:02 AM
Shrinking graemlins
by Djuma
Yesterday at 05:48 PM
2 problems I'm seeing now.
by DougMM
Yesterday at 04:39 PM
Forum Stats
4261 Members
33 Forums
30535 Topics
154978 Posts

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