FUDforum: How To » HELP?

Home » FUDforum » How To » HELP? (Existing Installation stopped working)

Show: Today's Messages :: Polls :: Message Navigator

HELP? [message #165273]

Fri, 20 May 2011 10:40

fordzilla

Messages: 17
Registered: May 2011
Location: Victoria

Karma: 0

Junior Member

Ok,

I have had FudForum up for at least a year now. Recently I upgraded to version 1.7.4 of XAMPP and since then I am unable to open anything to do with my forum. When I go to view the folder that has the forum, I get "The page cannot be displayed". I have checked that access to the folder etc is allowed by copying an image into that folder and am able to access it.

I really don't know what to do right now, and don't want to loose my years worth of forum.

Help?

Report message to a moderator

Re: HELP? [message #165274 is a reply to message #165273]

Fri, 20 May 2011 10:55

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Check for errors in Apache's error.log file.
The path is something like c:\xampp\apache\logs\error.log

Report message to a moderator

Re: HELP? [message #165275 is a reply to message #165274]

Fri, 20 May 2011 11:18

fordzilla

Messages: 17
Registered: May 2011
Location: Victoria

Karma: 0

Junior Member

[Fri May 20 07:39:21 2011] [error] [client 216.232.xxx.xxx] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'ttforum'@'localhost' (using password: YES) in C:\\xampp\\htdocs\\forum\\index.php on line 20
[Fri May 20 07:39:21 2011] [error] [client 216.232.xxx.xxx] PHP Warning: mysql_error() expects parameter 1 to be resource, string given in C:\\xampp\\htdocs\\forum\\index.php on line 20
[Fri May 20 07:39:21 2011] [error] [client 216.232.xxx.xxx] PHP Warning: mysql_errno() expects parameter 1 to be resource, string given in C:\\xampp\\htdocs\\forum\\index.php on line 20
[Fri May 20 07:39:21 2011] [error] [client 216.232.xxx.xxx] PHP Fatal error: SQL Error has occurred, please contact the <a href="mailto:admin(at)prodieselperformance(dot)com?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in C:\\xampp\\htdocs\\FUDforum\\include\\core.inc on line 201
[Fri May 20 07:39:21 2011] [error] [client 216.232.xxx.xxx] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'ttforum'@'localhost' (using password: YES) in C:\\xampp\\htdocs\\forum\\index.php on line 20
[Fri May 20 07:39:21 2011] [error] [client 216.232.xxx.xxx] PHP Warning: mysql_error() expects parameter 1 to be resource, string given in C:\\xampp\\htdocs\\forum\\index.php on line 20
[Fri May 20 07:39:21 2011] [error] [client 216.232.xxx.xxx] PHP Warning: mysql_errno() expects parameter 1 to be resource, string given in C:\\xampp\\htdocs\\forum\\index.php on line 20
[Fri May 20 07:39:21 2011] [error] [client 216.232.xxx.xxx] PHP Fatal error: SQL Error has occurred, please contact the <a href="mailto:admin(at)prodieselperformance(dot)com?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in C:\\xampp\\htdocs\\FUDforum\\include\\core.inc on line 201
[Fri May 20 07:39:21 2011] [error] [client 216.232.xxx.xxx] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'ttforum'@'localhost' (using password: YES) in C:\\xampp\\htdocs\\forum\\index.php on line 20
[Fri May 20 07:39:21 2011] [error] [client 216.232.xxx.xxx] PHP Warning: mysql_error() expects parameter 1 to be resource, string given in C:\\xampp\\htdocs\\forum\\index.php on line 20
[Fri May 20 07:39:21 2011] [error] [client 216.232.xxx.xxx] PHP Warning: mysql_errno() expects parameter 1 to be resource, string given in C:\\xampp\\htdocs\\forum\\index.php on line 20
[Fri May 20 07:39:21 2011] [error] [client 216.232.xxx.xxx] PHP Fatal error: SQL Error has occurred, please contact the <a href="mailto:admin(at)prodieselperformance(dot)com?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in C:\\xampp\\htdocs\\FUDforum\\include\\core.inc on line 201
[Fri May 20 07:39:21 2011] [error] [client 216.232.xxx.xxx] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'ttforum'@'localhost' (using password: YES) in C:\\xampp\\htdocs\\forum\\index.php on line 20
[Fri May 20 07:39:21 2011] [error] [client 216.232.xxx.xxx] PHP Warning: mysql_error() expects parameter 1 to be resource, string given in C:\\xampp\\htdocs\\forum\\index.php on line 20
[Fri May 20 07:39:21 2011] [error] [client 216.232.xxx.xxx] PHP Warning: mysql_errno() expects parameter 1 to be resource, string given in C:\\xampp\\htdocs\\forum\\index.php on line 20
[Fri May 20 07:39:21 2011] [error] [client 216.232.xxx.xxx] PHP Fatal error: SQL Error has occurred, please contact the <a href="mailto:admin(at)prodieselperformance(dot)com?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in C:\\xampp\\htdocs\\FUDforum\\include\\core.inc on line 201

Report message to a moderator

Re: HELP? [message #165276 is a reply to message #165275]

Fri, 20 May 2011 11:20

fordzilla

Messages: 17
Registered: May 2011
Location: Victoria

Karma: 0

Junior Member

Now I did have a problem with MYSQL going down, I preserved my databases and re-installed. Is this a username/password issue into MYSQL? How can I get back into fudforum and ensure that the database, username, and password are correct for MYSQL??

Report message to a moderator

Re: HELP? [message #165277 is a reply to message #165276]

Fri, 20 May 2011 11:36

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Yes, FUDforum cannot connect to the database. Please check if your MySQL datababase, userid and password matches your DB parameters in include/GLOBALS.php.

Report message to a moderator

Re: HELP? [message #165278 is a reply to message #165277]

Fri, 20 May 2011 12:05

fordzilla

Messages: 17
Registered: May 2011
Location: Victoria

Karma: 0

Junior Member

Ok, wooo Hooo! Got it back up! Thank you so much! Now... What if I want to duplicate that forum, and move it to another directory, and create another forum similar? Where can I change all the path information and DB information to do this? (Is that the GLOBALS section? Or is it not possible?)

Thanks,

Report message to a moderator

Re: HELP? [message #165284 is a reply to message #165278]

Fri, 20 May 2011 14:05

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

The first step is obviously to take a backup (files & DB). Copy all the files and fix-up your paths in the GLOBALS.php. When done, run a consistency check.

Report message to a moderator

Re: HELP? [message #165287 is a reply to message #165284]

Fri, 20 May 2011 16:06

fordzilla

Messages: 17
Registered: May 2011
Location: Victoria

Karma: 0

Junior Member

Stupid question, how do you run a consistency check?

Report message to a moderator

Re: HELP? [message #165288 is a reply to message #165287]

Fri, 20 May 2011 16:29

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

ACP -> Forum Consistency.

Report message to a moderator

Re: HELP? [message #165289 is a reply to message #165288]

Fri, 20 May 2011 17:28

fordzilla

Messages: 17
Registered: May 2011
Location: Victoria

Karma: 0

Junior Member

I got it all figured out! Thanks everyone for the help!

Report message to a moderator

Re: HELP? [message #165290 is a reply to message #165289]

Fri, 20 May 2011 21:32

fordzilla

Messages: 17
Registered: May 2011
Location: Victoria

Karma: 0

Junior Member

Now I am getting this when I try to access the forum externally:

Fri May 20 17:50:51 2011] [error] [client 50.92.198.144] PHP Fatal error: SQL Error has occurred, please contact the <a href="mailto:admin(at)prodieselperformance(dot)com?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in C:\\xampp\\htdocs\\FUDforum\\include\\core.inc on line 201, referer: http://www.prodieselperformance.com/forum/
[Fri May 20 17:50:54 2011] [error] [client 50.92.198.144] PHP Fatal error: SQL Error has occurred, please contact the <a href="mailto:admin(at)prodieselperformance(dot)com?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in C:\\xampp\\htdocs\\FUDforum\\include\\core.inc on line 201, referer: http://www.prodieselperformance.com/forum/

But it works fine from localhost. Any ideas?

[Updated on: Fri, 20 May 2011 21:32]

Report message to a moderator

Re: HELP? [message #165291 is a reply to message #165290]

Sat, 21 May 2011 05:15

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

My guess, you need to fix your cookie settings in GLOBALS.php.

If not, check your SQL error log (.../errors/sql_errors) and post the last entry here.

Report message to a moderator

Re: HELP? [message #165292 is a reply to message #165291]

Sat, 21 May 2011 13:56

fordzilla

Messages: 17
Registered: May 2011
Location: Victoria

Karma: 0

Junior Member

This is My Globals section, I didn't change anything in here.

$COOKIE_PATH = '/forum/';
$COOKIE_DOMAIN = 'fordzilla.homeip.net';
$COOKIE_NAME = 'fud_session_1263531404';
$COOKIE_TIMEOUT = 604800; /* seconds */
$SESSION_TIMEOUT = 1800; /* seconds */

Report message to a moderator

Re: HELP? [message #165295 is a reply to message #165292]

Sat, 21 May 2011 17:46

fordzilla

Messages: 17
Registered: May 2011
Location: Victoria

Karma: 0

Junior Member

Ok, now I have an even stranger problem. I have 2 forums up, one displays correctly (both SEPERATE INSTALLATIONS) the one that has been up for a year is now unable to view the messages that are in the topic, but if I click on the user, view all the messages they have ever entered, then I can see the messages. If I try to create a new topic or message I get the following error in Error Log:

(C:\xampp\htdocs\forum\index.php:76
C:\xampp\htdocs\forum\index.php:43
C:\xampp\htdocs\forum\theme\default\post.php:1938
C:\xampp\htdocs\forum\theme\default\post.php:1418
C:\xampp\htdocs\forum\theme\default\post.php:4130
C:\xampp\htdocs\forum\index.php:1221
) 1146: Table 'forum.fud30_fl_14' doesn't exist
Query: LOCK TABLES fud30_fl_14 WRITE
_GET: array ( 't' => 'post', )
_POST: array ( 'S' => 'e58ca895a44374569066884e9f0e6adc', 'SQ' => '88e6a2555337dc52992d07f64fe9d67b', 'submitted' => '1', 'reply_to' => '0', 'th_id' => '', 'frm_id' => '14', 'start' => '0', 'msg_id' => '0', 'pl_id' => '0', 'old_subject' => '', 'prev_loaded' => '1', 'msg_subject' => 'test', 'msg_tdescr' => '', 'thr_ordertype' => '0', 'thr_orderexpiry' => '1000000000', 'msg_icon' => '', 'fnt_size' => '', 'fnt_color' => '', 'fnt_face' => '', 'msg_body' => 'testtest Laughing

Laughing

', 'tmp_f_val' => '1', 'msg_poster_notif' => 'Y', 'msg_show_sig' => 'Y', 'btn_submit' => 1, )
Server Version: 5.5.8
[Referring Page] http://fordzilla.homeip.net:8112/forum/index.php?t=post&frm_id=14&S =e58ca895a44374569066884e9f0e6adc

Now, I have checked in my DB and there is no FUD30.FL14 so, why would it all of a sudden be looking for thi sparticular section?

The other problem I have is my other forum displays, it just won't show any icons for some reason.

Report message to a moderator

Re: HELP? [message #165300 is a reply to message #165295]

Sun, 22 May 2011 10:42

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Please run a consistency check and let us know if it solves the problem or not.

Report message to a moderator

Re: HELP? [message #165303 is a reply to message #165300]

Sun, 22 May 2011 21:15

fordzilla

Messages: 17
Registered: May 2011
Location: Victoria

Karma: 0

Junior Member

I can't even log into the forum now. Check this link out, I get this, then when I go log into the admin side, it says invalid credentials, what is going on here?

http://tenant-trash.com/ttforum

Report message to a moderator

Re: HELP? [message #165304 is a reply to message #165303]

Sun, 22 May 2011 21:20

fordzilla

Messages: 17
Registered: May 2011
Location: Victoria

Karma: 0

Junior Member

My second forum (the one that used to work fine) does this when I do a consistantcy check:
Disabling the forum for the duration of maintenance run.
Locking the database for checking
Locked!
Validating category order
Done: Validating category order
Checking if moderator and users table match
Rebuilding moderators
Done: Rebuilding moderators
Checking if all private messages have users
Checking messages against users & threads
Checking threads against forums
Checking message approvals
Done: Checking message approvals
Checking threads against messages
OK
Checking thread last & first post ids
Done: Checking thread last & first post ids
Checking forum & topic relations
Done: Checking forum & topic relations
Validating Forum Order
Done: Validating Forum Order
Checking for presence of forum lock tables

Then the ERROR log reports this:

(C:\xampp\htdocs\FUDforum\include\theme\default\db.inc:72
C:\xampp\htdocs\forum\adm\consist.php:302
) 1100: Table 'fud30_fl_2' was not locked with LOCK TABLES
Query: CREATE TABLE fud30_fl_2 (id INT)
_POST: array ( 'conf' => 'Yes', 'S' => '560cf45a74d3dc8b6ec6a2cfe0378b2c', 'SQ' => '04d844371f334fd740ff6c93856e4a9d', )
Server Version: 5.5.8
[Referring Page] http://fordzilla.homeip.net:8112/forum/adm/consist.php?S=560cf45a74d3dc8b6e c6a2cfe0378b2c&SQ=04d844371f334fd740ff6c93856e4a9d

Report message to a moderator

Re: HELP? [message #165305 is a reply to message #165304]

Sun, 22 May 2011 21:21

fordzilla

Messages: 17
Registered: May 2011
Location: Victoria

Karma: 0

Junior Member

Here is my system config info, if this helps?

FUDforum version: 3.0.0
PHP version: 5.3.5
PHP built on: Windows NT SERVER 5.1 build 2600 (Windows XP Professional Service Pack 3) i586
Database type: mysql (mysql)
Database version: 5.5.8
Web server: Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9. Shocked

Shocked

PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1
Web server to PHP interface: apache2handler
Relevant PHP settings: Safe mode: OFF
Open basedir: none
Display errors: OFF
File uploads: ON
Maximum file upload size: 128M
Magic quotes: OFF
Register globals: OFF
Output buffering: Yes
Disabled functions: none
PSpell support: No
Zlib support: Yes

Report message to a moderator

Re: HELP? [message #165306 is a reply to message #165305]

Sun, 22 May 2011 22:18

fordzilla

Messages: 17
Registered: May 2011
Location: Victoria

Karma: 0

Junior Member

Ok, got forum #2 back up. But still wont show pictures, layout etc... not sure why. First forum is up, but cant view messages in database from the category view, only from the username and view all their messages.

Forum 1 = http://prodieselperformance.com
Forum 2 = http://www.tenant-trash.com/ttforum

help??? (Sorry for posting links if your not allowed to here)

Report message to a moderator

Re: HELP? [message #165307 is a reply to message #165306]

Mon, 23 May 2011 13:53

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

FUDforum 3.0.0 is desupported. You need to upgrade prodieselperformance.com or consider commercial support.

Tenant-trash.com is not rendering images because of the iframe with redirect. This is not a FUDforum problem but a problem with how you've set it up.

Report message to a moderator

Re: HELP? [message #165312 is a reply to message #165307]

Mon, 23 May 2011 15:36

fordzilla

Messages: 17
Registered: May 2011
Location: Victoria

Karma: 0

Junior Member

Ok, upgraded the first one to 3.0.2, still can't see the messages when I go to the category, but if I view all messages posted by user I can see them then. Also each of my topics are now under 1 category. When I run the consistancy Check, it does this:

Fatal error: Uncaught exception 'Exception' with message '(C:\xampp\htdocs\FUDforum\include\theme\default\db.inc:75<br /> C:\xampp\htdocs\forum\adm\consist.php:25<br /> C:\xampp\htdocs\forum\adm\consist.php:171<br /> ) 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 'mm FROM fud30_mod mm LEFT JOIN fud30_users u ON mm.user_id=u.id LEFT JOIN fud30_' at line 1<br /> Query: DELETE fud30_mod mm FROM fud30_mod mm LEFT JOIN fud30_users u ON mm.user_id=u.id LEFT JOIN fud30_forum f ON f.id=mm.forum_id WHERE u.id IS NULL OR f.id IS NULL<br /> _POST: array ( 'conf' => 'Yes', 'S' => 'b9b74f643c88259078c99394ae376da3', 'SQ' => '697791d2d98e09e7ed142e3c3d5f2d04', )<br /> Database version: 5.5.8<br /> [Referring Page] http://fordzilla.homeip.net:8112/forum/adm/consist.php?S=b9b74f643c88259078 c99394ae376da3&SQ=697791d2d98e09e7ed142e3c3d5f2d04<br /> ' in C:\xampp\htdocs\FUDforum\include\core.inc:215 Stack trace: #0 C:\xampp\htdocs\FUDforum\include\theme\default\db.inc(75): fud_sql_error_handler('DELETE fud30_mo...', 'You have an err...', 1064, '5.5.8') #1 C:\xampp\htdocs\forum\adm\consist.php(25): q('DELETE fud30_mo...') #2 C:\xampp\htdocs\forum\adm\consist.php(171): delete_zero('fud30_mod', 'SELECT mm.id FR...') #3 {main} thrown in C:\xampp\htdocs\FUDforum\include\core.inc on line 215

Report message to a moderator

Re: HELP? [message #165314 is a reply to message #165312]

Mon, 23 May 2011 15:44

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

See solution posted at http://fudforum.org/forum/index.php?t=msg&goto=164940

Report message to a moderator

Re: HELP? [message #165316 is a reply to message #165314]

Mon, 23 May 2011 16:24

fordzilla

Messages: 17
Registered: May 2011
Location: Victoria

Karma: 0

Junior Member

Trying to figure out how to add that to the PHP file and where?. With the 2nd forum, what would I have done wrong that is forcing it not to show icons? It did at one point, then stopped. Any idea how to fix?

Report message to a moderator

Re: HELP? [message #165319 is a reply to message #165316]

Tue, 24 May 2011 02:09

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Use a text editor like Notepad++.
Find the lines prefixed with a minus (-) and replace them with lines that start with a (+).
When done run the consistency checker - it should go through this time and your forum should be OK.

Report message to a moderator

Re: HELP? [message #165336 is a reply to message #165319]

Fri, 27 May 2011 17:05

fordzilla

Messages: 17
Registered: May 2011
Location: Victoria

Karma: 0

Junior Member

Did the consistentcy checkery code, still getting error on this forum, but not on my new one. Any ideas?

Fatal error: Uncaught exception 'Exception' with message '(C:\xampp\htdocs\FUDforum\include\theme\default\db.inc:75<br /> C:\xampp\htdocs\forum\adm\consist.php:296<br /> ) 1100: Table 'fud30_fl_2' was not locked with LOCK TABLES<br /> Query: CREATE TABLE fud30_fl_2 (id INT)<br /> _POST: array ( 'conf' => 'Yes', 'S' => 'e4310a124cdc71e249c1151ab9131f75', 'SQ' => '0ad477dd7111b4b1e1166fee7d24d05d', )<br /> Database version: 5.5.8<br /> [Referring Page] http://fordzilla.homeip.net:8112/forum/adm/consist.php?S=e4310a124cdc71e249 c1151ab9131f75&SQ=0ad477dd7111b4b1e1166fee7d24d05d<br /> ' in C:\xampp\htdocs\FUDforum\include\core.inc:215 Stack trace: #0 C:\xampp\htdocs\FUDforum\include\theme\default\db.inc(75): fud_sql_error_handler('CREATE TABLE fu...', 'Table 'fud30_fl...', 1100, '5.5.8') #1 C:\xampp\htdocs\forum\adm\consist.php(296): q('CREATE TABLE fu...') #2 {main} thrown in C:\xampp\htdocs\FUDforum\include\core.inc on line 215

Report message to a moderator

Re: HELP? [message #165345 is a reply to message #165336]

Sun, 29 May 2011 04:42

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Try this version of consist.php:
http://fudforum.svn.sourceforge.net/viewvc/fudforum?view=revision&revis ion=5277

Report message to a moderator

Re: HELP? [message #165347 is a reply to message #165345]

Tue, 31 May 2011 10:12

fordzilla

Messages: 17
Registered: May 2011
Location: Victoria

Karma: 0

Junior Member

AWESOME! Thanks Naudefj, that worked, forum is back up, and all messages working properly!

Report message to a moderator

Previous Topic:	some trobles in file attachments/
Next Topic:	Hide Subforum also for Admin?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 01:01:54 GMT 2024

Total time taken to generate the page: 0.02086 seconds