Monitor Reply

Support

problema sql in istallation step

Permalink Browser Info Environment October 21, 2022 at 1:59 PM

hi, i have upgrade concrete5 from 8.5.1 to 8.5.9 (php 7.4.x) for to be sure to ave complete compatibility with new software, but in installation step i have the following error:

Doctrine \ DBAL \ Exception \ ForeignKeyConstraintViolationException
An exception occurred while executing 'ALTER TABLE atDateTime ADD CONSTRAINT FK_DF75412AA2A82A5D FOREIGN KEY (avID) REFERENCES AttributeValues (avID) ON DELETE CASCADE': SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`database_2019`.`#sql-336694_cc56ca`, CONSTRAINT `FK_DF75412AA2A82A5D` FOREIGN KEY (`avID`) REFERENCES `AttributeValues` (`avID`) ON DELETE CASCADE)
Previous exceptions

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`database_2019`.`#sql-336694_cc56ca`, CONSTRAINT `FK_DF75412AA2A82A5D` FOREIGN KEY (`avID`) REFERENCES `AttributeValues` (`avID`) ON DELETE CASCADE) (23000)
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`database_2019`.`#sql-336694_cc56ca`, CONSTRAINT `FK_DF75412AA2A82A5D` FOREIGN KEY (`avID`) REFERENCES `AttributeValues` (`avID`) ON DELETE CASCADE) (23000)

for verify, i have try to install another add-on , "login-block" the installation of it, is gone fine.

i need help thank you
Enrico

Type:	Ticket
Status:	Resolved

Xanweb replied on Oct 24, 2022 at 3:43 pm Permalink Reply

Hi Enrico,

Doesn't seems that the issue is related to our package.
It appears that the upgrade did not go well, you can try to re-run the upgrade script via the dashboard:
- Visit [your_domain]/ccm/system/upgrade
- Click on Re-Run Upgrade script and confirm.

Kind Regards,
Xanweb Support Team

bitit replied on Oct 24, 2022 at 4:29 pm Permalink Reply

ok, done, but , i have the same problem:

[
Doctrine \ DBAL \ Exception \ ForeignKeyConstraintViolationException
An exception occurred while executing 'ALTER TABLE atDateTime ADD CONSTRAINT FK_DF75412AA2A82A5D FOREIGN KEY (avID) REFERENCES AttributeValues (avID) ON DELETE CASCADE': SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`database_2019`.`#sql-336694_d91c0f`, CONSTRAINT `FK_DF75412AA2A82A5D` FOREIGN KEY (`avID`) REFERENCES `AttributeValues` (`avID`) ON DELETE CASCADE)
Previous exceptions

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`database_2019`.`#sql-336694_d91c0f`, CONSTRAINT `FK_DF75412AA2A82A5D` FOREIGN KEY (`avID`) REFERENCES `AttributeValues` (`avID`) ON DELETE CASCADE) (23000)
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`database_2019`.`#sql-336694_d91c0f`, CONSTRAINT `FK_DF75412AA2A82A5D` FOREIGN KEY (`avID`) REFERENCES `AttributeValues` (`avID`) ON DELETE CASCADE) (23000)

]

Xanweb replied on Oct 25, 2022 at 8:45 am Permalink Reply

Can you please provide us more details how the issue occurred and describe the steps made to reproduce the bug?

bitit replied on Oct 25, 2022 at 9:49 am Permalink Reply

well, i have upgrade the software from 8.5.1 to 8.5.9, step by step until 8.5.7 and next, after upgrading server php version to 7.4.x , i have upgrade by dashboard to 8.5.9.

because with old version i'm not was able to install nothing .

after i have download the plugin from dashboard and i proceeded with installation without success

bitit replied on Oct 25, 2022 at 2:33 pm Permalink Reply

well, i have solved , i have found many tips in the forums for applying what below :
"""
The best way to do this manually would be to run php ./concrete/bin/concrete5 orm:schema-tool:update --dump-sql then copy the outputted SQL and fire up a mysql client.

Run SET FOREIGN_KEY_CHECKS=0;
Run the SQL that was outputted by the orm:schema-tool
Run SET FOREIGN_KEY_CHECKS=1;
"""

after that , i have installed your plugin

thank you
enrico

bitit replied on Oct 25, 2022 at 3:05 pm Permalink Reply

https://www.fondazionecologni.it/

how can setup black background and white text?

Enrico

bitit replied on Oct 25, 2022 at 3:14 pm Permalink Reply

another question: if i give consent for cookies, and after i clear all cookies of web site , the cookie bar should be shown other time; usually other software working in this way , but not this.
ho can replicate the cookie banner a second time?

Enrico

Xanweb replied on Oct 26, 2022 at 9:28 am Permalink Reply

This is unexpected behavior, the disclaimer should appears again whenever you clear the cookies of your browser.
We tested the scenario on your website and it worked as intended.
Please double check if you have deleted the cookies properly.

Kind Regards,
Xanweb Support Team

bitit replied on Oct 26, 2022 at 9:34 am Permalink Reply

Ok, thank you , i was use a tool for firefox that seem not working correctly

Xanweb replied on Oct 26, 2022 at 9:02 am Permalink Reply

You can navigate to
/dashboard/system/seo/active_cookie_consent/cookies_disclaimer/style
in order to customize your disclaimer styles.

Kind Regards,
Xanweb Support Team

Active Cookie Consent

Support

problema sql in istallation step

Issue Reply

concrete5 Environment Information

Browser User-Agent String

Hide Post Content

Request Refund

Code

Delete Post