Duplicazione articolo

Postate qui discussioni di carattere generale riguardo a problemi di installazione e configurazione di osCommerce

Moderatore: mod Generali

Rispondi
pippo010
membro Regular
membro Regular
Messaggi: 134
Iscritto il: 26/01/2004, 1:00
Località: Italia
Contatta:

Duplicazione articolo

Messaggio 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
Avatar utente
marcus
membro Master
membro Master
Messaggi: 1619
Iscritto il: 04/12/2003, 1:00
Contatta:

Re: Duplicazione articolo

Messaggio 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
Nuovo pacchetto osCommercePRO (osCPRO) + Modulo Interfacciamento Gestionale Danea.
Visita la demo: http://oscpro.oscommercedev.com/index.php
pippo010
membro Regular
membro Regular
Messaggi: 134
Iscritto il: 26/01/2004, 1:00
Località: Italia
Contatta:

Messaggio da pippo010 »

Esatto Marcus.
Ho effettuato ma dofica dei due caratteri nel file categories.php sotto admin. Problema risolto.

Grazie
Rispondi