|
Page 1 of 1
|
 Chaotic 
Joined: January 2008
Posts: 1369
Location:  Georgia
|
 SOLVED - Critical Error (Themes)
Hello,
I was downgraded IP in the hopes of upgrading to phpBB3, but it looks like my attempt was futile. I used the downgrader that came with the latest IP release, in the contrib folder. I didn't get an error when running this file either. I installed phpBB3 in a new directory on my site, but the conversion did not go as planned. I have SQL backups of my original IP site, but my downgraded SQL was corrupted without me knowing. The downgraded SQL was going to be used for conversion to phpBB3.
Another problem I have is I don't have my original IP site or original database information up anymore...that's the real kicker. I'm trying to install IP again so I can hopefully restart the conversion process, but I'm getting an error:
Critical Error
Could not get theme data for themes_id []
DEBUG MODE
Line : 1010
File : functions.php
Something is missing in my database but I can't round it down to a more specific area of the problem.
Does anyone have an idea on how to resolve this error? My original IP board had 30k posts, so I'm trying to hold on to those if I possibly can.
Thanks in advance
____________ | Icy Phoenix ColorizeIt! |
Bipolar Disorder - Not good for you and definitely not good for everyone else.
Last edited by Guest on Wed 18 Jun, 2008 11:59; edited 1 time in total |
#1 Tue 17 Jun, 2008 03:22 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
| |
Chaotic
Joined: January 2008
Posts: 1369
Location: Georgia
|
Re: Critical Error (Themes)
Didn't work... 
____________ | Icy Phoenix ColorizeIt! |
Bipolar Disorder - Not good for you and definitely not good for everyone else.
|
#3 Tue 17 Jun, 2008 05:23 |
|
xmenfile
Joined: September 2007
Posts: 482
Location: Right in front of my computer
|
Re: Critical Error (Themes)
|
#4 Tue 17 Jun, 2008 06:55 |
|
Inactive User
|
Re: Critical Error (Themes)
Try this:
Edit: /includes/def_themes.php
Remove everything between:
$themes_style = array(
And
);
Keep a copy (Just in case that don't work) and then try removing the LAST 1 - (nothing else "and it could be different digit in the string"):
1 => array('themes_id' => '1',
If there's no themes in def_themes.php delete the whole content of the page and replace with the code below. Then if it still can't find theme [2] - [6] or whatever, change the 1 digits to whatever it is trying to find.
<?php
/***************************************************************************
* def_themes_def.php
* ------------------
* begin : 12/11/2003
* copyright : Ptirhiik
* email : admin@rpgnet-fr.com
*
* version : 1.0.0 - 12/11/2003
*
* last update : 2008-06-13 08:12:34 (GMT) by Lopalong *
***************************************************************************/
/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
*
***************************************************************************/
if ( !defined('IN_PHPBB') )
{
die('Hacking attempt');
exit;
}
//--------------------------------------------------------------------------------------------------
//
// $themes_style : templates
// --------------
//--------------------------------------------------------------------------------------------------
$themes_style = array(
1 => array('themes_id' => '1', 'template_name' => 'mg_themes', 'style_name' => 'Icy Phoenix', 'head_stylesheet' => 'style_ice.css', 'body_background' => 'ice', 'body_bgcolor' => '', 'body_text' => '', 'body_link' => '', 'body_vlink' => '', 'body_alink' => '', 'body_hlink' => '', 'tr_color1' => '', 'tr_color2' => '', 'tr_color3' => '', 'tr_class1' => '', 'tr_class2' => '', 'tr_class3' => '', 'th_color1' => '', 'th_color2' => '', 'th_color3' => '', 'th_class1' => '', 'th_class2' => '', 'th_class3' => '', 'td_color1' => '', 'td_color2' => '', 'td_color3' => '', 'td_class1' => 'row1', 'td_class2' => 'row2', 'td_class3' => '', 'fontface1' => '', 'fontface2' => '', 'fontface3' => '', 'fontsize1' => '10', 'fontsize2' => '11', 'fontsize3' => '12', 'fontcolor1' => '', 'fontcolor2' => '22BB33', 'fontcolor3' => 'DD2222', 'span_class1' => '', 'span_class2' => '', 'span_class3' => '', 'img_size_poll' => '0', 'img_size_privmsg' => '0', 'online_color' => '008000', 'offline_color' => 'DD0000', 'hidden_color' => 'EECC00'),
);
return;
?>
It's as if there was no theme installed - Strange stuff ? So you may have to end up editing the "default style" in the Db Dump.
Edit: Sorry xmenfile - I wasn't aware you were posting at the same time.
|
#5 Tue 17 Jun, 2008 17:32 |
|
Chaotic
Joined: January 2008
Posts: 1369
Location: Georgia
|
Re: Critical Error (Themes)
I have a backup of all the important SQL (phpbb_posts, phpbb_users, phpbb_forums, phpbb_categories, phpbb_config, phpbb_topics).
When I delete the defaults of posts, forums, categories, config, and topics, the forum is in working order. When I remove phpbb_users and replace it with my old phpbb_users, I start getting the error.
I removed everything and started uploading everything again today. I also got a different error:
Critical Error
Could not update user theme info
DEBUG MODE
SQL Error : 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 '' at line 3
I uploaded the aphrodite template folder as well since it was installed before I tried to upgrade to phpBB3.
I tried what you posted, but it didn't seem to fix the problem. Do you have any other suggestions? I appreciate the help you are giving me! 
____________ | Icy Phoenix ColorizeIt! |
Bipolar Disorder - Not good for you and definitely not good for everyone else.
|
#6 Tue 17 Jun, 2008 19:40 |
|
Inactive User
|
Re: Critical Error (Themes)
When installing IP, unless you deliberately tell the SQL to use the phpbb_ prefix, the default is ip_
Are you mixing up prefixes in the Db ? because you have me confused with my "Old" phpbb_ - my "new" install of IP etc?
|
#7 Wed 18 Jun, 2008 00:22 |
|
Chaotic
Joined: January 2008
Posts: 1369
Location: Georgia
|
Re: Critical Error (Themes)
In the install, I'm changing the prefix from ip_ to phpbb_. All my database entries have the phpbb_ prefix.
The board I'm trying to convert had tables of the same prefix too, phpbb_.
____________ | Icy Phoenix ColorizeIt! |
Bipolar Disorder - Not good for you and definitely not good for everyone else.
|
#8 Wed 18 Jun, 2008 01:55 |
|
Inactive User
|
Re: Critical Error (Themes)
Thanks, That clears that up.
Next silly question:
Are you manually changing the dump with your "old" backups, or are you dropping - creating tables with SQL ?
|
#9 Wed 18 Jun, 2008 02:26 |
|
Chaotic
Joined: January 2008
Posts: 1369
Location: Georgia
|
Re: Critical Error (Themes)
I am manually changing the newly installed tables and installing my "old" backups.
I believe I changed all the tables correctly to reflect the latest dump, but am getting a different error message:
Critical Error
Could not obtain ban information
DEBUG MODE
SQL Error : 1054 Unknown column 'ban_expire_time' in 'field list'
SELECT ban_ip, ban_userid, ban_email, ban_email, ban_expire_time, ban_priv_reason, ban_pub_reason_mode, ban_pub_reason FROM phpbb_banlist WHERE ban_ip IN ('443c0528', '443c05ff', '443cffff', '44ffffff') OR ban_userid = -1
Line : 170
File : sessions.php
____________ | Icy Phoenix ColorizeIt! |
Bipolar Disorder - Not good for you and definitely not good for everyone else.
|
#10 Wed 18 Jun, 2008 03:09 |
|
Inactive User
|
Re: Critical Error (Themes)
This makes interesting reading?
h**p://***.google.com.au/search?hl=...le+Search&meta=
h**p://forums.jumba.com.au/showthread.php?t=303
|
#11 Wed 18 Jun, 2008 04:06 |
|
Chaotic
Joined: January 2008
Posts: 1369
Location: Georgia
|
Re: Critical Error (Themes)
After a TON of going back and forth between the new DB entries and my backup, I finally got it working. All the problems were in the database. I just edited a little bit of the installation code for IP to include my backup.
I still love IP and still have another website that will continue to use this CMS.
Thanks for all your help Lopalong. You can edit my topic title to show "solved."
Thanks again buddy.
____________ | Icy Phoenix ColorizeIt! |
Bipolar Disorder - Not good for you and definitely not good for everyone else.
|
#12 Wed 18 Jun, 2008 08:42 |
|
Inactive User
|
Re: Critical Error (Themes)
I'm glad that you had the expertise to fix it.
Too easy to make mistakes manually editing - that's why I stopped doing it a L.O.N.G way back, unless it is absolutely necessary.
Damn! how did I miss that - Know the feeling!
|
#13 Wed 18 Jun, 2008 08:57 |
|
|
|
Page 1 of 1
|
 Was this topic useful?
 Was this topic useful?
| Link this topic |
|---|
| URL |
|
| BBCode |
|
| HTML |
|
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events
|
|
|
|
