Hi Edwin,


refering to my other post

www.jms2win.com/en/forum/24-joomla-multi...e-konfiguration#9102

a) How one has to deal with new extensions generally?

- E.g.: I installed a new extension on the mastersite ("Artof User").
- Now there is a message under "managed sites" saying something abot "new extension ... edit and resave the slave site ..."

What has to be done precisely?
"Define extensions" under "jms tools"?
How should the slave site be "edited and resave"?

Or shall I better install the "Artof User" separately in the slavesite?

b) what has to be done, when a extension is upgraded?

The documentation says

"Now when saving a slave site based on a “website template” there is an
automatic syncrhonisation of new extension installed.
This allow now update the “website template” an refresh the children slave
site with the new extensions installed;"


How is the template updated and how the slave refreshed?

What means "propagate"? What happens?

c) How should I deal with "Artof User"?

Until now, it looks, that I can work with "Artof User":

1. I define a new group in the mastersite-administration

2. I put a user mastersite-administration in this new group

3. Since this group is shown in the slave site administration too, I just set the access permissions for a special kunena-forum-category to this new group (the kunena forum is separate kunena-form in the slavesite.


Bests Mark

A) When an extension is not defined in JMS Tool menu, you have to re-install it in the slave site to let the extension create the MySQL tables used by the extension.
If you use JMS Tool to just "define the extension", this will just add the extension in the menu but not create any MySQL tables as its definition does not exists.
This is the reason why you have to go in the slave site back-end to re-install the extension.

b) When an extension has an upgrade, you have to re-install the extension in the back-end of the slave site to let the extension execute its specific PHP code to perform the upgrade.
Read also the user manual chapter 8.

Where did you read (page number, URL link) that there is antumatic synchronization of the extension installed ?

Open/Resave a slave site definition may sometimes update the missing extension when the website to replicate has new extension installed. In this case, this add the extnesion and create the missing MySQL tables.

Propagate mean that you can perform the same action to the children websites.
For example uninstall an component in the current websites and all its children slave sites.

c) I don't know what is "Artof User"

If you want that we review and new extension, you can send us the extension in the attachement of an email.
See contact us for the email address.

b) I read it in "jms2win_UsersManual_V120.pdf", chapter 1.2 (on page 5/67, second bullet point)


c) I sent you a message.

I was wrong, I can NOT work with artofusers on the mastersite. So - following you answer to a) - I installed artofuser on the slavesite too.

But I still have problems.

1. I created user a on the mastersite

2. I put him in a group I on the mastersite (with artofuser)

3. I set permissions in kunena 2 (of the slavesite) for user a

4. but the permission set categories are still shown on the slavesite, or still accessible through user a

5. then I installed artofuser on the slavesite

6. but the permission set categories are still shown on the slavesite, or still accessible through user a.
Reason is, that the installing of artofuser on the slavesite does not create an independant artofuser-instanz. Artofusers creates new groups, that are written in the table "prefix_core_acl_aro". And this table IS shared with the mastersite or the master-tables.

Do you have any idea, what could be the reason why the (independant) kunena forum in the slavesite does not respect the permissions of the users (shared among the master- and the slavesite)?

The Artof User definition is added in the JMS patch definition 1.2.77.
www.jms2win.com/en/faq/change-history-v12x

This extention can not be shared.

edwin2win wrote:
A) When an extension is not defined in JMS Tool menu, you have to re-install it in the slave site to let the extension create the MySQL tables used by the extension.
If you use JMS Tool to just "define the extension", this will just add the extension in the menu but not create any MySQL tables as its definition does not exists.
This is the reason why you have to go in the slave site back-end to re-install the extension.

b) When an extension has an upgrade, you have to re-install the extension in the back-end of the slave site to let the extension execute its specific PHP code to perform the upgrade.
Read also the user manual chapter 8.



I run

- a mastersite "master" and
- a slavesite "zertifizierung"
- a slavesite "zero"

I lately upgraded the master

- Community builder Cb 1.4 to cb 1.8 and
- Community Builder Group Jive to GJ 2.5

But I could not upgrade zertifizierung and zero

to GJ 2.5 and some other plugins

After upgrading the backup script stopped and the following message occured:

mysqldump: Couldn't execute 'show create table `zero_groupjive_categories`':
View 'c1joomla.zero_groupjive_categories' references invalid table(s) or
column(s) or function(s) or definer/invoker of view lack rights to use them
(1356)
mysqldump: Couldn't execute 'show create table `zero_groupjive_groups`':
View 'c1joomla.zero_groupjive_groups' references invalid table(s) or
column(s) or function(s) or definer/invoker of view lack rights to use them
(1356)
mysqldump: Couldn't execute 'show create table
`zero_groupjive_plugin_events`': View
'c1joomla.zero_groupjive_plugin_events' references invalid table(s) or
column(s) or function(s) or definer/invoker of view lack rights to use them
(1356)
mysqldump: Couldn't execute 'show create table
`zertifizierung_groupjive_categories`': View 'c1joomla.zertifizierung_groupjive_categories' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'show create table
`zertifizierung_groupjive_groups`': View 'c1joomla.zertifizierung_groupjive_groups' references invalid table(s) or
column(s) or function(s) or definer/invoker of view lack rights to use them
(1356)
mysqldump: Couldn't execute 'show create table
`zertifizierung_groupjive_plugin_events`': View 'c1joomla.zertifizierung_groupjive_plugin_events' references invalid
table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW CREATE TABLE `zero_groupjive_categories`':
View 'c1joomla.zero_groupjive_categories' references invalid table(s) or
column(s) or function(s) or definer/invoker of view lack rights to use them
(1356)
mysqldump: Couldn't execute 'SHOW CREATE TABLE `zero_groupjive_groups`':
View 'c1joomla.zero_groupjive_groups' references invalid table(s) or
column(s) or function(s) or definer/invoker of view lack rights to use them
(1356)
mysqldump: Couldn't execute 'SHOW CREATE TABLE
`zero_groupjive_plugin_events`': View
'c1joomla.zero_groupjive_plugin_events' references invalid table(s) or
column(s) or function(s) or definer/invoker of view lack rights to use them
(1356)
mysqldump: Couldn't execute 'SHOW CREATE TABLE
`zertifizierung_groupjive_categories`': View 'c1joomla.zertifizierung_groupjive_categories' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW CREATE TABLE
`zertifizierung_groupjive_groups`': View 'c1joomla.zertifizierung_groupjive_groups' references invalid table(s) or
column(s) or function(s) or definer/invoker of view lack rights to use them
(1356)
mysqldump: Couldn't execute 'SHOW CREATE TABLE
`zertifizierung_groupjive_plugin_events`': View 'c1joomla.zertifizierung_groupjive_plugin_events' references invalid
table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)


What has happened? How can I solve the inconsistency problem.

The MySQL error message report you that the table that you make reference does not exists.
So if you changed of DB or rename table or otherthing, you need to rebuild the links between the websites.

The backup failed because the table are no more present.
So fix your websites DB tables and views to provide a DB that contain consistent relation between table.

I suspect that you upgrade changed or rename tables.