Forum

Thread tagged as: Problem, Configuration, Hosting

Issues migrating from development to live

Hi, I have moved a site from development to a live hosted server. I backed up the database before moving it over.

I installed Perch on the new server and copied over the pages and templates etc. I restored the database.

I can log into Perch backoffice and see all the pages and regions etc. When I select a region there are no items available for editing, Just ones for adding new from the blocks.

See screenshot; Screenshot


    Perch Runway: 2.8.31
    Production mode: Production (100)
    Installed apps: content (2.8.31), assets (2.8.31), categories (2.8.31), perch_blog (5.0), perch_gallery (2.8.6)
    DB driver: PDO
    DB tables: Search_Engine (89), label_selector (8), perch2_backup_plans (0), perch2_backup_resources (0), perch2_backup_runs (0), perch2_blog_authors (2), perch2_blog_comments (0), perch2_blog_index (212), perch2_blog_posts (3), perch2_blog_posts_to_tags (8), perch2_blog_sections (1), perch2_blog_tags (7), perch2_blogs (1), perch2_categories (0), perch2_category_counts (0), perch2_category_sets (1), perch2_collection_index (0), perch2_collection_items (0), perch2_collection_revisions (1), perch2_collections (0), perch2_content_index (7457), perch2_content_items (2710), perch2_content_regions (520), perch2_gallery_albums (2), perch2_gallery_image_versions (318), perch2_gallery_images (53), perch2_navigation (1), perch2_navigation_pages (6), perch2_page_routes (0), perch2_page_templates (32), perch2_pages (193), perch2_resource_log (7962), perch2_resource_tags (273), perch2_resources (1084), perch2_resources_to_tags (602), perch2_settings (15), perch2_user_passwords (0), perch2_user_privileges (37), perch2_user_role_privileges (16), perch2_user_roles (2), perch2_users (2), print_selector_help_text (29), print_selector_questions (527), product_selector (23), signage_selector (22)
    Users: 2
    App runtimes:

    <?php
        $apps_list = array(
            'content', 
            'categories',
            'perch_blog',
            'perch_gallery',
        );

    Scheduled tasks for perch_blog: delete_spam_comments (1440 mins)
    Editor plug-ins: markitup
    H1: 7cd4ae85cc481c758f229e42f9bba10d
    L1: bd0fb93709430489ba96d1c02f79f9a8
    F1: 2edba60ed1f613d6dd804feb202456a2
    headerColour: rgb(54,54,54)
    content_singlePageEdit: 1
    helpURL:
    siteURL: /
    hideBranding: 0
    content_collapseList: 1
    lang: en-gb
    update_2.8.31: done
    headerScheme: dark
    update_runway_2.8.31: done
    latest_version: 2.8.15
    on_sale_version: 2.8.31
    perch_blog_update: 5.0.1
    perch_blog_post_url: /blog/post.php?s={postSlug}
    perch_gallery_update: 2.8.5
    PERCH_DEVELOPMENT: 10
    PERCH_STAGING: 50
    PERCH_PRODUCTION: 100
    PERCH_SITEPATH: /mnt/vol2/home/a/s/ashfie1/public_html
    PERCH_SCHEDULE_SECRET: 7Uko1ozxCDj6mGRD
    PERCH_DB_USERNAME: ashfie1_1
    PERCH_DB_SERVER: db1
    PERCH_DB_DATABASE: ashfie1_1
    PERCH_DB_PREFIX: perch2_
    PERCH_EMAIL_FROM: sales@ashfieldprinting.co.uk
    PERCH_EMAIL_FROM_NAME: Gemma Cramer
    PERCH_LOGINPATH: /perch
    PERCH_PATH: /mnt/vol2/home/a/s/ashfie1/public_html/perch
    PERCH_CORE: /mnt/vol2/home/a/s/ashfie1/public_html/perch/core
    PERCH_RESFILEPATH: /mnt/vol2/home/a/s/ashfie1/public_html/perch/resources
    PERCH_RESPATH: /perch/resources
    PERCH_HTML5: 1
    PERCH_TZ: Europe/London
    PERCH_RUNWAY: 1
    PERCH_ERROR_MODE: DIE
    PERCH_DATE_LONG: %d %B %Y
    PERCH_DATE_SHORT: %d %b %Y
    PERCH_TIME_SHORT: %H:%M
    PERCH_TIME_LONG: %H:%M:%S
    PERCH_RUNWAY_ROUTED:
    PERCH_STRONG_PASSWORDS:
    PERCH_DEBUG:
    PERCH_PREVIEW_ARG: preview
    PERCH_TEMPLATE_PATH: /mnt/vol2/home/a/s/ashfie1/public_html/perch/templates
    PERCH_DEFAULT_DOC: index.php
    PERCH_DEFAULT_EXT: .php
    PERCH_PRODUCTION_MODE: 100
    PERCH_RWD:
    PERCH_HTML_ENTITIES:
    PERCH_SSL:
    PERCH_STRIPSLASHES:
    PERCH_PROGRESSIVE_FLUSH: 1
    PERCH_PARANOID:
    PERCH_FORCE_SECURE_COOKIES:
    PERCH_PASSWORD_MIN_LENGTH: 6
    PERCH_MAX_FAILED_LOGINS: 10
    PERCH_AUTH_LOCKOUT_DURATION: 1 HOUR
    PERCH_VERIFY_UPLOADS:
    PERCH_AUTH_PLUGIN:
    PERCH_DB_CHARSET: utf8
    PERCH_DB_PORT:
    PERCH_DB_SOCKET:
    PERCH_SESSION_TIMEOUT_MINS: 20

