Phoca Forum

Hi folks,

I've added quite a few files to our Phoca Download-archive at http://www.mattliden.fi/gym/index.php/sv/dokument1

Oddly enough, none of the files are visible in the backend. The list is completely empty. What should I do about that?

Hi, check if the status (published, unpublished), language, etc is selected Ok in administration.
Try to enable debug mode, if there is no problem while loading the items from database.

Jan

Yep, enabling debug mode gave me some quite interesting error-messages...can I mail them privately to you for scrutiny?

Thx, Mike

Hi, just read from the debug mode if there is e.g. not missing some table or column, etc.

Jan

Hi,

Thank you for your feedback. This is the error message I'm getting:

JDatabaseMySQL::query: 1054 - Unknown column 'a.userid' in 'on clause' SQL=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 `j16_phocadownload` AS a LEFT JOIN `j16_languages` AS l ON l.lang_code = a.language LEFT JOIN j16_users AS uc ON uc.id=a.checked_out LEFT JOIN j16_users AS uua ON uua.id=a.userid LEFT JOIN j16_viewlevels AS ag ON ag.id = a.access LEFT JOIN j16_phocadownload_categories AS c ON c.id = a.catid LEFT JOIN j16_users AS ua ON ua.id = a.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc

Don't really know what I should do about it...!

Mikael

Would this thread contain the solution to the problem?

viewtopic.php?f=31&t=14956&start=10

Mikael

There are two solutions:

1) Install Phoca Download 2.0.0 STABLE (do not use upgrade, because Phoca Download 2.0.0 STABLE is first version and there is no upgrade possibility - before it, only development versions were released so no upgrade feature - explained in the forum)

2) Run the sql query - row for adding missing userid column can be found in install.sql.bak file (this should be run e.g. in phpMyAdmin)

Jan