Author Topic: VM2 administration left menu missing  (Read 9808 times)

Artanis

  • Beginner
  • *
  • Posts: 32
  • Zusurs...
    • Animus Design Studio (coming soon)
VM2 administration left menu missing
« on: June 24, 2012, 08:40:37 am »
Hello!

My client asked me to merge two VM databases and shop data - it worked unbelievably well for products and categories, but something went wrong in the backend and now I don't see left side VM2 menu in administration panel (see screenshot below). Could someone help me - how to repair VM2 backend by leaving products/categories/config/etc. intact?

Best regards, thanks for answer in advance.

[attachment cleanup by admin]
Animus Project - Design Studio
Running Joomla 2.5.6, Virtuemart 2.0.6a, PHP 5.3.10

Artanis

  • Beginner
  • *
  • Posts: 32
  • Zusurs...
    • Animus Design Studio (coming soon)
Re: VM2 administration left menu missing
« Reply #1 on: June 24, 2012, 08:50:09 am »
SOLVED:

I managed to copy URL to Tools section from another VM2 admin panel:
/administrator/index.php?option=com_virtuemart&view=updatesmigration

Then used button "Install tables or if necessary update them" this reinstalled database table called "joomla_adminmenuenteries"
Now left side menu in VM2 is visible again!

Thank you - just wanted to share solution - maybe someone else will stumble upon the same problem.
Best regards.
Animus Project - Design Studio
Running Joomla 2.5.6, Virtuemart 2.0.6a, PHP 5.3.10

her63

  • Beginner
  • *
  • Posts: 14
  • beginner
    • toko bunga makassar
Re: VM2 administration left menu missing
« Reply #2 on: August 06, 2012, 07:25:14 am »
  I have tried but not working what should i do , the message No SQL file provided


MADmarion

  • Beginner
  • *
  • Posts: 8
Re: VM2 administration left menu missing
« Reply #3 on: September 27, 2012, 11:25:21 am »
I have the same problem and the solution on top did not work!

I dont know what to do... I'm actually setting up a virtuemart shop, but all the important settings are missing, as I have no left admin menu! Heeelp!

monak83

  • Beginner
  • *
  • Posts: 14
Re: VM2 administration left menu missing
« Reply #4 on: October 05, 2013, 12:32:21 pm »
I ahve the same issue, I have also updato to last version 2.0.24 but LEFT ADMIN PANEL is missed...i see only PRODUCTS Tab.
Any ideas to fix?
Regards
monak83

Maxim Pishnyak

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2656
Re: VM2 administration left menu missing
« Reply #5 on: October 06, 2013, 12:26:06 pm »
Your 3rd party extensions?
You can support Community by voting for Project on the JED
https://extensions.joomla.org/extension/virtuemart/#reviews
Join us at
https://twitter.com/virtuemart

monak83

  • Beginner
  • *
  • Posts: 14
Re: VM2 administration left menu missing
« Reply #6 on: October 08, 2013, 16:24:28 pm »
I have found this: on Database Table PREFIX_virtuemart_adminmenuentries I have only an entry.
Is this that generate all LEFT PANEL items to manage VM admin?
Probably when I have upgade to last version broke this table.
Ho can I add all menu item?

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28324
  • Always on vacation
    • Jenkin Hill Internet
Re: VM2 administration left menu missing
« Reply #7 on: October 08, 2013, 16:55:54 pm »
I suspect a reinstall using Joomla's extensions installer is the approach to use (backup first).
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

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

Currently using VirtueMart  4.0.2 10661 on Joomla 3.10.9 PHP 7.4.29

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10283
  • VM3.9 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: VM2 administration left menu missing
