Включил отладку и при загрузки страницы товара выдает
1 JApplicationCms->execute() /index.php:45
2 JApplicationSite->doExecute() /libraries/cms/application/cms.php:252
3 JApplicationSite->dispatch() /libraries/cms/application/site.php:230
4 JComponentHelper::renderComponent() /libraries/cms/application/site.php:191
5 JComponentHelper::executeComponent() /libraries/cms/component/helper.php:372
6 require_once() /libraries/cms/component/helper.php:392
7 JControllerLegacy->execute() /components/com_virtuemart/virtuemart.php:124
8 VirtueMartControllerProductdetails->display() /libraries/legacy/controller/legacy.php:728
9 VirtueMartViewProductdetails->display() /components/com_virtuemart/controllers/productdetails.php:55
10 VirtueMartModelProduct->getNeighborProducts() /components/com_virtuemart/views/productdetails/view.html.php:163
11 JDatabaseDriver->loadAssocList() /administrator/components/com_virtuemart/models/product.php:1621
12 JDatabaseDriverMysql->execute() /libraries/joomla/database/driver.php:1123
В файле /administrator/components/com_virtuemart/models/product.php есть такой кусок кода
public function loadProductPrices($productId,$virtuemart_shoppergroup_ids,$front){
$db = JFactory::getDbo();
if(!isset($this->_nullDate))$this->_nullDate = $db->getNullDate();
if(!isset($this->_now)){
$jnow = JFactory::getDate();
$this->_now = $jnow->toSQL();
}
$q = 'SELECT * FROM `#__virtuemart_product_prices` WHERE `virtuemart_product_id` = "'.$productId.'" ';
if($front){
if($virtuemart_shoppergroup_ids and count($virtuemart_shoppergroup_ids)>0){
$q .= ' AND (';
$sqrpss = '';
foreach($virtuemart_shoppergroup_ids as $sgrpId){
$sqrpss .= ' `virtuemart_shoppergroup_id` ="'.$sgrpId.'" OR ';
}
$q .= $sqrpss.' `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") ';
}
$q .= ' AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "' . $db->escape($this->_nullDate). '" OR `product_price_publish_up` <= "' .$db->escape($this->_now). '" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "' .$db->escape($this->_nullDate). '" OR product_price_publish_down >= "' . $db->escape($this->_now). '" ) )';
}
$q .= ' ORDER BY `product_price` DESC';
static $loadedProductPrices = array();
$hash = $productId.','.implode('.',$virtuemart_shoppergroup_ids).','.(int)$front; //md5($q);
if(!isset($loadedProductPrices[$hash])){
$db->setQuery($q);
$prices = $db->loadAssocList();
$err = $db->getErrorMsg();
if(!empty($err)){
vmError('getProductSingle '.$err);
} else {
if(empty($prices)){
$loadedProductPrices[$hash] = false;
} else {
$loadedProductPrices[$hash] = $prices ;
}
}
}
return $loadedProductPrices[$hash];
}
То есть этот кусок
$q .= ' AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "' . $db->escape($this->_nullDate). '" OR `product_price_publish_up` <= "' .$db->escape($this->_now). '" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "' .$db->escape($this->_nullDate). '" OR product_price_publish_down >= "' . $db->escape($this->_now). '" ) )';