PHPBB2 HELP!

[Napster]

Ok so i am trying to install a certain theme or template for my new phpbb site and stuff.. So i downloaded a Pre-modded version of PHPBB2 with many mods installed already, but trying to get this mod to work is such a hassle..

I get this error when trying to install in the admin panel...

General Error
Could not insert theme data!

DEBUG MODE

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

INSERT INTO phpbb_themes (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, adminfontcolor, supermodfontcolor, modfontcolor) VALUES ('InvisionBlue', 'InvisionBlue', 'InvisionBlue.css', '', 'FFFFFF', '000000', '006699', '5493B4', '', 'DD6900', 'E4EAF2', 'DFE6EF', 'DFE6EF', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, ''Courier New'', sans-serif', '10', '11', '12', '444444', '006600', 'FFA34F', '', '', '', '0', '0', 'FFA34F', '737353', '006600')

Line : 121
File : /home/icewaref/public_html/forum/admin/admin_styles.php


Powered by phpBB 2.0.11 © 2001 phpBB Group

help please?

[vee_ess]

The entries for adminfontcolor, supermodfontcolor, and modfontcolor don't need to be there, admin and mod font colors are covered in fontcolor2 and fontcolor3.

Try this:

INSERT INTO phpbb_themes (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 ('InvisionBlue', 'InvisionBlue', 'InvisionBlue.css', '', 'FFFFFF', '000000', '006699', '5493B4', '', 'DD6900', 'E4EAF2', 'DFE6EF', 'DFE6EF', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, ''Courier New'', sans-serif', '10', '11', '12', '444444', '006600', 'FFA34F', '', '', '', '0', '0')

[Napster]

Well the whole thing is one big pre-modded forum. And when I copy it to my public_html and try to open it in IE, it says Access Denied. so I dunno if I need to run an SQL query or what... I do understand that the code you showed me might work, but i dont think a couple font colors are preventing me from installing this pre-modded forum.

[Napster]

Here is what the file looks like, This isnt Vbulletin so you don't pay for it.. and YES it is freeware.. So in case anyone says, "HEY U CANT DO THAT" the answer is "yes i can."

[Napster]

Come on now... Someone in this whole forum must know what im talking about.... PHPBB isnt that complex of a language now is it?? There should be some techs here who can answer my question... Im pleading with you..

[Jason425]

tech doesn't = programming nerd.. just wanted to clear that one up.. :P

[vee_ess]

Go to this file: /home/icewaref/public_html/forum/admin/admin_styles.php
in Notepad or something, find the line that looks like

INSERT INTO phpbb_themes (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, adminfontcolor, supermodfontcolor, modfontcolor) VALUES ('InvisionBlue', 'InvisionBlue', 'InvisionBlue.css', '', 'FFFFFF', '000000', '006699', '5493B4', '', 'DD6900', 'E4EAF2', 'DFE6EF', 'DFE6EF', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, ''Courier New'', sans-serif', '10', '11', '12', '444444', '006600', 'FFA34F', '', '', '', '0', '0', 'FFA34F', '737353', '006600')

and change it to

INSERT INTO phpbb_themes (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 ('InvisionBlue', 'InvisionBlue', 'InvisionBlue.css', '', 'FFFFFF', '000000', '006699', '5493B4', '', 'DD6900', 'E4EAF2', 'DFE6EF', 'DFE6EF', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, ''Courier New'', sans-serif', '10', '11', '12', '444444', '006600', 'FFA34F', '', '', '', '0', '0')

PHPBB isn't a language, it's a bulletin board written in the PHP language (stands for hypertext preprocessor, it's a server-side scripting language), and yes it has moderate complexity to it.