kellin Posted June 23, 2009 Share Posted June 23, 2009 I looked this up already and couldnt find specifically what I wanted, so Im posting here... Im doing a full migration of a server from one machine to another (full replacement, IP address and everything), and Ive gotten everything working, except for one little weird OS Commerce problem... For the sake of simplicity, Ive put all website directories in the same place as the old server, along with all the mysql databases. Initially everything looked great, but when I went to try to use the site, clicking on the different categories wont change to them. I figure its not a configuration problem, as the server files are located where they were originally, and Ive verified the rights are correct on the various files, and even verified all the mysql database files were moved over (at least by size and number, using du). So, Im guessing its something in one of the mysql database files? Maybe some data needs to be flushed, but I have no idea what... Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted June 23, 2009 Share Posted June 23, 2009 You could backup the old db and restore it to the the new db. Alternative is to repair all the tables using phpmyadmin Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
kellin Posted June 23, 2009 Author Share Posted June 23, 2009 this assumes Im even using phpmyadmin. Alright. I'll look up how to do either... is there a way withing mysqladmin to repair tables? You could backup the old db and restore it to the the new db. Alternative is to repair all the tables using phpmyadmin Link to comment Share on other sites More sharing options...
GemRock Posted June 23, 2009 Share Posted June 23, 2009 this assumes Im even using phpmyadmin. Alright. I'll look up how to do either... is there a way withing mysqladmin to repair tables? you could try to disable cache before attempting anything complicated i guess you db is OK or you wont see your site at all. Ken commercial support - unProtected channel, not to be confused with the forum with same name - open to everyone who need some professional help: either PM/email me, or go to my website (URL can be found in my profile). over 20 years of computer programming experience. Link to comment Share on other sites More sharing options...
kellin Posted June 23, 2009 Author Share Posted June 23, 2009 thats what I figured. Im running another site on the same server using a different php package and obviously different mysql database, and that seems to be working fine. How do i disable cache? you could try to disable cache before attempting anything complicated i guess you db is OK or you wont see your site at all.Ken Link to comment Share on other sites More sharing options...
GemRock Posted June 23, 2009 Share Posted June 23, 2009 configuration -> cache - use cache - false. Ken commercial support - unProtected channel, not to be confused with the forum with same name - open to everyone who need some professional help: either PM/email me, or go to my website (URL can be found in my profile). over 20 years of computer programming experience. Link to comment Share on other sites More sharing options...
kellin Posted June 23, 2009 Author Share Posted June 23, 2009 Its already set to false. I did notice something in the admin page on the new server that's amiss... When I go into the admin page, about a third of the links show what appears to be the variable name, instead of the actual name. For instance the "Orders" section (lists pending, processed and delivered) reads "BOX_TITLE_ORDERS" instead of just "Orders". Im guessing this means there _is_ a configuration problem somewhere.. though there really shouldn't be, as Ive put everything in the same place it was as in the old server... configuration -> cache - use cache - false.Ken Link to comment Share on other sites More sharing options...
kellin Posted June 24, 2009 Author Share Posted June 24, 2009 Also, I discovered its doing something similar in the admin pages, under the configuration section. It only loads the top item "My Store". None of the other sections underneath it will load. Im beginning to wonder if this is a php configuration problem? Link to comment Share on other sites More sharing options...
ABCommerce! Posted June 24, 2009 Share Posted June 24, 2009 Your hosting package name will not be the same on both servers. It is something like /home/?????/public_html/ It is in both configure.php files. Link to comment Share on other sites More sharing options...
kellin Posted June 24, 2009 Author Share Posted June 24, 2009 huh? If you're referring to document root, then yes, it is the same on both servers.. seeing as theyre both sitting in the same room and accessible via terminal. The new server has a fresh copy of Fedora Core 10 (dont ask, it wasnt my choice). both servers point to /var/www/html/{dir}/catalog and the httpd.conf file has the same references. As I said, its a near duplicate copy of the old server, with some minor changes to versions and conf files. The other mysql/php website Ive got running (not an oscommerce site) works perfectly fine. Your hosting package name will not be the same on both servers. It is something like /home/?????/public_html/ It is in both configure.php files. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.