Technology Tools for Ministry

Community

Web-Empowered Church User Community
All Categories > Ministry Tools > Other TYPO3 Extensions > ve_guestbook errors
Total Posts: 1 - Pages (1): [1]
Author: Sandy Matheson
Posted: Jul 25 2008 - 08:24 AM
Subject: ve_guestbook errors
Hi,

I have just acceda 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


This only happens on the form page for ve_guestbook, not the page to display comments.

I am using the WEC install with 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
Total Posts: 1 - Pages (1): [1]
Click here for a complete list of threads
You must login to post a message to this conference.