Hosting settings

    PHP: 5.4.34
    Zend: 2.4.0
    OS: Linux
    SAPI: cgi-fcgi
    Safe mode: not detected
    MySQL client: mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $
    MySQL server: 5.1.73
    Free disk space: 107.69 GB
    Extensions: Core, date, ereg, libxml, openssl, pcre, zlib, filter, hash, pcntl, readline, Reflection, SPL, session, standard, cgi-fcgi, apc, bcmath, bz2, calendar, ctype, curl, dba, dom, enchant, mbstring, fileinfo, ftp, gd, gearman, geoip, gettext, gmp, iconv, igbinary, imagick, imap, interbase, intl, json, ldap, exif, mcrypt, memcache, mssql, mysqlnd, mysql, mysqli, odbc, PDO, pdo_dblib, PDO_Firebird, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, recode, redis, shmop, SimpleXML, snmp, soap, sockets, sqlite3, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, xml, wddx, xmlreader, xmlrpc, xmlwriter, xsl, memcached, zip, mhash, ionCube Loader, Zend Guard Loader, xdebug
    GD: Yes
    ImageMagick: Yes
    PHP max upload size: 50M
    PHP max form post size: 50M
    PHP memory limit: 128M
    Total max uploadable file size: 50M
    Resource folder writeable: Yes
    Session timeout: 24 minutes
    Native JSON: Yes
    Filter functions: Yes
    Transliteration functions: Yes
    DOCUMENT_ROOT: /mnt/vol2/home/a/s/ashfie1/public_html
    GATEWAY_INTERFACE: CGI/1.1
    HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    HTTP_ACCEPT_ENCODING: gzip, deflate
    HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.5
    HTTP_CONNECTION: keep-alive
    HTTP_COOKIE: _ga=GA1.3.1186873010.1473080306; __tawkuuid=e::ashfieldprinting.co.uk::H4Kr07m1xliitSN/LfM+yO5mjV0ELVOSeHC1TUzHKUQzlzfxE1m/SrgdvNgICB8k::2; Tawk_57b6e9291105e45f7b2cd7bd=vs2.tawk.to:443::0; cmsa=1; PHPSESSID=261scd9so4dpi2mjd2jhb2cbu5; _gat=1; sc_is_visitor_unique=rx10859812.1474315895.63A15367A6404F9EDF9947CBDBF4C1F0.10.10.8.8.8.7.6.4.4; TawkConnectionTime=0
    HTTP_HOST: www.ashfieldprinting.co.uk
    HTTP_REFERER: https://www.ashfieldprinting.co.uk/perch/core/settings/diagnostics/
    HTTP_UPGRADE_INSECURE_REQUESTS: 1
    HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:48.0) Gecko/20100101 Firefox/48.0
    PATH: /bin:/usr/bin
    PHPRC: /etc
    QUERY_STRING: extended
    REDIRECT_STATUS: 200
    REMOTE_ADDR: 82.19.104.76
    REMOTE_PORT: 52311
    REQUEST_METHOD: GET
    REQUEST_URI: /perch/core/settings/diagnostics/?extended
    SCRIPT_FILENAME: /mnt/vol2/home/a/s/ashfie1/public_html/perch/core/settings/diagnostics/index.php
    SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
    SCRIPT_URI: https://www.ashfieldprinting.co.uk/perch/core/settings/diagnostics/
    SCRIPT_URL: /perch/core/settings/diagnostics/
    SERVER_ADDR: 195.26.90.14
    SERVER_ADMIN: root@localhost
    SERVER_NAME: www.ashfieldprinting.co.uk
    SERVER_PORT: 80
    SERVER_PROTOCOL: HTTP/1.1
    SERVER_SOFTWARE: Apache/2.2.15 (CentOS)
    UNIQUE_ID: V@BGmcMaWj4AACBkrvQAAAAa
    PHP_SELF: /perch/core/settings/diagnostics/index.php
    REQUEST_TIME_FLOAT: 1474315929.9035
    REQUEST_TIME: 1474315929
    argc: 1
