Phoca

Phoca extensions are free extensions and are made and supported in freetime. Because of time issue, please accept the following "rules":
  • • Before you ask, try to read documentation or search this forum, as many questions are answered repeatedly
  • • Check if your server meets all the necessary requirements
  • • Sometimes, topics in this forum cannot be answered immediately
  • • Some questions are answered shortly as the information can be found in documentation (Phoca or Joomla! documentation)
  • • If you have problem on your site, please paste the link to your site or link a screenshot of your site (with help of imageshack, etc.)
  • • If you get blank page or error 500 on your site, please try to enable error reporting on or see your error log and paste this error message into the topic (see How to enable displaying php errors on site, try to check your SEF
  • • If you think, you found a bug, try to describe it or suggest a fix for such bug
  • • If you miss some feature of Phoca extension, please paste a topic on feedback site, if some of Phoca extensions, you have downloaded and installed, doesn't fit your needs, just uninstall it.
  • Thank you for understanding, Jan

Section List view with SQL Error

Section List view with SQL Error

Postby TravellerHH on 10 Mar 2010, 13:35

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?
TravellerHH
Phoca Newbie
Phoca Newbie
 
Posts: 4
Joined: 10 Mar 2010, 13:30

Google Ads


Re: Section List view with SQL Error

Postby Jan on 10 Mar 2010, 23:14

Hi, which database version you are using?
If you find some Phoca extensions useful, please vote for them on: extensions.joomla.org
User avatar
Jan
Phoca Hero
Phoca Hero
 
Posts: 14397
Joined: 10 Nov 2007, 18:23
Location: Czech Republic

Re: Section List view with SQL Error

Postby TravellerHH on 10 Mar 2010, 23:52

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
TravellerHH
Phoca Newbie
Phoca Newbie
 
Posts: 4
Joined: 10 Mar 2010, 13:30

Re: Section List view with SQL Error

Postby Jan on 13 Mar 2010, 00:03

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 some Phoca extensions useful, please vote for them on: extensions.joomla.org
User avatar
Jan
Phoca Hero
Phoca Hero
 
Posts: 14397
Joined: 10 Nov 2007, 18:23
Location: Czech Republic

Re: Section List view with SQL Error

Postby TravellerHH on 15 Mar 2010, 11:35

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

Postby TravellerHH on 15 Mar 2010, 14:46

Forget to clean the cache. It is working now. thank you. Good work! :twisted:
TravellerHH
Phoca Newbie
Phoca Newbie
 
Posts: 4
Joined: 10 Mar 2010, 13:30

Re: Section List view with SQL Error

Postby Jan on 16 Mar 2010, 14:27

Ok
If you find some Phoca extensions useful, please vote for them on: extensions.joomla.org
User avatar
Jan
Phoca Hero
Phoca Hero
 
Posts: 14397
Joined: 10 Nov 2007, 18:23
Location: Czech Republic


Return to Phoca Documentation

Who is online

Users browsing this forum: No registered users and 1 guest