category description [solved]

More
12 years 7 months ago #19225 by 1ded6
Replied by 1ded6 on topic category description [solved]
Ok i tried the flexicontent module and tried some parameters to show the categroy title + category desc. and i got that :
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM jos_categories AS c WHERE c.id = 24' at line 1 SQL=SELECT c.id, c.title, c.description, FROM jos_categories AS c WHERE c.id = 24

think it was nice to report.

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

More
12 years 7 months ago #19227 by ggppdk
As you can see there is a comma just before FROM
that is causing the problem.

You can try to remove this comma.
The code is at the end of file:
modules/mod_flexicontent/helper.php

or wait for next beta of v1.5.6 which has more bugfixes.


-- 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
12 years 7 months ago #19234 by 1ded6
Replied by 1ded6 on topic category description [solved]
Ok worked perfectly.

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

More
12 years 6 months ago #19572 by scorpion_pt
Ive found today same error with r923 so I posted the bug:

code.google.com/p/flexicontent/i ... ail?id=233

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

More
12 years 6 months ago #19573 by ggppdk
Thanks for reporting, it is a bug,
but the comma must not be removed.
It must be moved to next line, just before CASE

Will fix, regards


-- 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.332 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