InstallToool error : lot of update queries pending...

**Charled** · 04.08.2022, 15:25

Hello everyone,

One of my prod websites under Contao 4.4 seems to work correctly but InstallTool displays a long list of database updates pending (see below). When I click on Update Database, I get the Contao error page and so... no database update...

I tried to to update manually in phpmyadmin SQL but I get errors too. For example

Code:

ALTER TABLE tl_calendar CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL

returns

Code:

#1075 - Un seul champ automatique est permis et il doit être indexé

(Sorry, french version.)

What is the solution ?

Thanks for your help.

Here is the list :

Code:

ALTER TABLE tl_article CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_calendar CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_calendar_events CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_calendar_feed CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_comments CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_comments_notify CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_content CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_cron CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_data CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_datamaps CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_datamaps_elements CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_dlh_geocode CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_elements CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_faq CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_faq_category CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_files CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_form CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_form_field CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_hofff_language_relations_group CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_image_size CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_image_size_item CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_ks_cc_category CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_ks_cc_category_language CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_ks_cc_service CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_ks_cc_service_language CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_layout CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_lead CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_lead_data CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_lead_export CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_log CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_member CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_member_group CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_ALTER TABLE tl_article CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_calendar CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_calendar_events CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_calendar_feed CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_comments CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_comments_notify CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_content CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_cron CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_data CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_datamaps CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_datamaps_elements CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_dlh_geocode CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_elements CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_faq CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_faq_category CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_files CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULLmetamodel CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_attribute CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_dca CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_dca_combine CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_dca_sortgroup CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_dcasetting CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_dcasetting_condition CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_filter CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_filtersetting CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_perimetersearch CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_rendersetting CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_rendersettings CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_searchable_pages CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_tabletext CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_tag_relation CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_translatedcheckbox CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_translatedlongblob CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_translatedlongtext CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_translatedtabletext CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_translatedtext CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_module CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_news CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_news_archive CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_news_feed CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_newsletter CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_newsletter_blacklist CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_newsletter_channel CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_newsletter_recipients CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_page CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_pattern CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_search CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_search_index CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_session CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_style CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_style_sheet CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_synccto_clients CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL

CREATE OR REPLACE VIEW hofff_language_relations_news_item AS
SELECT
  root_page.hofff_language_relations_group_id AS group_id,
  root_page.id AS root_page_id,
  page.id AS page_id,
  news.id AS item_id
FROM
  tl_news AS news
  JOIN tl_news_archive AS news_archive ON news_archive.id = news.pid
  JOIN tl_page AS page ON page.id = news_archive.jumpTo
  JOIN tl_page AS root_page ON root_page.id = page.hofff_root_page_id

ALTER TABLE tl_theme CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_undo CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_user CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_user_group CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_version CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_ctocom_cache CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_synccto_stats CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL

CREATE OR REPLACE VIEW hofff_language_relations_news_item AS
SELECT
  root_page.hofff_language_relations_group_id AS group_id,
  root_page.id AS root_page_id,
  page.id AS page_id,
  news.id AS item_id
FROM
  tl_news AS news
  JOIN tl_news_archive AS news_archive ON news_archive.id = news.pid
  JOIN tl_page AS page ON page.id = news_archive.jumpTo
  JOIN tl_page AS root_page ON root_page.id = page.hofff_root_page_id

CREATE OR REPLACE VIEW hofff_language_relations_news_aggregate AS
SELECT
  archive.id AS aggregate_id,
  CONCAT('a', archive.id) AS tree_root_id,
  root_page.id AS root_page_id,
  grp.id AS group_id,
  grp.title AS group_title,
  root_page.language AS language
FROM
  tl_news_archive AS archive
  JOIN tl_page AS page ON page.id = archive.jumpTo
  JOIN tl_page AS root_page ON root_page.id = page.hofff_root_page_id
  JOIN tl_hofff_language_relations_group AS grp ON grp.id = root_page.hofff_language_relations_group_id

