Monitor Reply

Support

Cannot complete install of Block Designer or Block Designer Pro

Permalink Browser Info Environment March 29, 2022 at 11:12 PM

I've tried multiple times to install these two plugins, but keep getting blocked by a foreign key constraint failure. When installing the Block Designer addon, I get the following stack trace (I only include the most relevant install-related lines):

Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException thrown with message "An exception occurred while executing 'ALTER TABLE atselectedtopics ADD CONSTRAINT FK_E42A7D5BA2A82A5D FOREIGN KEY (avID) REFERENCES atTopic (avID)':
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`flathead_cms`.`#sql-b64_3c1d`, CONSTRAINT `FK_E42A7D5BA2A82A5D` FOREIGN KEY (`avID`) REFERENCES `attopic` (`avID`))"
Stacktrace:
#41 Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php:68
#40 Doctrine\DBAL\Driver\AbstractMySQLDriver:convertException in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php:182
#39 Doctrine\DBAL\DBALException:wrapException in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php:159
#38 Doctrine\DBAL\DBALException:driverExceptionDuringQuery in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php:2225
#37 Doctrine\DBAL\Connection:handleExceptionDuringQuery in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php:1312
#36 Doctrine\DBAL\Driver\PDO\Exception in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDO\Exception.php:18
#35 Doctrine\DBAL\Driver\PDO\Exception:new in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:143
#34 PDOException in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:141
#33 PDO:query in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:141
#32 Doctrine\DBAL\Driver\PDOConnection:doQuery in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOQueryImplementation.php:38
#31 Doctrine\DBAL\Driver\PDOConnection:query in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php:1308
#30 Doctrine\DBAL\Connection:executeQuery in C:\WebRepositories\redesign.flathead.mt.gov\concrete\src\Database\DatabaseStructureManager.php:233

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

 
Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException thrown with message "An exception occurred while executing 'ALTER TABLE atselectedtopics ADD CONSTRAINT FK_E42A7D5BA2A82A5D FOREIGN KEY (avID) REFERENCES atTopic (avID)':
 
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`flathead_cms`.`#sql-b64_3c1d`, CONSTRAINT `FK_E42A7D5BA2A82A5D` FOREIGN KEY (`avID`) REFERENCES `attopic` (`avID`))"
 
Stacktrace:
#41 Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php:68
#40 Doctrine\DBAL\Driver\AbstractMySQLDriver:convertException in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php:182
#39 Doctrine\DBAL\DBALException:wrapException in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php:159
#38 Doctrine\DBAL\DBALException:driverExceptionDuringQuery in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php:2225
#37 Doctrine\DBAL\Connection:handleExceptionDuringQuery in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php:1312
#36 Doctrine\DBAL\Driver\PDO\Exception in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDO\Exception.php:18
#35 Doctrine\DBAL\Driver\PDO\Exception:new in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:143
#34 PDOException in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:141
#33 PDO:query in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:141
#32 Doctrine\DBAL\Driver\PDOConnection:doQuery in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOQueryImplementation.php:38
#31 Doctrine\DBAL\Driver\PDOConnection:query in C:\WebRepositories\redesign.flathead.mt.gov\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php:1308
#30 Doctrine\DBAL\Connection:executeQuery in C:\WebRepositories\redesign.flathead.mt.gov\concrete\src\Database\DatabaseStructureManager.php:233
#29 Concrete\Core\Database\DatabaseStructureManager:installDatabaseFor in C:\WebRepositories\redesign.flathead.mt.gov\concrete\src\Database\DatabaseStructureManager.php:170
#28 Concrete\Core\Database\DatabaseStructureManager:installDatabase in C:\WebRepositories\redesign.flathead.mt.gov\concrete\src\Package\Package.php:959
#27 Concrete\Core\Package\Package:installEntitiesDatabase in C:\WebRepositories\redesign.flathead.mt.gov\concrete\src\Package\Package.php:950
#26 Concrete\Core\Package\Package:installDatabase in C:\WebRepositories\redesign.flathead.mt.gov\concrete\src\Package\Package.php:600
#25 Concrete\Core\Package\Package:install in C:\WebRepositories\redesign.flathead.mt.gov\packages\block_designer\controller.php:31
#24 Concrete\Package\BlockDesigner\Controller:install in C:\WebRepositories\redesign.flathead.mt.gov\concrete\src\Package\PackageService.php:243
#23 Concrete\Core\Package\PackageService:install in C:\WebRepositories\redesign.flathead.mt.gov\concrete\controllers\single_page\dashboard\extend\install.php:146
#22 Concrete\Controller\SinglePage\Dashboard\Extend\Install:install_package in C:\WebRepositories\redesign.flathead.mt.gov\concrete\src\Controller\AbstractController.php:318

