Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
7 Registered (auduntvedt, blaaskaak, GEN™, Grummel, Jake, mcasado, 1 invisible), 16 Guests and 20 Spiders online.
Key: Admin, Global Mod, Mod
Top Posters
Gizmo 11702
Rick 7567
Ian 4107
Mark S 3983
ntdoc 3110
Sirdude 2041
jgeoff 1882
David Dreezer 1759
driv 1568
AllenAyres 1529
Latest Photos
Carrie - So Very
Testing
Test Photo
4TH of July at the river!
Test shots from D300 part 3
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: 7567
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: 3110
So does everything seem okay now?

Top


Shout Box

Recent Topics
Changing title of forum
by Baby Boomer
Today at 07:38 AM
Disable PM's for one group
by Musky
Today at 07:10 AM
SQL Error: Got error 28 from storage engine ?
by jgeoff
Yesterday at 05:03 PM
Stop All E-mail
by Mark S
Yesterday at 11:16 AM
Ability to Truncate a thread from any point at any time.
by Naz
Yesterday at 07:37 AM
Forum Stats
4025 Members
33 Forums
30880 Topics
156803 Posts

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