Admin not listing customers or orders

[Donovan]

I went into Admin today, and now I see it's no longer showing my customers (non-live store):

 

Last Name First Name Account Created Action 

Displaying 1 to 9 (of 9 customers) Page 1 of 1

or the test order I did today:

Customers Order Total Date Purchased Status Action 

Displaying 1 to 1 (of 1 orders) Page 1 of 1

It's everywhere that uses that standard display form really, I even got it to happen in Product Specials:

Specials 

Products Products Price Status Action 

Displaying 1 to 1 (of 1 products on special) Page 1 of 1

 

Presumably I broke this, or is this a bug in OSC due to the newer MySQL 4.1.x? I've already had to fix a bunch of limit statements.

 

Thanks for any help you can provide... <_<

[Donovan]

Just so you know, I did compare admin/customers.php to the original, it's exactly the same.

 

I also copied my installation to another directory and dropped a fresh copy of the MS2 files on top of it, and the situation still occurs? (I'm going to have to do this again, I don't see how this can be).

[Donovan]

Well, it looks like it should be too hard to track down. I did a true test, I put a fresh copy of osC in place and the details are showing, I'll have to do a diff and find out where I'm going wrong :)

[Donovan]

Obviously, and I'm not sure how this happened, but during the fixes for MySQL 4.1.x admin/includes/classes/split_page_results.php was changed incorrectly.

 

I had, believe it or not this (the fix for MySQL 4.1.x is on the first line):

      if (($current_page_number > $num_pages) and ($num_pages > 0)) {

        $current_page_number = $num_pages;

      }

      $offset = ($max_rows_per_page * ($current_page_number - 1));

      $sql_query .= " limit " . $max_rows_per_page . $current_page_number . ", " . $max_rows_per_page;

 

where the last line should have been the default, which is:

$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

 

Go figure how that happened?! :)

Cheers!

[elhajjar]

Hello,

 

My web site provider make some modification on his server. Moving database to another server and updating a new version of appache web server.

 

After, I can not see the new cusotmers, neither the new orders with my shopping cart admin.

 

Do you thing, I have to update some thing in my shopping cart?

Or this problem dedpending the web site provider to fix?

 

Thanks to helping.