Sorting entries

[mariof]

I was trying to add the entries from my old guest book, all was ok untill I reached paged 39 and now each new entry is misplaced. The dates are not sorted anymore.

I tried to change the Guestbook sorting back and forth. I tried even modifying the dates of each entry but still the same thing.

Is there a way to sort the database, or fix it?

Thank you for your help.
Mario.

[hage007]

Hi,

it's funny. Just some minutes ago i had the same problem as you yesterday.

I added some older entries by hand and now the sorting in frontend doesn't work anymore.

I just looked at the code but didn't find a bug or something else. (easybook.php Line: 476)
In backend the sorting is perfect. I have only 35 entries, not 39 pages...

I found one little thing:
Try this homepage to verify your unix-timestamps at column 'gbdate'
http://www.onlineconversion.com/unix_time.htm

I got some wrong dates! But the dates in backend are looking ok!

What's this? Can anyone help?
Thanks a lot...

[mariof]

It’s really frustrating, I love this module but I can’t use it!?

I installed the JamBook Guestbook because it has the import capabilities from EasyBook.
I imported all entries from EasyBook and they display fine in JamBook!? so I’m using now 2 guest book on my site, which is stupid (at least for me). JamBook as my old Guest book, users can view it only and EasyBook for the new one!?

I wish someone can help us in this very soon…

[hage007]

Nobody is interested in our problem...

[hage007]

I have the solution!

"ORDER BY gbdate"

means arder a string value ASC or DESC.

In Sept 2001 the length of the Unix-timestamp changed...

All you have to do:
take your easybook.php (components/com_easybook) and replace the existing code from line 475 with the following code:

Code:

        # Modified by Stefan Herklotz (sh-si.de) - Beginn
        $date_format = '%Y%m%d';

        # Modified by Thomas Mader - Beginn
if ($is_editor) {
$database->setQuery( "SELECT *, FROM_UNIXTIME( gbdate, '".$date_format."') AS newdate FROM #__easybook"
        . "\nORDER BY newdate $eb_sorting"
        . "\nLIMIT $start,$eb_perpage"
/*
$database->setQuery( "SELECT * FROM #__easybook"
        . "\nORDER BY gbdate $eb_sorting"
        . "\nLIMIT $start,$eb_perpage" */
     
        );
} else {
        $database->setQuery( "SELECT *, FROM_UNIXTIME( gbdate, '".$date_format."') AS newdate FROM #__easybook"
        . "\nWHERE published = 1"
        . "\nORDER BY newdate $eb_sorting"
        . "\nLIMIT $start,$eb_perpage"
        /*
        $database->setQuery( "SELECT * FROM #__easybook"
        . "\nWHERE published = 1"
        . "\nORDER BY gbdate $eb_sorting"
        . "\nLIMIT $start,$eb_perpage"
        */
        );
    # Modified by Stefan Herklotz (sh-si.de) - End

[mariof]

thanks Hage for your reply but on line 475 I have this string:

   $gbicq  = mosGetParam( $_REQUEST, 'gbicq');

I couldn't find the string ($date_format) anywhere in the file (easybook.php)
Can you tell me the line that I need to change to the new code.

Thanks,

[aravot]

I need this but my line 475 is  # Modified by Thomas Mader - Beginn

Replacing that, gives error could you please be more specific i.e. replace this code to this.

[floridabjoern]

Hi, have the same problem.

Thank you for posting solutions for changing the source-code, but I don't find the correct line too. I think the best solution would be, if the easy-joomla-team would program a fix and offer an update. If somebody of this team ist reading this: Are you planning to offer an update which is fixing this problem? If yes, any idea when it will be available?

By the way: Thank you for doing a great job!

Bjoern.