Phoca Forum

When I call the Section List I allways get this SQL Error

No valid database connection Unknown column 'Array' in 'where clause' SQL=SELECT c.id, c.title, c.alias, s.title AS sectiontitle, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias FROM jos_content AS c, jos_sections AS s, jos_categories AS cc WHERE c.sectionid= s.id AND c.catid= cc.id AND c.access <= 1 AND s.access <= 1 AND cc.access <= 1 AND ( ( c.state = 1 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-03-10 11:33:12' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-03-10 11:33:12' ) ) OR ( c.state = -1 ) ) AND s.id IN (Array) ORDER BY c.hits DESC LIMIT 5

I tried to change the configuration but without any success.
What do I wrong?

Hi, which database version you are using?

Datenbankversion: 5.0.41-community-nt
Datenbankzeichensatz: utf8_general_ci
PHP-Version: 5.2.6
Webserver: Apache/2.0.61 (Win32) PHP/5.2.6
PHP-Anbindung zum Webserver: apache2handler
Joomla!-Version: Joomla! 1.5.15 Stable [ Wojmamni Ama Mamni ] 05-November-2009 04:00 GMT

Hi, try to download the Phoca Documentation now (I have done some modifications there so it should be fixed - the modifications are in the same version 1.1.0 - so just upgrade the 1.1.0 with the latest 1.1.0 - which you will download now)
and let me know if it is fixed.

Thank you, Jan

Sorry, still the same result.

Forget to clean the cache. It is working now. thank you. Good work!

Ok