Forum
Timeout When Trying to Delete Item
Hello,
I've been experiencing the same issue as this post: (https://forum.grabaperch.com/forum/05-18-2017-delete-page-popup-doesnt-disappear-after-pressing-delete), across a few projects that I've recently been upgrading from Perch to Runway. I'm running Windows 10 and latest version of Chrome.
I've disabled JavaScript in my browser and still get the same error when trying to delete an empty item.
Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\......\core\lib\PerchDB_MySQL.class.php on line 131
I had downloaded a copy of my website files and database in order to perform an upgrade to Runway in my local development environment, and have been able to successfully upgrade to Runway and upgrade to Runway 3. I have a template that has a slideshow, each item is a slide. On the live website, still running Perch 2.8.34, I was able to successfully delete an empty item that was in this region. But in my development environment, I continue to get the error listed above.
What could be requiring more than 30 seconds to delete an empty item?
I wouldn't think there is an issue with the template, as it has not been edited at all since I downloaded a copy of the site, and the item was quickly deleted from my live site still running on the old perch version. Possibly a problem with my environment, but no idea where to start, as all I did was copy over all files of my live site and export/import my database.
I'm also getting this error message at the top of my page when I access the region in the control panel:
Notice: Undefined index: _id in C:\xampp\htdocs\......\core\apps\content\modes\region.itemlist.post.php on line 163
Here is my diagnostics report:
Perch Runway: 3.0.8
Production mode: Production (100)
Installed apps: content (3.0.8), assets (3.0.8), categories (3.0.8), perch_blog (5.5.1), perch_gallery (2.8.9), perch_mailchimp (2.0.2)
DB driver: PDO
DB tables: perch2_backup_plans (0), perch2_backup_resources (0), perch2_backup_runs (0), perch2_blog_authors (3), perch2_blog_categories (0), perch2_blog_comments (0), perch2_blog_index (1569), perch2_blog_posts (12), perch2_blog_posts_to_categories (0), perch2_blog_posts_to_tags (0), perch2_blog_sections (1), perch2_blog_tags (0), perch2_blogs (1), perch2_categories (21), perch2_category_counts (7), perch2_category_sets (3), perch2_collection_index (0), perch2_collection_items (0), perch2_collection_revisions (0), perch2_collections (0), perch2_content_index (50997), perch2_content_items (8541), perch2_content_locks (1), perch2_content_regions (230), perch2_forms (0), perch2_forms_responses (0), perch2_gallery_albums (26), perch2_gallery_image_versions (4506), perch2_gallery_images (753), perch2_menu_items (11), perch2_navigation (0), perch2_navigation_pages (0), perch2_page_routes (8), perch2_page_templates (24), perch2_pages (88), perch2_resource_log (3360), perch2_resource_tags (0), perch2_resources (1747), perch2_resources_to_tags (0), perch2_settings (95), perch2_user_passwords (10), perch2_user_privileges (48), perch2_user_role_privileges (201), perch2_user_roles (53), perch2_users (54)
Users: 54
App runtimes:
<?php
$apps_list = array(
'perch_blog',
'perch_gallery'
);
Scheduled tasks for perch_blog: delete_spam_comments (1440 mins)
Scheduled tasks for perch_mailchimp: update_list_stats (60 mins)
Editor plug-ins: ckeditor, redactor
H1: beada55e4624dfbc6fb1cc55c4d9c9f4
L1: 97285c80a986029f2702041ffccb7491
F1: 0c66c2e1f82f9e0b7617b2cb8270f2c7
headerColour: #1f275d
content_singlePageEdit: 1
helpURL: /HernandezCMS-QuickReference-112016.pdf
siteURL: /
hideBranding: 1
content_collapseList: 0
lang: en-gb
update_2.6.3: done
on_sale_version: 3.0.8
headerScheme: dark
content_hideNonEditableRegions: 1
perch_blog_post_url: /news/{postSlug}
perch_blog_slug_format: %Y-%m-%d-{postTitle}
perch_blog_akismet_key:
perch_blog_max_spam_days: 0
perch_comments_akismet_key:
perch_events_detail_url: /events/event.php?event={eventSlug}
perch_gallery_bucket_mode: dynamic
perch_gallery_bucket: default
perch_mailchimp_campaign_url: /newsletter/campaign.php?s={campaignSlug}
dashboard: 0
hide_pwd_reset: 1
content_frontend_edit: 1
perch_blog_comment_notify: 0
perch_gallery_basicUpload: 0
logoPath: /cms/resources/image001.png
update_2.6.5: done
perch_blog_update: 5.0.1
update_2.6.6: done
perch_gallery_update: 2.8.5
perch_mailchimp_api_key: 967ac64871aaf85f2e36f794f4826f28-us9
perch_mailchimp_list_id: 87787d7299
perch_mailchimp_secret: 387d770d8025c455bdbd5a83d6453127
perch_mailchimp_update: 2.0
update_2.7: done
update_2.7.1: done
update_2.7.10: done
latest_version:
update_2.8.13: done
jw_activity_log_prune_time: 365
update_2.8.29: done
perch_blog_site_name: Hernandez Middle School
update_2.8.31: done
update_2.8.32: done
update_2.8.34: done
update_runway_2.8.34: done
update_runway_3.0.8: done
content_skip_region_list: 1
keyboardShortcuts: 0
siteOffline: 0
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_SITEPATH: \ichernandez\cms\setup\runway\modes
PERCH_SCHEDULE_SECRET:
PERCH_DB_USERNAME: devadmin
PERCH_DB_SERVER: localhost
PERCH_DB_DATABASE: rug_ichernan
PERCH_DB_PREFIX: perch2_
PERCH_EMAIL_FROM:
PERCH_EMAIL_FROM_NAME:
PERCH_LOGINPATH: /cms
PERCH_PATH: C:\xampp\htdocs\runway_upgrade\07062017\ichernandez\cms
PERCH_CORE: C:\xampp\htdocs\runway_upgrade\07062017\ichernandez\cms\core
PERCH_RESFILEPATH: C:\xampp\htdocs\runway_upgrade\07062017\ichernandez\cms\resources
PERCH_RESPATH: /cms/resources
PERCH_HTML5: 1
PERCH_TZ: America/Chicago
PERCH_DEFAULT_EXT: .php
PERCH_CLEAN_RESOURCES: 1
PERCH_YOUTUBE_API_KEY: AIzaSyDjRW810A8kP0fmDJ1B60M2B8ELFY3oCIo
PERCH_PARANOID: 1
PERCH_MAX_FAILED_LOGINS: 10
PERCH_AUTH_LOCKOUT_DURATION: 15 MINUTES
PERCH_STRONG_PASSWORDS: 1
PERCH_PASSWORD_MIN_LENGTH: 8
PERCH_VERIFY_UPLOADS: 1
PERCH_SECURITY_HEADERS: 1
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_ASSET_VERSION: 5163d57ff611b3cf853b
PERCH_DEBUG:
PERCH_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: C:\xampp\htdocs\runway_upgrade\07062017\ichernandez\cms\templates
PERCH_TEMPLATE_FILTERS:
PERCH_DEFAULT_DOC: index.php
PERCH_PRODUCTION_MODE: 100
PERCH_XHTML_MARKUP:
PERCH_RWD: 1
PERCH_HTML_ENTITIES:
PERCH_SSL:
PERCH_STRIPSLASHES:
PERCH_PROGRESSIVE_FLUSH: 1
PERCH_FORCE_SECURE_COOKIES: 1
PERCH_DEFAULT_BUCKET: default
PERCH_TRANSLATION_ASSIST:
PERCH_PRIV_ASSIST:
PERCH_CUSTOM_EDITOR_CONFIGS:
PERCH_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:
PERCH_SESSION_TIMEOUT_MINS: 20
PERCH_APPS_EDITOR_PLUGIN: markitup
PERCH_APPS_EDITOR_MARKUP_LANGUAGE: markdown
Hosting settings
PHP: 5.6.24
Zend: 2.6.0
OS: WINNT
SAPI: apache2handler
Safe mode: not detected
MySQL client: mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
MySQL server: 5.5.5-10.1.16-MariaDB
Free disk space: 349.01 GB
Extensions: Core, bcmath, calendar, ctype, date, ereg, filter, ftp, hash, iconv, json, mcrypt, SPL, odbc, pcre, Reflection, session, standard, mysqlnd, tokenizer, zip, zlib, libxml, dom, PDO, bz2, SimpleXML, wddx, xml, xmlreader, xmlwriter, apache2handler, openssl, curl, fileinfo, gd, gettext, mbstring, exif, mysql, mysqli, pdo_mysql, pdo_sqlite, Phar, mhash
GD: Yes
ImageMagick: No
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: No
MIBDIRS: C:/xampp/php/extras/mibs
MYSQL_HOME: \xampp\mysql\bin
OPENSSL_CONF: C:/xampp/apache/bin/openssl.cnf
PHP_PEAR_SYSCONF_DIR: \xampp\php
PHPRC: \xampp\php
TMP: \xampp\tmp
HTTP_HOST: rugihms.dev
HTTP_CONNECTION: keep-alive
HTTP_PRAGMA: no-cache
HTTP_CACHE_CONTROL: no-cache
HTTP_UPGRADE_INSECURE_REQUESTS: 1
HTTP_USER_AGENT: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
HTTP_REFERER: https://rugihms.dev/cms/core/settings/diagnostics/
HTTP_ACCEPT_ENCODING: gzip, deflate
HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.8
HTTP_COOKIE: _ga=GA1.2.1999387093.1499449202; _gid=GA1.2.2085011047.1499449202; PHPSESSID=oec7n0jkrccelco963a8m1asj4
PATH: C:\Program Files (x86)\Common Files\Intel\Shared Libraries\redist\intel64\compiler;C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\nodejs\;C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program Files (x86)\Windows Live\Shared;C:\Users\Rodriguez\AppData\Roaming\npm;%USERPROFILE%\AppData\Local\Microsoft\WindowsApps;
SystemRoot: C:\WINDOWS
COMSPEC: C:\WINDOWS\system32\cmd.exe
PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
WINDIR: C:\WINDOWS
SERVER_SIGNATURE: <address>Apache/2.4.23 (Win32) OpenSSL/1.0.2h PHP/5.6.24 Server at rugihms.dev Port 80</address>
SERVER_SOFTWARE: Apache/2.4.23 (Win32) OpenSSL/1.0.2h PHP/5.6.24
SERVER_NAME: rugihms.dev
SERVER_ADDR: 127.0.0.1
SERVER_PORT: 80
REMOTE_ADDR: 127.0.0.1
DOCUMENT_ROOT: C:/xampp/htdocs/runway_upgrade/07062017/ichernandez
REQUEST_SCHEME: http
CONTEXT_DOCUMENT_ROOT: C:/xampp/htdocs/runway_upgrade/07062017/ichernandez
SERVER_ADMIN: postmaster@localhost
SCRIPT_FILENAME: C:/xampp/htdocs/runway_upgrade/07062017/ichernandez/cms/core/settings/diagnostics/index.php
REMOTE_PORT: 56862
GATEWAY_INTERFACE: CGI/1.1
SERVER_PROTOCOL: HTTP/1.1
REQUEST_METHOD: GET
QUERY_STRING: extended
REQUEST_URI: /cms/core/settings/diagnostics/?extended
SCRIPT_NAME: /cms/core/settings/diagnostics/index.php
PHP_SELF: /cms/core/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1499543430.034
REQUEST_TIME: 1499543430
Is this for all regions, or just one region?
I thought it was just my slideshow region, but it looks like I see the same issue in all regions now.
If I attempt to modify any content, when I go to save my changes, I'm ending up with this error and the item I attempt to edit is being automatically saved as a Draft.
I'm also noticing that for Categories, I can add a new Set, but notice that the id assigned to one or multiple new sets is always 0. Same is true if I attempt to add any new categories to an existing set, the category id becomes 0.
Overall, I can no longer modify any existing content copied over from my live site, including categories.
Have you checked your error log?
I tried deleting an item from two separate regions on two separate pages and this is what I have in my error log:
I attempted increasing the
max_execution_timein my php.ini file, and while I am not getting the timeout error message now, ALL items in my region were removed and 1 empty item is left.I'm assuming the
undefined index: _iderror is coming up because all the empty items, or any item I attempt to delete, or new items or category sets/categories I attempt to add, all somehow end up with an id = 0.Have you checked your database tables for corruption?
Drew,
That's exactly what I started thinking last night as the issues kept mounting up. I decided to start over, so dropped all tables, and imported the database I exported from the live site again.
As of now I'm back to where I was prior to these issues and everything is working fine now while running latest version of Runway 3. While it is a relief that I was working on a copy of the site on local environment as opposed to experiencing this with the live site, it does still concern me because I don't know what the cause was.
I still do occasionally experience the same issue from the post I first mentioned (https://forum.grabaperch.com/forum/05-18-2017-delete-page-popup-doesnt-disappear-after-pressing-delete) in other projects running Perch 3 or Runway 3, and it did seem to be the first issue I started to experience before everything else started to fail, but I can't say for sure that it was the cause of my database tables corruption.
For now, all is working fine so far. Appreciate all your help.
What sort of hosting is it on? Is there any chance of the server being overloaded?
The website is on shared hosting from bluehost.com. Currently setup on their best shared hosting plan available, Business Pro. Next step up would be their Cloud hosting or VPS hosting services, but I don't think I'm at that point yet. Maybe once I've added on a few more clients, I'll be able to justify the cost for a VPS plan.
The odd thing was that when I initially went to export the live site's database a few days ago, the SQL file was about 128MB. I republished the live website last night before I downloaded the database again, and that SQL file dropped to 11.4MB.
I have another site currently running Perch 3.0.8 and it does occasionally get stuck on the delete page popup, but if I close the window or refresh the page in my browser after clicking on delete, the item is in fact deleted...but the popup window still lingers after pressing "delete" so its a bit confusing because I'm sitting there wondering if its stuck or processing in the background.
It's not something I'm seeing widely reported, but I'll certainly keep an eye on it.
Ok thanks Drew.