Scriptcase Shop Error

[mfwebmaster]

Sto eseguendo il progetto di esempio Scriptcase shop e quando vado a completare l'acquisto sul carrello mi compare il seguente errore :

Error
Error while accessing the database
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 2, 1, '80.00', '80')' at line 1

____________________________________

qui di seguito riporto il codice presente nella Blank che provoca l'errore

sc_lookup(rs, "
SELECT
productid,
quantity
FROM
cart
WHERE
(session_id = '". session_id() ."')
");

if(!isset({rs[0][0]}))
{
echo {lang_empty_cart};
}else
{
sc_exec_sql("INSERT INTO orders (customerid, status, order_date, total) VALUES(". [v_cust] .", 1, '". date("Y-m-d H:i:s") ."', 0)");

sc_lookup(rs_order, "SELECT last_insert_rowid()");
$order = {rs_order[0][0]};

$total_order = 0;
$cont = 0;
$arr_products = array();
foreach({rs} as $prod)
{
sc_lookup(rs_prod, "SELECT price, name FROM products WHERE (productid = '". $prod[0] ."')");

$total = $prod[1] * {rs_prod[0][0]};
$total_order += $total;
sc_exec_sql("INSERT INTO orderitens (orderid, productid, quantity, unitprice, total)
VALUES(". $order .", ". $prod[0] .", ". $prod[1] .", '". {rs_prod[0][0]} ."', '". $total ."')");

sc_exec_sql("UPDATE products SET onhandquantity = (onhandquantity-". $prod[1] .") WHERE (productid = '". $prod[0] ."')");

$arr_products[$cont]['product'] = {rs_prod[0][1]};
$arr_products[$cont]['price'] = {rs_prod[0][0]};
$arr_products[$cont]['quantity']= $prod[1];

$cont++;
}

sc_exec_sql("UPDATE orders SET total='". $total_order ."' WHERE orderid = '". $order ."'");
sc_exec_sql("DELETE FROM cart WHERE (session_id = '". session_id() ."')");

sendEmailOrder($arr_products);

sc_redir(grid_orders_success.php, v_order=$order);
}

__________________________________________

Grazie in anticipo

[Fabio]

Ciao,
dovresti mettere in debug e vedere la query completa che stai inviando al db.
Sarà un semplice problema di "apici"

[mfwebmaster]

Ciao, grazie per la risposta…. verifico e ti faccio sapere.