Server died... restore shows Critical Errors!

[gcomfx.com]

Your phpBB Version: 2.0.22
phpBB Type: Integramod 141
MODs: No
Your knowledge: Basic Knowledge
Board URL: http://100mphclub.com/community

PHP Version:
MySQL Version:


What was done before the problem appeared?
My server died... they restored it (finally) and now I have critical errors.


What was done to try to solve the problem?
Replaced the DEF folder and checked all permissions.



De.scription and Message

Help! My server finally restored all 14 of my sites. Now my integramod 1.4.1 is jacked.

http://www.100mphclub.com/community

-----------------

Critical Error!
message_die() was called multiple times.

Error #1
Could not read list informations

Line : 511
File : /home/club100/public_html/community/profilcp/def/def_userfuncs.php
SQL :
SELECT th.*, (th.themes_id) AS _list_key, (th.style_name) AS _list_txt
FROM (phpbb_themes AS th)
ORDER BY th.style_name, th.themes_id


Error #2
Could not obtain moderator status

Line : 62
File : /home/club100/public_html/community/profilcp/functions_profile.php
SQL : SELECT * FROM phpbb_auth_access aa, phpbb_user_group ug WHERE ug.user_id = 583 AND aa.group_id = ug.group_id AND aa.auth_mod = 1 AND ug.user_pending = 0
----------------------------

I have not upgraded to .23 - should I do this and then try to fix the issues? What files do I NOT replace from a fresh install?

[gcomfx.com]

I'm not sure if it's related or not... but every photo album I have up on my server is dead as well.

http://www.gcomfx.com/gallery

[gcomfx.com]

I did a fresh install of Integramod 1.4.1 - copied over my config.php file. Ended in the same result:

http://www.100mphclub.com/community2/

Please tell me my database isn't fubared. <img>

[gcomfx.com]

Fresh install with a brand new database... and it's working.

Ugh. My database must be the issue. I'm trying to find out if my host has a backup from right before the server crash.

Mine is several months old. <img>

[gcomfx.com]

http://100mphclub.com/community2 is a fresh install with a database from Oct. of 07... ugh. I hate to start that far back, but at least it's something.

Still waiting to see what my stupid host can dig up for a back up.

Reminder for everyone... go back up your data. I know it's a PITA.... Just go do it. LOL

[CaNNon]

Damn I really hope they have one for you!
Didn't you set a db back up as a cron job?

[gcomfx.com]

The automatic backup has been broke in IM for a while hasn't it?

I only know how to do it through Cpanel manually.

Anyone out there any good at repairing a database? I have a copy of the current one that is corrupt. The first error is that "phpbb_themes" table is missing. I was going to try to fix this and try it again. Who knows how many are fubared though. <img>

[gcomfx.com]

What a mess... the database I need is missing 6 tables.

I added them from the working (old database of Oct. 07) and now I get this:

http://100mphclub.com/community

It's trying! Any ideas?

[gcomfx.com]

Going to try an older backup. For reference here is the new errors listed once I created the missing tables:

---------------------

General Error

Couldn't get banners data

DEBUG MODE

SQL Error : 1054 Unknown column 'banner_level' in 'where clause'

SELECT DISTINCT banner_id, banner_name, banner_spot, banner_de.scription, banner_forum, banner_type, banner_width, banner_height, banner_filter FROM phpbb_banner WHERE banner_active AND IF(banner_level_type,IF(banner_level_type=1,2<banner_level>=banner_level,2<>banner_level)),banner_level=2) AND (banner_timetype=0 OR (( 1716 BETWEEN time_begin AND time_end) AND ((banner_timetype=2 OR (( 0 BETWEEN date_begin AND date_end) AND banner_timetype=4) OR (( 20080323 BETWEEN date_begin AND date_end) AND banner_timetype=6) )))) ORDER BY banner_spot,banner_weigth*SUBSTRING(RAND(),6,2) DESC

Line : 876
File : page_header.php

[gcomfx.com]

I'm about to go insane. I had it fixed! I finally found a corrupt name in (a category title???) in the banner table. It had some part of a query listed in the title. I edited it to be the "banner_level" and all was good. I was getting ready to turn my site back on for people to log in.... and wham. Lost the connection to the database. Went and checked. It was GONE! Then it was back with 4 empty tables. Now there is an empty database with the same name and _backup in it.

My host must be working on it.... I have no idea. But I'm pissed! It took 10 hours to get this going and get a descent backup from them plus fix the error.

I'm afraid to upload the database and fix it again as they might delete it again. GRRRRR..... I can't wait to move my sites away from this host.

Thanks.... needed to vent.

[gcomfx.com]

