- Posts: 1
- Home
- Forum
- Community Forum
- Questions
- Does a vendor has access to the component experience (HUB)
Error trying to add a new asset
- YankeeDoodle
- Topic Author
- Offline
Less
More
10 years 3 months ago #5170
by YankeeDoodle
Error trying to add a new asset was created by YankeeDoodle
Whether or not the Sample Data is installed or not, trying to add a new asset to a new caregory, I am keeping the same error:
======================================
Cannot add or update a child row: a foreign key constraint fails (`mokumkf140_resort`.`vhusx_sr_reservation_assets`, CONSTRAINT `fk_jos_sr_reservation_assets_jos_sr_taxes1` FOREIGN KEY (`tax_id`) REFERENCES `vhusx_sr_taxes` (`id`) ON DELETE NO ACTION ON UPDA) SQL=INSERT INTO `vhusx_sr_reservation_assets` (`category_id`,`name`,`alias`,`address_1`,`address_2`,`city`,`postcode`,`phone`,`description`,`email`,`website`,`fax`,`rating`,`country_id`,`created_date`,`created_by`,`state`,`ordering`,`access`,`params`,`metakey`,`metadesc`,`metadata`,`xreference`,`lat`,`lng`,`default`,`deposit_required`,`deposit_is_percentage`,`deposit_amount`,`currency_id`,`tax_id`) VALUES ('19','Decano Resort & Beach Club','decano-resort-beach-club','','','','','','<p>Beach resort</p>','decano@resortbeach.club','','','1','169','','490','1','1','1','{\"termsofuse\":\"\",\"privacypolicy\":\"\",\"disclaimer\":\"\",\"only_show_reservation_form\":\"1\",\"enable_coupon\":\"1\",\"logo\":\"\"}','','','{\"robots\":\"\",\"author\":\"\",\"rights\":\"\"}','','12.8797210','121.7740170','1','1','1','50','1','0')
======================================
What am I doing wrong?
======================================
Cannot add or update a child row: a foreign key constraint fails (`mokumkf140_resort`.`vhusx_sr_reservation_assets`, CONSTRAINT `fk_jos_sr_reservation_assets_jos_sr_taxes1` FOREIGN KEY (`tax_id`) REFERENCES `vhusx_sr_taxes` (`id`) ON DELETE NO ACTION ON UPDA) SQL=INSERT INTO `vhusx_sr_reservation_assets` (`category_id`,`name`,`alias`,`address_1`,`address_2`,`city`,`postcode`,`phone`,`description`,`email`,`website`,`fax`,`rating`,`country_id`,`created_date`,`created_by`,`state`,`ordering`,`access`,`params`,`metakey`,`metadesc`,`metadata`,`xreference`,`lat`,`lng`,`default`,`deposit_required`,`deposit_is_percentage`,`deposit_amount`,`currency_id`,`tax_id`) VALUES ('19','Decano Resort & Beach Club','decano-resort-beach-club','','','','','','<p>Beach resort</p>','decano@resortbeach.club','','','1','169','','490','1','1','1','{\"termsofuse\":\"\",\"privacypolicy\":\"\",\"disclaimer\":\"\",\"only_show_reservation_form\":\"1\",\"enable_coupon\":\"1\",\"logo\":\"\"}','','','{\"robots\":\"\",\"author\":\"\",\"rights\":\"\"}','','12.8797210','121.7740170','1','1','1','50','1','0')
======================================
What am I doing wrong?
Please Log in or Create an account to join the conversation.
- vietvh
-
- Offline
Less
More
- Posts: 1553
10 years 3 months ago #5173
by vietvh
Replied by vietvh on topic Error trying to add a new asset
Hi,
Nice week to you.
If you are using v0.8.0, please apply this patch, it will fix this issue for you:
www.solidres.com/forum/general-discussio...without-choosing-tax
Regards,
Nice week to you.
If you are using v0.8.0, please apply this patch, it will fix this issue for you:
www.solidres.com/forum/general-discussio...without-choosing-tax
Regards,
Please Log in or Create an account to join the conversation.
Moderators: solidres