errore con easypopulate

[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

[marcus]

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

[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

[marcus]

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:

Codice: Seleziona tutto

$query = "INSERT INTO ".TABLE_PRODUCTS." (

e correggi la sintassi.

Saluti
Marcus

[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);

[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

[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

[marcus]

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