Cannot create child style

[Dad.]

Hello,

I get the following error when I try to create a child style:

An exception occurred: Mysqli prepare error: MySQL server has gone away in C:\wamp\www\software\xenforo\1.1\library\Zend\Db\Statement\Mysqli.php on line 77
 
Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 825
Zend_Db_Adapter_Abstract->fetchOne() in XenForo/Error.php at line 50
XenForo_Error::unexpectedException() in XenForo/Application.php at line 295
XenForo_Application::handleException()

I have 13 styles installed. I'm on localhost.

Thanks,
Mike

 

[Paul B]

Having that many styles will cause timeouts and other issues during the cache rebuilding.

Try increasing some of the time and memory values.

BTW, you posted about this before (the too many styles that is)

http://xenforo.com/community/thread...packet-bytes-error-message.25254/#post-306391

 

[Dad.]

But isn't this a different error? Apparently not, but it looked different . I increased max_allowed_packet to 10M and it worked perfectly. Would you recommend changing anything else?

 

[Dad.]

Fatal error: Maximum execution time of 60 seconds exceeded in C:\wamp\www\software\xenforo\1.1\library\Zend\Db\Statement\Mysqli.php on line 104

Cannot get by this one. Another issue with having skins? I only have around ten. Do I need to remove all skins when Im done working with them? The days of having dozens of skins is over?

 

[Paul B]

Try increasing the time limit as explained in this post: http://xenforo.com/community/threads/frequently-asked-questions.5183/#post-282417

 

[Dad.]

Fatal error: Maximum execution time of 60 seconds exceeded in C:\wamp\www\software\xenforo\1.1\library\XenForo\Template\Compiler\Tag\If.php on line 104

After setting max_execution_time = 180

 

[Jake Bunce]

Fatal error: Maximum execution time of 60 seconds exceeded in C:\wamp\www\software\xenforo\1.1\library\XenForo\Template\Compiler\Tag\If.php on line 104

After setting max_execution_time = 180

Some hosts don't allow you to override the PHP configuration. Visit admin.php?tools/phpinfo to confirm that the new value is showing for that setting.

 

[Dad.]

Thanks Jake, and I'm on localhost so it does show the value changed.

 

[Jake Bunce]

Then this error shouldn't be:

Maximum execution time of 60 seconds exceeded

Maybe it's an old error in the log? From before the change.

 

[Dad.]

Well I restarted all services, still getting:

Fatal error: Maximum execution time of 60 seconds exceeded in C:\wamp\www\software\xenforo\1.1\library\Zend\Db\Adapter\Abstract.php on line 473

But that line is showing as changed in php.ini and phpinfo(). Sorry this might be an easy fix, not really too involved on some of these things.

 

[Jake Bunce]

Well, the change isn't taking effect for some reason.

I say you should delete some styles.

 

[Dad.]

Lol! Well if I must. I do hope that one day I wont have to as it would make development that much easier, but if thats the best complaint I have Ill take it any day!

 

[agison]

This error come from Mysql, not php.
Change these values in my.cnf to:

wait_timeout = 600
connect_timeout = 120

Hope it help.

 

[Dad.]

This error come from Mysql, not php.
Change these values in my.cnf to:

wait_timeout = 600
connect_timeout = 120

Hope it help.

Thanks, but where do I find this file? Google wasn't much of a help with this. Im running wamp.

 

[bambua]

On linux it's usually in /etc/my.c

Thanks, but where do I find this file? Google wasn't much of a help with this. Im running wamp.

nf I think I missed in your post what type of environment you are developing in?

 

[agison]

It's /etc/my.cnf (linux, mac)

Windows are different, should check this: http://www.tikalk.com/net/blog/where-my-mycnf-file
C:\WINNT\my.ini C:\WINNT\my.cnf C:\my.ini C:\my.cnf
C:\Program Files\MySQL\MySQL Server 5.0\my.ini
C:\Program Files\MySQL\MySQL Server 5.0\my.cnf

 

[Dad.]

Im running wampserver. I did a search inside the folder for said file with no luck. I do have a my.ini file, but in that file I do not have the options that you've presented.

 

[agison]

You should add them then restart mysql.
wait_timeout = 600
connect_timeout = 120

 

[MagnusB]

Im running wampserver. I did a search inside the folder for said file with no luck. I do have a my.ini file, but in that file I do not have the options that you've presented.

Just a quick google found that it is called my.ini on Windows, and is located in xammp/mysql/bin/my.ini for wamp