DB Backup – Installtool "Es ist ein Fehler aufgetreten"

**Filip** · 31.10.2019, 16:17

Hallo!

Nachdem ich ausversehen meine Datenbank gelöscht habe (da war ich zu schnell bei der falschen datenbank), habe ich ein Datenbank Backup hochgeladen, und bekomme jetzt leider mehrere Fehler mit dem Backup.

Wenn ich bspw. das Installtool aufrufe erwartet mich das hier:

Code:

[2019-11-04 10:31:48] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction","_route":"contao_install"},"request_uri":"http://bokelaweb/contao/install","method":"GET"} []
[2019-11-04 10:31:49] app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing '\n            ALTER TABLE\n                tl_newsletter_recipients\n            DROP INDEX\n                pid,\n            ADD UNIQUE KEY\n                pid_email (pid, email)\n        ':\n\nSQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'pid'; check that column/key exists at /Applications/MAMP/htdocs/bokela/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'pid'; check that column/key exists at /Applications/MAMP/htdocs/bokela/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'pid'; check that column/key exists at /Applications/MAMP/htdocs/bokela/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"} []

Und sobald ich Elemente erstelle – und zwar das ich beim zweiten Element einen Datenbank Fehler bekomme, der aussagt das ich keine 2x Elemente erstellen kenn mit dem Primary Key 0.

Hat jemand einen Tipp wie ich das Problem beheben kann?

Dankeschön im vorraus.

**Filip** · 04.11.2019, 10:57

Ich habe mal das Installtool im Debug Modus geöffnet. (app_dev.php)

Bitte verzeiht mir wenn ich den Stacktrace falsch formartiert poste, bin das erste mal im Debug Modus.

Code:

An exception occurred while executing '
ALTER TABLE
tl_newsletter_recipients
DROP INDEX
pid,
ADD UNIQUE KEY
pid_email (pid, email)
':

SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'pid'; check that column/key exists

    Exceptions 3 Logs 2 Stack Traces 3 

Doctrine\DBAL\Exception\ DriverException
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php (line 106)
AbstractMySQLDriver->convertException('An exception occurred while executing \' ALTER TABLE tl_newsletter_recipients DROP INDEX pid, ADD UNIQUE KEY pid_email (pid, email) \':SQLSTATE[42000]: Syntax error or access violation: 1091 Can\'t DROP \'pid\'; check that column/key exists', object(PDOException)) in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php (line 166)
DBALException::wrapException(object(Driver), object(PDOException), 'An exception occurred while executing \' ALTER TABLE tl_newsletter_recipients DROP INDEX pid, ADD UNIQUE KEY pid_email (pid, email) \':SQLSTATE[42000]: Syntax error or access violation: 1091 Can\'t DROP \'pid\'; check that column/key exists') in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php (line 146)
DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), ' ALTER TABLE tl_newsletter_recipients DROP INDEX pid, ADD UNIQUE KEY pid_email (pid, email) ') in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php (line 1017)
Connection->query(' ALTER TABLE tl_newsletter_recipients DROP INDEX pid, ADD UNIQUE KEY pid_email (pid, email) ') in vendor/contao/installation-bundle/src/Database/Version447Update.php (line 123)
Version447Update->run() in vendor/contao/installation-bundle/src/Controller/InstallationController.php (line 380)
InstallationController->runDatabaseUpdates() in vendor/contao/installation-bundle/src/Controller/InstallationController.php (line 100)
InstallationController->installAction() in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 151)
HttpKernel->handleRaw(object(Request), 1) in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 68)
HttpKernel->handle(object(Request), 1, true) in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php (line 200)
Kernel->handle(object(Request)) in web/app_dev.php (line 69)

    Request::enableHttpMethodParameterOverride();
    // Handle the request
    $request = Request::createFromGlobals();
    $response = $kernel->handle($request);
    $response->send();
    $kernel->terminate($request, $response);

Doctrine\DBAL\Driver\ PDOException

SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'pid'; check that column/key exists
PDOException

SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'pid'; check that column/key exists

**Spooky** · 04.11.2019, 11:16

Im Debug Modus hast du im Fehlerfall 3 Tabs. Click auf den Tab "Stack Trace" und poste den Textinhalt des Stack Traces der jeweiligen Exception.

**Filip** · 04.11.2019, 11:28

Zitat von Spooky

Im Debug Modus hast du im Fehlerfall 3 Tabs. Click auf den Tab "Stack Trace" und poste den Textinhalt des Stack Traces der jeweiligen Exception.

Okay danke für den Tipp!

3/3 DriverException

Code:

Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing '
            ALTER TABLE
                tl_newsletter_recipients
            DROP INDEX
                pid,
            ADD UNIQUE KEY
                pid_email (pid, email)
        ':

SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'pid'; check that column/key exists

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106
  at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred while executing \'            ALTER TABLE                tl_newsletter_recipients            DROP INDEX                pid,            ADD UNIQUE KEY                pid_email (pid, email)        \':SQLSTATE[42000]: Syntax error or access violation: 1091 Can\'t DROP \'pid\'; check that column/key exists', object(PDOException))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:166)
  at Doctrine\DBAL\DBALException::wrapException(object(Driver), object(PDOException), 'An exception occurred while executing \'            ALTER TABLE                tl_newsletter_recipients            DROP INDEX                pid,            ADD UNIQUE KEY                pid_email (pid, email)        \':SQLSTATE[42000]: Syntax error or access violation: 1091 Can\'t DROP \'pid\'; check that column/key exists')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:146)
  at Doctrine\DBAL\DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), '            ALTER TABLE                tl_newsletter_recipients            DROP INDEX                pid,            ADD UNIQUE KEY                pid_email (pid, email)        ')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1017)
  at Doctrine\DBAL\Connection->query('            ALTER TABLE                tl_newsletter_recipients            DROP INDEX                pid,            ADD UNIQUE KEY                pid_email (pid, email)        ')
     (vendor/contao/installation-bundle/src/Database/Version447Update.php:123)
  at Contao\InstallationBundle\Database\Version447Update->run()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:380)
  at Contao\InstallationBundle\Controller\InstallationController->runDatabaseUpdates()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:100)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/app_dev.php:69)

