[TYPO3] ve_guestbook errors

[Oliver Rowlands]

Hi Sandy,

Are you trying allow your website visitors to comment on your tt_news 
articles or on standard pages?

I would personally recommend that you try Dimitry's 'comments' extension 
instead of ve_guestbook, it is far more flexible and has much better 
spam protection.

Best regards,

Oliver

Sandy Matheson wrote:
> 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


-- 
Oliver Rowlands
:: Liquid Light ::

E - oliver at liquidlight.co.uk
W - http://www.liquidlight.co.uk

T - 00 44 (0)845 6 58 88 35
F - 00 44 (0)845 6 58 44 35