Forum

Thread tagged as: Problem

Unable to log in

Perch isn't allowing me to log in today for some reason. When you click 'Log in' the page just seems to refresh, you get no notification. Other users have same issue. I have tried with false details and the error message doesn't appear either, so something is definitely up.

I can connect to the db with sequel pro fine. Have restarted the mySQL VM and that hasn't helped (site is on azure). Debug on the login page shows nothing out of the ordinary.

What should I be checking/doing to narrow this down?
Stephen Turvey

Stephen Turvey 0 points

  • 3 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

3 years ago

Does the URL change when you submit the login form?

Have you tried with debug turned on?
Stephen Turvey

Stephen Turvey 0 points

3 years ago

No the URL doesn't change. You can see here: https://www.tefluk.com/admin/

Debug doesn't change either
Drew McLellan

Drew McLellan 2638 points
Perch Support

3 years ago

Was this working previously?

You should update to the last version of Perch 2. https://grabaperch.com/update/v2-8-34
Stephen Turvey

Stephen Turvey 0 points

3 years ago

Yeah, for 4 years! Was in there just yesterday.
Drew McLellan

Drew McLellan 2638 points
Perch Support

3 years ago

Have you now updated?
Stephen Turvey

Stephen Turvey 0 points

3 years ago

Yes, I updated the core folder, then went to /admin/core/update which redirects me to the login screen and same issue.
Drew McLellan

Drew McLellan 2638 points
Perch Support

3 years ago

It's still showing as 2.8.29, so it sounds like you have bigger issues at play.
Stephen Turvey

Stephen Turvey 0 points

3 years ago

What could those bigger issues be? Everything else seems to be working except that login
Stephen Turvey

Stephen Turvey 0 points

3 years ago

I just went back to /admin/core/update and this time I did the update. I still can't log in though.

Here's the report from the update:

