IlColosso Posted March 15, 2007 Posted March 15, 2007 Hello people. I'm driving myself totally CRAZY with the moving of my site. I've tried to make it easy, uploaded everything to the right folders, then I've imported the database, and managed to get the site "working" on the temporal address before changing the DNS. I've tried all the functions to make sure it was working completely, and by surprise, I saw that the "new product" or "edit product" page was not working properly. It got truncated when the products attribute should have been changed. Note I'm using that contribution that allows product attributes to be handled directly from there. The problem is basically, I can't understand WHY a patch can work in one server, but not on the other, having the same files, the same database... Plus I can't find a way to have PHP to show me the error at least... ANY help would be appreciatted, even if I have to pay a reasonable price for it Thanks
smithygotlost Posted March 15, 2007 Posted March 15, 2007 With The Server If You Used To Use For Example Server 1 With host 1 Then You Move To Server 2 With Host 2 They may be using different Mysql Setup Or A Different Bare Bone For Their Server Is The Server With The Same Hosting Company ?
satish Posted March 15, 2007 Posted March 15, 2007 two issues are and there generally faced. PHP version and Mysql version. So just compare. Also environment variable setting. Satish Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does.
IlColosso Posted March 15, 2007 Author Posted March 15, 2007 With The Server If You Used To Use For Example Server 1 With host 1 Then You Move To Server 2 With Host 2 They may be using different Mysql Setup Or A Different Bare Bone For Their Server Is The Server With The Same Hosting Company ? Thanks for your help. As far as I see on the server config, yes, the MySql versions are different. However, I've tried with a clean database too, and the problem remained. About the second, I don't know what do you mean with "a different bare bone", even I've tried to search in google to see if I could understand it. My site is currently in an Argentinian host, and I'm triying to move it to midphase. By default, they've sent me to PHP 5 server, I requested it to be moved to PHP 4, and they did, actually it's the same version that I had, 4.4.4 so there's nothing to claim on there I guess.
IlColosso Posted March 15, 2007 Author Posted March 15, 2007 two issues are and there generally faced.PHP version and Mysql version. So just compare. Also environment variable setting. Satish Well, PHP version is the same, Mysql is not, but I've also compared it with a clean oscommerce database. I will try to ask anyway to change the Mysql version too, if possible. Mysql on Midphase is 4.1. On my previous server is 4.0. Could it be that the default Oscommerce database is made for a different Mysql and that I should import it with a different method or convert it to the actual midphase edition?
radders Posted March 15, 2007 Posted March 15, 2007 Exporting from mysql importing again can be problematical. There are issues with character set that I have commented on recently (exporting using the Latin1 character set being probably the best way). Also there can be data corruption (though a good host would probably catch that before it became a problem) and invalid characters causing imports to be truncated. In that case you can edit the file before you import to remove the problem. I gather also that not all php string functions are multi-byte safe which could afect data in UTF-8 format. - I have never come across this problem. The others I have!
IlColosso Posted March 15, 2007 Author Posted March 15, 2007 I gather also that not all php string functions are multi-byte safe which could afect data in UTF-8 format. Does this mean I should change from UTF-8 to try?
IlColosso Posted March 15, 2007 Author Posted March 15, 2007 FUCK, it works now. The bad thing is that I've tried so much now I can't even know what the hell I did to make it work. Thanks everybody, I'll surely be here again with more troubles soon... Murphy laws are always near me.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.