We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 44432
    • 7 Posts
    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
      • 10208 ☆ A M B ☆
      • 1,780 Posts
        Frogabog- MODX Websites in Portland Oregon
        "Do yourself a favor and get a copy of "MODX - The Official Guide" by Bob Ray. Read it.
        Having server issues? These guys have MODX Hosting perfected - SkyToaster
        • 44432
        • 7 Posts
        Hi Frogabog,

        Thanks for the link. However, I am not facing this issue with just TinyMCE or some packages, but all packages in general.
        cURL, zlib and allow_url_fopen are all enabled on the server. Also, the value of open_basedir is set to null

        I am also using Facebook login via the 'Hybridauth' extra/snippet. Whenever I try to login using the Facebook login, the login does not work. The authentication on Facebook happens properly, however the INSERT query into the users and sessions table does not get executed. I get the same error: "Error HY000 executing statement: MySQL server has gone away" in the Modx logs.

        Everything works properly on the Staging Server, however, I am getting this error on the Live Server.

        There are only 2 noticeable differences between the Staging Server and Live Server:

        1. MySQL versions are different
        2. Live Server is running Modx on multiple servers (3 servers) for node balancing in master/slave configuration

        Any help would be much appreciated.

        Thanks
          • 22303 MODX Staff
          • 10,725 Posts
          Quote from: dfunk006 at Jul 12, 2013, 03:23 AM

          2. Live Server is running Modx on multiple servers (3 servers) for node balancing in master/slave configuration
          Can you provide more details on this "node balancing", "master/slave" environment?
            • 44432
            • 7 Posts
            Hi Jason,

            Thanks for responding to this thread.

            There is a master Web server where all changes in the Modx manager are made (content updates /chunks/ templates/ snippets/ packages/ etc). The other 2 web servers sync up with this server every 1 minute. Whenever a user enters the site domain name, one of the 3 servers responds with the request, depending on the load.

            There are 2 Database Servers which sync up in real-time.

            I hope this helps.