Database repair

Ledo2 - December 21, 2008 - 03:17

I am new to Drupal and in process of making new markup for my site and dessign i made some content. So the site is not empty. I don't care about these data. So anything can happen to it. But for learning here is one sittuation i produced.

I used backup and migrate module. And didn't export everything. Beacose i had a lot of unwanted setings and menus an primary links and everything in the database. I was playing arround with everything so it was a mess.

So on clean installation i imported only a few databases. Basically story, page and some forum posts. I can do with them everything normally. And they are as they were. I can reply to them normally and move them arround. I made a new forum and put forum topics in it. I can put story ona a front page and everything. But everytime i reply to these content or move them i get a lot of these:

user warning: Table 'drupal.search_dataset' doesn't exist query: UPDATE search_dataset SET reindex = 1229828778 WHERE sid = 24 AND type = 'node' in modules\search\search.module on line 625.

And other simular outputs.

I did a upgrade.php nd cron.php and reindex the search. But didn't fix it.

So is these data usless and only good for deletion or i could repair it and use it normally again?

What do you mean "imported

cog.rusty - December 21, 2008 - 12:02

What do you mean "imported only a few databases"? How? If you mean "only a few tables from the database", that is not possible. The tables in a Drupal database can't be moved independently, because they contain references to each other and are meant to be used together.

You could try to disable the search module in admin/build/modules, then click on the "Uninstall" tab to uninstall it, and then enable it again to make it rebuild its missing tables. However, if you did move some database tables selectively, expect more problems.

U tried uninstalling search module

Ledo2 - December 21, 2008 - 14:56

I tried as you suggested but still the same. Probably the database is corupted beacose it mising some tables or something.

I manage to corupt it with backup and restore module somehow. When i exported just a few tables. I don't care about these data. But i am glad i did these to this data and not later on with real data from users.

Probabbly as you said some tables with some neded information are missing and Drupal can't just made new ones for them.

 
 

Drupal is a registered trademark of Dries Buytaert.