PDOException

Code:

Doctrine\DBAL\Driver\PDOException:
SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'pid'; check that column/key exists

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80
  at Doctrine\DBAL\Driver\PDOConnection->query('            ALTER TABLE                tl_newsletter_recipients            DROP INDEX                pid,            ADD UNIQUE KEY                pid_email (pid, email)        ')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1015)
  at Doctrine\DBAL\Connection->query('            ALTER TABLE                tl_newsletter_recipients            DROP INDEX                pid,            ADD UNIQUE KEY                pid_email (pid, email)        ')
     (vendor/contao/installation-bundle/src/Database/Version447Update.php:123)
  at Contao\InstallationBundle\Database\Version447Update->run()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:380)
  at Contao\InstallationBundle\Controller\InstallationController->runDatabaseUpdates()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:100)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/app_dev.php:69)

PDOException

Code:

PDOException:
SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'pid'; check that column/key exists

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75
  at PDO->query('            ALTER TABLE                tl_newsletter_recipients            DROP INDEX                pid,            ADD UNIQUE KEY                pid_email (pid, email)        ')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)
  at Doctrine\DBAL\Driver\PDOConnection->query('            ALTER TABLE                tl_newsletter_recipients            DROP INDEX                pid,            ADD UNIQUE KEY                pid_email (pid, email)        ')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1015)
  at Doctrine\DBAL\Connection->query('            ALTER TABLE                tl_newsletter_recipients            DROP INDEX                pid,            ADD UNIQUE KEY                pid_email (pid, email)        ')
     (vendor/contao/installation-bundle/src/Database/Version447Update.php:123)
  at Contao\InstallationBundle\Database\Version447Update->run()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:380)
  at Contao\InstallationBundle\Controller\InstallationController->runDatabaseUpdates()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:100)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/app_dev.php:69)

**Spooky** · 04.11.2019, 11:30

Wie alt war das Backup? Laut dieser Fehlermeldung fehlt die Tabellenspalte "pid" von "tl_newsletter_recipients".

**Filip** · 04.11.2019, 11:33

Zitat von Spooky

Wie alt war das Backup? Laut dieser Fehlermeldung fehlt die Tabellenspalte "pid" von "tl_newsletter_recipients".

Das Backup war vom 22.10.2019. Für mich scheint es so als ob am Backup irgendwas kaputt sein könnte.

Davor lief die Installation normal und ich konnte auch das Installtool erreichen.

**Spooky** · 04.11.2019, 11:35

Hast du seit dem 22.10. etwas an der Installation geändert/aktualisiert?

Hat die Tabelle tl_newsletter_recipients bei dir relevante Daten? Wenn nicht könntest du mal die ganze Tabelle löschen.

**Filip** · 04.11.2019, 11:40

Zitat von Spooky

Hast du seit dem 22.10. etwas an der Installation geändert/aktualisiert?

Hat die Tabelle tl_newsletter_recipients bei dir relevante Daten? Wenn nicht könntest du mal die ganze Tabelle löschen.

Die hat bei mir gar nichts drin. Ich lösche sie dann einfach mal komplett.

**Spooky** · 04.11.2019, 11:46

Wenn du den Contao Newsletter nicht brauchst, solltest du das Newsletter Bundle deinstallieren

**Filip** · 04.11.2019, 11:48

Zitat von Spooky

Wenn du den Contao Newsletter nicht brauchst, solltest du das Newsletter Bundle deinstallieren

Habe ich jetzt mal deeinstalliert.

UPDATE:

Ich habe die Tabelle tl_newsletter gelöscht. Jetzt kann ich das Installtool öffnen und das möchte ganz viel bei mir updaten:

Code:

Spalten ändern
	Alle auswählen
	

ALTER TABLE `cc_accommodations` CHANGE `ptable` `ptable` varchar(64) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `name` `name` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `description` `description` mediumtext NULL;

	

ALTER TABLE `cc_accommodations` CHANGE `short_description` `short_description` mediumtext NULL;

	

ALTER TABLE `cc_accommodations` CHANGE `gallery_size` `gallery_size` varchar(64) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `gallery_fullsize` `gallery_fullsize` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `geo_data` `geo_data` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `geo_data_street` `geo_data_street` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `geo_data_city` `geo_data_city` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `geo_data_zipcode` `geo_data_zipcode` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `geo_data_country` `geo_data_country` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `stay` `stay` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `size` `size` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `cancellation` `cancellation` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `check_in` `check_in` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `check_out` `check_out` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `list_wifi` `list_wifi` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `list_accessibility` `list_accessibility` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `list_restaurant` `list_restaurant` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `list_cabel_tv` `list_cabel_tv` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `arrival` `arrival` varchar(10) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `departure` `departure` varchar(10) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `additional_desc` `additional_desc` mediumtext NULL;

	

ALTER TABLE `cc_accommodations` CHANGE `slider` `slider` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `teaser` `teaser` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `highlight` `highlight` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `publish` `publish` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `rating` `rating` char(1) NOT NULL default '1';

	

ALTER TABLE `cc_accommodations` CHANGE `rating_value` `rating_value` varchar(6) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `rating_counter` `rating_counter` varchar(6) NOT NULL default '';

	

ALTER TABLE `cc_immorealty` CHANGE `ptable` `ptable` varchar(64) NOT NULL default '';

	

ALTER TABLE `cc_immorealty` CHANGE `name` `name` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_immorealty` CHANGE `description` `description` mediumtext NULL;

	

ALTER TABLE `cc_immorealty` CHANGE `unterseite` `unterseite` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_immorealty` CHANGE `top_object` `top_object` char(1) NOT NULL default '';

	

ALTER TABLE `cc_immorealty` CHANGE `notelist` `notelist` char(1) NOT NULL default '';

	

