Forum

Thread tagged as: Problem

Items not deleting

HI Guys,

I'm having an issue with the CMS that nothing seems to be deleting, I'm having this issue with regions, multiple regions (Inside the main region) and with assets.

Here is the debug output:

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='2ed4ba03609294a2537739646419db93' LIMIT 1
UPDATE perch2_users SET userHash='81dae43907301a12d777e447b364cf75' WHERE userID=1
SELECT p.privKey FROM perch2_user_privileges p
SELECT * FROM (SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID
SELECT * FROM perch2_content_regions WHERE regionID=4 LIMIT 1
SELECT * FROM perch2_pages WHERE pageID='2' LIMIT 1
SELECT * FROM perch2_content_items WHERE regionID=4 AND itemRev=45 ORDER BY itemOrder ASC

When I click delete, then yes on the pop up the page reloads but the item i've tried to delete is still there.

Any ideas how to fix this?
Chris Bell

Chris Bell 0 points

  • 6 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

6 years ago

Where's that debug from?

If you right click the Delete button and open the link in a new tap (to sidestep the JavaScript) does the delete page work?

Can you confirm you're running Perch 2.7.10?
Chris Bell

Chris Bell 0 points

6 years ago

Thats the output I get from the region page, I've just updated to 2.7 and tried the open in new tab thing,

If I do that it takes me to this URL: /perch/core/apps/content/delete/item/?id=9&itm=55

And this is the debug code from that page:

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='a98de6ed8f406cc56d378ec4246fcccd' LIMIT 1
UPDATE perch2_users SET userHash='59e90ea6f38154e287f3628e49b8cfb2' WHERE userID=1
SELECT p.privKey FROM perch2_user_privileges p
SELECT * FROM (SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID
SELECT * FROM perch2_content_regions WHERE regionID=9 LIMIT 1
SELECT * FROM perch2_pages WHERE pageID='3' LIMIT 1

When I click confirm on the delete confirmation message I get taken back to the region but still nothing has been deleted
Drew McLellan

Drew McLellan 2638 points
Perch Support

6 years ago

Can you show me your diagnostics report?
Chris Bell

Chris Bell 0 points

6 years ago

Here you go.... will ensure I add this in the start for future posts.

Diagnostics report
PERCH INFORMATION

Perch: 2.7.10
Production mode: Production (100)
Installed apps: content (2.7.10), assets (2.7.10), categories (2.7.10), perch_twitter (3.5.1)
DB driver: PDO
DB tables: perch2_categories, perch2_category_counts, perch2_category_sets, perch2_content_index, perch2_content_items, perch2_content_regions, perch2_navigation, perch2_navigation_pages, perch2_page_templates, perch2_pages, perch2_resource_log, perch2_resource_tags, perch2_resources, perch2_resources_to_tags, perch2_scheduled_tasks, perch2_settings, perch2_twitter_scheduled_tweets, perch2_twitter_settings, perch2_twitter_tweets, perch2_user_privileges, perch2_user_role_privileges, perch2_user_roles, perch2_users
Users: 2
App runtimes:
<?php
    $apps_list = array(
        'content',
        'categories',
        'perch_twitter',
    );
Scheduled tasks for perch_twitter: post_tweets (1 mins), update_tweets (15 mins)
Editor plug-ins: markitup
H1: e46fa3135b2365dfafe346c654f09f2b
L1: 460ea5c46d7bbb9670984a006669fbba
headerColour: #ffffff
content_singlePageEdit: 1
helpURL:
siteURL: /
hideBranding: 0
content_collapseList: 1
lang: en-gb
update_2.7.7: done
latest_version: 2.5.3
on_sale_version: 2.7.8
perch_twitter_update: 3.5
headerScheme: light
dashboard: 0
hide_pwd_reset: 0
content_hideNonEditableRegions: 0
content_frontend_edit: 0
logoPath: /perch/resources/corporate-logo.png
update_2.7.10: done
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_DB_USERNAME: avp
PERCH_DB_SERVER: localhost
PERCH_DB_DATABASE: avp_sandbox
PERCH_DB_PREFIX: perch2_
PERCH_TZ: UTC
PERCH_EMAIL_FROM: chris@de22.co.uk
PERCH_EMAIL_FROM_NAME: Chris Bell
PERCH_LOGINPATH: /perch
PERCH_PATH: /var/www/vhosts/de22.co.uk/avp_sandbox/perch
PERCH_CORE: /var/www/vhosts/de22.co.uk/avp_sandbox/perch/core
PERCH_RESFILEPATH: /var/www/vhosts/de22.co.uk/avp_sandbox/perch/resources
PERCH_RESPATH: /perch/resources
PERCH_HTML5: 1
PERCH_SCHEDULE_SECRET: iaowytbg9p47WEsgsdh9ACNW
PERCH_DEBUG: 1
PERCH_RUNWAY:
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_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /var/www/vhosts/de22.co.uk/avp_sandbox/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_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:
PERCH_APPS_EDITOR_PLUGIN: markitup
PERCH_APPS_EDITOR_MARKUP_LANGUAGE: textile
HOSTING SETTINGS

PHP: 5.3.2-1ubuntu4.28
Zend: 2.3.0
OS: Linux
SAPI: apache2handler
Safe mode: not detected
MySQL client: 5.1.73
MySQL server: 5.1.73-0ubuntu0.10.04.1
Extensions: Core, date, ereg, libxml, openssl, pcre, zlib, bcmath, bz2, calendar, ctype, dba, dom, hash, fileinfo, filter, ftp, gettext, session, iconv, json, mbstring, SPL, standard, posix, Reflection, Phar, shmop, SimpleXML, soap, sockets, exif, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, zip, apache2handler, curl, gd, imap, mcrypt, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, SQLite, sqlite3, xsl, mhash, ionCube Loader
GD: Yes
ImageMagick: No
PHP max upload size: 10M
PHP max form post size: 8M
PHP memory limit: 128M
Total max uploadable file size: 8M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: No
PP_CUSTOM_PHP_INI: /var/www/vhosts/avp.de22.co.uk/etc/php.ini
HTTP_HOST: avp.de22.co.uk
HTTP_CONNECTION: keep-alive
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/40.0.2214.94 Safari/537.36
HTTP_REFERER: https://avp.de22.co.uk/perch/core/settings/diagnostics/
HTTP_ACCEPT_ENCODING: gzip, deflate, sdch
HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.8
HTTP_COOKIE: PHPSESSID=fhdeir1irkmfbgifsqeclfg1c6; __utmt=1; __utma=209794048.1787575212.1412847226.1422523683.1423038021.22; __utmb=209794048.1.10.1423038021; __utmc=209794048; __utmz=209794048.1417774289.4.3.utmcsr=localhost:8888|utmccn=(referral)|utmcmd=referral|utmcct=/; _ga=GA1.4.1787575212.1412847226; _gat=1; cmsa=1
PATH: /usr/local/bin:/usr/bin:/bin
SERVER_SIGNATURE: <address>Apache Server at avp.de22.co.uk Port 80</address>
SERVER_SOFTWARE: Apache
SERVER_NAME: avp.de22.co.uk
SERVER_ADDR: 109.104.79.141
SERVER_PORT: 80
REMOTE_ADDR: 62.69.52.218
DOCUMENT_ROOT: /var/www/vhosts/de22.co.uk/avp_sandbox
SERVER_ADMIN: hello@de22.co.uk
SCRIPT_FILENAME: /var/www/vhosts/de22.co.uk/avp_sandbox/perch/core/settings/diagnostics/index.php
REMOTE_PORT: 60061
GATEWAY_INTERFACE: CGI/1.1
SERVER_PROTOCOL: HTTP/1.1
REQUEST_METHOD: GET
QUERY_STRING: extended
REQUEST_URI: /perch/core/settings/diagnostics/?extended
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
PHP_SELF: /perch/core/settings/diagnostics/index.php
REQUEST_TIME: 1423038469
Chris Bell

Chris Bell 0 points

6 years ago

I've just tried this on localhost and it works fine so it must be something wrong with the server set up, Maybe the fact the PHP version is out of date?
Drew McLellan

Drew McLellan 2638 points
Perch Support

6 years ago

The PHP version shouldn't be an issue, although it is very old.

Do you get any errors in your PHP error log?
Chris Bell

Chris Bell 0 points

6 years ago

No nothing in there
Drew McLellan

Drew McLellan 2638 points
Perch Support

6 years ago

Ok, well let me know when you have something we can work with.
Chris Bell

Chris Bell 0 points

6 years ago

OK, i'm transitioning to new servers over the next month so hopefully that will fix it.