UBB.Developers Forums UBB.threads 7 Development How Do I? Clean up in aisle 6.2.3!!

Well, our ISP switched servers on us, and when they did this, I guess they messed up my forum. It's giving off some pretty wild error messages to non-admin users, but us admin users have probably 1.5 pages of errors popping up when you try and open the main page.

Reckon someone could take a look and maybe shoot me a diagnosis? I'll take all the help I can get! Here it is:

http://www.yenko.net/ubbthreads/ubbthreads.php

SQL ERROR: Thu, Sep 18 2003 13:03:30 -0600 Database error only visible to forum administrators

You need to post the real errors, getting them from your MySQL log if necessary.

Well, that's part of the problem. When I try to view my error logs, it shows a list of porbably 20, but when I click on one of them it says it can't pull the page up.

But, here's what's showing on the main page to me:

At the top, between the title of my board and the links:
SQL ERROR:Thu, Sep 18 2003 13:07:23 -0600 Unable to do_query: REPLACE INTO w3t_Online (O_Username,O_Uid,O_Last,O_What,O_Extra,O_Read,O_Type) VALUES ('Chevy454','3','1063912043','postlist','UBB1','-1-2-3-4-','r')
Can't open file: 'w3t_Online.MYD'. (errno: 145)

And this is between the links and the actual forum:
SQL ERROR: Thu, Sep 18 2003 13:09:53 -0600 Unable to do_query: SELECT O_Type,COUNT(*) FROM w3t_Online WHERE O_Last > '1063911593' GROUP BY O_Type
Can't open file: 'w3t_Online.MYD'. (errno: 145)SQL ERROR: Thu, Sep 18 2003 13:09:53 -0600 Unable to do_query: SELECT COUNT(*), SUM(B_Topic) FROM w3t_Posts WHERE B_Posted > 1063670632 AND B_Board = 'UBB10'
Got error 134 from table handlerSQL ERROR: Thu, Sep 18 2003 13:09:53 -0600 Unable to do_query: SELECT COUNT(*), SUM(B_Topic) FROM w3t_Posts WHERE B_Posted > 1063729997 AND B_Board = 'lounge'
Got error 134 from table handlerSQL ERROR: Thu, Sep 18 2003 13:09:53 -0600 Unable to do_query: SELECT t1.Bo_Title,t1.Bo_Description,t1.Bo_Keyword,t1.Bo_Total,t1.Bo_Last,
t1.Bo_Number,t1.Bo_Moderated,t1.Bo_Read_Perm,t1.Bo_Write_Perm,t1.Bo_Threads,
t1.Bo_Sorter,t1.Bo_Posterid,t1.Bo_LastMain,t1.Bo_LastNumber,t2.U_Username,
t3.B_Subject,t3.B_Icon,t3.B_Reged,t3.B_AnonName FROM w3t_Boards AS t1 LEFT JOIN w3t_Users AS t2 ON t1.Bo_Posterid = t2.U_Number LEFT JOIN w3t_Posts AS t3 ON t1.Bo_LastNumber = t3.B_Number WHERE t1.Bo_Cat = 2 AND (t1.Bo_Posterid = t2.U_Number OR t1.Bo_Posterid = '0') AND (t1.Bo_LastNumber = t3.B_Number OR t1.Bo_LastNumber ='0') AND (t1.Bo_Read_Perm LIKE '%-3-%' OR t1.Bo_Read_Perm LIKE '%-2-%' OR t1.Bo_Read_Perm LIKE '%-1-%') ORDER BY t1.Bo_Sorter
Got error 127 from table handlerSQL ERROR: Thu, Sep 18 2003 13:09:53 -0600 Unable to do_query: SELECT COUNT(*), SUM(B_Topic) FROM w3t_Posts WHERE B_Posted > 1063753311 AND B_Board = 'UBB3'
Got error 134 from table handlerSQL ERROR: Thu, Sep 18 2003 13:09:53 -0600 Unable to do_query: SELECT COUNT(*), SUM(B_Topic) FROM w3t_Posts WHERE B_Posted > 1063726726 AND B_Board = 'UBB4'
Got error 134 from table handlerSQL ERROR: Thu, Sep 18 2003 13:09:53 -0600 Unable to do_query: SELECT COUNT(*), SUM(B_Topic) FROM w3t_Posts WHERE B_Posted > 1063728271 AND B_Board = 'UBB5'
Got error 134 from table handlerSQL ERROR: Thu, Sep 18 2003 13:09:53 -0600 Unable to do_query: SELECT COUNT(*), SUM(B_Topic) FROM w3t_Posts WHERE B_Posted > 1063728520 AND B_Board = 'UBB6'
Got error 134 from table handler

Your who's online table appears to be damaged. Trying running repair table. That should fix it.

Run this query from the sql command box in your admin panel:
repair table w3t_online;

Here's what it said when I ran the command:

Here are the results of your command: "repair table w3t_online;".

Resource id #12 row(s) affected by your query.

Well, here is the error it gives on top of the "who's online" page, as well as the whole host of errors I listed above:

