Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
5 Registered (David Dreezer, Djuma, LarE, MikeBTech, Sirdude), 17 Guests and 18 Spiders online.
Key: Admin, Global Mod, Mod
Top Posters
Gizmo 11647
Rick 7499
Ian 4092
Mark S 3969
ntdoc 3089
Sirdude 2027
jgeoff 1876
David Dreezer 1744
driv 1541
AllenAyres 1506
Latest Photos
Sunflower Photo
Testing
Test Photo
4TH of July at the river!
Sunflower Photo
Topic Options
Rate This Topic
#212290 - 05/15/08 04:54 AM SQL Errors?
badfrog Offline
newbie

Registered: 05/13/08
Posts: 34
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: 7499
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: 34
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: 3089
So does everything seem okay now?

Top


Shout Box

Recent Topics
Anyone know anything about phpbb versioning?
by David Dreezer
Today at 12:43 PM
How Customizable is the Look?
by flyboy105
Today at 11:48 AM
Ex-Google architect launches rival search engine
by ScriptKeeper
Today at 09:54 AM
Is it possible to show 1 category heading but not the forums?
by ScriptKeeper
Today at 08:40 AM
Using the USERS DB for other app login verification
by ThomasM
Today at 07:02 AM
Forum Stats
3999 Members
33 Forums
30783 Topics
156296 Posts

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