phpBB : Critical Error

[genxweb]

Your phpBB Version: 2.0.22
phpBB Type: Integramod 141
MODs: No
Your knowledge: Beginner
Board URL: http://www.divepa.com

PHP Version:
MySQL Version:


What was done before the problem appeared?
Site was hacked and i decided to upgrade to 1.4.1 instead of just trying to reload 1.4.0. I saved the old config.php file and uploaded all the 1.4.1 files minus the install , prill install and config.php. I than uploaded the 1.4.1 upgrade install dir and upgraded the forum.


What was done to try to solve the problem?
I have tried to use the following fixes

cookieMod
Clearing my browsers cache as well as trying from a totaly different machine.
I have tried running the sql code to truncate the php_themes and the sql code to have it use integramod2 theme instead.
I have replaced the def_themes.php file with one a admin uploaded to another post.
I have spent two days on these forums and googles looking for help.



De.scription and Message

phpBB : Critical Error

Could not get theme data for themes_id [2]

As you can see I have tried several of the posted fixes for this and none have worked. No matter what I do I can not view any integramod page without that error including the admin section which rules out me being able to uninstall a theme and reinstall it.

My sites been down for three days now can some one please help. I am even at the point that if some one can install 1.4.1 for me, with all my data intact I will pay them. Cant afford much since it is a money making site but I could pay 10.00 for a successful complete 1.4.1 migration.

Note: if it will be easier to migrate with a roll back I can have my site rolled back via cpanel backups.

Thanks
mike

[Helter]

upload the def_themes from the 141 package and chmod it to 666.

open your db in phpmyadmin. edit phpbb_config.
find "default_style 2" change to "default_style 1"

run this sql

Line number On/Off | Expand/Contract | Select all

 DROP TABLE IF EXISTS `phpbb_themes`;CREATE TABLE `phpbb_themes` (   `themes_id` mediumint(8) unsigned NOT NULL auto_increment,   `template_name` varchar(30) NOT NULL default '',   `style_name` varchar(30) NOT NULL default '',   `head_stylesheet` varchar(100) default NULL,   `body_background` varchar(100) default NULL,   `body_bgcolor` varchar(6) default NULL,   `body_text` varchar(6) default NULL,   `body_link` varchar(6) default NULL,   `body_vlink` varchar(6) default NULL,   `body_alink` varchar(6) default NULL,   `body_hlink` varchar(6) default NULL,   `tr_color1` varchar(6) default NULL,   `tr_color2` varchar(6) default NULL,   `tr_color3` varchar(6) default NULL,   `tr_class1` varchar(25) default NULL,   `tr_class2` varchar(25) default NULL,   `tr_class3` varchar(25) default NULL,   `th_color1` varchar(6) default NULL,   `th_color2` varchar(6) default NULL,   `th_color3` varchar(6) default NULL,   `th_class1` varchar(25) default NULL,   `th_class2` varchar(25) default NULL,   `th_class3` varchar(25) default NULL,   `td_color1` varchar(6) default NULL,   `td_color2` varchar(6) default NULL,   `td_color3` varchar(6) default NULL,   `td_class1` varchar(25) default NULL,   `td_class2` varchar(25) default NULL,   `td_class3` varchar(25) default NULL,   `fontface1` varchar(50) default NULL,   `fontface2` varchar(50) default NULL,   `fontface3` varchar(50) default NULL,   `fontsize1` tinyint(4) default NULL,   `fontsize2` tinyint(4) default NULL,   `fontsize3` tinyint(4) default NULL,   `fontcolor1` varchar(6) default NULL,   `fontcolor2` varchar(6) default NULL,   `fontcolor3` varchar(6) default NULL,   `span_class1` varchar(25) default NULL,   `span_class2` varchar(25) default NULL,   `span_class3` varchar(25) default NULL,   `img_size_poll` smallint(5) unsigned default NULL,   `img_size_privmsg` smallint(5) unsigned default NULL,   PRIMARY KEY  (`themes_id`)) TYPE=MyISAM ;  -- -- Dumping data for table `phpbb_themes`--  INSERT INTO `phpbb_themes` VALUES (1, 'Integra2', 'Integra2', 'Integra2.css', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'row1', 'row2', '', '', '', '', 0, 0, 0, '', '006600', 'ff0000', '', '', '', 0, 0);INSERT INTO `phpbb_themes` VALUES (2, 'fisubice', 'FI Subice', 'fisubice.css', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'row1', 'row2', '', '', '', '', 0, 0, 0, '', '006600', 'ff0000', '', '', '', 0, 0);      

be sure that fisubice is also in your templates folder

delete your browser cache.

[genxweb]

Thank you that worked.

Though now I get this error while trying to login

Error in obtaining userdata

DEBUG MODE

SQL Error : 1054 Unknown column 'ct_login_count' in 'field list'

SELECT user_id, username, user_password, user_active, user_level, user_rank, user_actviate_date, user_expire_date, user_regdate, user_login_tries, user_last_login_try, ct_login_count FROM phpbb_users WHERE username = 'michael'

Line : 94
File : login.php


And there is also no data in my forums.

[genxweb]

It looks like that ct_login_count should be in phpbb_users as a column but it is not there. I only have these colums that start with ct
ct_logintry int(2)
ct_unsucclogin int(10)
ct_pwreset int(2)
ct_mailcount int(10)
ct_postcount int(10)
ct_posttime int(10)
ct_searchcount int(10)
ct_searchtime int(10)

If I am correct and I am missing this how could I add it. If not can some one help me correct this issue. I think once this is done there will be only one other issue to resolve which will be getting the data back into the forums.

Thanks for all the help so far
Mike

[genxweb]

Once ct_login was added I get more missing colums. Is there a way to upgrade my databse to the 1.4.1 fully without having all these issues.

[genxweb]

I fixed the ct_ errors on login by importing the schema from 1.4.1 for users only.

My last issue is getting all my forum data to show. If some can help me with what I need to do to get the forums to show all data and not just some it be greatly appreciated.

[Helter]

be sure that includes/def_tree.php is chmoded to 666
go to acp/Forum Admin/Managment+ and use the "Resync" button at the bottom

[genxweb]

so close yet so far. As admin the site looks fine and I went to re-enable the board and got this error

SECURITY ALERT ÂÂÂ » ÂÂÂ » ÂÂÂ » ÂÂÂ »
CBACK CrackerTracker has detected a potential attack on this site with a worm or exploit .script so the Security System stopped the .script.


If you can see this page after including a new MOD into your board or after clicking on a link please contact the Board Administrator with this error message and a de.scription what you have done before you could see this page, that the Admin has the possibility to fix the problem.

If some one knows how to fix this it will be greatly apreciated. I am currently checking the forum for a solution.

[genxweb]

Site is up and running. Thanks for the help. I fixed the ct worm error by enabling debugging and lowering the security level of the errored pages to low.

[.QUACK.Major.Pain]

I've also found that the debugging fix setting security to medium doesn't fix the problem.
I too have had to change to Low on most of my fixes to get past CT errors.

[genxweb]

The funny thing is everything is workign accept prillian it is showing the critical phpbb template error. I have just disabled it for now but would like to fix that if any one knows how.

[Frost]

Can you paste the exact error in whole here, or a screenshot of the prillian box with the error