UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Database Crashed after Optimization.

posted March 22, 2003 10:07 AM
I am using UBB Threads 6.1.1.

I closed the forum to Optimize the Tables. I hit the button to Optimize. It came back very fast. When I went to another screen it logged me out and now I can't log in.

It gives me the following error at the top of the page.

SQL ERROR: Database error only visible to forum administrators

Warning: Supplied argument is not a valid MySQL result resource in /web/home2/w026125/docs/htsthreads/mysql.inc.php on line 121
SQL ERROR: Database error only visible to forum administrators

Warning: Supplied argument is not a valid MySQL result resource in /web/home2/w026125/docs/htsthreads/mysql.inc.php on line 121

Paul B. Carleton
President/CEO
www.HomeTheaterSPot.Com
SPot Forum

Did the actual error show up in your MySQL error log?

"Database error only visible to forum administrators" and "Supplied argument is not a valid MySQL result resource" aren't really informative.

Dave, I can't log in to find out.

It looks like either the MySQL database is gone or not accessible.


Paul B. Carleton
President/CEO
www.HomeTheaterSPot.Com
SPot Forum

Probably a corrupt table. Do you have phpMyAdmin installed?

If you are on 6.2 or higer, and using the SQL Error logs in threads, you can go into your server via FTP and view the logfile directly.

Josh
www.joshuapettit.com
ThreadsDev.com Administrator | InfoPop Community Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire for upgrades, tweaks and modifications.

Josh, no I do not have phpMyAdmin installed.

I am ussing 6.1.1. I have not upgraded yet to 6.2 because when I tried the upgrade script it would hang.

Paul B. Carleton
President/CEO
www.HomeTheaterSPot.Com
SPot Forum

One solution would be to install my MySQL Error Log hack. It was written for 6.1.1, and adopted as a feature in 6.2.

Or you could temporarily comment out the lines in mysql.inc.php that suppress displaying the actual MySQL error, so you could see the error.

Installing phpMyAdmin would be a good idea too. It's a very useful tool for dealing with database problems.

Well I installed phpMyAdmin.

This is what the database says.

Table Action Records Type Size

w3t_AddressBook Browse Select Insert Properties Drop Empty 938 MyISAM 38.5 KB

w3t_Banned Browse Select Insert Properties Drop Empty 205 MyISAM 14.8 KB

w3t_Boards Browse Select Insert Properties Drop Empty 123 MyISAM 42.7 KB

w3t_Category Browse Select Insert Properties Drop Empty 13 MyISAM 4.0 KB

w3t_Favorites Browse Select Insert Properties Drop Empty 1,575 MyISAM 83.6 KB

w3t_Graemlins Browse Select Insert Properties Drop Empty 39 MyISAM 3.4 KB

w3t_Groups Browse Select Insert Properties Drop Empty 29 MyISAM 2.7 KB

w3t_Last Browse Select Insert Properties Drop Empty 145,214 MyISAM 7.5 MB

w3t_Messages Browse Select Insert Properties Drop Empty in use

w3t_ModNotify Browse Select Insert Properties Drop Empty 44 MyISAM 2.2 KB

w3t_Moderators Browse Select Insert Properties Drop Empty 263 MyISAM 13.9 KB

w3t_Online Browse Select Insert Properties Drop Empty 74 MyISAM 245.8 KB

w3t_PollData Browse Select Insert Properties Drop Empty 6,650 MyISAM 345.6 KB

w3t_Polls Browse Select Insert Properties Drop Empty 358 MyISAM 37.6 KB

w3t_Posts Browse Select Insert Properties Drop Empty in use

w3t_Ratings Browse Select Insert Properties Drop Empty 2,752 MyISAM 170.0 KB

w3t_Subscribe Browse Select Insert Properties Drop Empty 4,730 MyISAM 214.4 KB

w3t_Users Browse Select Insert Properties Drop Empty in use

18 table(s) Sum 163,007 -- 8.7 MB

I am afraid it looks like the Messages, Posts, and Users tables say they are "in use" it shows no data

Paul B. Carleton
President/CEO
www.HomeTheaterSPot.Com
SPot Forum

