Pagina 1 di 1
errore con easypopulate
Inviato: 17/12/2006, 4:09
da ragno77
Qualcuno riesci ad aiutarmi , mi viene fuori questo errore e non so cosa Fare
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '", "bond_goldeye_set.jpg", "bond_goldeye_set.jpg", "bond_goldeye_set.jpg", "", "' at line 28
INSERT INTO products ( 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_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( 'bond_goldeye_set.jpg',bond_goldeye_set.jpg", "bond_goldeye_set.jpg", "bond_goldeye_set.jpg", "bond_goldeye_set.jpg", "", "", "", "", "", "", "", "", "", "", " '18', '17', '1', CURRENT_TIMESTAMP, "16/12/2006 18.05", NULL, '', '0.00', '3', '16')
Grazie Simone
Re: errore con easypopulate
Inviato: 17/12/2006, 6:44
da marcus
ragno77 ha scritto:Qualcuno riesci ad aiutarmi , mi viene fuori questo errore e non so cosa Fare
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '", "bond_goldeye_set.jpg", "bond_goldeye_set.jpg", "bond_goldeye_set.jpg", "", "' at line 28
INSERT INTO products ( 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_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( 'bond_goldeye_set.jpg',bond_goldeye_set.jpg", "bond_goldeye_set.jpg", "bond_goldeye_set.jpg", "bond_goldeye_set.jpg", "", "", "", "", "", "", "", "", "", "", " '18', '17', '1', CURRENT_TIMESTAMP, "16/12/2006 18.05", NULL, '', '0.00', '3', '16')
Grazie Simone
Ad un occhiata veloce hai un problema con gli apicetti qui:
VALUES ( 'bond_goldeye_set.jpg',bond_goldeye_set.jpg",
dovrebbe essere:
VALUES ( 'bond_goldeye_set.jpg',"bond_goldeye_set.jpg",
Saluti
Marcus
Inviato: 17/12/2006, 19:59
da ragno77
Ho scaricato l'archivio dei miei articoli con easypopulate , e poi quando ricarico gli stessi oggetti ( senza modifiche ) mi da questo errore ,
dove posso sistemare questo errore e da cosa puo dipendere???
Grazie
Inviato: 17/12/2006, 22:05
da marcus
ragno77 ha scritto:
dove posso sistemare questo errore e da cosa puo dipendere???
Grazie
Te l'ho scritto sopra
Devi correggere una query.
Per trovare la query da correggere cerca nel file easypopulate.php la stringa:
e correggi la sintassi.
Saluti
Marcus
Inviato: 18/12/2006, 20:37
da ragno77
Dov'e l'errore ?????
$query = "INSERT INTO ".TABLE_PRODUCTS." (
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_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'$v_products_image',"
. $v_products_image_med . '", "'
. $v_products_image_lrg . '", "'
. $v_products_image_sm_1 . '", "'
. $v_products_image_xl_1 . '", "'
. $v_products_image_sm_2 . '", "'
. $v_products_image_xl_2 . '", "'
. $v_products_image_sm_3 . '", "'
. $v_products_image_xl_3 . '", "'
. $v_products_image_sm_4 . '", "'
. $v_products_image_xl_4 . '", "'
. $v_products_image_sm_5 . '", "'
. $v_products_image_xl_5 . '", "'
. $v_products_image_sm_6 . '", "'
. $v_products_image_xl_6 . '", "';
// unmcomment these lines if you are running the image mods
/*
$query .= . $v_products_mimage . '", "'
. $v_products_bimage . '", "'
. $v_products_subimage1 . '", "'
. $v_products_bsubimage1 . '", "'
. $v_products_subimage2 . '", "'
. $v_products_bsubimage2 . '", "'
. $v_products_subimage3 . '", "'
. $v_products_bsubimage3 . '", "'
*/
$query .=" '$v_products_model',
'$v_products_price',
'$v_db_status',
CURRENT_TIMESTAMP,
$v_date_added,
$v_date_avail,
'$v_tax_class_id',
'$v_products_weight',
'$v_products_quantity',
'$v_manufacturer_id')
";
$result = tep_db_query($query);
Inviato: 19/12/2006, 12:13
da maury2ma
non esiste una risposta per la tua domanda,
infatti easy populate va configurato per la versione che usi, in base ai moduli che hai installato.
non esiste una query di massima.
trova qualcuno che mastichi mysql e vedrai che la correzzione te la fa in un batter d'occhio
Inviato: 19/12/2006, 14:13
da ragno77
La versione che uso di easypopulate è la 2.76 addattata per Ultra Pics , quindi non dovrebbe darmi questi problemi ........
Provero a chiedere a qualche amico .
Grazie
Inviato: 19/12/2006, 21:06
da marcus
ragno77 ha scritto:Dov'e l'errore ?????
$query = "INSERT INTO ".TABLE_PRODUCTS." (
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_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'$v_products_image',"
. $v_products_image_med . '", "'
. $v_products_image_lrg . '", "'
. $v_products_image_sm_1 . '", "'
. $v_products_image_xl_1 . '", "'
. $v_products_image_sm_2 . '", "'
. $v_products_image_xl_2 . '", "'
. $v_products_image_sm_3 . '", "'
. $v_products_image_xl_3 . '", "'
. $v_products_image_sm_4 . '", "'
. $v_products_image_xl_4 . '", "'
. $v_products_image_sm_5 . '", "'
. $v_products_image_xl_5 . '", "'
. $v_products_image_sm_6 . '", "'
. $v_products_image_xl_6 . '", "';
// unmcomment these lines if you are running the image mods
/*
$query .= . $v_products_mimage . '", "'
. $v_products_bimage . '", "'
. $v_products_subimage1 . '", "'
. $v_products_bsubimage1 . '", "'
. $v_products_subimage2 . '", "'
. $v_products_bsubimage2 . '", "'
. $v_products_subimage3 . '", "'
. $v_products_bsubimage3 . '", "'
*/
$query .=" '$v_products_model',
'$v_products_price',
'$v_db_status',
CURRENT_TIMESTAMP,
$v_date_added,
$v_date_avail,
'$v_tax_class_id',
'$v_products_weight',
'$v_products_quantity',
'$v_manufacturer_id')
";
$result = tep_db_query($query);
Prova a sostituire la query sopra con questa:
Codice: Seleziona tutto
$query = 'INSERT INTO ' . TABLE_PRODUCTS . ' (
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_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id) VALUES ("'
. $v_products_image . '", "'
. $v_products_image_med . '", "'
. $v_products_image_lrg . '", "'
. $v_products_image_sm_1 . '", "'
. $v_products_image_xl_1 . '", "'
. $v_products_image_sm_2 . '", "'
. $v_products_image_xl_2 . '", "'
. $v_products_image_sm_3 . '", "'
. $v_products_image_xl_3 . '", "'
. $v_products_image_sm_4 . '", "'
. $v_products_image_xl_4 . '", "'
. $v_products_image_sm_5 . '", "'
. $v_products_image_xl_5 . '", "'
. $v_products_image_sm_6 . '", "'
. $v_products_image_xl_6 . '", "';
// unmcomment these lines if you are running the image mods
/*
$query .= . $v_products_mimage . '", "'
. $v_products_bimage . '", "'
. $v_products_subimage1 . '", "'
. $v_products_bsubimage1 . '", "'
. $v_products_subimage2 . '", "'
. $v_products_bsubimage2 . '", "'
. $v_products_subimage3 . '", "'
. $v_products_bsubimage3 . '", "'
*/
$query .= $v_products_model . '", "'
. $v_products_price . '", "'
. $v_db_status . '", '
. CURRENT_TIMESTAMP . ', "'
. $v_date_added . '", "'
. $v_date_avail . '", "'
. (int)$v_tax_class_id . '", "'
. $v_products_weight . '", "'
. $v_products_quantity . '", "'
. (int)$v_manufacturer_id .'")';
$result = tep_db_query($query);
Saluti
Marcus