Guest Posted March 14, 2006 Posted March 14, 2006 Thanks in advanced for your help! I just changed hosting. Backed up all my files. Exported my database from old host via osCommerce. Imported database to new host via phpMyAdmin. FTP'd files to new host. Changed includes/configure.php and admin/includes/configure.php. Have not moved SSL Cert yet. Everything looks great. I add a product to my cart, click checkout, enter my user name and password, which exist in the database and i get: Error Error: No match for E-Mail Address and/or Password. I add a new customer with the same email & password and get: NOTE: If you already have an account with us, please login at the login page. Click Password forgotten enter my email address and get: Error Error: The E-Mail Address was not found in our records, please try again. Go into Customers section in www.mysite.com/admin, select my test user, click email, click send email and get: Error Error: No customer has been selected. Please help! Contributions I have added: United Parcel Service (XML) - UPSXML_v1_2_2 Basic Design Pack - basic_design_pack1mk6 Quickbooks Import QBI Easy Populater 2.79a menutabv10b Margin Reporting v2.56a Popup Estimated Shipping v1.7a with UPS-USPS support
♥Vger Posted March 14, 2006 Posted March 14, 2006 Let's see if you did the transfer of the database correctly. 1. Take a backup of your old database via osCommerce admin --> Tools --> Backup, and elect to download a backup of your database (no compression) 2. Create a new blank database for your new site. 3. Access the new (blank) database via phpMyAdmin, go to the SQL tab, and use the Browse box to locate the copy of your old database you downloaded to your computer. 4. Click the Go button. 5. The standard default setting for inserting data into a database is a 2Mb limit. If your database is larger than 2 Mbs then you'll either have to edit php.ini to allow a larger upload or else chunk up the database into smaller pieces. 6. Edited both of your configure.php files with the new database user name and password, as well as new database name. Vger
Guest Posted March 14, 2006 Posted March 14, 2006 Let's see if you did the transfer of the database correctly. 1. Take a backup of your old database via osCommerce admin --> Tools --> Backup, and elect to download a backup of your database (no compression) 2. Create a new blank database for your new site. 3. Access the new (blank) database via phpMyAdmin, go to the SQL tab, and use the Browse box to locate the copy of your old database you downloaded to your computer. 4. Click the Go button. 5. The standard default setting for inserting data into a database is a 2Mb limit. If your database is larger than 2 Mbs then you'll either have to edit php.ini to allow a larger upload or else chunk up the database into smaller pieces. 6. Edited both of your configure.php files with the new database user name and password, as well as new database name. Vger Thanks for all your help Vger! Still the same problem. How does the login page connect to the database? Any other thoughts?
Guest Posted March 14, 2006 Posted March 14, 2006 I loaded a stock osCOmmerce onto my site and pointed it to my original database and still have the same problem. What are the settings to export the db thru phpMyAdmin? How can I debug the db? Thanks for all your help!
♥Vger Posted March 14, 2006 Posted March 14, 2006 Your site is obviously connecting to the database - else you wouldn't be seeing your website at all. Make sure that your new host has either a sendmail or smtp facility for your domain on their server. Make sure that you added the email addresses you previously used on your domain via your new web hosting control panel - they don't get transferred when you move a website. If you want to 'Export' (download) a copy of the database using phpMyAdmin then it's usually okay to click on Export and accept the default settings. Vger
Guest Posted March 14, 2006 Posted March 14, 2006 Sendmail is sent up, as are email addresses. I exported from phpMyAdmin and uploaded. No better. It appears that OSC is reading from the database but not writing to it. United Parcel Service (XML) does not store Disallowed Shipping Methods. Log Destination does not store the destination I enter. Is there somewhere else where the permissions could have changed?
Guest Posted March 15, 2006 Posted March 15, 2006 I installed a stock version of oscommerce and imported my database into the one created by fantastico and ended up with the same problem. Is my database corrupted? How can i fix it?
Recommended Posts
Archived
This topic is now archived and is closed to further replies.