[TYPO3-shop] Table error!, Probably one or more required fields/tables are missing in the database!

[Franz Holzinger]

Kate Schrøder Jensen a écrit :

> I have updatede tt_products trough the Extension Manager (It said it
> needed to: Alter table tt_products_cat add ui int(11) unsigned not null
> auto_increment; Alter table tt:products_cat add primary key (uid)), but
> it still clames that it needs to be updated and sqlDebug returns:
> 
> caller    t3lib_DB::admin_query
> ERROR    Incorrect table definition; There can only be one auto column
> and it must be defined as a key
> lastBuiltQuery    ALTER TABLE tt_products_cat ADD uid int(11) unsigned
> NOT NULL auto_increment;
> debug_backtrace    sc_mod_tools_em_index->main //
> sc_mod_tools_em_index->showextdetails //
> sc_mod_tools_em_index->updatesform //
> sc_mod_tools_em_index->checkdbupdates //
> t3lib_install->performupdatequeries // t3lib_db->admin_query //
> t3lib_db->debug
> caller    t3lib_DB::admin_query
> ERROR    Key column 'uid' doesn't exist in table
> lastBuiltQuery    ALTER TABLE tt_products_cat ADD PRIMARY KEY (uid);
> debug_backtrace    sc_mod_tools_em_index->main //
> sc_mod_tools_em_index->showextdetails //
> sc_mod_tools_em_index->updatesform //
> sc_mod_tools_em_index->checkdbupdates //
> t3lib_install->performupdatequeries // t3lib_db->admin_query //
> t3lib_db->debug
> 
> What to do next? I do not hope all these questions are a hassle for you.
> Thank you so far for your help.

If your tt_products_cat table does not have the uid field, then all data
 might get lost. You can only export it from phpMyAdmin.

Install the phpMyAdmin extension or use the TYPO3 Install tool to delete
the table tt_products_cat. Then reinstall tt_products.

- Franz