Danke und ein Problem

Erstmal Danke für die schnellen Antworten!

Also Hier die 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, 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` text(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` date NOT NULL DEFAULT \'0000-00-00 00:00:00\', `date_expiry` date NOT NULL DEFAULT \'0000-00-00 00:00:00\', `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`) ) 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` text(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` date NOT NULL DEFAULT \'0000-00-00 00:00:00\',
`date_expiry` date NOT NULL DEFAULT \'0000-00-00 00:00:00\',
`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`)
) 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, 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` text(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` date NOT NULL DEFAULT \'0000-00-00 00:00:00\', `date_expiry` date NOT NULL DEFAULT \'0000-00-00 00:00:00\', `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`) ) 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` text(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` date NOT NULL DEFAULT \'0000-00-00 00:00:00\',
`date_expiry` date NOT NULL DEFAULT \'0000-00-00 00:00:00\',
`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`)
) DEFAULT CHARSET=utf8 COMMENT=\'stores the classifieds information\';

Nun, ich habe Joomla Version 1.5.15
PHP Version 5.2.12
MySQL: 4.1.2

Mache ich da was verkehrt?

Habe mir auch die neue Version hier vom Server gezogen, aber das selbe Resultat!


Gruß Freddy

hat bei mir nur mit SQL5 funktioniert, hatte mir 4 keine Chance zu installieren.
Vielleicht ist das das Probelm?

Hallo zusammen, ich würde gerne auf meiner Seite euren Kleinanzeigenmarkt mit rein nehmen,

aber ich habe auch das Problem mit der SQL!

Habe bereits von eurer Seite neu runter geladen und wollte es installieren! aber no way!

Was mache ich da verkehrt?


Gruß Freddy

PS: Danke im Voraus!

Super vielen Dank.
Jetzt klappt alles.

Vielen vielen Dank für den tollen Support