ALTER TABLE tl_article ADD PRIMARY KEY (id)

CREATE INDEX alias ON tl_article (alias)
CREATE INDEX pid_start_stop_published_sorting ON tl_article (
  pid, start, stop, published, sorting)

ALTER TABLE tl_calendar ADD PRIMARY KEY (id)
ALTER TABLE tl_calendar_events ADD PRIMARY KEY (id)
CREATE INDEX alias ON tl_calendar_events (alias)
CREATE INDEX pid_start_stop_published ON tl_calendar_events (pid, start, stop, published)
ALTER TABLE tl_calendar_feed ADD PRIMARY KEY (id)
CREATE INDEX alias ON tl_calendar_feed (alias)
ALTER TABLE tl_comments ADD PRIMARY KEY (id)
CREATE INDEX published ON tl_comments (published)
CREATE INDEX source_parent_published ON tl_comments (source, parent, published)
ALTER TABLE tl_comments_notify ADD PRIMARY KEY (id)
CREATE INDEX tokenremove ON tl_comments_notify (tokenremove)
CREATE INDEX source_parent_tokenconfirm ON tl_comments_notify (source, parent, tokenconfirm)
ALTER TABLE tl_content ADD PRIMARY KEY (id)
CREATE INDEX pid_ptable_invisible_sorting ON tl_content (pid, ptable, invisible, sorting)
ALTER TABLE tl_cron ADD PRIMARY KEY (id)
CREATE UNIQUE INDEX name ON tl_cron (name)
ALTER TABLE tl_data ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_data (pid)
CREATE INDEX pid_parent ON tl_data (pid, parent)
CREATE INDEX pid_pattern_parent ON tl_data (pid, pattern, parent)
ALTER TABLE tl_datamaps ADD PRIMARY KEY (id)
ALTER TABLE tl_datamaps_elements ADD PRIMARY KEY (id)
ALTER TABLE tl_dlh_geocode ADD PRIMARY KEY (id)
CREATE INDEX address ON tl_dlh_geocode (address)
CREATE INDEX address_language_region ON tl_dlh_geocode (address, language, region)
ALTER TABLE tl_elements ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_elements (pid)
CREATE INDEX alias ON tl_elements (alias)
CREATE INDEX pid_invisible_sorting ON tl_elements (pid, invisible, sorting)
ALTER TABLE tl_faq ADD PRIMARY KEY (id)
CREATE INDEX pid_published_sorting ON tl_faq (pid, published, sorting)
ALTER TABLE tl_faq_category ADD PRIMARY KEY (id)
ALTER TABLE tl_files ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_files (pid)
CREATE UNIQUE INDEX uuid ON tl_files (uuid)
CREATE INDEX path ON tl_files (path(333))
CREATE INDEX extension ON tl_files (extension)
ALTER TABLE tl_form ADD PRIMARY KEY (id)
CREATE INDEX alias ON tl_form (alias)
CREATE INDEX leadenabled ON tl_form (leadenabled)
CREATE INDEX leadmaster ON tl_form (leadmaster)
CREATE INDEX leadenabled_leadmaster ON tl_form (leadenabled, leadmaster)
ALTER TABLE tl_form_field ADD PRIMARY KEY (id)
CREATE INDEX pid_invisible_sorting ON tl_form_field (pid, invisible, sorting)
ALTER TABLE tl_hofff_language_relations_group ADD PRIMARY KEY (id)
ALTER TABLE tl_hofff_language_relations_news ADD PRIMARY KEY (item_id,related_item_id)
CREATE INDEX related_item_id ON tl_hofff_language_relations_news (related_item_id)
ALTER TABLE tl_hofff_language_relations_page ADD PRIMARY KEY (item_id,related_item_id)
CREATE INDEX related_item_id ON tl_hofff_language_relations_page (related_item_id)
ALTER TABLE tl_image_size ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_image_size (pid)
ALTER TABLE tl_image_size_item ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_image_size_item (pid)
ALTER TABLE tl_ks_cc_category ADD PRIMARY KEY (id)
CREATE INDEX alias ON tl_ks_cc_category (alias)
ALTER TABLE tl_ks_cc_category_language ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_ks_cc_category_language (pid)
CREATE INDEX language ON tl_ks_cc_category_language (language)
ALTER TABLE tl_ks_cc_service ADD PRIMARY KEY (id)
CREATE INDEX alias ON tl_ks_cc_service (alias)
ALTER TABLE tl_ks_cc_service_language ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_ks_cc_service_language (pid)
CREATE INDEX language ON tl_ks_cc_service_language (language)
ALTER TABLE tl_layout ADD PRIMARY KEY (id)
ALTER TABLE tl_lead ADD PRIMARY KEY (id)
CREATE INDEX master_id ON tl_lead (master_id)
ALTER TABLE tl_lead_data ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_lead_data (pid)
CREATE INDEX master_id ON tl_lead_data (master_id)
ALTER TABLE tl_lead_export ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_lead_export (pid)
ALTER TABLE tl_log ADD PRIMARY KEY (id)
ALTER TABLE tl_member ADD PRIMARY KEY (id)
CREATE UNIQUE INDEX username ON tl_member (username)
CREATE INDEX email ON tl_member (email)
CREATE UNIQUE INDEX autologin ON tl_member (autologin)
CREATE INDEX activation ON tl_member (activation)
ALTER TABLE tl_member_group ADD PRIMARY KEY (id)
ALTER TABLE tl_metamodel ADD PRIMARY KEY (id)
CREATE INDEX tablename ON tl_metamodel (tablename)
ALTER TABLE tl_metamodel_attribute ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_attribute (pid)
CREATE INDEX colname ON tl_metamodel_attribute (colname)
ALTER TABLE tl_metamodel_dca ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_dca (pid)
ALTER TABLE tl_metamodel_dca_combine ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_dca_combine (pid)
CREATE INDEX fe_group ON tl_metamodel_dca_combine (fe_group)
CREATE INDEX be_group ON tl_metamodel_dca_combine (be_group)
ALTER TABLE tl_metamodel_dca_sortgroup ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_dca_sortgroup (pid)
ALTER TABLE tl_metamodel_dcasetting ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_dcasetting (pid)
ALTER TABLE tl_metamodel_dcasetting_condition ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_dcasetting_condition (pid)
ALTER TABLE tl_metamodel_filter ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_filter (pid)
ALTER TABLE tl_metamodel_filtersetting ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_filtersetting (pid)
ALTER TABLE tl_metamodel_perimetersearch ADD PRIMARY KEY (id)
ALTER TABLE tl_metamodel_rendersetting ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_rendersetting (pid)
ALTER TABLE tl_metamodel_rendersettings ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_rendersettings (pid)
ALTER TABLE tl_metamodel_searchable_pages ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_searchable_pages (pid)
ALTER TABLE tl_metamodel_tabletext ADD PRIMARY KEY (id)
CREATE INDEX att_id_item_id_row_col ON tl_metamodel_tabletext (att_id, item_id, row, col)
ALTER TABLE tl_metamodel_tag_relation ADD PRIMARY KEY (id)
CREATE INDEX att_id_item_id_value_id ON tl_metamodel_tag_relation (att_id, item_id, value_id)
ALTER TABLE tl_metamodel_translatedcheckbox ADD PRIMARY KEY (id)
CREATE INDEX att_id_value_langcode_item_id ON tl_metamodel_translatedcheckbox (att_id, value, langcode, item_id)
ALTER TABLE tl_metamodel_translatedlongblob ADD PRIMARY KEY (id)
CREATE INDEX att_id_item_id_langcode ON tl_metamodel_translatedlongblob (att_id, item_id, langcode)
ALTER TABLE tl_metamodel_translatedlongtext ADD PRIMARY KEY (id)
CREATE INDEX att_id_item_id_langcode ON tl_metamodel_translatedlongtext (att_id, item_id, langcode)
ALTER TABLE tl_metamodel_translatedtabletext ADD PRIMARY KEY (id)
CREATE INDEX att_id_item_id_row_col_langcode ON tl_metamodel_translatedtabletext (
  att_id, item_id, row, col, langcode
)
ALTER TABLE tl_metamodel_translatedtext ADD PRIMARY KEY (id)
CREATE INDEX att_id_value_item_id_langcode ON tl_metamodel_translatedtext (att_id, value, item_id, langcode)
ALTER TABLE tl_metamodel_translatedurl ADD PRIMARY KEY (att_id,item_id,language)
CREATE INDEX att_id_language ON tl_metamodel_translatedurl (att_id, language)
ALTER TABLE tl_module ADD PRIMARY KEY (id)
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_newsletter ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_newsletter (pid)
ALTER TABLE tl_newsletter_blacklist ADD PRIMARY KEY (id)
CREATE UNIQUE INDEX pid_hash ON tl_newsletter_blacklist (pid, hash)
ALTER TABLE tl_newsletter_channel ADD PRIMARY KEY (id)
ALTER TABLE tl_newsletter_recipients ADD PRIMARY KEY (id)
CREATE INDEX email ON tl_newsletter_recipients (email)
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 hofff_root_page_id ON tl_page (hofff_root_page_id)
CREATE INDEX hofff_language_relations_group_id ON tl_page (
  hofff_language_relations_group_id
)
CREATE INDEX languagemain ON tl_page (languagemain)
ALTER TABLE tl_pattern ADD PRIMARY KEY (id)
CREATE INDEX pid_ptable_sorting ON tl_pattern (pid, ptable, sorting)
CREATE INDEX pid_ptable_invisible_sorting ON tl_pattern (pid, ptable, invisible, sorting)
CREATE INDEX pid_ptable_suboption_invisible_sorting ON tl_pattern (
  pid, ptable, suboption, invisible,
  sorting
)
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_synccto_clients ADD PRIMARY KEY (id)
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 UNIQUE INDEX pid_fromtable_version ON tl_version (pid, fromtable, version)
CREATE INDEX userid ON tl_version (userid)
ALTER TABLE tl_ctocom_cache ADD PRIMARY KEY (id)
CREATE INDEX uid ON tl_ctocom_cache (uid)
ALTER TABLE tl_synccto_stats ADD PRIMARY KEY (id)

