Error, Missing Table: log_search_words

Started by PenelopeQ, August 21, 2011, 11:04:02 AM

Previous topic - Next topic

kat

To restore the database,go to CPanel>Files>Backups and you'll see your database(s), there.

"Download a MySQL Database Backup".

You restore them from exactly the same place.

"Restore a MySQL Database".

It really is that simple.

For the site, itself, you want "Download a Home Directory Backup" and to restore it, you use "Restore a Home Directory Backup".

Doddle. :)

Of course, you can backup using FTP, if you want to, too!

PenelopeQ

Oh DUH, I really did know that. When I backup the restore option sits next to it!

Biting the bullet, doddling is over!

kat

If you need any more help, just ask.




Someone else! ;)

[/joke]

PenelopeQ

Nope, I deleted the table and I get the same posting error--it says the table doesn't exist so at least the error is now accurate!

Something in the processing of posting must try to communicate with that table.

I'm also having issues with the hosting--I'll contact them too.
A week-and-a-half ago we upgraded my package plan because of disk space and bandwidth.

Yesterday I was at 92% of my bandwidth usage limit. Today I'm at 95%.  >:( :o ???

This is all related. I had no problems with that table until upgrading plans.

kat

Dare I ask who your host is? (He says, praying that the answer's not "Godaddy")

oldpilot

Quote from: K@ on August 25, 2011, 04:11:53 PM
Dare I ask who your host is? (He says, praying that the answer's not "Godaddy")
Monte Carlo

PenelopeQ

I chose MonteCarol because of Christian's familiarity with smf. I switched from bluehost in July.

kat

Yeah, you did tell us and I forgot. Sorry 'bout that.

Let's wait until they've got you sorted and see where that leaves us, ay?

Otherwise, we might just be chasing our own tails.

Illori

have you tried going to admin -> search -> search method and click the link create custom index?

any size profile is fine and click create.

this table seems to only be created when creating the custom index. it is not found in a default install.

PenelopeQ

Quote from: Illori on August 25, 2011, 04:30:01 PMhave you tried going to admin -> search -> search method and click the link create custom index?

any size profile is fine and click create.

this table seems to only be created when creating the custom index. it is not found in a default install.
The custom index was selected when I checked yesterday and I was getting errors for searching and not being allowed to search. I switched it back and have no more search errors and no problems searching.

So I am now concerned that I've really messed up. I have a backup of my sql database and can thus restore it. I removed the enotify tables from my db--I uninstalled and deleted enotify back in July because I really think it is the culprit in being a resources sponge. But it was still running. Well I found the tables in the db.

Well, now I cannot get to any of my boards—I can view everything but the boards—main index, admin, search function... errors for the boards and this time it is stating one of the notify tables doesn't exist...well, yeah I agree.
I'm restoring the database now.
Okay, it took awhile, but it says it is restored. BUT it's not! I just went to look in phpMyAdmin and the enotify files are not back...so it isn't restored. I uploaded the sipped file, should I have uploaded the other one?
I disabled maintenance mode to see also...and nope, no luck. I enabled maintenance mode again for the meantime.

Illori

i dont know about the restore, your host should be able to help you with that issue.

PenelopeQ

Okay, I'll let her know.

But UGH, I always feel like I"m imposing. She reasserted that all the issues are smf issue--I know the resotre is different. But still I feel like I'm bothering her.

kat


Illori

i think Christian is a guy... http://www.simplemachines.org/community/index.php?action=profile;u=6720

assuming you are talking about the person that manages your hosting.

oldpilot

Quote from: Illori on August 26, 2011, 08:41:33 AM
i think Christian is a guy... http://www.simplemachines.org/community/index.php?action=profile;u=6720

assuming you are talking about the person that manages your hosting.

Yes that is him but she was talking to

Quote from: PenelopeQAna Maria from MonteCarol Hosting thinks that we may need to start from scratch with new sites. I think that means reload a new forum--but save the databases with content, she said not to panic, that we wouldn't lose our stuff. She's not sure, but will discuss it with Crhistian when he is back. I was wondering about this same thing.

Illori

the issue seems to be with the database, so i am not sure starting over would help much.

PenelopeQ

Quote from: Illori on August 26, 2011, 09:25:41 AM
the issue seems to be with the database, so i am not sure starting over would help much.
Illori you are correct. I was just hoping that Christian would have an idea to deal with that aspect.

This has been resolved. I want to go over how and what for other users.

In essence it was simple. But first Christian had me uninstall and remove all modifications and themes and run the upgrade again. After that I still had the posting error about the table log_search_words not existing.

log_search_words is a table created with the creation of the custom search index in admin-->search-->search method
Here is what Christian from MonteCarlo Hosting said.
Quote from: ChristianYou're complaining you are using up too much space - most of it is in your database because you are logging all of the words in your forum. This does not work for larger boards.

Please see this thread and follow karl benson's advice:

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

I had already unselected the custom index radio button, but I failed to notice that next to it was a link to remove the custom index.

Removing the index solved the posting error problem and now my post count and statistics are updating automatically again.

I had performed a search for log_search_words, but maybe it was limited to this board, because I did not ever find that thread--and I don't think OldPilot would have overlooked it either.

kat

Phew!

Thank Omnipotent being that you got that one figured-out, Lady P.

It sure had me baffled... ;)

Thanks for letting us know what was going-on. It may useful, in the future. :)

oldpilot

Well thanks everyone for your help, just out of curiosity I have tried to search for that topic now by copying the title into the search box.  But that does not bring that up.

Now maybe the parameters are not correct or I should use a wildcard, but I was wondering why I can't find it?


Advertisement: