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