Installation plugin sql error

ok , i have by two plug-in for cookies law and both give me the same error in installation step : EU Cookie Law Disclosure

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 (`fcol`.`#sql-336694_cc1003`, 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
(`fcologni_2019`.`#sql-336694_cc1003`, 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
(`fcol`.`#sql-336694_cc1003`, CONSTRAINT
`FK_DF75412AA2A82A5D` FOREIGN KEY (`avID`) REFERENCES
`AttributeValues` (`avID`) ON DELETE CASCADE) (23000)

Active Cookie Consent:

 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 (`fcologni_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 (`fcologni_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 (`fcologni_2019`.`#sql-336694_cc56ca`, CONSTRAINT `FK_DF75412AA2A82A5D` FOREIGN KEY (`avID`) REFERENCES `AttributeValues` (`avID`) ON DELETE CASCADE) (23000)

some body can help me?
ENrico

i have tested to install another plugin " login-blok", in this case the installations go fine.

but for both cookies law banner don’t work

Enrico

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

Sounds good, thanks for the follow up @bitit :+1:

ok in other web site i have the same problem but more complicate.
i have upgraded from 8.3.2 to 8.5.9 and after 8.5.11 for the same problem in installing plugin.

 Doctrine \ DBAL \ Exception \ ForeignKeyConstraintViolationException
An exception occurred while executing 'ALTER TABLE atDefault ADD CONSTRAINT FK_3484F81EA2A82A5D 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`.`#sql-d72_101032`, CONSTRAINT `FK_3484F81EA2A82A5D` 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`.`#sql-d72_101032`, CONSTRAINT `FK_3484F81EA2A82A5D` 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`.`#sql-d72_101032`, CONSTRAINT `FK_3484F81EA2A82A5D` FOREIGN KEY (`avID`) REFERENCES `AttributeValues` (`avID`) ON DELETE CASCADE) (23000)

i have i have tried to following the same way for solving but, in running
“php ./concrete/bin/concrete5 orm:schema-tool:update --dump-sql”
i have the following error

[04-Nov-2022 14:00:51 UTC] PHP Warning:  require(/home/maestro/public_html/updates/concrete-cms-8.5.11/concrete/bin/concrete5.php): failed to open stream: No such file or directory in /home/maestro/public_html/concrete/bin/concrete5 on line 80
[04-Nov-2022 14:00:51 UTC] PHP Fatal error:  require(): Failed opening required '/home/maestro/public_html/updates/concrete-cms-8.5.11/concrete/bin/concrete5.php' (include_path='.:/opt/cpanel/ea-php74/root/usr/share/pear') in /home/maestro/public_html/concrete/bin/concrete5 on line 80

same tip?

ok, i have try in this way
in folder : ```
updates/concrete-cms-8.5.11/concrete/bin/


i have copy concrete5 in concrete5.php

ok, i have try in this way
in folder : ```
updates/concrete-cms-8.5.11/concrete/bin/

i have copy concrete5 in concrete5.php

the output for command
php ./concrete/bin/concrete5 orm:schema-tool:update --dump-sql”
is

ALTER TABLE Packages CHANGE pkgName pkgName VARCHAR(255) DEFAULT NULL, CHANGE pkgAvailableVersion pkgAvailableVersion VARCHAR(255)DEFAULT NULL;
ALTER TABLE SiteSkeletonLocales CHANGE siteSkeletonID siteSkeletonID INT UNSIGNED DEFAULT NULL, CHANGE siteTreeID siteTreeID INT UNSIGNED DEFAULT NULL;
ALTER TABLE SiteGroups CHANGE siteTypeID siteTypeID INT UNSIGNED DEFAULT NULL;
ALTER TABLE SiteGroupRelations CHANGE siteGID siteGID INT UNSIGNED DEFAULT NULL, CHANGE siteID siteID INT UNSIGNED DEFAULT NULL;
ALTER TABLE SiteSkeletons CHANGE siteTypeID siteTypeID INT UNSIGNED DEFAULT NULL;
ALTER TABLE SiteLocales CHANGE siteID siteID INT UNSIGNED DEFAULT NULL, CHANGE siteTreeID siteTreeID INT UNSIGNED DEFAULT NULL;
ALTER TABLE SiteSkeletonTrees CHANGE skeletonLocaleID skeletonLocaleID INT UNSIGNED DEFAULT NULL, CHANGE siteTypeID siteTypeID INTUNSIGNED DEFAULT NULL;
ALTER TABLE Sites CHANGE siteTypeID siteTypeID INT UNSIGNED DEFAULT NULL;
ALTER TABLE SiteDomains CHANGE siteID siteID INT UNSIGNED DEFAULT NULL;
ALTER TABLE SiteTypes CHANGE pkgID pkgID INT UNSIGNED DEFAULT NULL;
ALTER TABLE SiteTreeTrees CHANGE siteLocaleID siteLocaleID INT UNSIGNED DEFAULT NULL;
ALTER TABLE MultilingualPageRelations CHANGE mpLanguage mpLanguage VARCHAR(32) DEFAULT NULL;
ALTER TABLE PageFeeds CHANGE pfAreaHandleToDisplay pfAreaHandleToDisplay VARCHAR(255) DEFAULT NULL, CHANGE customTopicAttributeKeyHandle customTopicAttributeKeyHandle VARCHAR(255) DEFAULT NULL;
ALTER TABLE FileImageThumbnailTypes CHANGE ftTypeWidth ftTypeWidth INT DEFAULT NULL, CHANGE ftTypeHeight ftTypeHeight INT DEFAULT NULL;
ALTER TABLE Files CHANGE uID uID INT UNSIGNED DEFAULT NULL, CHANGE fslID fslID INT UNSIGNED DEFAULT NULL, CHANGE fPassword fPassword VARCHAR(255) DEFAULT NULL;
ALTER TABLE FileVersions CHANGE fvPrefix fvPrefix VARCHAR(255) DEFAULT NULL, CHANGE fvTitle fvTitle VARCHAR(255) DEFAULT NULL, CHANGE fvExtension fvExtension VARCHAR(255) DEFAULT NULL;
ALTER TABLE StyleCustomizerInlineStyleSets CHANGE backgroundColor backgroundColor VARCHAR(255) DEFAULT NULL, CHANGE backgroundRepeat backgroundRepeat VARCHAR(255) DEFAULT NULL, CHANGE backgroundSize backgroundSize VARCHAR(255) DEFAULT NULL, CHANGE backgroundPosition backgroundPosition VARCHAR(255) DEFAULT NULL, CHANGE borderWidth borderWidth VARCHAR(255) DEFAULT NULL, CHANGE borderColor borderColor VARCHAR(255) DEFAULT NULL, CHANGE borderStyle borderStyle VARCHAR(255) DEFAULT NULL, CHANGE borderRadius borderRadius VARCHAR(255) DEFAULT NULL, CHANGE baseFontSize baseFontSize VARCHAR(255) DEFAULT NULL, CHANGE alignment alignment VARCHAR(255) DEFAULTNULL, CHANGE textColor textColor VARCHAR(255) DEFAULT NULL, CHANGE linkColor linkColor VARCHAR(255) DEFAULT NULL, CHANGE paddingTop paddingTop VARCHAR(255) DEFAULT NULL, CHANGE paddingBottom paddingBottom VARCHAR(255) DEFAULT NULL, CHANGE paddingLeft paddingLeft VARCHAR(255) DEFAULT NULL, CHANGE paddingRight paddingRight VARCHAR(255) DEFAULT NULL, CHANGE marginTop marginTop VARCHAR(255) DEFAULT NULL, CHANGE marginBottom marginBottom VARCHAR(255) DEFAULT NULL, CHANGE marginLeft marginLeft VARCHAR(255) DEFAULT NULL, CHANGE marginRight marginRight VARCHAR(255) DEFAULT NULL, CHANGE rotate rotate VARCHAR(255) DEFAULT NULL, CHANGE boxShadowHorizontal boxShadowHorizontal VARCHAR(255) DEFAULT NULL, CHANGE boxShadowVertical boxShadowVertical VARCHAR(255) DEFAULT NULL, CHANGE boxShadowBlur boxShadowBlur VARCHAR(255) DEFAULT NULL, CHANGE boxShadowSpread boxShadowSpread VARCHAR(255) DEFAULT NULL, CHANGE boxShadowColor boxShadowColor VARCHAR(255) DEFAULT NULL, CHANGE customClass customClass VARCHAR(255) DEFAULT NULL, CHANGE hideOnExtraSmallDevice hideOnExtraSmallDevice TINYINT(1) DEFAULT NULL, CHANGE hideOnSmallDevice hideOnSmallDevice TINYINT(1) DEFAULT NULL, CHANGE hideOnMediumDevice hideOnMediumDevice TINYINT(1) DEFAULT NULL, CHANGE hideOnLargeDevice hideOnLargeDevice TINYINT(1) DEFAULT NULL, CHANGE customID customID VARCHAR(255) DEFAULT NULL, CHANGE customElementAttribute customElementAttribute VARCHAR(255) DEFAULT NULL;
ALTER TABLE Users CHANGE uTimezone uTimezone VARCHAR(255) DEFAULT NULL, CHANGE uDefaultLanguage uDefaultLanguage VARCHAR(32) DEFAULT NULL;
ALTER TABLE UserSignups CHANGE uID uID INT UNSIGNED DEFAULT NULL, CHANGE createdBy createdBy INT UNSIGNED DEFAULT NULL;
ALTER TABLE Geolocators CHANGE glPackage glPackage INT UNSIGNED DEFAULT NULL;
ALTER TABLE OAuth2AuthCode CHANGE client client CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)';
ALTER TABLE OAuth2RefreshToken CHANGE accessToken accessToken CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)';
ALTER TABLE OAuth2AccessToken CHANGE client client CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)', CHANGE userIdentifier userIdentifier INT UNSIGNED DEFAULT NULL;
ALTER TABLE NotificationAlerts CHANGE uID uID INT UNSIGNED DEFAULT NULL, CHANGE nID nID INT UNSIGNED DEFAULT NULL;
ALTER TABLE UserSignupNotifications CHANGE usID usID INT UNSIGNED DEFAULT NULL;
ALTER TABLE FormSubmissionNotifications CHANGE exEntryID exEntryID INT DEFAULT NULL;
ALTER TABLE UserDeactivatedNotifications CHANGE actorID actorID INT UNSIGNED DEFAULT NULL;
ALTER TABLE SocialLinks CHANGE siteID siteID INT UNSIGNED DEFAULT NULL;
ALTER TABLE AttributeSets CHANGE akCategoryID akCategoryID INT UNSIGNED DEFAULT NULL, CHANGE pkgID pkgID INT UNSIGNED DEFAULT NULL;
ALTER TABLE AttributeKeyCategories CHANGE pkgID pkgID INT UNSIGNED DEFAULT NULL;
ALTER TABLE AttributeTypes CHANGE pkgID pkgID INT UNSIGNED DEFAULT NULL;
ALTER TABLE FileAttributeValues CHANGE avID avID INT UNSIGNED DEFAULT NULL;
ALTER TABLE SiteAttributeValues CHANGE avID avID INT UNSIGNED DEFAULT NULL;
ALTER TABLE SiteTypeAttributeValues CHANGE siteSkeletonID siteSkeletonID INT UNSIGNED DEFAULT NULL, CHANGE avID avID INT UNSIGNED DEFAULT NULL;
ALTER TABLE CalendarEventVersionAttributeValues CHANGE avID avID INT UNSIGNED DEFAULT NULL;
ALTER TABLE UserAttributeValues CHANGE avID avID INT UNSIGNED DEFAULT NULL;
ALTER TABLE ExpressEntityEntryAttributeValues CHANGE avID avID INT UNSIGNED DEFAULT NULL;
ALTER TABLE atSite CHANGE siteID siteID INT UNSIGNED DEFAULT NULL;
ALTER TABLE atDateTime CHANGE value value DATETIME DEFAULT NULL;
ALTER TABLE atDefault ADD CONSTRAINT FK_3484F81EA2A82A5D FOREIGN KEY (avID) REFERENCES AttributeValues (avID) ON DELETE CASCADE;
ALTER TABLE atSelectedTopics CHANGE avID avID INT UNSIGNED DEFAULT NULL;
ALTER TABLE atSelectedSocialLinks CHANGE serviceInfo serviceInfo VARCHAR(255) DEFAULT NULL, CHANGE avID avID INT UNSIGNED DEFAULT NULL;
ALTER TABLE atSelectedSocialLinks ADD CONSTRAINT FK_10743709A2A82A5D FOREIGN KEY (avID) REFERENCES atSocialLinks (avID);
ALTER TABLE atExpress ADD CONSTRAINT FK_CFAF40F1A2A82A5D FOREIGN KEY (avID) REFERENCES AttributeValues (avID) ON DELETE CASCADE;
ALTER TABLE atExpressSelectedEntries ADD CONSTRAINT FK_C9D404BBA2A82A5D FOREIGN KEY (avID) REFERENCES atExpress (avID);
ALTER TABLE atExpressSelectedEntries ADD CONSTRAINT FK_C9D404BB6DCB6296 FOREIGN KEY (exEntryID) REFERENCES ExpressEntityEntries (exEntryID);
ALTER TABLE atAddress CHANGE address1 address1 VARCHAR(255) DEFAULT NULL, CHANGE address2 address2 VARCHAR(255) DEFAULT NULL, CHANGE city city VARCHAR(255) DEFAULT NULL, CHANGE state_province state_province VARCHAR(255) DEFAULT NULL, CHANGE country country VARCHAR(255) DEFAULT NULL, CHANGE postal_code postal_code VARCHAR(255) DEFAULT NULL, CHANGE address3 address3 VARCHAR(255) DEFAULT NULL;
ALTER TABLE atSelectOptions CHANGE avSelectOptionListID avSelectOptionListID INT UNSIGNED DEFAULT NULL;
ALTER TABLE atSelectOptions ADD CONSTRAINT FK_797414B0CB59257C FOREIGN KEY (avSelectOptionListID) REFERENCES atSelectOptionLists (avSelectOptionListID);
ALTER TABLE atFile CHANGE fID fID INT UNSIGNED DEFAULT NULL;
ALTER TABLE atFile ADD CONSTRAINT FK_73D17D61A2A82A5D FOREIGN KEY (avID) REFERENCES AttributeValues (avID) ON DELETE CASCADE;
ALTER TABLE AttributeValues CHANGE akID akID INT UNSIGNED DEFAULT NULL;
ALTER TABLE AttributeValues ADD CONSTRAINT FK_DCCE7864B6561A7E FOREIGN KEY (akID) REFERENCES AttributeKeys (akID) ON DELETE CASCADE;
ALTER TABLE atNumber CHANGE value value NUMERIC(14, 4) DEFAULT NULL;
ALTER TABLE atNumber ADD CONSTRAINT FK_41BA30B5A2A82A5D FOREIGN KEY (avID) REFERENCES AttributeValues (avID) ON DELETE CASCADE;
ALTER TABLE CollectionAttributeValues CHANGE avID avID INT UNSIGNED DEFAULT NULL;
ALTER TABLE AttributeKeys CHANGE atID atID INT UNSIGNED DEFAULT NULL, CHANGE akCategoryID akCategoryID INT UNSIGNED DEFAULT NULL, CHANGE pkgID pkgID INT UNSIGNED DEFAULT NULL;
ALTER TABLE atSelectSettings CHANGE avSelectOptionListID avSelectOptionListID INT UNSIGNED DEFAULT NULL;
ALTER TABLE atAddressSettings CHANGE akDefaultCountry akDefaultCountry VARCHAR(255) DEFAULT NULL;
ALTER TABLE atUserGroupSettings ADD CONSTRAINT FK_C47871BEB6561A7E FOREIGN KEY (akID) REFERENCES AttributeKeys (akID);
ALTER TABLE atTextSettings CHANGE akTextPlaceholder akTextPlaceholder VARCHAR(255) DEFAULT NULL;
ALTER TABLE atExpressSettings CHANGE exEntityID exEntityID CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)';
ALTER TABLE atTextareaSettings CHANGE akTextareaDisplayMode akTextareaDisplayMode VARCHAR(255) DEFAULT NULL;
ALTER TABLE atBooleanSettings CHANGE checkboxLabel checkboxLabel VARCHAR(255) DEFAULT NULL;
ALTER TABLE SiteTypeAttributeKeys ADD CONSTRAINT FK_26C73776B6561A7E FOREIGN KEY (akID) REFERENCES AttributeKeys (akID) ON DELETE CASCADE;
ALTER TABLE ExpressAttributeKeys CHANGE entity_id entity_id CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)';
ALTER TABLE ExpressEntityEntryAssociations CHANGE association_id association_id CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)', CHANGE exEntryID exEntryID INT DEFAULT NULL;
ALTER TABLE ExpressEntityAssociationEntries CHANGE association_id association_id INT DEFAULT NULL, CHANGE exEntryID exEntryID INT DEFAULT NULL;
ALTER TABLE ExpressFormFieldSets CHANGE form_id form_id CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)', CHANGE title title VARCHAR(255) DEFAULT NULL;
ALTER TABLE ExpressEntityAssociations CHANGE target_entity_id target_entity_id CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)', CHANGE source_entity_id source_entity_id CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)', CHANGE target_property_name target_property_name VARCHAR(255) DEFAULT NULL, CHANGE inversed_by_property_name inversed_by_property_name VARCHAR(255) DEFAULT NULL, CHANGE association_type association_type VARCHAR(255) DEFAULT NULL;
ALTER TABLE ExpressEntities CHANGE default_view_form_id default_view_form_id CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)', CHANGE default_edit_form_id default_edit_form_id CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)', CHANGE plural_handle plural_handle VARCHAR(255) DEFAULT NULL, CHANGE label_mask label_mask VARCHAR(255) DEFAULT NULL, CHANGE result_column_set result_column_set LONGTEXT DEFAULT NULL COMMENT '(DC2Type:object)', CHANGE pkgID pkgID INT UNSIGNED DEFAULT NULL;
ALTER TABLE ExpressEntityEntries CHANGE exEntryEntityID exEntryEntityID CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)', CHANGE exEntryDateModified exEntryDateModified DATETIME DEFAULT NULL, CHANGE publicIdentifier publicIdentifier VARCHAR(255) DEFAULT NULL, CHANGE uID uID INT UNSIGNED DEFAULT NULL;
ALTER TABLE ExpressForms CHANGE entity_id entity_id CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)', CHANGE name name VARCHAR(255) DEFAULT NULL;
ALTER TABLE ExpressFormFieldSetAssociationControls CHANGE association_id association_id CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)', CHANGE association_entity_label_mask association_entity_label_mask VARCHAR(255) DEFAULT NULL;
ALTER TABLE ExpressFormFieldSetControls CHANGE field_set_id field_set_id INT DEFAULT NULL;
ALTER TABLE ExpressFormFieldSetAttributeKeyControls CHANGE akID akID INT UNSIGNED DEFAULT NULL;
ALTER TABLE ExpressFormFieldSetTextControls CHANGE headline headline VARCHAR(255) DEFAULT NULL;
ALTER TABLE IpAccessControlCategories CHANGE iaccTimeWindow iaccTimeWindow INT UNSIGNED DEFAULT NULL COMMENT 'The time window (in seconds) where the events should be counted (NULL means no limits)', CHANGE iaccBanDuration iaccBanDuration INT UNSIGNED DEFAULT NULL COMMENT 'The duration (in seconds) of the ban when the maximum number of events occur in the time window (NULL means forever)', CHANGE iaccPackage iaccPackage INT UNSIGNED DEFAULT NULL;
ALTER TABLE IpAccessControlCategories ADD CONSTRAINT FK_D4A10062C908ED51 FOREIGN KEY (iaccPackage) REFERENCES Packages (pkgID) ON DELETE CASCADE;
ALTER TABLE IpAccessControlRanges CHANGE iacrExpiration iacrExpiration DATETIME DEFAULT NULL COMMENT 'The date/time when this range expires (NULL means no expiration)', CHANGE iacrSite iacrSite INT UNSIGNED DEFAULT NULL;
ALTER TABLE IpAccessControlRanges ADD CONSTRAINT FK_2B1AA65D62009435 FOREIGN KEY (iacrSite) REFERENCES Sites (siteID) ON DELETE CASCADE;
ALTER TABLE PermissionAccessEntitySiteGroups CHANGE siteGID siteGID INT UNSIGNED DEFAULT NULL;
ALTER TABLE IpAccessControlEvents CHANGE iaceSite iaceSite INT UNSIGNED DEFAULT NULL;
ALTER TABLE IpAccessControlEvents ADD CONSTRAINT FK_6C004072B0C0DFA7 FOREIGN KEY (iaceSite) REFERENCES Sites (siteID) ON DELETE CASCADE;
ALTER TABLE Calendars CHANGE caName caName VARCHAR(255) DEFAULT NULL, CHANGE eventPageAttributeKeyHandle eventPageAttributeKeyHandle VARCHAR(255) DEFAULT NULL, CHANGE enableMoreDetails enableMoreDetails VARCHAR(1) DEFAULT NULL, CHANGE siteID siteID INT UNSIGNEDDEFAULT NULL;
ALTER TABLE CalendarEventVersionOccurrences CHANGE eventVersionID eventVersionID INT UNSIGNED DEFAULT NULL, CHANGE occurrenceID occurrenceID INT UNSIGNED DEFAULT NULL;
ALTER TABLE CalendarRelatedEvents CHANGE relationType relationType VARCHAR(1) DEFAULT NULL, CHANGE eventID eventID INT UNSIGNED DEFAULT NULL;
ALTER TABLE CalendarEvents CHANGE caID caID INT UNSIGNED DEFAULT NULL;
ALTER TABLE CalendarEventOccurrences CHANGE repetitionID repetitionID INT UNSIGNED DEFAULT NULL;
ALTER TABLE CalendarEventVersionRepetitions CHANGE eventVersionID eventVersionID INT UNSIGNED DEFAULT NULL, CHANGE repetitionID repetitionID INT UNSIGNED DEFAULT NULL;
ALTER TABLE CalendarEventVersions CHANGE evActivateDateTime evActivateDateTime DATETIME DEFAULT NULL, CHANGE evRelatedPageRelationType evRelatedPageRelationType VARCHAR(1) DEFAULT NULL, CHANGE eventID eventID INT UNSIGNED DEFAULT NULL, CHANGE uID uID INT UNSIGNED DEFAULT NULL;
ALTER TABLE SiteSkeletonTrees CHANGE skeletonLocaleID skeletonLocaleID INT UNSIGNED DEFAULT NULL, CHANGE siteTypeID siteTypeID INTUNSIGNED DEFAULT NULL

Messaggio di MySQL:
#1064 - Syntax error in SQL query close to 'DEFAULT NULL' line 1

:frowning:
help!

ok solved INTUNSIGNED - INT UNSIGNED
but i have a new error


ALTER TABLE atDefault ADD CONSTRAINT FK_3484F81EA2A82A5D FOREIGN KEY (avID) REFERENCES AttributeValues (avID) ON DELETE CASCADE

Messaggio di MySQL: Documentazione
#1826 - Duplicate FOREIGN KEY constraint name 'mydatabase/FK_3484F81EA2A82A5D'

seem the same error present in installation plugin step.

Ok Solved i have launched the script many time, any time i have removed the string that give error and the strings above.

at the end it seem working all.

enrico :sunglasses: