Posts by FishtankMike

    Unsure about the files uploaded but i've screenshot a few of the heavy table in the database (attached) if that helps. I can say that the reseources filder when its zipped up is over 10GB in size so there is a lot of physical files.

    The site is filling up the server /tmp folder with .MAD files which then kills the server - screenshot attached

    I'm told that they are created when INSERT and/or UPDATE queries are called to the database but sure that shouldn't happen with perch by just people visiting the site??


    So I have Perch runway site and as soon as the site has any kind of traffic ( like just 20 people ) the site completely dies.

    The server spec is ample:

    12 Core

    12GB Ram

    500GB HDD

    The server tech people are telling me that the code and/or database of Perch is filling up the /var/tmp folder on the server to capacity and crashing it.

    I really need some help!! ;(


    I have quite an old site running perch Runway. Its running extremely slow... nearly a minute to load!

    The server tech reports are telling me that the database is the issue.

    I have attached a screen shot of the DB in phpMyAdmin. I know there are a lot of rows in the blog index table?

    Also attached is a MySQL log which highlights a lot of the same state of "Creating sort index". Is the following thread linked to this...…ction-loading-speed-issue

    The server technicians have told me to optimise the database but I have no idea how or where to begin?!

    Here is the perch diagnostics

    • Perch Runway: 3.0.8, PHP: 7.0.33, MySQL: mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $, with PDO
    • Server OS: Linux, cgi-fcgi
    • Installed apps: content (3.0.8), assets (3.0.8), categories (3.0.8), perch_blog (5.5.1), perch_forms (1.9.1), perch_gallery (2.8.9)
    • App runtimes: <?php $apps_list = array( 'perch_blog', 'ftc_fixtures', 'ftc_sport_radar', 'perch_gallery', 'perch_forms' );
    • PERCH_LOGINPATH: /admin
    • PERCH_PATH: /home/***/public_html/admin
    • PERCH_CORE: /home/***/public_html/admin/core
    • PERCH_RESFILEPATH: /home/****/public_html/admin/resources
    • Image manipulation: GD
    • PHP limits: Max upload 512M, Max POST 512M, Memory: 512M, Total max file upload: 512M
    • F1: 0c66c2e1f82f9e0b7617b2cb8270f2c7
    • Resource folder writeable: Yes

    Any help or hints would be amazing.


    Here is my perch diagnostics:

    My client has reported to me that he is trying to create a blog post but when he saves/publishes it - the content doesn't save. In some cases only there is some content saved but 90% of it just goes missing.

    All the content is saved fine when in draft mode but as soon as its published the content goes missing??!

    I have checked the error logs and found this...

    1. PHP Warning: array_merge(): Argument #1 is not an array in /var/www/html/example/public_html/admin/addons/apps/perch_blog/PerchBlog_Post.class.php on line 99, referer:

    Can anyone help?