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?
Section List view with SQL Error
- Jan
- Phoca Hero
- Posts: 48386
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Section List view with SQL Error
Hi, which database version you are using?
If you find Phoca extensions useful, please support the project
-
- Phoca Newbie
- Posts: 4
- Joined: 10 Mar 2010, 13:30
Re: Section List view with SQL Error
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
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
- Jan
- Phoca Hero
- Posts: 48386
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Section List view with SQL Error
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
and let me know if it is fixed.
Thank you, Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Newbie
- Posts: 4
- Joined: 10 Mar 2010, 13:30
Re: Section List view with SQL Error
Sorry, still the same result.
-
- Phoca Newbie
- Posts: 4
- Joined: 10 Mar 2010, 13:30
Re: Section List view with SQL Error
Forget to clean the cache. It is working now. thank you. Good work!
- Jan
- Phoca Hero
- Posts: 48386
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Section List view with SQL Error
Ok
If you find Phoca extensions useful, please support the project