[TYPO3] ve_guestbook errors
Sandy Matheson
lists at mathesonuk.com
Sun Jul 27 17:40:06 CEST 2008
Hi,
I have just addeded a content element to my new site for people to
enter comments using ve_guestbook. This has produced the following
error:
Warning: Cannot modify header information - headers already sent by
(output started at
/usr/local/home/httpd/vhtdocs/t3src/typo3_src-4.1.7/t3lib/class.t3lib_db.php:1103)
in
/usr/local/home/httpd/vhtdocs/t3src/typo3_src-4.1.7/typo3/sysext/cms/tslib/class.tslib_fe.php
on line 2954
And the details with debug enabled says:
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 'AND tt_news.deleted=0 AND tt_news.t3ver_state!=1 AND
tt_news.hidden=0 AND (tt_ne' at line 4
lastBuiltQuery SELECT *
FROM tt_news
WHERE
uid = AND tt_news.deleted=0 AND tt_news.t3ver_state!=1 AND
tt_news.hidden=0 AND (tt_news.starttime<=1216988310) AND
(tt_news.endtime=0 OR tt_news.endtime>1216988310) AND
(tt_news.fe_group='' OR tt_news.fe_group IS NULL OR
tt_news.fe_group='0' OR (tt_news.fe_group LIKE '%,0,%' OR
tt_news.fe_group LIKE '0,%' OR tt_news.fe_group LIKE '%,0' OR
tt_news.fe_group='0') OR (tt_news.fe_group LIKE '%,-1,%' OR
tt_news.fe_group LIKE '-1,%' OR tt_news.fe_group LIKE '%,-1' OR
tt_news.fe_group='-1'))
debug_backtrace require#76 // include#426 //
tspagegen::rendercontent#77 // tslib_cobj->cobjget#339 //
tslib_cobj->cobjgetsingle#429 // tslib_cobj->user#555 //
tslib_cobj->calluserfunction#689 // call_user_func_array#5694 //
tx_templavoila_pi1->main_page# //
tx_templavoila_pi1->renderelement#218 //
tx_templavoila_pi1->processdatavalues#325 // tslib_cobj->cobjget#554
// tslib_cobj->cobjgetsingle#429 // tslib_cobj->cobj_array#485 //
tslib_cobj->cobjget#654 // tslib_cobj->cobjgetsingle#429 //
tslib_cobj->records#515 // tslib_cobj->cobjgetsingle#1318 //
tslib_cobj->cobjgetsingle#466 // tslib_cobj->casefunc#533 //
tslib_cobj->cobjgetsingle#1534 // tslib_cobj->cobj_array#485 //
tslib_cobj->cobjget#654 // tslib_cobj->cobjgetsingle#429 //
tslib_cobj->casefunc#533 // tslib_cobj->cobjgetsingle#1534 //
tslib_cobj->cobjgetsingle#466 // tslib_cobj->user#555 //
tslib_cobj->calluserfunction#689 // call_user_func_array#5694 //
tx_veguestbook_pi1->main# // tx_veguestbook_pi1->displayform#211 //
tx_timtab_fe->extraitemmarkerprocessor#835 // tx_timtab_fe->main#420
// tx_timtab_fe->substitutemarkers#86 //
tx_timtab_fe->getcurrentpost#173 // t3lib_db->exec_selectgetrows#273
// t3lib_db->exec_selectquery#302 // t3lib_db->debug#227
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 'AND tt_news.deleted=0 AND tt_news.t3ver_state!=1 AND
tt_news.hidden=0 AND (tt_ne' at line 4
lastBuiltQuery SELECT *
FROM tt_news
WHERE
uid = AND tt_news.deleted=0 AND tt_news.t3ver_state!=1 AND
tt_news.hidden=0 AND (tt_news.starttime<=1216988310) AND
(tt_news.endtime=0 OR tt_news.endtime>1216988310) AND
(tt_news.fe_group='' OR tt_news.fe_group IS NULL OR
tt_news.fe_group='0' OR (tt_news.fe_group LIKE '%,0,%' OR
tt_news.fe_group LIKE '0,%' OR tt_news.fe_group LIKE '%,0' OR
tt_news.fe_group='0') OR (tt_news.fe_group LIKE '%,-1,%' OR
tt_news.fe_group LIKE '-1,%' OR tt_news.fe_group LIKE '%,-1' OR
tt_news.fe_group='-1'))
debug_backtrace require#76 // include#426 //
tspagegen::rendercontent#77 // tslib_cobj->cobjget#339 //
tslib_cobj->cobjgetsingle#429 // tslib_cobj->user#555 //
tslib_cobj->calluserfunction#689 // call_user_func_array#5694 //
tx_templavoila_pi1->main_page# //
tx_templavoila_pi1->renderelement#218 //
tx_templavoila_pi1->processdatavalues#325 // tslib_cobj->cobjget#554
// tslib_cobj->cobjgetsingle#429 // tslib_cobj->cobj_array#485 //
tslib_cobj->cobjget#654 // tslib_cobj->cobjgetsingle#429 //
tslib_cobj->records#515 // tslib_cobj->cobjgetsingle#1318 //
tslib_cobj->cobjgetsingle#466 // tslib_cobj->casefunc#533 //
tslib_cobj->cobjgetsingle#1534 // tslib_cobj->cobj_array#485 //
tslib_cobj->cobjget#654 // tslib_cobj->cobjgetsingle#429 //
tslib_cobj->casefunc#533 // tslib_cobj->cobjgetsingle#1534 //
tslib_cobj->cobjgetsingle#466 // tslib_cobj->user#555 //
tslib_cobj->calluserfunction#689 // call_user_func_array#5694 //
tx_veguestbook_pi1->main# // tx_veguestbook_pi1->displayform#211 //
tx_timtab_fe->extraitemmarkerprocessor#835 // tx_timtab_fe->main#420
// tx_timtab_fe->substitutemarkers#86 //
tx_timtab_fe->getcurrentpost#173 // t3lib_db->exec_selectgetrows#273
// t3lib_db->debug#303
I am using Typo3 v4.1.7 and ve_guestbook version 2.7.1
Any ideas as to what could be causing the error and what I can do to
solve it?
Many thanks,
Sandy
More information about the TYPO3-english
mailing list