Can't see files in backend

[zupidupi]

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?

[Jan]

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

[zupidupi]

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

Thx, Mike

[Jan]

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

Jan

[zupidupi]

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

[zupidupi]

Would this thread contain the solution to the problem?

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

Mikael

[Jan]

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