Error in query arising only in 64 bit Apache-php combination

SteP
Topic Author
Offline
Premium Member

12 years 1 month ago #36407 by SteP

Error in query arising only in 64 bit Apache-php combination was created by SteP

I'm trying to setup on my test site a 64-bit Apache (2.4.4)-PHP(5.3.21) installation, and trimming it to be placed in production servers.
I have found a small error in \administrator\component\com_flexicontent\models\parentclassitem.php, arising only in 64-bit environment (!).

Looking at r1679, line 745 and following, you have:

Code:

$query = "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 #__flexicontent_items_ext as ie "
." JOIN #__flexicontent_types AS t ON t.id = ie.type_id"
." LEFT JOIN #__content_rating AS cr ON cr.content_id = ie.item_id"
." WHERE ie.item_id=".(int)$this->_id;

You can see at second line a " , " that apparently as no reason to be there: is there any other table name that should be placed before it, or it's simply to be deleted?

Could also someone confirm that, except for this issue, FC works normally in this environment?

_________________________________________
MMC Edizioni - www.mmcedizioni.it
Website Developer & Graphics

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

ggppdk
Offline
Administrator

12 years 1 month ago #36408 by ggppdk

Replied by ggppdk on topic Error in query arising only in 64 bit Apache-php combination

Hello, thanks for report,
that bug escaped us, because this code is really executed (or should never be needed)

in administrator/components/com_flexicontent/models/parentitemclass.php

Find line (about line 746):
." , cr.rating_count, ((cr.rating_sum / cr.rating_count)*20) as score"
and replace with
." cr.rating_count, ((cr.rating_sum / cr.rating_count)*20) as score"

Please tell us where this bug appeared ?
in frontend item view?

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.

ggppdk
Offline
Administrator

12 years 1 month ago #36409 by ggppdk

Replied by ggppdk on topic Error in query arising only in 64 bit Apache-php combination

Hello,
i check and it is bug,
and it seems to appear in specific PHP / mysql versions

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

SteP
Topic Author
Offline
Premium Member

12 years 1 month ago #36410 by SteP

Replied by SteP on topic Error in query arising only in 64 bit Apache-php combination

It appears in frontend when calling an item (menu voice setting: FLEXIContent » Single item.). This item is a simple Article, with only description content.
I had no time to further investigate why, but the win32 installation does not show it.

_________________________________________
MMC Edizioni - www.mmcedizioni.it
Website Developer & Graphics

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