[SOLVED]Category view: MySQL error with Joomfish 2.5.x

More
11 years 7 months ago #34350 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]

Please Log in or Create an account to join the conversation.

More
11 years 7 months ago #34352 by ggppdk
For line 386 it is OK
But for line 947 it is not , because the table alias is 'sc' AND not 'c', so ... change line but use 'sc'

So in about lines 386, 765 it should be:
Code:
$ordering = FLEXI_J16GE ? 'c.lft ASC' : 'c.ordering ASC';
And in 947
Code:
$ordering = FLEXI_J16GE ? 'sc.lft ASC' : 'sc.ordering ASC';


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
11 years 7 months ago #34363 by igcorreia
Great :D Thank's for the help.

We are struggling with 3 instances since stable release, but know with the bug fixes looks like we are getting there :D

Please Log in or Create an account to join the conversation.

More
11 years 7 months ago #34383 by scorpion_pt

micker wrote: thanks for return !!
can do a little tuto or how to about FLEXIcontent and joomfish ?


I will do that, no problem.
Only need some more time, I can do it for sure this week.

These are busy days ;)

ggppdk wrote: For line 386 it is OK
But for line 947 it is not , because the table alias is 'sc' AND not 'c', so ... change line but use 'sc'

So in about lines 386, 765 it should be:

Code:
$ordering = FLEXI_J16GE ? 'c.lft ASC' : 'c.ordering ASC';
And in 947
Code:
$ordering = FLEXI_J16GE ? 'sc.lft ASC' : 'sc.ordering ASC';


This is working like a charm. Thank you people for a great work :D

Please Log in or Create an account to join the conversation.

More
11 years 7 months ago #34387 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]

Please Log in or Create an account to join the conversation.

More
11 years 7 months ago #34393 by ggppdk
-- I tried testing with Joomfish but i have an endless loop (on any frontend component) i will test on a clean site,

NOTE: For Joomfish we need to synchronize associations of item translations , which is rather small work to do ...
and same for J3.0 translation associations

-- About Falang i have enabled for upcoming v2.0.1 editing of translations inside item form via TABS !!


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.514 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline