Danke und ein Problem

Habe die Komponente nun deinstalliert und versucht wieder neu zu installieren (Mit dem Download von hier). Doch nun bekomme ich beim Installieren folgende Fehlermeldung:



* JInstaller::install: SQL-Fehler DB function failed with error number 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 \'(2000) NOT NULL, `ad_state` tinyint(1) NOT NULL DEFAULT 0, `ad_price` int(\' at line 9 SQL=CREATE TABLE IF NOT EXISTS `jos_ksads_ads` ( `id` int(11) NOT NULL AUTO_INCREMENT, `catid` int(11) NOT NULL DEFAULT 1, `user_id` int(11) NOT NULL, `ad_ident` varchar(20) NOT NULL, `ad_name` varchar(255) NOT NULL, `ad_address` varchar(255) NOT NULL, `ad_intro` varchar(255) NOT NULL, `ad_desc` longtext(2000) NOT NULL, `ad_state` tinyint(1) NOT NULL DEFAULT 0, `ad_price` int(10) NOT NULL, `ad_location` varchar(100) NOT NULL, `ad_post` varchar(10) NOT NULL, `ad_delivery` varchar(100) NOT NULL, `ad_image` varchar(255) NOT NULL, `ad_img_comment` varchar(255) NOT NULL, `ad_boxnumber` tinyint(1) NOT NULL, `contact_name` varchar(255) NOT NULL, `contact_tel` varchar(30) NOT NULL, `contact_email` varchar(255) NOT NULL, `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `published` tinyint(1) NOT NULL, `prolonged` smallint(2) NOT NULL DEFAULT 0, `show_address` tinyint(1) NOT NULL, `views` int(11) NOT NULL DEFAULT 0, `meta` varchar(255) NOT NULL, `phonetic` varchar(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ad_name` (`ad_name`), UNIQUE KEY `id` (`id`) ) DEFAULT CHARSET=utf8 COMMENT=\'stores the classifieds information\';
SQL =

CREATE TABLE IF NOT EXISTS `jos_ksads_ads` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`catid` int(11) NOT NULL DEFAULT 1,
`user_id` int(11) NOT NULL,
`ad_ident` varchar(20) NOT NULL,
`ad_name` varchar(255) NOT NULL,
`ad_address` varchar(255) NOT NULL,
`ad_intro` varchar(255) NOT NULL,
`ad_desc` longtext(2000) NOT NULL,
`ad_state` tinyint(1) NOT NULL DEFAULT 0,
`ad_price` int(10) NOT NULL,
`ad_location` varchar(100) NOT NULL,
`ad_post` varchar(10) NOT NULL,
`ad_delivery` varchar(100) NOT NULL,
`ad_image` varchar(255) NOT NULL,
`ad_img_comment` varchar(255) NOT NULL,
`ad_boxnumber` tinyint(1) NOT NULL,
`contact_name` varchar(255) NOT NULL,
`contact_tel` varchar(30) NOT NULL,
`contact_email` varchar(255) NOT NULL,
`date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`published` tinyint(1) NOT NULL,
`prolonged` smallint(2) NOT NULL DEFAULT 0,
`show_address` tinyint(1) NOT NULL,
`views` int(11) NOT NULL DEFAULT 0,
`meta` varchar(255) NOT NULL,
`phonetic` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ad_name` (`ad_name`),
UNIQUE KEY `id` (`id`)
) DEFAULT CHARSET=utf8 COMMENT=\'stores the classifieds information\';

* Komponenten Installieren: SQL-Fehler! Fehlende oder nicht lesbare SQL-Datei. DB function failed with error number 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 \'(2000) NOT NULL, `ad_state` tinyint(1) NOT NULL DEFAULT 0, `ad_price` int(\' at line 9 SQL=CREATE TABLE IF NOT EXISTS `jos_ksads_ads` ( `id` int(11) NOT NULL AUTO_INCREMENT, `catid` int(11) NOT NULL DEFAULT 1, `user_id` int(11) NOT NULL, `ad_ident` varchar(20) NOT NULL, `ad_name` varchar(255) NOT NULL, `ad_address` varchar(255) NOT NULL, `ad_intro` varchar(255) NOT NULL, `ad_desc` longtext(2000) NOT NULL, `ad_state` tinyint(1) NOT NULL DEFAULT 0, `ad_price` int(10) NOT NULL, `ad_location` varchar(100) NOT NULL, `ad_post` varchar(10) NOT NULL, `ad_delivery` varchar(100) NOT NULL, `ad_image` varchar(255) NOT NULL, `ad_img_comment` varchar(255) NOT NULL, `ad_boxnumber` tinyint(1) NOT NULL, `contact_name` varchar(255) NOT NULL, `contact_tel` varchar(30) NOT NULL, `contact_email` varchar(255) NOT NULL, `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `published` tinyint(1) NOT NULL, `prolonged` smallint(2) NOT NULL DEFAULT 0, `show_address` tinyint(1) NOT NULL, `views` int(11) NOT NULL DEFAULT 0, `meta` varchar(255) NOT NULL, `phonetic` varchar(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ad_name` (`ad_name`), UNIQUE KEY `id` (`id`) ) DEFAULT CHARSET=utf8 COMMENT=\'stores the classifieds information\';
SQL =

CREATE TABLE IF NOT EXISTS `jos_ksads_ads` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`catid` int(11) NOT NULL DEFAULT 1,
`user_id` int(11) NOT NULL,
`ad_ident` varchar(20) NOT NULL,
`ad_name` varchar(255) NOT NULL,
`ad_address` varchar(255) NOT NULL,
`ad_intro` varchar(255) NOT NULL,
`ad_desc` longtext(2000) NOT NULL,
`ad_state` tinyint(1) NOT NULL DEFAULT 0,
`ad_price` int(10) NOT NULL,
`ad_location` varchar(100) NOT NULL,
`ad_post` varchar(10) NOT NULL,
`ad_delivery` varchar(100) NOT NULL,
`ad_image` varchar(255) NOT NULL,
`ad_img_comment` varchar(255) NOT NULL,
`ad_boxnumber` tinyint(1) NOT NULL,
`contact_name` varchar(255) NOT NULL,
`contact_tel` varchar(30) NOT NULL,
`contact_email` varchar(255) NOT NULL,
`date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`published` tinyint(1) NOT NULL,
`prolonged` smallint(2) NOT NULL DEFAULT 0,
`show_address` tinyint(1) NOT NULL,
`views` int(11) NOT NULL DEFAULT 0,
`meta` varchar(255) NOT NULL,
`phonetic` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ad_name` (`ad_name`),
UNIQUE KEY `id` (`id`)
) DEFAULT CHARSET=utf8 COMMENT=\'stores the classifieds information\';

Hallo und vielen Dank für die tolle Komponente.
Sie läuft nun bei mir auch ohne die Slider endlich perfekt, aber ich habe ein kleines neues Problem.
Ich habe die Komponente im Backend komplett eingerichtet und konnte als registrierter User auch alles sehen.
Nun habe ich die Komponente auf öffentlich gestellt und dann sieht man nichts mehr.
Die Seite bleibt einfach nur frei.

Weiß jemand was ich ändern kann/muss oder was falsch sein kann?


Danke für die Hilfe