Can someone tell me what this means....

[Deprecated]

Dammit I don't give up. Maybe I was just whining... I was just trying to tell you we are going to whack at this problem again tomorrow! I'm tired after working support for 12 hours...

I've marked your topic "unsolved" and I'm not going to give up unless you refuse to reply to your topic. So do like I said and remind me in 12 hours or so if this topic has no activity before then.

You get the best damned support for SMF or it won't be because of me.

Topic marked unsolved. Don't give up.

[lax.slash]

Deprecated - what's your opinion on the malicious activity theory?

[tk2012]

Well, I had fixed all the errors that were in my error log earlier in the week.  The last error that I had was the PLUSHSEARCH2 or something like that where I was told to make changes to the search settings.  That's the only changes I made.  I've not really had any problems with databases other than that PLUSHSEARCH thing. 

Not sure if that is involved here or not.  I'll check the IPs in the am.  I have about had it tonight.  It is my first week of chemo and I have tried to stay up as long as I could tonight.

[metallica48423]

So let me wrap my head around this.  The original issue problem was a crashed messages table?  The table would not repair.  Is this table still crashed and in place?  Have you contacted your host?  If not, do so, and ask them to run myisamchk on the table.  If not, it is possible that it is corrupted and may be a total loss.

If you have an older copy of the messages table in a backup, you *MAY* be able to import it and utilize it, however you will LOSE any topics and messages between when the backup was made and now, and it may cause some errors -- you'll have topic entries that don't have corresponding messages.  But that is speculation on my part based on prior experience.  The find and repair errors function should be able to hopefully clean that up.

I highly doubt the malicious action theroy. Sorry.  malicious action generally drops and deletes tables or table data, not crashes them.  Table crashes are usually a server fault due to poor configuration or maintenance, or possibly even overloading.  Tables can also crash if not optimized regularly -- SMF has a utility to do this automatically from time to time for this purpose.  However, that can be disabled -- but shouldn't be unless its being handled elsewhere.

[lax.slash]

So let me wrap my head around this.  The original issue problem was a crashed messages table?  The table would not repair.  Is this table still crashed and in place?  Have you contacted your host?  If not, do so, and ask them to run myisamchk on the table.  If not, it is possible that it is corrupted and may be a total loss.

He did check with his host, but the ticket handler is off until tomorrow.

I highly doubt the malicious action theroy. Sorry.  malicious action generally drops and deletes tables or table data, not crashes them.  Table crashes are usually a server fault due to poor configuration or maintenance, or possibly even overloading.  Tables can also crash if not optimized regularly -- SMF has a utility to do this automatically from time to time for this purpose.  However, that can be disabled -- but shouldn't be unless its being handled elsewhere.

That's why I was confused when I suggested that.

[metallica48423]

Yeah.  If the control panel repair and/or the repair function through phpmyadmin fail, then the only other real option is for the host to use the root user to run myisamchk.

As i said, there is a possibility it is corrupted and can't be repaired, but we need them to check first.

[Deprecated]

Deprecated - what's your opinion on the malicious activity theory?

My opinion doesn't really count. Reality is reality irrespective of my opinion, and I just don't know.

[Deprecated]

Oh yeah, Metallica sent me a message on IRC about this topic... I couldn't figure it out until just now.

We'll solve your topic tomorrow. Met is East Coast if I remember correctly, and I'm a Los Angeles guy. It's nearing our U.S. end of day and I think I can speak for him too, that our attention and awareness are decreasing.

Let's continue this tomorrow. We'll get it right.

[tk2012]

The "messages" table had crashed and would not repair... when I went into phpmyadmin I checked the table and it said "in use".    I tried to repair it thru phpmyadmin and it would not change.

I've been on hold with the host since Friday.  Today, they said they would get my table back up, but it would take a lengthy time because it is a manual process.  The table is no longer there.  It has been deleted. 

