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: SOBI2 & JMS
#1186
SOBI2 & JMS 14 Years, 10 Months ago Karma: 0
I get sql errors when i try to share sobi2 with the master site.

I get the errors no matter if i use the same DB as the master or a seperate DB for the slave site.

Error(1) [1142] query [CREATE OR REPLACE VIEW

In both cases the DB user is the same (Master DB and Sl query [CREATE OR REPLACE VIEW

In both cases the DB user is the same (Master DB and Slave DB )
3www
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#1187
Re:SOBI2 & JMS 14 Years, 10 Months ago Karma: 54
If you had a look on the complete error message you probably have a "denied" access.
Give the full error message to know the reason.

The MySQL 1142 means that the user has no permission to access the table.
Check the permission of MySQL DB and perhaps you will have to grant the user to accept access the table.
You also have the possibility to provide to JMS the MySQL root login and password the let JMS try grant the user for you.
See user manuel chapter 3.2.2 page 14 where you will find how to gie the Root login an password to JMS.
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