Codezwiz >> Forums >> General PHP Nuke Help >> fixing a buggy php-nuke forum theme?

Heya, I had installed the Topaz theme on my php-nuke site and it turned out reall nice. Then I went to the forums admin menu (from link in phpadmin) and changed the theme there, but the theme doesn't work there and I can't get in to change it back to the default (subSilver). I tried renaming subSilver to Topaz but that didn't work. Here's the error I get when I try and access the forums from the php-nuke admin menu:

phpBB : Critical Error

Could not open subSilver template config file

DEBUG MODE

Line : 370
File : /home/swg-dean/.panel/web/portal/cms/includes/functions.php

Any help would be greatly appreciated!

You dont need to change that style. Only the admin area is in subSilver and you can easily change that. To fix your problem log into your phpmyadmin and run this as SQL query.

UPDATE nuke_bbconfig SET config_value = '1' WHERE config_name = 'default_style';

Ok, seems we are getting closer.

Here is what I had
subSilver theme_id 1
Topaz theme_id 2

after changing the subSilver name to Topaz didn't work, I deleted the Topaz thinking that if it couldn't find the theme it would revert back to the default theme. When that didn't work I went in and changed the subSilver theme_id from 1 to 2. ( should have mentioned it the first time, but I forgot I had changed that, I'm reelly really sorry!)

Anyways, if I leave subSilver theme_id at 2 I get this:

phpBB : Critical Error

Could not get theme data for themes_id [1]

but if I go in and change the subSilver theme_id back to 1 I get the original error message I posted the first time.

If you know how I can fix this, would it be to much trouble to post a brief explenation of why this is doing what it's doing? I don't just want to fix the problem, I really want to know what's causing it in the first place and hopefully I can learn a bit from it.

On a side note, I don't know if it's a browser error or something to do with your site, but I get an empty dropdown box on the right side of the screen that just kinda cuts right through the middle of everything, scrolling it down off the page fixes the dispaly problem. Just thought I'd mention it incase it might not be just me but something buggy here.

Ok, I'm just making matters worse

I just 'had' to fix it myself

I have a stand alone version of phpbb, and the messed up phpbb that's part of my nuke site.

