English (United Kingdom)
Jms Multi Site, formerly joomla multisite.
Create, share multiple joomla sites in few clicks !
Message
  • EU e-Privacy Directive

    This website uses cookies to manage authentication, navigation, and other functions. By using our website, you agree that we can place these types of cookies on your device.

    View e-Privacy Directive Documents

Welcome, Guest
Please Login or Register.    Lost Password?

Db error on creation of slave site
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Db error on creation of slave site
#4015
Db error on creation of slave site 14 Years, 8 Months ago Karma: 0
All's working well with our slave sites, and I wanted to create a new slave, with the same Website Template, but with a different DB prefix, in this case, indl_.

Error I am getting back is:

Error(1) [1142] query [CREATE OR REPLACE VIEW indl_users AS SELECT * FROM `induguia_jo151`.`master_users`]. DB Error: CREATE VIEW command denied to user 'induguia_jo151'@'localhost' for table 'indl_users' SQL=CREATE OR REPLACE VIEW indl_users AS SELECT * FROM `induguia_jo151`.`master_users`... etc.

Why?
miami
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#4016
Re: Db error on creation of slave site 14 Years, 8 Months ago Karma: 54
You will find plenty answers in this forum. Always the same reason for "command denied"
www.jms2win.com/forum/search?q=command+denied+to+user

You have to increase the privileges of your MySQL user to add "create and show view".
Also explained in the tutorial video CP-02 and in 0.b - slide 35
www.jms2win.com/tutorial#jms12x-0b
www.jms2win.com/tutorial#jms12x-CP-02
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
Last Edit: 2010/04/26 08:22 By edwin2win.
The administrator has disabled public write access.
 
#4022
Re: Db error on creation of slave site 14 Years, 8 Months ago Karma: 0
Yup, that's it "create views, show views" on Cpanel.
miami
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#4024
Re: Db error on creation of slave site 14 Years, 8 Months ago Karma: 54
cPanel does NOT provide this facility.
If you are using a shared hosting, you have to contact the support to grant your user.
If you have a dedicated server of have the "root" PHPMyAdmin, you can do it yourself.
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
get the latest posts directly to your desktop
2Win, Multisite(s) are trademarks of Edwin2Win.
Joomla