ashleylr Posted January 29, 2007 Share Posted January 29, 2007 I have an existing OsCommerce site that is heavily modified and works great. My sister asked me to develop a new site for her so rather than starting over from scratch and installing the contributions over again, I opted to copy over the file system and database from my existing site and then strip out the data from the database that pertained specifically to my store. I updated the configuration information for her new database, installed an SSL cert, and made some basic modifications and everything seemed to be working pretty well. Then I tested her shopping cart and log in pages and they don't work at all for some reason. When I click on a product and click "add to cart" it takes me to the shopping cart page and says the shopping cart is empty. When I go to the create account page and try to set up my information and click submit, it just reloads the form. I'm thinking its something in the html output or possibly some obscure place where I missed changing over my old information to hers. Does anyone know where these functions are controlled or have any ideas on what file I can look at to try to correct this? The new website is <a href="http://www.thegreendistrict.com">www.thegreendistrict.com</a> if you want to check it out to see what I'm talking about. Thanks so much!! Ashley Link to comment Share on other sites More sharing options...
johngroves Posted January 29, 2007 Share Posted January 29, 2007 None of your product listings are working: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-60, 60' at line 1 select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -60, 60 [TEP STOP] I don't know what contributions you have installed, but have you tried copying the original site over to the new server, changing the configuration settings for the database settings etc. Truncate any product tables and then try adding your own products to see if they are displayed on the new site. -- Cheers, John Link to comment Share on other sites More sharing options...
ashleylr Posted January 29, 2007 Author Share Posted January 29, 2007 None of your product listings are working: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-60, 60' at line 1 select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -60, 60 [TEP STOP] I don't know what contributions you have installed, but have you tried copying the original site over to the new server, changing the configuration settings for the database settings etc. Truncate any product tables and then try adding your own products to see if they are displayed on the new site. That is exactly what I did, copied over the files exactly as I have them on my old site, exported the database and truncated the tables. I didn't have any troubles viewing the products (I have only loaded one as a test and its loading ok for me). I think the sql error you are getting is from the split page results class which I think only comes up when there are zero products (but there is one so that doesn't make sense). I tried it on a different computer in case I was getting cached product results, but the product page is working fine for me. That is wierd... Any ideas on why the forms wouldn't be submitting? Link to comment Share on other sites More sharing options...
ashleylr Posted January 29, 2007 Author Share Posted January 29, 2007 I think I see where you got that error, did you click on the "on sale" link? That is an error from not having any products that are on sale (again goes back to the split page results class). I just added a product to the specials table and that error went away. Link to comment Share on other sites More sharing options...
ashleylr Posted January 29, 2007 Author Share Posted January 29, 2007 any ideas on what could be causing all the forms not to submit the data through? I just don't know where that function is controlled... Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.