500 DB error in 2.0.2

More
11 years 6 months ago #37842 by dipti_j
hi guys!

I am from TechJoomla team. I installed flexicontent v2.0.2 on a clean Joomla 2.5.8 site.
When creating an item, I am getting the following 500 DB error
JDatabaseMySQLi::query: 1064 - 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 ' cr.rating_count, ((cr.rating_sum / cr.rating_count)*20) as score FROM m0dxz_fle' at line 1 SQL=SELECT t.access as type_access, t.name as typename, t.alias as typealias, , cr.rating_count, ((cr.rating_sum / cr.rating_count)*20) as score FROM m0dxz_flexicontent_items_ext as ie JOIN m0dxz_flexicontent_types AS t ON t.id = ie.type_id LEFT JOIN m0dxz_content_rating AS cr ON cr.content_id = ie.item_id WHERE ie.item_id=3

I guess, you guys forgot a ',' in the sql query :)

The fix for it is very simple, goto file /administrator/components/com_flexicontent/models/parentclassitem.php on line 745
Remove ',' after typealias
Save the file and refresh.

Joomla 2.5.8
FLEXIcontent CCK v2.0.2 r1680 for J2.5

Regards,
Dipti

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

More
11 years 6 months ago #37843 by ggppdk
Replied by ggppdk on topic 500 DB error in 2.0.2
Hello,
thanks for report,
this is already fixed in our source repository for v2.0.3


-- 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 6 months ago #37846 by micker
Replied by micker on topic 500 DB error in 2.0.2
do you want a beta for your dev ?

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 6 months ago #37871 by ggppdk
Replied by ggppdk on topic 500 DB error in 2.0.2
You can install
v2.0.3 beta2 from here (it is stable)
code.google.com/p/flexicontent/downloads/list


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