TYPO3 Exception 40¶
Below, the TYPO3 community may have provided additional information or solutions for this exception. However, these may or may not apply to your particular case. If you can provide more information, you should come back here and add your experience and solution steps to this issue once you have resolved it.
General TYPO3 troubleshooting tips can be found in the section "Troubleshooting" of the menu, and live support is available in the TYPO3 Slack channel #typo3-cms. (See How to get your TYPO3 Slack account.)
Indicates an SQL error has occurred, please check your
The column 'columnname' on table 'tablename' already exists
This happens for example if the file
ext_tables.sql of a TYPO3 extension has the
same field twice for a table.
CREATE TABLE sys_products_fe_users_mm_visited_products ( uid int(11) NOT NULL auto_increment, pid int(11) DEFAULT '0' NOT NULL, tstamp int(11) DEFAULT '0' NOT NULL, crdate int(11) DEFAULT '0' NOT NULL, deleted tinyint(4) DEFAULT '0' NOT NULL, hidden tinyint(4) DEFAULT '0' NOT NULL, tstamp int(11) unsigned DEFAULT '0' NOT NULL, uid_local int(11) DEFAULT '0' NOT NULL, uid_foreign int(11) DEFAULT '0' NOT NULL, qty int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid), KEY uid_local (uid_local), KEY uid_foreign (uid_foreign), );
There are 2 fields
tstamp in the table
Removing the second line with the field
tstamp from table
sys_products_fe_users_mm_visited_products fixes the problem in this case.