1064 - SQL-Fehler bei Steuern

[futurama103579]

Hi!

Hab mir mal XTCommerce installiert und finds auch echt gut, nur hab ich ein Problem:

Wenn ich auf Steuerzonen gehe, bekomm ich folgende Fehlermeldung angezeigt:

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 geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added from geo_zones order by geo_zone_name limit -20, 20

[XT SQL Error]


bei Steuerklassen:

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 tax_class_id, tax_class_title, tax_class_description, last_modified, date_added from tax_class order by tax_class_title limit -20, 20

[XT SQL Error]


und bei Steuers?tze

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 r.tax_rates_id, z.geo_zone_id, z.geo_zone_name, tc.tax_class_title, tc.tax_class_id, r.tax_priority, r.tax_rate, r.tax_description, r.date_added, r.last_modified from tax_class tc, tax_rates r left join geo_zones z on r.tax_zone_id = z.geo_zone_id where r.tax_class_id = tc.tax_class_id limit -20, 20

[XT SQL Error]


Wie kann ich das beheben?


Au?erdem bekomm ich bei NEWS nen Fehler:

Warning: fopen(/home/concept-carstyling-de/htdocs/OS/admin/rss/xt-news.cache): failed to open stream: Permission denied in /home/concept-carstyling-de/htdocs/OS/admin/includes/classes/carpinc.php on line 265

[CaRP] Can't open cache file.

Warning: touch(): Utime failed: Operation not permitted in /home/concept-carstyling-de/htdocs/OS/admin/includes/classes/carp.php on line 110

[CaRP] Unable to create/open RSS cache file.

[hp]

Zu Fehler 1 und 2:

?ffne die Datei admin/includes/classes/split_page_results.php

suche

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

und F?ge vor diese Zeile ein

if($offset<0) $offset=0;

original von Benax gepostet

gruss


hp

[chpohl]

admin/rss/xt-news.cache

Datei auf CHMOD 777 setzen

[futurama103579]

Danke!!!!!