Dennis Pickworth

Dennis Pickworth 0 points

  • 5 years ago
Rachel Andrew

Rachel Andrew 394 points
Perch Support

5 years ago

Were you developing in a subfolder originally?
Dennis Pickworth

Dennis Pickworth 0 points

5 years ago

Yes I suppose it was as in the subdomain/ashfields folder is that the issue? What is the best way to fix?
Drew McLellan

Drew McLellan 2638 points
Perch Support

5 years ago

Can you turn on debug and let me know what it outputs at the bottom of that edit page?
Dennis Pickworth

Dennis Pickworth 0 points

5 years ago

Hi Drew, The debug;

Debug Message
[1] SELECT u.*, r.* FROM perch2_users u, perch2_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='1c03504582f15a96efaf56b73b282bc9' LIMIT 1
UPDATE perch2_users SET userHash='ff5d50bab97fa73e5e6b0e8e895a46c8' WHERE userID='1'
[37] SELECT p.privKey FROM perch2_user_privileges p
[15] SELECT * FROM (SELECT DISTINCT settingID, settingValue, userID FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID, settingValue, userID
[nil] SELECT collectionID, collectionKey, collectionEditRoles FROM perch2_collections WHERE collectionInAppMenu=1 ORDER BY collectionOrder ASC
[1] SELECT * FROM perch2_content_regions WHERE regionID=30 LIMIT 1
[1] SELECT * FROM perch2_pages WHERE pageID='1' LIMIT 1
[1] SELECT * FROM perch2_content_items WHERE regionID=30 AND itemRev=222 ORDER BY itemOrder ASC
[1] SELECT * FROM perch2_content_items WHERE regionID=30 AND itemRev=222 ORDER BY itemOrder ASC
Using template: /templates/content/homepage_block.html
Using sub-template: /templates/content/blocks/HomePageSliderImages.html
Using sub-template: /templates/content/blocks/AboutUs-HOME.html
Using sub-template: /templates/content/image.html
Using sub-template: /templates/content/blocks/PercentBar.html
Using sub-template: /templates/content/image-class-mt1.html
Using sub-template: /templates/content/image.html
Form not posted or did not validate
Queries: 10
Memory: 5.7698

Hope this helps.
Drew McLellan

Drew McLellan 2638 points
Perch Support

5 years ago

Are you sure you migrated the database successfully without errors?
Dennis Pickworth

Dennis Pickworth 0 points

5 years ago

Hi Drew,

I have Re Migrated database, but this time dropped the tables first and this seems to have fixed the issue.

I think the issue may have been I had developed against a slightly older version of Perch.

Thanks for the help.