Hi,

I'm trying start a new site in the "manage sites" screen with Tienda component and it doesn't work. There is a problem with foreign key on the tables. How can i solve it? The following error shows on screen:

When you have a problem to install an extension using the JMS Tool, you can always login in the slave site and use the older method that consists to re-install it into a slave site.

Can you describe more in detail the scenario that you are using and that cause problem to help me reproducing it.

we are using multisite 1.2.46 (patch definition 1.2.52) in a fresh private server with whm and cpanel. We are using Joomla 1.5.22 with Tienda 0.6.2.(fresh install with no data) When we try to reproduce a slave site we get this error:

Create external Table Error query [CREATE TABLE `#__tienda_addresses` ( `address_id` int(11) NOT NULL auto_increment, `user_id` int(11) NOT NULL default '0', `addresstype_id` int(2) default NULL, `address_name` varchar(45) default NULL, `company` varchar(64) default NULL, `title` varchar(32) default NULL, `first_name` varchar(32) default NULL, `last_name` varchar(32) default NULL, `middle_name` varchar(32) default NULL, `phone_1` varchar(32) default NULL, `phone_2` varchar(32) default NULL, `fax` varchar(32) default NULL, `address_1` varchar(64) NOT NULL default '', `address_2` varchar(64) default NULL, `city` varchar(32) NOT NULL default '', `postal_code` varchar(32) default NULL, `country_id` int(11) NOT NULL, `zone_id` int(11) default NULL, `is_default_shipping` tinyint(1) default NULL, `is_default_billing` tinyint(1) default NULL, `is_deleted` tinyint(1) NOT NULL default '0', PRIMARY KEY (`address_id`), KEY `idx_address_id` (`address_id`), KEY `fk_addresses_countries` (`country_id`), KEY `fk_zones_addresses` (`zone_id`), CONSTRAINT `fk_addresses_countries` FOREIGN KEY (`country_id`) REFERENCES `#__tienda_countries` (`country_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_zones_addresses` FOREIGN KEY (`zone_id`) REFERENCES `#__tienda_zones` (`zone_id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_addresses.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_addresses` ( `address_id` int(11) NOT NULL auto_increment, `user_id` int(11) NOT NULL default '0', `addresstype_id` int(2) default NULL, `address_name` varchar(45) default NULL, `company` varchar(64) default NULL, `title` varchar(32) default NULL, `first_name` varchar(32) default NULL, `last_name` varchar(32) default NULL, `middle_name` varchar(32) default NULL, `phone_1` varchar(32) default NULL, `phone_2` varchar(32) default NULL, `fax` varchar(32) default NULL, `address_1` varchar(64) NOT NULL default '', `address_2` varchar(64) default NULL, `city` varchar(32) NOT NULL default '', `postal_code` varchar(32) default NULL, `country_id` int(11) NOT NULL, `zone_id` int(11) default NULL, `is_default_shipping` tinyint(1) default NULL, `is_default_billing` tinyint(1) default NULL, `is_deleted` tinyint(1) NOT NULL default '0', PRIMARY KEY (`address_id`), KEY `idx_address_id` (`address_id`), KEY `fk_addresses_countries` (`country_id`), KEY `fk_zones_addresses` (`zone_id`), CONSTRAINT `fk_addresses_countries` FOREIGN KEY (`country_id`) REFERENCES `perfilmin_tienda_countries` (`country_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_zones_addresses` FOREIGN KEY (`zone_id`) REFERENCES `perfilmin_tienda_zones` (`zone_id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_carts` ( `user_id` int(11) NOT NULL, `session_id` varchar(200) NOT NULL, `product_id` int(11) NOT NULL, `vendor_id` int(11) NOT NULL, `product_attributes` text NOT NULL COMMENT 'A CSV of productattributeoption_id values, always in numerical order', `product_qty` int(11) NOT NULL default '1', `last_updated` timestamp NOT NULL, `cartitem_params` text COMMENT 'Params for the cart item', KEY `idx_user_product` (`user_id`,`product_id`), KEY `fk_carts_products` (`product_id`), CONSTRAINT `fk_carts_products` FOREIGN KEY (`product_id`) REFERENCES `#__tienda_products` (`product_id`) ON DELETE CASCADE ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_carts.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_carts` ( `user_id` int(11) NOT NULL, `session_id` varchar(200) NOT NULL, `product_id` int(11) NOT NULL, `vendor_id` int(11) NOT NULL, `product_attributes` text NOT NULL COMMENT 'A CSV of productattributeoption_id values, always in numerical order', `product_qty` int(11) NOT NULL default '1', `last_updated` timestamp NOT NULL, `cartitem_params` text COMMENT 'Params for the cart item', KEY `idx_user_product` (`user_id`,`product_id`), KEY `fk_carts_products` (`product_id`), CONSTRAINT `fk_carts_products` FOREIGN KEY (`product_id`) REFERENCES `perfilmin_tienda_products` (`product_id`) ON DELETE CASCADE ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_geozones` ( `geozone_id` int(11) NOT NULL auto_increment, `geozone_name` varchar(32) NOT NULL default '', `geozone_description` text, `geozonetype_id` int(11) NOT NULL, `created_date` datetime default NULL, `modified_date` datetime default NULL, PRIMARY KEY (`geozone_id`), KEY `fk_geozonetype` (`geozonetype_id`), CONSTRAINT `fk_geozonetype` FOREIGN KEY (`geozonetype_id`) REFERENCES `#__tienda_geozonetypes` (`geozonetype_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_geozones.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_geozones` ( `geozone_id` int(11) NOT NULL auto_increment, `geozone_name` varchar(32) NOT NULL default '', `geozone_description` text, `geozonetype_id` int(11) NOT NULL, `created_date` datetime default NULL, `modified_date` datetime default NULL, PRIMARY KEY (`geozone_id`), KEY `fk_geozonetype` (`geozonetype_id`), CONSTRAINT `fk_geozonetype` FOREIGN KEY (`geozonetype_id`) REFERENCES `perfilmin_tienda_geozonetypes` (`geozonetype_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_orderhistory` ( `order_history_id` int(11) NOT NULL auto_increment, `order_id` int(11) NOT NULL default '0', `order_state_id` int(11) NOT NULL, `date_added` datetime NOT NULL, `notify_customer` int(1) default '0', `comments` text, PRIMARY KEY (`order_history_id`), KEY `fk_OrderState_OrderHistory` (`order_state_id`), KEY `fk_Orders_OrderHistory` (`order_id`), CONSTRAINT `fk_OrderState_OrderHistory` FOREIGN KEY (`order_state_id`) REFERENCES `#__tienda_orderstates` (`order_state_id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `fk_Orders_OrderHistory` FOREIGN KEY (`order_id`) REFERENCES `#__tienda_orders` (`order_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_orderhistory.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_orderhistory` ( `order_history_id` int(11) NOT NULL auto_increment, `order_id` int(11) NOT NULL default '0', `order_state_id` int(11) NOT NULL, `date_added` datetime NOT NULL, `notify_customer` int(1) default '0', `comments` text, PRIMARY KEY (`order_history_id`), KEY `fk_OrderState_OrderHistory` (`order_state_id`), KEY `fk_Orders_OrderHistory` (`order_id`), CONSTRAINT `fk_OrderState_OrderHistory` FOREIGN KEY (`order_state_id`) REFERENCES `perfilmin_tienda_orderstates` (`order_state_id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `fk_Orders_OrderHistory` FOREIGN KEY (`order_id`) REFERENCES `perfilmin_tienda_orders` (`order_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_orderinfo` ( `orderinfo_id` int(11) NOT NULL auto_increment, `order_id` int(11) NOT NULL default '0', `billing_company` varchar(64) default NULL, `billing_last_name` varchar(32) default NULL, `billing_first_name` varchar(32) default NULL, `billing_middle_name` varchar(32) default NULL, `billing_phone_1` varchar(32) default NULL, `billing_phone_2` varchar(32) default NULL, `billing_fax` varchar(32) default NULL, `billing_address_1` varchar(64) NOT NULL default '', `billing_address_2` varchar(64) default NULL, `billing_city` varchar(32) NOT NULL default '', `billing_zone_name` varchar(32) NOT NULL default '', `billing_country_name` varchar(64) NOT NULL default '', `billing_zone_id` int(11) NOT NULL default '0', `billing_country_id` int(11) NOT NULL default '0', `billing_postal_code` varchar(32) NOT NULL default '', `shipping_company` varchar(64) default NULL, `shipping_last_name` varchar(32) default NULL, `shipping_first_name` varchar(32) default NULL, `shipping_middle_name` varchar(32) default NULL, `shipping_phone_1` varchar(32) default NULL, `shipping_phone_2` varchar(32) default NULL, `shipping_fax` varchar(32) default NULL, `shipping_address_1` varchar(64) NOT NULL default '', `shipping_address_2` varchar(64) default NULL, `shipping_city` varchar(32) NOT NULL default '', `shipping_zone_name` varchar(32) NOT NULL default '', `shipping_country_name` varchar(64) NOT NULL default '', `shipping_zone_id` int(11) NOT NULL default '0', `shipping_country_id` int(11) NOT NULL default '0', `shipping_postal_code` varchar(32) NOT NULL default '', `user_email` varchar(255) NOT NULL default '', `zone_id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', PRIMARY KEY (`orderinfo_id`), KEY `idx_orderinfo_order_id` (`order_id`), KEY `fk_Orders_OrderInfo` (`order_id`), CONSTRAINT `fk_Orders_OrderInfo` FOREIGN KEY (`order_id`) REFERENCES `#__tienda_orders` (`order_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_orderinfo.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_orderinfo` ( `orderinfo_id` int(11) NOT NULL auto_increment, `order_id` int(11) NOT NULL default '0', `billing_company` varchar(64) default NULL, `billing_last_name` varchar(32) default NULL, `billing_first_name` varchar(32) default NULL, `billing_middle_name` varchar(32) default NULL, `billing_phone_1` varchar(32) default NULL, `billing_phone_2` varchar(32) default NULL, `billing_fax` varchar(32) default NULL, `billing_address_1` varchar(64) NOT NULL default '', `billing_address_2` varchar(64) default NULL, `billing_city` varchar(32) NOT NULL default '', `billing_zone_name` varchar(32) NOT NULL default '', `billing_country_name` varchar(64) NOT NULL default '', `billing_zone_id` int(11) NOT NULL default '0', `billing_country_id` int(11) NOT NULL default '0', `billing_postal_code` varchar(32) NOT NULL default '', `shipping_company` varchar(64) default NULL, `shipping_last_name` varchar(32) default NULL, `shipping_first_name` varchar(32) default NULL, `shipping_middle_name` varchar(32) default NULL, `shipping_phone_1` varchar(32) default NULL, `shipping_phone_2` varchar(32) default NULL, `shipping_fax` varchar(32) default NULL, `shipping_address_1` varchar(64) NOT NULL default '', `shipping_address_2` varchar(64) default NULL, `shipping_city` varchar(32) NOT NULL default '', `shipping_zone_name` varchar(32) NOT NULL default '', `shipping_country_name` varchar(64) NOT NULL default '', `shipping_zone_id` int(11) NOT NULL default '0', `shipping_country_id` int(11) NOT NULL default '0', `shipping_postal_code` varchar(32) NOT NULL default '', `user_email` varchar(255) NOT NULL default '', `zone_id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', PRIMARY KEY (`orderinfo_id`), KEY `idx_orderinfo_order_id` (`order_id`), KEY `fk_Orders_OrderInfo` (`order_id`), CONSTRAINT `fk_Orders_OrderInfo` FOREIGN KEY (`order_id`) REFERENCES `perfilmin_tienda_orders` (`order_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_orderitems` ( `orderitem_id` int(11) NOT NULL auto_increment, `order_id` int(11) default NULL, `vendor_id` int(11) default NULL, `product_id` int(11) default NULL, `orderitem_attributes` text NOT NULL COMMENT 'A CSV of productattributeoption_id values, always in numerical order', `orderitem_attribute_names` text NOT NULL COMMENT 'A CSV of productattributeoption_name values', `orderitem_sku` varchar(64) NOT NULL default '', `orderitem_name` varchar(64) NOT NULL default '', `orderitem_quantity` int(11) default NULL, `orderitem_price` decimal(15,5) NOT NULL default '0.00000' COMMENT 'Base price of the item', `orderitem_attributes_price` varchar(64) NOT NULL COMMENT 'The increase or decrease in price per item as a result of attributes. Includes + or - sign', `orderitem_discount` decimal(15,5) NOT NULL default '0.00000' COMMENT 'Coupon discount applied to each item', `orderitem_final_price` decimal(15,5) NOT NULL default '0.00000' COMMENT 'Price of item inclusive of quantity, attributes, tax, and shipping', `orderitem_tax` decimal(15,5) NOT NULL default '0.00000', `orderitem_shipping` decimal(12,5) NOT NULL default '0.00000', `orderitem_shipping_tax` decimal(12,5) NOT NULL default '0.00000', `orderitem_status` char(1) default NULL, `modified_date` datetime NOT NULL COMMENT 'GMT', `orderitem_recurs` tinyint(1) NOT NULL COMMENT 'Do any payments for this orderitem recur?', `recurring_price` decimal(15,5) NOT NULL default '0.00000' COMMENT 'Recurring price of the item', `recurring_payments` int(11) NOT NULL COMMENT 'How many recurring payments?', `recurring_period_interval` int(3) NOT NULL COMMENT 'How many period-units between payments?', `recurring_period_unit` varchar(1) NOT NULL COMMENT 'D, W, M, Y = Day, Week, Month, Year', `recurring_trial` tinyint(1) NOT NULL COMMENT 'Is there a trial period?', `recurring_trial_period_interval` int(3) NOT NULL COMMENT 'How many trial-period-units before payments begin?', `recurring_trial_period_unit` varchar(1) NOT NULL COMMENT 'D, W, M, Y = Day, Week, Month, Year', `recurring_trial_price` decimal(12,5) NOT NULL COMMENT 'Cost of trial period', `orderitem_subscription` tinyint(1) NOT NULL COMMENT 'Orderitem creates a subscription?', `subscription_lifetime` tinyint(1) NOT NULL COMMENT 'Lifetime subscription?', `subscription_period_interval` int(3) NOT NULL COMMENT 'How many period-units does the subscription last?', `subscription_period_unit` varchar(1) NOT NULL COMMENT 'D, W, M, Y = Day, Week, Month, Year', `orderitem_params` text COMMENT 'Params for the orderitem', PRIMARY KEY (`orderitem_id`), KEY `idx_order_item_order_id` (`order_id`), KEY `idx_order_item_vendor_id` (`vendor_id`), KEY `fk_Order_OrderItem` (`order_id`), KEY `fk_Product_OrderItem` (`product_id`), CONSTRAINT `fk_Order_OrderItem` FOREIGN KEY (`order_id`) REFERENCES `#__tienda_orders` (`order_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_Product_OrderItem` FOREIGN KEY (`product_id`) REFERENCES `#__tienda_products` (`product_id`) ON DELETE NO ACTION ON UPDATE CASCADE ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_orderitems.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_orderitems` ( `orderitem_id` int(11) NOT NULL auto_increment, `order_id` int(11) default NULL, `vendor_id` int(11) default NULL, `product_id` int(11) default NULL, `orderitem_attributes` text NOT NULL COMMENT 'A CSV of productattributeoption_id values, always in numerical order', `orderitem_attribute_names` text NOT NULL COMMENT 'A CSV of productattributeoption_name values', `orderitem_sku` varchar(64) NOT NULL default '', `orderitem_name` varchar(64) NOT NULL default '', `orderitem_quantity` int(11) default NULL, `orderitem_price` decimal(15,5) NOT NULL default '0.00000' COMMENT 'Base price of the item', `orderitem_attributes_price` varchar(64) NOT NULL COMMENT 'The increase or decrease in price per item as a result of attributes. Includes + or - sign', `orderitem_discount` decimal(15,5) NOT NULL default '0.00000' COMMENT 'Coupon discount applied to each item', `orderitem_final_price` decimal(15,5) NOT NULL default '0.00000' COMMENT 'Price of item inclusive of quantity, attributes, tax, and shipping', `orderitem_tax` decimal(15,5) NOT NULL default '0.00000', `orderitem_shipping` decimal(12,5) NOT NULL default '0.00000', `orderitem_shipping_tax` decimal(12,5) NOT NULL default '0.00000', `orderitem_status` char(1) default NULL, `modified_date` datetime NOT NULL COMMENT 'GMT', `orderitem_recurs` tinyint(1) NOT NULL COMMENT 'Do any payments for this orderitem recur?', `recurring_price` decimal(15,5) NOT NULL default '0.00000' COMMENT 'Recurring price of the item', `recurring_payments` int(11) NOT NULL COMMENT 'How many recurring payments?', `recurring_period_interval` int(3) NOT NULL COMMENT 'How many period-units between payments?', `recurring_period_unit` varchar(1) NOT NULL COMMENT 'D, W, M, Y = Day, Week, Month, Year', `recurring_trial` tinyint(1) NOT NULL COMMENT 'Is there a trial period?', `recurring_trial_period_interval` int(3) NOT NULL COMMENT 'How many trial-period-units before payments begin?', `recurring_trial_period_unit` varchar(1) NOT NULL COMMENT 'D, W, M, Y = Day, Week, Month, Year', `recurring_trial_price` decimal(12,5) NOT NULL COMMENT 'Cost of trial period', `orderitem_subscription` tinyint(1) NOT NULL COMMENT 'Orderitem creates a subscription?', `subscription_lifetime` tinyint(1) NOT NULL COMMENT 'Lifetime subscription?', `subscription_period_interval` int(3) NOT NULL COMMENT 'How many period-units does the subscription last?', `subscription_period_unit` varchar(1) NOT NULL COMMENT 'D, W, M, Y = Day, Week, Month, Year', `orderitem_params` text COMMENT 'Params for the orderitem', PRIMARY KEY (`orderitem_id`), KEY `idx_order_item_order_id` (`order_id`), KEY `idx_order_item_vendor_id` (`vendor_id`), KEY `fk_Order_OrderItem` (`order_id`), KEY `fk_Product_OrderItem` (`product_id`), CONSTRAINT `fk_Order_OrderItem` FOREIGN KEY (`order_id`) REFERENCES `perfilmin_tienda_orders` (`order_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_Product_OrderItem` FOREIGN KEY (`product_id`) REFERENCES `perfilmin_tienda_products` (`product_id`) ON DELETE NO ACTION ON UPDATE CASCADE ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_orderpayments` ( `orderpayment_id` int(11) NOT NULL auto_increment, `order_id` int(11) NOT NULL default '0', `orderpayment_type` varchar(255) NOT NULL default '' COMMENT 'Element name of payment plugin', `orderpayment_amount` decimal(15,5) default '0.00000', `transaction_id` varchar(255) NOT NULL default '', `transaction_status` varchar(255) NOT NULL default '', `transaction_details` text NOT NULL, `created_date` datetime NOT NULL COMMENT 'GMT', PRIMARY KEY (`orderpayment_id`), KEY `idx_order_payment_order_id` (`order_id`), KEY `fk_Orders_OrderPayment` (`order_id`), CONSTRAINT `fk_Orders_OrderPayment` FOREIGN KEY (`order_id`) REFERENCES `#__tienda_orders` (`order_id`) ON DELETE NO ACTION ON UPDATE CASCADE ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_orderpayments.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_orderpayments` ( `orderpayment_id` int(11) NOT NULL auto_increment, `order_id` int(11) NOT NULL default '0', `orderpayment_type` varchar(255) NOT NULL default '' COMMENT 'Element name of payment plugin', `orderpayment_amount` decimal(15,5) default '0.00000', `transaction_id` varchar(255) NOT NULL default '', `transaction_status` varchar(255) NOT NULL default '', `transaction_details` text NOT NULL, `created_date` datetime NOT NULL COMMENT 'GMT', PRIMARY KEY (`orderpayment_id`), KEY `idx_order_payment_order_id` (`order_id`), KEY `fk_Orders_OrderPayment` (`order_id`), CONSTRAINT `fk_Orders_OrderPayment` FOREIGN KEY (`order_id`) REFERENCES `perfilmin_tienda_orders` (`order_id`) ON DELETE NO ACTION ON UPDATE CASCADE ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_orders` ( `order_id` int(11) NOT NULL auto_increment, `user_id` int(11) NOT NULL default '0', `shipping_method_id` int(11) NOT NULL default '0', `order_number` varchar(255) default '' COMMENT 'The Invoice Number that Can be Set by Admins', `order_total` decimal(15,5) NOT NULL default '0.00000', `order_subtotal` decimal(15,5) default '0.00000', `order_tax` decimal(10,2) default '0.00', `order_shipping` decimal(10,2) default '0.00', `order_shipping_tax` decimal(10,2) default '0.00', `order_discount` decimal(12,2) NOT NULL default '0.00', `order_currency` text NOT NULL COMMENT 'Stores a JParameter formatted version of the current currency. Used to maintain the order integrity', `currency_id` int(11) default NULL, `order_state_id` int(11) default NULL, `created_date` datetime default NULL COMMENT 'GMT', `modified_date` datetime default NULL COMMENT 'GMT', `customer_note` text NOT NULL, `ip_address` varchar(15) NOT NULL, `order_ships` tinyint(1) NOT NULL COMMENT 'Does this order require shipping?', `order_recurs` tinyint(1) NOT NULL COMMENT 'Does any amount from this order recur?', `recurring_amount` decimal(12,5) NOT NULL COMMENT 'The amount of the recurring charge', `recurring_payments` int(11) NOT NULL COMMENT 'How many recurring payments?', `recurring_period_interval` int(3) NOT NULL COMMENT 'How many period-units between payments?', `recurring_period_unit` varchar(1) NOT NULL COMMENT 'D, W, M, Y = Day, Week, Month, Year', `recurring_trial` tinyint(1) NOT NULL COMMENT 'Is there a trial period?', `recurring_trial_period_interval` int(3) NOT NULL COMMENT 'How many trial-period-units before regular payments begin?', `recurring_trial_period_unit` varchar(1) NOT NULL COMMENT 'D, W, M, Y = Day, Week, Month, Year', `recurring_trial_price` decimal(12,5) NOT NULL COMMENT 'Cost of trial period', `completed_tasks` tinyint(1) NOT NULL default '0' COMMENT 'Were the OrderCompleted tasks executed?', `quantities_updated` tinyint(1) NOT NULL default '0' COMMENT 'Were the Product Quantities updated?', PRIMARY KEY (`order_id`), KEY `idx_orders_user_id` (`user_id`), KEY `fk_OrderState_Order` (`order_state_id`), KEY `fk_currencies_orders` (`currency_id`), CONSTRAINT `fk_currencies_orders` FOREIGN KEY (`currency_id`) REFERENCES `#__tienda_currencies` (`currency_id`) ON UPDATE CASCADE, CONSTRAINT `fk_OrderState_Order` FOREIGN KEY (`order_state_id`) REFERENCES `#__tienda_orderstates` (`order_state_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_orders.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_orders` ( `order_id` int(11) NOT NULL auto_increment, `user_id` int(11) NOT NULL default '0', `shipping_method_id` int(11) NOT NULL default '0', `order_number` varchar(255) default '' COMMENT 'The Invoice Number that Can be Set by Admins', `order_total` decimal(15,5) NOT NULL default '0.00000', `order_subtotal` decimal(15,5) default '0.00000', `order_tax` decimal(10,2) default '0.00', `order_shipping` decimal(10,2) default '0.00', `order_shipping_tax` decimal(10,2) default '0.00', `order_discount` decimal(12,2) NOT NULL default '0.00', `order_currency` text NOT NULL COMMENT 'Stores a JParameter formatted version of the current currency. Used to maintain the order integrity', `currency_id` int(11) default NULL, `order_state_id` int(11) default NULL, `created_date` datetime default NULL COMMENT 'GMT', `modified_date` datetime default NULL COMMENT 'GMT', `customer_note` text NOT NULL, `ip_address` varchar(15) NOT NULL, `order_ships` tinyint(1) NOT NULL COMMENT 'Does this order require shipping?', `order_recurs` tinyint(1) NOT NULL COMMENT 'Does any amount from this order recur?', `recurring_amount` decimal(12,5) NOT NULL COMMENT 'The amount of the recurring charge', `recurring_payments` int(11) NOT NULL COMMENT 'How many recurring payments?', `recurring_period_interval` int(3) NOT NULL COMMENT 'How many period-units between payments?', `recurring_period_unit` varchar(1) NOT NULL COMMENT 'D, W, M, Y = Day, Week, Month, Year', `recurring_trial` tinyint(1) NOT NULL COMMENT 'Is there a trial period?', `recurring_trial_period_interval` int(3) NOT NULL COMMENT 'How many trial-period-units before regular payments begin?', `recurring_trial_period_unit` varchar(1) NOT NULL COMMENT 'D, W, M, Y = Day, Week, Month, Year', `recurring_trial_price` decimal(12,5) NOT NULL COMMENT 'Cost of trial period', `completed_tasks` tinyint(1) NOT NULL default '0' COMMENT 'Were the OrderCompleted tasks executed?', `quantities_updated` tinyint(1) NOT NULL default '0' COMMENT 'Were the Product Quantities updated?', PRIMARY KEY (`order_id`), KEY `idx_orders_user_id` (`user_id`), KEY `fk_OrderState_Order` (`order_state_id`), KEY `fk_currencies_orders` (`currency_id`), CONSTRAINT `fk_currencies_orders` FOREIGN KEY (`currency_id`) REFERENCES `perfilmin_tienda_currencies` (`currency_id`) ON UPDATE CASCADE, CONSTRAINT `fk_OrderState_Order` FOREIGN KEY (`order_state_id`) REFERENCES `perfilmin_tienda_orderstates` (`order_state_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_productcategoryxref` ( `category_id` int(11) NOT NULL default '0', `product_id` int(11) NOT NULL default '0', KEY `idx_product_category_xref_category_id` (`category_id`), KEY `idx_product_category_xref_product_id` (`product_id`), KEY `fk_Product_ProductCategory` (`product_id`), KEY `fk_Category_ProductCategory` (`category_id`), CONSTRAINT `fk_Product_ProductCategory` FOREIGN KEY (`product_id`) REFERENCES `#__tienda_products` (`product_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_Category_ProductCategory` FOREIGN KEY (`category_id`) REFERENCES `#__tienda_categories` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_productcategoryxref.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_productcategoryxref` ( `category_id` int(11) NOT NULL default '0', `product_id` int(11) NOT NULL default '0', KEY `idx_product_category_xref_category_id` (`category_id`), KEY `idx_product_category_xref_product_id` (`product_id`), KEY `fk_Product_ProductCategory` (`product_id`), KEY `fk_Category_ProductCategory` (`category_id`), CONSTRAINT `fk_Product_ProductCategory` FOREIGN KEY (`product_id`) REFERENCES `perfilmin_tienda_products` (`product_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_Category_ProductCategory` FOREIGN KEY (`category_id`) REFERENCES `perfilmin_tienda_categories` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_productdownloadlogs` ( `productdownloadlog_id` int(11) NOT NULL auto_increment, `productfile_id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `productdownloadlog_datetime` datetime NOT NULL COMMENT 'GMT Only', `productdownloadlog_ipaddress` varchar(15) NOT NULL default '', PRIMARY KEY (`productdownloadlog_id`), KEY `fk_ProductFile_ProductDownloadLog` (`productfile_id`), CONSTRAINT `fk_ProductFile_ProductDownloadLog` FOREIGN KEY (`productfile_id`) REFERENCES `#__tienda_productfiles` (`productfile_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_productdownloadlogs.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_productdownloadlogs` ( `productdownloadlog_id` int(11) NOT NULL auto_increment, `productfile_id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `productdownloadlog_datetime` datetime NOT NULL COMMENT 'GMT Only', `productdownloadlog_ipaddress` varchar(15) NOT NULL default '', PRIMARY KEY (`productdownloadlog_id`), KEY `fk_ProductFile_ProductDownloadLog` (`productfile_id`), CONSTRAINT `fk_ProductFile_ProductDownloadLog` FOREIGN KEY (`productfile_id`) REFERENCES `perfilmin_tienda_productfiles` (`productfile_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_productdownloads` ( `productdownload_id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL default '0', `productfile_id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `order_id` int(11) NOT NULL default '0', `productdownload_startdate` datetime NOT NULL COMMENT 'GMT Only', `productdownload_enddate` datetime NOT NULL COMMENT 'GMT Only', `productdownload_max` int(11) NOT NULL default '-1', PRIMARY KEY (`productdownload_id`), KEY `fk_Product_ProductDownload` (`product_id`), CONSTRAINT `fk_Product_ProductDownload` FOREIGN KEY (`product_id`) REFERENCES `#__tienda_products` (`product_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_productdownloads.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_productdownloads` ( `productdownload_id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL default '0', `productfile_id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `order_id` int(11) NOT NULL default '0', `productdownload_startdate` datetime NOT NULL COMMENT 'GMT Only', `productdownload_enddate` datetime NOT NULL COMMENT 'GMT Only', `productdownload_max` int(11) NOT NULL default '-1', PRIMARY KEY (`productdownload_id`), KEY `fk_Product_ProductDownload` (`product_id`), CONSTRAINT `fk_Product_ProductDownload` FOREIGN KEY (`product_id`) REFERENCES `perfilmin_tienda_products` (`product_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_productfiles` ( `productfile_id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL default '0', `purchase_required` tinyint(1) NOT NULL, `productfile_name` varchar(128) NOT NULL default '', `productfile_path` varchar(255) NOT NULL, `productfile_description` mediumtext NOT NULL, `productfile_extension` varchar(6) NOT NULL default '', `productfile_mimetype` varchar(64) NOT NULL default '', `productfile_url` varchar(255) NOT NULL default '', `productfile_enabled` tinyint(1) NOT NULL default '0', `ordering` int(11) NOT NULL, `created_date` datetime NOT NULL COMMENT 'GMT Only', `modified_date` datetime NOT NULL COMMENT 'GMT Only', `max_download` int(11) default '-1', PRIMARY KEY (`productfile_id`), KEY `fk_Product_ProductFiles` (`product_id`), CONSTRAINT `fk_Product_ProductFiles` FOREIGN KEY (`product_id`) REFERENCES `#__tienda_products` (`product_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_productfiles.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_productfiles` ( `productfile_id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL default '0', `purchase_required` tinyint(1) NOT NULL, `productfile_name` varchar(128) NOT NULL default '', `productfile_path` varchar(255) NOT NULL, `productfile_description` mediumtext NOT NULL, `productfile_extension` varchar(6) NOT NULL default '', `productfile_mimetype` varchar(64) NOT NULL default '', `productfile_url` varchar(255) NOT NULL default '', `productfile_enabled` tinyint(1) NOT NULL default '0', `ordering` int(11) NOT NULL, `created_date` datetime NOT NULL COMMENT 'GMT Only', `modified_date` datetime NOT NULL COMMENT 'GMT Only', `max_download` int(11) default '-1', PRIMARY KEY (`productfile_id`), KEY `fk_Product_ProductFiles` (`product_id`), CONSTRAINT `fk_Product_ProductFiles` FOREIGN KEY (`product_id`) REFERENCES `perfilmin_tienda_products` (`product_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_productprices` ( `product_price_id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL default '0', `product_price` decimal(12,5) default '0.00000', `product_price_startdate` datetime NOT NULL COMMENT 'GMT Only', `product_price_enddate` datetime NOT NULL COMMENT 'GMT Only', `created_date` datetime NOT NULL COMMENT 'GMT Only', `modified_date` datetime NOT NULL COMMENT 'GMT Only', `group_id` int(11) default '0', `price_quantity_start` int(11) unsigned NOT NULL default '0', `price_quantity_end` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`product_price_id`), KEY `idx_product_price_product_id` (`product_id`), KEY `idx_product_price_group_id` (`group_id`), KEY `fk_Product_ProductPrice` (`product_id`), CONSTRAINT `fk_Product_ProductPrices` FOREIGN KEY (`product_id`) REFERENCES `#__tienda_products` (`product_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_productprices.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_productprices` ( `product_price_id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL default '0', `product_price` decimal(12,5) default '0.00000', `product_price_startdate` datetime NOT NULL COMMENT 'GMT Only', `product_price_enddate` datetime NOT NULL COMMENT 'GMT Only', `created_date` datetime NOT NULL COMMENT 'GMT Only', `modified_date` datetime NOT NULL COMMENT 'GMT Only', `group_id` int(11) default '0', `price_quantity_start` int(11) unsigned NOT NULL default '0', `price_quantity_end` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`product_price_id`), KEY `idx_product_price_product_id` (`product_id`), KEY `idx_product_price_group_id` (`group_id`), KEY `fk_Product_ProductPrice` (`product_id`), CONSTRAINT `fk_Product_ProductPrices` FOREIGN KEY (`product_id`) REFERENCES `perfilmin_tienda_products` (`product_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_productrelations` ( `productrelation_id` int(11) NOT NULL auto_increment, `product_id_from` int(11) NOT NULL default '0', `product_id_to` int(11) NOT NULL default '0', `relation_type` varchar(64) NOT NULL default '', PRIMARY KEY (`productrelation_id`), KEY `fk_Product_ProductRelationsA` (`product_id_from`), KEY `fk_Product_ProductRelationsB` (`product_id_to`), CONSTRAINT `fk_Product_ProductRelationsA` FOREIGN KEY (`product_id_from`) REFERENCES `#__tienda_products` (`product_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_Product_ProductRelationsB` FOREIGN KEY (`product_id_to`) REFERENCES `#__tienda_products` (`product_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_productrelations.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_productrelations` ( `productrelation_id` int(11) NOT NULL auto_increment, `product_id_from` int(11) NOT NULL default '0', `product_id_to` int(11) NOT NULL default '0', `relation_type` varchar(64) NOT NULL default '', PRIMARY KEY (`productrelation_id`), KEY `fk_Product_ProductRelationsA` (`product_id_from`), KEY `fk_Product_ProductRelationsB` (`product_id_to`), CONSTRAINT `fk_Product_ProductRelationsA` FOREIGN KEY (`product_id_from`) REFERENCES `perfilmin_tienda_products` (`product_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_Product_ProductRelationsB` FOREIGN KEY (`product_id_to`) REFERENCES `perfilmin_tienda_products` (`product_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_products` ( `product_id` int(11) NOT NULL auto_increment, `vendor_id` int(11) NOT NULL default '0', `manufacturer_id` int(11) NOT NULL default '0', `product_description` text, `product_description_short` text, `product_full_image` varchar(255) default NULL, `product_weight` decimal(10,4) default '0.0000', `product_length` decimal(10,4) default '0.0000', `product_width` decimal(10,4) default '0.0000', `product_height` decimal(10,4) default '0.0000', `product_url` varchar(255) default NULL, `product_sku` varchar(64) default NULL, `product_model` varchar(255) default NULL, `product_check_inventory` tinyint(1) default '0' COMMENT 'Check Inventory for this Product?', `product_ships` tinyint(1) default '0' COMMENT 'Product Requires Shipping?', `ordering` int(11) NOT NULL, `created_date` datetime NOT NULL COMMENT 'GMT Only', `modified_date` datetime NOT NULL COMMENT 'GMT Only', `publish_date` datetime NOT NULL COMMENT 'GMT Only', `unpublish_date` datetime NOT NULL COMMENT 'GMT Only', `product_name` varchar(255) NOT NULL default '', `product_alias` varchar(255) NOT NULL, `tax_class_id` int(11) default NULL, `product_enabled` tinyint(1) NOT NULL default '1', `product_notforsale` tinyint(1) NOT NULL default '0', `quantity_restriction` tinyint(1) NOT NULL default '0', `quantity_min` int(11) default NULL, `quantity_max` int(11) default NULL, `quantity_step` int(11) default NULL, `product_images_path` varchar(255) NOT NULL, `product_files_path` varchar(255) NOT NULL, `product_recurs` tinyint(1) NOT NULL COMMENT 'Do payments for this product recur?', `recurring_payments` int(11) NOT NULL COMMENT 'How many recurring payments?', `recurring_period_interval` int(3) NOT NULL COMMENT 'How many period-units between payments?', `recurring_period_unit` varchar(1) NOT NULL COMMENT 'D, W, M, Y = Day, Week, Month, Year', `recurring_trial` tinyint(1) NOT NULL COMMENT 'Is there a trial period?', `recurring_trial_period_interval` int(3) NOT NULL COMMENT 'How many trial-period-units before payments begin?', `recurring_trial_period_unit` varchar(1) NOT NULL COMMENT 'D, W, M, Y = Day, Week, Month, Year', `recurring_trial_price` decimal(12,5) NOT NULL COMMENT 'Cost of trial period', `product_params` text, `product_layout` varchar(255) default '' COMMENT 'The layout file for this product', `product_subscription` tinyint(1) NOT NULL COMMENT 'Product creates a subscription?', `subscription_lifetime` tinyint(1) NOT NULL COMMENT 'Lifetime subscription?', `subscription_period_interval` int(3) NOT NULL COMMENT 'How many period-units does the subscription last?', `subscription_period_unit` varchar(1) NOT NULL COMMENT 'D, W, M, Y = Day, Week, Month, Year', `product_sql` text NOT NULL COMMENT 'SQL queries to be executed after the product is purchased', `product_listprice` decimal(15,5) NOT NULL default '0.00000', `product_listprice_enabled` tinyint(1) NOT NULL default '0' COMMENT 'Display the product_listprice field?', `product_rating` decimal(15,5) NOT NULL default '0.00000' COMMENT 'The overall rating for the product. Is x out of 5', `product_comments` int(11) NOT NULL default '0' COMMENT 'The number of enabled comments the product has', `product_article` int(11) NOT NULL, PRIMARY KEY (`product_id`), KEY `idx_product_vendor_id` (`vendor_id`), KEY `idx_product_name` (`product_name`), KEY `fk_taxclasses_products` (`tax_class_id`), CONSTRAINT `fk_taxclasses_products` FOREIGN KEY (`tax_class_id`) REFERENCES `#__tienda_taxclasses` (`tax_class_id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_products.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_products` ( `product_id` int(11) NOT NULL auto_increment, `vendor_id` int(11) NOT NULL default '0', `manufacturer_id` int(11) NOT NULL default '0', `product_description` text, `product_description_short` text, `product_full_image` varchar(255) default NULL, `product_weight` decimal(10,4) default '0.0000', `product_length` decimal(10,4) default '0.0000', `product_width` decimal(10,4) default '0.0000', `product_height` decimal(10,4) default '0.0000', `product_url` varchar(255) default NULL, `product_sku` varchar(64) default NULL, `product_model` varchar(255) default NULL, `product_check_inventory` tinyint(1) default '0' COMMENT 'Check Inventory for this Product?', `product_ships` tinyint(1) default '0' COMMENT 'Product Requires Shipping?', `ordering` int(11) NOT NULL, `created_date` datetime NOT NULL COMMENT 'GMT Only', `modified_date` datetime NOT NULL COMMENT 'GMT Only', `publish_date` datetime NOT NULL COMMENT 'GMT Only', `unpublish_date` datetime NOT NULL COMMENT 'GMT Only', `product_name` varchar(255) NOT NULL default '', `product_alias` varchar(255) NOT NULL, `tax_class_id` int(11) default NULL, `product_enabled` tinyint(1) NOT NULL default '1', `product_notforsale` tinyint(1) NOT NULL default '0', `quantity_restriction` tinyint(1) NOT NULL default '0', `quantity_min` int(11) default NULL, `quantity_max` int(11) default NULL, `quantity_step` int(11) default NULL, `product_images_path` varchar(255) NOT NULL, `product_files_path` varchar(255) NOT NULL, `product_recurs` tinyint(1) NOT NULL COMMENT 'Do payments for this product recur?', `recurring_payments` int(11) NOT NULL COMMENT 'How many recurring payments?', `recurring_period_interval` int(3) NOT NULL COMMENT 'How many period-units between payments?', `recurring_period_unit` varchar(1) NOT NULL COMMENT 'D, W, M, Y = Day, Week, Month, Year', `recurring_trial` tinyint(1) NOT NULL COMMENT 'Is there a trial period?', `recurring_trial_period_interval` int(3) NOT NULL COMMENT 'How many trial-period-units before payments begin?', `recurring_trial_period_unit` varchar(1) NOT NULL COMMENT 'D, W, M, Y = Day, Week, Month, Year', `recurring_trial_price` decimal(12,5) NOT NULL COMMENT 'Cost of trial period', `product_params` text, `product_layout` varchar(255) default '' COMMENT 'The layout file for this product', `product_subscription` tinyint(1) NOT NULL COMMENT 'Product creates a subscription?', `subscription_lifetime` tinyint(1) NOT NULL COMMENT 'Lifetime subscription?', `subscription_period_interval` int(3) NOT NULL COMMENT 'How many period-units does the subscription last?', `subscription_period_unit` varchar(1) NOT NULL COMMENT 'D, W, M, Y = Day, Week, Month, Year', `product_sql` text NOT NULL COMMENT 'SQL queries to be executed after the product is purchased', `product_listprice` decimal(15,5) NOT NULL default '0.00000', `product_listprice_enabled` tinyint(1) NOT NULL default '0' COMMENT 'Display the product_listprice field?', `product_rating` decimal(15,5) NOT NULL default '0.00000' COMMENT 'The overall rating for the product. Is x out of 5', `product_comments` int(11) NOT NULL default '0' COMMENT 'The number of enabled comments the product has', `product_article` int(11) NOT NULL, PRIMARY KEY (`product_id`), KEY `idx_product_vendor_id` (`vendor_id`), KEY `idx_product_name` (`product_name`), KEY `fk_taxclasses_products` (`tax_class_id`), CONSTRAINT `fk_taxclasses_products` FOREIGN KEY (`tax_class_id`) REFERENCES `perfilmin_tienda_taxclasses` (`tax_class_id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_shippingmethods` ( `shipping_method_id` int(11) NOT NULL auto_increment, `shipping_method_name` varchar(255) NOT NULL, `tax_class_id` int(11) NOT NULL, `shipping_method_enabled` tinyint(1) NOT NULL, `shipping_method_type` tinyint(1) NOT NULL COMMENT '0=weight-based, 1=per-item, 2=per-order', `subtotal_minimum` decimal(12,5) NOT NULL COMMENT 'Minimum Subtotal required for shipping method to be active', PRIMARY KEY (`shipping_method_id`), KEY `fk_taxclasses_shippingmethods` (`tax_class_id`), CONSTRAINT `fk_taxclass_shippingmethods` FOREIGN KEY (`tax_class_id`) REFERENCES `#__tienda_taxclasses` (`tax_class_id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_shippingmethods.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_shippingmethods` ( `shipping_method_id` int(11) NOT NULL auto_increment, `shipping_method_name` varchar(255) NOT NULL, `tax_class_id` int(11) NOT NULL, `shipping_method_enabled` tinyint(1) NOT NULL, `shipping_method_type` tinyint(1) NOT NULL COMMENT '0=weight-based, 1=per-item, 2=per-order', `subtotal_minimum` decimal(12,5) NOT NULL COMMENT 'Minimum Subtotal required for shipping method to be active', PRIMARY KEY (`shipping_method_id`), KEY `fk_taxclasses_shippingmethods` (`tax_class_id`), CONSTRAINT `fk_taxclass_shippingmethods` FOREIGN KEY (`tax_class_id`) REFERENCES `perfilmin_tienda_taxclasses` (`tax_class_id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_shippingrates` ( `shipping_rate_id` int(11) NOT NULL auto_increment, `geozone_id` int(11) NOT NULL, `shipping_method_id` int(11) NOT NULL, `shipping_rate_price` decimal(12,5) NOT NULL, `shipping_rate_weight_start` decimal(11,3) NOT NULL, `shipping_rate_weight_end` decimal(11,3) NOT NULL, `shipping_rate_handling` decimal(12,5) NOT NULL, `created_date` datetime NOT NULL COMMENT 'GMT Only', `modified_date` datetime NOT NULL COMMENT 'GMT Only', PRIMARY KEY (`shipping_rate_id`), KEY `fk_geozone_shippingrates` (`geozone_id`), CONSTRAINT `fk_geozone_shippingrates` FOREIGN KEY (`geozone_id`) REFERENCES `#__tienda_geozones` (`geozone_id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_shippingrates.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_shippingrates` ( `shipping_rate_id` int(11) NOT NULL auto_increment, `geozone_id` int(11) NOT NULL, `shipping_method_id` int(11) NOT NULL, `shipping_rate_price` decimal(12,5) NOT NULL, `shipping_rate_weight_start` decimal(11,3) NOT NULL, `shipping_rate_weight_end` decimal(11,3) NOT NULL, `shipping_rate_handling` decimal(12,5) NOT NULL, `created_date` datetime NOT NULL COMMENT 'GMT Only', `modified_date` datetime NOT NULL COMMENT 'GMT Only', PRIMARY KEY (`shipping_rate_id`), KEY `fk_geozone_shippingrates` (`geozone_id`), CONSTRAINT `fk_geozone_shippingrates` FOREIGN KEY (`geozone_id`) REFERENCES `perfilmin_tienda_geozones` (`geozone_id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_taxrates` ( `tax_rate_id` int(11) NOT NULL auto_increment, `geozone_id` int(11) NOT NULL default '0', `tax_class_id` int(11) NOT NULL, `tax_rate` decimal(7,4) NOT NULL default '0.0000', `tax_rate_description` varchar(255) NOT NULL default '', `created_date` datetime NOT NULL COMMENT 'GMT Only', `modified_date` datetime NOT NULL COMMENT 'GMT Only', PRIMARY KEY (`tax_rate_id`), KEY `fk_TaxClass_TaxRates` (`tax_class_id`), KEY `fk_geozones_taxrates` (`geozone_id`), CONSTRAINT `fk_TaxClass_TaxRates` FOREIGN KEY (`tax_class_id`) REFERENCES `#__tienda_taxclasses` (`tax_class_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_geozones_taxrates` FOREIGN KEY (`geozone_id`) REFERENCES `#__tienda_geozones` (`geozone_id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_taxrates.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_taxrates` ( `tax_rate_id` int(11) NOT NULL auto_increment, `geozone_id` int(11) NOT NULL default '0', `tax_class_id` int(11) NOT NULL, `tax_rate` decimal(7,4) NOT NULL default '0.0000', `tax_rate_description` varchar(255) NOT NULL default '', `created_date` datetime NOT NULL COMMENT 'GMT Only', `modified_date` datetime NOT NULL COMMENT 'GMT Only', PRIMARY KEY (`tax_rate_id`), KEY `fk_TaxClass_TaxRates` (`tax_class_id`), KEY `fk_geozones_taxrates` (`geozone_id`), CONSTRAINT `fk_TaxClass_TaxRates` FOREIGN KEY (`tax_class_id`) REFERENCES `perfilmin_tienda_taxclasses` (`tax_class_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_geozones_taxrates` FOREIGN KEY (`geozone_id`) REFERENCES `perfilmin_tienda_geozones` (`geozone_id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) TYPE=InnoDB;
Create external Table Error query [CREATE TABLE `#__tienda_zonerelations` ( `zonerelation_id` int(11) NOT NULL auto_increment, `zone_id` int(11) default NULL, `geozone_id` int(11) default NULL, `zip_range` varchar(255) NOT NULL, `created_date` datetime default NULL, `modified_date` datetime default NULL, PRIMARY KEY (`zonerelation_id`), KEY `fk_geozone_zonerelations` (`geozone_id`), KEY `fk_geozone_zones` (`zone_id`), CONSTRAINT `fk_geozone_zonerelations` FOREIGN KEY (`geozone_id`) REFERENCES `#__tienda_geozones` (`geozone_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_geozone_zones` FOREIGN KEY (`zone_id`) REFERENCES `#__tienda_zones` (`zone_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; ]. DB Error: Can't create table './perfilministerial/perfilmin_tienda_zonerelations.frm' (errno: 150) SQL=CREATE TABLE `perfilmin_tienda_zonerelations` ( `zonerelation_id` int(11) NOT NULL auto_increment, `zone_id` int(11) default NULL, `geozone_id` int(11) default NULL, `zip_range` varchar(255) NOT NULL, `created_date` datetime default NULL, `modified_date` datetime default NULL, PRIMARY KEY (`zonerelation_id`), KEY `fk_geozone_zonerelations` (`geozone_id`), KEY `fk_geozone_zones` (`zone_id`), CONSTRAINT `fk_geozone_zonerelations` FOREIGN KEY (`geozone_id`) REFERENCES `perfilmin_tienda_geozones` (`geozone_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_geozone_zones` FOREIGN KEY (`zone_id`) REFERENCES `perfilmin_tienda_zones` (`zone_id`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB;

We have retried reproducting the problem without success.
We did our test with Tienda 0.5.6.
Perhaps you could send us in attachement of an email the same Tienda version that you are using.

Our investigation on the MySQL error code (150) let suppose that you have a problem with the DB engine time during the replication.
Tienda use the "InnoDB" engine.

During our test, we both install tienda using the "JMS Tool" menu and also with the "manage site" to replicate an existing slave containing the tienda installed.
In both case we were able to install it or copy the slave successfully.