ALTER TABLE `cc_immorealty` CHANGE `publish` `publish` char(1) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `ptable` `ptable` varchar(64) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `item_number` `item_number` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `name` `name` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `subheadline` `subheadline` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `stock` `stock` varchar(64) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `description` `description` mediumtext NULL;

	

ALTER TABLE `cc_product_catalog` CHANGE `short_description` `short_description` mediumtext NULL;

	

ALTER TABLE `cc_product_catalog` CHANGE `additional_desc` `additional_desc` mediumtext NULL;

	

ALTER TABLE `cc_product_catalog` CHANGE `producer_number` `producer_number` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `meta_description` `meta_description` mediumtext NULL;

	

ALTER TABLE `cc_product_catalog` CHANGE `highlight` `highlight` char(1) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `rating` `rating` char(1) NOT NULL default '1';

	

ALTER TABLE `cc_product_catalog` CHANGE `rating_value` `rating_value` varchar(6) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `rating_counter` `rating_counter` varchar(6) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `publish` `publish` char(1) NOT NULL default '';

Spalten anlegen
	Alle auswählen
	

CREATE INDEX path ON tl_files (
  path(333)
)

	

ALTER TABLE tl_log ADD PRIMARY KEY (id)

	

ALTER TABLE tl_member_group ADD PRIMARY KEY (id)

	

ALTER TABLE tl_module ADD PRIMARY KEY (id)

	

ALTER TABLE tl_nc_gateway ADD PRIMARY KEY (id)

	

CREATE INDEX queue_croninterval ON tl_nc_gateway (queue_croninterval)

	

ALTER TABLE tl_nc_language ADD PRIMARY KEY (id)

	

CREATE INDEX pid ON tl_nc_language (pid)

	

CREATE INDEX language ON tl_nc_language (language)

	

ALTER TABLE tl_nc_message ADD PRIMARY KEY (id)

	

CREATE INDEX pid ON tl_nc_message (pid)

	

ALTER TABLE tl_nc_notification ADD PRIMARY KEY (id)

	

ALTER TABLE tl_nc_queue ADD PRIMARY KEY (id)

	

CREATE INDEX message ON tl_nc_queue (message)

	

CREATE INDEX sourcequeue ON tl_nc_queue (sourcequeue)

	

CREATE INDEX targetgateway ON tl_nc_queue (targetgateway)

	

ALTER TABLE tl_news ADD PRIMARY KEY (id)

	

CREATE INDEX alias ON tl_news (alias)

	

CREATE INDEX pid_start_stop_published ON tl_news (pid, start, stop, published)

	

ALTER TABLE tl_news_archive ADD PRIMARY KEY (id)

	

ALTER TABLE tl_news_feed ADD PRIMARY KEY (id)

	

CREATE INDEX alias ON tl_news_feed (alias)

	

ALTER TABLE tl_page ADD PRIMARY KEY (id)

	

CREATE INDEX alias ON tl_page (alias)

	

CREATE INDEX pid_type_start_stop_published ON tl_page (pid, type, start, stop, published)

	

CREATE INDEX languagemain ON tl_page (languagemain)

	

ALTER TABLE tl_pct_customcatalog ADD PRIMARY KEY (id)

	

CREATE INDEX pid ON tl_pct_customcatalog (pid)

	

ALTER TABLE tl_pct_customcatalog_api ADD PRIMARY KEY (id)

	

CREATE INDEX pid ON tl_pct_customcatalog_api (pid)

	

ALTER TABLE tl_pct_customcatalog_job ADD PRIMARY KEY (id)

	

CREATE INDEX pid ON tl_pct_customcatalog_job (pid)

	

CREATE INDEX id ON tl_pct_customcatalog_language (id)

	

CREATE INDEX pid ON tl_pct_customcatalog_language (pid)

	

ALTER TABLE tl_pct_customelement ADD PRIMARY KEY (id)

	

CREATE INDEX alias ON tl_pct_customelement (alias)

	

ALTER TABLE tl_pct_customelement_attribute ADD PRIMARY KEY (id)

	

CREATE INDEX pid ON tl_pct_customelement_attribute (pid)

	

ALTER TABLE tl_pct_customelement_filter ADD PRIMARY KEY (id)

	

CREATE INDEX pid ON tl_pct_customelement_filter (pid)

	

ALTER TABLE tl_pct_customelement_filterset ADD PRIMARY KEY (id)

	

CREATE INDEX pid ON tl_pct_customelement_filterset (pid)

	

ALTER TABLE tl_pct_customelement_group ADD PRIMARY KEY (id)

	

CREATE INDEX pid ON tl_pct_customelement_group (pid)

	

CREATE INDEX tstamp ON tl_pct_customelement_group (tstamp)

	

ALTER TABLE tl_pct_customelement_groupset ADD PRIMARY KEY (id)

	

CREATE INDEX pid ON tl_pct_customelement_groupset (pid)

	

ALTER TABLE tl_pct_customelement_plugin ADD PRIMARY KEY (id)

	

ALTER TABLE tl_pct_customelement_tags ADD PRIMARY KEY (id)

	

CREATE INDEX pid ON tl_pct_customelement_tags (pid)

	

ALTER TABLE tl_pct_customelement_vault ADD PRIMARY KEY (id)

	

CREATE INDEX pid ON tl_pct_customelement_vault (pid)

	

CREATE INDEX source ON tl_pct_customelement_vault (source)

	

ALTER TABLE tl_pct_themedesigner ADD PRIMARY KEY (id)

	

ALTER TABLE tl_revolutionslider ADD PRIMARY KEY (id)

	

CREATE INDEX tstamp ON tl_revolutionslider (tstamp)

	

ALTER TABLE tl_revolutionslider_slides ADD PRIMARY KEY (id)

	

CREATE INDEX pid ON tl_revolutionslider_slides (pid)

	

ALTER TABLE tl_search ADD PRIMARY KEY (id)

	

CREATE UNIQUE INDEX url ON tl_search (url)

	