« Reply #8 on: December 19, 2013, 20:38:03 pm »
This is not checked by the updater.
Just use phpmyadmin, adjust the prefix and fire it
Code: [Select]
INSERT INTO `#__virtuemart_adminmenuentries` (`id`, `module_id`, `parent_id`, `name`, `link`, `depends`, `icon_class`, `ordering`, `published`, `tooltip`, `view`, `task`) VALUES
(null , 1, 0, 'COM_VIRTUEMART_CATEGORY_S', '', '', 'vmicon vmicon-16-folder_camera', 1, 1, '', 'category', ''),
(null, 1, 0, 'COM_VIRTUEMART_PRODUCT_S', '', '', 'vmicon vmicon-16-camera', 2, 1, '', 'product', ''),
(null, 1, 0, 'COM_VIRTUEMART_PRODUCT_CUSTOM_FIELD_S', '', '', 'vmicon vmicon-16-document_move', 5, 1, '', 'custom', ''),
(null, 1, 0, 'COM_VIRTUEMART_PRODUCT_INVENTORY', '', '', 'vmicon vmicon-16-price_watch', 7, 1, '', 'inventory', ''),
(null, 1, 0, 'COM_VIRTUEMART_CALC_S', '', '', 'vmicon vmicon-16-calculator', 8, 1, '', 'calc', ''),
(null, 1, 0, 'COM_VIRTUEMART_REVIEW_RATE_S', '', '', 'vmicon vmicon-16-comments', 9, 1, '', 'ratings', ''),
(null, 2, 0, 'COM_VIRTUEMART_ORDER_S', '', '', 'vmicon vmicon-16-page_white_stack', 1, 1, '', 'orders', ''),
(null, 2, 0, 'COM_VIRTUEMART_COUPON_S', '', '', 'vmicon vmicon-16-shopping', 10, 1, '', 'coupon', ''),
(null, 2, 0, 'COM_VIRTUEMART_REPORT', '', '', 'vmicon vmicon-16-chart_bar', 3, 1, '', 'report',''),
(null, 2, 0, 'COM_VIRTUEMART_USER_S', '', '', 'vmicon vmicon-16-user', 4, 1, '', 'user', ''),
(null, 2, 0, 'COM_VIRTUEMART_SHOPPERGROUP_S', '', '', 'vmicon vmicon-16-user-group', 5, 1, '', 'shoppergroup', ''),
(null, 3, 0, 'COM_VIRTUEMART_MANUFACTURER_S', '', '', 'vmicon vmicon-16-wrench_orange', 1, 1, '', 'manufacturer', ''),
(null, 3, 0, 'COM_VIRTUEMART_MANUFACTURER_CATEGORY_S', '', '', 'vmicon vmicon-16-folder_wrench', 2, 1, '', 'manufacturercategories', ''),
(null, 4, 0, 'COM_VIRTUEMART_STORE', '', '', 'vmicon vmicon-16-reseller_account_template', 1, 1, '', 'user', 'editshop'),
(null, 4, 0, 'COM_VIRTUEMART_MEDIA_S', '', '', 'vmicon vmicon-16-pictures', 2, 1, '', 'media', ''),
(null, 4, 0, 'COM_VIRTUEMART_SHIPMENTMETHOD_S', '', '', 'vmicon vmicon-16-lorry', 3, 1, '', 'shipmentmethod', ''),
(null, 4, 0, 'COM_VIRTUEMART_PAYMENTMETHOD_S', '', '', 'vmicon vmicon-16-creditcards', 4, 1, '', 'paymentmethod', ''),
(null, 5, 0, 'COM_VIRTUEMART_CONFIGURATION', '', '', 'vmicon vmicon-16-config', 1, 1, '', 'config', ''),
(null, 5, 0, 'COM_VIRTUEMART_USERFIELD_S', '', '', 'vmicon vmicon-16-participation_rate', 2, 1, '', 'userfields', ''),
(null, 5, 0, 'COM_VIRTUEMART_ORDERSTATUS_S', '', '', 'vmicon vmicon-16-document_editing', 3, 1, '', 'orderstatus', ''),
(null, 5, 0, 'COM_VIRTUEMART_CURRENCY_S', '', '', 'vmicon vmicon-16-coins', 5, 1, '', 'currency', ''),
(null, 5, 0, 'COM_VIRTUEMART_COUNTRY_S', '', '', 'vmicon vmicon-16-globe', 6, 1, '', 'country', ''),
(null, 11, 0, 'COM_VIRTUEMART_MIGRATION_UPDATE', '', '', 'vmicon vmicon-16-installer_box', 1, 1, '', 'updatesmigration', ''),
(null, 11, 0, 'COM_VIRTUEMART_ABOUT', '', '', 'vmicon vmicon-16-info', 2, 1, '', 'about', ''),
(null, 11, 0, 'COM_VIRTUEMART_HELP_TOPICS', 'http://docs.virtuemart.net/', '', 'vmicon vmicon-16-help', 4, 1, '', '', ''),
(null, 11, 0, 'COM_VIRTUEMART_COMMUNITY_FORUM', 'http://forum.virtuemart.net/', '', 'vmicon vmicon-16-reseller_programm', 6, 1, '', '', ''),
(null, 11, 0, 'COM_VIRTUEMART_STATISTIC_SUMMARY', '', '', 'vmicon vmicon-16-info', 1, 1, '', 'virtuemart', ''),
(null, 77, 0, 'COM_VIRTUEMART_USER_GROUP_S', '', '', 'vmicon vmicon-16-user', 2, 1, '', 'usergroups', '');
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

