- Posts: 8
- Home
- Forum
- Community Forum
- General discussions
- GTranslate component
problem to setpicture for rooms in media
- hossein
- Topic Author
- Offline
Less
More
10 years 10 months ago #4335
by hossein
problem to setpicture for rooms in media was created by hossein
whene i am editing "room type" after saving with picture selected fo room types from media ia involved with tjis error:
1452 Cannot add or update a child row: a foreign key constraint fails (`booking_test`.`uvu75_sr_room_types`, CONSTRAINT `fk_sr_room_types_sr_reservation_assets1` FOREIGN KEY (`reservation_asset_id`) REFERENCES `uvu75_sr_reservation_assets` (`id`) ON DELETE NO ACT) SQL=UPDATE `uvu75_sr_room_types` SET `reservation_asset_id`='',`name`='Tagh(double bed)',`alias`='tagh-double-bed',`description`='',`state`='1',`checked_out`='587',`checked_out_time`='2014-06-13 14:24:15',`created_by`='0',`created_date`='2014-05-29 04:37:40',`modified_by`='587',`modified_date`='2014-06-13 14:24:40',`language`='*',`params`='{\"show_smoking_option\":\"1\",\"show_child_option\":\"1\"}',`featured`='0',`ordering`='15',`occupancy_adult`='4',`occupancy_child`='6',`smoking`='0' WHERE `id`='20'
is there any body to help for this problem?
thanks in advance.
1452 Cannot add or update a child row: a foreign key constraint fails (`booking_test`.`uvu75_sr_room_types`, CONSTRAINT `fk_sr_room_types_sr_reservation_assets1` FOREIGN KEY (`reservation_asset_id`) REFERENCES `uvu75_sr_reservation_assets` (`id`) ON DELETE NO ACT) SQL=UPDATE `uvu75_sr_room_types` SET `reservation_asset_id`='',`name`='Tagh(double bed)',`alias`='tagh-double-bed',`description`='',`state`='1',`checked_out`='587',`checked_out_time`='2014-06-13 14:24:15',`created_by`='0',`created_date`='2014-05-29 04:37:40',`modified_by`='587',`modified_date`='2014-06-13 14:24:40',`language`='*',`params`='{\"show_smoking_option\":\"1\",\"show_child_option\":\"1\"}',`featured`='0',`ordering`='15',`occupancy_adult`='4',`occupancy_child`='6',`smoking`='0' WHERE `id`='20'
is there any body to help for this problem?
thanks in advance.
Please Log in or Create an account to join the conversation.
- Dolphin
-
- Offline
Less
More
- Posts: 43
10 years 10 months ago #4337
by Dolphin
Replied by Dolphin on topic problem to setpicture for rooms in media
What is your Solidres version? Did you select an asset for your room type before saving?
The following user(s) said Thank You: hossein
Please Log in or Create an account to join the conversation.
- hossein
- Topic Author
- Offline
Less
More
- Posts: 8
10 years 10 months ago #4338
by hossein
Replied by hossein on topic problem to setpicture for rooms in media
Thank for your information and cooperation.
the asset was blank and after i changed it to a correct state save btn worked as well.
the asset was blank and after i changed it to a correct state save btn worked as well.
Please Log in or Create an account to join the conversation.
Moderators: solidres