We are transitioning over to a new forum platform. Please post new issues there. Existing threads will be dealt with here unless you choose to move them over. Visit the new forum

Forum

Thread tagged as: Problem, Shop

Product Tag not adding in Shop and missing file

Im trying to add a tag for a product and it says;

"Your product option has been successfully edited. Return to option listing"

But the tag isn't listed anywhere and if I click on the option link in the message I get;

Not Found The requested URL /perch/addons/apps/perch_shop_products/tags/ was not found on this server.

I saw a similar post, but looks like theirs was fixed updating to 1.0.4. I updated before doing this and they are not showing

Diagnostics
Perch: 2.8.29, PHP: 5.4.42, MySQL: mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $, with PDO
Server OS: Darwin, apache2handler
Installed apps: content (2.8.29), assets (2.8.29), categories (2.8.29), perch_shop_orders (1.0.4), perch_shop_products (1.0.4), perch_shop (1.0.4), perch_members (1.5)
App runtimes: <?php $apps_list = array( 'content', 'categories', 'perch_members', 'perch_shop', );
PERCH_LOGINPATH: /perch
PERCH_PATH: /Volumes/FFD Web Work/Euro Med/root/perch
PERCH_CORE: /Volumes/FFD Web Work/Euro Med/root/perch/core
PERCH_RESFILEPATH: /Volumes/FFD Web Work/Euro Med/root/perch/resources
Image manipulation: GD
PHP limits: Max upload 32M, Max POST 32M, Memory: 128M, Total max file upload: 32M
F1: 2edba60ed1f613d6dd804feb202456a2
Resource folder writeable: Yes
HTTP_HOST: euromed
DOCUMENT_ROOT: /Volumes/FFD Web Work/Euro Med/root
REQUEST_URI: /perch/core/settings/diagnostics/
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
Wayne Hooper

Wayne Hooper 6 points

  • 4 years ago
Rachel Andrew

Rachel Andrew 394 points
Perch Support

It sounds as if you are missing files if you are getting a not found.

I've just re-downloaded the shop update and replaced the folders in the app folder and its still the same. Going through the folder structure, there isn't a tags folder in perch_shop_products folder... but then there isn't one in the 1.0.4 download either? There's one in the product folder inside perch_shop_products ?

Drew McLellan

Drew McLellan 2638 points
Perch Support

So you're saying there's a broken link?

I think so. I've created a video of what I'm doing

Video

Drew McLellan

Drew McLellan 2638 points
Perch Support

Have you edited the template at all?

Are repeaters working elsewhere for you?

Was this a clean install of 1.0.4?

I've only edited the product.html at the mo, but as a test I've deleted my templates so that it uses the default ones... same result

Repeaters are working fine elsewhere

Installed 1.0.3 and updated to 1.0.4

Drew McLellan

Drew McLellan 2638 points
Perch Support

Do you get any errors in your browser console?

No errors (Safari error console)

Here is the debug when saving a tag;


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='cf293dc5e99520fc0de64a1c9c9737c7' LIMIT 1 UPDATE perch2_users SET userHash='b15c9c98db835fda98b1c982910513f2' WHERE userID='1' [28] SELECT p.privKey FROM perch2_user_privileges p [24] 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 [1] SELECT * FROM perch2_shop_products WHERE productID='1' AND productDeleted IS NULL LIMIT 1 Using template: /addons/apps/perch_shop/templates/shop/products/tags.html Array ( [productDynamicFields] => {"tags":[{"tag":"test","expiry":{"_default":null},"id":null}]} ) [0] SELECT prodtagID FROM perch2_shop_product_tags WHERE productID=1 AND tagDeleted IS NULL Array ( [tag] => test [expiry] => Array ( [_default] => ) [id] => ) [1] SELECT * FROM perch2_members_tags WHERE tag='test' LIMIT 1 INSERT INTO perch2_shop_product_tags(productID,tagID,tagExpiry,tagOrder,tagDynamicFields) VALUES('1','1',NULL,1,'{\"tag\":\"test\",\"expiry\":{\"_default\":null},\"id\":null}') [1] SELECT * FROM perch2_shop_product_tags WHERE prodtagID='3' LIMIT 1 No ids to log. [1] SELECT * FROM perch2_shop_product_tags WHERE productID=1 AND tagDeleted IS NULL ORDER BY tagOrder ASC Queries: 11 Memory: 4.4795

I've forced an update and its now adding the tags. I did get quite of lot of red errors in the debug on the software update page, is that normal?

Drew McLellan

Drew McLellan 2638 points
Perch Support

What were the errors?

I've re-done the force update process on backup and get the errors below;

I haven't really done much with this site other than add a page-worth of content and setup one product, so if you feel it would be safer to start again let me know.

Debug Message
[23] 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'
[256] SELECT COUNT(*) FROM perch2_resource_log
DELETE FROM perch2_settings WHERE settingID='update_2.8.29' AND userID=0 LIMIT 1
INSERT INTO perch2_settings(settingID,settingValue,userID) VALUES('update_2.8.29','done',0)
Queries: 42
Drew McLellan

Drew McLellan 2638 points
Perch Support

That's fine - it's just stating that the change can't be made because it's already been made.

Thanks Drew

As a note. I noticed that the force update hadn't worked on this version and wouldn't let me know add a tag again. But adding a member has fixed this. So do you have to have a member in the system to be able to add a tag to a product?

Either way its fine now.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Had you installed the Members app at all?

I had as part of shop, but not added a member. It was in the apps config as per the shop instructions.

Drew McLellan

Drew McLellan 2638 points
Perch Support

I wonder if the tables hadn't yet been created. Glad it's sorted.