As the title say, I simply don't know how to upgrade to version 3.0.12. I get this error every time I try. What could cause the problem? Some extension?
<title>Error: 1242 Subquery returns more than 1 row SQL=SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element FROM `j3vm3_menu` as m
LEFT JOIN j3vm3_extensions AS e ON m.component_id = e.extension_id
WHERE m.client_id = 1 AND e.enabled = 1 AND m.id > 1 AND e.element = 'com_virtuemart'
AND (m.parent_id=1 OR m.parent_id =
(SELECT m.id FROM `j3vm3_menu` as m
LEFT JOIN j3vm3_extensions AS e ON m.component_id = e.extension_id
WHERE m.parent_id=1 AND m.client_id = 1 AND e.enabled = 1 AND m.id > 1 AND e.element = 'com_virtuemart'))
ORDER BY m.lft</title>
Cheers
/Betterlead
Edit: Yes I found this: http://forum.virtuemart.net/index.php?topic=127961.0 but still don't have a clue, how to fix it.
Link to my develop site: www.livingstudio.se/Aliv
Hi,
I don't understand everything in the error message, but I would check if you have duplicate entries in the Joomla menu and extension tables. Perhaps you have VirtueMart listed twice for some reason. If I remember correctly duplicate entries can happen if an installation doesn't complete.
Hi,
Could it have something to do with an extra fix I let a company make for me - a menu for manufacturers? It looks like I have both menu modules in /modules. I mean mod_menu original Virtuemart and the "fixed" one.
Quote from: betterlead on February 21, 2016, 09:23:15 AM
Hi,
Could it have something to do with an extra fix I let a company make for me - a menu for manufacturers? It looks like I have both menu modules in /modules. I mean mod_menu original Virtuemart and the "fixed" one.
I suppose that will be the problem, if both modules have the same name. I would suggest to backup the table and perhaps the complete database and then delete one of the duplicate lines in the table and check if the error message still shows.
Greatings JJK
If I only knew how and had the nerve to dig and fix in the database...
Screenshot of the component drop down menu, after the upgrade.
Looking at the j3vm3_menu table with phpMyAdmin, did you find duplicate lines? If not, did you try the 'Menus' > 'Rebuild' button already?
Anybody?
Someone told me there is probably something wrong in the update script.
Does this tell anybody what could be wrong?
SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM `j3vm3_menu` AS m
LEFT JOIN j3vm3_extensions AS e ON m.component_id = e.extension_id
WHERE m.client_id =1
AND e.enabled =1
AND m.id >1
AND e.element = 'com_virtuemart'
AND (
m.parent_id =1
OR m.parent_id = (
SELECT m.id
FROM `j3vm3_menu` AS m
LEFT JOIN j3vm3_extensions AS e ON m.component_id = e.extension_id
WHERE m.parent_id =1
AND m.client_id =1
AND e.enabled =1
AND m.id >1
AND e.element = 'com_virtuemart'
)
)
ORDER BY m.lft
LIMIT 0 , 30
[ Infogad ] [ Redigera ] [ Förklara SQL-kod ] [ Skapa PHP-kod ] [ Uppdatera ]
Startrad: Antal rader: Rubriker var rad
+ Alternativ
id title alias link parent_id img element
969 COM_VIRTUEMART com-virtuemart index.php?option=com_virtuemart 1 ../components/com_virtuemart/assets/images/vmgener... com_virtuemart
970 COM_VIRTUEMART_MENU_CATEGORIES com-virtuemart-menu-categories index.php?option=com_virtuemart&view=category 969 components/com_virtuemart/assets/images/icon_16/me... com_virtuemart
971 COM_VIRTUEMART_MENU_PRODUCTS com-virtuemart-menu-products index.php?option=com_virtuemart&view=product 969 components/com_virtuemart/assets/images/icon_16/me... com_virtuemart
972 COM_VIRTUEMART_MENU_ORDERS com-virtuemart-menu-orders index.php?option=com_virtuemart&view=orders 969 components/com_virtuemart/assets/images/icon_16/me... com_virtuemart
973 COM_VIRTUEMART_MENU_REPORT com-virtuemart-menu-report index.php?option=com_virtuemart&view=report 969 components/com_virtuemart/assets/images/icon_16/me... com_virtuemart
974 COM_VIRTUEMART_MENU_USERS com-virtuemart-menu-users index.php?option=com_virtuemart&view=user 969 components/com_virtuemart/assets/images/icon_16/me... com_virtuemart
975 COM_VIRTUEMART_MENU_MANUFACTURERS com-virtuemart-menu-manufacturers index.php?option=com_virtuemart&view=manufacturer 969 components/com_virtuemart/assets/images/icon_16/me... com_virtuemart
976 COM_VIRTUEMART_MENU_STORE com-virtuemart-menu-store index.php?option=com_virtuemart&view=user&task=edi... 969 components/com_virtuemart/assets/images/icon_16/me... com_virtuemart
977 COM_VIRTUEMART_MENU_MEDIAFILES com-virtuemart-menu-mediafiles index.php?option=com_virtuemart&view=media 969 components/com_virtuemart/assets/images/icon_16/me... com_virtuemart
978 COM_VIRTUEMART_MENU_SHIPMENTMETHODS com-virtuemart-menu-shipmentmethods index.php?option=com_virtuemart&view=shipmentmetho... 969 components/com_virtuemart/assets/images/icon_16/me... com_virtuemart
979 COM_VIRTUEMART_MENU_PAYMENTMETHODS com-virtuemart-menu-paymentmethods index.php?option=com_virtuemart&view=paymentmethod 969 components/com_virtuemart/assets/images/icon_16/me... com_virtuemart
980 COM_VIRTUEMART_MENU_CONFIGURATION com-virtuemart-menu-configuration index.php?option=com_virtuemart&view=config 969 components/com_virtuemart/assets/images/icon_16/me... com_virtuemart