|
|
Joined: Oct 2006
Posts: 20
stranger
|
|
stranger
Joined: Oct 2006
Posts: 20 |
Hi, My forum has been up and running fine for several years, but this morning when I tried to access it I got the following error. I haven't made any changes and can't seem to access any of the forum pages, including the control panel. Does anyone have any suggestions on how I can fix this and get my site back up and running?
UBB Error
We encountered a problem. The reason reported was
Database error only visible to forum administrators
Please use your back button to return to the previous page. Thanks! http://www.iwrf.com/forums/ubbthreads.php
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
If you don't have SQL error logging enabled in your control panel, then what you need to do is edit your libs/mysql.inc.php file. Look for a line that has:
$showerror = 0;
Change that to:
$showerror = 1;
You should then get the actual database error and we can give more info on the issue.
|
|
|
|
|
Joined: Oct 2006
Posts: 20
stranger
|
|
stranger
Joined: Oct 2006
Posts: 20 |
Thanks Rick. Since I can't access the file from the CP, can I edit it with notepad and then replace the existing file? Also, what permissions should I give to mysql.inc.php file?
Cheers-
John
|
|
|
|
|
Joined: Jun 2006
Posts: 16,300 Likes: 116
|
|
Joined: Jun 2006
Posts: 16,300 Likes: 116 |
The file has to be edited in NotePad (or any other standard text-only editor; don't use Word or anything that'll add additional characters to the file).
The file should be 644.
|
|
|
|
|
Joined: Oct 2006
Posts: 20
stranger
|
|
stranger
Joined: Oct 2006
Posts: 20 |
Okay, made the edit and now get this error message. UBB Error
We encountered a problem. The reason reported was
Script: /usr/www/users/iwrf/forums/libs/ubbthreads.inc.php
LineSQL Error: Incorrect key file for table './iwrf_ubbthreads/ubbt_CACHED_PERMISSIONS.MYI'; try to repair it
SQL Error Query: select USER_ID,CACHED_PERMISSION_DATA from ubbt_CACHED_PERMISSIONS where USER_ID = '2'
Where to next?
|
|
|
|
|
Joined: Jun 2006
Posts: 16,300 Likes: 116
|
|
Joined: Jun 2006
Posts: 16,300 Likes: 116 |
If you have PHPMyAdmin you can access the database and repair that table
|
|
|
|
|
Joined: Oct 2006
Posts: 20
stranger
|
|
stranger
Joined: Oct 2006
Posts: 20 |
Got it... many thanks!
John
|
|
|
|
|
Joined: Jun 2006
Posts: 16,300 Likes: 116
|
|
Joined: Jun 2006
Posts: 16,300 Likes: 116 |
You'll want to be sure that after the issue is repaired, you reverse the change to libs/mysql.inc.php since it can divulge information to users who don't need it...
|
|
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
|
|
|
|
