Passed variable is not an array or object

[Guest]

I have googled my problem but have not found a solution. It appears that I am not alone with this issue. When a new customer account is made, some of the information is not sent to the database correctly (I'm not a programmer, please forgive my lack of correct information). When I see a new customer in the admin, I see their name , but when I get to state and province is says: TEXT_NONE, TEXT_NONE, TEXT_NONE

 

If I try to edit it, when I click on the edit, I get the message:

Warning: reset() [function.reset]: Passed variable is not an array or object in /usr/home/xxxxxxxx/domains/xxxxxxx.com/public_html/store/admin/includes/classes/object_info.php on line 17

 

Warning: Variable passed to each() is not an array or object in /usr/home/xxxxxxx/domains/xxxxxxx.com/public_html/store/admin/includes/classes/object_info.php on line 18

 

I can edit their information, however, it doesn't stick. Also, I can't see their orders. I've tried to change information in the sql backend, but it doesn't seem to make a difference. I'm at a loss.

 

This just began to happen a couple of days ago. I recently installed cDynamic Meta Tags and Ultimate SEO URLs, but you wouldn't think that would cause it.

 

Thank you in advance for any ideas any of you might have.

[shooter-boy]

Hmmm... you're right, you wouldn't think that those contributions would cause it... but it's likely something to do with it.

 

Have you tried using a fresh create_account.php to create an account to see if that is any better in admin?

 

Rob

[Guest]

I'll give that a shot.

[Guest]

When I attempt to create an account from the front end, I hit the submit button and I get a blank page with this:

 

0 -

 

insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('0', '0', now())

 

[TEP STOP]

 

Any clues??? Clearly, something is getting passed wrong. I checked the database. It says it's optimized and not corrupted. I just don't know enough php or sql to make sense of this.

[arietis]

insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('0', '0', now())

 

[TEP STOP]

 

are you sure this is all the information? usually, mysql will give you a little more. i entered this into my table and it didn't have any trouble with it, so i'm guessing your table looks different. maybe you're missing a column name that has a 'not null' on it.

 

use phpmyadmin and take a look at your customers_info table. look for any columns that are denoted with a 'not null' specifier. the default schema looks like

DROP TABLE IF EXISTS customers_info;
CREATE TABLE osc_customers_info (
 customers_info_id int NOT NULL,
 customers_info_date_of_last_logon datetime,
 customers_info_number_of_logons int(5),
 customers_info_date_account_created datetime,
 customers_info_date_account_last_modified datetime,
 global_product_notifications int(1) DEFAULT '0',
 PRIMARY KEY (customers_info_id)
);

 

and only has the 'not null' on the customers_info_id column -- but you have that in your insert statement. if you've added a column and it's noted as 'not null' then it would be *required* to be specified in any insert statement. and if this is the case, then you'll have to modify your insert to include the column name and a value for that column. this would include both the 'front end' and 'admin' areas. anywhere you're using that table.

 

i hope that makes sense to you. :)

[arietis]

0 -

 

insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('0', '0', now())

 

thinking a little more, that '0' might be telling you that it has a problem with the customers_info_id being set to 0 -- because you already have one. i'd know more if there was more of the error message, something like 'duplicate entry' or something like that. are you sure you're not missing part of that error message?

[Guest]

That was all the information it gave me on the page.

 

Is this the info you're asking for?

 

Field Type Null Default

customers_info_id int(11) No 0

customers_info_date_of_last_logon datetime Yes NULL

customers_info_number_of_logons int(5) Yes NULL

customers_info_date_account_created datetime Yes NULL

customers_info_date_account_last_modified datetime Yes NULL

global_product_notifications int(1) Yes 0

[Guest]

Oh, so should I clear the default of 0? Is that maybe what's screwing it up? and take the null our of the date of last logon, date account created and last modified....

[Guest]

Okay, I found the answer (which makes no sense to me) but if anyone else has this problem, the answer is here:

http://www.oscommerce.com/forums/index.php?showtopic=155215

I don't pretend to understand it, but I just did the fix, and voila, my site is now back in order! *wipes brow*

 

Thanks for the help!