Missing one address record in addresses after csv import.

[Nick57]

Hi All,

 

I am having a weird problem that one address record is missing in the back-end after the csv import.

Imported 4823 records [correct amount checked within phpmyamin in table] but in back-end it is displaying 4822 addresses.

 

Showing rows 0 - 29 (4823 total, Query took 0.0008 sec)

 

I have checked if the field deleted is 0 and none are marked deleted.

 

I run with phpmyadmin a check and optimize records, but have no other idea what could stopping showing the correct amount in the backend, is there someone who had this problem before and knows what I need to check?

 

Another weird thing is that it shows this for the table address, why is this counter different?

~4,900 InnoDB utf8_general_ci 2.2 MiB -

 

Any help much appreciated.

[Nick57]

Found it, the export had some double records and that was the reason.