Hey newbie225. I moved your thread to the Mambo category. I am no Mambo guru but it seems your first issue would be to find out what version of mySQL you were using on your old server since the screenshot you provided seems to indicate that the db syntax maybe different? Perhaps if you can get that fixed we can get to your second issue. It's a starting place anyways  I would need to know what server you are on to be sure which versions it has.

I hope this helps,
RandyT

Hi. We have different security settings on our server which do reserve certain words to help prevent hacking. Every webhost will have different settings.

You can backup configuration.php and then edit it to the current password you are using. It should not have to be encoded. If it does need to be encoded, it is likely using MD5. You can encode the current password at http://scriptserver.mainframe8.com/md5.php and then paste the result into configuration.php

I looked at your database and it does not appear to have completely imported. You may be able to export it in Mysql40 compatible format at your old host in phpmyadmin to make it work on the current server. If you still have issues, we do have 1 PHP5/Mysql5 server available named Kwan which we can move the site to if you email support@lunarpages.com with your request.

.