Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues
Author Message
Malke
Hangin' Around


Joined: May 14, 2006
Posts: 25

PostPosted: Tue Jul 08, 2008 5:01 am Reply with quote

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.
 
View user's profile Send private message
kguske
Site Admin


Joined: Jun 04, 2004
Posts: 6383

PostPosted: Tue Jul 08, 2008 6:31 am Reply with quote

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

_________________
I google, therefore I exist...
Only registered users can see links on this board! Get registered or login!
 
View user's profile Send private message
Malke
PostPosted: Tue Jul 08, 2008 7:03 am Reply with quote

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.
 
Malke
PostPosted: Thu Jul 10, 2008 2:39 am Reply with quote

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?
 
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9453
Location: Arizona

PostPosted: Thu Jul 10, 2008 7:18 am Reply with quote

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...

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
Malke
PostPosted: Thu Jul 10, 2008 8:02 am Reply with quote

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.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©