Joomla 1.5 Поиск в Virtuemart выдало No valid database connection The..

Discussion in 'Магазины, электронная коммерция' started by rockethe, Feb 26, 2010.

  1. Offline

    rockethe Недавно здесь

    Joined:
    Nov 13, 2009
    Messages:
    31
    Likes Received:
    0
    Gender:
    Male
    Поиск товаров Virtuemart на главной странице. На Денвере все прекрасно, на сервере при запросе выдало:


    No valid database connection The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) as num_rows FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`) LEFT JOIN `jos_vm_product_price` ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id` WHERE (`jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id` OR `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_parent_id`) AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id` AND ( (`jos_vm_product`.`product_name` LIKE '%масло%' OR `jos_vm_product`.`product_sku` LIKE '%масло%' OR `jos_vm_product`.`product_s_desc` LIKE '%масло%' OR `jos_vm_product`.`product_desc` LIKE '%масло%') ) AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id` AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL) AND `jos_vm_shopper_group`.`default` = 1 AND `product_publish`='Y' AND `category_publish`='Y'
    Your search returned 0 results.


    Как исправить?
     
  2.  
  3. Offline

    Sirpredator Недавно здесь

    Joined:
    Jan 29, 2010
    Messages:
    8
    Likes Received:
    0
    Gender:
    Male
    Вы смогли решить проблему?
     

Share This Page

Loading...