DROP TABLE tl_newsletter_recipients_backup

**Spooky** · 06.08.2022, 08:58

Use the debug mode to get more information about the error.

**Charled** · 06.08.2022, 09:58

Thanks Spooky.

I used

Code:

terea.test/app_dev.php/contao/install

as explained in the doc. Now I have the black toolbar at the bottom. What do I search ?

**Charled** · 06.08.2022, 10:19

It returns 35 deprecations

Code:

11:09:43 php User Deprecated: Passing the path to the Composer installed.json as first argument is no longer supported in version 2.3.
Show context Show trace
11:09:43 php User Deprecated: Using a bundles.json file has been deprecated and will no longer work in version 3.0. Use the Plugin::getBundles() method to define your bundles instead.
Show context Show trace
11:09:43 php User Deprecated: The type "binary_string" was explicitly marked as commented in its configuration. This is no longer necessary and will be removed in DoctrineBundle 2.0. Please remove the "commented" attribute from the type configuration.
Show context Show trace
11:09:43 php User Deprecated: Using ClassLoader::addNamespace() has been deprecated and will no longer work in Contao 5.0.
Show context Show trace
11:09:43 php (5 times) User Deprecated: Using ClassLoader::addClasses() has been deprecated and will no longer work in Contao 5.0.
Show context Show trace
11:09:43 php (11 times) User Deprecated: Using ClassLoader::addClass() has been deprecated and will no longer work in Contao 5.0.
Show context Show trace
11:09:43 php (3 times) User Deprecated: Using ModuleLoader::getActive() has been deprecated and will no longer work in Contao 5.0.
Show context Show trace
11:09:43 php User Deprecated: Using the Contao\RequestToken class has been deprecated and will no longer work in Contao 5.0. Use the Symfony CSRF service via the container instead.
Show context Show trace
11:09:43 php (5 times) User Deprecated: The "contao.install_tool" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead.
Show context Show trace
11:09:43 php User Deprecated: The "contao.install_tool_user" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead.
Show context Show trace
11:09:43 php User Deprecated: The "contao.installer" service is private, getting it from the container is deprecated since Symfony 3.2 and will fail in 4.0. You should either make the service public, or stop using the container directly and use dependency injection instead.
Show context Show trace
11:09:44 php (3 times) User Deprecated: Using database.sql files has been deprecated and will no longer work in Contao 5.0. Use a DCA file instead.
Show context Show trace
11:09:44 php User Deprecated: Using Input::getInstance() has been deprecated and will no longer work in Contao 5.0. The Input class is now static.
Show context Show trace

