Phoca Forum

I get an error after first upgrading ti joomla 3.5.0 and then phoca download 3.1.0:

Error: 1054

Unknown column 'a.c.title' in 'order clause' SQL=SELECT a.id, a.title, a.alias, a.filename_play, a.filename_preview, a.link_external, a.image_filename, a.filename, c.id as catid, a.confirm_license, c.title as cattitle, c.alias as catalias, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug FROM #__phocadownload AS a LEFT JOIN #__phocadownload_categories AS c ON a.catid = c.id WHERE c.id = 4 ORDER BY a.c.title ASC LIMIT 0, 5

Hi, can you paste a screenshot where this occurs? This should not be a problem related to Joomla! 3.5.

Or in which view you get the problem?

Testing now Phoca Download 3.1.0, Joomla! 3.5, PHP without any such problem

Do you use some Phoca Download module?

Jan

I have put the following in an article:
Under finner dere eksempler på tema-/problemstillinger for muntlig eksamen. Foreløpig ligger det kun oppgaver i matematikk, norsk, naturfag og RLE.


{phocadownload view=category|id=7|target=s}
{phocadownload view=category|id=8|target=s}
{phocadownload view=category|id=9|target=s}
{phocadownload view=category|id=10|target=s}
{phocadownload view=category|id=11|target=s}
{phocadownload view=category|id=12|target=s}
{phocadownload view=category|id=13|target=s}
{phocadownload view=category|id=14|target=s}
{phocadownload view=category|id=15|target=s}
{phocadownload view=category|id=16|target=s}
{phocadownload view=category|id=17|target=s}
{phocadownload view=category|id=18|target=s}
{phocadownload view=category|id=3|target=s}

This worked before I upgraded, and I have not done any changes in my phoca download.

Are you using the plugin? Which version of plugin you are using?

Jan

I had version 3.1.0 installed. I think this is the latest version available, but I installed the plugin "on top" of the already installed one. Now it works again!

Ok