aezalpha Posted May 15, 2003 Posted May 15, 2003 I installed and have set up the 20030514 snapshot. I thought everything was running fine, until I noticed that when I access a customer's account information via Admin, the "State" field is populated with "223", which I believe is the zone code for U.S. I have gone through the code in admin/customers.php, and noticed that some error checking mechanisms are in place for the account info fields. Perhaps there's something in there that is defaulting the "State" field to 223? When I log in as the customer to review my account information, everything pulls up correctly. I was wondering if anyone else has run into the same problem. I'll work on comparing my account.php file with this one to see if there's something that's in the coding that I could change. There's gotta be something, 'cuz it doesn't make sense that it works for one and not the other. Anyway, please let me know if anyone can beat me to the solution. :)
hankfrid Posted May 16, 2003 Posted May 16, 2003 I just uploaded the 5-14 snapshot tonight and then reloaded a previous catalog database that I originally created about a month ago from a snapshot done 4-13. I also just went out there and set up a new customer and when I look at both old and new, everything in the State field looks just fine. What state value did you enter as the customer? But I don't seem to have that problem at all. Was this an older version database that you are using? HankFrid If I build it...they will come. If I don't try to build it.....I will never know!
aezalpha Posted May 16, 2003 Author Posted May 16, 2003 Nah the database should be a recent one. That was the reason why I had manually installed the new snapshot yesterday. The one that was installed through cPanel had an older database I think. I did some looking in my database in the "address_book" table, and noticed that entry_state column does not contain any values. However, the entry_country_id and entry_zone_id are both populated. For example, my fictional customer is from Texas. This person would have the following: 1) in database (via phpMyAdmin): - entry_country_id: 223 - entry_zone_id: 57 - entry_state: [blank] 2) in Admin->Customers->Edit - State: 223 - Country: United States 3) in Catalog via Client login - State: Texas - Country: United States The only main thing that I've seen that's different with admin/customers.php in this recent snapshot vs. MS1, is that there's a lot more error checking that's going on in the newer version. It starts at about line 562 for the state portion if you want to take a look. I appreciate your help with this, and sorry for the long post. I want to make sure that I had described the situation thoroughly. It's very puzzling, to say the least. :)
hankfrid Posted May 16, 2003 Posted May 16, 2003 How does your "zones" table in the database look? I show four fields: zone_id (57) zone_country_id (223) zone_code (TX) zone_name (Texas) in that order? Look for code that uses zone_country_id and see where all it places it. Did you delete your previous database before installing snapshot? Mine was still from a 4-13-2003 snapshot, but reloaded with default data fine and restored from my backup just fine. HankFrid If I build it...they will come. If I don't try to build it.....I will never know!
aezalpha Posted May 16, 2003 Author Posted May 16, 2003 Yep! My "zones" table is exactly like that one that you have, same order and everything. My suspicion is that somehow the zone information didn't translate properly into entry_state. In the "address_book" table, the "entry_state" column is empty. It's the same way in the database set up in the MS1 version (I have that running locally on my computer). What's "entry_state" used for if the value isn't stored in the database? Hmmmm... Maybe I should try to create another database and point the shop in that direction, to see if this is a database problem? What do you think?
hankfrid Posted May 16, 2003 Posted May 16, 2003 I know you don't want to hear this, but I don't think that is your problem, because my "address_book, entry_state" also has nothing on the database. Just wanted to stop you from chasing THAT lead too far. HankFrid If I build it...they will come. If I don't try to build it.....I will never know!
aezalpha Posted May 20, 2003 Author Posted May 20, 2003 :o) Okeedoke. I'll check into other possibilities as well. At this point I think I'll go ahead and wait on the new release of Linda's Shoppe Enhancement Controller to be updated to the current snapshot...and I may just reload all the files and stuff from scratch. I haven't really made any major changes anyway, and it looks as if there'll be lots of changes that comes with the SEC. :o) Henry, thanks so much for your help! I'll keep on investigating. Please do let me know if something else comes to ya.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.