Warnung: Installation der Site-Applikation fehlgeschlagen:

[schorse]

Warning: Installation of the application site failed:

Hello community,

a new reiniatialisation of my Server (1&1 Root-Server) have a small problem.

It is simply not possible to install a site application with mysql included. It appears the following errors:


Warning: Installation of the application site failed: Unable to execute SQL statement (CREATE TABLE `banner` (
`` Bid int (11) NOT NULL auto_increment,
`` Cid int (11) NOT NULL default''0'',
`Type` varchar (10) NOT NULL default banner''''
`Name` varchar (50) NOT NULL default'''',
`` Imptotal int (11) NOT NULL default''0'',
`` Impmade int (11) NOT NULL default''0'',
`` Clicks int (11) NOT NULL default''0'',
`` Imageurl varchar (100) NOT NULL default'''',
`` Clickurl varchar (200) NOT NULL default'''',
`Date` datetime default NULL,
`` ShowBanner tinyint (1) NOT NULL default''0'',
`` Checked_out tinyint (1) NOT NULL default''0'',
`` Checked_out_time datetime NOT NULL default''0000-00-00 00:00:00'',
`` Editor varchar (50) default NULL,
`` Custombannercode text,
PRIMARY KEY ( `` BID),
KEY `viewbanner` ( `showBanner`)
) TYPE = MyISAM AUTO_INCREMENT = 3): 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'0''
`Type` varchar (10) NOT NULL default banner''''
`Name` varchar (50) NOT 'at line 3



There will be no db added.
I hope that someone can help me please.

System: Suse 10.2-64 with Plesk 8.3

Greatings Schorse

 

[tiramisu_]

Hello,

Please try to disable magic_quotes:

http://kb.swsoft.com/en/4600

 

[schorse]

Thanx a lot, thats it