Customers can not be edited

Hi,

I had to import customers from a different database. So I created a dummy customer first then downloaded the CSV file to match the fields. I have done this with two tables. ID's match on both tables. All imported new customers have data matching the zencart required fields.
zen_customers_info
zen_customers

I can open and edit mu dummy customer but I can not even select to open the imported customers.

Only strange thing is all the new customers have 'Account Created' and 'Last Login' fields with date >> 11/30/2036 . This happens regardless of leaving the CVS field blank or filled with another date before import.

What else I need to do?
Is there another table should I be editing?

Maybe check the information associated with customers in this thread, though the date issue may also play a factor.

http://www.zen-cart.com/wiki/index.php/Developers_-_Database_Schema#Customer_Information

The date(s) could be updated with a sQL command to change all dates in the future to perhaps one in the past, but it is somewhat surprising that the date doesn't "transfer" unless there is something wrong with the format.

Hi,

Yes thank you date was the factor. I have changed all the new customer fields in 'DOB' to one date in the pass and in 'Account Created' and 'Last Login' to same dates in the pass. What is happening now is very unusual.

Some customers can be selected with the blue 'ARROW' pointer but some can't. Additionally if I select any random customer, it paginates to some random page number and on the new page right hand INFO (EDIT/DELETE/EMAIL) panel disappears. Naturally since on that page I can't see the right pane I can not find out if I can edit ornot.

To make it work I made all the dates on the fields same. Customer that work and the ones do not work have all same fields. Information on the customer does varies of course.

I am totally baffled.

oavs:

Hi,

Yes thank you date was the factor. I have changed all the new customer fields in 'DOB' to one date in the pass and in 'Account Created' and 'Last Login' to same dates in the pass. What is happening now is very unusual.

Some customers can be selected with the blue 'ARROW' pointer but some can't. Additionally if I select any random customer, it paginates to some random page number and on the new page right hand INFO (EDIT/DELETE/EMAIL) panel disappears. Naturally since on that page I can't see the right pane I can not find out if I can edit ornot.

To make it work I made all the dates on the fields same. Customer that work and the ones do not work have all same fields. Information on the customer does varies of course.

I am totally baffled.

What error messages (logs folder) if any are you getting? (Information not displaying usually means anerror.)

That is it:

[19-Sep-2014 19:04:31 America/Chicago] PHP Warning: array_merge(): Argument #1 is not an array in /home/dogetrea/public_html/dog/nimda/customers.php on line 1106
[19-Sep-2014 19:04:31 America/Chicago] PHP Warning: array_merge(): Argument #2 is not an array in /home/dogetrea/public_html/dog/nimda/customers.php on line 1108
[19-Sep-2014 19:04:31 America/Chicago] PHP Warning: reset() expects parameter 1 to be array, null given in /home/dogetrea/public_html/dog/nimda/includes/classes/object_info.php on line 29
[19-Sep-2014 19:04:31 America/Chicago] PHP Warning: Variable passed to each() is not an array or object in /home/dogetrea/public_html/dog/nimda/includes/classes/object_info.php on line 30

If you need to gather more information about the error, then perhaps lat9's mydebug backtrace plugin: http://www.zen-cart.com/downloads.php?do=file&id=1879 would help. If not for this, probably will help with the other mods you seem likely to do. :)

I have deleted all the log files in order to re generate them. I repeated the same process in admin with same problem but system did not generate any log files ...??.. where else should I look now.

Log files were in /logs

oavs:

I have deleted all the log files in order to re generate them. I repeated the same process in admin with same problem but system did not generate any log files ...??.. where else should I look now.

Log files were in /logs

Well, was wondering about the data itself and if there was any type of checkon the buttons themselves. Then sort of like you wondering if they are displayed, but perhaps in some way not on screen. If you have a web site inspector such as firebug, then perhaps can find the button(s) and maybe bring them back onscreen or figure out why they are not present. Probably could tellthe same thing by looking at the source code to the page. Suggest of course first looking/inspecting one of the "working" ones then open a second and see what if anything specific seems different.

oavs:

Hi,

I had to import customers from a different database. So I created a dummy customer first then downloaded the CSV file to match the fields. I have done this with two tables. ID's match on both tables. All imported new customers have data matching the zencart required fields.
zen_customers_info
zen_customers

I can open and edit mu dummy customer but I can not even select to open the imported customers.

Only strange thing is all the new customers have 'Account Created' and 'Last Login' fields with date >> 11/30/2036 . This happens regardless of leaving the CVS field blank or filled with another date before import.

What else I need to do?
Is there another table should I be editing?

Did you also import the address_book table?

Thanks,

Anne

picaflor-azul:

Did you also import the address_book table?

Thanks,

Anne
:yes: Not having the address_book table would certainly explain the logs that oavs posted in post#5 -- note that only the first one is pertinent, the remaining issues identified are based on an empty country array.

This is now all working 100% based on your responses.

Thank you all.

The only problem with customers now is this. If I select any random customer, screen 'jumps/refreshes' to the page where the customer is without the blue arrow pointer/selector. At the same time same ting happens with the right hand column despairing totally. On another random selection of a customer blue arrow pointer points to the correct customer and right hand column stays as normal.

Does this indicate some sort of customer details NOT been consistent? All the customers are there listed under the 'Customers' with identical field information.

Any ideas on this?