Nukemods Forum - View Single Post

glimras · **Site Crashed during an upgrade/update -** 03-04-2006, 08:31 AM

I'm not very PHP-Nuke competent at this point but have been trying to help out a group that has a site at www.kystrel.com. The site currently has a temporary page up with an exit; statement at the beginning of the <php> segment of index.html. I can remove that if someone needs to look at the current state of the index.php page and if looking at it will help someone help me.

Their previous webmaster, a college student working on the site in his spare time had installed a nukemod theme originally and the site worked great. Two fridays ago, he upgraded the theme to a platinum theme 7.6.b.4. I believe he got it from www.nukeplanet.com run by Loki, but that site is no help as it is down now. Something went terribly wrong and nothing has been the same since. I'm not sure if he didn't finish the steps necessary to make the change or what.

Modules that were there before are not there now. He suddenly was using up a 100 mbs more space then was allocated on the server. Graphics on the main page were gone. Users couldn't log in. The message boards could be gotten to through admin pages but none of the posts could access the database so they all came back with SQL errors.

I believe I have located a good backup of the data files from that morning before he started. I'm not so sure if they have a good backup of the database from that same time frame. I came to this site because their is a link on the site that links to nukemods and it said that the theme was from this site.

Can anyone provide me some guidance or point me in the right direction to find good instructions on restoring a php-nuke site from a backup?

You can reach me at glimras@aim.com.

Thanks in advance for any help you can provide.

Dale

P.S. When I try to open a post from the forums/message board, I get this error.

Could not obtain post/user information.

DEBUG MODE

SQL Error : 1054 Unknown column 'u.user_items' in 'field list'

SELECT u.username, u.user_color_gc, u.user_cash, u.user_id, u.user_items, u.user_privs, u.user_effects, u.user_custitle, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_allow_viewonline, u.user_session_time, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM nuke_bbposts p, nuke_users u, nuke_bbposts_text pt WHERE p.topic_id = '346' AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 602
File : viewtopic.php

Any help would be appreciated.

	(#1 (permalink))
glimras Junior Member Status: Offline Posts: 4 Join Date: Mar 2006	Site Crashed during an upgrade/update - 03-04-2006, 08:31 AM I'm not very PHP-Nuke competent at this point but have been trying to help out a group that has a site at www.kystrel.com. The site currently has a temporary page up with an exit; statement at the beginning of the <php> segment of index.html. I can remove that if someone needs to look at the current state of the index.php page and if looking at it will help someone help me. Their previous webmaster, a college student working on the site in his spare time had installed a nukemod theme originally and the site worked great. Two fridays ago, he upgraded the theme to a platinum theme 7.6.b.4. I believe he got it from www.nukeplanet.com run by Loki, but that site is no help as it is down now. Something went terribly wrong and nothing has been the same since. I'm not sure if he didn't finish the steps necessary to make the change or what. Modules that were there before are not there now. He suddenly was using up a 100 mbs more space then was allocated on the server. Graphics on the main page were gone. Users couldn't log in. The message boards could be gotten to through admin pages but none of the posts could access the database so they all came back with SQL errors. I believe I have located a good backup of the data files from that morning before he started. I'm not so sure if they have a good backup of the database from that same time frame. I came to this site because their is a link on the site that links to nukemods and it said that the theme was from this site. Can anyone provide me some guidance or point me in the right direction to find good instructions on restoring a php-nuke site from a backup? You can reach me at glimras@aim.com. Thanks in advance for any help you can provide. Dale P.S. When I try to open a post from the forums/message board, I get this error. Could not obtain post/user information. DEBUG MODE SQL Error : 1054 Unknown column 'u.user_items' in 'field list' SELECT u.username, u.user_color_gc, u.user_cash, u.user_id, u.user_items, u.user_privs, u.user_effects, u.user_custitle, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_allow_viewonline, u.user_session_time, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM nuke_bbposts p, nuke_users u, nuke_bbposts_text pt WHERE p.topic_id = '346' AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15 Line : 602 File : viewtopic.php Any help would be appreciated.