Chybný import databáze

Milan

(4 hodnocení)

19. 1. 2016 23:42:54

Zdravím,

Při importu databáze z hostingu svethostingu.cz na mysql hostingu Savana.cz vyhazuje tuto chybu:

Nahraje to jen 24 tabulek z 80 ti.

Je to u RS CMS made simple.

Byl by někdo ochotem mi s tím pomoci? Děkuji.

19. 1. 2016 23:42:54

https://webtrh.cz/diskuse/chybny-import-databaze#reply1167523

Jirka

(74 hodnocení)

19. 1. 2016 23:46:42

Evidentne jste tam ten autoincrement dopsal sam ( jinak by byl CAPS) ale zapomel jste na klic. Export totiz ted deli strukturu, klice a autoincrement. Kdyz to chcete mit pohromate, tak je potreba dopsat definice klice primo do CREATE TABLE :

19. 1. 2016 23:46:42

https://webtrh.cz/diskuse/chybny-import-databaze#reply1167522

Milan

(4 hodnocení)

19. 1. 2016 23:54:35

Mé kroky : Export na svethostingu > Import na Savaně. Nic jsem neupravoval. Když vypnu Zastavit při chybě je celkový soupis chyb :

-- ------------------------------------------------------------ Struktura tabulky `lamipac_module_cge_assocdata`--CREATE TABLE IF NOT EXISTS `lamipac_module_cge_assocdata` ( `id` int(11) NOT NULL auto_increment, `key1` varchar(255) default NULL, `key2` varchar(255) default NULL, `key3` varchar(255) default NULL, `key4` varchar(255) default NULL, `data` text, `expiry` varchar(20) default NULL, `create_date` datetime default NULL, `modified_date` datetime default NULL, `type` varchar(50) default NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8Chyba v dotazu (1075): Incorrect table definition; there can be only one auto column and it must be defined as a key-- ------------------------------------------------------------ Struktura tabulky `lamipac_module_cge_countries`--CREATE TABLE IF NOT EXISTS `lamipac_module_cge_countries` ( `id` int(11) NOT NULL auto_increment, `code` varchar(2) NOT NULL, `name` varchar(50) default NULL, `sorting` int(11) default '0') ENGINE=MyISAM AUTO_INCREMENT=239 DEFAULT CHARSET=utf8Chyba v dotazu (1075): Incorrect table definition; there can be only one auto column and it must be defined as a key---- Vypisuji data pro tabulku `lamipac_module_cge_countries`--INSERT INTO `lamipac_module_cge_countries` (`id`, `code`, `name`, `sorting`) VALUES(1, 'AF', 'Afghanistan', 0),(2, 'AL', 'Albania', 0),(3, 'DZ', 'Algeria', 0),(4, 'AS', 'American Samoa', 0),(5, 'AD', 'Andorra', 0),(6, 'AO', 'Angola', 0),(7, 'AI', 'Anguilla', 0),(8, 'AQ', 'Antarctica', 0),(9, 'AG', 'Antigua And Barbuda', 0),(10, 'AR', 'Argentina', 0),(11, 'AM', 'Armenia', 0),(12, 'AW', 'Aruba', 0),(13, 'AU', 'Australia', 0),(14, 'AT', 'Austria', 0),(15, 'AZ', 'Azerbaijan', 0),(16, 'BS', 'Bahamas', 0),(17, 'BH', 'Bahrain', 0),(18, 'BD', 'Bangladesh', 0),(19, 'BB', 'Barbados', 0),(20, 'BY', 'Belarus', 0),(21, 'BE', 'Belgium', 0),(22, 'BZ', 'Belize', 0),(23, 'BJ', 'Benin', 0),(24, 'BM', 'Bermuda', 0),(25, 'BT', 'Bhutan', 0),(26, 'BO', 'Bolivia', 0),(27, 'BA', 'Bosnia And Herzegowina', 0),(28, 'BW', 'Botswana', 0),(29, 'BV', 'Bouvet Island', 0),(30, 'BR', 'Brazil', 0),(31, 'IO', 'British Indian...Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_cge_countries' doesn't exist-- ------------------------------------------------------------ Struktura tabulky `lamipac_module_cge_states`--CREATE TABLE IF NOT EXISTS `lamipac_module_cge_states` ( `id` int(11) NOT NULL auto_increment, `code` varchar(2) NOT NULL, `name` varchar(50) default NULL, `sorting` int(11) default '0') ENGINE=MyISAM AUTO_INCREMENT=72 DEFAULT CHARSET=utf8Chyba v dotazu (1075): Incorrect table definition; there can be only one auto column and it must be defined as a key---- Vypisuji data pro tabulku `lamipac_module_cge_states`--INSERT INTO `lamipac_module_cge_states` (`id`, `code`, `name`, `sorting`) VALUES(1, 'AL', 'Alabama', 0),(2, 'AK', 'Alaska', 0),(3, 'AS', 'American Samoa', 0),(4, 'AZ', 'Arizona', 0),(5, 'AR', 'Arkansas', 0),(6, 'CA', 'California', 0),(7, 'CO', 'Colorado', 0),(8, 'CT', 'Connecticut', 0),(9, 'DE', 'Delaware', 0),(10, 'DC', 'District of Columbia', 0),(11, 'FM', 'Fed. States of Micronesia', 0),(12, 'FL', 'Florida', 0),(13, 'GA', 'Georgia', 0),(14, 'GU', 'Guam', 0),(15, 'HI', 'Hawaii', 0),(16, 'ID', 'Idaho', 0),(17, 'IL', 'Illinois', 0),(18, 'IN', 'Indiana', 0),(19, 'IA', 'Iowa', 0),(20, 'KS', 'Kansas', 0),(21, 'KY', 'Kentucky', 0),(22, 'LA', 'Louisiana', 0),(23, 'ME', 'Maine', 0),(24, 'MH', 'Marshall Islands', 0),(25, 'MD', 'Maryland', 0),(26, 'MA', 'Massachusetts', 0),(27, 'MI', 'Michigan', 0),(28, 'MN', 'Minnesota', 0),(29, 'MS', 'Mississippi', 0),(30, 'MO', 'Missouri', 0),(31, 'MT', 'Montana',...Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_cge_states' doesn't exist-- ------------------------------------------------------------ Struktura tabulky `lamipac_module_cggooglemaps`--CREATE TABLE IF NOT EXISTS `lamipac_module_cggooglemaps` ( `map_id` int(11) NOT NULL auto_increment, `name` varchar(80) NOT NULL, `owner_id` int(11) default NULL, `category_panel` tinyint(4) default NULL, `data` text) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8Chyba v dotazu (1075): Incorrect table definition; there can be only one auto column and it must be defined as a key---- Vypisuji data pro tabulku `lamipac_module_cggooglemaps`--INSERT INTO `lamipac_module_cggooglemaps` (`map_id`, `name`, `owner_id`, `category_panel`, `data`) VALUES(1, 'Podlahy Páč Třinec', 0, NULL, 'a:31:{s:12:"default_icon";s:6:"dd-end";s:4:"type";s:3:"map";s:5:"width";s:3:"500";s:6:"height";s:3:"500";s:12:"nav_controls";s:1:"1";s:18:"nav_control_option";s:7:"DEFAULT";s:14:"scale_controls";s:1:"0";s:9:"sv_radius";s:3:"100";s:13:"type_controls";s:1:"1";s:19:"type_control_option";s:7:"DEFAULT";s:7:"sidebar";s:1:"0";s:4:"zoom";s:2:"16";s:11:"info_window";s:1:"1";s:12:"info_trigger";s:5:"click";s:16:"infowindow_width";s:3:"250";s:17:"infowindow_height";s:3:"250";s:14:"category_panel";s:1:"0";s:10:"directions";s:1:"1";s:15:"directions_dest";s:6:"WINDOW";s:16:"directions_units";s:8:"IMPERIAL";s:6:"sensor";s:1:"0";s:14:"zoom_encompass";s:1:"0";s:14:"combine_points";s:1:"0";s:13:"combined_icon";s:7:"airport";s:11:"description";s:0:"";s:10:"center_lat";s:9:"49.678342";s:10:"center_lon...Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_cggooglemaps' doesn't exist-- ------------------------------------------------------------ Struktura tabulky `lamipac_module_cggooglemaps_cats`--CREATE TABLE IF NOT EXISTS `lamipac_module_cggooglemaps_cats` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) default NULL, `info` text, `icon` varchar(100) default NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8Chyba v dotazu (1075): Incorrect table definition; there can be only one auto column and it must be defined as a key-- ------------------------------------------------------------ Struktura tabulky `lamipac_module_cggooglemaps_icons`--CREATE TABLE IF NOT EXISTS `lamipac_module_cggooglemaps_icons` ( `id` int(11) NOT NULL auto_increment, `name` varchar(20) default NULL, `url` varchar(255) default NULL, `anchor_x` int(11) default NULL, `anchor_y` int(11) default NULL, `info_anchor_x` int(11) default NULL, `info_anchor_y` int(11) default NULL) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8Chyba v dotazu (1075): Incorrect table definition; there can be only one auto column and it must be defined as a key---- Vypisuji data pro tabulku `lamipac_module_cggooglemaps_icons`--INSERT INTO `lamipac_module_cggooglemaps_icons` (`id`, `name`, `url`, `anchor_x`, `anchor_y`, `info_anchor_x`, `info_anchor_y`) VALUES(1, 'airport', 'modules/CGGoogleMaps/icons/airport.png', 11, 16, NULL, NULL),(2, 'bank', 'modules/CGGoogleMaps/icons/bank.png', 11, 16, NULL, NULL),(3, 'boatramp', 'modules/CGGoogleMaps/icons/boatramp.png', 11, 16, NULL, NULL),(4, 'building', 'modules/CGGoogleMaps/icons/building.png', 11, 16, NULL, NULL),(5, 'campground', 'modules/CGGoogleMaps/icons/campground.png', 11, 16, NULL, NULL),(6, 'dd-end-small', 'modules/CGGoogleMaps/icons/dd-end-small.png', 5, 8, NULL, NULL),(7, 'dd-end', 'modules/CGGoogleMaps/icons/dd-end.png', 10, 17, NULL, NULL),(8, 'dd-start', 'modules/CGGoogleMaps/icons/dd-start.png', 10, 17, NULL, NULL),(9, 'dive', 'modules/CGGoogleMaps/icons/dive.png', 11, 16, NULL, NULL),(10, 'drinks', 'modules/CGGoogleMaps/icons/drinks.png', 11, 16, NULL, NULL),(11, 'en...Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_cggooglemaps_icons' doesn't exist-- ------------------------------------------------------------ Struktura tabulky `lamipac_module_cggooglemaps_points`--CREATE TABLE IF NOT EXISTS `lamipac_module_cggooglemaps_points` ( `marker_id` int(11) NOT NULL auto_increment, `map_id` int(11) default NULL, `name` varchar(80) default NULL, `info` text, `address` varchar(255) default NULL, `lat` varchar(100) default NULL, `lon` varchar(100) default NULL, `icon` varchar(100) default NULL, `categories` text) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8Chyba v dotazu (1075): Incorrect table definition; there can be only one auto column and it must be defined as a key---- Vypisuji data pro tabulku `lamipac_module_cggooglemaps_points`--INSERT INTO `lamipac_module_cggooglemaps_points` (`marker_id`, `map_id`, `name`, `info`, `address`, `lat`, `lon`, `icon`, `categories`) VALUES(1, 1, 'Podlahy Páč Třinec', '', '', '49.678342', '18.667775', 'dd-start', NULL)Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_cggooglemaps_points' doesn't exist-- ------------------------------------------------------------ Struktura tabulky `lamipac_module_gallery`--CREATE TABLE IF NOT EXISTS `lamipac_module_gallery` ( `fileid` int(11) NOT NULL auto_increment, `filename` varchar(255) default NULL, `filepath` varchar(255) default NULL, `filedate` datetime default NULL, `fileorder` int(11) default NULL, `active` int(11) default NULL, `defaultfile` int(11) default NULL, `galleryid` int(11) NOT NULL, `title` varchar(255) default NULL, `comment` text) ENGINE=MyISAM AUTO_INCREMENT=2421 DEFAULT CHARSET=utf8Chyba v dotazu (1075): Incorrect table definition; there can be only one auto column and it must be defined as a key---- Vypisuji data pro tabulku `lamipac_module_gallery`--INSERT INTO `lamipac_module_gallery` (`fileid`, `filename`, `filepath`, `filedate`, `fileorder`, `active`, `defaultfile`, `galleryid`, `title`, `comment`) VALUES(1, 'Gallery/', '', '2010-03-24 23:08:57', -1, 1, 2, 0, 'Fotogalerie', 'Galerie materiálů a našich realizací'),(3, 'BARLINEK/', '', '2010-04-04 09:37:37', 0, 1, 14, 1, '', ''),(524, 'Star 1160-0002-0.jpg', 'PVC/FATRA/STAR', '2010-04-26 14:34:36', 0, 1, 0, 285, '', ''),(2241, 'thumbnail-1024768-dual-414.jpg', 'PVC/FATRA/DUAL', '2014-05-06 08:13:34', 6, 1, 0, 283, 'Dual 414', ''),(2138, 'thumbnail-1024768-10204-2-x-kalibrovane.jpg', 'PVC/FATRA/THERMOFIX/THERMOFIX DŘEVO RUSTIKAL', '2012-07-12 12:36:24', 0, 1, 0, 2109, 'Dub tmavý / 10204-2', ''),(269, 'editor_1b080fc93d26dc28c100fa418488cc2c_8748b2.jpeg', 'KOREK/OBKLAD', '2010-04-20 16:22:52', 0, 0, 0, 247, '', ''),(2242, 'thumbnail-1024768-dual-830.jpg', 'PVC/FATRA/DUAL', '2014-05-06 08:13:49', 9, 1, 0, 283, 'Dual...Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_gallery' doesn't existINSERT INTO `lamipac_module_gallery` (`fileid`, `filename`, `filepath`, `filedate`, `fileorder`, `active`, `defaultfile`, `galleryid`, `title`, `comment`) VALUES(725, '1259692684EM3102Ljavor sv', 'EGEER/Egeer Emotion 31', '2010-05-04 14:31:28', 0, 1, 0, 702, '', ''),(726, '1259692052EM3101Lbuk ', 'EGEER/Egeer Emotion 31', '2010-05-04 14:31:28', 0, 1, 0, 702, '', ''),(727, '1259694756EM3112Lplatan ', 'EGEER/Egeer Emotion 31', '2010-05-04 14:31:28', 0, 1, 0, 702, '', ''),(728, '1259694461EM3109Ldub p', 'EGEER/Egeer Emotion 31', '2010-05-04 14:31:28', 0, 1, 0, 702, '', ''),(779, '1259747017EM3105L merbau parketa -3p', 'EGEER/Egeer Emotion 31', '2010-05-04 14:31:28', 0, 1, 0, 702, '', ''),(780, '1259694581EM3110Ldub oxford selsk', 'EGEER/Egeer Emotion 31', '2010-05-04 14:31:28', 0, 1, 0, 702, '', ''),(781, '1259694292EM3108L o', 'EGEER/Egeer Emotion 31', '2010-05-04 14:31:28', 0, 1, 0, 702, '', ''),(782, '1259694184EM3107Lsmrk horsk', 'EGEER/Egeer Emotion 31', '2010-05-04 14:31:28'...Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_gallery' doesn't existINSERT INTO `lamipac_module_gallery` (`fileid`, `filename`, `filepath`, `filedate`, `fileorder`, `active`, `defaultfile`, `galleryid`, `title`, `comment`) VALUES(1327, 'lima_92.JPG', 'KOBERCE/kobercove_ctverce/Lima', '2010-05-08 19:25:32', 0, 1, 0, 1101, '', ''),(1328, 'lima_99.jpg', 'KOBERCE/kobercove_ctverce/Lima', '2010-05-08 19:25:40', 0, 1, 0, 1101, '', ''),(1329, 'mars_53.jpg', 'KOBERCE/kobercove_ctverce/Mars', '2010-05-08 19:27:54', 0, 1, 0, 1102, '', ''),(1330, 'mars_55.jpg', 'KOBERCE/kobercove_ctverce/Mars', '2010-05-08 19:27:59', 0, 1, 0, 1102, '', ''),(1331, 'mars_65.jpg', 'KOBERCE/kobercove_ctverce/Mars', '2010-05-08 19:30:27', 0, 1, 0, 1102, '', ''),(1332, 'mars_71.jpg', 'KOBERCE/kobercove_ctverce/Mars', '2010-05-08 19:30:45', 0, 1, 0, 1102, '', ''),(1333, 'mars_73.jpg', 'KOBERCE/kobercove_ctverce/Mars', '2010-05-08 19:30:52', 0, 1, 0, 1102, '', ''),(1334, 'mars_61.jpg', 'KOBERCE/kobercove_ctverce/Mars', '2010-05-08 19:29:29', 0, 1, 0, 1102, '', ''),(1335, 'mars_6...Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_gallery' doesn't existINSERT INTO `lamipac_module_gallery` (`fileid`, `filename`, `filepath`, `filedate`, `fileorder`, `active`, `defaultfile`, `galleryid`, `title`, `comment`) VALUES(1857, '763202.jpg', 'MARMOLEUM/marmoleum click/Marmoleum click', '2010-05-13 15:56:26', 0, 1, 0, 1851, '', ''),(1858, '763038.jpg', 'MARMOLEUM/marmoleum click/Marmoleum click', '2010-05-13 15:56:26', 0, 1, 0, 1851, '', ''),(1859, '763879.jpg', 'MARMOLEUM/marmoleum click/Marmoleum click', '2010-05-13 15:56:26', 0, 1, 0, 1851, '', ''),(1860, '763127.jpg', 'MARMOLEUM/marmoleum click/Marmoleum click', '2010-05-13 15:56:26', 0, 1, 0, 1851, '', ''),(1861, '763858.jpg', 'MARMOLEUM/marmoleum click/Marmoleum click', '2010-05-13 15:56:26', 0, 1, 0, 1851, '', ''),(1862, '763877.jpg', 'MARMOLEUM/marmoleum click/Marmoleum click', '2010-05-13 15:56:26', 0, 1, 0, 1851, '', ''),(1863, '763878.jpg', 'MARMOLEUM/marmoleum click/Marmoleum click', '2010-05-13 15:56:26', 0, 1, 0, 1851, '', ''),(1864, '763860.jpg', 'MARMOLEUM/marmoleum click...Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_gallery' doesn't exist-- ------------------------------------------------------------ Struktura tabulky `lamipac_module_gallery_fielddefs`--CREATE TABLE IF NOT EXISTS `lamipac_module_gallery_fielddefs` ( `fieldid` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `type` varchar(20) default NULL, `maxlength` int(11) default NULL, `dirfield` tinyint(4) default NULL, `sortorder` int(11) default NULL, `public` tinyint(4) default NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8Chyba v dotazu (1075): Incorrect table definition; there can be only one auto column and it must be defined as a key-- ------------------------------------------------------------ Struktura tabulky `lamipac_module_gallery_templateprops`--CREATE TABLE IF NOT EXISTS `lamipac_module_gallery_templateprops` ( `templateid` int(11) NOT NULL auto_increment, `template` varchar(255) default NULL, `version` varchar(20) default NULL, `about` text, `thumbwidth` int(11) default NULL, `thumbheight` int(11) default NULL, `resizemethod` varchar(10) default NULL, `maxnumber` int(11) default NULL, `sortitems` varchar(255) default NULL, `visible` int(11) default NULL) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8Chyba v dotazu (1075): Incorrect table definition; there can be only one auto column and it must be defined as a key---- Vypisuji data pro tabulku `lamipac_module_gallery_templateprops`--INSERT INTO `lamipac_module_gallery_templateprops` (`templateid`, `template`, `version`, `about`, `thumbwidth`, `thumbheight`, `resizemethod`, `maxnumber`, `sortitems`, `visible`) VALUES(1, 'Fancybox', '1.3.0-1', 'This Gallerytemplate uses the Fancybox system version 1.3.0rnDocumentation for extra options can be found at <a href="http://www.fancybox.net/" target="_blank">www.fancybox.net</a>rnFiles that come with Fancybox are stored in modules/Gallery/templates/fancybox/rnFancybox was built using the <a href="http://jquery.com/">jQuery library</a>. Licensed under both <a href="http://docs.jquery.com/Licensing">MIT and GPL licenses</a>', NULL, NULL, NULL, NULL, 'n-isdir/s+file', 1),(2, 'Lightbox', '2.04-1', 'This Gallerytemplate uses the Lightbox2 system version 2.04 by Lokesh DhakarrnDocumentation can be found at <a href="http://www.huddletogether.com/proj...Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_gallery_templateprops' doesn't exist-- ------------------------------------------------------------ Struktura tabulky `lamipac_module_jquery_scripts`--CREATE TABLE IF NOT EXISTS `lamipac_module_jquery_scripts` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `position` int(11) default NULL, `code` longtext, `load_default` int(11) default NULL, `in_header` int(11) default NULL, `required_plugins` varchar(255) default NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8Chyba v dotazu (1075): Incorrect table definition; there can be only one auto column and it must be defined as a key-- ------------------------------------------------------------ Struktura tabulky `lamipac_module_news_fielddefs`--CREATE TABLE IF NOT EXISTS `lamipac_module_news_fielddefs` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `type` varchar(50) default NULL, `max_length` int(11) default NULL, `create_date` datetime default NULL, `modified_date` datetime default NULL, `item_order` int(11) default NULL, `public` int(11) default NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8Chyba v dotazu (1075): Incorrect table definition; there can be only one auto column and it must be defined as a key---- Klíče pro tabulku `lamipac_module_cge_assocdata`--ALTER TABLE `lamipac_module_cge_assocdata` ADD PRIMARY KEY (`id`)Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_cge_assocdata' doesn't exist---- Klíče pro tabulku `lamipac_module_cge_countries`--ALTER TABLE `lamipac_module_cge_countries` ADD PRIMARY KEY (`id`,`code`)Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_cge_countries' doesn't exist---- Klíče pro tabulku `lamipac_module_cge_states`--ALTER TABLE `lamipac_module_cge_states` ADD PRIMARY KEY (`id`,`code`)Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_cge_states' doesn't exist---- Klíče pro tabulku `lamipac_module_cggooglemaps`--ALTER TABLE `lamipac_module_cggooglemaps` ADD PRIMARY KEY (`map_id`)Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_cggooglemaps' doesn't exist---- Klíče pro tabulku `lamipac_module_cggooglemaps_cats`--ALTER TABLE `lamipac_module_cggooglemaps_cats` ADD PRIMARY KEY (`id`)Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_cggooglemaps_cats' doesn't exist---- Klíče pro tabulku `lamipac_module_cggooglemaps_icons`--ALTER TABLE `lamipac_module_cggooglemaps_icons` ADD PRIMARY KEY (`id`)Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_cggooglemaps_icons' doesn't exist---- Klíče pro tabulku `lamipac_module_cggooglemaps_points`--ALTER TABLE `lamipac_module_cggooglemaps_points` ADD PRIMARY KEY (`marker_id`)Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_cggooglemaps_points' doesn't exist---- Klíče pro tabulku `lamipac_module_gallery`--ALTER TABLE `lamipac_module_gallery` ADD PRIMARY KEY (`fileid`,`galleryid`)Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_gallery' doesn't exist---- Klíče pro tabulku `lamipac_module_gallery_fielddefs`--ALTER TABLE `lamipac_module_gallery_fielddefs` ADD PRIMARY KEY (`fieldid`)Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_gallery_fielddefs' doesn't exist---- Klíče pro tabulku `lamipac_module_gallery_templateprops`--ALTER TABLE `lamipac_module_gallery_templateprops` ADD PRIMARY KEY (`templateid`)Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_gallery_templateprops' doesn't exist---- Klíče pro tabulku `lamipac_module_jquery_scripts`--ALTER TABLE `lamipac_module_jquery_scripts` ADD PRIMARY KEY (`id`)Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_jquery_scripts' doesn't exist---- Klíče pro tabulku `lamipac_module_news_fielddefs`--ALTER TABLE `lamipac_module_news_fielddefs` ADD PRIMARY KEY (`id`)Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_news_fielddefs' doesn't exist---- AUTO_INCREMENT pro tabulky------ AUTO_INCREMENT pro tabulku `lamipac_module_cge_countries`--ALTER TABLE `lamipac_module_cge_countries`AUTO_INCREMENT=239Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_cge_countries' doesn't exist---- AUTO_INCREMENT pro tabulku `lamipac_module_cge_states`--ALTER TABLE `lamipac_module_cge_states`AUTO_INCREMENT=72Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_cge_states' doesn't exist---- AUTO_INCREMENT pro tabulku `lamipac_module_cggooglemaps`--ALTER TABLE `lamipac_module_cggooglemaps`AUTO_INCREMENT=2Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_cggooglemaps' doesn't exist---- AUTO_INCREMENT pro tabulku `lamipac_module_cggooglemaps_icons`--ALTER TABLE `lamipac_module_cggooglemaps_icons`AUTO_INCREMENT=32Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_cggooglemaps_icons' doesn't exist---- AUTO_INCREMENT pro tabulku `lamipac_module_cggooglemaps_points`--ALTER TABLE `lamipac_module_cggooglemaps_points`AUTO_INCREMENT=2Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_cggooglemaps_points' doesn't exist---- AUTO_INCREMENT pro tabulku `lamipac_module_gallery`--ALTER TABLE `lamipac_module_gallery`AUTO_INCREMENT=2421Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_gallery' doesn't exist---- AUTO_INCREMENT pro tabulku `lamipac_module_gallery_templateprops`--ALTER TABLE `lamipac_module_gallery_templateprops`AUTO_INCREMENT=7Chyba v dotazu (1146): Table 'pac78trpo8k.lamipac_module_gallery_templateprops' doesn't exist231 příkazů proběhlo v pořádku. (1.539 s)

19. 1. 2016 23:54:35

https://webtrh.cz/diskuse/chybny-import-databaze#reply1167521

Jirka

(74 hodnocení)

20. 1. 2016 00:02:31

Ten export je docela zmateny... udelejte zvlast strukturu, importujte, pak zvlast data a importujte. Jestli nepujde ta struktura importovat, tak v textaku nahradte "NULL auto_increment" za "NULL" nebot autoincrement je definovan zvlast nize

20. 1. 2016 00:02:31

https://webtrh.cz/diskuse/chybny-import-databaze#reply1167520

Milan

(4 hodnocení)

20. 1. 2016 00:18:49

Import po této úpravě bez problémů, posílám několikanásobné díky.