dongwen7380 2014-09-15 09:12
浏览 15

Magento - Helper在模块上抛出异常

We have had a working extension on our site that allows customers to request samples - the code on our category pages is :

<?php if (Mage::helper('floorsamples')->isSamplesEnabled($_product->getId())): ?>
        <a href="<?php echo $this->getUrl('samples/cart/add') . '?product=' . $_product->getId(); ?>" class="link-compare" onclick="sampleconfirm()"><img src="<?php echo $this->getSkinUrl('images/cat-freesample.png')?>" /></a>
                <?php else: ?>
                    <a href="<?php echo $_product->getProductUrl() ?>"><img src="<?php echo $this->getSkinUrl('images/cat-moreinfo.png')?>" /></a>
                <?php endif; ?>  

However, checking whether the samples option is available causes an exception to throw. The rest of the module appears to be fully functional - apart from this exception.

The functions are :

public function isSamplesEnabled($productId) {
    if (!$this->getConfigClass()->enabled) {
        return false;
    }
    $product = $this->_getProduct($productId);
    foreach ($product->getCategoryCollection() as $category) {
        if ($this->_isSamplesEnabledHelper($product, $category)) {
            return true;
        }
    }
    return false;
}

private function _isSamplesEnabledHelper($product, $category, $recursive = false) {
    $category = Mage::getModel("catalog/category")->load($category->getEntityId());
    if ($this->_getData($category)) {
        return true;
    }
    if ($recursive) {
        foreach ($category->getChildrenCategories() as $child) {
            if ($this->_isSamplesEnabledHelper($product, $child, $recursive)) {
                return true;
            }
        }
    }
    return false;
}

Thanks!

PS. Below is from the logs

a:5:{i:0;s:202:"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1";i:1;s:6240:"#0
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Centos7 / PETGEM
    • ¥15 csmar数据进行spss描述性统计分析
    • ¥15 各位请问平行检验趋势图这样要怎么调整?说标准差差异太大了
    • ¥15 delphi webbrowser组件网页下拉菜单自动选择问题
    • ¥15 wpf界面一直接收PLC给过来的信号,导致UI界面操作起来会卡顿
    • ¥15 init i2c:2 freq:100000[MAIXPY]: find ov2640[MAIXPY]: find ov sensor是main文件哪里有问题吗
    • ¥15 运动想象脑电信号数据集.vhdr
    • ¥15 三因素重复测量数据R语句编写,不存在交互作用
    • ¥15 微信会员卡等级和折扣规则
    • ¥15 微信公众平台自制会员卡可以通过收款码收款码收款进行自动积分吗