Passed variable is not an array or object in customers after upgrading

[royalgemsnz]

I stuffed up my db and did a fresh install and imported my old data. In my admin however, I get the below errors up top when I look at the customer details and the customer fields are blank. I can enter data but they remain blank. On the webpage side, everything seems fine. I can log in to my account and all the details are there. The version is had was 1.3.0 and now is 1.3.0.2, so im guessing something was changed in relation to this.

Does anyone know specifically what changes I need to make to fix it?



"Warning: reset(): Passed variable is not an array or object in /usr/local/psa/home/vhosts/royalgems.co.nz/httpdocs/admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /usr/local/psa/home/vhosts/royalgems.co.nz/httpdocs/admin/includes/classes/object_info.php on line 30"

[DrByte]

It would seem that perhaps your customer data-tables may not be in sync with each other. Did you encounter any errors while importing?


Tables in question are:
- customers
- customers_info
- address_book

[royalgemsnz]

I had someone else do the import so I'm not sure. He didn't mention anything and doesn't know why the error has occured, so I'm guessing the answer is no.

Is there anyway to bring them in line with the current version?

[DrByte]

First you need to find out whether they're intact or not.

1. How many records are there in those tables?

2. What happens if you run this query via phpMyAdmin?
How many records do you get?
Do you get any errors?

select c.customers_id, c.customers_gender, c.customers_firstname,
                                          c.customers_lastname, c.customers_dob, c.customers_email_address,
                                          a.entry_company, a.entry_street_address, a.entry_suburb,
                                          a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id,
                                          a.entry_country_id, c.customers_telephone, c.customers_fax,
                                          c.customers_newsletter, c.customers_default_address_id,
                                          c.customers_email_format, c.customers_group_pricing,
                                          c.customers_authorization, c.customers_referral
                                  from customers c left join address_book a
                                  on c.customers_default_address_id = a.address_book_id
                                  where a.customers_id = c.customers_id;

[royalgemsnz]

I ran that query and got the below error.

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a
' at line 9

From that I figure that customers and address book are the 2 tables having issues. Heres a pic of customers which has 15 rows. Address book has 13 rows

[DrByte]

oops -- I was talking to someone when I posted that query, and left some PHP code in it. I've edited it for you to try again.

[DrByte]

From that I figure that customers and address book are the 2 tables having issues.

As I mentioned before, there are 3 tables which work in tandem:

It would seem that perhaps your customer data-tables may not be in sync with each other. Did you encounter any errors while importing?


Tables in question are:
- customers
- customers_info
- address_book

[royalgemsnz]

Hmmm. I ran it again and didn't have any errors.

[dbltoe]

Chris,
I'll start with the fact that I got in this mess in the middle.
Client had 4 music CDs with 2 entered as music and 2 as general. The client moved 2 generals to music by changing product type.
Cart and admin seem to work well but the two moved from general to music give the error in this thread when trying to edit in categories.
Suggestions?

[Ajeh]

Product Types like Product General and Product Music use different database tables ...

They really are not interchangeable ...

You would need to check all the tables and make sure the proper records exist for the 2 Product General products that were manually switched to Product Music ...