Section List view with SQL Error

Phoca Documentation - creating documentation in Joomla! CMS
TravellerHH
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 10 Mar 2010, 13:30

Section List view with SQL Error

Post by TravellerHH »

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?
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48402
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Section List view with SQL Error

Post by Jan »

Hi, which database version you are using?
If you find Phoca extensions useful, please support the project
TravellerHH
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 10 Mar 2010, 13:30

Re: Section List view with SQL Error

Post by TravellerHH »

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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48402
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Section List view with SQL Error

Post by Jan »

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
If you find Phoca extensions useful, please support the project
TravellerHH
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 10 Mar 2010, 13:30

Re: Section List view with SQL Error

Post by TravellerHH »

Sorry, still the same result.
TravellerHH
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 10 Mar 2010, 13:30

Re: Section List view with SQL Error

Post by TravellerHH »

Forget to clean the cache. It is working now. thank you. Good work! :twisted:
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48402
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Section List view with SQL Error

Post by Jan »

Ok
If you find Phoca extensions useful, please support the project
Post Reply