Update-Probleme... [1.1-RC3 -> 1.3.3]

[Spacey]

Hallo Forum!

Habe hier eine alte 1.1-RC3 Installation welche ich umziehen möchte. Erstes Problem: Auf dem alten Server lief php4 und alles war wunderbar. Auf dem neuen läuft nur noch php5 - und das gab einen schönen Fehler ala "...unexpected T_PUBLIC...". Habe rausgefunden, dass das wohl ein php4<->php5 Problem ist.

Gut, die 1.1-RC3 ist eh sau alt, könnte man ja mal updaten. Habe mir also die 1.3.3 gezogen (von der Beta 1.4 mal abgesehen) und nach dieser Anleitung geupdatet - mehr oder weniger.

Mir war hierbei z.B. nicht klar, wieso ist alle Content-Bilder löschen soll..

Code: Select all

Löschen Sie bitte auch noch den Inhalt folgender Ordner
content/images
content/gt (seit 1.1-RC4 03.06.2004)
content/rss (seit Version 1.1.5)

weil diese dann ja weg wären - oder?!

Bei den div sql-Updates gab es auch immer wieder mal Rote Fehler...

Aber soweit so gut: Nun sehe ich nach den Updates mein CMS - mehr oder weniger. Alle Content Bilder sind weiße durchgekreuzte Kästchen. Liegt das evtl. daran, das ich sie nicht gelöscht habe? Wäre aber alles nicht sehr logisch...

Des weiteren ist meine alte Navigation (selbst customizetes Layout) wieder Standard. Die conf.template_default.inc.php hat sich auch gut verändert - früher waren überall "'s und jetzt sind 's dabei - ein simpler Austausch brachte hier nicht viel - nun habe ich Pfadangaben in der Darstellung anstatt der Bilder.

Die CSS's sind auch alle weg... Umlaut-Probleme...

Ich denke da ist irgendwo gewaltig generell der Wurm drinnen. Habe ich einen allgemeinen Denk- Update-Fehler gemacht - oder etwas übersehen oder falsch gemacht? Gibt es andere Update-Schritte für meine alte Version? Irgendwie gleich das hier einem fast komplett neu aufsetzen....

*seufz*

[flip-flop]

Hallo,

ein Update von einer 1.1-RC3 ist nicht ganz so einfach, da hier noch teilweise eine andere Dateienstruktur angelegt war.

Ich würde eine 1.4.1 installieren. (ist definitiv stabil).

