Paycheck Posted April 26, 2004 Posted April 26, 2004 I just installed 2.2MS2 and have just about all in place. FOr some reason however when I try to login with my user account email and password it is giving me a 404 error. Can anyone explain this to me. I have two versions of the cart running one is 2.1MS2 which works fine here at this address and the one in question is a fresh install of 2.2MS2 at this address I have created a new account to make sure my DB upload was clean in that regards and still it gives me a 404 error. Much help needed on this guys. I installed this version as I was told there was some security issues with the earlier milesone version and I also wanted to use the gift voucher contribution which did not work on the earlier version of OS. So I appreciate any help on this one. JM Always remember, we need patience, guidance and most of all understanding. My Contributions
Paycheck Posted April 26, 2004 Author Posted April 26, 2004 I could sure use some help on this one guys. Anyone?? It is shutting me down. Why won't login.php login my users? it keeps throwing me back to the index.php page?? Heeeeeeeeeeeeeeeeeeeeeeellllllllllllllppppppppppppp Always remember, we need patience, guidance and most of all understanding. My Contributions
zzfritz Posted April 26, 2004 Posted April 26, 2004 I just created an account at your site, then went to the login. After entering the email address and password, I got no error message of any kind but it did direct me back to the index page as a guest. This is not a symptom I recognize, and without knowing squat about how you configured or what mods have been made, troubleshooting is impossible. Does the account you created (and mine as Joe Blow) show up in Admin -> Customers?
Paycheck Posted April 26, 2004 Author Posted April 26, 2004 OK THis is what I get. I go into my admin section under customers and you show as Joe Blow. When I click on edit for your account this is what shows up. Warning: reset(): Passed variable is not an array or object in /home/surfcamp/public_html/catalog/admin/includes/classes/object_info.php on line 17 Warning: Variable passed to each() is not an array or object in /home/surfcamp/public_html/catalog/admin/includes/classes/object_info.php on line 18 The only modding I have done is a contribution to my sort of the attributes and the gift voucher mod. I don't see how either one of these would effect the login. This is a fresh install of the 2.2MS2 JM Always remember, we need patience, guidance and most of all understanding. My Contributions
zzfritz Posted April 26, 2004 Posted April 26, 2004 Gee whiz ... this is starting to look like a database problem. This error suggests that the database query done by admin/customers.php is failing to get the record. It calls objectInfo() with what should be an array result from a query for the customer record, but objectInfo() is telling us there was no array. Try using phpMyAdmin to look at the customers table, just to see what is really there. This is really puzzling because you are able to see the list of customers the page initially presents.
Paycheck Posted April 26, 2004 Author Posted April 26, 2004 What exactly should I be looking for Oh wise one :D I will copy the DB table for the customers and show you in a file, will that work? Or is there a quick easy solution. JM Always remember, we need patience, guidance and most of all understanding. My Contributions
Paycheck Posted April 27, 2004 Author Posted April 27, 2004 Here is the working public_html/shop shopping cart customers table customers_id int(11) No auto_increment customers_gender char(1) No customers_firstname varchar(32) No customers_lastname varchar(32) No customers_dob datetime No 0000-00-00 00:00:00 customers_email_address varchar(96) No customers_default_address_id int(5) No 1 customers_telephone varchar(32) No customers_fax varchar(32) Yes NULL customers_password varchar(40) No customers_newsletter char(1) Yes NULL Here is the non working public_html/catalog/ shopping cart customers_id int(11) No auto_increment customers_gender char(1) No customers_firstname varchar(32) No customers_lastname varchar(32) No customers_dob datetime No 0000-00-00 00:00:00 customers_email_address varchar(96) No customers_default_address_id int(5) No 1 customers_telephone varchar(32) No customers_fax varchar(32) Yes NULL customers_password varchar(40) No customers_newsletter char(1) Yes NULL Always remember, we need patience, guidance and most of all understanding. My Contributions
zzfritz Posted April 27, 2004 Posted April 27, 2004 That's just the structure for the tables. In phpMyAdmin, at the top click the Browse button and it should show what is actually in the rows of the table. What I am interested to see is whether any of the fields in the new customer records are clearly erroneous. If so, the location and nature of the anomaly will guide us. This is a witch-hunt but at least somewhat rational. In this instance, I am certainly no 'wise one' ...
Paycheck Posted April 27, 2004 Author Posted April 27, 2004 That's just the structure for the tables. In phpMyAdmin, at the top click the Browse button and it should show what is actually in the rows of the table. What I am interested to see is whether any of the fields in the new customer records are clearly erroneous. If so, the location and nature of the anomaly will guide us. This is a witch-hunt but at least somewhat rational. In this instance, I am certainly no 'wise one' ... customers_id customers_gender customers_firstname customers_lastname customers_dob customers_email_address customers_default_address_id customers_telephone customers_fax customers_password customers_newsletter These are the table headers in the browse mode of the customers table I noticed in the tables that under customers_defailt_address_id there were two test users that had address id's of 0 not the typical "1" ?? JM Always remember, we need patience, guidance and most of all understanding. My Contributions
zzfritz Posted April 27, 2004 Posted April 27, 2004 ... this is a little like running the Lunar Landrover by telegraph, but we persevere: No, the customers_default_address_id is an index to another table. What we need to see are that the first field customers_id is incrementing and each row has customers_firstname and customers_lastname that look like what was entered. Step by step ...
zzfritz Posted April 27, 2004 Posted April 27, 2004 Whoa, rover ... Looking back at your first post to make sure my DB upload was clean You uploaded which tables from where, with what assurance they had the correct structure? Did you move them over as-is, then run the 2.2MS install upgrading them? Or did you install 2.2MS as a fresh install (you did use that phrase), then overlay its database? It appears you corrupted a good but empty MS2 database by uploading a MS1 structured backup. That would explain MS2 code being bollixed by what it finds (or fails to find).
Paycheck Posted April 27, 2004 Author Posted April 27, 2004 Hmm good point, what I did was run the install, then uploaded the version 2.1 information into the tables. All whent pretty clean with no errors so I thought nothing of it. Maybe I will delete the DB, re run the set up script for the mySQL and then add back only the customers info and productss and attributes? Does that sound like it will be OK? JM Always remember, we need patience, guidance and most of all understanding. My Contributions
zzfritz Posted April 29, 2004 Posted April 29, 2004 Does that sound like it will be OK? No. You have a MS1 database, leave it intact. Do the MS2 install as an upgrade with that database, which automatically upgrades the database schema to MS2.
Paycheck Posted April 29, 2004 Author Posted April 29, 2004 Cool great idea. Thanks I will try it. JM Always remember, we need patience, guidance and most of all understanding. My Contributions
Paycheck Posted April 29, 2004 Author Posted April 29, 2004 Cool great idea. Thanks I will try it. JM Sorry I must correct myself. I have a fresh install of 2.2MS2 database and all. All I did was export the information from the tables of the 2.1MS2 version and upload the table information into the new database. Is this not exceptable? I am still having th eptoblems. I have a 2.2 version database created by the auto install set up from 2.2 I am soooooo confused? I think maybe I should wipe it all out and start again? What is your opinion? JM Always remember, we need patience, guidance and most of all understanding. My Contributions
zzfritz Posted April 30, 2004 Posted April 30, 2004 You keep trying to make this more complicated than necessary. One more time: Keep your MS1-style database in place; Install MS2 as an upgrade to an existing site (the very first choice given to you at the bottom of the first page when you run the install). That's it. The MS2 installation modifies the database to suit the new schema.
Paycheck Posted April 30, 2004 Author Posted April 30, 2004 Fritz sorry your getting frustrated but you are no following my request. I already have a 2.1 in place. It is a working cart that is live and being hit quite frequently and I am a bit sketchy on upgrading it's DB until I have seen all of the contributions I have and mods work on the 2.2 system. I wanted to simply use the information from the DB called shop and upload it into the DB called catalog. I understand there is an upgrade to oscommerce in the install section, I have used it before but I did not want to take a chance on my working cart being corrupted with an upgrade. I hope this made sense for you. Sorry for the confusion. I am working through this step by step, thanks for your patience. JM Always remember, we need patience, guidance and most of all understanding. My Contributions
zzfritz Posted May 1, 2004 Posted May 1, 2004 but I did not want to take a chance on my working cart being corrupted with an upgrade So, just make a copy of it.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.