|
Joined: May 2009
Posts: 16
stranger
|
stranger
Joined: May 2009
Posts: 16 |
Hi everyone. Thanks for your help yesterday. I have a couple of additional problems after upgrading from classic to threads. I'm looking to solve this one first: Members seem to have access to everything and things are working AOK, but when Guests log in, they get this message when clicking on a topic:
UBB Message We encountered a problem. The reason reported was Database error only visible to forum administrators
I see in the Control Panel where you can allow Guests to view the Forum and see Topics, but am I missing where you can give the,m access to view Posts? I went back over all of the permissions and think I have it right, but the error persists.
Help! :-)
Bernie
|
|
|
|
Joined: Nov 2006
Posts: 40
newbie
|
newbie
Joined: Nov 2006
Posts: 40 |
Hi again. Just to be absolutely sure where we're starting from: in the Control Panel, under Permissions - Forum Permissions, under "Can read topic", you have a 1 in the box for Guests? That said, even if the 1 is NOT set for Guests, it shouldn't throw a database ERROR, just block viewing... hmmm!
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Best thing to do would be to setup MySQL logging in the control panel so you can view what the MySQL error is. If we can see the actual error, then we'll probably be able to say what needs to be done.
|
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
Thats what I said yesterday in another post he made. Turn on logging
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: May 2009
Posts: 16
stranger
|
stranger
Joined: May 2009
Posts: 16 |
Here's the report:
Script: /home/vg004web01/29/25/1032529/web/ubbthreads/scripts/postlist.inc.php - Line: 522 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,t3.USER_GROUP_IMAGES 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 = 6 and t1.TOPIC_IS_STICKY = '0'
AND t1.TOPIC_IS_APPROVED = '1' ORDER BY t1.TOPIC_LAST_REPLY_TIME desc LIMIT - 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
Bernie
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
It looks like there is no default setting for either topics per page, or posts per page. Go through the Display Option -> General Settings in the Control Panel. Specifically look at the Forum and Topic Settings and make sure there are values set for the defaults.
|
|
|
|
Joined: May 2009
Posts: 16
stranger
|
stranger
Joined: May 2009
Posts: 16 |
Fantastic! That worked :-)
Many thanks!
Bernie
|
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
Just a heads up Bernie. If you had issues with this setting. You may want to go thru some of the other settings in the control panel. Even if they look correct select submit in the form. That will force the script to update the database. Just in case you have other settings that did not update the database correctly.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
1 members (Ruben),
667
guests, and
166
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|