CREATE UNIQUE INDEX checksum_pid ON tl_search (checksum, pid)

	

ALTER TABLE tl_search_index ADD PRIMARY KEY (id)

	

CREATE INDEX pid ON tl_search_index (pid)

	

CREATE INDEX word ON tl_search_index (word)

	

ALTER TABLE tl_session ADD PRIMARY KEY (id)

	

CREATE INDEX pid ON tl_session (pid)

	

CREATE UNIQUE INDEX hash ON tl_session (hash)

	

ALTER TABLE tl_style ADD PRIMARY KEY (id)

	

CREATE INDEX pid ON tl_style (pid)

	

ALTER TABLE tl_style_sheet ADD PRIMARY KEY (id)

	

CREATE UNIQUE INDEX name ON tl_style_sheet (name)

	

ALTER TABLE tl_theme ADD PRIMARY KEY (id)

	

ALTER TABLE tl_undo ADD PRIMARY KEY (id)

	

ALTER TABLE tl_user ADD PRIMARY KEY (id)

	

CREATE UNIQUE INDEX username ON tl_user (username)

	

CREATE INDEX email ON tl_user (email)

	

ALTER TABLE tl_user_group ADD PRIMARY KEY (id)

	

ALTER TABLE tl_version ADD PRIMARY KEY (id)

	

CREATE INDEX pid ON tl_version (pid)

	

CREATE INDEX fromtable ON tl_version (fromtable)

Wenn ich die Datenbank aktualisiere bekomme ich wieder einen Fehler:

Code:

Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing 'CREATE INDEX path ON tl_files (path(333))':

SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'path'

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106
  at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred while executing \'CREATE INDEX path ON tl_files (path(333))\':SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name \'path\'', object(PDOException))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:166)
  at Doctrine\DBAL\DBALException::wrapException(object(Driver), object(PDOException), 'An exception occurred while executing \'CREATE INDEX path ON tl_files (path(333))\':SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name \'path\'')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:146)
  at Doctrine\DBAL\DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), 'CREATE INDEX path ON tl_files (path(333))')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1017)
  at Doctrine\DBAL\Connection->query('CREATE INDEX path ON tl_files (path(333))')
     (vendor/contao/installation-bundle/src/Database/Installer.php:80)
  at Contao\InstallationBundle\Database\Installer->execCommand('5d853cc50d676e6a95c8c8d617814bd3')
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:414)
  at Contao\InstallationBundle\Controller\InstallationController->adjustDatabaseTables()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:102)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/app_dev.php:69)

Code:

Doctrine\DBAL\Driver\PDOException:
SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'path'

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80
  at Doctrine\DBAL\Driver\PDOConnection->query('CREATE INDEX path ON tl_files (path(333))')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1015)
  at Doctrine\DBAL\Connection->query('CREATE INDEX path ON tl_files (path(333))')
     (vendor/contao/installation-bundle/src/Database/Installer.php:80)
  at Contao\InstallationBundle\Database\Installer->execCommand('5d853cc50d676e6a95c8c8d617814bd3')
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:414)
  at Contao\InstallationBundle\Controller\InstallationController->adjustDatabaseTables()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:102)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/app_dev.php:69)

Code:

PDOException:
SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'path'

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75
  at PDO->query('CREATE INDEX path ON tl_files (path(333))')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)
  at Doctrine\DBAL\Driver\PDOConnection->query('CREATE INDEX path ON tl_files (path(333))')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1015)
  at Doctrine\DBAL\Connection->query('CREATE INDEX path ON tl_files (path(333))')
     (vendor/contao/installation-bundle/src/Database/Installer.php:80)
  at Contao\InstallationBundle\Database\Installer->execCommand('5d853cc50d676e6a95c8c8d617814bd3')
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:414)
  at Contao\InstallationBundle\Controller\InstallationController->adjustDatabaseTables()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:102)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/app_dev.php:69)

Wenn ich dann die Seite wieder refreshe, komme ich normal ins Installtool und kann wieder die Spalten auswählen die ich updaten will.

Scheint für mich so, als ob es die Spalten nicht updated.

**Filip** · 04.11.2019, 15:53

Hat noch jemand eine Idee wie ich die Fehlermeldung umgehen kann und die Tabellen wieder reparieren kann? Anscheinend war leider etwas bei dem backup futsch, da scheinen überall die Primary Keys zu fehlen.

**BugBuster** · 04.11.2019, 17:57

Da ist aber mehr im Eimer. Wenn Doctrine mit "CREATE INDEX path ON tl_files (path(333))" einen Index anlegen will und die Meldung kommt, "Duplicate key name 'path'", heißt das ja, er wäre schon da und will nochmal angelegt werden.
Schonmal den Cache gelöscht? Irgendwas ist da nicht synchron.

**Filip** · 05.11.2019, 11:56

Zitat von BugBuster

Da ist aber mehr im Eimer. Wenn Doctrine mit "CREATE INDEX path ON tl_files (path(333))" einen Index anlegen will und die Meldung kommt, "Duplicate key name 'path'", heißt das ja, er wäre schon da und will nochmal angelegt werden.
Schonmal den Cache gelöscht? Irgendwas ist da nicht synchron.

Ich habe den Cache inzwischen schon mehrmals gelöscht. Habe auch alle Updates über den Manager installiert, sowie den Composer Installer/Update ausgeführt.

Im moment läuft die Installation lokal auf Mamp. Leider habe ich ja die aktuelle Datenbank gelöscht und hatte nur dieses eine Backup (etwa. eine Woche älter als der zeitpunkt an dem ich das aktuelle gelöscht habe).

Hast du eine Idee wie ich das wieder syncron kriegen kann?

**Spooky** · 05.11.2019, 11:58

Du könntest den path Index von tl_files manuell löschen. Bzw. jeden Index, wo dieses Problem auftritt.

**Filip** · 05.11.2019, 12:10

Zitat von Spooky

Du könntest den path Index von tl_files manuell löschen. Bzw. jeden Index, wo dieses Problem auftritt.