jpadkins

  • Beginner
  • *
  • Posts: 2
Re: VM2 administration left menu missing
« Reply #9 on: April 08, 2014, 01:42:31 am »
Hi Milbo,
I am having the same issue as the rest and your solution seems to have fixed it for everyone but it makes absolutely no sense to me. Can you break that down for a newbie please?

sorga

  • Beginner
  • *
  • Posts: 4
Re: VM2 administration left menu missing
« Reply #10 on: April 27, 2014, 12:14:49 pm »
This is not checked by the updater.
Just use phpmyadmin, adjust the prefix and fire it
Code: [Select]
INSERT INTO `#__virtuemart_adminmenuentries` (`id`, `module_id`, `parent_id`, `name`, `link`, `depends`, `icon_class`, `ordering`, `published`, `tooltip`, `view`, `task`) VALUES
(null , 1, 0, 'COM_VIRTUEMART_CATEGORY_S', '', '', 'vmicon vmicon-16-folder_camera', 1, 1, '', 'category', ''),
(null, 1, 0, 'COM_VIRTUEMART_PRODUCT_S', '', '', 'vmicon vmicon-16-camera', 2, 1, '', 'product', ''),
(null, 1, 0, 'COM_VIRTUEMART_PRODUCT_CUSTOM_FIELD_S', '', '', 'vmicon vmicon-16-document_move', 5, 1, '', 'custom', ''),
(null, 1, 0, 'COM_VIRTUEMART_PRODUCT_INVENTORY', '', '', 'vmicon vmicon-16-price_watch', 7, 1, '', 'inventory', ''),
(null, 1, 0, 'COM_VIRTUEMART_CALC_S', '', '', 'vmicon vmicon-16-calculator', 8, 1, '', 'calc', ''),
(null, 1, 0, 'COM_VIRTUEMART_REVIEW_RATE_S', '', '', 'vmicon vmicon-16-comments', 9, 1, '', 'ratings', ''),
(null, 2, 0, 'COM_VIRTUEMART_ORDER_S', '', '', 'vmicon vmicon-16-page_white_stack', 1, 1, '', 'orders', ''),
(null, 2, 0, 'COM_VIRTUEMART_COUPON_S', '', '', 'vmicon vmicon-16-shopping', 10, 1, '', 'coupon', ''),
(null, 2, 0, 'COM_VIRTUEMART_REPORT', '', '', 'vmicon vmicon-16-chart_bar', 3, 1, '', 'report',''),
(null, 2, 0, 'COM_VIRTUEMART_USER_S', '', '', 'vmicon vmicon-16-user', 4, 1, '', 'user', ''),
(null, 2, 0, 'COM_VIRTUEMART_SHOPPERGROUP_S', '', '', 'vmicon vmicon-16-user-group', 5, 1, '', 'shoppergroup', ''),
(null, 3, 0, 'COM_VIRTUEMART_MANUFACTURER_S', '', '', 'vmicon vmicon-16-wrench_orange', 1, 1, '', 'manufacturer', ''),
(null, 3, 0, 'COM_VIRTUEMART_MANUFACTURER_CATEGORY_S', '', '', 'vmicon vmicon-16-folder_wrench', 2, 1, '', 'manufacturercategories', ''),
(null, 4, 0, 'COM_VIRTUEMART_STORE', '', '', 'vmicon vmicon-16-reseller_account_template', 1, 1, '', 'user', 'editshop'),
(null, 4, 0, 'COM_VIRTUEMART_MEDIA_S', '', '', 'vmicon vmicon-16-pictures', 2, 1, '', 'media', ''),
(null, 4, 0, 'COM_VIRTUEMART_SHIPMENTMETHOD_S', '', '', 'vmicon vmicon-16-lorry', 3, 1, '', 'shipmentmethod', ''),
(null, 4, 0, 'COM_VIRTUEMART_PAYMENTMETHOD_S', '', '', 'vmicon vmicon-16-creditcards', 4, 1, '', 'paymentmethod', ''),
(null, 5, 0, 'COM_VIRTUEMART_CONFIGURATION', '', '', 'vmicon vmicon-16-config', 1, 1, '', 'config', ''),
(null, 5, 0, 'COM_VIRTUEMART_USERFIELD_S', '', '', 'vmicon vmicon-16-participation_rate', 2, 1, '', 'userfields', ''),
(null, 5, 0, 'COM_VIRTUEMART_ORDERSTATUS_S', '', '', 'vmicon vmicon-16-document_editing', 3, 1, '', 'orderstatus', ''),
(null, 5, 0, 'COM_VIRTUEMART_CURRENCY_S', '', '', 'vmicon vmicon-16-coins', 5, 1, '', 'currency', ''),
(null, 5, 0, 'COM_VIRTUEMART_COUNTRY_S', '', '', 'vmicon vmicon-16-globe', 6, 1, '', 'country', ''),
(null, 11, 0, 'COM_VIRTUEMART_MIGRATION_UPDATE', '', '', 'vmicon vmicon-16-installer_box', 1, 1, '', 'updatesmigration', ''),
(null, 11, 0, 'COM_VIRTUEMART_ABOUT', '', '', 'vmicon vmicon-16-info', 2, 1, '', 'about', ''),
(null, 11, 0, 'COM_VIRTUEMART_HELP_TOPICS', 'http://docs.virtuemart.net/', '', 'vmicon vmicon-16-help', 4, 1, '', '', ''),
(null, 11, 0, 'COM_VIRTUEMART_COMMUNITY_FORUM', 'http://forum.virtuemart.net/', '', 'vmicon vmicon-16-reseller_programm', 6, 1, '', '', ''),
(null, 11, 0, 'COM_VIRTUEMART_STATISTIC_SUMMARY', '', '', 'vmicon vmicon-16-info', 1, 1, '', 'virtuemart', ''),
(null, 77, 0, 'COM_VIRTUEMART_USER_GROUP_S', '', '', 'vmicon vmicon-16-user', 2, 1, '', 'usergroups', '');

