Hello,
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 a.id 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.id, a.title, a.level, a.lft, a.rgt, a.menutype, a.parent_id, a.published ORDER BY a.lft ASC
Can somebody help me ?
http://lmgtfy.com/?q=MAX_JOIN_SIZE
ask your host