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

[Kate Schrøder Jensen]

Franz Holzinger skrev:
> Hello Kate,
> 
>> Franz Holzinger skrev:
>>> Kate Schrøder Jensen a écrit :
>>>> Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
>>>> resource in /var/lib/typo3/typo3_src-4.1.3/t3lib/class.t3lib_db.php on
>>>> line 783
>>> You must activate sqlDebug in install tool to show the SQL error.
>>>
>>> - Franz
>>>
>> Thanks for your answer. The sqlDebug gives me an apply that doesn't make
>> sence to me at all... And please, I beg upon my knees, do not apply in
>> to complicated terms - I'm new in this.
>>
> This is easy.
> 
>> caller    t3lib_DB::exec_SELECTquery
>> ERROR    Unknown column 'uid' in 'field list'
>> lastBuiltQuery    SELECT title,uid,pid,subtitle
>> FROM tt_products_cat
>> WHERE
>> pid=38 AND tt_products_cat.deleted=0
>> ORDER BY title
>> LIMIT 21
>> debug_backtrace    sc_db_list->main // localrecordlist->generatelist //
>> localrecordlist->gettable // t3lib_db->exec_select_queryarray //
>> t3lib_db->exec_selectquery // t3lib_db->debug
> 
> There is an installation error. The field uid is missing in
> tt_products_cat. So go into the Extension Manager, click on Shop System
> and make all necessary database table updates.
> 
> - Franz
> 
> 
> 
> 
> 
Hi, again

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.

- Kate