Chyba 1064

Pri nahravani databazy mi hadze chybu 1064. Neviete niekto co stym?

CREATE TABLE `mos_categories` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`parent_id` int( 11 ) NOT NULL default '0',
`title` varchar( 50 ) NOT NULL default '',
`name` varchar( 255 ) NOT NULL default '',
`image` varchar( 100 ) NOT NULL default '',
`section` varchar( 50 ) NOT NULL default '',
`image_position` varchar( 10 ) NOT NULL default '',
`description` text NOT NULL ,
`published` tinyint( 1 ) NOT NULL default '0',
`checked_out` int( 11 ) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar( 50 ) default NULL ,
`ordering` int( 11 ) NOT NULL default '0',
`access` tinyint( 3 ) unsigned NOT NULL default '0',
`count` int( 11 ) NOT NULL default '0',
`params` text NOT NULL ,
PRIMARY KEY ( `id` ) ,
KEY `cat_idx` ( `section` , `published` , `access` ) ,
KEY `idx_section` ( `section` ) ,
KEY `idx_access` ( `access` ) ,
KEY `idx_checkout` ( `checked_out` )
)ENGINE = MYISAM DEFAULT CHARSET = latin2 AUTO_INCREMENT = 15

MySQL hlásí:

#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 'ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=15' at line

zkus zaměnit ENGINE za type

Po zmene ENGINE na type hlási:

Databáza skspyware beží na localhost
Chyba

SQL dotaz :

CREATE TABLE `mos_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 DEFAULT CHARSET = latin2 AUTO_INCREMENT = 1

MySQL hlási:


#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 'DEFAULT CHARSET=latin2 AUTO_INCREMENT=1' at line 19

hele, musí tam bejt to za tim type=myisam? ono to je totiž IMHO standartní...

Tak nakoniec som to vyriesil tym ze som nainstaloval noveho phpmyAdmina. Dakujem za pomoc OndraSter.

nie je zač to