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?
Go to bottomPage: 1
TOPIC: Users sharing setup problem
#6959
Users sharing setup problem 13 Years ago Karma: 0
hi

We've setup for users sharing as per your tutorial: "How to share the users and extensions betweens websites ?" No 16

Get error display after create slave_1.a

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

Seems like we have not setup correctly the permissions/access rights for the database tables for the Slaves sites. Kindly advise where we may have done wrongly in the cPanel to setup the database/table user accounts/permissions.

Will appreciate very much an early reply and assistance.

Thanks very much for a great product.
andrew@somotweb.vn
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#6964
Re: Users sharing setup problem 13 Years ago Karma: 54
This is a "command denied to user" error returned by MySQL and discuss plenty of times in the forum.
In example

www.jms2win.com/en/forum/10-plesk-config...other-server-db#6271

Review the privileges of you MySQL user to give him the permission to create and show views.
See also the tutorial video 0.b - slide 35 that show how to modify the privileges with PHPMyAdmin.
www.jms2win.com/en/tutorial#jms12x-0b
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