| No footer on page when logged out - why?... [message #22084] |
Wed, 12 January 2005 23:29  |
welshchris
Messages: 35
Registered: December 2004
Karma: 0
|
Member |
|
|
.... for some reason the footer will not appear on any forum pages when I'm viewing whilst logged out - Is there an obvious reason for this or have I made a cockup somewhere? 
When trying to read messages when logged out, I get the following error, but not when viewing the index page:
-----------
Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /var/www/html/arsenalw/fudforum/index.php on line 58
-----------
Are the two things related?
Have a look at http://www.awimb.com/fudforum/ and you'll see what I mean.
Chris
[Updated on: Wed, 12 January 2005 23:31] Report message to a moderator |
|
|
|
| Re: No footer on page when logged out - why?... [message #22098 is a reply to message #22084] |
Fri, 14 January 2005 18:23  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Sounds like there is an error occuring causing the forum's execution to stop prematurely. Check the forum's error viewer control panel to see what is the actual SQL error that is occuring.
FUDforum Core Developer
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Thanks, but... [message #22223 is a reply to message #22220] |
Fri, 21 January 2005 14:32 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Just download and run the upgrade script if you want to upgrade your forum.
FUDforum Core Developer
|
|
|
|
|
|
| Re: Ilia... [message #22227 is a reply to message #22224] |
Fri, 21 January 2005 15:07 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
You need to download 2.6.10RC1 upgrade script.
FUDforum Core Developer
|
|
|
|
| Done... [message #22228 is a reply to message #22227] |
Fri, 21 January 2005 15:33 |
welshchris
Messages: 35
Registered: December 2004
Karma: 0
|
Member |
|
|
... but with major problems.
Ran the upgrade script as per instructions, BUT:
1). It has over-written all of my modified CSS  (Can I just recover the old .css file from the backup?)
2). I now get an error and am unable to read any messages while logged in to the forum:
--------------------
(/var/www/html/arsenalw/fudforum/index.php:125
/var/www/html/arsenalw/fudforum/index.php:221
/var/www/html/arsenalw/fudforum/theme/default/tree.php:705
/var/www/html/arsenalw/fudforum/index.php:1174
) 1064: 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 'AND tr.user_id=2 LEFT JOIN fud26_read r ON r.thread_id=t.id AND r.user_id=' at line 17
Query: SELECT c.id AS cat_id, f.name, m.subject, t.id, t.forum_id, t.replies, t.rating, t.n_rating, t.root_msg_id, t.moved_to, t.thread_opt, t.root_msg_id, t.last_post_date, tn.thread_id AS subscribed, mo.forum_id AS md, tr.thread_id AS cant_rate, r.last_view, r2.last_view AS last_forum_view, tv.pos AS th_pos, tv.page AS th_page, m2.thread_id AS last_thread, (CASE WHEN g2.id IS NOT NULL THEN g2.group_cache_opt ELSE g1.group_cache_opt END) AS group_cache_opt FROM fud26_thread t INNER JOIN fud26_msg m ON m.id=t.root_msg_id INNER JOIN fud26_forum f ON f.id=t.forum_id INNER JOIN fud26_cat c ON f.cat_id=c.id INNER JOIN fud26_thread_view tv ON tv.forum_id=t.forum_id AND tv.thread_id=t.id INNER JOIN fud26_msg m2 ON f.last_post_id=m2.id LEFT JOIN fud26_thread_notify tn ON tn.user_id=2 AND tn.thread_id=109 LEFT JOIN fud26_mod mo ON mo.user_id=2 AND mo.forum_id=t.forum_id LEFT JOIN fud26_thread_rate_track tr ON tr.thread_id= AND tr.user_id=2 LEFT JOIN fud26_read r ON r.thread_id=t.id AND r.user_id=2 LEFT JOIN fud26_forum_read r2 ON r2.forum_id=t.forum_id AND r2.user_id=2 INNER JOIN fud26_group_cache g1 ON g1.user_id=2147483647 AND g1.resource_id=f.id LEFT JOIN fud26_group_cache g2 ON g2.user_id=2 AND g2.resource_id=f.id WHERE t.id=109
_GET: t=tree&goto=523&rid=2&S=c812a815de61cd4faee8dee08db4387e&
Server Version: 4.1.8-log
[Referring Page] http://www.awimb.com/fudforum/index.php?t=threadt&frm_id=1&rid=2&am p;S=c812a815de61cd4faee8dee08db4387e
--------------------
Something is wrong - How do I fix it?
PLEASE reply to my mails about opening a support contract Ilia! - I will go insane soon trying to sort this out myself! 
Chris
|
|
|
|
|
|
|
|
| Re: Done... [message #22231 is a reply to message #22230] |
Fri, 21 January 2005 18:29 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
the directory backup starts with a ., which makes it invisible to some ftp clients. Since you only need the forum.css.tmpl file, you can simply download it via the forum's file manager.
FUDforum Core Developer
|
|
|
|
|
|
| Re: Done... [message #22233 is a reply to message #22232] |
Fri, 21 January 2005 21:02 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
That directory definately does exist, the forum NEVER removes backups of templates.
You can make a simple webscript that will show you the full path to the file.
<?php
require "./GLOBALS.php";
echo shell_exec("ls -lia {$DATA_DIR}/errors/.backup/forum.css.tmpl*");
?>
FUDforum Core Developer
|
|
|
|
| Re: Done... [message #22234 is a reply to message #22233] |
Fri, 21 January 2005 22:12 |
welshchris
Messages: 35
Registered: December 2004
Karma: 0
|
Member |
|
|
Ilia - I ran the script which gives the path as:
/var/www/html/arsenalw/FUDforum_data//errors/.backup/forum.css.tmpl_1106320 997
However, it does not appear my ftp program (what's with the 'double slash'?) and it doesn't appear in the forum file manager either 
The only way I could get the file was to make a link out of the url and download it that way, then reload to the correct place.
Thanks
Chris
[Updated on: Fri, 21 January 2005 22:19] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]