I will look into it. The constraint may be exposing an underlying problem with the database. Thanks, Andy
On Tue, Jan 27, 2015 at 8:39 AM, <[email protected]> wrote: > Dear all, > > I ran into another frontend issue, I cannot create a basic reservation and > get the following rather generic error message: "Error encountered: Please > try again later" > > With IE11 Developer Tools, I got this as the error message for the AJAX > request: > Cannot add or update a child row: a foreign key constraint fails > (`vcl`.`sublog`, CONSTRAINT `sublog_ibfk_8` FOREIGN KEY (`blockRequestid`) > REFERENCES `blockRequest` (`id`)) > INSERT INTO sublog (logid, imageid, imagerevisionid, computerid, > managementnodeid, predictivemoduleid, hostcomputerid) VALUES (4, 3, 2, 2, > 1, 8, 1) > ERROR(101): General MySQL error > > The problem seems to be that the frontend tries to INSERT into the sublog > table incorrectly (under the new set of foreign key constraints). > The problematic constraint seems to have appeared with the same commit as > the one I wrote about earlier: > > Constraint commited: > Revision: 1646344 > Author: arkurth > Date: 2014. december 17. 22:51:21 > Message: > VCL-763 > Added constraints to the several columns which reference another table. > ---- > Modified : /vcl/trunk/mysql/vcl.sql > > Again, due to this, we are unable to create any new reservations in a 2.4 > (test version) clean install (using the install script provided by Josh). > As before, we would appreciate if you could fix this in the trunk. > > Br, > Aaron Toth >
