My SQL server crashed

Hangin' Around Joined: May 14, 2006 Posts: 25

My providers SQL server crashed. Devistating for me.

They are working on recovering the database but meanwhile they have copied over what they say is the database. I have no access to myphpadmin but will get it sooner or later.

Anyway... To maintain the site while the sql server is f***ed up, I want to do whatever I can do.

The news table seems to be intact. However, no modules are shown in the admin panel and the main site is only displaying blocks. If someone could please let me know how the table that see what modules are avaliable, which one is in home etc looks I could use BigDump or something to put it in so that we can have a functioning news section while the database is being fixed.

Oh and I get this error on the site:

Unknown column 'topicid' in 'field list'
Unknown column 'topicid' in 'field list'

Thanks in advance.

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

Sounds like problems with the table structure. The admin panel modules function uses the modules table. Do you see modules in your menu menu?

Posted: Tue Jul 08, 2008 7:03 am

I'm unable to load that menu. I think the server is back to my old phpnuke 7.8 database.

The news module works. The "old articles" block works. I just need to put that module in home.

Posted: Thu Jul 10, 2008 2:39 am

Seems like the only 2 tables that doesn't work are this one and the blocks table.

Which table is listing the modules etc? Does anyone have the structure so I can just add/replace it on my mysql server?

registered · Posted: Thu Jul 10, 2008 7:18 am

Malke, take a look in the original INSTALLATION/sql directory. There is a core sql file there which has all the table create code and the default data to insert...

Posted: Thu Jul 10, 2008 8:02 am

thanks. i think i'll just re-install and then insert the backup tables for config, content and news. if i restore 2-3 tables it could turn out that more tables are damaged. It's probably safest to do it this way.