**Spooky** · 06.08.2022, 10:31

Zitat von Charled

Thanks Spooky.

I used

Code:

terea.test/app_dev.php/contao/install

as explained in the doc. Now I have the black toolbar at the bottom. What do I search ?

Now you just need to reproduce the error again, then you should be able to post a detailed stack trace of the error.

**Charled** · 06.08.2022, 13:33

Ok. Lezgo...

HTML-Code:

[3/3] DriverException

Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing 'ALTER TABLE tl_article CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL':

SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128
  at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182)
  at Doctrine\DBAL\DBALException::wrapException()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:159)
  at Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:2226)
  at Doctrine\DBAL\Connection->handleExceptionDuringQuery()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1451)
  at Doctrine\DBAL\Connection->query()
     (vendor/contao/installation-bundle/src/Database/Installer.php:80)
  at Contao\InstallationBundle\Database\Installer->execCommand()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:419)
  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()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (web/app_dev.php:73)

HTML-Code:

[2/3] Exception

Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:143)
  at Doctrine\DBAL\Driver\PDOConnection->doQuery()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php:38)
  at Doctrine\DBAL\Driver\PDOConnection->query()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1449)
  at Doctrine\DBAL\Connection->query()
     (vendor/contao/installation-bundle/src/Database/Installer.php:80)
  at Contao\InstallationBundle\Database\Installer->execCommand()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:419)
  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()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (web/app_dev.php:73)

