Pagina 1 di 1

Duplicazione articolo

Inviato: 18/11/2006, 18:08
da pippo010
Ciao a tutti,
quando cerco di duplicare un articolo mi esce questo errore:

1136 - Column count doesn't match value count at row 1

insert into products (products_quantity, products_model,products_image, products_image_med, products_image_lrg, products_image_sm_1, products_image_xl_1, products_image_sm_2, products_image_xl_2, products_image_sm_3, products_image_xl_3, products_image_sm_4, products_image_xl_4, products_image_sm_5, products_image_xl_5, products_image_sm_6, products_image_xl_6, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('15', 'GSC1', 'toyz/1_tn.gif', ', '', '', '', '', '', '', '', '', '', '', '', '', '', ''25.0000' , now(), '', '0.30', '0', '3', '1')

[TEP STOP]


Qualcuno ha un'idea?
Grazie

Re: Duplicazione articolo

Inviato: 18/11/2006, 21:01
da marcus
pippo010 ha scritto:Ciao a tutti,
quando cerco di duplicare un articolo mi esce questo errore:

1136 - Column count doesn't match value count at row 1

insert into products (products_quantity, products_model,products_image, products_image_med, products_image_lrg, products_image_sm_1, products_image_xl_1, products_image_sm_2, products_image_xl_2, products_image_sm_3, products_image_xl_3, products_image_sm_4, products_image_xl_4, products_image_sm_5, products_image_xl_5, products_image_sm_6, products_image_xl_6, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('15', 'GSC1', 'toyz/1_tn.gif', ', '', '', '', '', '', '', '', '', '', '', '', '', '', ''25.0000' , now(), '', '0.30', '0', '3', '1')

[TEP STOP]

Qualcuno ha un'idea?
Grazie
Mi pare ci sia un errore con gli apici nelle parti della query evidenziate in rosso:

insert into products (products_quantity, products_model,products_image, products_image_med, products_image_lrg, products_image_sm_1, products_image_xl_1, products_image_sm_2, products_image_xl_2, products_image_sm_3, products_image_xl_3, products_image_sm_4, products_image_xl_4, products_image_sm_5, products_image_xl_5, products_image_sm_6, products_image_xl_6, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('15', 'GSC1', 'toyz/1_tn.gif', ', '', '', '', '', '', '', '', '', '', '', '', '', '', ''25.0000' , now(), '', '0.30', '0', '3', '1')

Da correggere così:

''25.0000' -> '25.0000'

' ->''


Saluti
Marcus

Inviato: 20/11/2006, 12:04
da pippo010
Esatto Marcus.
Ho effettuato ma dofica dei due caratteri nel file categories.php sotto admin. Problema risolto.

Grazie