CMS MADE SIMPLE FORGE

Module Generator

 

[#8657] Sorting not functioning

avatar
Created By: Gerrit Duran (gdur)
Date Submitted: Mon Nov 19 15:22:29 -0500 2012

Assigned To: Zdeno Kuzmany (xxl)
Version: 2.2.4
CMSMS Version: 1.11.2.1
Severity: Major
Resolution: None
State: Open
Summary:
Sorting not functioning
Detailed Description:
Sorting and set in the backend has no effect nor when assigned in the frontend.
On the Items page in the backend sorting results in an error:

Warning: implode() [function.implode]: Invalid arguments passed in
/home/webtest/domains/webtest.duran-audio.com/public_html/modules/ModuleGenerator/ModuleLib/function.admin_itemtab.php
on line 114

Using debug set true doesn't help either. I only found: (mysqli): SELECT
c.*,ca.category_name FROM cms_module_projects_item c LEFT JOIN
cms_module_projects_fieldval FV1 ON c.item_id = FV1.item_id AND FV1.fielddef_id
= '4' LEFT JOIN cms_module_projects_categories ca ON ca.category_id =
c.category_id WHERE c.active = 1 AND  (ca.category_name = 'airports') ORDER BY
FV1.value asc LIMIT 0,25
as an SQL statement in which I can recoqnise some stuff but no errors occor.

Also in the backend Options-> Mode tab the sorting setting choosen here have no
effect. Also the pagelimit can't be changed and returns the default 25 after
submitting a different number.

The day after:
Sorry but I found out that it's not a bug as such apart from the error message
and the 25 limit, that remains.
The sorting problem was that I wanted to sort on a date field and because you
can select a date field as such which comes up with a nice calender and offers
date formatting I just didn't realised that the data is stored as text and is
during sorting handled as text and not as date. So changing the format to
YYYY-MM-DD solved the problem somehow but it wouldn't surprise me if others run
into the same problem.



History

Updates

Updated: 2012-11-20 17:14
state: Closed => Open

Updated: 2012-11-20 17:03
description: Sorting and set in the backend has no effect nor when assigned in the frontend. On the Items page in the backend sorting results in an error: Warning: implode() [function.implode]: Invalid arguments passed in /home/webtest/domains/webtest.duran-audio. => Sorting and set in the backend has no effect nor when assigned in the frontend. On the Items page in the backend sorting results in an error: Warning: implode() [function.implode]: Invalid arguments passed in /home/webtest/domains/webtest.duran-audio.
summary: Sorting not functioning => Sorting not functioning
resolution_id: => 5
state: Open => Closed