[TYPO3-shop] sql warnings

[Christina]

Hi Franz,
I have received some input from the Danish Typo3 community - that might 
shed some light on my issue:

There seems to be an error in EXT:table
Appearantly, ORDER BY, is not correctly translated which may correlate 
with the fact that my server recently upgraded to php5.2

part of the SQL statement yields:
  ORDER BY .uid DESC
But as the statement is selecting from several tables there is an 
ambiguity in which table to choose uid from, or perphaps the '.uid' 
should be changed to 'uid'?

The SQL statement:
SELECT ... (a lot of columns)
FROM tt_products products
WHERE
products.uid < 20 AND products.pid IN (97) AND (products.inStock <>0) 
AND products.deleted=0 AND products.hidden=0 AND 
(products.starttime<=1193127948) AND (products.endtime=0 OR 
products.endtime>1193127948) AND products.fe_group IN (0,-1)
ORDER BY .uid DESC


I look forward to your answer :)
Best regards
Christina

Franz Holzinger skrev:
> Hello Christina,
> 
>> (The warning messages have been pasted in at the end of this message)
>>
>> http://instrulog.cvfront.dk/index.php?id=97&tx_ttproducts_pi1[backPID]=97&tx_ttproducts_pi1[product]=20&cHash=28202efa25
>>
>> Any ideas on how to solve the issues that causes the warning? or just
>> how to remove the warnings from the site (as they do not seem to cause
>> any errors)?
>>
> These warning messages do not give enough information. You must activate
> the SQL debug output in the install tool.
> 
> - Franz
> 
>> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
>> result resource in /home/typo3/typo3_src-4.0.2/t3lib/class.t3lib_db.php
>> on line 801
>>
>> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
>> result resource in /home/typo3/typo3_src-4.0.2/t3lib/class.t3lib_db.php
>> on line 801
>>
>> Warning: Cannot modify header information - headers already sent by
>> (output started at
>> /home/typo3/typo3_src-4.0.2/t3lib/class.t3lib_db.php:801) in
>> /home/typo3/typo3_src-4.0.2/typo3/sysext/cms/tslib/class.tslib_fe.php on
>> line 2830