Codezwiz >> Forums >> General PHP Nuke Help >> Error in Styles Admin

Alright here goes.. I'm trying to edit my current style, using style manager (phpbb).

Once I edit the colors this is the error I get:

Could not update themes table!

DEBUG MODE

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

UPDATE phpbb_themes SET style_name = 'subBlack', template_name = 'subBlack', head_stylesheet = 'subBlack.css', body_background = '', body_bgcolor = 'E5E5E5', body_text = '000000', body_link = '006699', body_vlink = '5493B4', body_alink = '', body_hlink = 'DD6900', tr_color1 = 'EFEFEF', tr_color2 = 'DEE3E7', tr_color3 = 'D1D7DC', tr_class1 = '', tr_class2 = '', tr_class3 = '', th_color1 = '98AAB1', th_color2 = '006699', th_color3 = 'FFFFFF', th_class1 = 'cellpic1.gif', th_class2 = 'cellpic3.gif', th_class3 = 'cellpic2.jpg', td_color1 = 'FAFAFA', td_color2 = 'FFFFFF', td_color3 = '', td_class1 = 'row1', td_class2 = 'row2', td_class3 = '', fontface1 = 'Verdana, Arial, Helvetica, sans-serif', fontface2 = 'Trebuchet MS', fontface3 = 'Courier, ''Courier New'', sans-serif', fontsize1 = 10, fontsize2 = 11, fontsize3 = 12, fontcolor1 = '444444', fontcolor2 = '006600', fontcolor3 = 'FFFFFF', span_class1 = '', span_class2 = '', span_class3 = '', fontcolor4 = '', fontcolor5 = '', fontcolor98 = '', fontcolor99 = '' WHERE themes_id = 5

Line : 320
File : /data/members/free/tripod/uk/k/r/a/krackit/htdocs/admin/admin_styles.php

Lines 318-324

if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, "Could not update themes table!", "", __LINE__, __FILE__, $sql);
}

//
// Check if there's a names table entry for this style

Anyone know what to do?

Just wanted to update: I didn't get this error until added the User Level Mod. I've redone everything 3 times. Still the same error.

You have a an extra column added. Did you install any type of a styles hack?