500 Internal Server Error on debug

magj
Topic Author
Offline
Senior Member

11 years 11 months ago #38606 by magj

500 Internal Server Error on debug was created by magj

Hi

I use Build 1680 For j2.5.11 I have some problem in my pages , when I enable debug system in Global Configuration , I get 500 Internal Server Error with this error:

Code:

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 uldu_flex' 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 uldu_flexicontent_items_ext as ie JOIN uldu_flexicontent_types AS t ON t.id = ie.type_id LEFT JOIN uldu_content_rating AS cr ON cr.content_id = ie.item_id WHERE ie.item_id=737

I even disabled the vote field to check if it is the problem or no but it's not.

Any help would be greatly appreciated
Regards

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

ggppdk
Offline
Administrator

11 years 11 months ago #38607 by ggppdk

Replied by ggppdk on topic 500 Internal Server Error on debug

Hello,

this already reported and fixed in later revision (v2.0.3 -despite delay- is close)

-- edit file:
administrator/components/com_flexicontent/.parentitemclass.php

change line (about) 746:

Code:

."	, cr.rating_count, ((cr.rating_sum / cr.rating_count)*20) as score"

Code:

." cr.rating_count, ((cr.rating_sum / cr.rating_count)*20) as score"

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.