Allways the one to impulsivly (sp?) slam the big red DO NOT TOUCH button repeatedly, I managed to drop my phpbb_config (it looks to me like it's just moved to the bottom of the list?)

I thought I was being a smarty when I figured out I could copy files from one database to another, hence killing 2 birds with one stone. Porting my stand alone phpboard into my nuke sites broken php board. Well, shall we shoot me now, or shoot me later?

Here's the end result:

phpBB : Critical Error

Could not query config information

DEBUG MODE

SQL Error : 1146 Table 'swg-dean_p_nu1.nuke_bbconfig' doesn't exist

SELECT * FROM nuke_bbconfig

Line : 213
File : /home/swg-dean/.panel/web/portal/cms/modules/Forums/common.php

Calgon, take me away! Did I just make the fixable unfixable?

You just have to re import a fresh table. Make sure when you do that you have the subSilver theme reuploaded in its entirity. Then readd the sql for a fresh nuke_bbconfig.

CREATE TABLE nuke_bbconfig (
config_name varchar(255) NOT NULL default '',
config_value varchar(255) NOT NULL default '',
PRIMARY KEY (config_name)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_bbconfig`
#

INSERT INTO nuke_bbconfig VALUES ('config_id', '1');
INSERT INTO nuke_bbconfig VALUES ('board_disable', '0');
INSERT INTO nuke_bbconfig VALUES ('sitename', 'MySite.com');
INSERT INTO nuke_bbconfig VALUES ('site_desc', '');
INSERT INTO nuke_bbconfig VALUES ('cookie_name', 'phpbb2mysql');
INSERT INTO nuke_bbconfig VALUES ('cookie_path', '/');
INSERT INTO nuke_bbconfig VALUES ('cookie_domain', 'MySite.com');
INSERT INTO nuke_bbconfig VALUES ('cookie_secure', '0');
INSERT INTO nuke_bbconfig VALUES ('session_length', '3600');
INSERT INTO nuke_bbconfig VALUES ('allow_html', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_html_tags', 'b,i,u,pre');
INSERT INTO nuke_bbconfig VALUES ('allow_bbcode', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_smilies', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_sig', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_namechange', '0');
INSERT INTO nuke_bbconfig VALUES ('allow_theme_create', '0');
INSERT INTO nuke_bbconfig VALUES ('allow_avatar_local', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_avatar_remote', '0');
INSERT INTO nuke_bbconfig VALUES ('allow_avatar_upload', '0');
INSERT INTO nuke_bbconfig VALUES ('override_user_style', '1');
INSERT INTO nuke_bbconfig VALUES ('posts_per_page', '15');
INSERT INTO nuke_bbconfig VALUES ('topics_per_page', '50');
INSERT INTO nuke_bbconfig VALUES ('hot_threshold', '25');
INSERT INTO nuke_bbconfig VALUES ('max_poll_options', '10');
INSERT INTO nuke_bbconfig VALUES ('max_sig_chars', '255');
INSERT INTO nuke_bbconfig VALUES ('max_inbox_privmsgs', '100');
INSERT INTO nuke_bbconfig VALUES ('max_sentbox_privmsgs', '100');
INSERT INTO nuke_bbconfig VALUES ('max_savebox_privmsgs', '100');
INSERT INTO nuke_bbconfig VALUES ('board_email_sig', 'Thanks, [ Register or login to view links on this board. ] ');
INSERT INTO nuke_bbconfig VALUES ('board_email', 'Webmaster@MySite.com');
INSERT INTO nuke_bbconfig VALUES ('smtp_delivery', '0');
INSERT INTO nuke_bbconfig VALUES ('smtp_host', '');
INSERT INTO nuke_bbconfig VALUES ('require_activation', '0');
INSERT INTO nuke_bbconfig VALUES ('flood_interval', '15');
INSERT INTO nuke_bbconfig VALUES ('board_email_form', '0');
INSERT INTO nuke_bbconfig VALUES ('avatar_filesize', '6144');
INSERT INTO nuke_bbconfig VALUES ('avatar_max_width', '80');
INSERT INTO nuke_bbconfig VALUES ('avatar_max_height', '80');
INSERT INTO nuke_bbconfig VALUES ('avatar_path', 'modules/Forums/images/avatars');
INSERT INTO nuke_bbconfig VALUES ('avatar_gallery_path', 'modules/Forums/images/avatars');
INSERT INTO nuke_bbconfig VALUES ('smilies_path', 'modules/Forums/images/smiles');
INSERT INTO nuke_bbconfig VALUES ('default_style', '1');
INSERT INTO nuke_bbconfig VALUES ('default_dateformat', 'D M d, Y g:i a');
INSERT INTO nuke_bbconfig VALUES ('board_timezone', '10');
INSERT INTO nuke_bbconfig VALUES ('prune_enable', '0');
INSERT INTO nuke_bbconfig VALUES ('privmsg_disable', '0');
INSERT INTO nuke_bbconfig VALUES ('gzip_compress', '0');
INSERT INTO nuke_bbconfig VALUES ('coppa_fax', '');
INSERT INTO nuke_bbconfig VALUES ('coppa_mail', '');
INSERT INTO nuke_bbconfig VALUES ('board_startdate', '1013908210');
INSERT INTO nuke_bbconfig VALUES ('default_lang', 'english');
INSERT INTO nuke_bbconfig VALUES ('smtp_username', '');
INSERT INTO nuke_bbconfig VALUES ('smtp_password', '');
INSERT INTO nuke_bbconfig VALUES ('record_online_users', '2');
INSERT INTO nuke_bbconfig VALUES ('record_online_date', '1034668530');
INSERT INTO nuke_bbconfig VALUES ('server_name', 'MySite.com');
INSERT INTO nuke_bbconfig VALUES ('server_port', '80');
INSERT INTO nuke_bbconfig VALUES ('script_path', '/modules/Forums/');
INSERT INTO nuke_bbconfig VALUES ('version', '.0.8');
INSERT INTO nuke_bbconfig VALUES ('enable_confirm', '0');
INSERT INTO nuke_bbconfig VALUES ('sendmail_fix', '0');

Ok, before I try this I want to make sure I do it right the first time.

First, I didn't delete any of the subSilver files, just modified the theme_id in the two theme config files changing it back and forth between 1 and 2. I also renamed the folder to Topaz and changed it back to subSilver. So do I need to upload it? I don't have nuke-php on my computer, it's a web based one provided by my site host.

You said I need to import a fresh table. Is that what the sql code you supplied does, or do I need to import a fresh table and add the sql code to it?

Sorry if I'm being such a pest with all these questions, but this is my first experience with php (the easy click to install and spiffy admin interface on my hosts site is really misleading, making the whole php thing look like cake

)

But now that I'm seeing whats capable with it I wanna stick with it!

Reupload anything that you altered. Make sure that is a scratch fresh install. Then use the structure I paced above in the code box or one from a PHPNuke fresh install. There both the same. Import into your database and that should be it. Make sure you reupload whatever you altered.

Thanks sooooo much for your help Telli! I just uninstalled php-nuke and re-installed it (much easier then just doing the theme).

And I figured out what caused this whole mess to begin with. I couldn't figure out why my theme wasn't copying over to my forums, so I had copied the Topaz theme to the forums module dir and then selected the theme from the forum settings menu

Now, the REASON why my theme didn't copy over to the forums? I didn't have any forums! Yes that's right, the great intelligent me never created the categories or forums in the first place!

Yeesh, anyways thanks again for your help and thanks for not pointing out what a nit-wit I am (god only knows you HAD to be thinking that

)