|
JomSocial Data shared on install 15 Years, 6 Months ago
|
Karma: 0
|
|
When you choose to install JomSocial the data is shared by default. Also if you choose share from master you get many SQL errors. Also had the same issues with SOBI2
|
|
|
|
Last Edit: 2009/06/24 06:06 By kestertonm.
|
|
|
Re:JomSocial Data shared on install 15 Years, 6 Months ago
|
Karma: 54
|
|
Can you describe when you have those MySQL errors.
Is that at the moment you create the slave site and that you have choosen to share the data?
If YES, do you create the slave site into the same DB or into another DB ?
If you try to share the extension with a slave site into another DB, it is possible that you hosting provider does not accept to create a new user of the "new slave DB" into the DB that must be share. In this case, you either need to have the "root" MySQL login and password to allow create the new user required for the sharing OR create the slave site into the same DB than the one that you want to share.
When sharing the extension into the same DB, there is no problem as you are using the same MySQL login and password.
Can you give the error message.
It will help me identify the place where the error is produced.
|
|
|
|
Last Edit: 2009/06/24 09:27 By edwin2win.
|
|
|
Re:JomSocial Data shared on install 15 Years, 6 Months ago
|
Karma: 0
|
|
I get the same 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 Slave DB)
|
|
3www
Fresh Boarder
Posts: 5
|
|
|
|
|
Re:JomSocial Data shared on install 15 Years, 6 Months ago
|
Karma: 54
|
|
As I have explained in another post, this is a permission error in MySQL.
You have to grant the user to allow it access the tables.
Read completly the error message and you will see that the user is denied to access the table or create the view.
So refer to your MySQL administrator to ask him to grant your user authorise such sharing tables. Normally, when you use the same DB that should work except if the MySQL administrator does not allow using such functionality. When using the same DB, this mean that you use the same login and password and that should solve your problem.
Otherwise to have to grant the user to autorise access the other DB and tables.
Contact your MySQL administrator to give the permission.
Have you also checked that you are using MySQL 5.0 or higher.
|
|
|
|
Last Edit: 2009/07/07 16:06 By edwin2win.
|
|
|
Forum
