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
Duplicazione articolo
Moderatore: mod Generali
Re: Duplicazione articolo
Mi pare ci sia un errore con gli apici nelle parti della query evidenziate in rosso: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
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
Nuovo pacchetto osCommercePRO (osCPRO) + Modulo Interfacciamento Gestionale Danea.
Visita la demo: http://oscpro.oscommercedev.com/index.php
Visita la demo: http://oscpro.oscommercedev.com/index.php