Upgrade 1.2.5-DEV to 1.4.1 database upgrade error

Please post all install related problems here. Visit this forum first for troubleshooting.
Post Reply
User avatar
forefront
Posts: 96
Joined: Sun 16. May 2004, 14:13
Location: Cherryvale, KS • USA
Contact:

Upgrade 1.2.5-DEV to 1.4.1 database upgrade error

Post by forefront » Fri 8. May 2009, 04:57

I am upgrading from 1.2.5-DEV to 1.4.1 ... and it has gone well. The site can be seen and it all appears normal. However ... the database updates had these errors when running the database upgrade for 1.3.5 to 1.5:

Code: Select all

ERROR: Duplicate column name 'acat_archive' -> ALTER TABLE `phpwcms_articlecat` ADD `acat_archive` INT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE `phpwcms_articlecat` ADD INDEX ( `acat_archive` );
ERROR: Duplicate column name 'article_archive_status' -> ALTER TABLE `phpwcms_article` ADD `article_archive_status` INT( 1 ) NOT NULL DEFAULT '1';
ALTER TABLE `phpwcms_article` ADD INDEX ( `article_archive_status` );
ERROR: Duplicate column name 'acontent_category' -> ALTER TABLE `phpwcms_articlecontent` ADD `acontent_category` VARCHAR( 255 ) NOT NULL;
ALTER TABLE `phpwcms_file` CHANGE `f_cat` `f_cat` VARCHAR( 255 ) NOT NULL;
ALTER TABLE `phpwcms_file` CHANGE `f_changed` `f_changed` INT NOT NULL DEFAULT '0';
ALTER TABLE `phpwcms_file` CHANGE `f_created` `f_created` INT NOT NULL DEFAULT '0';
ERROR: Can't DROP 'f_log'; check that column/key exists -> ALTER TABLE `phpwcms_file` DROP `f_log`;
ALTER TABLE `phpwcms_file` CHANGE `f_longinfo` `f_longinfo` TEXT NOT NULL;
ERROR: Duplicate column name 'f_copyright' -> ALTER TABLE `phpwcms_file` ADD `f_copyright` VARCHAR( 255 ) NOT NULL;
ERROR: Duplicate column name 'f_tags' -> ALTER TABLE `phpwcms_file` ADD `f_tags` VARCHAR( 255 ) NOT NULL;
ALTER TABLE `phpwcms_file` CHANGE `f_size` `f_size` INT( 15 ) UNSIGNED NOT NULL DEFAULT '0';
ERROR: Duplicate column name 'f_granted' -> ALTER TABLE `phpwcms_file` ADD `f_granted` INT NOT NULL DEFAULT '0';
ALTER TABLE `phpwcms_file` ADD INDEX ( `f_granted` );
ERROR: Duplicate column name 'acontent_granted' -> ALTER TABLE `phpwcms_articlecontent` ADD `acontent_granted` INT NOT NULL DEFAULT '0';
ALTER TABLE `phpwcms_articlecontent` ADD INDEX ( `acontent_granted` );
DROP TABLE IF EXISTS `phpwcms_calendar`;
CREATE TABLE `phpwcms_calendar` ---REMOVED TO MAKE MESSAGE SMALLER---
CREATE TABLE IF NOT EXISTS `phpwcms_content` ---REMOVED TO MAKE MESSAGE SMALLER---
CREATE TABLE IF NOT EXISTS `phpwcms_categories` ---REMOVED TO MAKE MESSAGE SMALLER---
CREATE TABLE IF NOT EXISTS `phpwcms_shop_orders` --REMOVED TO MAKE MESSAGE SMALLER---
CREATE TABLE IF NOT EXISTS `phpwcms_shop_products` ---REMOVED TO MAKE MESSAGE SMALLER---
CREATE TABLE IF NOT EXISTS `phpwcms_sysvalue` ---REMOVED TO MAKE MESSAGE SMALLER---
ERROR: Duplicate column name 'country_updated' -> ALTER TABLE `phpwcms_country` ADD `country_updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP AFTER `country_id`;
ERROR: Duplicate column name 'country_iso3' -> ALTER TABLE `phpwcms_country` ADD `country_iso3` CHAR( 3 ) NOT NULL default '' AFTER `country_iso`;
ERROR: Duplicate column name 'country_isonum' -> ALTER TABLE `phpwcms_country` ADD `country_isonum` INT NOT NULL default '0' AFTER `country_iso3`;
ERROR: Duplicate column name 'country_continent_code' -> ALTER TABLE `phpwcms_country` ADD `country_continent_code` CHAR( 2 ) NOT NULL default '' AFTER `country_isonum`;
ERROR: Duplicate column name 'country_continent' -> ALTER TABLE `phpwcms_country` ADD `country_continent` VARCHAR( 255 ) NOT NULL default '';
ERROR: Duplicate column name 'country_continent_de' -> ALTER TABLE `phpwcms_country` ADD `country_continent_de` VARCHAR( 255 ) NOT NULL default '';
ERROR: Duplicate column name 'country_region' -> ALTER TABLE `phpwcms_country` ADD `country_region` VARCHAR( 255 ) NOT NULL default '';
ERROR: Duplicate column name 'country_region_de' -> ALTER TABLE `phpwcms_country` ADD `country_region_de` VARCHAR( 255 ) NOT NULL default '';
ERROR: Can't DROP 'detail_login'; check that column/key exists -> ALTER TABLE `phpwcms_userdetail` DROP INDEX `detail_login`;
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_float1` `detail_float1` DOUBLE NOT NULL DEFAULT '0';
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_float2` `detail_float2` DOUBLE NOT NULL DEFAULT '0';
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_float3` `detail_float3` DOUBLE NOT NULL DEFAULT '0';
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_float4` `detail_float4` DOUBLE NOT NULL DEFAULT '0';
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_float5` `detail_float5` DOUBLE NOT NULL DEFAULT '0';
TRUNCATE TABLE `phpwcms_country`;
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(1, '0000-00-00 00:00:00', 'AF', 'AFG', 4, 'AS', 'Afghanistan, Islamic Republic of', 'Afghanistan', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(2, '0000-00-00 00:00:00', 'AL', 'ALB', 8, 'EU', 'Albania, Republic of', 'Albanien', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(3, '0000-00-00 00:00:00', 'DZ', 'DZA', 12, 'AF', 'Algeria, People''s Democratic Republic of', 'Algerien', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(4, '0000-00-00 00:00:00', 'AS', 'ASM', 16, 'OC', 'American Samoa', 'Amerikanisch Samoa', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(5, '0000-00-00 00:00:00', 'AD', 'AND', 20, 'EU', 'Andorra, Principality of', 'Andorra', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(6, '0000-00-00 00:00:00', 'AO', 'AGO', 24, 'AF', 'Angola, Republic of', 'Angola', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(7, '0000-00-00 00:00:00', 'AI', 'AIA', 660, 'NA', 'Anguilla', 'Anguilla', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(8, '0000-00-00 00:00:00', 'AQ', 'ATA', 10, 'AN', 'Antarctica (the territory South of 60 deg S)', 'Antarktis', 'Antarctica', 'Antarktis', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(9, '0000-00-00 00:00:00', 'AG', 'ATG', 28, 'NA', 'Antigua and Barbuda', 'Antigua und Barbuda', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(10, '0000-00-00 00:00:00', 'AR', 'ARG', 32, 'SA', 'Argentina, Argentine Republic', 'Argentinien', 'South America', 'Südamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(11, '0000-00-00 00:00:00', 'AM', 'ARM', 51, 'AS', 'Armenia, Republic of', 'Armenien', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(12, '0000-00-00 00:00:00', 'AW', 'ABW', 533, 'NA', 'Aruba', 'Aruba', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(13, '0000-00-00 00:00:00', 'AU', 'AUS', 36, 'OC', 'Australia, Commonwealth of', 'Australien', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(14, '0000-00-00 00:00:00', 'AT', 'AUT', 40, 'EU', 'Austria, Republic of', 'Österreich', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(15, '0000-00-00 00:00:00', 'AZ', 'AZE', 31, 'AS', 'Azerbaijan, Republic of', 'Aserbaidschan', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(16, '0000-00-00 00:00:00', 'BS', 'BHS', 44, 'NA', 'Bahamas, Commonwealth of the', 'Bahamas', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(17, '0000-00-00 00:00:00', 'BH', 'BHR', 48, 'AS', 'Bahrain, Kingdom of', 'Bahrain', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(18, '0000-00-00 00:00:00', 'BD', 'BGD', 50, 'AS', 'Bangladesh, People''s Republic of', 'Bangladesch', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(19, '0000-00-00 00:00:00', 'BB', 'BRB', 52, 'NA', 'Barbados', 'Barbados', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(20, '0000-00-00 00:00:00', 'BY', 'BLR', 112, 'EU', 'Belarus, Republic of', 'Belarus', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(21, '0000-00-00 00:00:00', 'BE', 'BEL', 56, 'EU', 'Belgium, Kingdom of', 'Belgien', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(22, '0000-00-00 00:00:00', 'BZ', 'BLZ', 84, 'NA', 'Belize', 'Belize', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(23, '0000-00-00 00:00:00', 'BJ', 'BEN', 204, 'AF', 'Benin, Republic of', 'Benin', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(24, '0000-00-00 00:00:00', 'BM', 'BMU', 60, 'NA', 'Bermuda', 'Bermuda', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(25, '0000-00-00 00:00:00', 'BT', 'BTN', 64, 'AS', 'Bhutan, Kingdom of', 'Bhutan', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(26, '0000-00-00 00:00:00', 'BO', 'BOL', 68, 'SA', 'Bolivia, Republic of', 'Bolivien', 'South America', 'Südamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(27, '0000-00-00 00:00:00', 'BA', 'BIH', 70, 'EU', 'Bosnia and Herzegovina', 'Bosnien und Herzegowina', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(28, '0000-00-00 00:00:00', 'BW', 'BWA', 72, 'AF', 'Botswana, Republic of', 'Botsuana', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(29, '0000-00-00 00:00:00', 'BV', 'BVT', 74, 'AN', 'Bouvet Island (Bouvetoya)', 'Bouvet-Insel', 'Antarctica', 'Antarktis', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(30, '0000-00-00 00:00:00', 'BR', 'BRA', 76, 'SA', 'Brazil, Federative Republic of', 'Brasilien', 'South America', 'Südamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(31, '0000-00-00 00:00:00', 'IO', 'IOT', 86, 'AS', 'British Indian Ocean Territory (Chagos Archipelago)', 'Britisches Territorium Im Indischen Ozean', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(32, '0000-00-00 00:00:00', 'BN', 'BRN', 96, 'AS', 'Brunei Darussalam', 'Brunei Darussalam', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(33, '0000-00-00 00:00:00', 'BG', 'BGR', 100, 'EU', 'Bulgaria, Republic of', 'Bulgarien', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(34, '0000-00-00 00:00:00', 'BF', 'BFA', 854, 'AF', 'Burkina Faso', 'Burkina Faso', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(35, '0000-00-00 00:00:00', 'BI', 'BDI', 108, 'AF', 'Burundi, Republic of', 'Burundi', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(36, '0000-00-00 00:00:00', 'KH', 'KHM', 116, 'AS', 'Cambodia, Kingdom of', 'Kambodscha', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(37, '0000-00-00 00:00:00', 'CM', 'CMR', 120, 'AF', 'Cameroon, Republic of', 'Kamerun', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(38, '0000-00-00 00:00:00', 'CA', 'CAN', 124, 'NA', 'Canada', 'Kanada', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(39, '0000-00-00 00:00:00', 'CV', 'CPV', 132, 'AF', 'Cape Verde, Republic of', 'Kap Verde', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(40, '0000-00-00 00:00:00', 'KY', 'CYM', 136, 'NA', 'Cayman Islands', 'Kaimaninseln', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(41, '0000-00-00 00:00:00', 'CF', 'CAF', 140, 'AF', 'Central African Republic', 'Zentralafrikanische Republik', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(42, '0000-00-00 00:00:00', 'TD', 'TCD', 148, 'AF', 'Chad, Republic of', 'Tschad', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(43, '0000-00-00 00:00:00', 'CL', 'CHL', 152, 'SA', 'Chile, Republic of', 'Chile', 'South America', 'Südamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(44, '0000-00-00 00:00:00', 'CN', 'CHN', 156, 'AS', 'China, People''s Republic of', 'China', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(45, '0000-00-00 00:00:00', 'CX', 'CXR', 162, 'AS', 'Christmas Island', 'Weihnachtsinsel', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(46, '0000-00-00 00:00:00', 'CC', 'CCK', 166, 'AS', 'Cocos (Keeling) Islands', 'Kokosinseln (Keelingsinseln)', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(47, '0000-00-00 00:00:00', 'CO', 'COL', 170, 'SA', 'Colombia, Republic of', 'Kolumbien', 'South America', 'Südamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(48, '0000-00-00 00:00:00', 'KM', 'COM', 174, 'AF', 'Comoros, Union of the', 'Komoren', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(49, '0000-00-00 00:00:00', 'CG', 'COG', 178, 'AF', 'Congo, Republic of the', 'Kongo', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(50, '0000-00-00 00:00:00', 'CD', 'COD', 180, 'AF', 'Congo, Democratic Republic of the', 'Kongo, Demokratische Republik', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(51, '0000-00-00 00:00:00', 'CK', 'COK', 184, 'OC', 'Cook Islands', 'Cook-Inseln', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(52, '0000-00-00 00:00:00', 'CR', 'CRI', 188, 'NA', 'Costa Rica, Republic of', 'Costa Rica', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(53, '0000-00-00 00:00:00', 'CI', 'CIV', 384, 'AF', 'Cote d''Ivoire, Republic of', 'Côte D''Ivoire', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(54, '0000-00-00 00:00:00', 'HR', 'HRV', 191, 'EU', 'Croatia, Republic of', 'Kroatien', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(55, '0000-00-00 00:00:00', 'CU', 'CUB', 192, 'NA', 'Cuba, Republic of', 'Kuba', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(56, '0000-00-00 00:00:00', 'CY', 'CYP', 196, 'AS', 'Cyprus, Republic of', 'Zypern', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(57, '0000-00-00 00:00:00', 'CZ', 'CZE', 203, 'EU', 'Czech Republic', 'Tschechische Republik', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(58, '0000-00-00 00:00:00', 'DK', 'DNK', 208, 'EU', 'Denmark, Kingdom of', 'Dänemark', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(59, '0000-00-00 00:00:00', 'DJ', 'DJI', 262, 'AF', 'Djibouti, Republic of', 'Dschibuti', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(60, '0000-00-00 00:00:00', 'DM', 'DMA', 212, 'NA', 'Dominica, Commonwealth of', 'Dominica', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(61, '0000-00-00 00:00:00', 'DO', 'DOM', 214, 'NA', 'Dominican Republic', 'Dominikanische Republik', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(63, '0000-00-00 00:00:00', 'EC', 'ECU', 218, 'SA', 'Ecuador, Republic of', 'Ecuador', 'South America', 'Südamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(64, '0000-00-00 00:00:00', 'EG', 'EGY', 818, 'AF', 'Egypt, Arab Republic of', 'Ägypten', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(65, '0000-00-00 00:00:00', 'SV', 'SLV', 222, 'NA', 'El Salvador, Republic of', 'El Salvador', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(66, '0000-00-00 00:00:00', 'GQ', 'GNQ', 226, 'AF', 'Equatorial Guinea, Republic of', 'Äquatorialguinea', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(67, '0000-00-00 00:00:00', 'ER', 'ERI', 232, 'AF', 'Eritrea, State of', 'Eritrea', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(68, '0000-00-00 00:00:00', 'EE', 'EST', 233, 'EU', 'Estonia, Republic of', 'Estland', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(69, '0000-00-00 00:00:00', 'ET', 'ETH', 231, 'AF', 'Ethiopia, Federal Democratic Republic of', 'Äthiopien', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(70, '0000-00-00 00:00:00', 'FK', 'FLK', 238, 'SA', 'Falkland Islands (Malvinas)', 'Falkland-Inseln (Malvinen)', 'South America', 'Südamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(71, '0000-00-00 00:00:00', 'FO', 'FRO', 234, 'EU', 'Faroe Islands', 'Färöer', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(72, '0000-00-00 00:00:00', 'FJ', 'FJI', 242, 'OC', 'Fiji, Republic of the Fiji Islands', 'Fidschi', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(73, '0000-00-00 00:00:00', 'FI', 'FIN', 246, 'EU', 'Finland, Republic of', 'Finnland', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(74, '0000-00-00 00:00:00', 'FR', 'FRA', 250, 'EU', 'France, French Republic', 'Frankreich', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(75, '0000-00-00 00:00:00', 'GF', 'GUF', 254, 'SA', 'French Guiana', 'Französisch Guayana', 'South America', 'Südamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(76, '0000-00-00 00:00:00', 'PF', 'PYF', 258, 'OC', 'French Polynesia', 'Französisch Polynesien', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(77, '0000-00-00 00:00:00', 'TF', 'ATF', 260, 'AN', 'French Southern Territories', 'Französische Südgebiete', 'Antarctica', 'Antarktis', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(78, '0000-00-00 00:00:00', 'GA', 'GAB', 266, 'AF', 'Gabon, Gabonese Republic', 'Gabun', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(79, '0000-00-00 00:00:00', 'GM', 'GMB', 270, 'AF', 'Gambia, Republic of the', 'Gambia', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(80, '0000-00-00 00:00:00', 'GE', 'GEO', 268, 'AS', 'Georgia', 'Georgien', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(81, '0000-00-00 00:00:00', 'DE', 'DEU', 276, 'EU', 'Germany, Federal Republic of', 'Deutschland', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(82, '0000-00-00 00:00:00', 'GH', 'GHA', 288, 'AF', 'Ghana, Republic of', 'Ghana', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(83, '0000-00-00 00:00:00', 'GI', 'GIB', 292, 'EU', 'Gibraltar', 'Gibraltar', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(84, '0000-00-00 00:00:00', 'GR', 'GRC', 300, 'EU', 'Greece, Hellenic Republic', 'Griechenland', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(85, '0000-00-00 00:00:00', 'GL', 'GRL', 304, 'NA', 'Greenland', 'Grönland', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(86, '0000-00-00 00:00:00', 'GD', 'GRD', 308, 'NA', 'Grenada', 'Grenada', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(87, '0000-00-00 00:00:00', 'GP', 'GLP', 312, 'NA', 'Guadeloupe', 'Guadeloupe', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(88, '0000-00-00 00:00:00', 'GU', 'GUM', 316, 'OC', 'Guam', 'Guam', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(89, '0000-00-00 00:00:00', 'GT', 'GTM', 320, 'NA', 'Guatemala, Republic of', 'Guatemala', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(90, '0000-00-00 00:00:00', 'GN', 'GIN', 324, 'AF', 'Guinea, Republic of', 'Guinea', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(91, '0000-00-00 00:00:00', 'GW', 'GNB', 624, 'AF', 'Guinea-Bissau, Republic of', 'Guinea-Bissau', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(92, '0000-00-00 00:00:00', 'GY', 'GUY', 328, 'SA', 'Guyana, Co-operative Republic of', 'Guyana', 'South America', 'Südamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(93, '0000-00-00 00:00:00', 'HT', 'HTI', 332, 'NA', 'Haiti, Republic of', 'Haiti', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(94, '0000-00-00 00:00:00', 'HM', 'HMD', 334, 'AN', 'Heard Island and McDonald Islands', 'Heard und McDonald', 'Antarctica', 'Antarktis', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(95, '0000-00-00 00:00:00', 'VA', 'VAT', 336, 'EU', 'Holy See (Vatican City State)', 'Vatikanstadt, Staat (Heiliger Stuhl)', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(96, '0000-00-00 00:00:00', 'HN', 'HND', 340, 'NA', 'Honduras, Republic of', 'Honduras', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(97, '0000-00-00 00:00:00', 'HK', 'HKG', 344, 'AS', 'Hong Kong, Special Administrative Region of China', 'Hongkong', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(98, '0000-00-00 00:00:00', 'HU', 'HUN', 348, 'EU', 'Hungary, Republic of', 'Ungarn', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(99, '0000-00-00 00:00:00', 'IS', 'ISL', 352, 'EU', 'Iceland, Republic of', 'Island', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(100, '0000-00-00 00:00:00', 'IN', 'IND', 356, 'AS', 'India, Republic of', 'Indien', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(101, '0000-00-00 00:00:00', 'ID', 'IDN', 360, 'AS', 'Indonesia, Republic of', 'Indonesien', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(102, '0000-00-00 00:00:00', 'IR', 'IRN', 364, 'AS', 'Iran, Islamic Republic of', 'Iran (Islamische Republik)', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(103, '0000-00-00 00:00:00', 'IQ', 'IRQ', 368, 'AS', 'Iraq, Republic of', 'Irak', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(104, '0000-00-00 00:00:00', 'IE', 'IRL', 372, 'EU', 'Ireland', 'Irland', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(105, '0000-00-00 00:00:00', 'IL', 'ISR', 376, 'AS', 'Israel, State of', 'Israel', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(106, '0000-00-00 00:00:00', 'IT', 'ITA', 380, 'EU', 'Italy, Italian Republic', 'Italien', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(107, '0000-00-00 00:00:00', 'JM', 'JAM', 388, 'NA', 'Jamaica', 'Jamaika', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(108, '0000-00-00 00:00:00', 'JP', 'JPN', 392, 'AS', 'Japan', 'Japan', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(109, '0000-00-00 00:00:00', 'JO', 'JOR', 400, 'AS', 'Jordan, Hashemite Kingdom of', 'Jordanien', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(110, '0000-00-00 00:00:00', 'KZ', 'KAZ', 398, 'AS', 'Kazakhstan, Republic of', 'Kasachstan', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(111, '0000-00-00 00:00:00', 'KE', 'KEN', 404, 'AF', 'Kenya, Republic of', 'Kenia', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(112, '0000-00-00 00:00:00', 'KI', 'KIR', 296, 'OC', 'Kiribati, Republic of', 'Kiribati', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(113, '0000-00-00 00:00:00', 'KP', 'PRK', 408, 'AS', 'Korea, Democratic People''s Republic of', 'Korea, Demokratische Volksrepublik', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(114, '0000-00-00 00:00:00', 'KR', 'KOR', 410, 'AS', 'Korea, Republic of', 'Korea, Republik', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(115, '0000-00-00 00:00:00', 'KW', 'KWT', 414, 'AS', 'Kuwait, State of', 'Kuwait', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(116, '0000-00-00 00:00:00', 'KG', 'KGZ', 417, 'AS', 'Kyrgyz Republic', 'Kirgisistan', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(117, '0000-00-00 00:00:00', 'LA', 'LAO', 418, 'AS', 'Lao People''s Democratic Republic', 'Laos, Demokratische Volksrepublik', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(118, '0000-00-00 00:00:00', 'LV', 'LVA', 428, 'EU', 'Latvia, Republic of', 'Lettland', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(119, '0000-00-00 00:00:00', 'LB', 'LBN', 422, 'AS', 'Lebanon, Lebanese Republic', 'Libanon', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(120, '0000-00-00 00:00:00', 'LS', 'LSO', 426, 'AF', 'Lesotho, Kingdom of', 'Lesotho', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(121, '0000-00-00 00:00:00', 'LR', 'LBR', 430, 'AF', 'Liberia, Republic of', 'Liberia', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(122, '0000-00-00 00:00:00', 'LY', 'LBY', 434, 'AF', 'Libyan Arab Jamahiriya', 'Libysch-Arabische Dschamahirija', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(123, '0000-00-00 00:00:00', 'LI', 'LIE', 438, 'EU', 'Liechtenstein, Principality of', 'Liechtenstein', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(124, '0000-00-00 00:00:00', 'LT', 'LTU', 440, 'EU', 'Lithuania, Republic of', 'Litauen', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(125, '0000-00-00 00:00:00', 'LU', 'LUX', 442, 'EU', 'Luxembourg, Grand Duchy of', 'Luxembourg', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(126, '0000-00-00 00:00:00', 'MO', 'MAC', 446, 'AS', 'Macao, Special Administrative Region of China', 'Macau', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(127, '0000-00-00 00:00:00', 'MK', 'MKD', 807, 'EU', 'Macedonia, the former Yugoslav Republic of', 'Mazedonien, Ehemalige Jugoslawische Republik', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(128, '0000-00-00 00:00:00', 'MG', 'MDG', 450, 'AF', 'Madagascar, Republic of', 'Madagaskar', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(129, '0000-00-00 00:00:00', 'MW', 'MWI', 454, 'AF', 'Malawi, Republic of', 'Malawi', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(130, '0000-00-00 00:00:00', 'MY', 'MYS', 458, 'AS', 'Malaysia', 'Malaysia', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(131, '0000-00-00 00:00:00', 'MV', 'MDV', 462, 'AS', 'Maldives, Republic of', 'Malediven', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(132, '0000-00-00 00:00:00', 'ML', 'MLI', 466, 'AF', 'Mali, Republic of', 'Mali', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(133, '0000-00-00 00:00:00', 'MT', 'MLT', 470, 'EU', 'Malta, Republic of', 'Malta', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(134, '0000-00-00 00:00:00', 'MH', 'MHL', 584, 'OC', 'Marshall Islands, Republic of the', 'Marshallinseln', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(135, '0000-00-00 00:00:00', 'MQ', 'MTQ', 474, 'NA', 'Martinique', 'Martinique', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(136, '0000-00-00 00:00:00', 'MR', 'MRT', 478, 'AF', 'Mauritania, Islamic Republic of', 'Mauretanien', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(137, '0000-00-00 00:00:00', 'MU', 'MUS', 480, 'AF', 'Mauritius, Republic of', 'Mauritius', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(138, '0000-00-00 00:00:00', 'YT', 'MYT', 175, 'AF', 'Mayotte', 'Mayotte', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(139, '0000-00-00 00:00:00', 'MX', 'MEX', 484, 'NA', 'Mexico, United Mexican States', 'Mexiko', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(140, '0000-00-00 00:00:00', 'FM', 'FSM', 583, 'OC', 'Micronesia, Federated States of', 'Mikronesien, Föderierte Staaten Von', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(141, '0000-00-00 00:00:00', 'MD', 'MDA', 498, 'EU', 'Moldova, Republic of', 'Moldau, Republik', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(142, '0000-00-00 00:00:00', 'MC', 'MCO', 492, 'EU', 'Monaco, Principality of', 'Monaco', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(143, '0000-00-00 00:00:00', 'MN', 'MNG', 496, 'AS', 'Mongolia', 'Mongolei', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(144, '0000-00-00 00:00:00', 'MS', 'MSR', 500, 'NA', 'Montserrat', 'Montserrat', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(145, '0000-00-00 00:00:00', 'MA', 'MAR', 504, 'AF', 'Morocco, Kingdom of', 'Marokko', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(146, '0000-00-00 00:00:00', 'MZ', 'MOZ', 508, 'AF', 'Mozambique, Republic of', 'Mosambik', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(147, '0000-00-00 00:00:00', 'MM', 'MMR', 104, 'AS', 'Myanmar, Union of', 'Myanmar', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(148, '0000-00-00 00:00:00', 'NA', 'NAM', 516, 'AF', 'Namibia, Republic of', 'Namibia', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(149, '0000-00-00 00:00:00', 'NR', 'NRU', 520, 'OC', 'Nauru, Republic of', 'Nauru', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(150, '0000-00-00 00:00:00', 'NP', 'NPL', 524, 'AS', 'Nepal, State of', 'Nepal', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(151, '0000-00-00 00:00:00', 'NL', 'NLD', 528, 'EU', 'Netherlands, Kingdom of the', 'Niederlande', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(152, '0000-00-00 00:00:00', 'AN', 'ANT', 530, 'NA', 'Netherlands Antilles', 'Niederländische Antillen', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(153, '0000-00-00 00:00:00', 'NC', 'NCL', 540, 'OC', 'New Caledonia', 'Neukaledonien', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(154, '0000-00-00 00:00:00', 'NZ', 'NZL', 554, 'OC', 'New Zealand', 'Neuseeland', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(155, '0000-00-00 00:00:00', 'NI', 'NIC', 558, 'NA', 'Nicaragua, Republic of', 'Nicaragua', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(156, '0000-00-00 00:00:00', 'NE', 'NER', 562, 'AF', 'Niger, Republic of', 'Niger', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(157, '0000-00-00 00:00:00', 'NG', 'NGA', 566, 'AF', 'Nigeria, Federal Republic of', 'Nigeria', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(158, '0000-00-00 00:00:00', 'NU', 'NIU', 570, 'OC', 'Niue', 'Niue', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(159, '0000-00-00 00:00:00', 'NF', 'NFK', 574, 'OC', 'Norfolk Island', 'Norfolk-Insel', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(160, '0000-00-00 00:00:00', 'MP', 'MNP', 580, 'OC', 'Northern Mariana Islands, Commonwealth of the', 'Nördliche Marianen', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(161, '0000-00-00 00:00:00', 'NO', 'NOR', 578, 'EU', 'Norway, Kingdom of', 'Norwegen', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(162, '0000-00-00 00:00:00', 'OM', 'OMN', 512, 'AS', 'Oman, Sultanate of', 'Oman', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(163, '0000-00-00 00:00:00', 'PK', 'PAK', 586, 'AS', 'Pakistan, Islamic Republic of', 'Pakistan', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(164, '0000-00-00 00:00:00', 'PW', 'PLW', 585, 'OC', 'Palau, Republic of', 'Palau', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(165, '0000-00-00 00:00:00', 'PS', 'PSE', 275, 'AS', 'Palestinian Territory, Occupied', 'Palästina', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(166, '0000-00-00 00:00:00', 'PA', 'PAN', 591, 'NA', 'Panama, Republic of', 'Panama', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(167, '0000-00-00 00:00:00', 'PG', 'PNG', 598, 'OC', 'Papua New Guinea, Independent State of', 'Papua-Neuguinea', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(168, '0000-00-00 00:00:00', 'PY', 'PRY', 600, 'SA', 'Paraguay, Republic of', 'Paraguay', 'South America', 'Südamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(169, '0000-00-00 00:00:00', 'PE', 'PER', 604, 'SA', 'Peru, Republic of', 'Peru', 'South America', 'Südamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(170, '0000-00-00 00:00:00', 'PH', 'PHL', 608, 'AS', 'Philippines, Republic of the', 'Philippinen', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(171, '0000-00-00 00:00:00', 'PN', 'PCN', 612, 'OC', 'Pitcairn Islands', 'Pitcairn', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(172, '0000-00-00 00:00:00', 'PL', 'POL', 616, 'EU', 'Poland, Republic of', 'Polen', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(173, '0000-00-00 00:00:00', 'PT', 'PRT', 620, 'EU', 'Portugal, Portuguese Republic', 'Portugal', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(174, '0000-00-00 00:00:00', 'PR', 'PRI', 630, 'NA', 'Puerto Rico, Commonwealth of', 'Puerto Rico', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(175, '0000-00-00 00:00:00', 'QA', 'QAT', 634, 'AS', 'Qatar, State of', 'Katar', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(176, '0000-00-00 00:00:00', 'RE', 'REU', 638, 'AF', 'Reunion', 'Réunion', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(177, '0000-00-00 00:00:00', 'RO', 'ROU', 642, 'EU', 'Romania', 'Rumänien', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(178, '0000-00-00 00:00:00', 'RU', 'RUS', 643, 'EU', 'Russian Federation', 'Russische Föderation', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(179, '0000-00-00 00:00:00', 'RW', 'RWA', 646, 'AF', 'Rwanda, Republic of', 'Ruanda', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(180, '0000-00-00 00:00:00', 'SH', 'SHN', 654, 'AF', 'Saint Helena', 'St. Helena', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(181, '0000-00-00 00:00:00', 'KN', 'KNA', 659, 'NA', 'Saint Kitts and Nevis, Federation of', 'Saint Kitts und Nevis', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(182, '0000-00-00 00:00:00', 'LC', 'LCA', 662, 'NA', 'Saint Lucia', 'Santa Lucia', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(183, '0000-00-00 00:00:00', 'PM', 'SPM', 666, 'NA', 'Saint Pierre and Miquelon', 'Saint-Pierre und Miquelon', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(184, '0000-00-00 00:00:00', 'VC', 'VCT', 670, 'NA', 'Saint Vincent and the Grenadines', 'Saint Vincent und die Grenadinen', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(185, '0000-00-00 00:00:00', 'WS', 'WSM', 882, 'OC', 'Samoa, Independent State of', 'Samoa', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(186, '0000-00-00 00:00:00', 'SM', 'SMR', 674, 'EU', 'San Marino, Republic of', 'San Marino', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(187, '0000-00-00 00:00:00', 'ST', 'STP', 678, 'AF', 'Sao Tome and Principe, Democratic Republic of', 'São Tomé und Príncipe', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(188, '0000-00-00 00:00:00', 'SA', 'SAU', 682, 'AS', 'Saudi Arabia, Kingdom of', 'Saudi-Arabien', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(189, '0000-00-00 00:00:00', 'SN', 'SEN', 686, 'AF', 'Senegal, Republic of', 'Senegal', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(190, '0000-00-00 00:00:00', 'SC', 'SYC', 690, 'AF', 'Seychelles, Republic of', 'Seychellen', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(191, '0000-00-00 00:00:00', 'SL', 'SLE', 694, 'AF', 'Sierra Leone, Republic of', 'Sierra Leone', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(192, '0000-00-00 00:00:00', 'SG', 'SGP', 702, 'AS', 'Singapore, Republic of', 'Singapur', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(193, '0000-00-00 00:00:00', 'SK', 'SVK', 703, 'EU', 'Slovakia (Slovak Republic)', 'Slowakei (Slowakische Republik)', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(194, '0000-00-00 00:00:00', 'SI', 'SVN', 705, 'EU', 'Slovenia, Republic of', 'Slowenien', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(195, '0000-00-00 00:00:00', 'SB', 'SLB', 90, 'OC', 'Solomon Islands', 'Salomonen', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(196, '0000-00-00 00:00:00', 'SO', 'SOM', 706, 'AF', 'Somalia, Somali Republic', 'Somalia', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(197, '0000-00-00 00:00:00', 'ZA', 'ZAF', 710, 'AF', 'South Africa, Republic of', 'Südafrika', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(198, '0000-00-00 00:00:00', 'GS', 'SGS', 239, 'AN', 'South Georgia and the South Sandwich Islands', 'Südgeorgien und Südliche Sandwichinseln', 'Antarctica', 'Antarktis', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(199, '0000-00-00 00:00:00', 'ES', 'ESP', 724, 'EU', 'Spain, Kingdom of', 'Spanien', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(200, '0000-00-00 00:00:00', 'LK', 'LKA', 144, 'AS', 'Sri Lanka, Democratic Socialist Republic of', 'Sri Lanka', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(201, '0000-00-00 00:00:00', 'SD', 'SDN', 736, 'AF', 'Sudan, Republic of', 'Sudan', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(202, '0000-00-00 00:00:00', 'SR', 'SUR', 740, 'AF', 'Suriname, Republic of', 'Suriname', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(203, '0000-00-00 00:00:00', 'SJ', 'SJM', 744, 'EU', 'Svalbard & Jan Mayen Islands', 'Svalbard und Jan Mayen', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(204, '0000-00-00 00:00:00', 'SZ', 'SWZ', 748, 'AF', 'Swaziland, Kingdom of', 'Swasiland', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(205, '0000-00-00 00:00:00', 'SE', 'SWE', 752, 'EU', 'Sweden, Kingdom of', 'Schweden', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(206, '0000-00-00 00:00:00', 'CH', 'CHE', 756, 'EU', 'Switzerland, Swiss Confederation', 'Schweiz', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(207, '0000-00-00 00:00:00', 'SY', 'SYR', 760, 'AS', 'Syrian Arab Republic', 'Syrien, Arabische Republik', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(208, '0000-00-00 00:00:00', 'TW', 'TWN', 158, 'AS', 'Taiwan', 'Taiwan (China)', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(209, '0000-00-00 00:00:00', 'TJ', 'TJK', 762, 'AS', 'Tajikistan, Republic of', 'Tadschikistan', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(210, '0000-00-00 00:00:00', 'TZ', 'TZA', 834, 'AF', 'Tanzania, United Republic of', 'Tansania, Vereinigte Republik', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(211, '0000-00-00 00:00:00', 'TH', 'THA', 764, 'AS', 'Thailand, Kingdom of', 'Thailand', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(212, '0000-00-00 00:00:00', 'TG', 'TGO', 768, 'AF', 'Togo, Togolese Republic', 'Togo', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(213, '0000-00-00 00:00:00', 'TK', 'TKL', 772, 'OC', 'Tokelau', 'Tokelau', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(214, '0000-00-00 00:00:00', 'TO', 'TON', 776, 'OC', 'Tonga, Kingdom of', 'Tonga', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(215, '0000-00-00 00:00:00', 'TT', 'TTO', 780, 'NA', 'Trinidad and Tobago, Republic of', 'Trinidad und Tobago', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(216, '0000-00-00 00:00:00', 'TN', 'TUN', 788, 'AF', 'Tunisia, Tunisian Republic', 'Tunesien', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(217, '0000-00-00 00:00:00', 'TR', 'TUR', 792, 'AS', 'Turkey, Republic of', 'Türkei', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(218, '0000-00-00 00:00:00', 'TM', 'TKM', 795, 'AS', 'Turkmenistan', 'Turkmenistan', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(219, '0000-00-00 00:00:00', 'TC', 'TCA', 796, 'NA', 'Turks and Caicos Islands', 'Turks- und Caicosinseln', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(220, '0000-00-00 00:00:00', 'TV', 'TUV', 798, 'OC', 'Tuvalu', 'Tuvalu', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(221, '0000-00-00 00:00:00', 'UG', 'UGA', 800, 'AF', 'Uganda, Republic of', 'Uganda', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(222, '0000-00-00 00:00:00', 'UA', 'UKR', 804, 'EU', 'Ukraine', 'Ukraine', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(223, '0000-00-00 00:00:00', 'AE', 'ARE', 784, 'AS', 'United Arab Emirates', 'Vereinigte Arabische Emirate', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(224, '0000-00-00 00:00:00', 'GB', 'GBR', 826, 'EU', 'United Kingdom of Great Britain & Northern Ireland', 'United Kingdom', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(225, '0000-00-00 00:00:00', 'US', 'USA', 840, 'NA', 'United States of America', 'Vereinigte Staaten', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(226, '0000-00-00 00:00:00', 'UM', 'UMI', 581, 'OC', 'United States Minor Outlying Islands', 'Kleinere entlegene Inseln der Vereinigten Staaten', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(227, '0000-00-00 00:00:00', 'UY', 'URY', 858, 'SA', 'Uruguay, Eastern Republic of', 'Uruguay', 'South America', 'Südamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(228, '0000-00-00 00:00:00', 'UZ', 'UZB', 860, 'AS', 'Uzbekistan, Republic of', 'Usbekistan', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(229, '0000-00-00 00:00:00', 'VU', 'VUT', 548, 'OC', 'Vanuatu, Republic of', 'Vanuatu', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(230, '0000-00-00 00:00:00', 'VE', 'VEN', 862, 'SA', 'Venezuela, Bolivarian Republic of', 'Venezuela', 'South America', 'Südamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(231, '0000-00-00 00:00:00', 'VN', 'VNM', 704, 'AS', 'Vietnam, Socialist Republic of', 'Vietnam', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(232, '0000-00-00 00:00:00', 'VG', 'VGB', 92, 'NA', 'British Virgin Islands', 'Jungferninseln (Britische)', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(233, '0000-00-00 00:00:00', 'VI', 'VIR', 850, 'NA', 'United States Virgin Islands', 'Jungferninseln (Amerikanische)', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(234, '0000-00-00 00:00:00', 'WF', 'WLF', 876, 'OC', 'Wallis and Futuna', 'Wallis und Futuna', 'Oceania', 'Ozeanien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(235, '0000-00-00 00:00:00', 'EH', 'ESH', 732, 'AF', 'Western Sahara', 'Westsahara', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(236, '0000-00-00 00:00:00', 'YE', 'YEM', 887, 'AS', 'Yemen', 'Jemen', 'Asia', 'Asien', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(237, '0000-00-00 00:00:00', 'YU', 'YUG', 891, 'EU', 'Yugoslavia', 'Jugoslawien', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(238, '0000-00-00 00:00:00', 'ZM', 'ZMB', 894, 'AF', 'Zambia, Republic of', 'Sambia', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(239, '0000-00-00 00:00:00', 'ZW', 'ZWE', 716, 'AF', 'Zimbabwe, Republic of', 'Simbabwe', 'Africa', 'Afrika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(240, '0000-00-00 00:00:00', 'AX', 'ALA', 248, 'EU', 'Åland Islands', 'Åland Inseln', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(241, '0000-00-00 00:00:00', 'GG', 'GGY', 831, 'EU', 'Guernsey, Bailiwick of', 'Guernsey, Vogtei', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(242, '0000-00-00 00:00:00', 'IM', 'IMN', 833, 'EU', 'Isle of Man', 'Insel Man', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(243, '0000-00-00 00:00:00', 'JE', 'JEY', 832, 'EU', 'Jersey, Bailiwick of', 'Jersey, Vogtei', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(244, '0000-00-00 00:00:00', 'ME', 'MNE', 499, 'EU', 'Montenegro, Republic of', 'Montenegro', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(245, '0000-00-00 00:00:00', 'BL', 'BLM', 652, 'NA', 'Saint Barthelemy', 'Sankt Bartholomäus', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(246, '0000-00-00 00:00:00', 'MF', 'MAF', 663, 'NA', 'Saint Martin', 'Saint-Martin', 'North America', 'Nordamerika', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(247, '0000-00-00 00:00:00', 'RS', 'SRB', 688, 'EU', 'Serbia, Republic of', 'Serbien', 'Europe', 'Europa', '', '');
ERROR: Column count doesn't match value count at row 1 -> INSERT INTO `phpwcms_country` VALUES(248, '0000-00-00 00:00:00', 'TL', 'TLS', 626, 'AS', 'Timor-Leste, Democratic Republic of', 'Osttimor (Timor-Leste)', 'Asia', 'Asien', '', '');
ERROR: Duplicate column name 'f_gallerystatus' -> ALTER TABLE `phpwcms_file` ADD `f_gallerystatus` INT( 1 ) NOT NULL DEFAULT '0';
ERROR: Duplicate column name 'fcat_sort' -> ALTER TABLE `phpwcms_filecat` ADD `fcat_sort` INT( 11 ) NOT NULL DEFAULT '0';
ERROR: Duplicate column name 'fkey_sort' -> ALTER TABLE `phpwcms_filekey` ADD `fkey_sort` INT( 11 ) NOT NULL DEFAULT '0';
ERROR: Duplicate column name 'f_vars' -> ALTER TABLE `phpwcms_file` ADD `f_vars` BLOB NOT NULL;
Does anyone know how to fix this?
Don Bledsoe
FOREFRONT INTERNET

User avatar
forefront
Posts: 96
Joined: Sun 16. May 2004, 14:13
Location: Cherryvale, KS • USA
Contact:

Re: Upgrade 1.2.5-DEV to 1.4.1 database upgrade error

Post by forefront » Fri 8. May 2009, 05:16

I do not know if this is related or not ...

After logging in to the backend, I looked around ... in MODULES --> Glossary, this error was displayed:

Code: Select all

Warning: Invalid argument supplied for foreach() in /home/username/public_html/wcms/include/inc_module/mod_glossary/backend.listing.php on line 205
This is the only error that is apparent, but I've not tried to edit any entries yet. Considering this is a very big upgrade, I think it's going VERY well.
Don Bledsoe
FOREFRONT INTERNET

User avatar
juergen
Moderator
Posts: 4549
Joined: Mon 10. Jan 2005, 18:10
Location: Weinheim
Contact:

Re: Upgrade 1.2.5-DEV to 1.4.1 database upgrade error

Post by juergen » Fri 8. May 2009, 06:01

Hi

For me this looks like you missed one of the early updates ... you are shure abt the 1.2.5 ? As far as I remenber this one was a kind of quicky, only for a short while.
With having your backups save.... -> restart at Vers. 1.2.1 update, perhaps that helps.

User avatar
forefront
Posts: 96
Joined: Sun 16. May 2004, 14:13
Location: Cherryvale, KS • USA
Contact:

Re: Upgrade 1.2.5-DEV to 1.4.1 database upgrade error

Post by forefront » Fri 8. May 2009, 13:18

I ran the queries again, starting with 1.2.1, but the changes have already been made as I get a "duplicate column" error.

I checked with phpMyAdmin ... country table exists but is empty and contains the following fields:

Code: Select all

country_id
country_updated
country_iso
country_iso3
country_isonum
country_continentcode
country_name
country_continent
country_continent_de
country_region
country_region_de
I checked every table and found several with duplicate indexes, probably because some queries ran more than once. I deleted the duplicate indexes.

It appears that the inserts contain 12 fields, while the table contains only 11 fields. I would guess that there's an ALTER or CREATE query for phpwcms_country that is incorrect or failed for some reason. Do you know when that occurred?
Don Bledsoe
FOREFRONT INTERNET

User avatar
forefront
Posts: 96
Joined: Sun 16. May 2004, 14:13
Location: Cherryvale, KS • USA
Contact:

Re: Upgrade 1.2.5-DEV to 1.4.1 database upgrade error

Post by forefront » Fri 8. May 2009, 13:47

I found where the phpwcms_country table was created: 07_27-08-2005_to_1.2.7.sql and since the table was empty, I recreated it. Then, in database upgrade 1.3.5 to 1.5, I ran the queries there and it ran successfully ... BUT ... while there is data in the INSERT statements, no data is in the table for the following fields:

country_iso3
country_isonum
country_continentcode

What I should have is the entries in the INSERT statements, but that's not happening. Does anyone have a suggestion as to what I should do next?
Don Bledsoe
FOREFRONT INTERNET

User avatar
forefront
Posts: 96
Joined: Sun 16. May 2004, 14:13
Location: Cherryvale, KS • USA
Contact:

Re: Upgrade 1.2.5-DEV to 1.4.1 database upgrade error

Post by forefront » Fri 8. May 2009, 23:42

This is fixed ... dumb me. The first CREATE TABLE query has different fields ... data was inserted and then the table was altered to a new structure. So ... I ran a TRUNCATE TABLE and then ran the INSERT query again and it was successful.

This problem is corrected but the MODULE --> Glossary problem remains.
Don Bledsoe
FOREFRONT INTERNET

User avatar
juergen
Moderator
Posts: 4549
Joined: Mon 10. Jan 2005, 18:10
Location: Weinheim
Contact:

Re: Upgrade 1.2.5-DEV to 1.4.1 database upgrade error

Post by juergen » Mon 11. May 2009, 12:56

So anyhow, do you need the Glossary at all ?

If not: delete /include/inc_module/mod_glossary with all its subdirs

and everything will be fine !

User avatar
forefront
Posts: 96
Joined: Sun 16. May 2004, 14:13
Location: Cherryvale, KS • USA
Contact:

Re: Upgrade 1.2.5-DEV to 1.4.1 database upgrade error

Post by forefront » Mon 11. May 2009, 13:10

In Upgrade 1.3.2 I found the glossary CREATE TABLE script ... I also found I had several other tables missing and added those. I think I'm okay now.
Don Bledsoe
FOREFRONT INTERNET

Post Reply