News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

update 3.0.2 to 3.0.3

Started by apweb, January 15, 2015, 17:56:41 PM

Previous topic - Next topic

apweb

Hi,
How update VM update 3.0.2 to 3.0.3 ??

jenkinhill

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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:

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

apweb

Hello,
Quote from: GJC Web Design on January 15, 2015, 20:01:39 PM
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?
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

tomaa

Quote from: AS on January 16, 2015, 10:38:06 AM
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?