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
Warning: Invalid argument ...default.php on line 23
-
- Phoca Newbie
- Posts: 8
- Joined: 07 Feb 2013, 20:47
- Jan
- Phoca Hero
- Posts: 48041
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Warning: Invalid argument ...default.php on line 23
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
Debug mode will display database error.
Jan
If you find Phoca extensions useful, please support the project
- Jan
- Phoca Hero
- Posts: 48041
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Warning: Invalid argument ...default.php on line 23
Hi, sent PM.
Jan
Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Member
- Posts: 32
- Joined: 22 May 2013, 16:06
Re: Warning: Invalid argument ...default.php on line 23
Hello Jan
I have the same problem...
What must I do?
Thank you very much.
Regards
Patrick
I have the same problem...
What must I do?
Thank you very much.
Regards
Patrick
- Jan
- Phoca Hero
- Posts: 48041
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Warning: Invalid argument ...default.php on line 23
Hi, did you enable debug mode? Which error you get there?
Jan
Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Member
- Posts: 32
- Joined: 22 May 2013, 16:06
Re: Warning: Invalid argument ...default.php on line 23
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
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
- Jan
- Phoca Hero
- Posts: 48041
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Warning: Invalid argument ...default.php on line 23
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
you can see the list of tables in:
administrator/components/com_phocadownload/install/sql/mysql/install.utf8.sql
Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Member
- Posts: 32
- Joined: 22 May 2013, 16:06
Re: Warning: Invalid argument ...default.php on line 23
Thanks Jan.
Reinstalling the component solved the problem.
Reinstalling the component solved the problem.
- Jan
- Phoca Hero
- Posts: 48041
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Warning: Invalid argument ...default.php on line 23
Ok
If you find Phoca extensions useful, please support the project