Habe einige errors

[Gilles]

Hi ich hoffe Ihr k?nnt mir helfen, habe einige Probleme mit dem Onlineshop.

1. Ich will keine Thumbmails Bilder, die Bilder sollen scharf in der originalen gr??e dargestellt werden wie geht das ?

2. Kategorie Kunden link Betsellung

- Wenn ich da drauf klicke bekomme ich folgende fehlermeldung, nur warum und wie beseitige ich die ?

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 o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '2' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20

[XT SQL Error]

3. Produktkatalog link Hersteller

- Wenn ich da drauf klicke bekomme ich folgende fehlermeldung, nur warum und wie beseitige ich die ?

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 manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from manufacturers order by manufacturers_name limit -20, 20

[XT SQL Error]

4. Produktkatalog link Produktbewertung

- Wenn ich da drauf klicke bekomme ich folgende fehlermeldung, nur warum und wie beseitige ich die ?

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

[XT SQL Error]

5. Produktkatalog link Sonerangebote

- Wenn ich da drauf klicke bekomme ich folgende fehlermeldung, nur warum und wie beseitige ich die ?

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 p.products_id, pd.products_name, p.products_price, s.specials_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 = '2' and p.products_id = s.products_id order by pd.products_name limit -20, 20

[XT SQL Error]

6. Statistik link gekaufte Artikel

- Wenn ich da drauf klicke bekomme ich folgende fehlermeldung, nur warum und wie beseitige ich die ?

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 p.products_id, p.products_ordered, pd.products_name from products p, products_description pd where pd.products_id = p.products_id and pd.language_id = '2' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name limit -20, 20

[XT SQL Error]

7. Statistik link Kunden-Bestellstatistik

- Wenn ich da drauf klicke bekomme ich folgende fehlermeldung, nur warum und wie beseitige ich die ?

Nr. Kunden Umsatz Gesamt

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 c.customers_firstname, c.customers_lastname, sum(op.final_price) as ordersum from customers c, orders_products op, orders o where c.customers_id = o.customers_id and o.orders_id = op.orders_id group by c.customers_firstname, c.customers_lastname order by ordersum DESC limit -20, 20

[XT SQL Error]

8. Hilfsprogramme link CC Blacklist

- Wenn ich da drauf klicke bekomme ich folgende fehlermeldung, nur warum und wie beseitige ich die ?

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 blacklist_id, blacklist_card_number, date_added, last_modified from card_blacklist order by blacklist_id limit -20, 20

[XT SQL Error]

9. Hilfsprogramme link Banner Manager

- Wenn ich da drauf klicke bekomme ich folgende fehlermeldung, nur warum und wie beseitige ich die ?

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 banners_id, banners_title, banners_image, banners_group, status, expires_date, expires_impressions, date_status_change, date_scheduled, date_added from banners order by banners_title, banners_group limit -20, 20

[XT SQL Error]

10. Gutscheine/Koupons link Koupon Admin

- Wenn ich da drauf klicke bekomme ich folgende fehlermeldung, nur warum und wie beseitige ich die ?

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 coupon_id, coupon_code, coupon_amount, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_products, restrict_to_categories, date_created,date_modified from coupons where coupon_active='Y' and coupon_type != 'G' limit -20, 20

[XT SQL Error]

11.Gutscheine/Koupons link Gutschein Queque

- Wenn ich da drauf klicke bekomme ich folgende fehlermeldung, nur warum und wie beseitige ich die ?

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 c.customers_firstname, c.customers_lastname, gv.unique_id, gv.date_created, gv.amount, gv.order_id from customers c, coupon_gv_queue gv where (gv.customer_id = c.customers_id and gv.release_flag = 'N') limit -20, 20

[XT SQL Error]

12. Gutscheine/Koupons link Gutschein Queque

- Wenn ich da drauf klicke bekomme ich folgende fehlermeldung, nur warum und wie beseitige ich die ?

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 c.customers_firstname, c.customers_lastname, gv.unique_id, gv.date_created, gv.amount, gv.order_id from customers c, coupon_gv_queue gv where (gv.customer_id = c.customers_id and gv.release_flag = 'N') limit -20, 20

[XT SQL Error]

13. Gutscheine/Koupons link Gutschein Versand

- Wenn ich da drauf klicke bekomme ich folgende fehlermeldung, nur warum und wie beseitige ich die ?

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 c.coupon_amount, c.coupon_code, c.coupon_id, et.sent_firstname, et.sent_lastname, et.customer_id_sent, et.emailed_to, et.date_sent, c.coupon_id from coupons c, coupon_email_track et where c.coupon_id = et.coupon_id limit -20, 20

[XT SQL Error]

ich hoffe ihr k?nnt mir helfen

[caner_can]

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 'left join specials s on p.products_id = s.products_id

select p.products_fsk18, p.products_shippingtime, p.products_model, p.products_ean, pd.products_name, p.products_id, p.products_price, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, pd.products_short_description, pd.products_description, p.manufacturers_id, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_discount_allowed, p.products_tax_class_id from products_description pd, manufacturers m, products p, left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '2' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '2'

[XT SQL Error]

[PILICIC HANDEL]

hallo

das hab eich auch wenn ich auf hersteller gehe

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 'where p.products_status = '1' and

select p.products_fsk18, p.products_shippingtime, p.products_model, p.products_ean, pd.products_name, p.products_id, p.products_price, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, pd.products_short_description, pd.products_description, p.manufacturers_id, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_discount_allowed, p.products_tax_class_id from products_description pd, manufacturers m, products p left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id where p.products_status = '1' and pd.products_id = p.products_id and p.products_fsk18!=1 and pd.language_id = '2' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '7'

[XT SQL Error]

[rivendarkness]

Na die Suchfuntkion hier hätte geholfen. Da gehts weiter:

http://www.xt-commerce.com/forum/showthread.php?t=48052&highlight=1064