Customer List in Admin - not sorted by ID after importing from old server

[scamp]

Hope this is the right place to put this one.

This really isn't an issue just annoying so if there is no way to fix it then it is fine.

I recently upgraded to a new server so brought all my customer database across from the old site. As a result the way the customer list is being sorted in admin is out of order. When I go in via myphpadmin, the names are all sorted by id which is what I want but for some reason this isn't coming through into the admin area.

Any ideas on how to get the admin to list the customer names by id as per normal?

Thanks heaps in advance

[Ajeh]

What indexes are on your customers table if you peek at it in phpMyAdmin ...

[scamp]

not to sure about indexes...

KEY `idx_email_address_zen` (`customers_email_address`),
KEY `idx_referral_zen` (`customers_referral`(10)),
KEY `idx_grp_pricing_zen` (`customers_group_pricing`),
KEY `idx_nick_zen` (`customers_nick`),
KEY `idx_newsletter_zen` (`customers_newsletter`)

[Ajeh]

You should have a Primary index set on the customers_id ...

In phpMyAdmin, you can add a Primary Index on the customers_id ...

See if that doesn't fix the issue ...

[torvista]

I have the same issue after importing some new records.



Up to 40 was added manually/normally.
41-45 were imported.
46 was added manually.

I think the indexes are correct, but i don't really know what I am looking at.


thanks
Steve

[torvista]

well now its ordering correctly,


but I still would like to know what is going on here.

If it's not right, something must be wrong...somewhere...