Thanks for the fix, it is working corretly now. Br, Aaron Toth -----Andy Kurth <[email protected]> ezt írta: ----- Címzett: [email protected] Feladó: Andy Kurth <[email protected]> Dátum: 2015/01/28 06:37du. Tárgy: Re: VCL 2.4 Frontend issue
I committed changes to vcl.sql and update-vcl.sql to not add the constraint on sublog.blockRequestid. The real problem is that sublog.blockRequestid is set to 'NOT NULL'. When the web frontend inserts a sublog entry for a non-block request reservation it sets sublog.blockRequestid to 0 -- a non-existent value. We should change things to allow this value to be null and set it to null for non-block request reservations. Not wanting to make too many changes at this point with the upcoming release, I simply removed the constraint. The update-vcl.sql file was updated to remove the sublog.blockRequestid constraint if it exists. You should be able to apply it to your database in order to fix things. -Andy On Tue, Jan 27, 2015 at 8:57 AM, Andy Kurth <[email protected]> wrote: > 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 >> > >
