1

enter image description here

Whem i am trying to fetch sql query in my magento's controller it's display this error

SQLSTATE[HY000]: General error

HERE is my code

    $connection = Mage::getSingleton('core/resource')->getConnection('core_write');
    $sql = "DELETE FROM marketplace_sellernotification WHERE seller_id =".$sellerId;
    $rows = $connection->fetchAll($sql);
    header('Location: ' . $_SERVER['HTTP_REFERER']);
4
  • try this code:-my.cnf settings that might help… max_allowed_packet = 16M wait_timeout = 1800 connect_timeout = 120 Commented Jul 2, 2015 at 11:10
  • please tell me code of line 1362 at SellerController.php
    – Amit Bera
    Commented Jul 2, 2015 at 11:10
  • $rows = $connection->fetchAll($sql);
    – Magento
    Commented Jul 2, 2015 at 11:12
  • I hope you are sanitizing $sellerId to always be an integer. Better: use prepared statements. Even better: use the appropiate Magento resource model. Commented Jul 2, 2015 at 11:25

1 Answer 1

2

Hi first you need change core_read to core_write
from

$connection = Mage::getSingleton('core/resource')->getConnection('core_read'); 

to

$connection = Mage::getSingleton('core/resource')->getConnection('core_write'); 

Now run query by checking carefully ,sure it will work

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.