I have used JMS on my local host, all worked very well and most pleased with JMS' capability. I moved my joomla folders and tables to a Hosting provider, modified configuration files, all looks ok. However getting the following message when creating a slave -
Error(1) [1142] query [CREATE OR REPLACE VIEW tt2_users AS SELECT * FROM `DBname`.`ct_users`]. DB Error: CREATE VIEW command denied to user 'username@'localhost' for table 'tt2_users' SQL=CREATE OR REPLACE VIEW tt2_users AS SELECT * FROM `DBname`.`ct_users`.
I have asked the hosting provider to ensure privilges have been granted to Create Views and Show Views, due to a problem in Cpanel. The problem has not been corrected - Mysql version used is 5.0.91-community.
Reply from Hosting provider is -
"One of our system administrators believes it has worked {create & show views} at some point and that it appears a it is a bit unreliable and a bug still exists, whether it improved in some versions and then got worse again we are unsure.
We are not convinced this can be done as it is not an advertised feature yet and only a recently introduced feature in mySQL and mySQL's support for views is not perfect yet in our opinion.
It appears to be a mySQL bug and not a cPanel bug,
bugs.mysql.com/bug.php?id=9034. And looks like a deadlock because you can't create it unless it exists, if it exists, you can't create it because it already exists!
Is this correct, I hope not, as I would think that anyone using JMS is utilising MySQL Views.
Can you please confirm if or not a issue with MySQL and views. And any information that would assist me in resolving the issue with my host.
Many thanks
Forum