The install of Block Designer Pro throws the same issue. If I ignore the error the addons show as installed, but there's no dashboard integration shown (none the of the single pages are registered).

Type:	Ticket
Status:	Resolved

ramonleenders replied on Mar 30, 2022 at 1:37 pm Permalink Reply

Hi there,

Seems that your Flathead Add-On is causing issues here. Not sure what this Add-on is or wjat it does? Your first few lines have the flathead constraint in the log mentioned. I can confirm that the Add-on should work with 9.0.2 of ConcreteCMS. Must be something with your current install unfortunately. Can you install other Add-ons though?

Kind regards
Ramon

FCIT_Programmers replied on Mar 30, 2022 at 2:42 pm Permalink Reply

Thank you for the quick reply, I appreciate it.

I am able to install other addons on our Concrete installation, yes. I will try temporarily disabling the "Flathead County Identity Access Manager" addon, and install these two block designer addons again. We are actively developing this website with a custom theme and custom addons, so if there's something that we're doing that is breaking things, we want to know about it.

FCIT_Programmers replied on Mar 30, 2022 at 3:35 pm Permalink Reply

Disabling the "Flathead County Identity Access Manager" addon didn't work, I still received the same basic error. The purpose of that Flathead addon is to enable LDAP and Duo/MFA authentication capabilities for the website.

The custom theme we're developing is not yet a full concrete package, and thus lives in the application/* folder structure. Is there another Flathead Add-On that you're referring to in your original comment?

ramonleenders replied on Mar 30, 2022 at 8:42 pm Permalink Reply

I dont know the add on, so I don't know to be honest. Did you upgrade from 8.x perhaps? I remember having the same issue with an installation, but forgot how I resolved it. See these lines:

ONSTRAINT FK_E42A7D5BA2A82A5D FOREIGN KEY (avID) REFERENCES atTopic (avID)':
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`flathead_cms`.`#sql-b64_3c1d`, CONSTRAINT `FK_E42A7D5BA2A82A5D` FOREIGN KEY (`avID`) REFERENCES `attopic` (`avID`))

Clearly there seems something wrong database wise for the constrainst of this flathead cms add on. Can you try a fresh install of concreteCMS maybe? Don't really know what to do on my end for this. Maybe there is a SQL fix, but since I am on holidays, it is a bit hard to search for tbat. If you have Slack, there are people helping out there as well.

Let me know if a clean install works, then at least we know it is something with the current database.

Kind regards
Ramon

FCIT_Programmers replied on Mar 31, 2022 at 2:01 am Permalink Reply

Thank you. I was going to attempt a fresh install of Concrete, without the custom themes and any other addons aside from these two. The flathead_cms in that MySQL error is the name of the database. This Concrete install started at version 9.0, and has only upgraded to the latest point releases available on that branch.

I will let you know how the fresh install goes. One of my other programmers also had a thought about cleaning up some of those tables, since she encountered an issue with one of her sub-projects, relating to foreign key issues and Entity relationships.

Thanks! Enjoy your holiday.

FCIT_Programmers replied on Mar 31, 2022 at 3:03 am Permalink Reply

After creating a fresh install of ConcreteCMS 9.0.2 for another project, and temporarily installing these two addons in that site, the addons installed just fine. I will troubleshoot our existing Concrete install, or start from scratch (since it's not launched yet).

Thank you for your assistance, I really appreciate it.

FCIT_Programmers replied on Mar 31, 2022 at 8:22 pm Permalink Reply

I found the record that was causing the foreign key issue and removed it, since it was orphaned. That allowed me to install both addons.

Block Designer

Support

Cannot complete install of Block Designer or Block Designer Pro

Issue Reply

concrete5 Environment Information

Browser User-Agent String

Hide Post Content

Request Refund

Code

Delete Post