UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support Guests Can't View Posts

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

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!

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.

Thats what I said yesterday in another post he made.
Turn on logging

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

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.

Fantastic! That worked :-)

Many thanks!

Bernie

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.