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

Reply via email to