Wenn ich das mache, dann zeigt es mir als erstes einen Fehler in der Tabelle "tl_log" an.

Code:

Doctrine\DBAL\Exception\UniqueConstraintViolationException:
An exception occurred while executing 'ALTER TABLE tl_log ADD PRIMARY KEY (id)':

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:55
  at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred while executing \'ALTER TABLE tl_log ADD PRIMARY KEY (id)\':SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry \'0\' for key \'PRIMARY\'', object(PDOException))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:166)
  at Doctrine\DBAL\DBALException::wrapException(object(Driver), object(PDOException), 'An exception occurred while executing \'ALTER TABLE tl_log ADD PRIMARY KEY (id)\':SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry \'0\' for key \'PRIMARY\'')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:146)
  at Doctrine\DBAL\DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), 'ALTER TABLE tl_log ADD PRIMARY KEY (id)')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1017)
  at Doctrine\DBAL\Connection->query('ALTER TABLE tl_log ADD PRIMARY KEY (id)')
     (vendor/contao/installation-bundle/src/Database/Installer.php:80)
  at Contao\InstallationBundle\Database\Installer->execCommand('b1ae659163fee5c32f4854c488755063')
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:414)
  at Contao\InstallationBundle\Controller\InstallationController->adjustDatabaseTables()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:102)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/app_dev.php:69)

Wenn ich in der tl_log versuche den PRIMARY KEY anzupassen zeigt mir das Installtool leider wieder den Fehler von tl_files an, also die "tl_files" wird wieder automatisch angepasst und Contao erkennt das direkt als Fehler an?

**Spooky** · 05.11.2019, 12:19

Du hast Einträge mit der ID 0 in deiner Datenbank. Lösche einfach tl_log.

**Filip** · 05.11.2019, 12:25

Zitat von Spooky

Du hast Einträge mit der ID 0 in deiner Datenbank. Lösche einfach tl_log.

Also muss ich hier jetzt wahrscheinlich durch alle Datenbank Änderungen die das Installtool vorschlägt einzelnd durch?
Wenn ich diese Änderungen mit dem Installtool wieder umsetze, wie bspw. folgendens, dann zeigt es mir nach der aktualisierung wieder den Fehler an.

Code:

CREATE INDEX path ON tl_files (
  path(333)
)

Bringt das in diesem Fall überhaupt etwas zur Lösung des Problems, oder zerschieße ich die Datenbank nicht automatisch wenn ich sie wieder aktualisiere?

**Filip** · 05.11.2019, 12:29

Zitat von Filip

Also muss ich hier jetzt wahrscheinlich durch alle Datenbank Änderungen die das Installtool vorschlägt einzelnd durch?
Wenn ich diese Änderungen mit dem Installtool wieder umsetze, wie bspw. folgendens, dann zeigt es mir nach der aktualisierung wieder den Fehler an.

Code:

CREATE INDEX path ON tl_files (
  path(333)
)

Bringt das in diesem Fall überhaupt etwas zur Lösung des Problems, oder zerschieße ich die Datenbank nicht automatisch wenn ich sie wieder aktualisiere?

UPDATE: Habe jetzt noch tl_search_index gelöscht, weil da der gleiche Fehler aufgetaucht ist.

Jetzt kommt kein Fehler mehr beim klicken auf "Datenbank aktualisieren", aber die Datenbank updatet auch nicht wirklich - sondern die Seite aktualisiert sich nur und hat immer noch die gleichen Einträge drin.

Code:

Spalten ändern
	Alle auswählen
	

ALTER TABLE `cc_accommodations` CHANGE `ptable` `ptable` varchar(64) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `name` `name` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `description` `description` mediumtext NULL;

	

ALTER TABLE `cc_accommodations` CHANGE `short_description` `short_description` mediumtext NULL;

	

ALTER TABLE `cc_accommodations` CHANGE `gallery_size` `gallery_size` varchar(64) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `gallery_fullsize` `gallery_fullsize` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `geo_data` `geo_data` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `geo_data_street` `geo_data_street` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `geo_data_city` `geo_data_city` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `geo_data_zipcode` `geo_data_zipcode` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `geo_data_country` `geo_data_country` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `stay` `stay` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `size` `size` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `cancellation` `cancellation` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `check_in` `check_in` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `check_out` `check_out` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `list_wifi` `list_wifi` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `list_accessibility` `list_accessibility` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `list_restaurant` `list_restaurant` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `list_cabel_tv` `list_cabel_tv` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `arrival` `arrival` varchar(10) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `departure` `departure` varchar(10) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `additional_desc` `additional_desc` mediumtext NULL;

	

ALTER TABLE `cc_accommodations` CHANGE `slider` `slider` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `teaser` `teaser` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `highlight` `highlight` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `publish` `publish` char(1) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `rating` `rating` char(1) NOT NULL default '1';

	

ALTER TABLE `cc_accommodations` CHANGE `rating_value` `rating_value` varchar(6) NOT NULL default '';

	

ALTER TABLE `cc_accommodations` CHANGE `rating_counter` `rating_counter` varchar(6) NOT NULL default '';

	

ALTER TABLE `cc_immorealty` CHANGE `ptable` `ptable` varchar(64) NOT NULL default '';

	

ALTER TABLE `cc_immorealty` CHANGE `name` `name` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_immorealty` CHANGE `description` `description` mediumtext NULL;

	

ALTER TABLE `cc_immorealty` CHANGE `unterseite` `unterseite` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_immorealty` CHANGE `top_object` `top_object` char(1) NOT NULL default '';

	

ALTER TABLE `cc_immorealty` CHANGE `notelist` `notelist` char(1) NOT NULL default '';

	

ALTER TABLE `cc_immorealty` CHANGE `publish` `publish` char(1) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `ptable` `ptable` varchar(64) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `item_number` `item_number` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `name` `name` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `subheadline` `subheadline` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `stock` `stock` varchar(64) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `description` `description` mediumtext NULL;

	

ALTER TABLE `cc_product_catalog` CHANGE `short_description` `short_description` mediumtext NULL;

	

