[TYPO3-project-seminars] Fatal Error in Front-End in every list view

[Stephan Schindel]

Hi,
I did an update of seminars et.al.:

Static Info Tables  	static_info_tables  	2.1.1
Static Methods for Extensions since 2007  	div2007  	0.2.0
Static taxes  	static_info_tables_taxes  	0.0.1
One is Enough Library  	oelib  	0.6.1
Ameos Formidable  	ameos_formidable  	1.1.0
One-time FE account 	onetimeaccount 	0.6.1
Seminar Manager 	seminars 	0.8.0

In the FE should be the listing of seminars, but I encountered the same 
Fatal Error as Stephanie Noack:

Fatal error: Uncaught exception 'tx_oelib_Exception_Database' with 
message 'There was an error with the database query. 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

'EXISTS (SELECT * FROM tx_seminars_seminars_organizers_mm WHERE The last 
built query: SELECT tx_seminars_organizers.* FROM tx_seminars_organizers 
WHERE EXISTS (SELECT * FROM tx_seminars_seminars_organizers_mm WHERE 
uid_local=20 AND uid_foreign=tx_seminars_organizers.uid) AND 
tx_seminars_organizers.deleted=0 ORDER BY uid'

in 
/homepages/21/d38855908/htdocs/institut-nord/typo3conf/ext/oelib/class.tx_oelib_db.php:328 
Stack trace: #0 
/homepages/21/d38855908/htdocs/institut-nord/typo3conf/ext/seminars/class.tx_seminars_bag.php(237): 
tx_oelib_db::select('tx_seminars_org...', 'tx_seminars_org...', 'EXISTS 
(SELECT ...', '', 'uid', '') #1 
/homepages/21/d38855908/htdocs/institut-nord/typo3conf/ext/seminars/class.tx_seminars_bag.php(159): 
tx_seminars_bag->rewind() #2 /h in 
/homepages/21/d38855908/htdocs/institut-nord/typo3conf/ext/oelib/class.tx_oelib_db.php 
on line 328



the extension dbal is offline
the extension dat2cal eliminated

a database compare shows only that:
Changing fields
ALTER TABLE cache_hash ENGINE=InnoDB;
ALTER TABLE cache_imagesizes ENGINE=InnoDB;
ALTER TABLE sys_log ENGINE=InnoDB;
ALTER TABLE cache_pages ENGINE=InnoDB;
ALTER TABLE cache_pagesection ENGINE=InnoDB;
ALTER TABLE cache_typo3temp_log ENGINE=InnoDB;
ALTER TABLE cache_md5params ENGINE=InnoDB;
ALTER TABLE fe_session_data ENGINE=InnoDB;

I am using a server of 1und1.com with
Typo3 4.2.8
PHP Version 5.2.10
MySQL 5.0.67

What have I to do? (I am no php-expert)


Greetings
Stephan Schindel

fon 0431 260 982 50
fax 0431 260 982 49
mob 0170 384 73 99

http://www.computer-rundum.de
Webdesign mit TYPO3 - PC-Beratung & -Service


Stephanie Noack schrieb:
> Hello everybody! 
> 
>  
> 
> I get the following error message in the front-end: 
> 
>  
> 
> Fatal error: Uncaught exception 'tx_oelib_Exception_Database' with message
> 'There was an error with the database query. 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 'EXISTS (SELECT * FROM
> tx_seminars_seminars_place_mm WHERE tx_se The last built query: SELECT
> 
> tx_seminars_seminars.* FROM tx_seminars_seminars WHERE
> tx_seminars_seminars.pid IN (715) AND (tx_seminars_seminars.object_type=2 OR
> 
> tx_seminars_seminars.object_type=0) AND EXISTS (SELECT * FROM
> tx_seminars_seminars_place_mm WHERE
> tx_seminars_seminars_place_mm.uid_local=tx_seminars_seminars.uid AND
> tx_seminars_seminars_place_mm.uid_foreign IN(1)) AND
> (tx_seminars_seminars.end_date > 1247469088 OR
> (tx_seminars_seminars.end_date = 0 AND tx_seminars_seminars.begin_date >
> 
> 1247469088) OR tx_seminars_seminars.begin_date = 0) AND cancelled!=1 AND
> ((object_type=0 AND event_type IN(4,5,2,3,1,6)) OR (object_type=2 AND EXISTS
> (SELECT * FROM tx_seminars_seminars AS topic WHERE topic in
> /homepages/32/d253459282/htdocs/typo3cms/heckenhof/typo3conf/ext/oelib/class
> 
> .tx_oelib_db.php on line 328
> 
>  
> 
> The message exists on every page with a list view (events, category or
> topics)
> 
>  
> 
> I'm using:
> 
>  
> 
> . SQL 5
> 
>  
> 
> . PHP 5.2.0
> 
>  
> 
> . TYPO3 4.2.8
> 
>  
> 
> . oelib 0.6.1
> 
>  
> 
> . ameos_formidable 1.1.0
> 
>  
> 
> . seminars 0.8.0
> 
>  
> 
> . onetimeaccount 0.6.1
> 
>  
> 
> I tried to comment out the TS setup one line at a time, but the breakage is
> still existing.
> 
>  
> 
> Best regards 
> 
>  
> 
> Stephie
> 
>  
>