Passaggio dati database

[pippo010]

Ciao a tutti, nei giorni scorsi mi sono trovato a dover effettuare un reindirizzamento di database ad uno nuovo. A causa della impossibilità di utlizzare il salvataggio di oscommerce, ho esportato il file sql mediante l'esporta di mysqladministrator per poi reimportarlo nel nuovo database.
Il problema che non riesco a risolvere è che ho questi errore che mi affliggono, al quale non trovo risposta.


Recensioni
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 '-20, 20' at line 1

select reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -20, 20

[TEP STOP]

--------------------------------------------------------------

Prodotti in arrivo
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 '-20, 20' at line 1

select pd.products_id, pd.products_name, p.products_date_available from products_description pd, products p where p.products_id = pd.products_id and p.products_date_available != '' and pd.language_id = '4' order by p.products_date_available DESC limit -20, 20

[TEP STOP]

----------------------------------------------------------------

Sconto Prodottori Per Gruppi Cerca:
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 '-20, 20' at line 1

select g.manudiscount_id, g.manudiscount_name, g.manudiscount_discount, gm.manufacturers_name as manudiscount_manufacturers_name, g.manudiscount_customers_id, g.manudiscount_groups_id from manudiscount g, manufacturers gm where g.manudiscount_manufacturers_id = gm.manufacturers_id order by g.manudiscount_id ASC limit -20, 20

[TEP STOP]

------------------------------------------------------------

Newsletter Manager
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 '-20, 20' at line 1

select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -20, 20

[TEP STOP]

------------------------------------------------------------



Inoltre mi ritrovo a fianco dei campi imponibile, pacco celere, iva e totale un punto di domanda al posto del simbolo €.

Qualcuno di voi riesce ad indicarmi una soluzione?

Grazie

[pippo010]

Come non detto, sono riuscito a risolvere.. ecco la soluzione:


limit -20, 20
http://www.oscommerce.com/community/bugs,1605


Problema:

Errore 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 '-20,
20' at line 1

Soluzione:

Riga 67 in catalog/includes/classes/split_page_results.php deve esere cambiata
da:

$this->sql_query .= " limit " . $offset . ", " . $this->number_of_rows_per_page;

a:

$this->sql_query .= " limit " . max($offset, 0) . ", " .
$this->number_of_rows_per_pag e;

Riga 38 in catalog/admin/includes/classes/split_page_results.php deve essere
cambiata da:

$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

a:

$sql_query .= " limit " . max($offset, 0) . ", " . $max_rows_per_page;

[vinx]

Grazie mille il tuo aiuto è stato prezioso...