AmOn Posted March 5, 2013 Share Posted March 5, 2013 I try to upload a new skin.. it's loading when import it and then appear a message There appears to be an error with the database. Link to comment Share on other sites More sharing options...
0 Lock Down Posted March 5, 2013 Share Posted March 5, 2013 (edited) It is because the mysql variable max_allowed_packet is set too low.Find the my.cnf file in the etc folder on your server and change the value to 32M or add this line after the [mysld] or [mysqldump] in that file. max_allowed_packet = 32M Edited March 5, 2013 by Lock Down 1 Link to comment Share on other sites More sharing options...
0 Evarni Posted March 5, 2013 Share Posted March 5, 2013 In your ACP try this. Go to Look and Feel > Template Tools First rebuild HTML, CSS and Replacements for everything. Afterward, recache all skins. I had the database error when I installed a skin a few months back. This actually solved the issue. 1 Link to comment Share on other sites More sharing options...
0 AmOn Posted March 5, 2013 Author Share Posted March 5, 2013 In your ACP try this. Go to Look and Feel > Template Tools First rebuild HTML, CSS and Replacements for everything. Afterward, recache all skins. I had the database error when I installed a skin a few months back. This actually solved the issue.Still the same Link to comment Share on other sites More sharing options...
0 AmOn Posted March 5, 2013 Author Share Posted March 5, 2013 (edited) i think problem is on php.ini values Edited March 5, 2013 by AmOn Link to comment Share on other sites More sharing options...
0 AmOn Posted March 5, 2013 Author Share Posted March 5, 2013 Error: 1153 - Got a packet bigger than 'max_allowed_packet' bytes mySQL query error: INSERT INTO cache_store (`cs_key`,`cs_value`) VALUES('_importSkinContent_','<?xml version="1.0" encoding="utf-8"?>n<xmlarchive generator="IPS_KERNEL" created="1332895432" ipbLongVersion="33011" ipbHumanVersion="3.3.0">n <fileset>n <file>n <filename>core.xml</filename> File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications/core/modules_admin/templates/importexport.php | [db_main_mysql].insert | 296 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications/core/modules_admin/templates/importexport.php | [admin_core_templates_importexport]._importSet | 123 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [admin_core_templates_importexport].doExecute | 306 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' Link to comment Share on other sites More sharing options...
0 Evarni Posted March 5, 2013 Share Posted March 5, 2013 What skin are you trying to upload? Did you get the skin from here? 1 Link to comment Share on other sites More sharing options...
0 AmOn Posted March 5, 2013 Author Share Posted March 5, 2013 What skin are you trying to upload? Did you get the skin from here?No, from somewhere else.. it was working like a charm before Link to comment Share on other sites More sharing options...
0 AmOn Posted March 5, 2013 Author Share Posted March 5, 2013 (edited) No it is because the mysql varuable max_allowed_packet is set too low. Find the my.cnf file in the etc folder on your server and change the value to 32M or add this line after the [mysld] in that file. max_allowed_packet = 32M ohhhh heavy artilery responded Edited March 5, 2013 by AmOn Link to comment Share on other sites More sharing options...
0 AmOn Posted March 5, 2013 Author Share Posted March 5, 2013 It is because the mysql variable max_allowed_packet is set too low.Find the my.cnf file in the etc folder on your server and change the value to 32M or add this line after the [mysld] or [mysqldump] in that file. max_allowed_packet = 32M This guy Lock Down every answer he post is the right! Never ever he answered second because he never made a mistake... Thank you all people the issue solved! Link to comment Share on other sites More sharing options...
Question
AmOn
I try to upload a new skin.. it's loading when import it and then appear a message
Link to comment
Share on other sites
9 answers to this question
Recommended Posts