una marea di errori

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

Moderatore: mod Generali

Rispondi
ema
membro Junior
membro Junior
Messaggi: 46
Iscritto il: 25/11/2004, 1:00
Località: italia
Contatta:

una marea di errori

Messaggio da ema »

ciao,ieri leggevo un post dove si diceva che bastava cambiare un"]"in admin/newletters.php per non aver problemi,io lo fatto,in locale funziona a meraviglia ma sul server remoto mi da' tutti questi errori.
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 '-8, 8' at line 1

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

offerte
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 '-8, 8' at line 1

select p.products_id, pd.products_name, p.products_price, s.specials_id, s.customers_groups_id, s.customers_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = s.products_id order by pd.products_name, s.customers_groups_id, s.customers_id limit -8, 8

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 '-8, 8' 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 -8, 8

newletter 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 '-8, 8' 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 -8, 8

come faccio a sistemare il tutto?
grazie in anticipo,ema
Rispondi