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: Error, Installation

Error creating some tables for perch_shop

Hi,

When the activate stage runs after installing perch_shop I'm seeing some errors around the creation of a few tables. It seems to be around text columns having default values. I'm running PHP7 and MySQL 5.7 so not sure if that is where the error is?

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='0b496a819b49a7b55afdb6dc2e5dc526' LIMIT 1
UPDATE perch2_users SET userHash='34206eac154b8043db191ef4dbcc7eee' WHERE userID='1'
[64] SELECT p.privKey FROM perch2_user_privileges p
[23] 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
SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM perch2_shop_products WHERE parentID IS NULL AND productDeleted IS NULL ORDER BY title ASC LIMIT 0, 24
Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'prismpot.perch2_shop_products' doesn't exist
[23] SELECT FOUND_ROWS() AS `count`
Attempting app installation: perch_shop
[0] SHOW TABLES LIKE "perch2_shop_products"
CREATE TABLE IF NOT EXISTS `perch2_shop_addresses` ( `addressID` int(10) unsigned NOT NULL AUTO_INCREMENT, `addressTitle` char(128) DEFAULT 'Default', `addressSlug` char(128) DEFAULT 'default', `addressFirstName` char(128) NOT NULL DEFAULT '', `addressLastName` char(128) NOT NULL DEFAULT '', `addressCompany` char(128) NOT NULL DEFAULT '', `addressLine1` char(255) NOT NULL DEFAULT '', `addressDynamicFields` mediumtext, `addressCreated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `addressUpdated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `addressDeleted` datetime DEFAULT NULL, `customerID` int(10) unsigned NOT NULL DEFAULT '0', `countryID` int(10) DEFAULT NULL, `regionID` int(10) DEFAULT NULL, `orderID` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`addressID`), KEY `idx_customer` (`customerID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_admin_index` ( `indexID` int(10) NOT NULL AUTO_INCREMENT, `itemKey` char(64) NOT NULL DEFAULT '-', `itemID` char(32) NOT NULL DEFAULT '0', `indexKey` char(64) NOT NULL DEFAULT '-', `indexValue` char(255) NOT NULL DEFAULT '', PRIMARY KEY (`indexID`), KEY `idx_fk` (`itemKey`,`itemID`), KEY `idx_key` (`indexKey`), KEY `idx_key_val` (`indexKey`,`indexValue`), KEY `idx_keys` (`itemKey`,`indexKey`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_brands` ( `brandID` int(10) unsigned NOT NULL AUTO_INCREMENT, `brandTitle` varchar(255) NOT NULL DEFAULT '', `brandDynamicFields` mediumtext NOT NULL DEFAULT '', `brandCreated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `brandUpdated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `brandDeleted` datetime DEFAULT NULL, PRIMARY KEY (`brandID`) ) CHARSET=utf8
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'brandDynamicFields' can't have a default value
CREATE TABLE IF NOT EXISTS `perch2_shop_cart` ( `cartID` int(10) unsigned NOT NULL AUTO_INCREMENT, `memberID` int(10) unsigned DEFAULT NULL, `customerID` int(10) unsigned DEFAULT NULL, `currencyID` int(10) unsigned DEFAULT NULL, `locationID` int(10) unsigned NOT NULL DEFAULT '0', `shippingID` int(10) unsigned DEFAULT NULL, `cartPricing` enum('standard','sale','trade') DEFAULT 'standard', `cartTotalItems` int(10) unsigned NOT NULL DEFAULT '0', `cartTotalProducts` int(10) unsigned NOT NULL DEFAULT '0', `cartTotalWithTax` decimal(10,2) NOT NULL DEFAULT '0.00', `cartTotalWithoutTax` decimal(10,2) NOT NULL DEFAULT '0.00', `billingAddress` char(128) DEFAULT NULL, `shippingAddress` char(128) DEFAULT NULL, `cartProperties` text, `cartDiscountCode` char(255) DEFAULT '', PRIMARY KEY (`cartID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_cart_data` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `cartID` char(32) NOT NULL DEFAULT '', `productID` char(32) DEFAULT NULL, `orderID` char(32) DEFAULT NULL, `cartData` text, PRIMARY KEY (`id`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_cart_items` ( `itemID` int(10) unsigned NOT NULL AUTO_INCREMENT, `cartID` int(10) unsigned NOT NULL DEFAULT '0', `productID` int(10) unsigned NOT NULL DEFAULT '0', `itemQty` int(10) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`itemID`), KEY `idx_cart` (`cartID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_countries` ( `countryID` int(10) unsigned NOT NULL AUTO_INCREMENT, `country` varchar(255) NOT NULL DEFAULT '', `iso2` char(2) NOT NULL DEFAULT '', `iso3` char(3) NOT NULL DEFAULT '', `isonum` int(10) unsigned NOT NULL DEFAULT '0', `eu` tinyint(1) unsigned NOT NULL DEFAULT '0', `countryActive` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`countryID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_currencies` ( `currencyID` int(10) NOT NULL AUTO_INCREMENT, `currencyCode` char(3) NOT NULL DEFAULT '', `currencyNumber` int(10) unsigned DEFAULT NULL, `currencyTitle` char(64) NOT NULL DEFAULT '', `currencySymbol` char(16) NOT NULL DEFAULT '', `currencySymbolPosition` enum('before','after') NOT NULL DEFAULT 'before', `currencyDecimals` int(10) unsigned NOT NULL DEFAULT '2', `currencyDecimalSeparator` char(16) NOT NULL DEFAULT '.', `currencyThousandsSeparator` char(16) NOT NULL DEFAULT ',', `currencyRate` decimal(65,4) unsigned NOT NULL DEFAULT '1.0000', `currencyActive` tinyint(1) unsigned NOT NULL DEFAULT '0', `currencyIsCommon` tinyint(1) unsigned NOT NULL DEFAULT '0', `currencyDynamicFields` text, PRIMARY KEY (`currencyID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_customers` ( `customerID` int(10) unsigned NOT NULL AUTO_INCREMENT, `customerFirstName` char(128) NOT NULL DEFAULT '', `customerLastName` char(128) NOT NULL DEFAULT '', `customerEmail` char(128) NOT NULL DEFAULT '', `customerDynamicFields` mediumtext, `customerCreated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `customerUpdated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `customerDeleted` datetime DEFAULT NULL, `memberID` int(10) unsigned NOT NULL DEFAULT '0', `customerTaxID` char(255) DEFAULT NULL, `customerTaxIDType` char(32) DEFAULT NULL, `customerTaxIDStatus` enum('valid','invalid','unchecked') NOT NULL DEFAULT 'unchecked', `customerTaxIDLastChecked` datetime DEFAULT NULL, `customerTaxIDLastResponse` char(255) DEFAULT NULL, PRIMARY KEY (`customerID`), KEY `idx_member` (`memberID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_emails` ( `emailID` int(10) unsigned NOT NULL AUTO_INCREMENT, `emailTitle` varchar(255) NOT NULL DEFAULT '', `emailSlug` varchar(255) NOT NULL DEFAULT '', `emailFor` enum('customer','customer_bcc','admin') NOT NULL DEFAULT 'customer', `emailRecipient` varchar(255) DEFAULT NULL, `emailStatus` varchar(255) NOT NULL DEFAULT '', `emailTemplate` varchar(255) NOT NULL DEFAULT 'order_paid.html', `emailActive` varchar(255) NOT NULL DEFAULT '1', `emailDynamicFields` mediumtext NOT NULL DEFAULT '', `emailCreated` datetime NOT NULL DEFAULT '2016-01-01 00:00:00', `emailUpdated` datetime NOT NULL DEFAULT '2016-01-01 00:00:00', PRIMARY KEY (`emailID`) ) CHARSET=utf8
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'emailDynamicFields' can't have a default value
CREATE TABLE IF NOT EXISTS `perch2_shop_index` ( `indexID` int(10) NOT NULL AUTO_INCREMENT, `itemKey` char(64) NOT NULL DEFAULT '-', `itemID` char(32) NOT NULL DEFAULT '0', `indexKey` char(64) NOT NULL DEFAULT '-', `indexValue` char(255) NOT NULL DEFAULT '', PRIMARY KEY (`indexID`), KEY `idx_fk` (`itemKey`,`itemID`), KEY `idx_key` (`indexKey`), KEY `idx_key_val` (`indexKey`,`indexValue`), KEY `idx_keys` (`itemKey`,`indexKey`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_option_values` ( `valueID` int(10) unsigned NOT NULL AUTO_INCREMENT, `optionID` int(10) unsigned NOT NULL DEFAULT '0', `valueTitle` varchar(255) NOT NULL DEFAULT '', `valueSKUCode` char(16) DEFAULT NULL, `valueOrder` int(10) unsigned NOT NULL DEFAULT '1', `valueDynamicFields` mediumtext NOT NULL DEFAULT '', `valueCreated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `valueUpdated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `valueDeleted` datetime DEFAULT NULL, PRIMARY KEY (`valueID`), KEY `idx_mod` (`optionID`) ) CHARSET=utf8
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'valueDynamicFields' can't have a default value
CREATE TABLE IF NOT EXISTS `perch2_shop_options` ( `optionID` int(10) unsigned NOT NULL AUTO_INCREMENT, `optionTitle` varchar(255) NOT NULL DEFAULT '', `optionPrecendence` int(10) unsigned NOT NULL DEFAULT '1', `optionDynamicFields` mediumtext NOT NULL DEFAULT '', `optionCreated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `optionUpdated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `optionDeleted` datetime DEFAULT NULL, PRIMARY KEY (`optionID`) ) CHARSET=utf8
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'optionDynamicFields' can't have a default value
CREATE TABLE IF NOT EXISTS `perch2_shop_order_items` ( `itemID` int(10) unsigned NOT NULL AUTO_INCREMENT, `itemType` enum('product','shipping','discount') NOT NULL DEFAULT 'product', `orderID` int(10) unsigned DEFAULT NULL, `productID` int(10) unsigned DEFAULT NULL, `shippingID` int(10) unsigned DEFAULT NULL, `itemPrice` decimal(10,2) DEFAULT '0.00', `itemTax` decimal(10,2) DEFAULT '0.00', `itemDiscount` decimal(10,2) DEFAULT '0.00', `itemTaxDiscount` decimal(10,2) DEFAULT '0.00', `itemTotal` decimal(10,2) DEFAULT '0.00', `itemQty` int(10) unsigned NOT NULL DEFAULT '1', `itemTaxRate` char(16) DEFAULT '0.00', `itemDynamicFields` mediumtext, PRIMARY KEY (`itemID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_orders` ( `orderID` int(10) unsigned NOT NULL AUTO_INCREMENT, `orderStatus` char(128) DEFAULT '', `orderInvoiceNumber` char(128) DEFAULT NULL, `orderGateway` char(128) NOT NULL DEFAULT '', `orderTotal` char(128) NOT NULL DEFAULT '', `orderItemsSubtotal` char(128) NOT NULL DEFAULT '0', `orderItemsTax` char(128) NOT NULL DEFAULT '0', `orderItemsTotal` char(128) NOT NULL DEFAULT '0', `orderShippingSubtotal` char(128) NOT NULL DEFAULT '0', `orderShippingDiscounts` char(128) NOT NULL DEFAULT '0', `orderShippingTax` char(128) NOT NULL DEFAULT '0', `orderShippingTaxDiscounts` char(128) NOT NULL DEFAULT '0', `orderShippingTotal` char(128) NOT NULL DEFAULT '0', `orderDiscountsTotal` char(128) NOT NULL DEFAULT '0', `orderTaxDiscountsTotal` char(128) NOT NULL DEFAULT '0', `orderSubtotal` char(128) NOT NULL DEFAULT '0', `orderTaxTotal` char(128) NOT NULL DEFAULT '0', `orderItemsRefunded` char(128) NOT NULL DEFAULT '0', `orderTaxRefunded` char(128) NOT NULL DEFAULT '0', `orderShippingRefunded` char(128) NOT NULL DEFAULT '0', `orderTotalRefunded` char(128) NOT NULL DEFAULT '0', `orderTaxID` char(255) DEFAULT NULL, `currencyID` int(10) unsigned NOT NULL DEFAULT '0', `orderExchangeRate` float(10,5) unsigned DEFAULT NULL, `orderShippingWeight` char(128) NOT NULL DEFAULT '0', `customerID` int(10) unsigned NOT NULL DEFAULT '0', `shippingID` int(10) unsigned DEFAULT '0', `orderShippingTaxRate` char(128) NOT NULL DEFAULT '0', `orderShippingAddress` int(10) unsigned NOT NULL DEFAULT '0', `orderBillingAddress` int(10) unsigned NOT NULL DEFAULT '0', `orderGatewayRef` char(255) DEFAULT NULL, `orderPricing` enum('standard','sale','trade') NOT NULL DEFAULT 'standard', `orderDynamicFields` mediumtext, `orderCreated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `orderUpdated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `orderDeleted` datetime DEFAULT NULL, PRIMARY KEY (`orderID`), KEY `idx_customer` (`customerID`), KEY `idx_status` (`orderStatus`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_product_files` ( `fileID` int(10) unsigned NOT NULL AUTO_INCREMENT, `productID` int(10) unsigned NOT NULL DEFAULT '0', `fileTitle` char(255) NOT NULL DEFAULT '', `fileSlug` char(255) NOT NULL DEFAULT '', `resourceID` int(10) NOT NULL DEFAULT '0', `fileDynamicFields` text, `fileOrder` int(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`fileID`), KEY `idx_product` (`productID`), KEY `idx_resource` (`resourceID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_product_option_values` ( `prodoptID` int(10) unsigned NOT NULL AUTO_INCREMENT, `productID` int(10) unsigned NOT NULL DEFAULT '0', `optionID` int(10) unsigned NOT NULL DEFAULT '0', `valueID` int(10) unsigned NOT NULL DEFAULT '0', `valueModPrice` decimal(4,2) NOT NULL DEFAULT '0.00', `valueModOperator` enum('+','-','=') NOT NULL DEFAULT '+', PRIMARY KEY (`prodoptID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_product_options` ( `productID` int(10) unsigned NOT NULL DEFAULT '0', `optionID` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`productID`,`optionID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_products` ( `productID` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '', `sku` char(255) NOT NULL DEFAULT '', `productSlug` varchar(255) DEFAULT NULL, `stock_level` int(10) unsigned DEFAULT NULL, `parentID` int(10) unsigned DEFAULT NULL, `productVariantDesc` varchar(255) DEFAULT NULL, `productOrder` int(10) unsigned NOT NULL DEFAULT '1', `productHasVariants` tinyint(1) unsigned NOT NULL DEFAULT '0', `productStockOnParent` tinyint(1) unsigned DEFAULT '0', `productDynamicFields` mediumtext NOT NULL DEFAULT '', `productTemplate` char(64) NOT NULL DEFAULT 'product.html', `productCreated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `productUpdated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `productDeleted` datetime DEFAULT NULL, PRIMARY KEY (`productID`), KEY `idx_sku` (`sku`), KEY `idx_del` (`productDeleted`), KEY `idx_parent` (`parentID`) ) CHARSET=utf8
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'productDynamicFields' can't have a default value
CREATE TABLE IF NOT EXISTS `perch2_shop_promotions` ( `promoID` int(10) unsigned NOT NULL AUTO_INCREMENT, `promoTitle` varchar(255) NOT NULL DEFAULT '', `promoDynamicFields` mediumtext NOT NULL DEFAULT '', `promoFrom` datetime DEFAULT NULL, `promoTo` datetime DEFAULT NULL, `promoActive` tinyint(1) DEFAULT '1', `promoOrder` int(10) unsigned NOT NULL DEFAULT '1', `promoCreated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `promoUpdated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `promoDeleted` datetime DEFAULT NULL, PRIMARY KEY (`promoID`) ) CHARSET=utf8
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'promoDynamicFields' can't have a default value
CREATE TABLE `perch2_shop_search` ( `searchID` int(10) unsigned NOT NULL AUTO_INCREMENT, `itemKey` int(10) unsigned NOT NULL DEFAULT '0', `itemType` enum('product','brand') DEFAULT 'product', `searchBody` text, PRIMARY KEY (`searchID`), KEY `itemKey` (`itemKey`,`itemType`), FULLTEXT KEY `idx_search` (`searchBody`) ) ENGINE=MyISAM CHARSET=utf8
Invalid query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'perch2_shop_search' already exists
CREATE TABLE IF NOT EXISTS `perch2_shop_shippings` ( `shippingID` int(10) unsigned NOT NULL AUTO_INCREMENT, `shippingTitle` varchar(255) NOT NULL DEFAULT '', `shippingSlug` varchar(255) NOT NULL DEFAULT '', `shippingOrder` int(10) unsigned NOT NULL DEFAULT '1', `shippingDynamicFields` mediumtext NOT NULL DEFAULT '', `shippingCreated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `shippingUpdated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `shippingDeleted` datetime DEFAULT NULL, PRIMARY KEY (`shippingID`) ) CHARSET=utf8
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'shippingDynamicFields' can't have a default value
CREATE TABLE IF NOT EXISTS `perch2_shop_tax_exhibits` ( `exhibitID` int(10) unsigned NOT NULL AUTO_INCREMENT, `orderID` int(10) unsigned NOT NULL DEFAULT '0', `exhibitType` enum('BILL_ADDRESS','SHIP_ADDRESS','IP_ADDRESS','CARD_ADDRESS','MANUAL') NOT NULL DEFAULT 'IP_ADDRESS', `exhibitDetail` char(255) NOT NULL DEFAULT '', `exhibitSource` char(255) NOT NULL DEFAULT '', `locationID` int(10) unsigned DEFAULT NULL, `countryID` int(10) unsigned DEFAULT NULL, `exhibitDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`exhibitID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_tax_group_rates` ( `grouprateID` int(10) unsigned NOT NULL AUTO_INCREMENT, `locationID` int(10) unsigned NOT NULL DEFAULT '0', `groupID` int(10) unsigned NOT NULL DEFAULT '0', `rateID` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`grouprateID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_tax_groups` ( `groupID` int(10) unsigned NOT NULL AUTO_INCREMENT, `groupTitle` char(255) NOT NULL DEFAULT '', `groupSlug` char(255) DEFAULT NULL, `groupTaxRate` enum('buyer','seller') NOT NULL DEFAULT 'seller', `groupDynamicFields` mediumtext, `groupCreated` datetime DEFAULT NULL, `groupUpdated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `groupDeleted` datetime DEFAULT NULL, PRIMARY KEY (`groupID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_tax_locations` ( `locationID` int(10) unsigned NOT NULL AUTO_INCREMENT, `locationTitle` char(255) NOT NULL DEFAULT '', `countryID` int(10) unsigned DEFAULT NULL, `regionID` int(10) unsigned DEFAULT NULL, `locationIsHome` tinyint(1) unsigned DEFAULT '0', `locationIsDefault` tinyint(1) unsigned DEFAULT '0', `locationTaxRate` decimal(4,2) unsigned NOT NULL DEFAULT '0.00', `locationTaxRateReduced` decimal(4,2) unsigned NOT NULL DEFAULT '0.00', `locationDynamicFields` mediumtext, `locationCreated` datetime DEFAULT NULL, `locationUpdated` datetime DEFAULT NULL, `locationDeleted` datetime DEFAULT NULL, PRIMARY KEY (`locationID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_tax_rates` ( `rateID` int(10) unsigned NOT NULL AUTO_INCREMENT, `locationID` int(10) unsigned NOT NULL DEFAULT '0', `rateTitle` char(128) NOT NULL DEFAULT 'Standard', `rateValue` decimal(4,2) NOT NULL DEFAULT '0.00', `rateDynamicFields` text, `rateCreated` datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `rateUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `rateDeleted` datetime DEFAULT NULL, PRIMARY KEY (`rateID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_variants` ( `productID` int(10) unsigned NOT NULL DEFAULT '0', `optionID` int(10) unsigned NOT NULL DEFAULT '0', `valueID` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`productID`,`optionID`,`valueID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_product_tags` ( `prodtagID` int(10) unsigned NOT NULL AUTO_INCREMENT, `productID` int(10) unsigned NOT NULL DEFAULT '0', `tagID` int(10) unsigned NOT NULL DEFAULT '0', `tagExpiry` char(255) DEFAULT NULL, `tagDynamicFields` text, `tagOrder` int(10) unsigned DEFAULT NULL, `tagCreated` datetime DEFAULT NULL, `tagModified` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `tagDeleted` timestamp NULL DEFAULT NULL, PRIMARY KEY (`prodtagID`), KEY `idx_product` (`productID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_orders_meta` ( `id` char(64) NOT NULL DEFAULT '', `metaValue` char(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_order_statuses` ( `statusID` int(10) unsigned NOT NULL AUTO_INCREMENT, `statusKey` char(64) NOT NULL DEFAULT '', `statusTitle` char(128) NOT NULL DEFAULT '', `statusEditable` tinyint(1) unsigned NOT NULL DEFAULT '1', `statusIndex` int(10) unsigned NOT NULL DEFAULT '101', `statusDynamicFields` text, `statusCreated` datetime NOT NULL DEFAULT '2016-01-01 00:00:00', `statusUpdated` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `statusDeleted` datetime DEFAULT NULL, `statusActive` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`statusID`), KEY `idx_key` (`statusKey`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_order_promotions` ( `orderpromoID` int(10) unsigned NOT NULL AUTO_INCREMENT, `promoID` int(10) unsigned NOT NULL DEFAULT '0', `orderID` int(10) unsigned NOT NULL DEFAULT '0', `customerID` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`orderpromoID`), KEY `idx_promo` (`promoID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_shipping_zones` ( `zoneID` int(10) unsigned NOT NULL AUTO_INCREMENT, `zoneTitle` char(255) NOT NULL DEFAULT '', `zoneSlug` char(255) DEFAULT NULL, `zoneIsDefault` tinyint(1) unsigned DEFAULT '0', `zoneActive` tinyint(1) unsigned NOT NULL DEFAULT '1', `zoneDynamicFields` mediumtext, `zoneCreated` datetime DEFAULT NULL, `zoneUpdated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `zoneDeleted` datetime DEFAULT NULL, PRIMARY KEY (`zoneID`) ) CHARSET=utf8
CREATE TABLE IF NOT EXISTS `perch2_shop_shipping_zone_countries` ( `zcID` int(10) unsigned NOT NULL AUTO_INCREMENT, `zoneID` int(10) unsigned NOT NULL DEFAULT '0', `countryID` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`zcID`), KEY `idx_country` (`countryID`), KEY `idx_zone` (`zoneID`) ) CHARSET=utf8
INSERT INTO `perch2_shop_countries` (`countryID`, `country`, `iso2`, `iso3`, `isonum`, `eu`, `countryActive`) VALUES (1,'Afganistan','AF','AFG',4,0,1), (2,'Åland Islands','AX','ALA',248,0,1), (3,'Albania','AL','ALB',8,0,1), (4,'Algeria','DZ','DZA',12,0,1), (5,'American Samoa','AS','ASM',16,0,1), (6,'Andorra','AD','AND',20,0,1), (7,'Angola','AO','AGO',24,0,1), (8,'Anguilla','AI','AIA',660,0,1), (9,'Antigua & Barbuda','AG','ATG',28,0,1), (10,'Argentina','AR','ARG',32,0,1), (11,'Armenia','AM','ARM',51,0,1), (12,'Aruba','AW','ABW',533,0,1), (13,'Australia','AU','AUS',36,0,1), (14,'Austria','AT','AUT',40,1,1), (15,'Azerbaijan','AZ','AZE',31,0,1), (16,'Bahamas','BS','BHS',44,0,1), (17,'Bahrain','BH','BHR',48,0,1), (18,'Bangladesh','BD','BGD',50,0,1), (19,'Barbados','BB','BRB',52,0,1), (20,'Belarus','BY','BLR',112,0,1), (21,'Belgium','BE','BEL',56,1,1), (22,'Belize','BZ','BLZ',84,0,1), (23,'Benin','BJ','BEN',204,0,1), (24,'Bermuda','BM','BMU',60,0,1), (25,'Bhutan','BT','BTN',64,0,1), (26,'Bolivia','BO','BOL',68,0,1), (27,'Bonaire','BQ','BES',535,0,1), (28,'Bosnia-Herzegovina','BA','BIH',70,0,1), (29,'Botswana','BW','BWA',72,0,1), (30,'Brazil','BR','BRA',76,0,1), (31,'British Indian Ocean Territory','IO','IOT',86,0,1), (32,'British Virgin Islands','VG','VGB',92,0,1), (33,'Brunei Darussalam','BN','BRN',96,0,1), (34,'Bulgaria','BG','BGR',100,1,1), (35,'Burkina Faso','BF','BFA',854,0,1), (36,'Burundi','BI','BDI',108,0,1), (37,'Cambodia','KH','KHM',116,0,1), (38,'Cameroon','CM','CMR',120,0,1), (39,'Canada','CA','CAN',124,0,1), (40,'Cape Verde Islands','CV','CPV',132,0,1), (41,'Cayman Islands','KY','CYM',136,0,1), (42,'Central African Republic','CF','CAF',140,0,1), (43,'Chad','TD','TCD',148,0,1), (44,'Chile','CL','CHL',152,0,1), (45,'China','CN','CHN',156,0,1), (46,'Christmas Island','CX','CXR',162,0,1), (47,'Cocos (Keeling) Islands','CC','CCK',166,0,1), (48,'Colombia','CO','COL',170,0,1), (49,'Comoros','KM','COM',174,0,1), (50,'Congo (Brazzaville)','CG','COG',178,0,1), (51,'Congo (Kinshasa)','CD','ZAR',180,0,1), (52,'Cook Islands','CK','COK',184,0,1), (53,'Costa Rica','CR','CRI',188,0,1), (54,'Croatia','HR','HRV',191,1,1), (55,'Cuba','CU','CUB',192,0,1), (56,'Curaçao','CW','CUW',531,0,1), (57,'Cyprus','CY','CYP',196,1,1), (58,'Czech Republic','CZ','CZE',203,1,1), (59,'Denmark','DK','DNK',208,1,1), (60,'Djibouti','DJ','DJI',262,0,1), (61,'Dominica','DM','DMA',212,0,1), (62,'Dominican Republic','DO','DOM',214,0,1), (63,'East Timor','TL','TLS',626,0,1), (64,'Ecuador','EC','ECU',218,0,1), (65,'Egypt','EG','EGY',818,0,1), (66,'El Salvador','SV','SLV',222,0,1), (67,'Equatorial Guinea','GQ','GNQ',226,0,1), (68,'Eritrea','ER','ERI',232,0,1), (69,'Estonia','EE','EST',233,1,1), (70,'Ethiopia','ET','ETH',231,0,1), (71,'Faeroe Islands','FO','FRO',234,0,1), (72,'Falkland Islands','FK','FLK',238,0,1), (73,'Fiji','FJ','FJI',242,0,1), (74,'Finland','FI','FIN',246,1,1), (75,'France','FR','FRA',250,1,1), (76,'French Guiana','GF','GUF',254,0,1), (77,'French Polynesia','PF','PYF',258,0,1), (78,'French Southern Territories','TF','ATF',260,0,1), (79,'Gabon','GA','GAB',266,0,1), (80,'Gambia','GM','GMB',270,0,1), (81,'Georgia','GE','GEO',268,0,1), (82,'Germany','DE','DEU',276,1,1), (83,'Ghana','GH','GHA',288,0,1), (84,'Gibralter','GI','GIB',292,0,1), (85,'Greece','GR','GRC',300,1,1), (86,'Greenland','GL','GRL',304,0,1), (87,'Grenada','GD','GRD',308,0,1), (88,'Guadeloupe','GP','GLP',312,0,1), (89,'Guam','GU','GUM',316,0,1), (90,'Guatemala','GT','GTM',320,0,1), (91,'Guernsey','GG','GGY',831,0,1), (92,'Guinea','GN','GIN',324,0,1), (93,'Guinea-Bissau','GW','GNB',624,0,1), (94,'Guyana','GY','GUY',328,0,1), (95,'Haiti','HT','HTI',332,0,1), (96,'Holy See','VA','VAT',336,0,1), (97,'Honduras','HN','HND',340,0,1), (98,'Hong Kong','HK','HKG',344,0,1), (99,'Hungary','HU','HUN',348,1,1), (100,'Iceland','IS','ISL',352,0,1), (101,'India','IN','IND',356,0,1), (102,'Indonesia','ID','IDN',360,0,1), (103,'Iran','IR','IRN',364,0,1), (104,'Iraq','IQ','IRQ',368,0,1), (105,'Ireland','IE','IRL',372,1,1), (106,'Isle of Man','IM','IMN',833,0,1), (107,'Israel','IL','ISR',376,0,1), (108,'Italy','IT','ITA',380,1,1), (109,'Ivory Coast','CI','CIV',384,0,1), (110,'Jamaica','JM','JAM',388,0,1), (111,'Japan','JP','JPN',392,0,1), (112,'Jersey','JE','JEY',832,0,1), (113,'Jordan','JO','JOR',400,0,1), (114,'Kazakhstan','KZ','KAZ',398,0,1), (115,'Kenya','KE','KEN',404,0,1), (116,'Kiribati','KI','KIR',296,0,1), (117,'Kuwait','KW','KWT',414,0,1), (118,'Kyrgyzstan','KG','KGZ',417,0,1), (119,'Laos','LA','LAO',418,0,1), (120,'Latvia','LV','LVA',428,1,1), (121,'Lebanon','LB','LBN',422,0,1), (122,'Lesotho','LS','LSO',426,0,1), (123,'Liberia','LR','LBR',430,0,1), (124,'Libya','LY','LBY',434,0,1), (125,'Liechtenstein','LI','LIE',438,0,1), (126,'Lithuania','LT','LTU',440,1,1), (127,'Luxembourg','LU','LUX',442,1,1), (128,'Macau','MO','MAC',446,0,1), (129,'Macedonia','MK','MKD',807,0,1), (130,'Madagascar','MG','MDG',450,0,1), (131,'Malawi','MW','MWI',454,0,1), (132,'Malaysia','MY','MYS',458,0,1), (133,'Maldives','MV','MDV',462,0,1), (134,'Mali','ML','MLI',466,0,1), (135,'Malta','MT','MLT',470,1,1), (136,'Marshall Islands','MH','MHL',584,0,1), (137,'Martinique','MQ','MTQ',474,0,1), (138,'Mauritania','MR','MRT',478,0,1), (139,'Mauritius','MU','MUS',480,0,1), (140,'Mayotte','YT','MYT',175,0,1), (141,'Mexico','MX','MEX',484,0,1), (142,'Micronesia','FM','FSM',583,0,1), (143,'Moldova','MD','MDA',498,0,1), (144,'Monaco','MC','MCO',492,0,1), (145,'Mongolia','MN','MNG',496,0,1), (146,'Montenegro','ME','MNE',499,0,1), (147,'Montserrat','MS','MSR',500,0,1), (148,'Morocco','MA','MAR',504,0,1), (149,'Mozambique','MZ','MOZ',508,0,1), (150,'Myanmar','MM','MMR',104,0,1), (151,'Namibia','NA','NAM',516,0,1), (152,'Nauru','NR','NRU',520,0,1), (153,'Nepal','NP','NPL',524,0,1), (154,'Netherlands Antilles','AN','ANT',530,0,1), (155,'Netherlands','NL','NLD',528,1,1), (156,'New Caledonia','NC','NCL',540,0,1), (157,'New Zealand','NZ','NZL',554,0,1), (158,'Nicaragua','NI','NIC',558,0,1), (159,'Niger','NE','NER',562,0,1), (160,'Nigeria','NG','NGA',566,0,1), (161,'Niue','NU','NIU',570,0,1), (162,'Norfolk Island','NF','NFK',574,0,1), (163,'North Korea','KP','PRK',408,0,1), (164,'Northern Mariana Islands','MP','MNP',580,0,1), (165,'Norway','NO','NOR',578,0,1), (166,'Oman','OM','OMN',512,0,1), (167,'Pakistan','PK','PAK',586,0,1), (168,'Palau','PW','PLW',585,0,1), (169,'Palestinian Territories','PS','PSE',275,0,1), (170,'Panama','PA','PAN',591,0,1), (171,'Papua New Guinea','PG','PNG',598,0,1), (172,'Paraguay','PY','PRY',600,0,1), (173,'Peru','PE','PER',604,0,1), (174,'Philippines','PH','PHL',608,0,1), (175,'Pitcairn Islands','PN','PCN',612,0,1), (176,'Poland','PL','POL',616,1,1), (177,'Portugal','PT','PRT',620,1,1), (178,'Puerto Rico','PR','PRI',630,0,1), (179,'Qatar','QA','QAT',634,0,1), (180,'Romania','RO','ROU',642,1,1), (181,'Russia','RU','RUS',643,0,1), (182,'Rwanda','RW','RWA',646,0,1), (183,'Réunion','RE','REU',638,0,1), (184,'Saba','BQ','BES',535,0,1), (185,'Saint Barthélemy','BL','BLM',652,0,1), (186,'Saint Christopher & Nevis','KN','KNA',659,0,1), (187,'Saint Helena','SH','SHN',654,0,1), (188,'Saint Lucia','LC','LCA',662,0,1), (189,'Saint Martin','MF','MAF',663,0,1), (190,'Saint Pierre & Miquelon','PM','SPM',666,0,1), (191,'Saint Vincent & The Grenadines','VC','VCT',670,0,1), (192,'Samoa','WS','WSM',882,0,1), (193,'San Marino','SM','SMR',674,0,1), (194,'Sao Tome & Principe','ST','STP',678,0,1), (195,'Saudi Arabia','SA','SAU',682,0,1), (196,'Senegal','SN','SEN',686,0,1), (197,'Serbia','RS','SRB',688,0,1), (198,'Seychelles','SC','SYC',690,0,1), (199,'Sierra Leone','SL','SLE',694,0,1), (200,'Singapore','SG','SGP',702,0,1), (201,'Sint Eustatius','BQ','BES',535,0,1), (202,'Sint Maarten','SX','SXM',534,0,1), (203,'Slovakia','SK','SVK',703,1,1), (204,'Slovenia','SI','SVN',705,1,1), (205,'Solomon Islands','SB','SLB',90,0,1), (206,'Somalia','SO','SOM',706,0,1), (207,'Somaliland','SO','SOM',706,0,1), (208,'South Africa','ZA','ZAF',710,0,1), (209,'South Georgia & The South Sandwish Islands','GS','SGS',239,0,1), (210,'South Korea','KR','KOR',418,0,1), (211,'South Sudan','SS','SSD',0,0,1), (212,'Spain','ES','ESP',724,1,1), (213,'Sri Lanka','LK','LKA',144,0,1), (214,'Sudan','SD','SDN',736,0,1), (215,'Suriname','SR','SUR',740,0,1), (216,'Swaziland','SZ','SWZ',748,0,1), (217,'Sweden','SE','SWE',752,1,1), (218,'Switzerland','CH','CHE',756,0,1), (219,'Syria','SY','SYR',760,0,1), (220,'Taiwan','TW','TWN',158,0,1), (221,'Tajikistan','TJ','TJK',762,0,1), (222,'Tanzania','TZ','TZA',834,0,1), (223,'Thailand','TH','THA',764,0,1), (224,'Togo','TG','TGO',768,0,1), (225,'Tokelau','TK','TKL',772,0,1), (226,'Tonga','TO','TON',776,0,1), (227,'Trinidad & Tobago','TT','TTO',780,0,1), (228,'Tunisia','TN','TUN',788,0,1), (229,'Turkey','TR','TUR',792,0,1), (230,'Turkmenistan','TM','TKM',795,0,1), (231,'Turks & Caicos Islands','TC','TCA',796,0,1), (232,'Tuvalu','TV','TUV',798,0,1), (233,'Uganda','UG','UGA',800,0,1), (234,'Ukraine','UA','UKR',804,0,1), (235,'United Arab Emirates','AE','ARE',784,0,1), (236,'United Kingdom','GB','GBR',826,1,1), (237,'United States','US','USA',840,0,1), (238,'United States Virgin Islands','VI','VIR',850,0,1), (239,'Uruguay','UY','URY',858,0,1), (240,'Uzbekistan','UZ','UZB',860,0,1), (241,'Vanuatu','VU','VUT',548,0,1), (242,'Venezuela','VE','VEN',862,0,1), (243,'Vietnam','VN','VNM',704,0,1), (244,'Wallis & Futuna','WF','WLF',876,0,1), (245,'Western Sahara','EH','ESH',732,0,1), (246,'Yemen','YE','YEM',887,0,1), (247,'Zambia','ZM','ZMB',894,0,1), (248,'Zimbabwe','ZW','ZWE',716,0,1), (249,'Vatican City','VA','VAT',336,0,1), (250,'Saint Kitts and Nevis','KN','KNA',659,0,1)
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'
INSERT INTO `perch2_shop_currencies` (`currencyID`, `currencyCode`, `currencyNumber`, `currencyTitle`, `currencySymbol`, `currencyDecimals`, `currencyRate`, `currencyActive`, `currencyIsCommon`, `currencyDynamicFields`) VALUES (1,'AED',784,'United Arab Emirates dirham','د.إ',2,1.0000,0,0,NULL), (2,'AFN',971,'Afghan afghani','؋',2,1.0000,0,0,NULL), (3,'ALL',8,'Albanian lek','Lek',2,1.0000,0,0,NULL), (4,'AMD',51,'Armenian dram','¤',2,1.0000,0,0,NULL), (5,'ANG',532,'Netherlands Antillean guilder','ƒ',2,1.0000,0,0,NULL), (6,'AOA',973,'Angolan kwanza','Kz',2,1.0000,0,0,NULL), (7,'ARS',32,'Argentine peso','$',2,1.0000,0,0,NULL), (8,'AUD',36,'Australian dollar','$',2,1.0000,0,1,NULL), (9,'AWG',533,'Aruban florin','ƒ',2,1.0000,0,0,NULL), (10,'AZN',944,'Azerbaijani manat','ман',2,1.0000,0,0,NULL), (11,'BAM',977,'Bosnia and Herzegovina convertible mark','KM',2,1.0000,0,0,NULL), (12,'BBD',52,'Barbados dollar','$',2,1.0000,0,0,NULL), (13,'BDT',50,'Bangladeshi taka','৳',2,1.0000,0,0,NULL), (14,'BGN',975,'Bulgarian lev','лв',2,1.0000,0,0,NULL), (15,'BHD',48,'Bahraini dinar','BD',3,1.0000,0,0,NULL), (16,'BIF',108,'Burundian franc','FBu',0,1.0000,0,0,NULL), (17,'BMD',60,'Bermudian dollar','$',2,1.0000,0,0,NULL), (18,'BND',96,'Brunei dollar','$',2,1.0000,0,0,NULL), (19,'BOB',68,'Boliviano','$b',2,1.0000,0,0,NULL), (20,'BRL',986,'Brazilian real','R$',2,1.0000,0,0,NULL), (21,'BSD',44,'Bahamian dollar','$',2,1.0000,0,0,NULL), (22,'BTN',64,'Bhutanese ngultrum','Nu.',2,1.0000,0,0,NULL), (23,'BWP',72,'Botswana pula','P',2,1.0000,0,0,NULL), (24,'BYR',974,'Belarusian ruble','p.',0,1.0000,0,0,NULL), (25,'BZD',84,'Belize dollar','BZ$',2,1.0000,0,0,NULL), (26,'CAD',124,'Canadian dollar','$',2,1.0000,0,1,NULL), (27,'CDF',976,'Congolese franc','FC',2,1.0000,0,0,NULL), (28,'CHF',756,'Swiss franc','CHF',2,1.0000,0,1,NULL), (29,'CLP',152,'Chilean peso','$',0,1.0000,0,0,NULL), (30,'CNY',156,'Chinese yuan','¥',2,1.0000,0,0,NULL), (31,'COP',170,'Colombian peso','$',2,1.0000,0,0,NULL), (32,'CRC',188,'Costa Rican colon','₡',2,1.0000,0,0,NULL), (33,'CUC',931,'Cuban convertible peso','CUC$',2,1.0000,0,0,NULL), (34,'CUP',192,'Cuban peso','₱',2,1.0000,0,0,NULL), (35,'CVE',132,'Cape Verde escudo','$',0,1.0000,0,0,NULL), (36,'CZK',203,'Czech koruna','Kč',2,1.0000,0,0,NULL), (37,'DJF',262,'Djiboutian franc','Fdj',0,1.0000,0,0,NULL), (38,'DKK',208,'Danish krone','kr',2,1.0000,0,1,NULL), (39,'DOP',214,'Dominican peso','RD$',2,1.0000,0,0,NULL), (40,'DZD',12,'Algerian dinar','د.ج',2,1.0000,0,0,NULL), (41,'EGP',818,'Egyptian pound','£',2,1.0000,0,0,NULL), (42,'ERN',232,'Eritrean nakfa','Nfk',2,1.0000,0,0,NULL), (43,'ETB',230,'Ethiopian birr','Br',2,1.0000,0,0,NULL), (44,'EUR',978,'Euro','€',2,1.0000,0,1,'[]'), (45,'FJD',242,'Fiji dollar','$',2,1.0000,0,0,NULL), (46,'FKP',238,'Falkland Islands pound','£',2,1.0000,0,0,NULL), (47,'GBP',826,'Pound sterling','£',2,1.0000,1,1,NULL), (48,'GEL',981,'Georgian lari','GEL',2,1.0000,0,0,NULL), (49,'GHS',936,'Ghanaian cedi','GH₵',2,1.0000,0,0,NULL), (50,'GIP',292,'Gibraltar pound','£',2,1.0000,0,0,NULL), (51,'GMD',270,'Gambian dalasi','D',2,1.0000,0,0,NULL), (52,'GNF',324,'Guinean franc','FG',0,1.0000,0,0,NULL), (53,'GTQ',320,'Guatemalan quetzal','Q',2,1.0000,0,0,NULL), (54,'GYD',328,'Guyanese dollar','$',2,1.0000,0,0,NULL), (55,'HKD',344,'Hong Kong dollar','$',2,1.0000,0,0,NULL), (56,'HNL',340,'Honduran lempira','L',2,1.0000,0,0,NULL), (57,'HRK',191,'Croatian kuna','kn',2,1.0000,0,0,NULL), (58,'HTG',332,'Haitian gourde','G',2,1.0000,0,0,NULL), (59,'HUF',348,'Hungarian forint','Ft',2,1.0000,0,0,NULL), (60,'IDR',360,'Indonesian rupiah','Rp',2,1.0000,0,0,NULL), (61,'ILS',376,'Israeli new shekel','₪',2,1.0000,0,0,NULL), (62,'INR',356,'Indian rupee','₹',2,1.0000,0,0,NULL), (63,'IQD',368,'Iraqi dinar','ع.د',3,1.0000,0,0,NULL), (64,'IRR',364,'Iranian rial','﷼',2,1.0000,0,0,NULL), (65,'ISK',352,'Icelandic króna','kr',0,1.0000,0,0,NULL), (66,'JMD',388,'Jamaican dollar','J$',2,1.0000,0,0,NULL), (67,'JOD',400,'Jordanian dinar','JD',3,1.0000,0,0,NULL), (68,'JPY',392,'Japanese yen','¥',0,1.0000,0,0,NULL), (69,'KES',404,'Kenyan shilling','KSh',2,1.0000,0,0,NULL), (70,'KGS',417,'Kyrgyzstani som','лв',2,1.0000,0,0,NULL), (71,'KHR',116,'Cambodian riel','៛',2,1.0000,0,0,NULL), (72,'KMF',174,'Comoro franc','CF',0,1.0000,0,0,NULL), (73,'KPW',408,'North Korean won','₩',2,1.0000,0,0,NULL), (74,'KRW',410,'South Korean won','₩',0,1.0000,0,0,NULL), (75,'KWD',414,'Kuwaiti dinar','K.D.',3,1.0000,0,0,NULL), (76,'KYD',136,'Cayman Islands dollar','$',2,1.0000,0,0,NULL), (77,'KZT',398,'Kazakhstani tenge','лв',2,1.0000,0,0,NULL), (78,'LAK',418,'Lao kip','₭',2,1.0000,0,0,NULL), (79,'LBP',422,'Lebanese pound','£',2,1.0000,0,0,NULL), (80,'LKR',144,'Sri Lankan rupee','₨',2,1.0000,0,0,NULL), (81,'LRD',430,'Liberian dollar','$',2,1.0000,0,0,NULL), (82,'LSL',426,'Lesotho loti','L',2,1.0000,0,0,NULL), (83,'LYD',434,'Libyan dinar','LD',3,1.0000,0,0,NULL), (84,'MAD',504,'Moroccan dirham','د.م.',2,1.0000,0,0,NULL), (85,'MDL',498,'Moldovan leu','lei',2,1.0000,0,0,NULL), (86,'MGA',969,'Malagasy ariary','Ar',1,1.0000,0,0,NULL), (87,'MKD',807,'Macedonian denar','ден',2,1.0000,0,0,NULL), (88,'MMK',104,'Myanmar kyat','K',2,1.0000,0,0,NULL), (89,'MNT',496,'Mongolian tugrik','₮',2,1.0000,0,0,NULL), (90,'MOP',446,'Macanese pataca','MOP$',2,1.0000,0,0,NULL), (91,'MRO',478,'Mauritanian ouguiya','UM',1,1.0000,0,0,NULL), (92,'MUR',480,'Mauritian rupee','₨',2,1.0000,0,0,NULL), (93,'MVR',462,'Maldivian rufiyaa','Rf',2,1.0000,0,0,NULL), (94,'MWK',454,'Malawian kwacha','MK',2,1.0000,0,0,NULL), (95,'MXN',484,'Mexican peso','$',2,1.0000,0,0,NULL), (96,'MYR',458,'Malaysian ringgit','RM',2,1.0000,0,0,NULL), (97,'MZN',943,'Mozambican metical','MT',2,1.0000,0,0,NULL), (98,'NAD',516,'Namibian dollar','$',2,1.0000,0,0,NULL), (99,'NGN',566,'Nigerian naira','₦',2,1.0000,0,0,NULL), (100,'NIO',558,'Nicaraguan córdoba','C$',2,1.0000,0,0,NULL), (101,'NOK',578,'Norwegian krone','kr',2,1.0000,0,1,NULL), (102,'NPR',524,'Nepalese rupee','₨',2,1.0000,0,0,NULL), (103,'NZD',554,'New Zealand dollar','$',2,1.0000,0,1,NULL), (104,'OMR',512,'Omani rial','﷼',3,1.0000,0,0,NULL), (105,'PAB',590,'Panamanian balboa','B/.',2,1.0000,0,0,NULL), (106,'PEN',604,'Peruvian nuevo sol','S/.',2,1.0000,0,0,NULL), (107,'PGK',598,'Papua New Guinean kina','K',2,1.0000,0,0,NULL), (108,'PHP',608,'Philippine peso','₱',2,1.0000,0,0,NULL), (109,'PKR',586,'Pakistani rupee','₨',2,1.0000,0,0,NULL), (110,'PLN',985,'Polish złoty','zł',2,1.0000,0,0,NULL), (111,'PYG',600,'Paraguayan guaraní','Gs',0,1.0000,0,0,NULL), (112,'QAR',634,'Qatari riyal','﷼',2,1.0000,0,0,NULL), (113,'RON',946,'Romanian leu','lei',2,1.0000,0,0,NULL), (114,'RSD',941,'Serbian dinar','Дин.',2,1.0000,0,0,NULL), (115,'RUB',643,'Russian ruble','руб',2,1.0000,0,0,NULL), (116,'RWF',646,'Rwandan franc','FRw',0,1.0000,0,0,NULL), (117,'SAR',682,'Saudi riyal','﷼',2,1.0000,0,0,NULL), (118,'SBD',90,'Solomon Islands dollar','$',2,1.0000,0,0,NULL), (119,'SCR',690,'Seychelles rupee','₨',2,1.0000,0,0,NULL), (120,'SDG',938,'Sudanese pound','ج.س.',2,1.0000,0,0,NULL), (121,'SEK',752,'Swedish krona/kronor','kr',2,1.0000,0,1,NULL), (122,'SGD',702,'Singapore dollar','$',2,1.0000,0,0,NULL), (123,'SHP',654,'Saint Helena pound','£',2,1.0000,0,0,NULL), (124,'SLL',694,'Sierra Leonean leone','Le',2,1.0000,0,0,NULL), (125,'SOS',706,'Somali shilling','S',2,1.0000,0,0,NULL), (126,'SRD',968,'Surinamese dollar','$',2,1.0000,0,0,NULL), (127,'SSP',728,'South Sudanese pound','SSP',2,1.0000,0,0,NULL), (128,'STD',678,'São Tomé and Príncipe dobra','Db',2,1.0000,0,0,NULL), (129,'SYP',760,'Syrian pound','£',2,1.0000,0,0,NULL), (130,'SZL',748,'Swazi lilangeni','E',2,1.0000,0,0,NULL), (131,'THB',764,'Thai baht','฿',2,1.0000,0,0,NULL), (132,'TJS',972,'Tajikistani somoni','TJS',2,1.0000,0,0,NULL), (133,'TMT',934,'Turkmenistani manat','T',2,1.0000,0,0,NULL), (134,'TND',788,'Tunisian dinar','DT',3,1.0000,0,0,NULL), (135,'TOP',776,'Tongan paʻanga','T$',2,1.0000,0,0,NULL), (136,'TRY',949,'Turkish lira','₺',2,1.0000,0,0,NULL), (137,'TTD',780,'Trinidad and Tobago dollar','TT$',2,1.0000,0,0,NULL), (138,'TWD',901,'New Taiwan dollar','NT$',2,1.0000,0,0,NULL), (139,'TZS',834,'Tanzanian shilling','TSh',2,1.0000,0,0,NULL), (140,'UAH',980,'Ukrainian hryvnia','₴',2,1.0000,0,0,NULL), (141,'UGX',800,'Ugandan shilling','USh',0,1.0000,0,0,NULL), (142,'USD',840,'United States dollar','$',2,1.0000,0,1,'[]'), (143,'UYU',858,'Uruguayan peso','$U',2,1.0000,0,0,NULL), (144,'UZS',860,'Uzbekistan som','лв',2,1.0000,0,0,NULL), (145,'VEF',937,'Venezuelan bolívar','Bs',2,1.0000,0,0,NULL), (146,'VND',704,'Vietnamese dong','₫',0,1.0000,0,0,NULL), (147,'VUV',548,'Vanuatu vatu','VT',0,1.0000,0,0,NULL), (148,'WST',882,'Samoan tala','WS$',2,1.0000,0,0,NULL), (149,'YER',886,'Yemeni rial','﷼',2,1.0000,0,0,NULL), (150,'ZAR',710,'South African rand','R',2,1.0000,0,0,NULL), (151,'ZMW',967,'Zambian kwacha','ZMW',2,1.0000,0,0,NULL), (152,'XBT',NULL,'Bitcoin','Ƀ',2,1.0000,0,0,'[]')
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'
INSERT INTO `perch2_shop_emails` (`emailID`, `emailTitle`, `emailSlug`, `emailActive`, `emailDynamicFields`, `emailCreated`, `emailUpdated`) VALUES (1,'Order paid','order_paid','1','{\"name\":\"Order paid\",\"subject\":\"Thank you for your order\",\"enabled\":\"1\",\"logo\":null,\"intro\":{\"_flang\":\"markdown\",\"raw\":\"Thank you for placing your order!\",\"processed\":\"<p>Thank you for placing your order!<\\/p>\"},\"signoff\":{\"_flang\":\"markdown\",\"raw\":\"We appreciate your business.\",\"processed\":\"<p>We appreciate your business.<\\/p>\"}}','2016-01-01 00:00:00','2015-09-20 12:01:37')
Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'prismpot.perch2_shop_emails' doesn't exist
INSERT INTO `perch2_shop_orders_meta` (`id`, `metaValue`) VALUES ('last_invoice_number','0')
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'last_invoice_number' for key 'PRIMARY'
INSERT INTO `perch2_shop_order_statuses` (`statusID`, `statusKey`, `statusTitle`, `statusEditable`, `statusIndex`, `statusDynamicFields`, `statusCreated`, `statusUpdated`, `statusDeleted`, `statusActive`) VALUES (1,'created','Created',0,0,'[]','2016-01-01 00:00:00','2016-02-26 04:42:44',NULL,1), (2,'payment_failed','Payment failed',0,50,NULL,'2016-01-01 00:00:00','2016-02-26 04:39:44',NULL,1), (3,'paid','Paid',0,100,'[]','2016-01-01 00:00:00','2016-02-26 12:42:00',NULL,1), (4,'processing','Processing',0,150,NULL,'2016-01-01 00:00:00','2016-02-26 04:39:45',NULL,1), (5,'cancelled','Cancelled',0,200,NULL,'2016-01-01 00:00:00','2016-02-26 04:39:45',NULL,1), (6,'dispatched','Dispatched',0,250,NULL,'2016-01-01 00:00:00','2016-02-26 04:39:45',NULL,1), (7,'returned','Returned',0,300,NULL,'2016-01-01 00:00:00','2016-02-26 04:39:46',NULL,1), (8,'partial_refund','Partial refund',0,350,NULL,'2016-01-01 00:00:00','2016-02-26 04:39:46',NULL,1), (9,'refunded','Refunded',0,400,NULL,'2016-01-01 00:00:00','2016-02-26 04:39:47',NULL,1)
Invalid query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.brands.create' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.brands.edit' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.brands.delete' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.currencies.create' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.currencies.delete' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.currencies.edit' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.customers.create' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.customers.delete' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.customers.edit' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.email.create' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.emails.delete' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.options.create' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.options.edit' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.orders' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.orders.edit' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.products' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.products.create' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.products.edit' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.products.delete' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.promos.create' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.promos.edit' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.promos.delete' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.shippings.create' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.shippings.delete' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.shippings.edit' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.statuses.create' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.statuses.delete' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.statuses.edit' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.taxbands.create' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.taxbands.delete' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.taxbands.edit' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.taxgroups.create' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.taxgroups.delete' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.taxgroups.edit' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.taxlocations.create' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.taxlocations.delete' LIMIT 1
[1] SELECT * FROM perch2_user_privileges WHERE privKey='perch_shop.taxlocations.edit' LIMIT 1
DELETE FROM perch2_settings WHERE settingID='perch_shop_update' AND userID=0 LIMIT 1
INSERT INTO perch2_settings(settingID,settingValue,userID) VALUES('perch_shop_update','1.0.9',0)
Queries: 101
Memory: 3.7988
Perch: 2.8.32, PHP: 7.0.9, MySQL: mysqlnd 5.0.12-dev - 20150407 - $Id: 241ae00989d1995ffcbbf63d579943635faf9972 $, with PDO
Server OS: Linux, apache2handler
Installed apps: content (2.8.32), assets (2.8.32), categories (2.8.32), perch_shop_orders (1.0.9), perch_shop_products (1.0.9), perch_shop (1.0.9), perch_members (1.5)
App runtimes: <?php $apps_list = [ 'content', 'categories', // required for shop app app 'perch_members', 'perch_shop', ];
PERCH_LOGINPATH: /manage
PERCH_PATH: /opt/rh/httpd24/root/var/www/html/manage
PERCH_CORE: /opt/rh/httpd24/root/var/www/html/manage/core
PERCH_RESFILEPATH: /opt/rh/httpd24/root/var/www/html/manage/resources
Image manipulation: GD Imagick
PHP limits: Max upload 14M, Max POST 16M, Memory: 256M, Total max file upload: 14M
F1: 2edba60ed1f613d6dd804feb202456a2
Resource folder writeable: Yes
HTTP_HOST: prismpot.docker
DOCUMENT_ROOT: /opt/rh/httpd24/root/var/www/html
REQUEST_URI: /manage/core/settings/diagnostics/
SCRIPT_NAME: /manage/core/settings/diagnostics/index.php

Removing the DEFAULT '' from all of the mediumtext columns seems to resolve the issue

David Kirk

David Kirk 1 points

  • 4 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

That's the bug, yes. We made some changes to fix things for Windows servers and it caused problems for 5.7. It's fixed in dev so will be in the next update.

Thanks Drew