Debug Message
[31] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
[1] SHOW TABLES LIKE 'perch2_content_index'
CREATE TABLE IF NOT EXISTS `perch2_content_index` ( `indexID` int(10) NOT NULL AUTO_INCREMENT, `itemID` int(10) NOT NULL DEFAULT '0', `regionID` int(10) NOT NULL DEFAULT '0', `pageID` int(10) NOT NULL DEFAULT '0', `itemRev` int(10) NOT NULL DEFAULT '0', `indexKey` char(64) NOT NULL DEFAULT '-', `indexValue` char(255) NOT NULL DEFAULT '', PRIMARY KEY (`indexID`), KEY `idx_key` (`indexKey`), KEY `idx_val` (`indexValue`), KEY `idx_rev` (`itemRev`), KEY `idx_item` (`itemID`), KEY `idx_keyval` (`indexKey`,`indexValue`), KEY `idx_regrev` (`regionID`,`itemRev`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_resources` ( `resourceID` int(10) unsigned NOT NULL AUTO_INCREMENT, `resourceApp` char(32) NOT NULL DEFAULT 'content', `resourceBucket` char(16) NOT NULL DEFAULT 'default', `resourceFile` char(255) NOT NULL DEFAULT '', `resourceKey` enum('orig','thumb') DEFAULT NULL, `resourceParentID` int(10) NOT NULL DEFAULT '0', `resourceType` char(4) NOT NULL DEFAULT '', PRIMARY KEY (`resourceID`), UNIQUE KEY `idx_file` (`resourceBucket`,`resourceFile`), KEY `idx_app` (`resourceApp`), KEY `idx_key` (`resourceKey`), KEY `idx_type` (`resourceType`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
ALTER TABLE `perch2_content_items` ADD INDEX `idx_regrev` USING BTREE (itemID, regionID, itemRev)
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_regrev'
ALTER TABLE `perch2_content_items` ADD INDEX `idx_order` USING BTREE (itemOrder)
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_order'
ALTER TABLE `perch2_content_regions` ADD INDEX `idx_key` USING BTREE (regionKey)
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_key'
ALTER TABLE `perch2_content_regions` ADD INDEX `idx_path` USING BTREE (regionPage)
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_path'
ALTER TABLE `perch2_page_templates` ADD `templateNavGroups` VARCHAR(255) NULL DEFAULT '' AFTER `templateReference`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'templateNavGroups'
CREATE TABLE IF NOT EXISTS `perch2_navigation` ( `groupID` int(10) NOT NULL AUTO_INCREMENT, `groupTitle` varchar(255) NOT NULL DEFAULT '', `groupSlug` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`groupID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_navigation_pages` ( `navpageID` int(10) unsigned NOT NULL AUTO_INCREMENT, `pageID` int(10) unsigned NOT NULL DEFAULT '0', `groupID` int(10) unsigned NOT NULL DEFAULT '0', `pageParentID` int(10) unsigned NOT NULL DEFAULT '0', `pageOrder` int(10) unsigned NOT NULL DEFAULT '1', `pageDepth` tinyint(10) unsigned NOT NULL, `pageTreePosition` varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (`navpageID`), KEY `idx_group` (`groupID`), KEY `idx_page_group` (`pageID`,`groupID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC
ALTER TABLE `perch2_user_privileges` ADD UNIQUE INDEX `idx_key` (`privKey`)
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_key'
INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('content.navgroups.configure','Configure navigation groups',7), ('content.navgroups.create','Create navigation groups',8), ('content.navgroups.delete','Delete navigation groups',9)
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'content.navgroups.configure' for key 'idx_key'
INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('content.pages.create.toplevel','Add new top-level pages',3)
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'content.pages.create.toplevel' for key 'idx_key'
INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('content.pages.delete.own','Delete pages they created themselves',4)
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'content.pages.delete.own' for key 'idx_key'
INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('content.templates.configure','Configure master pages',6)
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'content.templates.configure' for key 'idx_key'
INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('content.pages.republish','Republish pages', 12)
ALTER TABLE `perch2_pages` ADD `pageAccessTags` VARCHAR(255) NOT NULL DEFAULT '' AFTER `pageNavOnly`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageAccessTags'
ALTER TABLE `perch2_pages` ADD `pageCreatorID` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `pageAccessTags`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageCreatorID'
ALTER TABLE `perch2_pages` ADD `pageModified` DATETIME NOT NULL DEFAULT '2014-01-01 00:00:00' AFTER `pageCreatorID`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageModified'
ALTER TABLE `perch2_pages` ADD `pageAttributes` TEXT NOT NULL AFTER `pageModified`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageAttributes'
ALTER TABLE `perch2_pages` ADD `pageAttributeTemplate` VARCHAR(255) NOT NULL DEFAULT 'default.html' AFTER `pageAttributes`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageAttributeTemplate'
INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('content.pages.attributes','Edit page titles and attributes',6)
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'content.pages.attributes' for key 'idx_key'
CREATE TABLE IF NOT EXISTS `perch2_user_role_privileges` ( `roleID` int(10) unsigned NOT NULL, `privID` int(10) unsigned NOT NULL, PRIMARY KEY (`roleID`,`privID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
[1] SHOW TABLES LIKE 'perch2_resource_log'
ALTER TABLE `perch2_resources` ADD `resourceCreated` DATETIME NOT NULL DEFAULT '2000-01-01 00:00:00' AFTER `resourceType`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'resourceCreated'
ALTER TABLE `perch2_resources` ADD `resourceUpdated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `resourceCreated`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'resourceUpdated'
ALTER TABLE `perch2_resources` ADD `resourceAWOL` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `resourceUpdated`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'resourceAWOL'
ALTER TABLE `perch2_resources` ADD INDEX `idx_awol` (`resourceAWOL`)
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_awol'
ALTER TABLE `perch2_resources` ADD `resourceTitle` CHAR(255) NULL DEFAULT NULL AFTER `resourceAWOL`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'resourceTitle'
ALTER TABLE `perch2_resources` ADD `resourceFileSize` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `resourceTitle`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'resourceFileSize'
ALTER TABLE `perch2_resources` ADD `resourceWidth` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `resourceFileSize`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'resourceWidth'
ALTER TABLE `perch2_resources` ADD `resourceHeight` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `resourceWidth`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'resourceHeight'
ALTER TABLE `perch2_resources` ADD `resourceCrop` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `resourceHeight`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'resourceCrop'
ALTER TABLE `perch2_resources` ADD `resourceDensity` FLOAT NOT NULL DEFAULT '1' AFTER `resourceCrop`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'resourceDensity'
ALTER TABLE `perch2_resources` ADD `resourceTargetWidth` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `resourceDensity`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'resourceTargetWidth'
ALTER TABLE `perch2_resources` ADD `resourceTargetHeight` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `resourceTargetWidth`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'resourceTargetHeight'
ALTER TABLE `perch2_resources` ADD `resourceMimeType` CHAR(64) NULL DEFAULT NULL AFTER `resourceTargetHeight`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'resourceMimeType'
ALTER TABLE `perch2_resources` ADD FULLTEXT INDEX `idx_search` (`resourceTitle`)
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_search'
ALTER TABLE `perch2_resources` ADD `resourceInLibrary` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `resourceMimeType`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'resourceInLibrary'
ALTER TABLE `perch2_resources` ADD INDEX `idx_library` (`resourceInLibrary`)
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_library'
CREATE TABLE IF NOT EXISTS `perch2_resource_tags` ( `tagID` INT(10) NOT NULL AUTO_INCREMENT, `tagTitle` VARCHAR(255) NOT NULL DEFAULT '', `tagSlug` VARCHAR(255) NOT NULL DEFAULT '', `tagCount` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`tagID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC
CREATE TABLE IF NOT EXISTS `perch2_resources_to_tags` ( `resourceID` int(10) NOT NULL DEFAULT '0', `tagID` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`resourceID`,`tagID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED
CREATE TABLE IF NOT EXISTS `perch2_resource_log` ( `logID` int(10) unsigned NOT NULL AUTO_INCREMENT, `appID` char(32) NOT NULL DEFAULT 'content', `itemFK` char(32) NOT NULL DEFAULT 'itemRowID', `itemRowID` int(10) unsigned NOT NULL DEFAULT '0', `resourceID` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`logID`), KEY `idx_resource` (`resourceID`), KEY `idx_fk` (`itemFK`,`itemRowID`), UNIQUE KEY `idx_uni` (`appID`,`itemFK`,`itemRowID`,`resourceID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('assets.create','Upload assets',1)
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'assets.create' for key 'idx_key'
INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('assets.manage','Manage assets',2)
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'assets.manage' for key 'idx_key'
CREATE TABLE IF NOT EXISTS `perch2_categories` ( `catID` int(10) NOT NULL AUTO_INCREMENT, `setID` int(10) unsigned NOT NULL, `catParentID` int(10) unsigned NOT NULL DEFAULT '0', `catTitle` char(64) NOT NULL DEFAULT '', `catSlug` char(64) NOT NULL DEFAULT '', `catPath` char(255) NOT NULL DEFAULT '', `catDisplayPath` char(255) NOT NULL DEFAULT '', `catOrder` int(10) unsigned NOT NULL DEFAULT '0', `catTreePosition` char(255) NOT NULL DEFAULT '000', `catDynamicFields` text NOT NULL, PRIMARY KEY (`catID`), KEY `idx_set` (`setID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_category_sets` ( `setID` int(10) NOT NULL AUTO_INCREMENT, `setTitle` char(64) NOT NULL DEFAULT '', `setSlug` char(64) NOT NULL DEFAULT '', `setTemplate` char(255) NOT NULL DEFAULT 'set.html', `setCatTemplate` char(255) NOT NULL DEFAULT 'category.html', `setDynamicFields` text, PRIMARY KEY (`setID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('categories.create','Create new categories',1)
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'categories.create' for key 'idx_key'
INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('categories.delete','Delete categories',2)
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'categories.delete' for key 'idx_key'
INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('categories.manage','Manage categories',3)
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'categories.manage' for key 'idx_key'
INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('categories.sets.create','Create category sets',4)
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'categories.sets.create' for key 'idx_key'
INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('categories.sets.delete','Delete category sets',5)
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'categories.sets.delete' for key 'idx_key'
CREATE TABLE IF NOT EXISTS `perch2_resource_log` ( `logID` int(10) unsigned NOT NULL AUTO_INCREMENT, `appID` char(32) NOT NULL DEFAULT 'content', `itemFK` char(32) NOT NULL DEFAULT 'itemRowID', `itemRowID` int(10) unsigned NOT NULL DEFAULT '0', `resourceID` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`logID`), KEY `idx_resource` (`resourceID`), KEY `idx_fk` (`itemFK`,`itemRowID`), UNIQUE KEY `idx_uni` (`appID`,`itemFK`,`itemRowID`,`resourceID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
ALTER TABLE `perch2_content_regions` ADD `regionUpdated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `regionEditRoles`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'regionUpdated'
ALTER TABLE `perch2_content_items` ADD `itemUpdated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `itemSearch`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'itemUpdated'
ALTER TABLE `perch2_content_items` ADD `itemUpdatedBy` CHAR(32) NOT NULL DEFAULT '' AFTER `itemUpdated`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'itemUpdatedBy'
ALTER TABLE `perch2_pages` ADD `pageTemplate` CHAR(255) NOT NULL DEFAULT '' AFTER `pageAttributeTemplate`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageTemplate'
ALTER TABLE `perch2_pages` ADD `templateID` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `pageTemplate`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'templateID'
ALTER TABLE `perch2_pages` ADD `pageSubpageTemplates` VARCHAR(255) NOT NULL DEFAULT '' AFTER `templateID`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageSubpageTemplates'
ALTER TABLE `perch2_pages` ADD `pageCollections` VARCHAR(255) NOT NULL DEFAULT '' AFTER `pageSubpageTemplates`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'pageCollections'
CREATE TABLE IF NOT EXISTS `perch2_category_counts` ( `countID` int(10) unsigned NOT NULL AUTO_INCREMENT, `catID` int(10) unsigned NOT NULL, `countType` char(64) NOT NULL DEFAULT '', `countValue` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`countID`), KEY `idx_cat` (`catID`), KEY `idx_cat_type` (`countType`,`catID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
ALTER TABLE `perch2_categories` CHANGE `catDisplayPath` `catDisplayPath` CHAR(255) NOT NULL DEFAULT ''
-- DROP INDEX `idx_uni` ON `perch2_resource_log`
ALTER TABLE `perch2_resource_log` ADD UNIQUE INDEX `idx_uni` (`appID`, `itemFK`, `itemRowID`, `resourceID`)
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_uni'
ALTER TABLE `perch2_users` ADD `userPasswordToken` CHAR(255) NOT NULL DEFAULT 'expired' AFTER `userMasterAdmin`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'userPasswordToken'
ALTER TABLE `perch2_users` ADD `userPasswordTokenExpires` DATETIME NOT NULL DEFAULT '2015-01-01 00:00:00' AFTER `userPasswordToken`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'userPasswordTokenExpires'
CREATE TABLE IF NOT EXISTS `perch2_user_passwords` ( `passwordID` int(10) unsigned NOT NULL AUTO_INCREMENT, `userID` int(10) unsigned NOT NULL, `userPassword` varchar(255) NOT NULL DEFAULT '', `passwordLastUsed` datetime NOT NULL DEFAULT '2000-01-01 00:00:00', PRIMARY KEY (`passwordID`), KEY `idx_user` (`userID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
ALTER TABLE `perch2_users` ADD `userLastFailedLogin` DATETIME NULL AFTER `userPasswordTokenExpires`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'userLastFailedLogin'
ALTER TABLE `perch2_users` ADD `userFailedLoginAttempts` INT(0) UNSIGNED NOT NULL DEFAULT '0' AFTER `userLastFailedLogin`
Invalid query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'userFailedLoginAttempts'
ALTER TABLE `perch2_resources` ADD INDEX `idx_list` (`resourceParentID`, `resourceKey`, `resourceAWOL`)
[1] SHOW TABLES LIKE 'perch2_resource_log'
[1928] SELECT COUNT(*) FROM perch2_resource_log
DELETE FROM perch2_settings WHERE settingID='update_2.8.34' AND userID=0 LIMIT 1
INSERT INTO perch2_settings(settingID,settingValue,userID) VALUES('update_2.8.34','done',0)
Queries: 42
Drew McLellan

Drew McLellan 2638 points
Perch Support

3 years ago

What's changed between when it was last working and now?
Stephen Turvey

Stephen Turvey 0 points

3 years ago

Nothing that I can think of. I downloaded the live db and connected to that fine on localhost, so think that rules out some sort of db issue. In the php error log all that appears is something about mailchimp but that error goes back to March. I removed mailchimp from app config and deleted the tables on live db just in case that was it but it hasn't had any effect.

[06-Apr-2018 09:16:16 Europe/London] PHP Fatal error:  Call to a member function is_set() on null in /home/site/wwwroot/admin/addons/apps/perch_mailchimp/lib/PerchMailChimp_Subscribers.class.php on line 29
Drew McLellan

Drew McLellan 2638 points
Perch Support

3 years ago

Have you always used CloudFlare?
Stephen Turvey

Stephen Turvey 0 points

3 years ago

Yes we have
Drew McLellan

Drew McLellan 2638 points
Perch Support

3 years ago

I'm not sure I have any more suggestions then. Is there anything else you can tell me?
Stephen Turvey

Stephen Turvey 0 points

3 years ago

Can confirm this was an Azure hosting issue. Nothing anywhere on the site could be POSTed. We went back and forth with Microsoft support for a week before realising how useless they were and changed hosts. All fine now.