There is an error in hou sql SYNTAX - ECART

I am trying to store de sumary and the details of the order...but e get the same message...Can you help me?

If you update this line in your queryobj.php file:
$this->Debug = false;

to:
$this->Debug = true;

It should give you a better error message.

INSERT INTO orders (`n_pedido`, `total_pedido`, `clienteID`, `portes`, `statusID`, `observaciones`) VALUES ('PE-200922-5', 0, 5, 0, 1, DEFAULT)

Duplicate entry 'PE-200922-5' for key 'n_pedido'

n_pedido is set as a unique column in your database but you are attempting to insert a value that already exists in the table.

I don't even see an <input> field named "numero" which you are using to do the update. Your trigger for the database insert is "before page load" which runs before any form is posted, so something is wrong with that logic.

Please attach a current version of the page so I can see what might be wrong.

The error means you are trying to insert a repeated order. Your order id "n_pedido" has to be unique in the database.

Now it is working, the ploblem was the number id, it was the same. The summary store the data, but the deails doesnt safe into the data base

Please attach the current version of the page and I can see if I can spot the problem or help you debug it.

the Gran Total, i can save it in the store summary and i use: <?php echo $eCart1->GrandTotal(); ?>

This line should be on the top of the page... but after the ecart include.

<?php

$eCart1->GetContent();

?>

Try moving it to line 14

this is the error that i get, when it has to safe two different products....in the store details:

INSERT INTO orderdetails (`n_pedido`, `nombre_producto`, `precio_producto`, `unidades`, `peso`, `totalPrecio`, `sku`, `prodID`, `clienteID`) VALUES ('PE-200922214500-5', 'Filetes de sardina', 5, 11, 120, 75, '0002', 2, 5)

Duplicate entry 'PE-200922214500-5' for key 'n_pedido'