- Posts: 96
- Thank you received: 0
[SOLVED]Category view: MySQL error with Joomfish 2.5.x
- scorpion_pt
- Topic Author
- Offline
- Premium Member
-
11 years 7 months ago - 11 years 7 months ago #34336
by scorpion_pt
Hi again,
Testing Joomfish 2.5.1 integration with Joomla 2.5.9 and FLEXIcontent version 2.0.1 (candidate)(r1650).
Displaying a category view(with any template) via menu link returns this error:
Thank you
Testing Joomfish 2.5.1 integration with Joomla 2.5.9 and FLEXIcontent version 2.0.1 (candidate)(r1650).
Displaying a category view(with any template) via menu link returns this error:
Code:
SQL QUERY ERROR:
SELECT c.id FROM #__categories AS c WHERE c.published = 1 AND ( c.parent_id = 19 OR c.id=19) ORDER BY lft ASC
Column 'lft' in order clause is ambiguous SQL=SELECT jfself.id AS id, c.id FROM ifi9p_categories AS c JOIN ifi9p_categories AS jfself USING (id) WHERE c.published = 1 AND ( c.parent_id = 19 OR c.id=19) ORDER BY lft ASC
Thank you
Last edit: 11 years 7 months ago by scorpion_pt.
Please Log in or Create an account to join the conversation.
11 years 7 months ago #34340
by micker
FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]
Replied by micker on topic [SOLVED]Category view: MySQL error with Joomfish 2.5.x
actualy we doesn't test any compatibility with joomfish 
FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]
Please Log in or Create an account to join the conversation.
- scorpion_pt
- Topic Author
- Offline
- Premium Member
-
11 years 7 months ago #34345
by scorpion_pt
If you had read the post you would have seen that the problem is a mere ambiguity in the clause 'lftr':
And for information I can say that Joomfish is now working OK with FLEXI.
I solved this issues editing the file /components/com_flexicontent/models/category.php in this lines
Line #386
to
Line #947
to
To ggppdk: Please advise if this changes have some impact not expected?
Thanks in advance
Replied by scorpion_pt on topic [SOLVED]Category view: MySQL error with Joomfish 2.5.x
You should cause Falang don't work in an acceptable way.micker wrote: actualy we doesn't test any compatibility with joomfish
If you had read the post you would have seen that the problem is a mere ambiguity in the clause 'lftr':
Code:
Column 'lft' in order clause is ambiguous
And for information I can say that Joomfish is now working OK with FLEXI.
I solved this issues editing the file /components/com_flexicontent/models/category.php in this lines
Line #386
Code:
$ordering = FLEXI_J16GE ? 'lft ASC' : 'ordering ASC';
Code:
$ordering = FLEXI_J16GE ? 'c.lft ASC' : 'ordering ASC';
Code:
$ordering = FLEXI_J16GE ? 'lft ASC' : 'ordering ASC';
Code:
$ordering = FLEXI_J16GE ? 'c.lft ASC' : 'ordering ASC';
To ggppdk: Please advise if this changes have some impact not expected?
Thanks in advance
Please Log in or Create an account to join the conversation.
11 years 7 months ago #34349
by igcorreia
Replied by igcorreia on topic [SOLVED]Category view: MySQL error with Joomfish 2.5.x
haah I have been here 
every day I just don't post hehe...
every day I just don't post hehe... Please Log in or Create an account to join the conversation.
Time to create page: 0.349 seconds
Last FLEXI-site
... loading images 
