error after upgrading to phoca download 3.1.0 on joomla 3.5.

Phoca Download - download manager
pmonstad
Phoca Newbie
Phoca Newbie
Posts: 9
Joined: 06 Nov 2015, 21:58

error after upgrading to phoca download 3.1.0 on joomla 3.5.

Post by pmonstad »

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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48566
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: error after upgrading to phoca download 3.1.0 on joomla

Post by Jan »

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 :idea:

Do you use some Phoca Download module?

Jan
If you find Phoca extensions useful, please support the project
pmonstad
Phoca Newbie
Phoca Newbie
Posts: 9
Joined: 06 Nov 2015, 21:58

Re: error after upgrading to phoca download 3.1.0 on joomla

Post by pmonstad »

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.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48566
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: error after upgrading to phoca download 3.1.0 on joomla

Post by Jan »

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

Jan
If you find Phoca extensions useful, please support the project
pmonstad
Phoca Newbie
Phoca Newbie
Posts: 9
Joined: 06 Nov 2015, 21:58

Re: error after upgrading to phoca download 3.1.0 on joomla

Post by pmonstad »

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!
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48566
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: error after upgrading to phoca download 3.1.0 on joomla

Post by Jan »

Ok
If you find Phoca extensions useful, please support the project
Post Reply