Oscommerce revamp/Database fix

Looking for osc professional, to fix the database error of my current oscommerce website: [login to view URL] The error is user can not complete the whole purchasing [login to view URL] submit the checkout,it display the error page. Also there has a few small modifications need to be done: [login to view URL] pages for my footer text link [login to view URL] a few logo on the home page. [login to view URL] the admin protection Thank you!