Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[2.3.0-beta1] Datenbank aktualisieren Exception #1436

Closed
Mynyx opened this issue May 3, 2015 · 1 comment
Closed

[2.3.0-beta1] Datenbank aktualisieren Exception #1436

Mynyx opened this issue May 3, 2015 · 1 comment
Labels
Milestone

Comments

@Mynyx
Copy link

Mynyx commented May 3, 2015

Fatal error: Uncaught exception Exception with message Query error: Duplicate entry '' for key 'uniqid' (ALTER TABLE tl_iso_product_collection ADD UNIQUE KEY uniqid (uniqid);) thrown in system/modules/core/library/Contao/Database/Statement.php on line 295
#0 system/modules/core/library/Contao/Database.php(207): Contao\Database\Statement->query('ALTER TABLE tl...') #1 system/modules/repository/classes/RepositoryManager.php(477): Contao\Database->query('ALTER TABLE tl...')
#2 system/modules/repository/classes/RepositoryBackendModule.php(153): RepositoryManager->update('database')
#3 system/modules/core/classes/BackendModule.php(98): RepositoryBackendModule->compile()
#4 system/modules/repository/classes/RepositoryBackendModule.php(72): Contao\BackendModule->generate()
#5 system/modules/repository/classes/RepositoryManager.php(57): RepositoryBackendModule->generate()
#6 system/modules/core/classes/Backend.php(423): RepositoryManager->generate()
#7 system/modules/core/controllers/BackendMain.php(131): Contao\Backend->getBackendModule('repository_mana...')
#8 contao/main.php(20): Contao\BackendMain->run()
#9 {main}

@zonky2
Copy link
Contributor

zonky2 commented May 10, 2016

I had the same error during the update by 2.2.4 to 2.3.5

Fatal error: Uncaught exception Exception with message Query error: Duplicate entry '' for key 'uniqid' (ALTER TABLE `tl_iso_product_collection` ADD UNIQUE KEY `uniqid` (`uniqid`);) thrown in system/modules/core/library/Contao/Database/Statement.php on line 295

#0 system/modules/core/library/Contao/Database.php(207): Contao\Database\Statement->query('ALTER TABLE `tl...')
#1 system/modules/repository/classes/RepositoryManager.php(477): Contao\Database->query('ALTER TABLE `tl...')
#2 system/modules/repository/classes/RepositoryBackendModule.php(153): RepositoryManager->update('database')
#3 system/modules/core/classes/BackendModule.php(98): RepositoryBackendModule->compile()
#4 system/modules/repository/classes/RepositoryBackendModule.php(72): Contao\BackendModule->generate()
#5 system/modules/repository/classes/RepositoryManager.php(57): RepositoryBackendModule->generate()
#6 system/modules/core/classes/Backend.php(423): RepositoryManager->generate()
#7 system/modules/core/controllers/BackendMain.php(131): Contao\Backend->getBackendModule('repository_mana...')
#8 contao/main.php(20): Contao\BackendMain->run()
#9 {main}

may be, you should update the db migration with
ALTER TABLE tl_iso_product_collectionCHANGEuniqid uniqid VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants