Jump to content

Prestashop update transaction query problem


kirubanidhi
 Share

Recommended Posts

how to resolve this error,

 

 

 Fatal error: Uncaught 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 'Express, `card_number`=0002 WHERE `order_reference` = YPCEAQCDF' in /var/www/html/cy_prestashop/classes/db/Db.php on line 791 ( ! ) PrestaShopDatabaseException: 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 'Express, `card_number`=0002 WHERE `order_reference` = YPCEAQCDF' at line 1<br /><br /><pre>UPDATE `ps_order_payment` SET `transaction_id` =60029436712, `card_brand`=American Express, `card_number`=0002 WHERE `order_reference` = YPCEAQCDF</pre> in /var/www/html/cy_prestashop/classes/db/Db.php on line 791

 

 

Code:

 

public function orderPayment_fun($reference,$transaction_id,$card_number,$card_brand){
 
        $value=Db::getInstance()->execute('UPDATE `'._DB_PREFIX_.'order_payment` SET `transaction_id` ='.$transaction_id.', `card_brand`='.$card_brand.', `card_number`='.$card_number.' WHERE `order_reference` = '.$reference);
        
 
        if($value){
            echo "Updated successful";
        }else{
            echo "failed";
        }
        die();   
    }
 
Getting value when order is created but code is not updated to database.
 
Transaction Id 60029436712
Card Number 0002
Card Brand American Express
Order Reference YPCEAQCDF
Edited by kirubanidhi (see edit history)

Share this post


Link to post
Share on other sites

You should put your values between quotes. 

 

Usually Mysql can handle that - although it is not recommended - but in the case of "American Express" it goes wrong. Because there are no quotes it assumes that the value ends with the first space. And then it tries to evaluate "Express" as a new keyword.

Share this post


Link to post
Share on other sites

I did resolve my problem .

 

I followed below update query in my orderpayment page.

 

Code:

 

$update="UPDATE `ps_order_payment` SET `card_number`='$card_no',
                                        `card_brand`='$card_type',
                                        `card_expiration`='$card_expire',
                                        `card_holder`='$card_holder_name'
                                         WHERE `transaction_id`=".(int)$trans_id;
 
return Db::getInstance()->execute($update);
Edited by kirubanidhi (see edit history)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More