TYPO3 Mailingliste: nicht fragen - lesen!

This is the message I'm getting looking in th Ext Manager for
tt_products. I guess it causes all the warning I get when I'm in List
showing the sysFolder of the shop. Here I can make new products but not
new categories. The warnings sounds like:

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

Warning: Cannot modify header information - headers already sent by
(output started at
/var/lib/typo3/typo3_src-4.1.3/t3lib/class.t3lib_db.php:783) in
/var/lib/typo3/typo3_src-4.1.3/typo3/template.php on line 618

The thing that puzzels me the most is, that I allready got a site up and
running with the same extensions and configuration.

This is the related extensions I have installed:
tt_address 2.2.1
nsb_cat2menu 0.0.1
sr_feuser_register 2.5.8
tt_products 2.5.5
fh_libery 0.0.20
lib 0.0.20
mbi_products_categories 0.1.1
sr_static_info 2.0.0
static_info_tables 2.0.6
div 0.1.0
table 0.1.13
templavoila 1.3.0

How can I solve my problem?

Thanks, Kate

_______________________________________________
TYPO3-project-tt-products mailing list
TYPO3-project-tt-products (AT) lists...netfielders.de
http://lists.netfielders.de/cgi-bin/...ct-tt-products

Kate Schrøder Jensen a écrit :
> This is the message I'm getting looking in th Ext Manager for
> tt_products. I guess it causes all the warning I get when I'm in List
> showing the sysFolder of the shop. Here I can make new products but not
> new categories. The warnings sounds like:
>
> 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

_______________________________________________
TYPO3-project-tt-products mailing list
TYPO3-project-tt-products (AT) lists...netfielders.de
http://lists.netfielders.de/cgi-bin/...ct-tt-products

Franz Holzinger skrev:
> Kate Schrøder Jensen a écrit :
>> This is the message I'm getting looking in th Ext Manager for
>> tt_products. I guess it causes all the warning I get when I'm in List
>> showing the sysFolder of the shop. Here I can make new products but not
>> new categories. The warnings sounds like:
>>
>> 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.

Kate

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

_______________________________________________
TYPO3-project-tt-products mailing list
TYPO3-project-tt-products (AT) lists...netfielders.de
http://lists.netfielders.de/cgi-bin/...ct-tt-products

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




_______________________________________________
TYPO3-project-tt-products mailing list
TYPO3-project-tt-products (AT) lists...netfielders.de
http://lists.netfielders.de/cgi-bin/...ct-tt-products

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 ttroducts_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

_______________________________________________
TYPO3-project-tt-products mailing list
TYPO3-project-tt-products (AT) lists...netfielders.de
http://lists.netfielders.de/cgi-bin/...ct-tt-products

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 ttroducts_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

_______________________________________________
TYPO3-project-tt-products mailing list
TYPO3-project-tt-products (AT) lists...netfielders.de
http://lists.netfielders.de/cgi-bin/...ct-tt-products