update 3.0.2 to 3.0.3

[apweb]

Hi,
How update VM update 3.0.2 to 3.0.3 ??

[jenkinhill]

http://forum.virtuemart.net/index.php?topic=123808

[apweb]

Thanks for your quick reply.

I use Joomla 3.3.6 and VM 3.0.2 (fr)

In VM control panel
I can't find the button to update?

I also tried in Joomla Update control panel.

[GJC Web Design]

just download the zip - unzip and install the two packages as you would any other extension

all your settings and content will be untouched

http://dev.virtuemart.net/attachments/download/891/com_virtuemart.3.0.3_extract_first.zip

[AnSit]

After the upgrade 3.0.2 to 3.0.3 will not load the back-end of the site. And the title page the following error:

Code Select Expand

Fatal error: Uncaught exception 'RuntimeException' with message 'Subquery returns more than 1 row SQL=SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element FROM `test2_menu` as m LEFT JOIN test2_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 `test2_menu` as m LEFT JOIN test2_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' in ###/libraries/joomla/database/driver/mysqli.php:606 Stack trace: #0 ###/libraries/joomla/database/driver.php(1281): JDatabaseDriverMysqli->execute() #1 ###/administrator/modules/mod_vmmenu/helper.php(46): JDatabaseDriver->loadObjectList() #2 in ###/libraries/joomla/database/driver/mysqli.php on line 606


Can you please tell how to fix it now, without having to reinstall?

[GJC Web Design]

the error relates to Joomla's database driver - have done loads of vm3 installs and never seen this
Try to install 3.0.3 again

[AnSit]

So in fact the problem is that the train does not load has admin panel!
The menu is displayed only up menu Virtuemart and nothing can be done.
What to do in this case?

[GJC Web Design]

Ah .. I see it is related to the vm admin module

unpublish this in extensions->modules->

choose admin modules to find it

[AnSit]

Not possible to do the same change - does not work at all, no menus. 

[GJC Web Design]

think outside the box

either rename /administrator/modules/mod_vmmenu/helper.php to something else or disable the module in the database extensions table

[AnSit]

Thank You!
It turned out to recover only by restoring the table ### _ menu from the dump.

[GJC Web Design]

did you keep a copy of the corrupt one.. ? this sort of rings a bell ..
I had an upgrade to VM3 that had no VM admin mod links -- in the table were 3 sets - all wrongly attributed to comp number and/or parent id

would be interesting to see what went wrong with yours

[apweb]

Hello,

just download the zip - unzip and install the two packages as you would any other extension

all your settings and content will be untouched

http://dev.virtuemart.net/attachments/download/891/com_virtuemart.3.0.3_extract_first.zip

Is there a more modern approach?

I created a new site, then installed VM. After installation I got this warning.

[GJC Web Design]

More modern? ha .. the devs could add a gui, have some nice ajax effects, some draggy droppy stuff, lots of things to click, a popup or two... but why?
You want to put some zipped files on your server, expand them and run an installation script.. and that is exactly what you do...

the message is simply a warning and has been so explained at least 5-6 times in posts on here.. did u search?

[tomaa]

Thank You!
It turned out to recover only by restoring the table ### _ menu from the dump.

I had exactly the same problem as AS.
Spent hours to restore my db.
Could you explain how you restored yours?
Did you copy from a back-up?