Die Bilder in /content/images/* werden vom System autom. neu genereriert wenn diese vorher gelöscht wurden. Die Originale liegen immer noch im Ordner /filearchive/*

- Datenbank kopieren
- DB-Updates machen und auf Fehler achten (auch nach unten rollen im Ausgabefenster)
Wenn Fehler auftauchen in phpMyAdmin nachsehen ob alle Tabellen angelegt worden sind).
Fehler müssen auf jeden Fall korrigiert werden, sonst geht es im Nachhinein schief.
Nach dem letzten DB-Update: Mit phpMyAdmin nachsehen ob doppelte Indizes produziert worden sind. -> Doppelte löschen.

- Charset: Du musst schauen mit welchem Charset die alte Seite gelaufen ist. Dazu gehört auch die DB-Kollation und das DB-Charset.
Es wird wahrscheinlich auch eine MySQL 5 DB laufen, hier wird zwingend eine Kollation verlangt und die sollte stimmen.
Schauen in der alten DB nach, mit welcher Collation/Charset diese lief. Wenn das nicht zu erkennen ist war es mit 99% Wahrscheinlichkeit swedish_latin1_ci und latin1.

Die Updatebeschreibung ist eigentlich recht gut und funktioniert auch.
Es sollte jeder Schritt überprüft werden, auch das kopieren der Dateien (FTP-Prgramm).

Hier eine Updateanleitung für neuere Version auf der Basis einer parallelen Installation. http://forum.phpwcms.org/viewtopic.php?p=109508#p109508

Knut

[Spacey]

Hallo Knut,

vielen Dank für Deine Antwort(en)!

Ich habe jetzt noch mal von vorne das Update angefangen - habe das File 305 genommen - keine Ahnung ob das die 1.4.1 ist - ist irgendwie nicht sonderlich ersichtlich.

Habe das Bild-Problem gelöst - habe es entsprechend der Anleitung aus dem Content gelöscht - super.

Die Datenbank-Updates habe ich durchgerattert. Folgende Fehler haben sich ergeben - die Nummern geben den jeweiligen Update-Schritt an:

Code: Select all

1)
ERROR: Duplicate column name 'acat_topcount' -> ALTER TABLE `phpwcms_articlecat` ADD `acat_topcount` INT NOT NULL;
ERROR: Table 'phpwcms_guestbook' already exists -> CREATE TABLE `phpwcms_guestbook` (
ERROR: Duplicate column name 'acat_ssl' -> ALTER TABLE `phpwcms_articlecat` ADD `acat_ssl` INT( 1 ) NOT NULL;
ERROR: Duplicate column name 'acat_regonly' -> ALTER TABLE `phpwcms_articlecat` ADD `acat_regonly` INT( 1 ) NOT NULL;
ERROR: Duplicate column name 'article_notitle' -> ALTER TABLE `phpwcms_article` ADD `article_notitle` INT( 1 ) NOT NULL;
ERROR: Unknown column 'newsletter_name' in 'phpwcms_newsletter' -> ALTER TABLE `phpwcms_newsletter` CHANGE `newsletter_name` `newsletter_name` TEXT NOT NULL;
ERROR: Table 'phpwcms_blog' already exists -> CREATE TABLE `phpwcms_blog` (



8)
ERROR: Unknown column 'cache_timeout' in 'phpwcms_cache' -> ALTER TABLE `phpwcms_cache` ADD `cache_isprint` INT( 1 ) NOT NULL AFTER `cache_timeout`;
ERROR: Table 'holgersql1.phpwcms_forum' doesn't exist -> ALTER TABLE `phpwcms_forum` ADD `forum_ctopic` INT NOT NULL AFTER `forum_uid`;
ERROR: Table 'holgersql1.phpwcms_forum' doesn't exist -> ALTER TABLE `phpwcms_forum` ADD `forum_cpost` INT NOT NULL AFTER `forum_ctopic`;
ERROR: Table 'holgersql1.phpwcms_forum' doesn't exist -> ALTER TABLE `phpwcms_forum` ADD `forum_lastpost` MEDIUMTEXT NOT NULL;


10)
ERROR: Duplicate column name 'article_nositemap' -> ALTER TABLE `phpwcms_article` ADD `article_nositemap` INT( 1 ) DEFAULT '1' NOT NULL;
ERROR: Duplicate column name 'acat_nositemap' -> ALTER TABLE `phpwcms_articlecat` ADD `acat_nositemap` INT( 1 ) DEFAULT '1' NOT NULL;


13)
ERROR: Table 'holgersql1.phpwcms_usergroup' doesn't exist -> ALTER TABLE `phpwcms_usergroup` ADD `group_name` VARCHAR( 200 ) NOT NULL AFTER `group_id`;
ERROR: Table 'holgersql1.phpwcms_usergroup' doesn't exist -> ALTER TABLE `phpwcms_usergroup` ADD `group_member` MEDIUMTEXT NOT NULL AFTER `group_name`;
ERROR: Table 'holgersql1.phpwcms_usergroup' doesn't exist -> ALTER TABLE `phpwcms_usergroup` ADD `group_timestamp` TIMESTAMP NOT NULL;
ERROR: Table 'holgersql1.phpwcms_usergroup' doesn't exist -> ALTER TABLE `phpwcms_usergroup` ADD `group_trash` INT( 1 ) NOT NULL;
ERROR: Table 'holgersql1.phpwcms_usergroup' doesn't exist -> ALTER TABLE `phpwcms_usergroup` ADD `group_active` INT( 1 ) NOT NULL;

20)
ERROR: Can't DROP 'acat_alias'; check that column/key exists -> ALTER TABLE `phpwcms_articlecat` DROP INDEX `acat_alias`;


21)
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', '', '');

Nun kann *ich* nicht einschätzen, in wie fern diese Fehler übersehbar oder wichtig sind. Kurze Ideen dazu?

Alte DB:

MySQL-Zeichensatz: UTF-8 Unicode (utf8)
chensatz / Kollation der MySQL-Verbindung: UTF8_general_ci
Die ganzen Tables waren latin1_swedish_ci

Neue DB:
MySQL-Zeichensatz: UTF-8 Unicode (utf8)
Zeichensatz / Kollation der MySQL-Verbindung: UTF8_unicode_ci
Die ganzen Tables sind latin1_swedish_ci

Apache selbst ist auch korrekt konfiguriert vom Charset her.

Abgesehen von den Umlauten & den Fehler oben stimmt mein CSS nach dem Upgrade nicht: Die Schriftarten, Bildabstände und überhaupt die ganze Navigation ist hinüber (standard). Leider weiss ich nicht mehr genau wo ich die alten CSS finde geschweige denn wo ich das in der neuen Version pflegen muss... kurzer Tip hier?! Alternativ suche ich natürlich selbst (wie'n Bär) *g*

Merci!

[Spacey]

Nachtrag:

Habe das mit der Navigation & dem Aussehen halbwegs hinbekommen. Lediglich die Zeilenabstände sind noch nicht ganz stimmig.

Was halt noch Futsch ist, sind die Umlaute in den Artikeln und im CMS selbst... im Titel stimmt er jedoch...

Was auch noch nicht ganz hinhaut: .htaccess - früher hiessen die Seiten schick blafasel.shtml - das geht derzeit nicht - heisst alles index.php?homepage & Co....

[flip-flop]

Weshalb die r305? Die r307 ist aktuell. -> http://www.phpwcms-docu.de/download-dev-versionen.phtml

MySQL-Zeichensatz und Kollation des phpMyAdmin sind nicht die in der DB, sondern nur die Verbindung des Programms phpMyAdmin zur DB.

Also deine DB hat den charset latin1 und die collation latin1_swedish_ci.
Das muss auch in deiner config.inc.php eingstellt werden.
Bsp.:

Code: Select all

$phpwcms['db_charset']        = 'latin1';  // utf8
$phpwcms['db_collation']      = 'latin1_swedish_ci'; // utf8_general_ci
$phpwcms['db_version']        = 40120;

(Hier mit einer DB der Version 40120 (In phpMyAdmin ablesbar)).

charset der Seite wäre dann

Code: Select all

$phpwcms['charset']           = 'ISO-8859-1';       //default charset 'iso-8859-1'

CSS-Dateien liegen in /template/inc_css/ und müssen u.U. in deiner Vorlage neu eingebunden werden.
Du musst einige Dateien der alten Version mit der neuen Version abgleichen.

/config/phpwcms/conf.inc.php
/config/phpwcms/conf.template_default.inc.php
/template/inc_css/frontend.css

DB-Update:
ERROR: Table 'holgersql1.phpwcms_forum' doesn't exist -> ALTER TABLE `phpwcms_forum` ADD `forum_ctopic` INT NOT NULL AFTER `forum_uid`;

Bevor wir hier weitermachen, nutzt du ein prepend "holgersql1" in $phpwcms["db_prepend"]?

shtml: Du verwendest Server Side Includes (SSI) auf dem Account

[Spacey]

Weshalb die r305? Die r307 ist aktuell. -> http://www.phpwcms-docu.de/download-dev-versionen.phtml

Ehrm.. sind das alles Versionen von 1.4.1?! Sorry - das ist nicht ganz ersichtlich...

Das muss auch in deiner config.inc.php eingstellt werden.
Bsp.:

Code: Select all

$phpwcms['db_charset']        = 'latin1';  // utf8
$phpwcms['db_collation']      = 'latin1_swedish_ci'; // utf8_general_ci
$phpwcms['db_version']        = 40120;

(Hier mit einer DB der Version 40120 (In phpMyAdmin ablesbar)).

charset der Seite wäre dann

Code: Select all

$phpwcms['charset']           = 'ISO-8859-1';       //default charset 'iso-8859-1'

Habe ich genau so eingestellt - aber um Umlaute im CMS sind noch mau...
Wenn ich das Charset auf utf8 stelle, sind die Umlaute im CMS gut - aber im Header futsch...

db_version ist die Server-Version, oder?! Bei mir währe das "5.0.32-Debian_7etch8-log" -> 5032 dann - oder?!

CSS-Dateien liegen in /template/inc_css/ und müssen u.U. in deiner Vorlage neu eingebunden werden.
Du musst einige Dateien der alten Version mit der neuen Version abgleichen.

/config/phpwcms/conf.inc.php
/config/phpwcms/conf.template_default.inc.php
/template/inc_css/frontend.css

Hat sich anscheinend soweit geklärt.... sieht recht gut aus bis auf ein paar Details...

DB-Update:
ERROR: Table 'holgersql1.phpwcms_forum' doesn't exist -> ALTER TABLE `phpwcms_forum` ADD `forum_ctopic` INT NOT NULL AFTER `forum_uid`;

Bevor wir hier weitermachen, nutzt du ein prepend "holgersql1" in $phpwcms["db_prepend"]?

Nein, kein prepend... auch keine Ahnung, wieso der Fehler so kam... evtl. ein Bug im sql Update Script?! Bei allen anderen Update-Scripten gab es keinen solchen Fehler... die, die ich gepostet habe waren die einzigen. holgersql1 heisst die Datenbank - und phpwcms_forum existiert aber...

shtml: Du verwendest Server Side Includes (SSI) auf dem Account

Ehrm nein... aber bei dem 1.1 RC3'er CMS lief alles über diese homepage.shtml - blafasel.shtml Seiten... also rewrite hat das entsprechend angestellt... habe ich nicht besonders konfiguriert... und es ist insg. ein eigener Rootie - kann auf der Maschine also machen was ist will - wenn Dein Erstaunen in diese Richtung gehen sollte

Dann noch eine Frage:
Meine CSS schlagen noch nicht ganz durch. Was mir aufgefallen ist: Ich habe im Head einer jeden Seite Folgendes:

Code: Select all

  <style type="text/css" media="all">
  <!-- 
    body {
      background-color: #ffffff;
      color: #ffffff;
    }
    a, a:link, a:active, a:visited, a:hover { color: #FF9900; }
    a:visited { color: #FF9900; }
    a:active { color: #FF9900; }
  //-->
  </style>

Das hatte ich früher nicht. Wo kommt das her und wie kann ich es abstellen? Das wird bei mir alles über die CSS geregelt...

[juergen]

Hier kommt die Erklärung für : holgersql1:

Typische Bezeichnung für den DB Namen, wenn der Server zB unter syscp läuft. Will sagen: Du hast irgendwo bei Prepend versehentlich den Namen der DB oder den Nutzer (zumeist identisch) eingetragen.

Und ? Richtig geraten ?

[Spacey]

syscp wird genutzt - dort sind db_user und db_table identisch. Das sollte aber keine Probleme bringen - zumindest hat's das noch nirgends... und bei db_prepend steht definitiv nix - ansonsten hätte es schon vorher beim Update wesentlich mehr Probleme gegeben weil er keinen einzigen Table richtig gefunden hat, vermute ich... und es gibt doch auch nur eine Stelle in der Config, wo man prepend eingeben kann, oder?

Code: Select all

$phpwcms['db_host']           = 'localhost';
$phpwcms['db_user']           = 'holgersql1';
$phpwcms['db_pass']           = '***************';
$phpwcms['db_table']          = 'holgersql1';
$phpwcms['db_prepend']        = '';
$phpwcms['db_pers']           = 1;
$phpwcms['db_charset']        = 'latin1';
$phpwcms['db_collation']      = 'latin1_swedish_ci';
$phpwcms['db_version']        = 5032;

[juergen]

Wenn es nicht der prepend ist, musst mal überlegen wieso er user.tabelle abarbeitet

//Edit: Oder mach dir eben einen echten Sql User und lass den das Upgrade vonHand machen, womöglich ist es ein Rechte Problem ?

[juergen]

kann auf der Maschine also machen was ist will - wenn Dein Erstaunen in diese Richtung gehen sollte

Ich hoffe sehr dass du wenigstens sichergestellt hast, dass auch nur du auf der Kiste machen kannst was du willst. syscp hat 1.4.2, alles davor hat Löcher..

[Spacey]

Ich hoffe sehr dass du wenigstens sichergestellt hast, dass auch nur du auf der Kiste machen kannst was du willst. syscp hat 1.4.2, alles davor hat Löcher..

All diese kritischen Sachen (syscp, webmail, phpmyadmin etc.) sind sowieso per .htaccess & .htpasswd geschützt - da kommt keiner ohne Passwort ran..

[Spacey]

shtml: Du verwendest Server Side Includes (SSI) auf dem Account

Noch mal hierzu:

Bei dem .htaccess File hiess es in der 1.1'er .shtml - heute (oder ab 1.2?!) heisst es nun .phtml - damit die URLs nicht mehr index.php?homepage etc. heissen.

Ich habe gerade ein weiteres (älteres, aber nicht ganz so altes wie das 1.1er) umgezogen - dort heisst's .phtml - und dort klappt es nach dem Umzug auch bestens.

Muss ich abgesehen von der .htaccess noch im CMS evtl. etwas einstellen, damit diese anderen URL's verwendet werden?

Wenn ich die URLs manuell mit shtml eingebe, dann funktioniert es - das .htaccess scheint also zu greifen. Lediglich das CMS selbst erstellt mir die Links in der Navigation nicht mehr so - früher hat es das getan?! Oder kommt sich da jetzt das phtml der aktuellen Version mit dem shtml von früher in die Quere?!

[flip-flop]

In der conf.inc.php:

Code: Select all

$phpwcms['rewrite_url']       = 1;  //whether URL should be rewritable

[Spacey]

In der conf.inc.php:

Code: Select all

$phpwcms['rewrite_url']       = 1;  //whether URL should be rewritable

perfetto Merci!