Monitor Reply

Support

Can't Install

Permalink Browser Info Environment March 27, 2017 at 6:48 PM

Hi there

I'm running into a problem when installing to c5 8.1. I get the debug message as follows

Doctrine \ DBAL \ Exception \ ForeignKeyConstraintViolationException
An exception occurred while executing 'ALTER TABLE AttributeSets ADD CONSTRAINT FK_FCA02D5FCE45CBB0 FOREIGN KEY (pkgID) REFERENCES Packages (pkgID)': SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`databasename`.`#sql-548_193ae`, CONSTRAINT `FK_FCA02D5FCE45CBB0` FOREIGN KEY (`pkgID`) REFERENCES `Packages` (`pkgID`))

Install_Directory/updates/concrete5-8.1.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php

case '1051':
case '1146':
return new Exception\TableNotFoundException($message, $exception);

case '1216':
case '1217':
case '1451':
case '1452':
case '1701':
return new Exception\ForeignKeyConstraintViolationException($message, $exception);

case '1062':
case '1557':
case '1569':
case '1586':
return new Exception\UniqueConstraintViolationException($message, $exception);

case '1054':
case '1166':
case '1611':

Can you help please?

Type:	Discussion
Status:	Resolved

IceManSpy replied on Mar 28, 2017 at 6:06 am Permalink Reply

Hi

This error is wierd, because I can't see anything about my plugin.
If you install another plugin, the error apear?
Could you test in fresh system or another server / computer?

gordonc200 replied on Mar 28, 2017 at 8:02 am Permalink Reply

Thanks for the response.

I'll need to find the time to setup a clean install of c5. I'll test as soon as I can and let you know.

A bit more info. If I go back from the error page and refresh the "extend concrete" dashboard page the package shows as installed but there's no dashboard page for it.

gordonc200 replied on Apr 9, 2017 at 2:52 pm Permalink Reply

OK, I've now managed to install the Add On to clean C5 8.1 installs to both a local development platform and the same server the production website is on. Running a local version of the problem website recreates the same problem.

So there's something in my site that the addon is conflicting with. The site is highly customised, uses advanced permissions (it isn't public) and has been updated from 5.7. It uses a number of custom blocks and packages so I suspect working this out might not be easy.

gordonc200 replied on Apr 19, 2017 at 1:17 pm Permalink Reply

It turns out the issue was with an the package "proevents" which doesn't work with v8. This couldn't be uninstalled as it was throwing a "foreign key constraint" error.

I eventually resolved this by manually removing the proevents package using the excellent guide here

https://www.concrete5.org/community/forums/customizing_c5/nuclear-op...

Once that was dealt with your package installed no problem.

I offer the advice of the method I used to clear the problem but can't say if it will work for anyone else!

Following the above guide I found ProEvents package ID was 97 and the Block ID was 22. This will obviously be different on others systems and so they should find the IDs and put them in the code below. The first sql code I ran on my database in mySQLAdmin was

delete from Blocks where btID = "blockIDhere";
delete from BlockTypes where btID = "blockIDhere";
delete from Packages where pkgID = "packageIDhere";
delete from Pages where pkgID = "packageIDhere";
delete from PageThemes where pkgID = "packageIDhere";
delete from PageTypes where pkgID = "packageIDhere";
delete from SystemAntispamLibraries where pkgID = "packageIDhere";
delete from MailImporters where pkgID = "packageIDhere";
delete from AttributeKeyCategories where pkgID = "packageIDhere";
delete from PermissionKeyCategories where pkgID = "packageIDhere";
delete from AttributeSets where pkgID = "packageIDhere";
delete from GroupSets where pkgID = "packageIDhere";
delete from AttributeTypes where pkgID = "packageIDhere";
delete from WorkflowTypes where pkgID = "packageIDhere";
delete from PermissionKeys where pkgID = "packageIDhere";

Viewing 15 lines of 17 lines. View entire code block.

 
delete from Blocks where btID = "blockIDhere";
delete from BlockTypes where btID = "blockIDhere";
delete from Packages where pkgID = "packageIDhere";
delete from Pages where pkgID = "packageIDhere";
delete from PageThemes where pkgID = "packageIDhere";
delete from PageTypes where pkgID = "packageIDhere";
delete from SystemAntispamLibraries where pkgID = "packageIDhere";
delete from MailImporters where pkgID = "packageIDhere";
delete from AttributeKeyCategories where pkgID = "packageIDhere";
delete from PermissionKeyCategories where pkgID = "packageIDhere";
delete from AttributeSets where pkgID = "packageIDhere";
delete from GroupSets where pkgID = "packageIDhere";
delete from AttributeTypes where pkgID = "packageIDhere";
delete from WorkflowTypes where pkgID = "packageIDhere";
delete from PermissionKeys where pkgID = "packageIDhere";
delete from PermissionAccessEntityTypes where pkgID = "packageIDhere";
delete from SystemCaptchaLibraries where pkgID = "packageIDhere";

I had unticked checking foreign key constraints.

Then I ran

DROP TABLE `btProEventDates`, `btProEventSettings`, `btProEventDatesExclude`, `btProEventUserSaved`, `btProEventList`;

I then deleted the package from the packages directory.

Hopefully this is of some help to others.

Good work on your v8 compatible package IceManSpy.

ds - Event Calendar Free 5.7.

Support

Can't Install

Issue Reply

concrete5 Environment Information

Browser User-Agent String

Hide Post Content

Request Refund

Code

Delete Post