Edwin

When propogating a component from the master to a slave via rules, it displays on the components menu on the slave site, but when selected on the slave site it displays a MSQL error. Method was define from master, as there was no install option or sharing.

To solve this I have copied the desired tables from the master site_id to the slave site_id. All done within the same DB as I dont seem to have database sharing.

The component now operates as it should.

My question is this, is it ok to do this. Will it cause any problems in the future?

Kev King

You mentioned a MySQL error but didn't provided the error message.
Without this detailled MySQL error message, it is difficult to identifying the orign of the problem.

So please provide a full detailled MySQL error message.

No this is not normal but without any detailled information, we can not help you fixing it.

Sorry Edwin

Here is one error message that is received when trying to access the component installed on the slave site via the administrator menu:

An error has occurred.

0 SQL=SELECT name FROM test2dir1_bl_addons WHERE published='1' AND name='Payments'

When I then go into my MYSQL database and perform a copy operation to replicate that table into the slave table that error goes. But it just brings up another error when you select that component again. Until you have replicated all the tables for that component.

I duplicated that via my test site.
My main site is now error free as I have replicated all tables using phpMYadmin.

I just wondered if it would cause problems in the future, when updating components that was all.

I don't see any error message in this SQL statmeent.
You should have received more info with the SQL error code and message that is not present in this message.
So I still don't know what is not correct in this SQL statemenet.

You should have an error code and also a detailled on the reason why this SQL statement has an error.
Please provide the full message with full details.

Give a screenshot to see where you received this message.
If this a message trapped by Joomla 3.2.x with a button to return to control panel.

If yes, you can sometime have more info when you enable the "debug" mode in the global configuration.
In this case, if you have a full trace, provide it.

11 Querries logged in total, but only error ones listed here.

Errors as listed below in more detail:

SELECT folder AS type, element AS name, params

FROM sl1_extensions

WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3,6)

ORDER BY ordering

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE sl1_extensions ref extension extension 62 const 50 Using where; Using filesort

SELECT name
FROM sl1_bl_addons
WHERE published='1'
AND name='Payments'

Explain
Error
SQL=EXPLAIN SELECT name FROM sl1_bl_addons WHERE published='1' AND name='Payments'

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

FROM sl1_modules AS m

LEFT JOIN sl1_modules_menu AS mm
ON mm.moduleid = m.id

LEFT JOIN sl1_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id

WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2014-03-24 19:38:42')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-03-24 19:38:42')
AND m.access IN (1,1,2,3,6)
AND m.client_id = 1
AND (mm.menuid = 0 OR mm.menuid <= 0)

ORDER BY m.position, m.ordering

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE m ALL PRIMARY,published,newsfeeds NO INDEX KEY COULD BE USED NULL NULL 15 Using where; Using filesort
1 SIMPLE mm ref PRIMARY PRIMARY 4 xxxxxxx_master.m.id 1 Using where; Using index
1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 303 xxxxxxx_master.m.module,const 1 Using where

SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native

FROM sl1_menu_types AS a

LEFT JOIN sl1_menu AS b
ON b.menutype = a.menutype
AND b.home != 0

LEFT JOIN sl1_languages AS l
ON l.lang_code = language

WHERE (b.client_id = 0 OR b.client_id IS NULL)

GROUP BY a.id, a.menutype, a.description, a.title, b.menutype,b.language,l.image,l.sef,l.title_native

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using temporary; Using filesort
1 SIMPLE b ref idx_menutype idx_menutype 74 xxxxxxx_master.a.menutype 3 Using where
1 SIMPLE l eq_ref idx_langcode idx_langcode 21 xxxxxxx_master.b.language 1


SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element

FROM sl1_menu AS m

LEFT JOIN sl1_extensions AS e
ON m.component_id = e.extension_id

WHERE m.client_id = 1
AND e.enabled = 1
AND m.id > 1

ORDER BY m.lft

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE m ref PRIMARY,idx_client_id_parent_id_alias_language,idx_componentid idx_client_id_parent_id_alias_language 1 const 40 Using where; Using filesort
1 SIMPLE e eq_ref PRIMARY PRIMARY 4 xxxxxxx_master.m.component_id 1 Using where

Hope you can make something of this Edwin.

Sorry but I don't see any MySQL error in the list of SQL statement that you provided.

You should have something like MySQL error with a code XXXX and near '...."

The only thing that I see in your list is a "explain error" but without description.
The explain detail shows that some index could be added to improve the performance.

All I can suggest is to try re-execute the statment with PHP MyAdmin and collect the error message if the statement can not be executed.
If the statement is executed, this mean that there is no MySQL error.

If you want that we have a look on your server to provide you a better diagnosis, this is still possible with our billable support that you can order at
www.jms2win.com/en/joomla-multisite?page...35&category_id=1