Hello,
When I click the "Download" button to download a package from the Package Manager, I get a dialog box saying "Downloading..." but nothing happens. The Modx error log gives the following error: "Could not download and create transport package with signature - Error HY000 executing statement: MySQL server has gone away" in Modx logs.
However, when I check the core/packages directory with FTP afterwards, the transport zip is there.
Everything else on the CMS works fine but for some reason, the INSERT queries are not executing.
Error Log:
[2013-07-11 15:56:19] (ERROR @ /connectors/workspace/packages-rest.php) Error HY000 executing statement:
INSERT INTO `vh1_transport_packages` (`signature`, `created`, `state`, `workspace`, `provider`, `disabled`, `source`, `package_name`, `metadata`, `version_major`, `version_minor`, `version_patch`, `release`, `release_index`) VALUES ('fblogin-1.0-rc4', '2013-07-11 03:56:10', 1, 1, 1, 0, 'fblogin-1.0-rc4.transport.zip', 'fbLogin', 'a:31:{i:0;a:4:{s:4:\"name\";s:2:\"id\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:24:\"4f41f8d6f245541dd1000115\";s:8:\"children\";a:0:{}}i:1;a:4:{s:4:\"name\";s:7:\"package\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:24:\"4f41f8d6f245541dd1000115\";s:8:\"children\";a:0:{}}i:2;a:4:{s:4:\"name\";s:12:\"display_name\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:15:\"fblogin-1.0-rc4\";s:8:\"children\";a:0:{}}i:3;a:4:{s:4:\"name\";s:7:\"version\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:5:\"1.0.0\";s:8:\"children\";a:0:{}}i:4;a:4:{s:4:\"name\";s:13:\"version_major\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:1:\"1\";s:8:\"children\";a:0:{}}i:5;a:4:{s:4:\"name\";s:13:\"version_minor\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:1:\"0\";s:8:\"children\";a:0:{}}i:6;a:4:{s:4:\"name\";s:13:\"version_patch\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:1:\"0\";s:8:\"children\";a:0:{}}i:7;a:4:{s:4:\"name\";s:7:\"release\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:3:\"rc4\";s:8:\"children\";a:0:{}}i:8;a:4:{s:4:\"name\";s:8:\"vrelease\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:2:\"rc\";s:8:\"children\";a:0:{}}i:9;a:4:{s:4:\"name\";s:14:\"vrelease_index\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:2:\"rc\";s:8:\"children\";a:0:{}}i:10;a:4:{s:4:\"name\";s:6:\"author\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:15:\"freelancewebdev\";s:8:\"children\";a:0:{}}i:11;a:4:{s:4:\"name\";s:11:\"description\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:737:\"<p>fbLogin is a MODX extra which extends Shaun McCormick\"s <a href=\"http://modx.com/extras/package/login\">Login extra</a> to enable users to register and login to a site using their Facebook account via the Facebook API using Version 3.0 of their PHP SDK.</p><p></p><p>It is more intended as a tool for developers to accelerate their Facebook integrations rather than a designer tool.</p><p><b>VERY IMPORTANT</b></p><p>THIS EXTRA REQUIRES FRIENDLY URL\'S TO BE ENABLED.</p><p>THIS EXTRA MAKES USE OF THE FACEBOOK PHP SDK (VERSION 3) WHICH IS BUNDLED WITH THE EXTRA FOR YOUR CONVENIENCE.</p><p></p><p></p><p></p><p>ALSO IF YOU INSTALLED VERSION RC! OR RC2, I RECOMMEND YOU UNINSTALL IT COMPLETELY BEFORE INSTALLING THIS VERSION.</p><p></p>\";s:8:\"children\";a:0:{}}i:12;a:4:{s:4:\"name\";s:12:\"instructions\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:383:\"<p></p><p></p><p><a href=\"http://www.hyper-typer.com/news/facebook-login-modx\" title=\"Information on the fbLogin extra including readme file\" target=\"_blank\">See the readme for fbLogin and other supplementary information</a></p><p><a href=\"http://github.com/freelancewebdev/fblogin\" title=\"The fbLogin MODX extra code on Github\" target=\"_blank\">On Github</a></p><p></p><p></p><p></p>\";s:8:\"children\";a:0:{}}i:13;a:4:{s:4:\"name\";s:9:\"changelog\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:257:\"<p>fbLogin 1.0 rc 2</p><p>Complete re-write for ease of installation and configuration</p><p></p><p>fbLogin 1.0 rc3Updates to build script to correct bugs with vehicle packing</p><p>fbLogin 1.0 rc4 Update to address issue with resolver introduced in rc3</p>\";s:8:\"children\";a:0:{}}i:14;a:4:{s:4:\"name\";s:9:\"createdon\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:23:\"2012-02-25 21:46:55 UTC\";s:8:\"children\";a:0:{}}i:15;a:4:{s:4:\"name\";s:10:\"created_by\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:15:\"freelancewebdev\";s:8:\"children\";a:0:{}}i:16;a:3:{s:4:\"name\";s:8:\"editedon\";s:10:\"attributes\";a:0:{}s:8:\"children\";a:0:{}}i:17;a:4:{s:4:\"name\";s:10:\"releasedon\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:23:\"2012-02-28 05:26:41 UTC\";s:8:\"children\";a:0:{}}i:18;a:4:{s:4:\"name\";s:9:\"downloads\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:4:\"1230\";s:8:\"children\";a:0:{}}i:19;a:4:{s:4:\"name\";s:8:\"approved\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:4:\"true\";s:8:\"children\";a:0:{}}i:20;a:4:{s:4:\"name\";s:7:\"audited\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:5:\"false\";s:8:\"children\";a:0:{}}i:21;a:4:{s:4:\"name\";s:8:\"featured\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:5:\"false\";s:8:\"children\";a:0:{}}i:22;a:4:{s:4:\"name\";s:10:\"deprecated\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:5:\"false\";s:8:\"children\";a:0:{}}i:23;a:4:{s:4:\"name\";s:7:\"license\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:5:\"GPLv2\";s:8:\"children\";a:0:{}}i:24;a:3:{s:4:\"name\";s:7:\"smf_url\";s:10:\"attributes\";a:0:{}s:8:\"children\";a:0:{}}i:25;a:4:{s:4:\"name\";s:4:\"name\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:7:\"fbLogin\";s:8:\"children\";a:0:{}}i:26;a:4:{s:4:\"name\";s:10:\"repository\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:24:\"4d4c3fa6b2b0830da9000001\";s:8:\"children\";a:0:{}}i:27;a:4:{s:4:\"name\";s:8:\"supports\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:3:\"2.2\";s:8:\"children\";a:0:{}}i:28;a:4:{s:4:\"name\";s:10:\"screenshot\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:72:\"http://modx.s3.amazonaws.com/extras/4f41f8d6f245541dd1000115/fbLogin.png\";s:8:\"children\";a:0:{}}i:29;a:3:{s:4:\"name\";s:4:\"file\";s:10:\"attributes\";a:0:{}s:8:\"children\";a:7:{i:0;a:4:{s:4:\"name\";s:2:\"id\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:24:\"51083a28f24554374a0000a5\";s:8:\"children\";a:0:{}}i:1;a:4:{s:4:\"name\";s:7:\"version\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:24:\"4f4956cff2455467fc0000ef\";s:8:\"children\";a:0:{}}i:2;a:4:{s:4:\"name\";s:8:\"filename\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:29:\"fblogin-1.0-rc4.transport.zip\";s:8:\"children\";a:0:{}}i:3;a:4:{s:4:\"name\";s:9:\"downloads\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:3:\"243\";s:8:\"children\";a:0:{}}i:4;a:4:{s:4:\"name\";s:6:\"lastip\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:14:\"124.153.64.254\";s:8:\"children\";a:0:{}}i:5;a:4:{s:4:\"name\";s:9:\"transport\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:4:\"true\";s:8:\"children\";a:0:{}}i:6;a:4:{s:4:\"name\";s:8:\"location\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:60:\"http://modx.com/extras/download/?id=51083a28f24554374a0000a5\";s:8:\"children\";a:0:{}}}}i:30;a:4:{s:4:\"name\";s:17:\"package-signature\";s:10:\"attributes\";a:0:{}s:4:\"text\";s:15:\"fblogin-1.0-rc4\";s:8:\"children\";a:0:{}}}', 1, 0, 0, 'rc', 4)
Array
(
[0] => HY000
[1] => 2006
[2] => MySQL server has gone away
)
[2013-07-11 15:56:19] (ERROR @ /connectors/workspace/packages-rest.php) Could not download and create transport package with signature: fblogin-1.0-rc4
[2013-07-11 15:56:19] (ERROR @ /connectors/workspace/packages-rest.php) Error HY000 executing statement:
Array
(
[0] => HY000
[1] => 2006
[2] => MySQL server has gone away
)
[2013-07-11 15:56:19] (ERROR @ /connectors/workspace/packages-rest.php) Error HY000 executing statement:
INSERT INTO `vh1_session` (`id`, `access`, `data`) VALUES ('9hg1upt45u4phkj18bfcdh6nq4', 1373538379, 'modx.user.contextTokens|a:1:{s:3:\"mgr\";i:1;}HybridAuth|a:30:{s:9:\"assetsUrl\";s:30:\"/assets/components/hybridauth/\";s:6:\"cssUrl\";s:34:\"/assets/components/hybridauth/css/\";s:5:\"jsUrl\";s:33:\"/assets/components/hybridauth/js/\";s:9:\"imagesUrl\";s:37:\"/assets/components/hybridauth/images/\";s:7:\"siteUrl\";s:18:\"http://www.vh1.in/\";s:12:\"connectorUrl\";s:43:\"/assets/components/hybridauth/connector.php\";s:8:\"corePath\";s:37:\"/home/vh1/core/components/hybridauth/\";s:9:\"modelPath\";s:43:\"/home/vh1/core/components/hybridauth/model/\";s:10:\"chunksPath\";s:53:\"/home/vh1/core/components/hybridauth/elements/chunks/\";s:13:\"templatesPath\";s:56:\"/home/vh1/core/components/hybridauth/elements/templates/\";s:11:\"chunkSuffix\";s:10:\".chunk.tpl\";s:12:\"snippetsPath\";s:55:\"/home/vh1/core/components/hybridauth/elements/snippets/\";s:14:\"processorsPath\";s:48:\"/home/vh1/core/components/hybridauth/processors/\";s:10:\"rememberme\";b:1;s:8:\"loginTpl\";s:20:\"tpl.HybridAuth.login\";s:9:\"logoutTpl\";s:21:\"tpl.HybridAuth.logout\";s:10:\"profileTpl\";s:22:\"tpl.HybridAuth.profile\";s:8:\"saltName\";s:0:\"\";s:8:\"saltPass\";s:0:\"\";s:6:\"groups\";s:0:\"\";s:12:\"loginContext\";s:0:\"\";s:11:\"addContexts\";s:0:\"\";s:13:\"updateProfile\";b:1;s:13:\"profileFields\";s:127:\"username:25,email:50,fullname:50,phone:12,mobilephone:12,dob:10,gender,address,country,city,state,zip,fax,photo,comment,website\";s:14:\"requiredFields\";s:23:\"username,email,fullname\";s:15:\"loginResourceId\";i:0;s:16:\"logoutResourceId\";i:0;s:9:\"providers\";s:6:\"Google\";s:6:\"action\";s:7:\"loadTpl\";s:2:\"HA\";a:4:{s:8:\"base_url\";s:57:\"http://www.vh1.in/assets/components/hybridauth/action.php\";s:10:\"debug_mode\";i:0;s:10:\"debug_file\";s:35:\"/home/vh1/core/cache/logs/error.log\";s:9:\"providers\";a:1:{s:6:\"Google\";a:2:{s:7:\"enabled\";b:1;s:4:\"keys\";a:2:{s:2:\"id\";s:39:\"837417200925.apps.googleusercontent.com\";s:6:\"secret\";s:24:\"ZxbqkPlBhGVleO5ilPjMTbn5\";}}}}}HA::CONFIG|a:2:{s:14:\"php_session_id\";s:34:\"s:26:\"4vov8og9gbqbgkrt3vo1cqfcd7\";\";s:7:\"version\";s:16:\"s:9:\"2.1.1-dev\";\";}modx.user.0.resourceGroups|a:1:{s:3:\"web\";a:0:{}}modx.user.0.attributes|a:1:{s:3:\"web\";a:4:{s:16:\"modAccessContext\";a:1:{s:3:\"web\";a:1:{i:0;a:3:{s:9:\"principal\";i:0;s:9:\"authority\";s:1:\"0\";s:6:\"policy\";a:1:{s:4:\"load\";b:1;}}}}s:22:\"modAccessResourceGroup\";a:0:{}s:17:\"modAccessCategory\";a:0:{}s:28:\"sources.modAccessMediaSource\";a:0:{}}}modx.mgr.user.token|s:52:\"modx51b5d08c8ee725.30769838_151de7be19ce6a4.74368549\";modx.mgr.session.cookie.lifetime|i:0;')
Array
(
[0] => HY000
[1] => 2006
[2] => MySQL server has gone away
)
I have found another thread on the forum regarding this issue, however it hasn't been resolved:
https://forums.modx.com/?action=thread&thread=13806
I have migrated the code from Staging Server to Live Server. Everything is working properly on the Staging Server.
My Environment details for Live Server:
PHP: 5.4.16
MySQL Database: 5.5.25a-27
MySQL Client: 5.1.69
Linux: CentOS
Modx Version: 2.2.6-pl
My Environment details for Staging Server:
PHP: 5.4.16
MySQL Database: 5.5.31
MySQL Client: 5.5.31
Linux: CentOS
Modx Version: 2.2.6-pl
Any help would be much appreciated.
Thanks