Hi, I really like this push2rss extension. I got the update pages to work, but I have trouble with the pagecontent or tt_content.
When an reader tries to get the XML, or you click on the link just to view the XML, the plugin generates a lot of sql errors. (turn on $TYPO3_CONF_VARS[SYS][sqlDebug] = 1 to see them) Is anyone else trying to do tt_content and gotten this to work? Thanks for the help. Bill Stoltz sample of errors ----- caller t3lib_DB::sql 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 'AND sys_language_uid<1 AND deleted=0' at line 4 lastBuiltQuery SELECT uid,trackchanges FROM tx_push2rss3ds_channel WHERE pid= AND sys_language_uid<1 AND deleted=0 debug_backtrace require // include // tspagegen::rendercontent // tslib_cobj->cobjget // tslib_cobj->cobjgetsingle // tslib_cobj->template // tslib_cobj->cobjgetsingle // tslib_cobj->template // tslib_cobj->cobjgetsingle // tslib_cobj->content // tslib_cobj->cobjgetsingle // tslib_cobj->cobjgetsingle // tslib_cobj->casefunc // tslib_cobj->cobjgetsingle // tslib_cobj->cobj_array // tslib_cobj->cobjget // tslib_cobj->cobjgetsingle // tslib_cobj->casefunc // tslib_cobj->cobjgetsingle // tslib_cobj->cobjgetsingle // tslib_cobj->user // tslib_cobj->calluserfunction // call_user_method // tx_push2rss3ds_pi1->main // tx_push2rss3ds_push->getuidparent // tx_push2rss3ds_push->getparameterinchannel // t3lib_db->sql // t3lib_db->debug caller t3lib_DB::sql ERROR Unknown column 'title' in 'field list' lastBuiltQuery SELECT uid,title,l18n_parent,sys_language_uid FROM tt_content WHERE uid=958 AND deleted=0 debug_backtrace require // include // tspagegen::rendercontent // tslib_cobj->cobjget // tslib_cobj->cobjgetsingle // tslib_cobj->template // tslib_cobj->cobjgetsingle // tslib_cobj->template // tslib_cobj->cobjgetsingle // tslib_cobj->content // tslib_cobj->cobjgetsingle // tslib_cobj->cobjgetsingle // tslib_cobj->casefunc // tslib_cobj->cobjgetsingle // tslib_cobj->cobj_array // tslib_cobj->cobjget // tslib_cobj->cobjgetsingle // tslib_cobj->casefunc // tslib_cobj->cobjgetsingle // tslib_cobj->cobjgetsingle // tslib_cobj->user // tslib_cobj->calluserfunction // call_user_method // tx_push2rss3ds_pi1->main // tx_push2rss3ds_push->getuidparent // t3lib_db->sql // t3lib_db->debug caller t3lib_DB::sql ERROR Unknown column 'title' in 'field list' lastBuiltQuery SELECT uid,title,l18n_parent,sys_language_uid FROM tt_content WHERE uid=958 AND deleted=0 debug_backtrace require // include // tspagegen::rendercontent // tslib_cobj->cobjget // tslib_cobj->cobjgetsingle // tslib_cobj->template // tslib_cobj->cobjgetsingle // tslib_cobj->template // tslib_cobj->cobjgetsingle // tslib_cobj->content // tslib_cobj->cobjgetsingle // tslib_cobj->cobjgetsingle // tslib_cobj->casefunc // tslib_cobj->cobjgetsingle // tslib_cobj->cobj_array // tslib_cobj->cobjget // tslib_cobj->cobjgetsingle // tslib_cobj->casefunc // tslib_cobj->cobjgetsingle // tslib_cobj->cobjgetsingle // tslib_cobj->user // tslib_cobj->calluserfunction // call_user_method // tx_push2rss3ds_pi1->main // tx_push2rss3ds_pi1::tsconfigarray2array // tx_push2rss3ds_push->getuidparent // t3lib_db->sql // t3lib_db->debug caller t3lib_DB::sql 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 'AND sys_language_uid<1 AND deleted=0' at line 4 lastBuiltQuery SELECT uid,trackchanges FROM tx_push2rss3ds_channel WHERE pid= AND sys_language_uid<1 AND deleted=0 _______________________________________________ TYPO3-english mailing list TYPO3-english@lists.netfielders.de http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english