HTML-Code:

 1/3 PDOException

PDOException:
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141
  at PDO->query()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)
  at Doctrine\DBAL\Driver\PDOConnection->doQuery()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php:38)
  at Doctrine\DBAL\Driver\PDOConnection->query()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1449)
  at Doctrine\DBAL\Connection->query()
     (vendor/contao/installation-bundle/src/Database/Installer.php:80)
  at Contao\InstallationBundle\Database\Installer->execCommand()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:419)
  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()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (web/app_dev.php:73)

**Spooky** · 07.08.2022, 10:36

Hm, looks like your database got may be corrupted.

Execute the following query on your database and post the output:

Code:

SHOW CREATE TABLE tl_article;

**Charled** · 07.08.2022, 10:44

Code:

localhost/terea_v3b_test/		
http://localhost/phpmyadmin/db_sql.php?db=terea_v3b_test
Your SQL query has been executed successfully.

SHOW CREATE TABLE tl_article


tl_article	CREATE TABLE `tl_article` (
  `id` int(10) unsigne...

For information : there are some days, I wanted to add a page in the structure and this page has id=0.

**Spooky** · 07.08.2022, 11:18

Hm are you sure you are on the correct database?

**Charled** · 07.08.2022, 11:28

You're right. That's why i modified my post...

For information : I discovered the problem when I added a new page in the structure and it had id = 0.

With the right db...

Code:

localhost/terea_v3b_test/		
http://localhost/phpmyadmin/db_sql.p...terea_v3b_test
Your SQL query has been executed successfully.

SHOW CREATE TABLE tl_article


tl_article	CREATE TABLE `tl_article` (
  `id` int(10) unsigne...

**Spooky** · 07.08.2022, 11:31

You need to post the whole output of the query.

**Charled** · 07.08.2022, 11:39

Sorry but it returns nothing more. I type it in SQL tab and that's what it returns. Perhaps do I need to modify some parameters for phpmydmin to be more verbose ?

**Charled** · 07.08.2022, 11:44

Ok. I was in "partial text". Here is the whole output.

Code:

localhost/terea_v3b_test/		http://localhost/phpmyadmin/db_sql.php?db=terea_v3b_test
Your SQL query has been executed successfully.

show create table tl_article



tl_article	CREATE TABLE `tl_article` (
  `id` int(10) unsigned NOT NULL,
  `pid` int(10) unsigned NOT NULL DEFAULT 0,
  `sorting` int(10) unsigned NOT NULL DEFAULT 0,
  `tstamp` int(10) unsigned NOT NULL DEFAULT 0,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `author` int(10) unsigned NOT NULL DEFAULT 0,
  `inColumn` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `keywords` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `showTeaser` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `teaserCssID` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `teaser` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `printable` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `customTpl` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `protected` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `groups` blob DEFAULT NULL,
  `guests` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `cssID` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `published` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `start` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `stop` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `languageMain` int(10) unsigned NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC

**Spooky** · 07.08.2022, 12:03

Yeah, the tl_article.id column is missing the AUTO_INCREMENT property for some reason. May be you can add that manually via your MySQL Client

**Charled** · 07.08.2022, 13:43

I tried by phpmyadmin : error. I tried by cli : error.

Code:

MariaDB [(none)]> use terea_v3b_test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [terea_v3b_test]> ALTER TABLE `tl_article` CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT; 
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key
MariaDB [terea_v3b_test]>

If I try to set id as primary key, it returns

Code:

 #1062 - Duplicate entry '1' for key 'PRIMARY'

**Spooky** · 07.08.2022, 13:56

Analyse the contents of your tl_article table and check whether you have entries with a duplicate value for id.

**Charled** · 07.08.2022, 14:31

Houston, we got a problem : all rows are duplicate !

**Spooky** · 07.08.2022, 14:32

Then you need to fix that first

**Charled** · 07.08.2022, 14:45

Ok. But...

Code:

 Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

**Charled** · 07.08.2022, 15:16

OK. I exported a dump of tl_article. I opened it, suppressed the duplicate rows queries. Then suppressed tl_article and imported the dump.
I could add primary to id then auto-increment.

Will I have to primary and auto_increment all the id col of all tl_* tables ?

**Spooky** · 07.08.2022, 15:44

Zitat von Charled

Will I have to primary and auto_increment all the id col of all tl_* tables ?

Depends on whether it's missing everywhere or not.

**Charled** · 13.08.2022, 16:58

Finally I had many tl_* tables(tl_content, tl_pages...) and all my mm_ tables having duplicate records. I've exported them, suppressed the duplicates and reimported. Then I added primary key to ID col. But it doesn't work. And the Install Tool still returns the same error.

it's possible the problem came when I installed hofff/contao-language-relations-news to make possible to switch between languages for news pages. Perhaps because I've installed it after having created some news... i'll test with a database backup.

But as I need to update Contao to 4.9 or 4.13, i decided to recreate it. Some work but more secure.

Thanks for your help.