Files error

[montangero]

Hi !
I've installed Phoca Download 3.0.5 on Joomla 3.3.3. I had old version of both before. The upgrade seems to work for everything except the files. When I click on Categories, Statistics I can see what was on my server before the upgrade. But when I click on Files I get no files but this error message : "Warning: Invalid argument supplied for foreach() in /home/www/87beef0a4885282367b24f6b540388fd/web/joomla33/administrator/components/com_phocadownload/views/phocadownloadfiles/view.html.php on line 28".
What's wrong ?
Thanks,
Marc

[Jan]

Hi, enable debug mode in Joomla! global configuration to see which error message you get from database?

Jan

[montangero]

Hi !

I get that (see above). I hope it helps you understand

Thanks,

Marc

PS : it's only the beginning because the forum doesn't accept more than 2800 characters. I can send it by mail if you want.

23 requêtes exécutées 360.9 ms

2 doubles découverts!
2 requêtes dupliquées: #9 #11

[Jan]

Hi, you don't need to paste whole database debug here, just try to find error message there. On the site where you get the warning, you should get only one database error message.

Jan

[montangero]

Hi !

I get this error :

"Error
Unknown column 'a.userid' in 'on clause' SQL=EXPLAIN SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,ag.title AS access_level,c.title AS category_title, c.id AS category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno FROM `mmp_jos_phocadownload` AS a LEFT JOIN `mmp_jos_languages` AS l ON l.lang_code = a.language LEFT JOIN mmp_jos_users AS uc ON uc.id=a.checked_out LEFT JOIN mmp_jos_users AS uua ON uua.id=a.userid LEFT JOIN mmp_jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN mmp_jos_phocadownload_categories AS c ON c.id = a.catid LEFT JOIN mmp_jos_users AS ua ON ua.id = a.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc"

And this one : "Error
Unknown column 'a.userid' in 'on clause' SQL=EXPLAIN SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,ag.title AS access_level,c.title AS category_title, c.id AS category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno FROM `mmp_jos_phocadownload` AS a LEFT JOIN `mmp_jos_languages` AS l ON l.lang_code = a.language LEFT JOIN mmp_jos_users AS uc ON uc.id=a.checked_out LEFT JOIN mmp_jos_users AS uua ON uua.id=a.userid LEFT JOIN mmp_jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN mmp_jos_phocadownload_categories AS c ON c.id = a.catid LEFT JOIN mmp_jos_users AS ua ON ua.id = a.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc LIMIT 0, 20"

And : "Error
Unknown column 'a.userid' in 'on clause' SQL=EXPLAIN SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,ag.title AS access_level,c.title AS category_title, c.id AS category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno FROM `mmp_jos_phocadownload` AS a LEFT JOIN `mmp_jos_languages` AS l ON l.lang_code = a.language LEFT JOIN mmp_jos_users AS uc ON uc.id=a.checked_out LEFT JOIN mmp_jos_users AS uua ON uua.id=a.userid LEFT JOIN mmp_jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN mmp_jos_phocadownload_categories AS c ON c.id = a.catid LEFT JOIN mmp_jos_users AS ua ON ua.id = a.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc"

And several times this error : "id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 120 Using where"

Does it help you understand what's going wrong ?

Thank you so much, best regards,
Marc

[Jan]

HI, this means, that the column userid is missing in phoca download table (`mmp_jos_phocadownload` AS a ) but why it is missed, really no idea. Try to add the column manually :Idea:
https://www.phoca.cz/documents/16-joomla ... ent-errors (database errors)
Jan

[montangero]

Hi !
I've installed this column, then I got other tables missing which I added manually and now I get "Unknown column 'r.tagid' in 'field list' SQL=SELECT r.tagid FROM mmp_jos_phocadownload_tags AS a LEFT JOIN mmp_jos_phocadownload_tags_ref AS r ON a.id = r.tagid WHERE r.fileid = 58 ". What should I do ?
Thanks,
Marc

[Jan]

Hi, hmm, this seems like more columns are missed, the best way is to reinstall the component or install the tables manually, completely. (but be aware while reinstalling, all old data will be lost )

Jan