[TYPO3] bug in copy page?

ries van Twisk typo3 at rvt.dds.nl
Fri Nov 2 16:09:39 CET 2007


There you go,

contact the author of  tx_wecknowledgebase_comments

and ask him to fix this, the generated SQL is indeed incorrect,
it might be a TCA issue, I hardly doubts is a core typo3 issue.

Ries


On Nov 2, 2007, at 9:37 AM, Nagita Karunaratne wrote:

> ries van Twisk wrote:
>> Nagita,
>>
>> n the install tool you can enable sqlDebug.
>> After you enabled it then do a other copy/paste.
>> Then you can see what SQL was executed that failed.
>>
>> Now we can only guess what is wrong (tt_address?? or.....)
>> With the correct SQL we will know...
>>
>> Ries
>>
> Hi,
>
> Here is the listing after enabling SQLDebug:
>
> ---------------------------------------------------------------------- 
> -------
> caller	t3lib_DB::exec_SELECTquery
>
> ERROR	You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'DESC' at line 5
>
> lastBuiltQuery	SELECT uid
> FROM tx_wecknowledgebase_comments
> WHERE
> pid=1000
> ORDER BY crdate ASC DESC
>
> debug_backtrace	SC_tce_db->main // t3lib_TCEmain->process_cmdmap //
> t3lib_TCEmain->copyPages // t3lib_TCEmain->copySpecificPage //
> t3lib_DB->exec_SELECTquery // t3lib_DB->debug
>
> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
> result resource in /var/www/typo3_src-4.1.2/t3lib/ 
> class.t3lib_db.php on
> line 796
>
> Warning: Cannot modify header information - headers already sent by
> (output started at
> /var/www/typo3_src-4.1.2/t3lib/class.t3lib_db.php:1095) in
> /var/www/typo3_src-4.1.2/typo3/tce_db.php on line 225
>
> -----------------------------------------------------------
>
> The only thing I can think is that it is caused by WEC Knowledgebase
> extension.
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english

--
Ries van Twisk
Freelance TYPO3 Developer
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/
skype: callto://r.vantwisk
Phone: + 1 810-476-4193








More information about the TYPO3-english mailing list