Page 1 of 2
Error 1054 - Unknown column
Posted: 24 Feb 2014, 10:37
by 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
Re: Error 1054 - Unknown column
Posted: 26 Feb 2014, 16:26
by 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
Re: Error 1054 - Unknown column
Posted: 09 Mar 2014, 00:02
by 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?
Re: Error 1054 - Unknown column
Posted: 09 Mar 2014, 22:02
by Jan
Re: Error 1054 - Unknown column
Posted: 11 Mar 2014, 14:28
by alexintras
Thank you, resolved!
But I did it before, than upgrade to 3.0.2...
Re: Error 1054 - Unknown column
Posted: 27 Apr 2014, 22:25
by simkea
neotrend wrote: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
Re: Error 1054 - Unknown column
Posted: 03 May 2014, 12:35
by Jan
Ok, thank you for the info.
Jan
Re: Error 1054 - Unknown column
Posted: 29 Aug 2014, 17:49
by 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
Re: Error 1054 - Unknown column
Posted: 31 Aug 2014, 22:45
by Jan
Hi, which error you get exactly? The Phoca Download problem has solution here:
https://www.phoca.cz/documents/16-joomla ... extensions
Jan
Re: Error 1054 - Unknown column
Posted: 04 Sep 2014, 22:46
by 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