Author Topic: I can not add new menu items  (Read 1231 times)


  • Beginner
  • *
  • Posts: 5
I can not add new menu items
« on: September 17, 2014, 17:13:53 pm »

I migrated my site yesterday to a faster server but now I have a new problem. I can not add new menu items. I have 4300 products on my store and every product is added to a menu item. Now if I try to configure a new product details layout menu item I receive the following message: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT AS value, a.title AS text, a.level FROM fk3vu_menu AS a LEFT JOIN `fk3vu_menu` AS b ON a.lft > b.lft AND a.rgt < b.rgt WHERE a.menutype = 'produse' AND a.published != -2 GROUP BY, a.title, a.level, a.lft, a.rgt, a.menutype, a.parent_id, a.published ORDER BY a.lft ASC

Can somebody help me ?

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10441
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: I can not add new menu items
« Reply #1 on: September 17, 2014, 23:28:49 pm »
GJC Web Design
VirtueMart and Joomla Developers - php developers
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
Contact for any VirtueMart or Joomla development & customisation