Moving MySQL data from 4.0 to 5.x
I needed to move date from one database to another.The source DB was MySQL 4.0 and the destination was MySQL 5.1. And all the problems was with UTF-8 symbols. I couldn’t get it to work on MySQL 5.1. I search on the internet and figured out that MySQL 4.0 does not support UTF-8 and it is supported only from MySQL 4.1.
You can store UTF-8 date on MySQL 4.0 but it’s not encoded using UTF-8. The data is encoded using the default encoding ‘Latin1′, so the only thing what you need is to make an export file and upload using PhpMyAdmin, but dont forget to select that the data is encoded ‘Latin1′ and not UTF-8.
Another FedEx class update
FedEx supports only 150 pound per package, so if you are trying to calculate rates for package which weight more than 150 you get an error. The fix was made and now PackageCount is automatically counted by given weight.
You can download updated FedEx class from this post.
PHP: FedEx shipping rates calculator updated
One user was using my FedEx class and could not get rates for Ground service. I have just figured out what was the problem. First of all Ground and Home delivery are ground services and you must set Carrier code to FDXG.
After this I found few bugs witch I fixed and now you can download updated FedEx class from this post.
406 Not Acceptable error
This is an error I got today:
406 Not Acceptable
An appropriate representation of the requested resource /index.php could not be found on this server.
I saw it for the first time and tried to find out where’s the problem. And the problem was in Apache mod_security. I have disabled mod_security specific to resolve the 406 errors. Sometimes mod_security rules are too strict for some web applications.
In order to disable mod_security add this line to .htaccess file: SecFilterEngine Off
Godaddy promo code | renew .NET
My anekdotai.net domain expiration was going to the end so today i decided to renew it. And first of all I was looking for godaddy promo codes. Most of them were not working or already expired but there are two codes still working:
.NET Domain Names Just $5.99/yr!
gdm0431 expires 15 may 2007
SAVE 25% on every .COM, .NET, .ORG, .MOBI, .NAME, .BIZ, .US, .TV and .WS domains.Expires: May 7, 2007
gdm0420a May 7, 2007