View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000785 | BeeJ | База данных | public | 2024-07-20 18:25 | 2024-09-06 00:12 |
| Reporter | simon | Assigned To | simon | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Product Version | BeeJ 0.1a-rc3 | ||||
| Target Version | BeeJ 0.1a-rc4 | Fixed in Version | BeeJ 0.1a | ||
| Summary | 0000785: не удаляются ульи из-за связи с рядом и из-за потери colony_id | ||||
| Description | 2024-07-20 17:47:53 - mysqli_sql_exception: Cannot delete or update a parent row: a foreign key constraint fails (`beejb`.`bj_beehive_to_row`, CONSTRAINT `bj_beehive_to_row_ibfk_2` FOREIGN KEY (`beehive_id`) REFERENCES `bj_beehive` (`beehive_id`)) in /var/www/bj/basedir/site/system/library/db/mysqli.php on line 101 2024-07-20 17:48:47 - Exception: Error: Cannot add or update a child row: a foreign key constraint fails (`beejb`.`bj_colony_journal`, CONSTRAINT `bj_colony_journal_ibfk_1` FOREIGN KEY (`colony_id`) REFERENCES `bj_colony` (`colony_id`)) Error No: 1452 INSERT INTO bj_colony_journal SET text = 'Пчелосемья отвязана от улья из-за его удаления.' ,see_queen_id = 0 ,brood_info_id = 0 ,event_date = '2024-07-20 17:48' ,customer_id = 1 ,colony_id = 0 ,status = 1 ,date_added = NOW() in /var/www/bj/basedir/site/system/library/db/mysqli.php on line 80 | ||||
| Tags | No tags attached. | ||||
| Attach Tags | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-07-20 18:25 | simon | New Issue | |
| 2024-07-20 18:25 | simon | Status | new => assigned |
| 2024-07-20 18:25 | simon | Assigned To | => simon |
| 2024-07-21 05:28 | simon | Status | assigned => closed |
| 2024-07-21 05:28 | simon | Resolution | open => fixed |
| 2024-07-21 05:28 | simon | Fixed in Version | => BeeJ 0.1a |
| 2024-09-06 00:12 | simon | Target Version | BeeJ 0.1a => BeeJ 0.1a-rc4 |
