Is it possible to change write permissions for a mysql database or do I have to request it to be done? I am using cfwebstore and it can't write its own errors to the database so I can't troubleshoot things.

Thanks for the help.

mysql does have an error logging and query logging feature but it's a server wide setting and wouldn't be turning on in a shared environment. HMS offers phpmyadmin from the control panel. If you have an account with them feel free to use it for testing your mysql queries. Another option is to test from the mysql command prompt. Errors are also displayed there.

I know exactly what errors your talking about. I use CFWebstoreEXT.

The error catching actually writes to disk as well as the database. I use a windows server and a MSSQL 2005 database and the permissions are fine. If you are on a Unix server, make sure the directory [webroot]/temp/errors has permissions of 777. If you are on windows, your permissions should be fine though.

You can't change your permissions in MySQL database with HMS, but i don't think that's your problem if you are able to Add, Update, and delete products.

I have several sites with HostMySite running CFWebStoreEXT. If you ever run into problems with it, let me know. I can probably help.