dj4uk Posted October 18, 2007 Share Posted October 18, 2007 I've been using OSCommerce for a website for a while and everything has been fine. I've now got a new development server and have downloaded the database and website scripts as a whole onto this so I have a development mirror. The website appears ok but catgeories and products can't be viewed. If I force it to go to a page /product_info.php?products_id=443 where I have checked a product with that ID exists in the database it says the product cannot be found. Also if I go into the admin area all the menus aren't working and seem to be replaced with variable names e.g. REPORTS_PRODUCTS. What have I done wrong!?! Any help would be good. DJ Link to comment Share on other sites More sharing options...
Guest Posted October 18, 2007 Share Posted October 18, 2007 I am assuming that you create the dbase on new server and imported the dbase from old one.You did adjust the configure.php to you new server and dbase name.If that is all correct then another option could be that you imported in wrong format(I had that happen to me).I think that 3 and 4 version are not compatible. Link to comment Share on other sites More sharing options...
dj4uk Posted October 23, 2007 Author Share Posted October 23, 2007 I am assuming that you create the dbase on new server and imported the dbase from old one.You did adjust the configure.php to you new server and dbase name.If that is all correct then another option could be that you imported in wrong format(I had that happen to me).I think that 3 and 4 version are not compatible. Yep database created and imported. Also configure.php is pointing to the local database. I'm doing a SQL dump from version 4.1.18 and then loading the SQL into the local database which is version 5.0.37. Link to comment Share on other sites More sharing options...
Guest Posted October 23, 2007 Share Posted October 23, 2007 Did you try to repair the dbase? Link to comment Share on other sites More sharing options...
dj4uk Posted October 23, 2007 Author Share Posted October 23, 2007 Did you try to repair the dbase? What do you mean repair? From looking at the data it's imported fine. Link to comment Share on other sites More sharing options...
dj4uk Posted October 26, 2007 Author Share Posted October 26, 2007 Anyone? I'm totally lost! Link to comment Share on other sites More sharing options...
Gauravs Posted October 26, 2007 Share Posted October 26, 2007 Are the servers identical (OS)? Typical problem if you have moved from a server which has register_global and register_long_arrays "on" and now not enabled on new server to show TEXT_FILENAME instead of user friendly 'My Files' kind of display. Use serverinfo.php on both servers (it is available in admin -> Tools -> Server Info) and compare what are the differences in two boxes. A contribution exists for register_long_arrays where you remove each $HTTP_POST with $_POST .. (or something similar) for couple of pages to overcome these issues. Cheers Best Regards,Gaurav Link to comment Share on other sites More sharing options...
dj4uk Posted November 1, 2007 Author Share Posted November 1, 2007 Are the servers identical (OS)? Typical problem if you have moved from a server which has register_global and register_long_arrays "on" and now not enabled on new server to show TEXT_FILENAME instead of user friendly 'My Files' kind of display. Use serverinfo.php on both servers (it is available in admin -> Tools -> Server Info) and compare what are the differences in two boxes. A contribution exists for register_long_arrays where you remove each $HTTP_POST with $_POST .. (or something similar) for couple of pages to overcome these issues. Cheers Hi pubdomains.com Both live and development servers are Windows boxes. But what you are describing fits exactly what I'm experiencing. Where would I find Server Info on a Windows machine? DJ Link to comment Share on other sites More sharing options...
dj4uk Posted November 1, 2007 Author Share Posted November 1, 2007 Hi pubdomains.com Both live and development servers are Windows boxes. But what you are describing fits exactly what I'm experiencing. Where would I find Server Info on a Windows machine? DJ Ah ha found that setting in the php.ini file. Now there is another problem: 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '35' [TEP STOP] Any ideas? Link to comment Share on other sites More sharing options...
dj4uk Posted November 2, 2007 Author Share Posted November 2, 2007 Sorted obviously a problem with PHP5 or MySQL 5 now works after applying: http://www.oscommerce.com/community/contributions,4654 Thanks for all the help DJ Link to comment Share on other sites More sharing options...
dj4uk Posted December 3, 2007 Author Share Posted December 3, 2007 Ok then another issue I can add an item to the basket and it appears in the quick basket (top right) however as soon as I click a link to a new page the basket empties! I've checked sessions are working correctly and they are - any ideas? Dave 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.