ALTER TABLE `cc_product_catalog` CHANGE `additional_desc` `additional_desc` mediumtext NULL;

	

ALTER TABLE `cc_product_catalog` CHANGE `producer_number` `producer_number` varchar(255) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `meta_description` `meta_description` mediumtext NULL;

	

ALTER TABLE `cc_product_catalog` CHANGE `highlight` `highlight` char(1) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `rating` `rating` char(1) NOT NULL default '1';

	

ALTER TABLE `cc_product_catalog` CHANGE `rating_value` `rating_value` varchar(6) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `rating_counter` `rating_counter` varchar(6) NOT NULL default '';

	

ALTER TABLE `cc_product_catalog` CHANGE `publish` `publish` char(1) NOT NULL default '';

Spalten anlegen
	Alle auswählen
	

CREATE INDEX path ON tl_files (
  path(333)
)

UPDATE 2:
Also man kann im Installtool sehen das es eigentlich nur noch Sachen für das Plugin CC sind, die hier umgesetzt werden müssen.

Komischerweise kann ich aber trotzdem keine Inhaltselemente erstellen, weil Contao immer den PRIMARY KEY 0 in der Tabelle "tl_content" vergibt.

Code:

[2019-11-05 12:32:01] app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\\DBAL\\Exception\\UniqueConstraintViolationException(code: 0): An exception occurred while executing 'INSERT INTO tl_content (`autogrid_mode`, `type`, `floating`, `sortOrder`, `perRow`, `sliderStartSlide`, `revolutionslider_data_start`, `revolutionslider_data_delay`, `revolutionslider_data_animation_start`, `revolutionslider_data_animation_end`, `revolutionslider_data_opacity`, `revolutionslider_text_fontsize`, `revolutionslider_data_start_OUT`, `revolutionslider_data_opacity_OUT`, `revolutionslider_data_delay_OUT`, `dlh_googlemap_template`, `dlh_googlemap_zoom`, `dlh_googlemap_size`, `dlh_googlemap_protected`, `com_order`, `com_template`, `pid`, `sorting`, `ptable`, `tstamp`) VALUES ('auto', 'text', 'above', 'ascending', 4, 0, 0, 0, 'fade', 'fadeout', '100', '14', 0, '100', 0, 'ce_dlh_googlemaps_default', '10', 'a:3:{i:0;i:16;i:1;i:9;i:2;s:12:\\\"proportional\\\";}', '', 'ascending', 'com_default', 0, 0, 'tl_article', 0)':\n\nSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' at /Applications/MAMP/htdocs/bokela/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:55, Doctrine\\DBAL\\Driver\\PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' at /Applications/MAMP/htdocs/bokela/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' at /Applications/MAMP/htdocs/bokela/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"} []

**Filip** · 06.11.2019, 08:46

Zitat von Spooky

Du könntest den path Index von tl_files manuell löschen. Bzw. jeden Index, wo dieses Problem auftritt.

Ich habe jetzt mal den Stacktrace kopiert, den ich bekomme wenn ich versuche ein Element zu erstellen.

Ich bin leider vollkommen überfragt, gerne probiere ich auch nochmal alles aus was die mögliche Ursache sein könnte. Die Seite ist von einem Kunden und ich muss da nächste Woche den Kunden dazu schulen…

Code:

Doctrine\DBAL\Exception\UniqueConstraintViolationException:
An exception occurred while executing 'INSERT INTO tl_content (`autogrid_mode`, `type`, `floating`, `sortOrder`, `perRow`, `sliderStartSlide`, `revolutionslider_data_start`, `revolutionslider_data_delay`, `revolutionslider_data_animation_start`, `revolutionslider_data_animation_end`, `revolutionslider_data_opacity`, `revolutionslider_text_fontsize`, `revolutionslider_data_start_OUT`, `revolutionslider_data_opacity_OUT`, `revolutionslider_data_delay_OUT`, `com_order`, `com_template`, `pid`, `sorting`, `ptable`, `tstamp`) VALUES ('auto', 'text', 'above', 'ascending', 4, 0, 0, 0, 'fade', 'fadeout', '100', '14', 0, '100', 0, 'ascending', 'com_default', 12624, 16, 'tl_article', 0)':

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:55
  at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred while executing \'INSERT INTO tl_content (`autogrid_mode`, `type`, `floating`, `sortOrder`, `perRow`, `sliderStartSlide`, `revolutionslider_data_start`, `revolutionslider_data_delay`, `revolutionslider_data_animation_start`, `revolutionslider_data_animation_end`, `revolutionslider_data_opacity`, `revolutionslider_text_fontsize`, `revolutionslider_data_start_OUT`, `revolutionslider_data_opacity_OUT`, `revolutionslider_data_delay_OUT`, `com_order`, `com_template`, `pid`, `sorting`, `ptable`, `tstamp`) VALUES (\'auto\', \'text\', \'above\', \'ascending\', 4, 0, 0, 0, \'fade\', \'fadeout\', \'100\', \'14\', 0, \'100\', 0, \'ascending\', \'com_default\', 12624, 16, \'tl_article\', 0)\':SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry \'0\' for key \'PRIMARY\'', object(PDOException))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:166)
  at Doctrine\DBAL\DBALException::wrapException(object(Driver), object(PDOException), 'An exception occurred while executing \'INSERT INTO tl_content (`autogrid_mode`, `type`, `floating`, `sortOrder`, `perRow`, `sliderStartSlide`, `revolutionslider_data_start`, `revolutionslider_data_delay`, `revolutionslider_data_animation_start`, `revolutionslider_data_animation_end`, `revolutionslider_data_opacity`, `revolutionslider_text_fontsize`, `revolutionslider_data_start_OUT`, `revolutionslider_data_opacity_OUT`, `revolutionslider_data_delay_OUT`, `com_order`, `com_template`, `pid`, `sorting`, `ptable`, `tstamp`) VALUES (\'auto\', \'text\', \'above\', \'ascending\', 4, 0, 0, 0, \'fade\', \'fadeout\', \'100\', \'14\', 0, \'100\', 0, \'ascending\', \'com_default\', 12624, 16, \'tl_article\', 0)\':SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry \'0\' for key \'PRIMARY\'')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:146)
  at Doctrine\DBAL\DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), 'INSERT INTO tl_content (`autogrid_mode`, `type`, `floating`, `sortOrder`, `perRow`, `sliderStartSlide`, `revolutionslider_data_start`, `revolutionslider_data_delay`, `revolutionslider_data_animation_start`, `revolutionslider_data_animation_end`, `revolutionslider_data_opacity`, `revolutionslider_text_fontsize`, `revolutionslider_data_start_OUT`, `revolutionslider_data_opacity_OUT`, `revolutionslider_data_delay_OUT`, `com_order`, `com_template`, `pid`, `sorting`, `ptable`, `tstamp`) VALUES (\'auto\', \'text\', \'above\', \'ascending\', 4, 0, 0, 0, \'fade\', \'fadeout\', \'100\', \'14\', 0, \'100\', 0, \'ascending\', \'com_default\', 12624, 16, \'tl_article\', 0)', array())
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:912)
  at Doctrine\DBAL\Connection->executeQuery('INSERT INTO tl_content (`autogrid_mode`, `type`, `floating`, `sortOrder`, `perRow`, `sliderStartSlide`, `revolutionslider_data_start`, `revolutionslider_data_delay`, `revolutionslider_data_animation_start`, `revolutionslider_data_animation_end`, `revolutionslider_data_opacity`, `revolutionslider_text_fontsize`, `revolutionslider_data_start_OUT`, `revolutionslider_data_opacity_OUT`, `revolutionslider_data_delay_OUT`, `com_order`, `com_template`, `pid`, `sorting`, `ptable`, `tstamp`) VALUES (\'auto\', \'text\', \'above\', \'ascending\', 4, 0, 0, 0, \'fade\', \'fadeout\', \'100\', \'14\', 0, \'100\', 0, \'ascending\', \'com_default\', 12624, 16, \'tl_article\', 0)')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:277)
  at Contao\Database\Statement->query()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:251)
  at Contao\Database\Statement->execute()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:682)
  at Contao\DC_Table->create()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:620)
  at Contao\Backend->getBackendModule('article', null)
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:131)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:55)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/app_dev.php:69)

