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 > [email protected] > http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english -- Ries van Twisk Freelance TYPO3 Developer email: [EMAIL PROTECTED] web: http://www.rvantwisk.nl/ skype: callto://r.vantwisk Phone: + 1 810-476-4193 _______________________________________________ TYPO3-english mailing list [email protected] http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
