Forums

Site broken after back-up

Permalink
So I broke my site by changing the local language. Perfect, nothing worked.

That's exactly why there are back-ups, however, after using the back-up I got a error when updating to 8.5.2 from 8.4.3 (worked before)..

I'm getting the next error:
So I broke my site by changing the local language. Perfect, nothing worked.

That's exactly why there are back-ups, however, after using the back-up I got a error when updating to 8.5.2 from 8.4.3 (worked before)..

I'm getting the next error: 

Doctrine\DBAL\Exception\DriverException thrown with message "An exception occurred while executing 'CREATE TABLE ExpressFormFieldSetControls (id CHAR(36) NOT NULL COMMENT '(DC2Type:guid)', is_required TINYINT(1) NOT NULL, position INT NOT NULL, custom_label LONGTEXT DEFAULT NULL, field_set_id INT DEFAULT NULL, type VARCHAR(255) NOT NULL, INDEX IDX_E42868A43ABF811A (field_set_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB':
SQLSTATE[HY000]: General error: 1005 Can't create table `id2174_conc1`.`ExpressFormFieldSetControls` (errno: 150 "Foreign key constraint is incorrectly formed")"
Stacktrace:
#23 Doctrine\DBAL\Exception\DriverException in /home/id2174/domains/MYDOMAINNAME/public_html/updates/concrete5-8.5.2/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115
#22 Doctrine\DBAL\Driver\AbstractMySQLDriver:convertException in /home/id2174/domains/MYDOMAINNAME/public_html/updates/concrete5-8.5.2/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:128
#21 Doctrine\DBAL\DBALException:driverExceptionDuringQuery in /home/id2174/domains/MYDOMAINNAME/public_html/updates/concrete5-8.5.2/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:855
#20 Doctrine\DBAL\Driver\PDOException in /home/id2174/domains/MYDOMAINNAME/public_html/updates/concrete5-8.5.2/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106
#19 PDOException in /home/id2174/domains/MYDOMAINNAME/public_html/updates/concrete5-8.5.2/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104
#18 PDO:query in /home/id2174/domains/MYDOMAINNAME/public_html/updates/concrete5-8.5.2/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104
#17 Doctrine\DBAL\Driver\PDOConnection:query in /home/id2174/domains/MYDOMAINNAME/public_html/updates/concrete5-8.5.2/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:852
#16 Doctrine\DBAL\Connection:executeQuery in /home/id2174/domains/MYDOMAINNAME/public_html/updates/concrete5-8.5.2/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php:843
#15 Doctrine\ORM\Tools\SchemaTool:updateSchema in /home/id2174/domains/MYDOMAINNAME/public_html/updates/concrete5-8.5.2/concrete/src/Updater/Migrations/AbstractMigration.php:125
#14 Concrete\Core\Updater\Migrations\AbstractMigration:refreshEntities in /home/id2174/domains/MYDOMAINNAME/public_html/updates/concrete5-8.5.2/concrete/src/Updater/Migrations/Migrations/Version20180904165911.php:19
#13 Concrete\Core\Updater\Migrations\Migrations\Version20180904165911:upgradeDatabase in /home/id2174/domains/MYDOMAINNAME/public_html/updates/concrete5-8.5.2/concrete/src/Updater/Migrations/AbstractMigration.php:84
#12 Concrete\Core\Updater\Migrations\AbstractMigration:postUp in /home/id2174/domains/MYDOMAINNAME/public_html/updates/concrete5-8.5.2/concrete/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Version.php:297
Viewing 15 lines of 27 lines. View entire code block.


What can I do?? Start over or is it possible to fix this?
FischerVision
 
hutman replied on at Permalink Reply
hutman
Did you restore your database backup after the language site break incident? If so, did you remove all the tables then import the backup?