The "messages" backup that was available in myphpadmin that I saw was from 9-17ish.  I went ahead myself and imported that one into the database as the usable one within 45 seconds.  I have the forum in maintenance mode currently to keep anyone from making new posts because I was hoping to use a more current copy of my database backup. 

I guess I'm confused here because of the following:

All my other tables are current as if nothing happened.  I imported the "messages" table that was from 9-17 into my forum with no problem.  The part I don't understand is that if I have a database from 10-17 which includes a more recent copy of the "messages" table in it, why can't I do the following?

a- create a new database directory and import the 10-17 database into it.
b- export the "messages" table from the 10-17 database onto my laptop
c- delete the "messages" table from my current database (because it was deleted already and I imported the 9-17 version with no problems)
d- import the "messages" (10-17) into my current database because it would give me an extra months worth of messages.




Like I said, the only database problems that I had originally were the Plushsearch2 problems. 

http://www.simplemachines.org/community/index.php?topic=262174.0

I did what was stated in the reply and then this happened.  They could be totally unrelated, but I would think Search and Messages do overlap in some way.



(FYI -The people who registered during the time the forum was down, have different ip addresses.)

[Deprecated]

Well your smf_messages table cannot be imported unless you import your smf_topics table too. They go together. If you add the messages table without the topics, any existing topics that were active between the dates of the two files will be screwed up, and any new topics will be missing even though the posts will be there but not accessible.

Yeah, could be related to that mod. Hard to say. Doesn't seem impossible though.


I don't know if I can help you without seeing that crashed table. Have you looked at source? It might be something obvious in just one place...

[tk2012]

What mod?

ok, so I'll load the topics table, too and get it to at least to the 9-17 backup.

The crashed table was deleted, so don't think there is much to go on there... that's why I'm doing damage control at this point and trying to get it to a more current back up from 10-17

[Deprecated]

I was just referencing the Plushsearch2 mod that you mentioned.

[tk2012]

I don't have a mod that does anything like that.  LOL.  That's why I have been posting it to find out what help I can get.  I have no search mods installed on my forum at all.  I'm not aware of any either.  As far as I know, this is a function otherwise I wouldn't have been told by two different people to upgrade to b4.0 because they thought those problems had been taken care of in the upgrade. 

[tk2012]

@Deprecated

I did two different backups thru the forum administration center... (Because I'm not fluent with myphpadmin)  Next time, I'll do it thru there.  Anyway, I was told not to attach a database file on the forum here, but I'd like a 2nd opinion..

Can you tell me if what I have will actually work to use as a restore if I emailed it to you? 

[Deprecated]

Let me understand you first, you intend to mail just the faulty table, right? Please tell me what its size is.

But not the entire database!

[tk2012]

well, let me tell you this.  I have three files here from 10/17

two of them I receive this error when trying to import them into the database:

No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.

the third, file that I've tried, sends back a HUGE error about the Admin_Files table not existing...

Now, all of these files were downloaded via the administration center on the forum, so I don't understand why they won't work....

[metallica48423]

there is a utility out there called bigdump -- might have to google it -- that can import larger sql files.  It may help in your case

[tk2012]

motorstorm-rpms_org_community-complete_2008-10-17.sql   3.71MB

motorstorm-rpms_org_community-data_2008-10-17.sql   3.65MB

motorstorm-rpms_org_community-data_2008-10-17.sql.gz  1.01MB

These are the names of the files and sizes... is it the way in which they were downloaded?  I did one with the data and one as complete as instructed in a different thread here.

http://www.simplemachines.org/community/index.php?topic=184356.0

[tk2012]

Right now the forum is restored to 9-17.  I don't want to completely replace my database until I know for certain it is going to import completely.  That's why, I wanted to make a 2nd directory name and import it to that one first to make certain.

[Deprecated]

tk2012 please excuse me for saying that i'm signing off for tonight (soon) and please pm me or bump your topic tomorrow morning. gnite!