Thank you alot for your answer.  This is answer for my question.
Maybe you help me to solve another issue. I can't change the order status. I have only "pending" option available. How can solve this issue? I have VM2.6.0 and Joomla 2.5.18. Thank alot.


Sorry. I solve myself. Thanks

Cornel

  • Beginner
  • *
  • Posts: 21
Re: VM2 administration left menu missing
« Reply #11 on: May 29, 2014, 22:26:54 pm »
I tried to import using phpmyadmin, but that did not fix the probklem. My menu entries still does not appear, even after I updated to VM 2.6.6 (base and aio).
My  virtuemart_adminmenuentries table is filled but not entry is displayed !

What to check for next ?

sicogary

  • Beginner
  • *
  • Posts: 3
Re: VM2 administration left menu missing
« Reply #12 on: January 21, 2015, 12:40:28 pm »
Hello there,

I have run into the same problem. I have tried to use the solution copying the new tables with phpmyadmin. I have copied them but the menu is stil not working.

Can anyone help?

Thanks

KaosVJ

  • Beginner
  • *
  • Posts: 1
Re: VM2 administration left menu missing
« Reply #13 on: January 21, 2015, 18:30:00 pm »
OK, after a whole afternoon I discovered what was causing this problem.

Did none of the solutions above work?
Did this start happening to you after a backup restore or database migration?

The problem is within the #__virtuemart_modules table. Check the "is_admin" column, is everything set to 0? There, you found it.

At least these rows should have the "is_admin" column set to 1:

1, 'product'
2, 'order'
3, 'manufacturer'
4, 'store'
5, 'configuration'
8, 'store'
11, 'tools'
13, 'zone'

How does it happen? For some reason the table structure makes it that the value of that field (an "enum" one) isn't correctly set if it's exported and then imported, even though the values are correct in the sql dump file.

Hope this helps you.