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

[Franz Holzinger]

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