Ugh... uploading the backup again, even in a new location. It stops at 4 tables when it unzips. Guess I'm waiting on the everlasting support ticket for answers.

I may just head on to a new host and start all over. <img>

[gcomfx.com]

I tired a new tactic... got a new error. I took the exact same database as before, and tried to import it straight into phpmyadmin.

__________________

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ble `phpbb_album`

LOCK TABLES `phpbb_album` WRITE' at line 1

[CaNNon]

The automatic backup has been broke in IM for a while hasn't it?

I don't think so I've been using it since I installed, never had any issues with it at all.

I really wish I could help but I suck with the db!

[gcomfx.com]

Okay, found out the database is corrupt. It has the comment fields randomly screwed up in the text of the SQL file. I've been able to upload them in phpmyadmin and get them to show their ugly face one at a time. I've found two and fixed them, but now I'm beyond the 300 time limit of phpmyadmin. LOL

So time to try the backup upload and see if it crashes it or not. Wish me luck.

--------------

-- Sending SELECT query...
-- Retrieving rows...

----------------

Above is the culprit. It's randomly all over the database. <img>

Trying a find and replace now.

[Helter]

you can use bigdump if you exceed the phpmyadmin size limit. As for your themes tables, you can safely delete them and upload new ones from the IM141 install. Just be sure to upload a new include/def_themes chmod to 666 and edit the default theme in your database phpbb_config. set it to theme 1
you also need to be sure Integra2 is in the theme folder

[gcomfx.com]

I've been going through the database. I think I've fixed most of the errors... but I'm stuck on this one:

---------------------

CREATE TABLE `phpbb_groups` (
`group_id` mediumint( 8 ) NOT NULL AUTO_INCREMENT ,
`group_type` tinyint( 4 ) NOT NULL default '1',
`group_name` varchar( 40 ) NOT NULL default '',
`group_de.scription` varchar( 255 ) NOT NULL default '',
`group_moderator` mediumint( 8 ) NOT NULL default '0',
`group_single_user` tinyint( 1 ) NOT NULL default '1',
`group_count` int( 4 ) unsigned default '99999999',
`group_count_max` int( 4 ) unsigned default '99999999',
`group_count_enable` smallint( 2 ) unsigned default '0',
`group_amount` float default '0',
`group_period` int( 11 ) default '1',
`group_period_basis` varchar( 10 ) default 'M',
`group_first_trial_fee` float default '0',
`group_first_trial_period` int( 11 ) default '0',
`group_first_trial_period_basis` varchar( 10 ) default '0',
`group_second_trial_fee` float default '0',
`group_second_trial_period` int( 11 ) -- Sending SELECT default '0',
`group_second_trial_period_basis` varchar( 10 ) default '0',
`group_sub_recurring` int( 11 ) default '1',
`group_sub_recurring_stop` int( 11 ) default '0',
`group_sub_recurring_stop_num` int( 11 ) default '0',
`group_sub_reattempt` int( 11 ) default '1',
PRIMARY KEY ( `group_id` ) ,
KEY `group_single_user` ( `group_single_user` )
) ENGINE = MYISAM AUTO_INCREMENT =1012 DEFAULT CHARSET = latin1;


MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group_second_trial_period_basis` varchar(10) default '0',
`group_sub_recurring' at line 18

-------------------------

Visually I don't see what is wrong with it. But I'm not a coder, so I'm just trying to match patterns. LOL Help??

[gcomfx.com]

Is it "-- Sending SELECT "

Damn this random code BS.

[gcomfx.com]

you can use bigdump if you exceed the phpmyadmin size limit. As for your themes tables, you can safely delete them and upload new ones from the IM141 install. Just be sure to upload a new include/def_themes chmod to 666 and edit the default theme in your database phpbb_config. set it to theme 1
you also need to be sure Integra2 is in the theme folder

What is Bigdump? Also, I'm new to this SQL editing world. All I have is TextEdit on my Mac. Is there anything I can use that will check the database before I try to upload it?

And where in the world are these extra comments in the database coming from? Was it the automatic backup builder timing out?

[gcomfx.com]

My post is gone... interesting.

Well, I guess I'll post again that I was able to get the database fixed and all is well!!!

I ended up manually going through the database in textedit. There were a bunch of places that comments generated by phpmyadmin were tossed in with the normal code and screwed it all up.

I still couldn't get the whole database to upload in one session. So I manually added the last few tables and all is well with the world. <img>

[Helter]

glad it worked out for you. db can be a real pain at times

[gcomfx.com]

glad it worked out for you. db can be a real pain at times

Yes very much so, especially when you are a designer not a coder. I didn't even know if what I did was going to work, but I'm learning the hard way! <img>