Code:

Doctrine\DBAL\Driver\PDOException:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80
  at Doctrine\DBAL\Driver\PDOConnection->query('INSERT INTO tl_content (`autogrid_mode`, `type`, `floating`, `sortOrder`, `perRow`, `sliderStartSlide`, `revolutionslider_data_start`, `revolutionslider_data_delay`, `revolutionslider_data_animation_start`, `revolutionslider_data_animation_end`, `revolutionslider_data_opacity`, `revolutionslider_text_fontsize`, `revolutionslider_data_start_OUT`, `revolutionslider_data_opacity_OUT`, `revolutionslider_data_delay_OUT`, `com_order`, `com_template`, `pid`, `sorting`, `ptable`, `tstamp`) VALUES (\'auto\', \'text\', \'above\', \'ascending\', 4, 0, 0, 0, \'fade\', \'fadeout\', \'100\', \'14\', 0, \'100\', 0, \'ascending\', \'com_default\', 12624, 16, \'tl_article\', 0)')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:909)
  at Doctrine\DBAL\Connection->executeQuery('INSERT INTO tl_content (`autogrid_mode`, `type`, `floating`, `sortOrder`, `perRow`, `sliderStartSlide`, `revolutionslider_data_start`, `revolutionslider_data_delay`, `revolutionslider_data_animation_start`, `revolutionslider_data_animation_end`, `revolutionslider_data_opacity`, `revolutionslider_text_fontsize`, `revolutionslider_data_start_OUT`, `revolutionslider_data_opacity_OUT`, `revolutionslider_data_delay_OUT`, `com_order`, `com_template`, `pid`, `sorting`, `ptable`, `tstamp`) VALUES (\'auto\', \'text\', \'above\', \'ascending\', 4, 0, 0, 0, \'fade\', \'fadeout\', \'100\', \'14\', 0, \'100\', 0, \'ascending\', \'com_default\', 12624, 16, \'tl_article\', 0)')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:277)
  at Contao\Database\Statement->query()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:251)
  at Contao\Database\Statement->execute()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:682)
  at Contao\DC_Table->create()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:620)
  at Contao\Backend->getBackendModule('article', null)
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:131)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:55)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/app_dev.php:69)

Code:

