Error 1054 - Unknown column

[neotrend]

I have a strange behavior.

I installed a new Phoca Download 3.0.4 on Joomla 3.2.2, created categories and files.
When I now want to access the files in frontend, I see the categories page. But when I select one of these categories, I get the following error:

Code: Select all

Unknown column '4kommunikation' in 'where clause' SQL=SELECT parent_id FROM j25_categories WHERE id=4kommunikation-vorlagen-und-hilfsmittel

That's strange, because "4kommunikation" is a combination of the ID (4) and the alias (kommunikation...).

Thanks for help

[Jan]

Hi, the problem is, Phoca Download does not have any SQL which asks Joomla! category database table, so this SQL query should not come from Phoca Download - you should check other parts in your system which ask for the Joomla! categories

Jan

[alexintras]

Hi!
I have Joomla!, 3.2.3 and same 1054 error with

Code: Select all

Unknown column 'c.tokenhits' in 'field list' SQL=SELECT c.catid, c.filename, c.directlink, c.link_external, c.access, c.confirm_license, c.metakey, c.metadesc, cc.access as cataccess, cc.accessuserid as cataccessuserid, c.tokenhits FROM aajuw_phocadownload AS c, aajuw_phocadownload_categories AS cc WHERE c.id = 41 AND c.published = 1 AND c.approved = 1 AND c.catid = cc.id AND cc.access IN (1,1,5) AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2014-03-08 21:50:49' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2014-03-08 21:50:49' ) ORDER BY c.ordering LIMIT 0, 1

This come after upgrade to Version 3.0.4 from 3.0.0
Any idea?

[Jan]

Hi, see:
https://www.phoca.cz/documents/16-joomla ... extensions

Jan

[alexintras]

Thank you, resolved!
But I did it before, than upgrade to 3.0.2...

[simkea]

I have a strange behavior.

I installed a new Phoca Download 3.0.4 on Joomla 3.2.2, created categories and files.
When I now want to access the files in frontend, I see the categories page. But when I select one of these categories, I get the following error:

Code: Select all

Unknown column '4kommunikation' in 'where clause' SQL=SELECT parent_id FROM j25_categories WHERE id=4kommunikation-vorlagen-und-hilfsmittel

That's strange, because "4kommunikation" is a combination of the ID (4) and the alias (kommunikation...).

Thanks for help

Ok. i have the error too.
plz check if you use the module: mod_flexheader3

to fix the problem:
change in mod_flexheader3.php in line 141:
- if($fl_view=='category') {
+ if($fl_view=='category' AND $fl_option!='com_phocadownload' ) {

I have already informed the developer of Flex Header.
br

br

[Jan]

Ok, thank you for the info.

Jan

[StBk]

I've the same problem with Phoca Gallery and I'm using FlexHeader3.
The problem is since I've updated Joomla from 2.5.24 3.3.3 and updating Phoca Gallery from 3.2.3 to 4.1.1 and FlexHeader from 1.5.4 to 1.6.2.
Is there any new info since the last post?

Best regards,
Stefan

[Jan]

Hi, which error you get exactly? The Phoca Download problem has solution here: https://www.phoca.cz/documents/16-joomla ... extensions

Jan

[StBk]

I've the same problem like simkea wrote on 27.04.2014 (no DB-problems).
Using Phoca-product (the problem ist at Phoca Gallery, too) together with Flexheader3 is a problem.
But the modification solves the problem.
I only wanted to know from simkea about news from the developer.
Best regards,
Stefan