CPanel and MySQL. Save me!
I created an account in MySQL that has full rights to all the databases on the server from the proper host and what not. I do a SELECT query in CF against the server and it works fine. I run an UPDATE or INSERT query and I get the following...
ODBC Error Code = 60 ()
[MERANT][ODBC MySql driver][MySql]Table 'bids' is read only
I checked /var/lib/mysql/mydatabasename and checked permisions. Everything looked fine at the file system level. I even made a test database chmod-ed 777. Still no luck.
Here is ware it gets weird. I write to the same databases uses PERL or PHP just fine. Its only CF that isnt working.
The driver its using is CFmysql15.so found in my /opt/coldfusion/lib/ directory.
I have installed CF5 a billion times on linux and never had this problem. This is the first one with cpanel and now its not working.
Any help anyone could give me on this would VERY appreciated. This is a production server and the work arounds are no longer working.
Help!!!
Thank you.
