This is company website, and from the accesses I have it seems company called melbourneIT has setup the website.
In the control panel access, there is a button “Change to MySQL5” under Databases > MySQL section. Current version is 4.1.22. I am guessing this is something got to do with my problem. Requesting Tech Help to update MySQL to 5 might be a good idea?
