Page 1 sur 2

Sorting by Date

Posté : jeu. 15 juil. 2010 12:25
par angiek
Steevo:

I've come across a problem with sorting my list of courses by approval date.

It appears that when sorting, it is only applying to the current displayed page of items, not the full list. When I sort by my approval date parameter and navigate to the next page, all the sorting disappears.

Also, I have the field defined as a date, using the standard U.S. display format of M.D.Y.

But I think when it's sorting, it's using the display format as it's sorting template. Thus, it's sorting first by month, then day, then year. I need items to be sorted by year, then month, then date.

Am I missing something here? Can you help me get this field to sort properly? It is one of the parameters that my client originally requested. You can see what I am talking about here:

http://amiwebupload.phpwebhosting.com/a ... 2&Itemid=2

Thank you in advance for your help.

AngieK

Re: Sorting by Date

Posté : sam. 17 juil. 2010 14:39
par steevo
Hi,

You're right, it's sorting as if the field was a simple field. I'm going to modify that.

I see the problem when you change the page.

I will propose a fix next week.

Re: Sorting by Date

Posté : sam. 24 juil. 2010 18:20
par angiek
Dear Steevo:

Wondering if you have made any progress on the solution to the sorting problem?

Thank you for all your help.

Great component!

angiek

Re: Sorting by Date

Posté : dim. 25 juil. 2010 00:38
par steevo
Hi,

I just release 0.4.1 to fix it.
Before update, you should save database because this release make modification in collector tables.
You don't have to uninstall old version. Update is automatic.

For your problem when you change page, you should change a parameter in the link menu.
Say "no" to "erase last search".
This will fix the problem but to display all list, you will have to click on reset button in search area.
I have to work on it.

Re: Sorting by Date

Posté : mer. 28 juil. 2010 18:45
par angiek
Steevo:

I installed the new version, as you instructed. Unfortunately, it's reset all my dates in my entries.

No worries, we will work to put them back properly.

However, before I spend the time doing this ...

Should we wait until you have the rest of the work completed with the second part and I've installed the rest of the fix?

Or can we move forward with fixing the dates without a second round of having to fix them?

We don't mind waiting. We just don't want to fix something twice.

Re: Sorting by Date

Posté : mer. 28 juil. 2010 23:40
par steevo
Sorry about that. Is your server under windows ?

You can fix dates. This part work (you can check with several dates) and next release will not update this part so no risk to erase dates.

For 0.4.1, i have to modify values format in database, so there was a risk.

Did you save your database before update as i said ? If yes, can you give me the file to check what append ?

Re: Sorting by Date

Posté : mer. 28 juil. 2010 23:49
par angiek
Unfortunately, I was unable to save the database. My host's save/export function is archaic, to put it in the best light, and I got so frustrated with trying to back up, I just updated finally without the backup.

I didn't realize you needed to see it. What should I do?

Anyway, it didn't mess up anything except the date field. Everything else is fine.

Please let me know what you need from me.

AK

Re: Sorting by Date

Posté : jeu. 29 juil. 2010 00:00
par steevo
If you had it, i will check the problem but it doesn't matter.

Re: Sorting by Date

Posté : jeu. 29 juil. 2010 00:29
par angiek
Thanks for letting me know.

We'll redo the dates. It's no big deal to us. Thank you again for your help.

AK

Re: Sorting by Date

Posté : jeu. 29 juil. 2010 23:50
par angiek
Steevo:

I have error codes displaying on the front-end of my Joomla site with the Collector component:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/amiwebupload/www/ami/libraries/joomla/database/database/mysql.php on line 344

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/amiwebupload/www/ami/libraries/joomla/database/database/mysql.php on line 344

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/amiwebupload/www/ami/libraries/joomla/database/database/mysql.php on line 344

You can see these errors at http://amiwebupload.phpwebhosting.com/a ... 2&Itemid=2

Can you help? Or do I need to contact my host?