Hallo,
After the update from 3.02 to 3.04 I can no longer work in the backend. It is the message: Error 1242 subquery returns mor than 1 row SQL = ... How can I solve this problem?
Many Thanks!
Manuel
there have been some reports of the VM admin menus getting confused.. try disabling in the extensions table the VM admin menu module
that's it. After deleting the module mod_vmmenu from the table extensions everything goes.
Thanks for the quick help! :)
Manuel
I had the same issue. You guys saved me some serious road rash since I was about the blow on a backup from last night! Thanks.
When I went to install the AIO, the same error resulted, and I had to delete mod_vmmenu AGAIN.
This is an issue that should be fixed before many like us run into the same thing.
BTW - Now I have no Virtuemart menu in the main menu bar, but have two VM menus in the components menu. Had to manually delete the duplicate menu item.
Allen
to get your menu mod back just go ext->module manager
filter: administrator
then make a new Administrator VM Menu and publish to menu position
if you cleaned up your admin menus ok in the table it should now be OK
Quote from: GJC Web Design on February 03, 2015, 00:40:04 AM
to get your menu mod back just go ext->module manager
filter: administrator
then make a new Administrator VM Menu and publish to menu position
if you cleaned up your admin menus ok in the table it should now be OK
But when I delete the "mod_vmmenu" from the extension table (without this I can't do anything in the admin) I can't make a new Admin menu of course...
Matt
reinstall it first obviously - from the AIO pack
I've got the same problem >:(
i'cant use the backend, but my front end is still working well (apparently)
How to fix that ?
you post the question in a thread that contains the answer... what's that about?
try again... ->
Quotethere have been some reports of the VM admin menus getting confused.. try disabling in the extensions table the VM admin menu module
Quote from: alain1 on February 12, 2015, 17:38:54 PM
"there have been some reports of the VM admin menus getting confused.. try disabling in the extensions table the VM admin menu module"
How to do this ?
I can't log on my administrator page !
Is anybody here to help me fixing this problem ?!?!?
Please see http://forum.virtuemart.net/index.php?topic=104795.0
Quote
try disabling in the extensions table the VM admin menu module
= remove the reference in the database. Not in the site BE. In table ###_modules (but backup the db first, just in case)
Quote from: jenkinhill on February 13, 2015, 12:12:39 PM
= remove the reference in the database. Not in the site BE. In table ###_modules (but backup the db first, just in case)
the site BE ?
what do you means by "BE" ?
BE -> back end -> admin
ok, so now my backend website is totally down !
:( >:(
Please ! How to solve this problem ?
Try the new installer vm3.0.6, it may fix it.
Quote from: Milbo on February 20, 2015, 16:16:51 PM
Try the new installer vm3.0.6, it may fix it.
Hi !
Thanks for your reply.
Unfortunately not, it's exactly what i've done ! i have Virtuemart 3.0.4 installed,and when i'm tryint to install the new version 3.0.6, everything in the backend crash down...and this error code appears....
Hello,
After updating from VM 3.0.4 to 3.0.6 I got the same error 1242 as Bambino.
My back-end turned to white now displaying error message up in the blue.
Thanks to the information in this thread I was able to get the back-end working again. :-)
(although I found it scary to go for the first time into a database and actually deleting a line - did back-up the database)
Now I am left with a double VM entry in the Component-dropdown menu.
What should I do to delete one of them?
1st - as you did - back up everything
then search in your #__menus table for duplicate entries for the com_virtuemart ext .. delete the older of each one
Thanks GJC, worked perfectly.
There were two sets of com_virtuemart that I had to delete.
Left the last set in the database ###_menu and all works well now.
Excellent - see - you'll become a top gun at DB manipulation now...
I just tried to update to Virtuemart 3.0.9, and got this 1242 error. I noticed from this thread that doing the following seems to work:
"try disabling in the extensions table the VM admin menu module"
"After deleting the module mod_vmmenu from the table extensions everything goes"
Since I am more of a graphic artist than a web developer, can anyone simplify this a little more? A screenshot of where I can make this change would be great!
I am assuming I am not the only newbie out there, so there might be other people who might find a simpler explanation more useful.
Thanks again for your help.