Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
7 registered (smallufo, SteveS, sampsonzurich, Bjab, FordDoctor, Stan, Pilgrim), 27 Guests and 13 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 05/17/12
Posts: 3
Top Posters (30 Days)
Ruben 51
Gizmo 24
DennyP 24
Dunny 15
SteveS 14
AllenAyres 12
SD 10
dbremer 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#211730 - 05/11/08 07:20 AM 7.3 - Threads suddenly not displaying headers/footer/new post indicators etc....
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
Hi,

On my copy of threads nothing from the config.inc.php is being read.

When I view the file within the CP all boxes are blank.

Yet, when I view config.inc.php in a file viewer all the data is there.

As a result, I have no header, footer, new post indicator etc., showing. Nor do I have a post count against the top posters, and the quick reply box is also missing.

The only advantage is that the forums are loading much faster LOL

Any suggestions as to why this has suddenly happened?

I have checked that the file has 777 permissions etc.

Looking at my error log I am seeing....

Code:
[ERROR][Sun, May 11 2008 12:05:52 +0100] [] [] Script: /path/to/forums/scripts/postlist.inc.php - Line: 524 
		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 = 14
		and t1.TOPIC_IS_STICKY = '0'
		
		AND t1.TOPIC_IS_APPROVED = '1'
		ORDER BY t1.TOPIC_CREATED_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



and

Code:
[ERROR][Sun, May 11 2008 12:05:46 +0100] [] [] Script: /path/to/forums/scripts/showflat.inc.php - Line: 647 
		SELECT	p.POST_ID, u.USER_DISPLAY_NAME, p.POST_POSTED_TIME, p.POST_POSTER_IP,
			p.POST_SUBJECT, p.POST_BODY, p.POST_IS_APPROVED, up.USER_AVATAR, up.USER_TITLE,
			up.USER_CUSTOM_TITLE, up.USER_NAME_COLOR, p.POST_ICON, p.POST_HAS_POLL,
			p.POST_HAS_FILE, p.POST_PARENT_ID, u.USER_MEMBERSHIP_LEVEL, up.USER_SIGNATURE,
			p.POST_LAST_EDITED_TIME, p.POST_LAST_EDIT_REASON, p.POST_LAST_EDITED_BY,
			up.USER_LOCATION, up.USER_TOTAL_POSTS, u.USER_REGISTERED_ON, up.USER_RATING,
			up.USER_AVATAR_WIDTH, up.USER_AVATAR_HEIGHT, u.USER_ID, p.POST_PARENT_USER_ID,
			up.USER_BIRTHDAY, up.USER_PUBLIC_BIRTHDAY, p.POST_ADD_SIGNATURE, up.USER_ACCEPT_PM,
			up.USER_HOMEPAGE, up.USER_VISIBLE_ONLINE_STATUS, up.USER_MOOD, p.POST_POSTER_NAME
		FROM	ubbt_POSTS AS p,
			ubbt_USERS AS u,
			ubbt_USER_PROFILE as up
		WHERE	p.TOPIC_ID  = 126746
			AND p.USER_ID = u.USER_ID
			AND p.USER_ID = up.USER_ID
			AND p.POST_IS_APPROVED = '1'
		ORDER BY p.POST_ID
	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 18



Ironically I am seeing custom headers in forums that have a custom header.

Anyone have any suggestions??

Thanks
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#211731 - 05/11/08 07:54 AM Re: 7.3 - Threads suddenly not displaying headers/footer/new post indicators etc.... [Re: Ian]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
Okay - uploaded backup copies of header.php, footer.php, and config.inc.php.

This got everything working again, to a degree - the header, footer, header insert files were all blank.

However when I try and update admin/gen_display.php I get

Forbidden
You do not have permission to access this document.

Also when I view /admin/phpinfo.php

I get

Forbidden
You do not have permission to access this document.

I can update say admin/features.php without any issues. I cannot see any permissions issues and have re-uploaded the files.

Running

mysql 5.0.22
php 5.1.6


All very strange frown
Top
#211747 - 05/11/08 10:58 AM Re: 7.3 - Threads suddenly not displaying headers/footer/new post indicators etc.... [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
The 2 SQL errors appear to be someone visiting showflat and they don't have a limit set for the number of topics per page. I'm guessing since the config file wasn't working, it couldn't use the config default.

As for the the Forbidden errors. What permissions are set on the scripts giving those errors. I know you said you can't see any issues, but just checking if they are the same as the ones that are working.
Top
#211755 - 05/11/08 11:18 AM Re: 7.3 - Threads suddenly not displaying headers/footer/new post indicators etc.... [Re: Rick]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
currently 666

exactly the same permissions as admin/dofeatures.php which works fine.
Top
#211759 - 05/11/08 12:00 PM Re: 7.3 - Threads suddenly not displaying headers/footer/new post indicators etc.... [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
You wouldn't happen to have mod_security enabled would you?
Top
#211770 - 05/11/08 02:08 PM Re: 7.3 - Threads suddenly not displaying headers/footer/new post indicators etc.... [Re: Rick]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
Thank you laugh

Forgot that frown
Top
#211788 - 05/11/08 06:58 PM Re: 7.3 - Threads suddenly not displaying headers/footer/new post indicators etc.... [Re: Rick]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
Originally Posted By: Rick
You wouldn't happen to have mod_security enabled would you?
Ahh the grand solution I bring to the table... lol... god I hate this module!
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#211802 - 05/12/08 01:29 AM Re: 7.3 - Threads suddenly not displaying headers/footer/new post indicators etc.... [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
Yes, but why affect these two sections and not other ones?
Top
#211806 - 05/12/08 02:48 AM Re: 7.3 - Threads suddenly not displaying headers/footer/new post indicators etc.... [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
Certain words in a page will make mod_security barf... It's a truely horrible module that bans even the most harmless scripts...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Due Date Calculator-Calculate When Your Baby is Due
by StewartMyduedate
12:54 AM
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image