I am getting the following can't access error.

Can't open file: 'w3t_Users.MYD'. (errno: 144)

Paul B. Carleton
President/CEO
www.HomeTheaterSPot.Com
SPot Forum

OK
Go to SQL Commands and enter this:

REPAIR TABLE
w3t_Users

That shoudl do the trick. <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Josh
www.joshuapettit.com
ThreadsDev.com Administrator | InfoPop Community Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire for upgrades, tweaks and modifications.

Do I put it on two lines as you have done?

Paul B. Carleton
President/CEO
www.HomeTheaterSPot.Com
SPot Forum

It didn't work I get the following.

htsthreads.w3t_Users repair error 28 when writing to datafile

htsthreads.w3t_Users repair error 28 when writing to datafile

htsthreads.w3t_Users repair status Operation failed

BTW w3t_Post & w3t_Messages also have the same problem. <img border="0" title="" alt="[Frown]" src="images/icons/frown.gif" />

I have to tell you I am pretty nervous here. <img border="0" title="" alt="[Embarrassed]" src="images/icons/blush.gif" />

Paul B. Carleton
President/CEO
www.HomeTheaterSPot.Com
SPot Forum

There are some more advanced repair options here.

I'm not too familiar with them. I believe the other options need to be run from the command line, or your host will have to run them.

All is not lost yet, if you are on a shared host, I would contact them and ask them about database repair.

Josh
www.joshuapettit.com
ThreadsDev.com Administrator | InfoPop Community Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire for upgrades, tweaks and modifications.

Thanks I was just looking at that page.

I am on a dedicated server and my MySQL guy is not home right now.

Argg! <img border="0" title="" alt="[Confused]" src="images/icons/confused.gif" />

Paul B. Carleton
President/CEO
www.HomeTheaterSPot.Com
SPot Forum

This may be helpful:

$ perror 28
Error code 28: No space left on device

Daoh, good work Dave!

That explains why they all got corrupt all of a sudden... you're out of space. <img border="0" title="" alt="[Frown]" src="images/icons/frown.gif" />

Josh
www.joshuapettit.com
ThreadsDev.com Administrator | InfoPop Community Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire for upgrades, tweaks and modifications.

My Web Host finally called me last night at about 10PM. He figured out that it was a space issue and moved us to a partition on the Hard Drive that had plenty of space. I was then able to run the REPAIR TABLE code and all was fixed.

Thanks you guys for your help. BTW, phpMyAdmin is a great tool! Thanks for the heads up on that as well. <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Now I just have to get the courage to upgrade to 6.2.2 now. When I tried to upgrade to 6.2 the import script kept locking up and it corrupted all my data and I had to reinstall from a backup.

Between that and this I don't know if I can take it. My members would swarm up and kill me if I screwed up all the data on the forum. <img border="0" title="" alt="[Mad]" src="images/icons/mad.gif" />

The Data is all backed up as of today now and I am feeling a bit better about making the move. Learning PHP and MySQL since I made the move from classic last summer has been a real learning curve.

How well does the upgrade script work for large forums now?

Paul B. Carleton
President/CEO
www.HomeTheaterSPot.Com
SPot Forum

You know... if you were close on space and were running the 6.2 altertable... it might have been filling stuff up and thats why it corrupted everything.

Might be worth another shot. <img border="0" title="" alt="[Wink]" src="images/icons/wink.gif" />

Josh
www.joshuapettit.com
ThreadsDev.com Administrator | InfoPop Community Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire for upgrades, tweaks and modifications.

Thanks, I was thinking the same thing.

They did do something to break up the script after the initial release to help on large forums, right?

Paul B. Carleton
President/CEO
www.HomeTheaterSPot.Com
SPot Forum

Yes, the most recent script should be better.

If a step times out in your browser..... don't do it again... use phpMyAdmin to view the processes... you can usually tell that it is still working. Wait til it stops, then continue to the next step.

The problems arise when you do a step more than once. <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Josh
www.joshuapettit.com
ThreadsDev.com Administrator | InfoPop Community Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire for upgrades, tweaks and modifications.