Error in category

tevez15
Topic Author
Offline
Elite Member

12 years 2 months ago #35780 by tevez15

Error in category was created by tevez15

Hi FC friends

I have one bug to report:

Code:

Warning: Invalid argument supplied for foreach() in /var/www/neci/components/com_flexicontent/models/category.php on line 231

Code:

foreach ($rows as $row) {
  $query_ids[] = $row->id;
}

My version is 2.0.2 (candidate) r1665

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

ggppdk
Offline
Administrator

12 years 2 months ago #35785 by ggppdk

Replied by ggppdk on topic Error in category

What is the configured ordering of the category ?

is it custom field ordering?

this was fixed in r1666

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

tevez15
Topic Author
Offline
Elite Member

12 years 2 months ago #35844 by tevez15

Replied by tevez15 on topic Error in category

No, just title - alphabetical, and i do not use a filter by custom field $:\$

I will update it to fix this problem

EDIT: We update to version r1668 but the problem keeps up, ordering is default.

EDIT2: I have a suggestion, in module, when we call a image field, is nice have a option to call all image on field(when he as a multiple image field) or just the first image insert on field. (?) Is possible right

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

ggppdk
Offline
Administrator

12 years 2 months ago #35899 by ggppdk

Replied by ggppdk on topic Error in category

Hello,
this error means that the query above is broken

please enable Joomla Debugging to see the broken query

OR a couple of rows there is :
$rows = $this->_db->loadObjectList();
just after it add:

Code:

if ($this->_db->getErrorNum())  JFactory::getApplication()->enqueueMessage(__FUNCTION__.'(): SQL QUERY ERROR:<br/>'.nl2br($this->_db->getErrorMsg()),'error');

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

tevez15
Topic Author
Offline
Elite Member

12 years 2 months ago #35920 by tevez15

Replied by tevez15 on topic Error in category

Hi

I add the code and he show a box with this info:

Code:

getData(): SQL QUERY ERROR:
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...

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