区块链api问题[重复]

Question

This question already has an answer here:

• MySQL error - #1062 - Duplicate entry ' ' for key 2 8 answers

I am using PHP 7.2 and laravel this my blockchain api code

$blockchain_receive_root = "https://api.blockchain.info/";
    $secret = "ABIR";
    $my_api_key = $gateway->account;
    $my_xpub = $gateway->val1;

    $invoice_id = $transaction->hash;
    $callback_url = route('ipn.blockchain', ['invoice_id' => $invoice_id, 'secret' => $secret]);

    $resp = $blockchain_receive_root . "v2/receive?key=" . $my_api_key . "&callback=" . urlencode($callback_url) . "&xpub=" . $my_xpub;

    //BITCOIN API HAVING ISSUE. PLEASE TRY LATER
    if (!$resp) {
        return redirect()->route('account')->with('error', trans('site.blockchain.error'));
        exit;
    }
                $ch = curl_init();
                curl_setopt($ch, CURLOPT_URL, $resp);
                curl_setopt($ch,CURLOPT_USERAGENT,"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.13) Gecko/20080311 Firefox/2.0.0.13");
                curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
                $laste = curl_exec($ch);
                curl_close($ch);

    $response = json_decode($laste);

    $var = "bitcoin:$response->address?amount=$transaction->btc_amo";
    $code =  "<img src=\"https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl=$var&choe=UTF-8\" title='' style='width:300px;' />";

and this is my callback url file

        if($request->input('invoice_id') && $request->input('secret')) {

        $track = $request->input('invoice_id');
        $secret = $request->input('secret');
        $value = $request->input('value');
        $confirmations = $request->input('confirmations');
        $value_in_btc = $value / 100000000;
        $trx_hash = $request->input('transaction_hash');

        $order = Transaction::where('hash',$track)->first();

        if($order->status == 0){

            if ($order->btc_amo==$value_in_btc && $secret=="ABIR" && $confirmations >= 1){
                $savedata['confirmation'] = $trx_hash;
                $savedata['gateway_response'] = json_encode($request->all());
                $savedata['status'] = 'paid';

                //Update product sales
                $this->salesupdate($order->product_id);
                //Save order
                $this->neworder($order->user_id,$order->product_id,$order->price,$order->hash,$order->id);
                //Save user transaction
                $this->newusertransaction($order->user_id,$order->price);
                //Credit seller
                $this->creditseller($order->product_id);


                $order->update($savedata);
                 $request->session()->flash('success',trans('Your payments has been done!'));
                  return redirect()->route('account.mypurchases',$track);
            }
        }
    }

now the issue is the callback URL doesn't do the function inside him like credit the seller and update product sales

and when i checked my logs i found this

[2018-09-15 04:27:07] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '119' for key 'transaction_id' (SQL: insert into buys (user_id, product_id, price, hash, transaction_id, updated_at, created_at) values (2, 104, 0.20, 92b6564b75f60396590d744e5efacbbe, 119, 2018-09-15 04:27:07, 2018-09-15 04:27:07)) {"exception":"[object] (Illuminate\Database\QueryException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '119' for key 'transaction_id' (SQL: insert into buys (user_id, product_id, price, hash, transaction_id, updated_at, created_at) values (2, 104, 0.20, 92b6564b75f60396590d744e5efacbbe, 119, 2018-09-15 04:27:07, 2018-09-15 04:27:07)) at /srv/data/web/vhosts/heliux.pw/htdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '119' for key 'transaction_id' at /srv/data/web/vhosts/heliux.pw/htdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php:458) [stacktrace]

please some one tell me where is the error and how to fix it

</div>

Answer 1

It looks like the buys table has a UNIQUE index on transaction_id and that the table already has this transaction_id in the table.