Chyba 1064

1. Návštěvník 726C9B16 17. 8. 2005 21:29

   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

2. Návštěvník 53519B1F 17. 8. 2005 22:17

   zkus zaměnit ENGINE za type

3. Návštěvník 726C9B16 17. 8. 2005 22:49

   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

4. Návštěvník 53519B1F 17. 8. 2005 23:41

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

5. Návštěvník 726C9B16 18. 8. 2005 01:13

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

6. Návštěvník 53519B1F 18. 8. 2005 10:15

   nie je zač to

← Zpět na všechna témata