1264 - Out of range value adjusted for....help me!
Inviato: 08/03/2006, 20:50
premetto che sono passato a mysql 5
e che molti aggiustamenti li ho gia fatti
ma questo pare non trovare soluzione almeno per le mie capacita'
quando il cliente conferma l'ordine al momento della notifica via e mail
riceve questo errore (solo nuovi clienti)
1264 - Out of range value adjusted for column 'products_id' at row 1
insert into products_notifications (products_id, customers_id, date_added) values ('', '37', now())
su os commerce.com ho trovato questa discussione:
At checkout_success Page.
If UnChecked any products notify.
Then click Continue Button.
1264 - Out of range value adjusted for column 'products_id' at row 1
insert into products_notifications (products_id, customers_id, date_added) values ('', '2', now())
If some one know this bug?
Please help.
Comments:
9 Jan 2006 19:18:33 bamsejon (AT) bredband (DOT) net
Got the same problem, seems like MYSQL don't like when you insert a '' value to a column that has 0 for a default value and where it is a primary column..
Don't know why osCommerce want to insert any row anyway, there is no point of inserting a new row if there is nothing to insert...
/Jon
9 Jan 2006 19:21:34 bamsejon (AT) bredband (DOT) net
It might bee a problem with MySQL..
When setting the default value to -1 it works..
I'm Using MySQL Version 5.0.11
/jon
13 Jan 2006 11:54:09 a (DOT) tomas (AT) iccsl (DOT) com
Hay que modificar en appplication.top la siguiente linea
if ($check['count'] < 1) {
tep_db_query("insert into " . TABLE_PRODUCTS_NOTIFICATIONS . " (products_id, customers_id, date_added) values ('" . $notify[$i] . "', '" . $customer_id . "', now())");
y substituir el < 1 por > 0, o sea
if ($check['count'] > 0) {
tep_db_query("insert into " . TABLE_PRODUCTS_NOTIFICATIONS . " (products_id, customers_id, date_added) values ('" . $notify[$i] . "', '" . $customer_id . "', now())");
come si adatta al mio caso ????non capisco quali file devo editare.
grazie in anticipo
e che molti aggiustamenti li ho gia fatti
ma questo pare non trovare soluzione almeno per le mie capacita'
quando il cliente conferma l'ordine al momento della notifica via e mail
riceve questo errore (solo nuovi clienti)
1264 - Out of range value adjusted for column 'products_id' at row 1
insert into products_notifications (products_id, customers_id, date_added) values ('', '37', now())
su os commerce.com ho trovato questa discussione:
At checkout_success Page.
If UnChecked any products notify.
Then click Continue Button.
1264 - Out of range value adjusted for column 'products_id' at row 1
insert into products_notifications (products_id, customers_id, date_added) values ('', '2', now())
If some one know this bug?
Please help.
Comments:
9 Jan 2006 19:18:33 bamsejon (AT) bredband (DOT) net
Got the same problem, seems like MYSQL don't like when you insert a '' value to a column that has 0 for a default value and where it is a primary column..
Don't know why osCommerce want to insert any row anyway, there is no point of inserting a new row if there is nothing to insert...
/Jon
9 Jan 2006 19:21:34 bamsejon (AT) bredband (DOT) net
It might bee a problem with MySQL..
When setting the default value to -1 it works..
I'm Using MySQL Version 5.0.11
/jon
13 Jan 2006 11:54:09 a (DOT) tomas (AT) iccsl (DOT) com
Hay que modificar en appplication.top la siguiente linea
if ($check['count'] < 1) {
tep_db_query("insert into " . TABLE_PRODUCTS_NOTIFICATIONS . " (products_id, customers_id, date_added) values ('" . $notify[$i] . "', '" . $customer_id . "', now())");
y substituir el < 1 por > 0, o sea
if ($check['count'] > 0) {
tep_db_query("insert into " . TABLE_PRODUCTS_NOTIFICATIONS . " (products_id, customers_id, date_added) values ('" . $notify[$i] . "', '" . $customer_id . "', now())");
come si adatta al mio caso ????non capisco quali file devo editare.
grazie in anticipo
