Can i see what are the errors ?
yes, sorry dennis wrong forum
MySQL 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 '/images/bg2.jpg'); background-attachment:fixed; line-height: 1.4em; f' at line 1
Query: UPDATE community_themes SET css='body { background: #efefef; color: #000; font-family: Verdana; font-size: 13px; text-align: left; /* IE 5 fix */ line-height: 1.4 } a:link { color: #026CB1; text-decoration: none; } a:visited { color: #026CB1; text-decoration: none; } a:hover, a:active { color: #000; text-decoration: underline; } #container { width: 60%; background: #F5F4EA; border: 1px solid #e4e4e4; color: #000000; margin: auto auto; padding: 20px; text-align: left; /* IE 5 fix */ } #content { /* FIX: Make internet explorer wrap correctly */ width: auto !important; } .menu ul { color: #000000; font-weight: bold; text-align: right; padding: 4px; } .menu ul a:link { color: #000000; text-decoration: none; } .menu ul a:visited { color: #000000; text-decoration: none; } .menu ul a:hover, .menu ul a:active { color: #4874a3; text-decoration: none; } #panel { background: #efefef; color: #000000; font-size: 11px; border: 1px solid #D4D4D4; padding: 8px; } table { color: #000000; font-family: Verdana; font-size: 13px; } .tborder { background: #81A2C4; width: 100%; margin: auto auto; border: 1px solid #0F5C8E; } .thead { background: #026CB1 url(images/thead_bg.gif) top left repeat-x; color: #ffffff; } .thead a:link { color: #ffffff; text-decoration: none; } .thead a:visited { color: #ffffff; text-decoration: none; } .thead a:hover, .thead a:active { color: #ffffff; text-decoration: underline; } .tcat { background: #ADCBE7; color: #000000; font-size: 12px; } .tcat a:link { color: #000000; } .tcat a:visited { color: #000000; } .tcat a:hover, .tcat a:active { color: #000000; } .trow1 { background: #f5f5f5; } .trow2 { background: #EFEFEF; } .trow_shaded { background: #eea8a1; } .trow_sep { background: #e5e5e5; color: #000; font-size: 12px; font-weight: bold; } .tfoot { background: #026CB1 url(images/thead_bg.gif) top left repeat-x; color: #ffffff; } .tfoot a:link { color: #ffffff; text-decoration: none; } .tfoot a:visited { color: #ffffff; text-decoration: none; } .tfoot a:hover, .tfoot a:active { color: #ffffff; text-decoration: underline; } .bottommenu { background: #efefef; color: #000000; border: 1px solid #4874a3; padding: 6px; } .navigation { color: #000000; font-size: 13px; font-weight: bold; } .navigation a:link { text-decoration: none; } .navigation a:visited { text-decoration: none; } .navigation a:hover, .navigation a:active { text-decoration: none; } .navigation .active { color: #000000; font-size: small; font-weight: bold; } .smalltext { font-size: 11px; } .largetext { font-size: 16px; font-weight: bold; } input.textbox { background: #ffffff; color: #000000; border: 1px solid #0f5c8e; padding: 1px; } textarea { background: #ffffff; color: #000000; border: 1px solid #0f5c8e; padding: 2px; font-family: Verdana; line-height: 1.4; font-size: 13px; } select { background: #ffffff; border: 1px solid #0f5c8e; } .editor { background: #f1f1f1; border: 1px solid #ccc; } .editor_control_bar { background: #fff; border: 1px solid #0f5c8e; } .toolbar_normal { background: #f0f0f0; border: 1px solid #f0f0f0; } .toolbar_hover { background: #c1d2ee; border: 1px solid #5296f7; } .toolbar_clicked { background: #e1F2fe; border: 1px solid #5296f7; } .autocomplete { background: #fff; border: 1px solid #000; color: black; } .autocomplete_selected { background: #adcee7; color: #000; } .popup_menu { background: #ccc; border: 1px solid #000; } .popup_menu .popup_item { background: #fff; color: #000; } .popup_menu .popup_item:hover { background: #C7DBEE; color: #000; } .trow_reputation_positive { background: #ccffcc; } .trow_reputation_negative { background: #ffcccc; } .reputation_positive { color: green; } .reputation_neutral { color: #444; } .reputation_negative { color: red; } /* Additional CSS (Master) */ img { border: none; } .clear { clear: both; } .hidden { display: none; float: none; width: 1%; } .float_left { float: left; } .float_right { float: right; } .menu ul { list-style: none; margin: 0; } .menu li { display: inline; padding-left: 5px; } .menu img { padding-right: 5px; vertical-align: top; } #panel .links { margin: 0; float: right; } .expcolimage { float: right; width: auto; vertical-align: middle; } img.attachment { border: 1px solid #E9E5D7; padding: 2px; } .pagenav { font-weight: bold; } .pagenavbit { padding-left: 3px; } .pagenavbit a { text-decoration: none; } .pagenavcurrent { font-weight: bold; padding-left: 3px; } hr { background-color: #000000; color: #000000; height: 1px; border: 0px; } #copyright { font: 11px Verdana, Arial, Sans-Serif; margin: 0; padding: 10px 0 0 0; } #debug { float: right; text-align: right; margin-top: 0; } .quote_header { background: #fff; border: 1px dashed #000; border-bottom: 0; color: #000; font-weight: bold; margin: 8px auto 0 auto; padding: 4px; } .quote_body { background: #fff; border: 1px dashed #000; border-top: 0; color: #000; padding: 4px; margin: 0 auto 8px auto; } .code_header { background: #fff; border: 1px dashed #000; border-bottom: 0; color: #000; font-weight: bold; margin: 8px auto 0 auto; padding: 4px; } .code_body { background: #fff; border: 1px dashed #000; border-top: 0; color: #000; padding: 4px; margin: 0 auto 8px auto; font-family: Monaco, Consolas, Courier, monospace; font-size: 12px; } .usercpnav { list-style: inside; padding: 0; margin: 0; } .usercpnav li { padding: 1px; font-size:11px } .usercpnav .pmfolders { /* PM folders on the UCP Nav menu */ } .subforumicon { border: 0; vertical-align: middle; } .separator { margin: 5px; padding: 0; height: 0px; font-size: 1px; list-style-type: none; } form { margin: 0; padding: 0; } .popup_menu .popup_item_container { margin: 1px; text-align: left; } .popup_menu .popup_item { display: block; padding: 3px; text-decoration: none; white-space: nowrap; } .popup_menu a.popup_item:hover { text-decoration: none; } .autocomplete { text-align: left; } /* Additional CSS (Custom) */ img { border: none; } .clear { clear: both; } .hidden { display: none; float: none; width: 1%; } .float_left { float: left; } .float_right { float: right; } .menu ul { list-style: none; margin: 0; } .menu li { display: inline; padding-left: 5px; } .menu img { padding-right: 5px; vertical-align: top; } #panel .links { margin: 0; float: right; } .expcolimage { float: right; width: auto; vertical-align: middle; } img.attachment { border: 1px solid #E9E5D7; padding: 2px; } .pagenav { font-weight: bold; } .pagenavbit { padding-left: 3px; } .pagenavbit a { text-decoration: none; } .pagenavcurrent { font-weight: bold; padding-left: 3px; } hr { background-color: #000000; color: #000000; height: 1px; border: 0px; } #copyright { font: 11px Verdana, Arial, Sans-Serif; margin: 0; padding: 10px 0 0 0; } #debug { float: right; text-align: right; margin-top: 0; } .quote_header { background: #fff; border: 1px dashed #000; border-bottom: 0; color: #000; font-weight: bold; margin: 8px auto 0 auto; padding: 4px; width: 550px; } .quote_body { background: #fff; border: 1px dashed #000; border-top: 0; color: #000; padding: 4px; margin: 0 auto 8px auto; width: 550px; } .code_header { background: #fff; border: 1px dashed #000; border-bottom: 0; color: #000; font-weight: bold; margin: 8px auto 0 auto; padding: 4px; width: 550px; } .code_body { background: #fff; border: 1px dashed #000; border-top: 0; color: #000; padding: 4px; margin: 0 auto 8px auto; font-family: Monaco, Consolas, Courier, monospace; font-size: 12px; width: 550px; } .usercpnav { list-style: inside; padding: 0; margin: 0; } .usercpnav li { padding: 1px; font-size:11px } .usercpnav .pmfolders { /* PM folders on the UCP Nav menu */ } .subforumicon { border: 0; vertical-align: middle; } .separator { margin: 5px; padding: 0; height: 0px; font-size: 1px; list-style-type: none; } form { margin: 0; padding: 0; } .popup_menu .popup_item_container { margin: 1px; text-align: left; } .popup_menu .popup_item { display: block; padding: 3px; text-decoration: none; white-space: nowrap; } .popup_menu a.popup_item:hover { text-decoration: none; } .autocomplete { text-align: left; } body { margin:0px 0; padding:0; color: #000; background: #303B41 url('/include/templates/default/images/bg2.jpg'); background-attachment:fixed; line-height: 1.4em; font-style:normal; font-variant:normal; font-weight:normal; font-size:74%; font-family:Arial, Sans-Serif } a img { border:none; } .content { background: transparent; color: #000; margin: 0 auto; padding: 0; width: 800px } .img { padding: 0 8px 8px 0; float: left; } .img2 { padding: 0 0 3px 3px; float: right; } /* HEADER --------------------------------------------------------------------------------------------------------------------------------------------------- */ #top { padding: 0; margin: 0; background: transparent ; height: 44px } #top .padding { float: right; color: #808080; padding: 20px 25px 0 0; font-size: 90%; } #top a { color: #E0F5FF; } #header { margin: 0; width: 800px; background: url('../pic/themepic/header.jpg') no-repeat center top; height: 149px; color: #FFF } #header .f_search { float: right; padding: 70px 50px 0 0; } #header .title { padding: 45px 0 0 50px; } #header h1 { font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 22px; font-weight: bold; margin: 0; padding: 0; } #header h2 { font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; background-image: url('../pic/themepic/none'); color: #075181; margin: 0; padding-left:2px; padding-right:0; padding-top:0; padding-bottom:0 } /* SUBHEADER ---------------------------------------------------------------------------------------------------------------------------------------------------*/ #subheader { background: transparent repeat-y center; width: 770px; height: 35px; color: #FFF; margin-left: 15px; } #subheader .padding { padding: 10px 15px 10px 15px; } #subheader h2 { color: #FEAB06; } #subheader a {color: #FECF5F; } /* NAVIGATION ---------------------------------------------------------------------------------------------------------------------------------------------------*/ .nav { text-align: left; color: #7D8085; padding: 20px 0 0 0px; width: 200px; } .nav li { margin: 5px 0 5px 0px; padding: 0px 0 0 0px; border-bottom: 1px dotted #ccc; list-style: none; } .nav li a { color: #546078; text-decoration: none; padding: 5px 0 0 0px; display: block; margin-bottom: 2px;} .nav li a:hover { color: #075181; text-decoration: none; background: #E5F6FF; display: block; margin-bottom: 2px;} /* MAIN ---------------------------------------------------------------------------------------------------------------------------------------------------*/ #main { background: transparent; width: 760px; margin: 0 20px 0 20px; color: #808080; } #main .right_side { float: right; padding:0px 0 0 10px; margin:0; background-color: #FFF; width: 210px; } #main .right_side .hitems { margin: 0; padding: 0; } #main .right_side .hitems ul { margin: 5px 0; padding : 0; color: #a90000; list-style-image: url('../pic/themepic/arrow.gif'); } #main .right_side .hitems li { margin: 0 0 2px 20px; padding: 0 0 0 0px; color: #555; } #main .left_side { float: left; background: #FFF; padding:15px 15px 0 20px; margin:0; } #main h3 { font: 100% Arial, Sans-Serif; margin: 0 0 10px 0px; padding: 0; color: #5f5f5f; background: inherit; border-bottom: 1px solid #036CB4; } #main .box { background: transparent; padding: 5px; border: 1px solid #ccc;} #main .right_side ul { margin: 5px 0 5px 0; padding : 0; list-style : none; border-bottom: 0px solid #eee; list-style-type: square; color: #a90000; } #main .right_side li { margin: 0 0 2px 15px; padding: 0 0 0 0px; color: #555; } #main .right_side .padding { margin: 0 0 20px 15px; padding: 0 0 0 0px; color: #555; } /* FOOTER ---------------------------------------------------------------------------------------------------------------------------------------------------*/ #footer { clear:both; height: 43px; color:#ccc; background: transparent ; font-size:90%; padding: 0; text-align:center } #footer .padding { padding: 10px 0px 0px 0px; } #footer .right { float:right; clear:right; text-align:right; } #footer a { color: #E0F5FF; } /* Top Menu */ #menu { background: #000 url('../pic/themepic/menu.jpg') no-repeat center bottom; width: 760px; height: 35px; margin: 0; padding: 0 } #menu ul { margin:0; list-style:none; padding: 5px 0 0 20px; } #menu a, #nav strong, #nav span { float:left; display:block; color:#fff; padding: 5px; text-decoration:none; } #menu a { float:none; } #menu li { float:left; color: #FFF; background: #000; margin:0; padding:0 0 0 0px; } #menu a:hover { text-decoration:underline;} #menu .padding { padding: 5px 0 0 10px; font-weight: bold; } /* ---------------------------------------------------------------------------------------------------------------------------------------------------*/ input.search { width: 150px; border: 1px solid #075181; color: #666; } input.submit { background: none; color: #075181; border: 0px none;; font-style:normal; font-variant:normal; font-weight:bold; font-size:1.1em; font-family:Arial, Verdana, Helvetica, sans-serif } input.search:hover { background: #FFFFF4; } ul { margin-left: 0; padding-left: 5px; list-style : square; } li { margin: 0 0 2px 15px; padding: 0 0 0 0px; color: #555; } /*Image Resizer v0.1 by xam */ table.ncode_imageresizer_warning { background: #FFFFE1; color: #000000; border: 1px solid #CCC; cursor: pointer; } table.ncode_imageresizer_warning td { font-size: 12px; color: red; vertical-align: middle; text-decoration: bold; } table.ncode_imageresizer_warning td.td1 { padding: 5px; } table.ncode_imageresizer_warning td.td1 { padding: 2px; } /*Image Resizer v0.1 by xam */ .exs{ position: relative; z-index: 0; } .exs:hover{ background-color: transparent; z-index: 50; } .exs span{ position: absolute; background-color: #E8E9F9; padding: 8px; width: 300px; left: -1000px; border: 1px dashed gray; visibility: hidden; color: black; text-decoration: none; } ' WHERE tid='34'
not sure if i added wrong dont think i did plus it could be server error although every other plugin ive had of you works
ALright this is somehow a special case for you.
Im upgrading the online version to overcome this case in the future.
However if you want to solve it now..
open the plugin file
find
$db->query("UPDATE ".TABLE_PREFIX."themes SET css='".$add_css['css'].$new."' WHERE tid='".$add_css['tid']."'");
$db->query("UPDATE ".TABLE_PREFIX."themes SET extracss='".$add_css['extracss'].$new."' WHERE tid='".$add_css['tid']."'");
replace with
$db->query("UPDATE ".TABLE_PREFIX."themes SET css='".$db->escape_string($add_css['css'].$new)."' WHERE tid='".$add_css['tid']."'");
$db->query("UPDATE ".TABLE_PREFIX."themes SET extracss='".$db->escape_string($add_css['extracss'].$new)."' WHERE tid='".$add_css['tid']."'");
find
$db->query("UPDATE ".TABLE_PREFIX."themes SET extracss='$extra' WHERE tid='".$remove_css['tid']."'");
$db->query("UPDATE ".TABLE_PREFIX."themes SET css='$css' WHERE tid='".$remove_css['tid']."'");
replace with
$db->query("UPDATE ".TABLE_PREFIX."themes SET extracss='".$db->escape_string($extra)."' WHERE tid='".$remove_css['tid']."'");
$db->query("UPDATE ".TABLE_PREFIX."themes SET css='".$db->escape_string($css)."' WHERE tid='".$remove_css['tid']."'");