SQL ERROR: Thu, Sep 18 2003 16:03:59 -0600 Unable to do_query: DELETE FROM w3t_Online WHERE O_Last < 1063922039
Can't open file: 'w3t_Online.MYD'. (errno: 145)

If

REPAIR TABLE w3t_Online;

did not work

At least it is only that table that is corrupt and not the user or posts table.

But before you do the suggestion below try the repair command again flush your browser cache and all cookies and relog in.

You can safely drop that table and then run this command in PhpMyAdmin to recreate the structure

CREATE TABLE `w3t_Online` (
`O_Username` varchar(64) NOT NULL default '',
`O_Last` int(9) unsigned NOT NULL default '0',
`O_What` varchar(64) default NULL,
`O_Extra` varchar(200) default NULL,
`O_Read` varchar(255) default NULL,
`O_Type` char(1) NOT NULL default '',
`O_Agent` text,
`O_Refer` text,
`O_Uid` int(9) default NULL,
`O_IPaddy` varchar(15) default NULL,
UNIQUE KEY `Oindx1` (`O_Username`),
KEY `Oindx2` (`O_Last`),
KEY `type_index` (`O_Type`)
) TYPE=MyISAM;

Well, Omegatron saved the day! He got my forum back on it's feat again!

Many thanks for a job well done!

Ok, now I probably really screwed it up. While I was in the admin area checking the error logs I looked at the last post data and noticed that ALL of the forums were different, so I hit "update". Well, it's showing my forums again, but under "last post" it says "new forum" and it won't show any posts if you click on a forum to open it up. Anyone ever done this?

The irony of it is that Omegatron just got this thing back up and running, and I had to get up at 5am, so I was gonna do a backup of the board since no one would be around so early...oh well!

Rob,

Four days later and your still having problems. Since your new to that server I would seriously check with the host and fine tune whatever settings they have.

It is abnormal to have this kind of table corruption
You are getting continual table corruption on that new server.

Chuck:

I agree. Like I said, I didn't even have a HINT of a problem until they decided to do their "upgrade" to a new server and new software. Once they did that, my entire site/email was down 3 weeks! Sadly, all of their customers got hit with this, so they are being bombarded with complaints.

I've been telling them about this for 3 weeks now, and this makes corruption number 5 to my forum! Any idea what could be causing the corruption, or what I need to tell them to look for? I've had good luck with their service in the past, but this is getting old in a hurry...

You know, something just dawned on me...

Every time my forum has gone down, it has happened between midnight and 5am, while I'm in bed! Reckon I'm just unlucky, or that it's just "coincidence" that my ISP updates and does maintenance at during this same window...?

Well I can tell you a story on that one

I have service though OLM.net. They are reliable and fast.

I was on their old system for years and never had a problem. I went to the new VDS systems so I would have access to install whatever modules I wanted etc. My site has been down every two weeks at least for a a half hour or hour

Nothing Major but there seems to be kinks in the new vds software. I have never had table corruption or I would have switched already. Then you have to repoint domains and 72 hours later blah blah blah.

Your case is extreme and you may need to act sometime as you stand a chance if you do not back up daily as I stated of losing everything. You were lucky indeed as before I came along as set your backup paths etc. YOU HAD NO BACKUPS. you could have lost your entire forum.

Chuck:

That sounds eerily familiar! Before, we had to request, either by email, phone, whatever, to install a new feature. Then, they decided that this new software was the way to go, because we could each go into our control panel and add/remove whatever we wanted. Well, it sounded good on paper, but that's when all heck broke loose. I had considered asking if they were could "prorate" this last month's fees, as we were down about 3 weeks, but...?

Thanks again for the help.

Most good hosting companies will prorate fees in those circumstances and it is in their hosting agreements.

Well, guess what...MORE ERRORS! Big surprise, huh?!

Anyway, anyone seen this one:

Unable to do_query: SELECT DISTINCT Cat_Title,Cat_Number,Cat_Description FROM w3t_Category WHERE Cat_Type = 'forum' ORDER BY Cat_Number - Got error 127 from table handler

I'm trying to learn how to do this the hard way, but in all that mess, is it saying that "w3t_Category" is the problem? Could I try a repaair table?

Basically your w3t_Category table is corrupt - and the REPAIR TABLE command will *usually* fix it.

We've put together a list of common errors and their solutions which is handy when you have trouble:
https://www.ubbdev.com/forum/showflat.php/Cat/0/Number/94361

Soemtimes you can't login to run the commands from the Admin panel, so in those cases phpMyAdmin is handy.

I just want to add that since this is your second table corruption in less than a week, you might want to consider nightly backups. If your post or user table corrupts beyond what the repair table can fix you would lose any posts/users since your last backup.

Slayer:

That's an excellent point. I've been trying to do backups every few hours, but I was a "little" busy last night and this morning! You see, just before midnight last night my 2 year old decided to see if the end off of a crayon would fit in his nose. It did, so I was up until almost 2am trying to extract it...I couldn't, so an early trip to the doctor today and about 5 hours later the crayon is out, but I returned to a corrupted forum. Luckily, it didn't wipe out any info, and the repair table fixed it.

Yikes! Aren't 2 year olds fun.