Phoca Forum

Hello,

I have this error :
Warning: Invalid argument supplied for foreach() in /homepages/4xx/d4xxxx/htdocs/GENEOS/components/com_phocadownload/views/categories/tmpl/default.php on line 23
whith this Menu link :
http://www.geneos.fr/index.php?option=c ... 21&lang=fr
I have this issue after the upgra from com_phocadownload_v3.0.4 to com_phocadownload_v3.0.5
Many thanks for your help!!

System Information
phocadownload_v3.0.5
Theme Xtc Departure
PHP Built On Linux info 3.0 #1337 SMP Tue Jan 01 00:00:00 CEST 2000 all GNU/Linux
Database Version 5.1.73-1
Database Collation utf8_general_ci
PHP Version 5.4.30
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.3.1 Stable [ Ember ] 11-June-2014 13:30 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Firefox/31.0

Hi, try to enable debug mode, this seems like database error - seems like some column is missing in some of the Phoca Download table.

Debug mode will display database error.

Jan

Hi, sent PM.

Jan

Hello Jan

I have the same problem...

What must I do?

Thank you very much.

Regards
Patrick

Hi, did you enable debug mode? Which error you get there?

Jan

Hi Jan

I get:

SELECT c.id, c.title, c.alias, c.filename, c.date, c.hits, c.image_filename, cc.id AS categoryid, cc.access as cataccess, cc.accessuserid as cataccessuserid, cc.title AS categorytitle, cc.alias AS categoryalias
FROM ******_phocadownload AS c, ******_phocadownload_categories AS cc
WHERE c.catid= cc.id
AND c.published= 1
AND c.approved= 1
AND c.textonly= 0
AND cc.access IN (1,1)
AND c.access IN (1,1)
AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2014-07-31 05:08:04' )
AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2014-07-31 05:08:04' )
ORDER BY c.hits DESC
LIMIT 5

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE c ALL catid NO INDEX KEY COULD BE USED NULL NULL 4 Using where; Using filesort
1 SIMPLE cc eq_ref PRIMARY,idx_access PRIMARY 4 mydatabase.c.catid 1 Using where

---------------------------

SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM ******_phocadownload_styles AS a
WHERE a.published = 1
ORDER BY a.type, a.ordering ASC

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 Using where; Using filesort





Regards
Patrick

Hmm, I see no error which can prevent from loading items Did you try to reinstall the component, this seems like some tables are missing in your database, but in such case you will get sql error - check e.g. per phpMyAdmin if all tables are there.

you can see the list of tables in:
administrator/components/com_phocadownload/install/sql/mysql/install.utf8.sql

Jan

Thanks Jan.

Reinstalling the component solved the problem.

Ok