[SOLVED] "Could not get theme data for themes_id [1]&qu

[sanji]

Your phpBB Version: 2.0.22
phpBB Type: Integramod 141
MODs: Yes
Your knowledge: Advanced Knowledge
Board URL: http://www.secret-japan.com/forum_beta

PHP Version:
MySQL Version:


What was done before the problem appeared?
- created new folder for a test upgrade from 1.4.0 to 1.4.1
- changed the 1.4.1 files to add small modifications (not a lot of changes anyway)
- uploaded the modified 1.4.1 files in the new folder
- copied my 1.4.0 tables and past them in a new database
- changed URL of the board in the config table, changed cookie name in the config table
- run the xxx_update.php from the install folder to update the database : no error found


What was done to try to solve the problem?
- run this query :

Code: Select all

UPDATE `phpbb_config` SET `config_value` = '1' WHERE `config_name` = 'default_style' LIMIT 1 ;UPDATE `phpbb_config` SET `config_value` = '1' WHERE `config_name` = 'override_user_style' LIMIT 1 ;TRUNCATE phpbb_themes;INSERT INTO `phpbb_themes` (`themes_id`, `template_name`, `style_name`, `head_stylesheet`, `body_background`, `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`, `td_class2`, `td_class3`, `fontface1`, `fontface2`, `fontface3`, `fontsize1`, `fontsize2`, `fontsize3`, `fontcolor1`, `fontcolor2`, `fontcolor3`, `span_class1`, `span_class2`, `span_class3`, `img_size_poll`, `img_size_privmsg`) VALUES (1, 'Integra2', 'Integra2', 'Integra2.css', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'row1', 'row2', '', '', '', '', 0, 0, 0, '', '006600', 'ff0000', '', '', '', 0, 0);

- deleted cache folder

- deleted cookie

- checked def files permission (some were not 666, corrected)



De.scription and Message

I did not had this error the first time I tried the new 1.4.1 version. Now that I uploaded all files again, I find it impossible to see the board or the ACP.

I have checked all fixes described on the forum, and none of them solved the problem...

I finally want to underline that I do not use any personnal theme, just the classical one installed with 1.4.0...

Thanks for your help,

sanji

[Helter]

save your original "includes/def_*" files
Upload new ones from the install package, and chmod them to 666

[sanji]

I deleted all my def files, uploaded the one from the package and chmoded them back to 666.

Still...

phpBB : Critical Error

Could not get theme data for themes_id [1]

sanji

[Frost]

What theme is set as default and show your def_themes file here

[sanji]

this is my def_theme.php, which is the same as the one from the package

<?php
/***************************************************************************
* def_themes_def.php
* ------------------
* begin : 12/11/2003
* copyright : Ptirhiik
* email : <a>admin@rpgnet-fr.com</a>
*
* version : 1.0.0 - 12/11/2003
*
* last update : 2006-07-08 04:16:42 (GMT) by Michaelo *
***************************************************************************/

/***************************************************************************
*
* 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' => 'Integra2', 'style_name' => 'Integra2', 'head_stylesheet' => 'Integra2.css', 'body_background' => '', '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' => '0', 'fontsize2' => '0', 'fontsize3' => '0', 'fontcolor1' => '', 'fontcolor2' => '006600', 'fontcolor3' => 'ff0000', 'span_class1' => '', 'span_class2' => '', 'span_class3' => '', 'img_size_poll' => '0', 'img_size_privmsg' => '0'),
);
?>

This is what I have in my themes table:

...
VALUES
(1, 'Integra2', 'Integra2', 'Integra2.css', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'row1', 'row2', '', '', '', '', 0, 0, 0, '', '006600', 'ff0000', '', '', '', 0, 0);

and my themes_name table:

...
VALUES
(1, 'The lightest row colour', 'The medium row color', 'The darkest row colour', '', '', '', 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', '', 'Background for topic posts', '2nd background for topic posts', '', 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', '', '', ''),
(2, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(3, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(4, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

I have 4 entries for themes_name and only 1 for themes, is that normal?


Default theme is number 1.


Thanks for your help,

sanji

[Whisky]

Yes it's normal the themes_name table just contains explanations about the css fields.

I had a similar problem and I fixed manually by modifiying the def_themes.php but looking at yours all seems to be correct on server/DB side so maybe its a problem in your cache or with a cookie still pointing on a previous theme, the strange thing is that he groans about the theme ID 1 and this one exists in your DB <img>
Did you deleted your cookies?

[Frost]

Your def_themes is fine, it's showing that Integra2 is the only theme installed

This could only mean a cache/cookie problem like they said.

Considering that you're locked out of your board you need to open your ftp program and manually delete all your cache files.

Then open your browser and without going to your site, go and delete all of your cookies. Then shut the browser (and all instances) down completely.

Now re-open your browser and go to your site. If it still gives the error then you are missing files in your Integra2 theme. Meaning you might have moved it or deleted it/or files of it on accident.

If you delete cookies, delete cache, re-visit your site, check to ensure your theme is there in entirety and you're still locked out. I would really be interested in having a closer look at your site because it is possessed <img>

[sanji]

Still the same problem...

... but I can't hate integrmod, as it seems I am responsible for the problem: the original 1.4.1 files are working fine, but when I upload my modified 1.4.1 files, the site crashes. The strange thing is that even if I upload the original files again, the site still stays offline. I need to wiped the folder on the server and upload everything again!

I only have very limited modifications - Teelks' change for 2 qbars, some small modifications on the bbcode, removing the cache of the forum structure...

I am now uploading one modified file after the other to try to find where the error is coming from.

sanji

[sanji]

OK!

Finally, I got it work. It took about 30 hours of work to understand the problem...

On 1.4.0, I could not cache the forum structure, and therefore commented the function_category_hierarchy file calling the cache files.
On 1.4.1, if you do not use the cache, the forum seems to have a problem: I always got this "Could not get theme data for themes_id [1]" error...

What I did was to uncomment the lines calling the cache in function_category_hierarchy.php, delete the def_tree.php file, go on the ACP and resync the forum.

It seems to work so far...

But it was really though to find the problem...

Thanks to those who helped.

sanji