[TYPO3] push2rss sql errors
Bill Stoltz
bstoltz81 at comcast.net
Sat Sep 22 23:34:20 CEST 2007
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
More information about the TYPO3-english
mailing list