We only provide official support for Solidres's subscribers, all subscribers can request support by using forum or support ticket system. For more information please check our Support Policy at www.solidres.com/support-policy

SQL Insert error for new Asset

cdavis411
Topic Author
Offline

11 years 8 months ago #5228 by cdavis411

SQL Insert error for new Asset was created by cdavis411

Hello,

I Just installed the SolidRes package and created a category and a currency. When I tried to save an asset it gave the following error.

An error has occurred.
1452 Cannot add or update a child row: a foreign key constraint fails (`ccd411_tch`.`PREFIX-SNIPPED_sr_reservation_assets`, CONSTRAINT `fk_jos_sr_reservation_assets_jos_sr_taxes1` FOREIGN KEY (`tax_id`) REFERENCES `ne6qo_sr_taxes` (`id`) ON DELETE NO ACTION ON UPDATE NO A) SQL=INSERT INTO `PREFIX-SNIPPED_sr_reservation_assets` (`category_id`,`name`,`alias`,`address_1`,`address_2`,`city`,`postcode`,`phone`,`description`,`email`,`website`,`fax`,`rating`,`geo_state_id`,`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 ('17','Charis House','charis-house','336 Starbuck Run','','CITY-SNIPPED','ZIP-SNIPPED','','','support@DOMAIN-SNIPPED.com','','','1','11','224','','','1','1','1','{\"termsofuse\" $:\$ "\",\"privacypolicy\" $:\$ "\",\"disclaimer\" $:\$ "\",\"only_show_reservation_form\" $:\$ "0\",\"enable_coupon\" $:\$ "1\",\"logo\" $:\$ "\"}','','','{\"robots\" $:\$ "\",\"author\" $:\$ "\",\"rights\" $:\$ "\"}','','28.6976290','-81.3925160','0','0','1','','1','0')