| new problem - will not start [message #1050] |
Wed, 20 March 2002 12:25  |
|
|
I just checked my forum today and received the following message:
Fatal error: Call to undefined function: fud_use() in /var/www/html/forum/index.php on line 22
What should I do now?
Jim
|
|
|
|
|
|
| Re: new problem - will not start [message #1058 is a reply to message #1051] |
Wed, 20 March 2002 15:43  |
|
|
I found that the GLOBALS.php file in the forumdata/include directory had just 0 bytes! I have no idea how that happened. I have not done anything with the forum for several days. Fortunately, I had a pretty recent backup copy of that file so I copied it over. Different error now. It says:
Warning: Can't connect to local MySQL server through socket '/var/lib/mysql.sock' (2) in /var/www/forumdata/include/db.inc on line 26
The mysql.sock file is there. This sounded familiar so I tried a previous suggestion about typing
mysql -S/var/mysql.sock -uuserid -ppassword
and I recieved the same error message.
Jim
|
|
|
|
|
|
| Re: new problem - will not start [message #1060 is a reply to message #1059] |
Wed, 20 March 2002 15:55 |
|
|
If fixed the $MYSQL_SERVER setting and now I get the following error when I access the forum:
Query Failed: SELECT count(*) FROM fud_msg LEFT JOIN fud_thread ON fud_msg.thread_id=fud_thread.id LEFT JOIN fud_forum ON fud_thread.forum_id=fud_forum.id LEFT JOIN fud_mod ON fud_forum.id=fud_mod.forum_id AND fud_mod.user_id=1 WHERE fud_msg.approved='N' AND fud_forum.moderated='Y'
Reason: Can't open file: 'fud_msg.MYD'. (errno: 145)
From: /var/www/html/forum/index.php
Jim
|
|
|
|
|
|
|
|
| Re: new problem - will not start [message #1063 is a reply to message #1062] |
Wed, 20 March 2002 16:37 |
|
|
I think I found the root of the problem - the /var partition was full. I have created some free space but still get the same error. Some files must have been corrupted. What is the best strategy? Is the update to 1.2.3 likely to fix anything?
Jim
|
|
|
|
|
|
| Re: new problem - will not start [message #1067 is a reply to message #1064] |
Wed, 20 March 2002 17:22 |
|
|
I ran the update. Final result was a screen with the following message:
Locking the database for checking
Query Failed: LOCK TABLES fud_thread WRITE, fud_thread_view WRITE, fud_forum WRITE, fud_cat WRITE, fud_msg WRITE, fud_mod WRITE, fud_users WRITE, fud_users AS fud_users_2 WRITE, fud_read WRITE, fud_poll WRITE, fud_poll_opt WRITE, fud_poll_opt_track WRITE, fud_smiley WRITE, fud_thread_notify WRITE, fud_forum_notify WRITE, fud_attach WRITE, fud_msg_report WRITE, fud_thread_rate_track WRITE, fud_level WRITE, fud_custom_tags WRITE, fud_user_ignore READ, fud_buddy WRITE, fud_pmsg WRITE, fud_ext_block WRITE
Reason: Can't find file: 'fud_thread_view.MYD' (errno: 2)
From: /var/www/html/forum/adm/consist.php
Server Version: 3.23.48-log
Now the forum seems disabled. Get the message "Undergoing upgrades".
Jim
|
|
|
|
| Re: new problem - will not start [message #1068 is a reply to message #1067] |
Wed, 20 March 2002 18:02 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
add to buddy list
ignore all messages by this user
|
|
| fjrohlf wrote on Wed, 20 March 2002 5:22 PM |
I ran the update. Final result was a screen with the following message:
Locking the database for checking
Query Failed: LOCK TABLES fud_thread WRITE, fud_thread_view WRITE, fud_forum WRITE, fud_cat WRITE, fud_msg WRITE, fud_mod WRITE, fud_users WRITE, fud_users AS fud_users_2 WRITE, fud_read WRITE, fud_poll WRITE, fud_poll_opt WRITE, fud_poll_opt_track WRITE, fud_smiley WRITE, fud_thread_notify WRITE, fud_forum_notify WRITE, fud_attach WRITE, fud_msg_report WRITE, fud_thread_rate_track WRITE, fud_level WRITE, fud_custom_tags WRITE, fud_user_ignore READ, fud_buddy WRITE, fud_pmsg WRITE, fud_ext_block WRITE
Reason: Can't find file: 'fud_thread_view.MYD' (errno: 2)
From: /var/www/html/forum/adm/consist.php
Server Version: 3.23.48-log
Now the forum seems disabled. Get the message "Undergoing upgrades".
|
Oh boy, you running out of space seems to have screwed up MySQL. Mysql query failed because mysql couldn't find "fud_thread_view.MYD" file. You'll need to run mysql integrity checker & fixer 1st.
FUDforum Core Developer
|
|
|
|
|
|
|
|
| Re: new problem - will not start [message #1072 is a reply to message #1050] |
Wed, 20 March 2002 19:14 |
|
|
I found a file called mysqlcheck in the usr/bin directory. I ran it with the --all-databases option and it said all were ok except: forumdata.fud_index and forumdata.fud_msg are corrupt and the file forumdata.fud_thread_view.MYD cannot be found. I noticed that there was a repair options -a and -r. Should I try them?
Jim
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: new problem - will not start [message #1079 is a reply to message #1077] |
Wed, 20 March 2002 20:10 |
|
|
I tried /etc/init.d/mysql start
and I get the following:
Starting mysqld daemon with databases from /var/lib/mysql
020320 20:19:40 mysqld ended
If I then type mysql I get the following:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Jim
|
|
|
|
|
|
| Re: new problem - will not start [message #1082 is a reply to message #1079] |
Wed, 20 March 2002 20:12 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
add to buddy list
ignore all messages by this user
|
|
| fjrohlf wrote on Wed, 20 March 2002 8:10 PM |
I tried /etc/init.d/mysql start
and I get the following:
Starting mysqld daemon with databases from /var/lib/mysql
020320 20:19:40 mysqld ended
If I then type mysql I get the following:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
|
I think your mysql fails to start...
after you run your start script, do a "ps aux" and see if you can spot mysql running....
FUDforum Core Developer
|
|
|
|
|
|
|
|
|
|
|
|
| Re: new problem - will not start [message #1089 is a reply to message #1088] |
Wed, 20 March 2002 20:22 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
add to buddy list
ignore all messages by this user
|
|
| fjrohlf wrote on Wed, 20 March 2002 8:19 PM |
No, I just stopped the deamon I did not stop using mysqladmin also. Should I try to kill all of those processes?
|
Uhm did you use the "kill" command?
You ALWAYS should stop mysql using the mysqladmin script, otherwise you risk corrupting the databases.
use the command like this:
mysqladmin -uroot -pROOT_PASS shutdown
FUDforum Core Developer
|
|
|
|
| Re: new problem - will not start [message #1090 is a reply to message #1089] |
Wed, 20 March 2002 20:45 |
|
|
ok, the forum consistency check now runs ok. No error messages. It then says the forum is currently disabled and that I should go toe the Global settings manager to re-enable it. I tried that. Changed the picklist from no to yes and then clicked return to forum but I still receive the message saying :
Undergoing Upgrades
Administrators can login here
I then noticed that the time stamp on the GLOBALS.php file in the include directory had not changed. I then change the N to Y to enable it using vi. I was then able to access the forum. So far it looks like the various messages are there! Time for a big backup.
Why would the admin control panel not be able to change the GLOBALS.php file?
Jim
|
|
|
|
|
|
|
|
|
|
| Re: new problem - will not start [message #1096 is a reply to message #1093] |
Wed, 20 March 2002 21:29 |
|
|
I have already upgraded to 1.2.3 so that is not the problem.
One thing that has puzzled me before is that the global settings manager does not have an update button. I made a change to the 'reason for disabling' message. I then went to the message editor and then back to the global settings and I got back the original vaues not what I had changed them to. How does one save the settings?
Jim
|
|
|
|
| Re: new problem - will not start [message #1098 is a reply to message #1096] |
Wed, 20 March 2002 21:33 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
add to buddy list
ignore all messages by this user
|
|
You see no update(Set) button?
There should be a "Set" button at the bottom right corner of the page, you may need to scroll a little to see it because admglobal is a rathe long form.
If the button is not there, then that is your problem, to solve it simply replace your admglobals.php with the admglobals.php from the one stored inside the forum_install/install_data/docs/adm/ directory (the forum sources you've downloaded).
FUDforum Core Developer
|
|
|
|
| Re: new problem - will not start [message #1099 is a reply to message #1098] |
Wed, 20 March 2002 21:49 |
|
|
Oh, way over there to the right. I had not seen that before! Could you move it down to a line by itself so it would be on the left?
I found out one reason why I ran out of space. In the /var/lib/mysql directory there is a morph.log file that is 55MB. Can that be deleted or at least be reduced in size? There are also some files with names like morph-bin.009 that are fairly large.
Thanks again for all of your help. I really appreciate it.
Jim
|
|
|
|
|
|
Calendar
Search
Help
Members
Control Panel
Logout [ CommonCrawl [Bot] ]
Home
]