Customers cannot create accounts?

[WebMistress]

I seem to have run into yet another lovely snag.

I can see customers having created accounts, yet when I click on their names with edit in the admin module, I get this error.

Warning: reset(): Passed variable is not an array or object in /home/blah/public_html/blah/admin/includes/classes/object_info.php on line 17

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

I go, uh crud?
try to make a new account

Get this after I enter in testing info on the entry page.


1054 - Unknown column 'entry_zipcode' in 'field list'

insert into address_book (customers_id, entry_firstname, entry_lastname, entry_street_address, entry_city, entry_zipcode, entry_country_id, entry_zone_id, entry_state) values ('8', 'me', 'me', '123 nree', 'and', '46016', '223', '24', '')

[TEP STOP]

I take it this means that I have to scour every line of every single page in my files to change EVERY reference to post-code to read zip-code???

::changes sig to read
~~ O ~~
Bang Head Here ::

[michael_s]

OR you could add the field 'entry_zipcode' to the addressbook table...

[WebMistress]

o0
really....

And this would make it much simpler?

How do I go about doing that?
Is that in the adding fields info thinggies from other questioneers?

Does that look like what it is to you as well?
An errant reference?

[WebMistress]

ooh
is it here?

main catalog/address_book.php
in this line of queries?
$addresses_query = tep_db_query("select address_book_id, entry_firstname as firstname,
just add entry_zipcode as zipcode

?

----------

nope
thats not it
now I get this upon logging into said created test account

1054 - Unknown column 'entry_zipcode' in 'field list'

select address_book_id, entry_firstname as firstname, entry_lastname as lastname, entry_company as company, entry_street_address as street_address, entry_suburb as suburb, entry_city as city, entry_zipcode as zipcode, entry_postcode as postcode, entry_state as state, entry_zone_id as zone_id, entry_country_id as country_id from address_book where customers_id = '8' order by firstname, lastname

[TEP STOP]

::deletes and tries again::


ugh
I need to change something in the DB dont I>

[michael_s]

WebMistress, don't add it to the files. Add it to the database. You have to run a mysql query on the database and insert the field.

The error tells you that the program (osCommerce) tried to access the field 'entry_zipcode' in the database, and it is not there. My solution was to add that field to the database so that you dont get the error...

[WebMistress]

|Thats what I thought
and unfortunately, I am a complete newb with all this <<like you cant tell >>, and have no clue how to run a query in the DB without a contrib.

::blehs and starts looking for something to teach that::

[WebMistress]

ok I think I may have found it

in the PHPMyAdmin, do I add this?

Add new field : 1 After:line of my choice
and then make the query string on the file match??

HAVE to ask to make sure because with my luck lately, I would totally farshnuggel my entire db with the beautiful press of a single button...

[michael_s]

WebMistress, avoid any worries and backup your db before you change anything. But yeah, that is the general idea...

[WebMistress]

::grins VERY large and proudly::
I did it
BUT
I still get this error when I try and delete the test account

Warning: reset(): Passed variable is not an array or object in /home/blah/public_html/blah/admin/includes/classes/object_info.php on line 17

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

What the hell is the error???

This is the whole file

<?php
/*
$Id: object_info.php,v 1.6 2003/06/20 16:23:08 hpdl Exp $

5\ osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com

Copyright (c) 2003 osCommerce

10\ Released under the GNU General Public License
*/

class objectInfo {

15\ // class constructor
function objectInfo($object_array) {
reset($object_array);
while (list($key, $value) = each($object_array)) {
$this->$key = tep_db_prepare_input($value);
}
}
}
?>

[WebMistress]

I THINK I figured out what the error is.
When there was a problem with the account creation, anyone that tried to make an account was only able to get their email and password done. The parse error didnt let them get any further.
If I try and edit ANY of those customers, that is when the error comes up. But if I try and edit any of the completed accounts, namely the one I made BEFORE the error started, or the new ones I made/edited after it was fixed, then all is cool.

Any ideas or should I wait until everyone gets their accounts updated and THEN worry or just leave the test acconts there?