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 Jul 2, 2015 at 11:10
  • please tell me code of line 1362 at SellerController.php
    – Amit Bera
    Jul 2, 2015 at 11:10
  • $rows = $connection->fetchAll($sql);
    – Magento
    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. 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 that you have read and understand our privacy policy and code of conduct.

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