PDOException:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75
  at PDO->query('INSERT INTO tl_content (`autogrid_mode`, `type`, `floating`, `sortOrder`, `perRow`, `sliderStartSlide`, `revolutionslider_data_start`, `revolutionslider_data_delay`, `revolutionslider_data_animation_start`, `revolutionslider_data_animation_end`, `revolutionslider_data_opacity`, `revolutionslider_text_fontsize`, `revolutionslider_data_start_OUT`, `revolutionslider_data_opacity_OUT`, `revolutionslider_data_delay_OUT`, `com_order`, `com_template`, `pid`, `sorting`, `ptable`, `tstamp`) VALUES (\'auto\', \'text\', \'above\', \'ascending\', 4, 0, 0, 0, \'fade\', \'fadeout\', \'100\', \'14\', 0, \'100\', 0, \'ascending\', \'com_default\', 12624, 16, \'tl_article\', 0)')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)
  at Doctrine\DBAL\Driver\PDOConnection->query('INSERT INTO tl_content (`autogrid_mode`, `type`, `floating`, `sortOrder`, `perRow`, `sliderStartSlide`, `revolutionslider_data_start`, `revolutionslider_data_delay`, `revolutionslider_data_animation_start`, `revolutionslider_data_animation_end`, `revolutionslider_data_opacity`, `revolutionslider_text_fontsize`, `revolutionslider_data_start_OUT`, `revolutionslider_data_opacity_OUT`, `revolutionslider_data_delay_OUT`, `com_order`, `com_template`, `pid`, `sorting`, `ptable`, `tstamp`) VALUES (\'auto\', \'text\', \'above\', \'ascending\', 4, 0, 0, 0, \'fade\', \'fadeout\', \'100\', \'14\', 0, \'100\', 0, \'ascending\', \'com_default\', 12624, 16, \'tl_article\', 0)')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:909)
  at Doctrine\DBAL\Connection->executeQuery('INSERT INTO tl_content (`autogrid_mode`, `type`, `floating`, `sortOrder`, `perRow`, `sliderStartSlide`, `revolutionslider_data_start`, `revolutionslider_data_delay`, `revolutionslider_data_animation_start`, `revolutionslider_data_animation_end`, `revolutionslider_data_opacity`, `revolutionslider_text_fontsize`, `revolutionslider_data_start_OUT`, `revolutionslider_data_opacity_OUT`, `revolutionslider_data_delay_OUT`, `com_order`, `com_template`, `pid`, `sorting`, `ptable`, `tstamp`) VALUES (\'auto\', \'text\', \'above\', \'ascending\', 4, 0, 0, 0, \'fade\', \'fadeout\', \'100\', \'14\', 0, \'100\', 0, \'ascending\', \'com_default\', 12624, 16, \'tl_article\', 0)')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:277)
  at Contao\Database\Statement->query()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:251)
  at Contao\Database\Statement->execute()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:682)
  at Contao\DC_Table->create()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:620)
  at Contao\Backend->getBackendModule('article', null)
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:131)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:55)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/app_dev.php:69)

**Spooky** · 06.11.2019, 08:56

Der Stack Trace hilft hier leider nicht. Vermutlich ist deine Datenbank Definition nicht in Ordnung.

**Filip** · 06.11.2019, 09:04

Zitat von Spooky

Der Stack Trace hilft hier leider nicht. Vermutlich ist deine Datenbank Definition nicht in Ordnung.

Ist eigentlich auf auto increment konfiguriert? Das ist eine phpmyadmin 5.6 Datenbank.

Ich habe inzwischen auch alle Tabellen und spalten auf utf8_unicode_ci geändert.

(Mit dem Befehl "ALTER TABLE tableName.tl_page CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;")

**Filip** · 06.11.2019, 10:02

Zitat von Spooky

Der Stack Trace hilft hier leider nicht. Vermutlich ist deine Datenbank Definition nicht in Ordnung.

Ich habe jetzt mal die einzelnen Spalten überprüft und gemerkt das der Primary Key kein AUTO_INCREMENT ausgewählt hatte. Ich hole das jetzt mal bei allen Tabellen nach.

Es war mir jetzt auf jeden fall schon mal möglich wieder Elemente zu erstellen, hoffentlich zerschießt es mir die Installation nicht wegen irgendeines anderen Fehlers der jetzt mitgekommen ist.

**Spooky** · 06.11.2019, 10:03

Wie hattest du dieses Backup überhaupt erzeugt? Auf jeden Fall war das sehr kaputt

**Filip** · 06.11.2019, 10:12

Zitat von Spooky

Wie hattest du dieses Backup überhaupt erzeugt? Auf jeden Fall war das sehr kaputt

So wie ich es bisher immer gemacht hatte, einfach über phpmyadmin die ganze Datenbank exportiert.

In Zukunft werde ich mir wohl angewöhnen müssen das über die Shell und Cronjobs zu lösen. Wenn du da einen Tipp hast, wo ich damit anfangen kann, in Verbindung mit Contao wäre ich immer bereit zu lernen.

Ich möchte mich auch nochmal bedanken für die ganzen Denkanstöße und generell die Hilfsbereitschaft hier, auch wenn man manchmal fast am verzweifeln ist, sind alle hier immer nett und objektiv.

**Spooky** · 06.11.2019, 10:15

Naja ich persönlich nutze SQLyog.

Über die Shell brauchst du nur:

Code:

mysqldump --hex-blob --user=[USER] --password [DATABASE] > dump.sql

**mlweb** · 06.11.2019, 14:44

Zitat von Spooky

Naja ich persönlich nutze SQLyog.

Verstehe ich es richtig, dass ich SQLyog auch im Shared Hosting einsetzen könnte, wenn externer Zugriff auf die DB erlaubt ist?

**Spooky** · 06.11.2019, 14:45

Oder per SSH Tunnel

**mlweb** · 06.11.2019, 14:53

Mit SSH-Tunnel habe ich bisher noch nie befasst.

Vielleicht kommt das noch.
Aber schon wenn das Tool funktioniert, wenn ich externen Zugriff auf die DB habe, finde ich das ganz interessant.

**Spooky** · 06.11.2019, 15:01

In den meisten Fällen ist so ein externer Zugriff aber unverschlüsselt und sollte daher, egal mit welchem Tool, nicht unbedingt benutzt werden.

Wenn ich Zeit finde könnte ich ja mal eine kleine Anleitung unter Verwendung von bspw. Termius posten.

**mlweb** · 06.11.2019, 15:16

So eine Anleitung würde ich toll finden.
Könnte man so etwas eigentlich auch in die Doku aufnehmen? Extrabereich oder so?

**Spooky** · 06.11.2019, 15:26

Ja naja, da das ja nichts direkt mit Contao zu tun hat... es gibt aber ein ähnliche Diskussion hier: https://github.com/contao/docs/pull/99

Btw. wer mich (zB für solche Community Support Dinge) auch ein wenig finanziell unterstützen möchte, Abseits von Amazon Wunschlisten, kann das nun auch über GitHub Sponsors machen

Thema: DB Backup – Installtool "Es ist ein Fehler aufgetreten"

Themen-Optionen

Thema durchsuchen

DB Backup – Installtool "Es ist ein Fehler aufgetreten"

Aktive Benutzer

Aktive Benutzer

Berechtigungen

Contao

Empfohlene Webdesign-Bücher