1 - I added "livingcountry" column to user's table; however, it shows as "Unknown Tag 'livingcountry'" when I add <%livingcountry%> to signup_form.html template????!!!
2 - The livingcountry is a drop-down selection menu, I added country names in it; however, I can not ReSync the user's table as I get the following error (debugger is enabled):
A fatal error has occured:
Please enable debugging in setup for more details.Stack Trace ====================================== Links (6635): Links::environment called at /home/www/mydomain/cgi-bin/links/admin/Links.pm line 712 with no arguments. Links (6635): Links::fatal called at GT::Base::error line 378 with arguments (GT::SQL::Creator (6635): enum('Afghanistan','Albania','Algeria','AmericanSamoa','Andorra','Angola','Anguilla','Antarctica','Antigua and Barbuda','Argentina','Argentina (Buenos Aires)','Armenia','Aruba','Ascension Islands','Australia','Austria','Azerbaijan','Bahamas, The','Bahrain','Bangladesh','Bangladesh (Chittagong)','Bangladesh (Dhaka)','Barbados','Belarus','Belgium','Belize','Benin, Republic Of','Bermuda','Bhutan','Bolivia','Bolivia (La Paz)','Bosnia-Herzegovina','Botswana','Brazil','Brazil (Rio Dejanero)','Brazil (Rio-Janeiro)','Brazil (Sao Paulo)','British Virgin Islands','Brunei','Bulgaria','urkina Faso','Burundi','Cambodia','Cameroon','Canada','Cape Verde Island','Cayman Islands','Central African Republic','Chad Republic','Chile','China','Christmas And Cocos Islands','Colombia','Colombia (Bogota)','Colombia (Cali)','Colombia (Medellin)','Comoros Federal And Islamic Republic Of','Congo','Cook Islands','Costa Rica','Croatia','Cuba','Cyprus','Czech Republic','Denmark','Diego Garcia','Djibouti','Dominica','Dominican Republic','Ecuador','Egypt','Egypt (Cairo)','El Salvador','Equatorial Guinea','Eritrea','Estonia','Ethiopia','Faeroe Islands','Fiji Islands','Finland','France','French Antilles (Martinique)','French Guiana','French Polynesia','Gabon Republic','GambiaGeorgia','GermanyGhana','Ghana (Accra)','Gibraltar','Greece','Greenland','Grenada','Guadeloupe','Guam','Guantanamo Bay (US Naval Base) Cuba','Guatemala','Guinea People''s Revolutionary Republic','Guinea-Bissau','Guyana','Haiti','Honduras','Hong Kong','Hungary Iceland','India','India (Ahmedabad)','India (Bangalore)','India (Bombay)','India (Hyderabad)','India (Madras)','India (New Delhi)','India (PUNE)','Indonesia','Indonesia (Jakarta)','Iran','Iraq','Ireland','Israel','Italy','Ivory Coast, Republic Of','Jamaica','Japan','Jordan','Kazakhstan','Kenya','Kenya (Nairobi)','Kiribati','Korea, North','Korea, South','Kuwait','Kyrgyzstan','Laos','Latvia','Lebanon','Lesotho','Liberia','Libya','Liechtenstein','Lithuania','Luxembourg','Macao','Macedonia, Republic of','Madagascar','Malawi','Malaysia','Maldives','Mali Republic','Malta','Marshall Islands','Mauritania','Mauritius','Mayotte Island','Mexico (All Bands)','Mexico Band 1','Mexico Bands 3-8','Micronesia','Moldova','Monaco','Mongolia','Monteserrat','Morocco','Mozambique','Myanmar','Namibia','Nauru','Nepal','Netherlands','Netherlands Antilles','New Caledonia','New Zealand','Nicaragua','Niger Republic','Nigeria','Nigeria (Lagos)','Norfolk Island','Norway','Oman','Pakistan','Pakistan (Islamabad)','Pakistan (Karachi)','Palau','Palestine','Panama, Republic Of','Papua New Guinea','Paraguay','Peru','Peru (Lima)','Philippines','Phillipines (Manila)','oland','Poland (Warsaw)','Portugal','Puerto Rico','Qatar','Reunion Island','Romania','Russia','Russia (Moscow)','ussia (St. Petersburg)','Rwanda','San Marino','Sao Tome','Saudi Arabia','Saudi Arabia - Jeddah','Saudi Arabia - Riyadh','Senegal (Dakar)','Senegal Republic','Seychelles Islands','Sierra Leone','Singapore, Republic Of','Slovakia','Slovenia','Somalia Republic','South Africa','Spain','Sri Lanka','St Helena','St Kitts and Nevis','St Lucia','St Pierre and Miguelon','St Vincent','Sudan','Suriname','Swaziland','Sweden','Switzerland','Syria','Taiwan','Tajikistan Tanzania','Thailand','Thailand (Bangkok)','Togo','Tonga Islands','Trinidad and Tobago','Tunisia','Turkey','Turkey (Istambul)','Turkmenistan','Turks and Caicos','Tuvalu','U.S. Virgin Islands','Uganda','Ukraine','United Arab Emirates','United Kingdom','United States of America','Uruguay','Uzbekistan Tashkent','Vatican City','Venezuala (Caracas)','Venezuela','Vietnam','Wallis And Futuna Islands','Western Samoa','Yemen','Yugoslavia','Zaire','Zambia','Zimbabwe') is not a supported type at GT::SQL::Admin::editor_update_def line 1892. ). Links (6635): GT::Base::error called at GT::Base::fatal line 290 with arguments (GT::SQL::Creator=HASH(0x844e3d0), BADTYPE, FATAL, enum('Afghanistan','Albania','Algeria','AmericanSamoa','Andorra','Angola','Anguilla','Antarctica','Antigua and Barbuda','Argentina','Argentina (Buenos Aires)','Armenia','Aruba','Ascension Islands','Australia','Austria','Azerbaijan','Bahamas, The','Bahrain','Bangladesh','Bangladesh (Chittagong)','Bangladesh (Dhaka)','Barbados','Belarus','Belgium','Belize','Benin, Republic Of','Bermuda','Bhutan','Bolivia','Bolivia (La Paz)','Bosnia-Herzegovina','Botswana','Brazil','Brazil (Rio Dejanero)','Brazil (Rio-Janeiro)','Brazil (Sao Paulo)','British Virgin Islands','Brunei','Bulgaria','urkina Faso','Burundi','Cambodia','Cameroon','Canada','Cape Verde Island','Cayman Islands','Central African Republic','Chad Republic','Chile','China','Christmas And Cocos Islands','Colombia','Colombia (Bogota)','Colombia (Cali)','Colombia (Medellin)','Comoros Federal And Islamic Republic Of','Congo','Cook Islands','Costa Rica','Croatia','Cuba','Cyprus','Czech Republic','Denmark','Diego Garcia','Djibouti','Dominica','Dominican Republic','Ecuador','Egypt','Egypt (Cairo)','El Salvador','Equatorial Guinea','Eritrea','Estonia','Ethiopia','Faeroe Islands','Fiji Islands','Finland','France','French Antilles (Martinique)','French Guiana','French Polynesia','Gabon Republic','GambiaGeorgia','GermanyGhana','Ghana (Accra)','Gibraltar','Greece','Greenland','Grenada','Guadeloupe','Guam','Guantanamo Bay (US Naval Base) Cuba','Guatemala','Guinea People''s Revolutionary Republic','Guinea-Bissau','Guyana','Haiti','Honduras','Hong Kong','Hungary Iceland','India','India (Ahmedabad)','India (Bangalore)','India (Bombay)','India (Hyderabad)','India (Madras)','India (New Delhi)','India (PUNE)','Indonesia','Indonesia (Jakarta)','Iran','Iraq','Ireland','Israel','Italy','Ivory Coast, Republic Of','Jamaica','Japan','Jordan','Kazakhstan','Kenya','Kenya (Nairobi)','Kiribati','Korea, North','Korea, South','Kuwait','Kyrgyzstan','Laos','Latvia','Lebanon','Lesotho','Liberia','Libya','Liechtenstein','Lithuania','Luxembourg','Macao','Macedonia, Republic of','Madagascar','Malawi','Malaysia','Maldives','Mali Republic','Malta','Marshall Islands','Mauritania','Mauritius','Mayotte Island','Mexico (All Bands)','Mexico Band 1','Mexico Bands 3-8','Micronesia','Moldova','Monaco','Mongolia','Monteserrat','Morocco','Mozambique','Myanmar','Namibia','Nauru','Nepal','Netherlands','Netherlands Antilles','New Caledonia','New Zealand','Nicaragua','Niger Republic','Nigeria','Nigeria (Lagos)','Norfolk Island','Norway','Oman','Pakistan','Pakistan (Islamabad)','Pakistan (Karachi)','Palau','Palestine','Panama, Republic Of','Papua New Guinea','Paraguay','Peru','Peru (Lima)','Philippines','Phillipines (Manila)','oland','Poland (Warsaw)','Portugal','Puerto Rico','Qatar','Reunion Island','Romania','Russia','Russia (Moscow)','ussia (St. Petersburg)','Rwanda','San Marino','Sao Tome','Saudi Arabia','Saudi Arabia - Jeddah','Saudi Arabia - Riyadh','Senegal (Dakar)','Senegal Republic','Seychelles Islands','Sierra Leone','Singapore, Republic Of','Slovakia','Slovenia','Somalia Republic','South Africa','Spain','Sri Lanka','St Helena','St Kitts and Nevis','St Lucia','St Pierre and Miguelon','St Vincent','Sudan','Suriname','Swaziland','Sweden','Switzerland','Syria','Taiwan','Tajikistan Tanzania','Thailand','Thailand (Bangkok)','Togo','Tonga Islands','Trinidad and Tobago','Tunisia','Turkey','Turkey (Istambul)','Turkmenistan','Turks and Caicos','Tuvalu','U.S. Virgin Islands','Uganda','Ukraine','United Arab Emirates','United Kingdom','United States of America','Uruguay','Uzbekistan Tashkent','Vatican City','Venezuala (Caracas)','Venezuela','Vietnam','Wallis And Futuna Islands','Western Samoa','Yemen','Yugoslavia','Zaire','Zambia','Zimbabwe')). Links (6635): GT::Base::fatal called at GT::SQL::Creator::_load_table line 288 with arguments (GT::SQL::Creator=HASH(0x844e3d0), BADTYPE, enum('Afghanistan','Albania','Algeria','AmericanSamoa','Andorra','Angola','Anguilla','Antarctica','Antigua and Barbuda','Argentina','Argentina (Buenos Aires)','Armenia','Aruba','Ascension Islands','Australia','Austria','Azerbaijan','Bahamas, The','Bahrain','Bangladesh','Bangladesh (Chittagong)','Bangladesh (Dhaka)','Barbados','Belarus','Belgium','Belize','Benin, Republic Of','Bermuda','Bhutan','Bolivia','Bolivia (La Paz)','Bosnia-Herzegovina','Botswana','Brazil','Brazil (Rio Dejanero)','Brazil (Rio-Janeiro)','Brazil (Sao Paulo)','British Virgin Islands','Brunei','Bulgaria','urkina Faso','Burundi','Cambodia','Cameroon','Canada','Cape Verde Island','Cayman Islands','Central African Republic','Chad Republic','Chile','China','Christmas And Cocos Islands','Colombia','Colombia (Bogota)','Colombia (Cali)','Colombia (Medellin)','Comoros Federal And Islamic Republic Of','Congo','Cook Islands','Costa Rica','Croatia','Cuba','Cyprus','Czech Republic','Denmark','Diego Garcia','Djibouti','Dominica','Dominican Republic','Ecuador','Egypt','Egypt (Cairo)','El Salvador','Equatorial Guinea','Eritrea','Estonia','Ethiopia','Faeroe Islands','Fiji Islands','Finland','France','French Antilles (Martinique)','French Guiana','French Polynesia','Gabon Republic','GambiaGeorgia','GermanyGhana','Ghana (Accra)','Gibraltar','Greece','Greenland','Grenada','Guadeloupe','Guam','Guantanamo Bay (US Naval Base) Cuba','Guatemala','Guinea People''s Revolutionary Republic','Guinea-Bissau','Guyana','Haiti','Honduras','Hong Kong','Hungary Iceland','India','India (Ahmedabad)','India (Bangalore)','India (Bombay)','India (Hyderabad)','India (Madras)','India (New Delhi)','India (PUNE)','Indonesia','Indonesia (Jakarta)','Iran','Iraq','Ireland','Israel','Italy','Ivory Coast, Republic Of','Jamaica','Japan','Jordan','Kazakhstan','Kenya','Kenya (Nairobi)','Kiribati','Korea, North','Korea, South','Kuwait','Kyrgyzstan','Laos','Latvia','Lebanon','Lesotho','Liberia','Libya','Liechtenstein','Lithuania','Luxembourg','Macao','Macedonia, Republic of','Madagascar','Malawi','Malaysia','Maldives','Mali Republic','Malta','Marshall Islands','Mauritania','Mauritius','Mayotte Island','Mexico (All Bands)','Mexico Band 1','Mexico Bands 3-8','Micronesia','Moldova','Monaco','Mongolia','Monteserrat','Morocco','Mozambique','Myanmar','Namibia','Nauru','Nepal','Netherlands','Netherlands Antilles','New Caledonia','New Zealand','Nicaragua','Niger Republic','Nigeria','Nigeria (Lagos)','Norfolk Island','Norway','Oman','Pakistan','Pakistan (Islamabad)','Pakistan (Karachi)','Palau','Palestine','Panama, Republic Of','Papua New Guinea','Paraguay','Peru','Peru (Lima)','Philippines','Phillipines (Manila)','oland','Poland (Warsaw)','Portugal','Puerto Rico','Qatar','Reunion Island','Romania','Russia','Russia (Moscow)','ussia (St. Petersburg)','Rwanda','San Marino','Sao Tome','Saudi Arabia','Saudi Arabia - Jeddah','Saudi Arabia - Riyadh','Senegal (Dakar)','Senegal Republic','Seychelles Islands','Sierra Leone','Singapore, Republic Of','Slovakia','Slovenia','Somalia Republic','South Africa','Spain','Sri Lanka','St Helena','St Kitts and Nevis','St Lucia','St Pierre and Miguelon','St Vincent','Sudan','Suriname','Swaziland','Sweden','Switzerland','Syria','Taiwan','Tajikistan Tanzania','Thailand','Thailand (Bangkok)','Togo','Tonga Islands','Trinidad and Tobago','Tunisia','Turkey','Turkey (Istambul)','Turkmenistan','Turks and Caicos','Tuvalu','U.S. Virgin Islands','Uganda','Ukraine','United Arab Emirates','United Kingdom','United States of America','Uruguay','Uzbekistan Tashkent','Vatican City','Venezuala (Caracas)','Venezuela','Vietnam','Wallis And Futuna Islands','Western Samoa','Yemen','Yugoslavia','Zaire','Zambia','Zimbabwe')). Links (6635): GT::SQL::Creator::_load_table called at GT::SQL::Creator::load_table line 220 with arguments (GT::SQL::Creator=HASH(0x844e3d0)). Links (6635): GT::SQL::Creator::load_table called at GT::SQL::Admin::editor_update_def line 1892 with arguments (GT::SQL::Creator=HASH(0x844e3d0)). Links (6635): GT::SQL::Admin::editor_update_def called at /home/www/mydomain/cgi-bin/links/admin/GT/SQL/Admin.pm line 121 with arguments (Links::Admin=HASH(0x83e1c00)). Links (6635): GT::SQL::Admin::process called at admin.cgi line 79 with arguments (Links::Admin=HASH(0x83e1c00), db, GT::SQL=HASH(0x82a9a70), cgi, GT::CGI=HASH(0x82ab94c)). Links (6635): main::db_request called at admin.cgi line 57 with no arguments. Links (6635): main::main called at admin.cgi line 24 with no arguments.
The "livingcountry" looks like this, so what am I doing wrong?
==============================================================
- Column Name ==> livingcountry
- Column Type ==> ENUM
- Column Index ==> None
- Column Values ==> Afghanistan Albania Algeria AmericanSamoa (all countries one per line)
- Not Null ==> No
- Form Display ==> Living Country
- Form Type ==> SELECT
- Form Size ==> 1
- Form Names ==> 1 2 3 4 5 5 (one number per line for all countries)
- Form Values ==> Afghanistan Albania Algeria AmericanSamoa (all countries one per line)
- File Save method ==> HASHED
but if I delete this field, I am able to ReSynch the DB.
Thank you for your help
Mark
2 - The livingcountry is a drop-down selection menu, I added country names in it; however, I can not ReSync the user's table as I get the following error (debugger is enabled):
Code:
A fatal error has occured:
GT::SQL::Creator (6635): enum('Afghanistan','Albania','Algeria','AmericanSamoa','Andorra','Angola','Anguilla','Antarctica','Antigua and Barbuda','Argentina','Argentina (Buenos Aires)','Armenia','Aruba','Ascension Islands','Australia','Austria','Azerbaijan','Bahamas, The','Bahrain','Bangladesh','Bangladesh (Chittagong)','Bangladesh (Dhaka)','Barbados','Belarus','Belgium','Belize','Benin, Republic Of','Bermuda','Bhutan','Bolivia','Bolivia (La Paz)','Bosnia-Herzegovina','Botswana','Brazil','Brazil (Rio Dejanero)','Brazil (Rio-Janeiro)','Brazil (Sao Paulo)','British Virgin Islands','Brunei','Bulgaria','urkina Faso','Burundi','Cambodia','Cameroon','Canada','Cape Verde Island','Cayman Islands','Central African Republic','Chad Republic','Chile','China','Christmas And Cocos Islands','Colombia','Colombia (Bogota)','Colombia (Cali)','Colombia (Medellin)','Comoros Federal And Islamic Republic Of','Congo','Cook Islands','Costa Rica','Croatia','Cuba','Cyprus','Czech Republic','Denmark','Diego Garcia','Djibouti','Dominica','Dominican Republic','Ecuador','Egypt','Egypt (Cairo)','El Salvador','Equatorial Guinea','Eritrea','Estonia','Ethiopia','Faeroe Islands','Fiji Islands','Finland','France','French Antilles (Martinique)','French Guiana','French Polynesia','Gabon Republic','GambiaGeorgia','GermanyGhana','Ghana (Accra)','Gibraltar','Greece','Greenland','Grenada','Guadeloupe','Guam','Guantanamo Bay (US Naval Base) Cuba','Guatemala','Guinea People''s Revolutionary Republic','Guinea-Bissau','Guyana','Haiti','Honduras','Hong Kong','Hungary Iceland','India','India (Ahmedabad)','India (Bangalore)','India (Bombay)','India (Hyderabad)','India (Madras)','India (New Delhi)','India (PUNE)','Indonesia','Indonesia (Jakarta)','Iran','Iraq','Ireland','Israel','Italy','Ivory Coast, Republic Of','Jamaica','Japan','Jordan','Kazakhstan','Kenya','Kenya (Nairobi)','Kiribati','Korea, North','Korea, South','Kuwait','Kyrgyzstan','Laos','Latvia','Lebanon','Lesotho','Liberia','Libya','Liechtenstein','Lithuania','Luxembourg','Macao','Macedonia, Republic of','Madagascar','Malawi','Malaysia','Maldives','Mali Republic','Malta','Marshall Islands','Mauritania','Mauritius','Mayotte Island','Mexico (All Bands)','Mexico Band 1','Mexico Bands 3-8','Micronesia','Moldova','Monaco','Mongolia','Monteserrat','Morocco','Mozambique','Myanmar','Namibia','Nauru','Nepal','Netherlands','Netherlands Antilles','New Caledonia','New Zealand','Nicaragua','Niger Republic','Nigeria','Nigeria (Lagos)','Norfolk Island','Norway','Oman','Pakistan','Pakistan (Islamabad)','Pakistan (Karachi)','Palau','Palestine','Panama, Republic Of','Papua New Guinea','Paraguay','Peru','Peru (Lima)','Philippines','Phillipines (Manila)','oland','Poland (Warsaw)','Portugal','Puerto Rico','Qatar','Reunion Island','Romania','Russia','Russia (Moscow)','ussia (St. Petersburg)','Rwanda','San Marino','Sao Tome','Saudi Arabia','Saudi Arabia - Jeddah','Saudi Arabia - Riyadh','Senegal (Dakar)','Senegal Republic','Seychelles Islands','Sierra Leone','Singapore, Republic Of','Slovakia','Slovenia','Somalia Republic','South Africa','Spain','Sri Lanka','St Helena','St Kitts and Nevis','St Lucia','St Pierre and Miguelon','St Vincent','Sudan','Suriname','Swaziland','Sweden','Switzerland','Syria','Taiwan','Tajikistan Tanzania','Thailand','Thailand (Bangkok)','Togo','Tonga Islands','Trinidad and Tobago','Tunisia','Turkey','Turkey (Istambul)','Turkmenistan','Turks and Caicos','Tuvalu','U.S. Virgin Islands','Uganda','Ukraine','United Arab Emirates','United Kingdom','United States of America','Uruguay','Uzbekistan Tashkent','Vatican City','Venezuala (Caracas)','Venezuela','Vietnam','Wallis And Futuna Islands','Western Samoa','Yemen','Yugoslavia','Zaire','Zambia','Zimbabwe') is not a supported type at GT::SQL::Admin::editor_update_def line 1892.
Please enable debugging in setup for more details.Stack Trace ====================================== Links (6635): Links::environment called at /home/www/mydomain/cgi-bin/links/admin/Links.pm line 712 with no arguments. Links (6635): Links::fatal called at GT::Base::error line 378 with arguments (GT::SQL::Creator (6635): enum('Afghanistan','Albania','Algeria','AmericanSamoa','Andorra','Angola','Anguilla','Antarctica','Antigua and Barbuda','Argentina','Argentina (Buenos Aires)','Armenia','Aruba','Ascension Islands','Australia','Austria','Azerbaijan','Bahamas, The','Bahrain','Bangladesh','Bangladesh (Chittagong)','Bangladesh (Dhaka)','Barbados','Belarus','Belgium','Belize','Benin, Republic Of','Bermuda','Bhutan','Bolivia','Bolivia (La Paz)','Bosnia-Herzegovina','Botswana','Brazil','Brazil (Rio Dejanero)','Brazil (Rio-Janeiro)','Brazil (Sao Paulo)','British Virgin Islands','Brunei','Bulgaria','urkina Faso','Burundi','Cambodia','Cameroon','Canada','Cape Verde Island','Cayman Islands','Central African Republic','Chad Republic','Chile','China','Christmas And Cocos Islands','Colombia','Colombia (Bogota)','Colombia (Cali)','Colombia (Medellin)','Comoros Federal And Islamic Republic Of','Congo','Cook Islands','Costa Rica','Croatia','Cuba','Cyprus','Czech Republic','Denmark','Diego Garcia','Djibouti','Dominica','Dominican Republic','Ecuador','Egypt','Egypt (Cairo)','El Salvador','Equatorial Guinea','Eritrea','Estonia','Ethiopia','Faeroe Islands','Fiji Islands','Finland','France','French Antilles (Martinique)','French Guiana','French Polynesia','Gabon Republic','GambiaGeorgia','GermanyGhana','Ghana (Accra)','Gibraltar','Greece','Greenland','Grenada','Guadeloupe','Guam','Guantanamo Bay (US Naval Base) Cuba','Guatemala','Guinea People''s Revolutionary Republic','Guinea-Bissau','Guyana','Haiti','Honduras','Hong Kong','Hungary Iceland','India','India (Ahmedabad)','India (Bangalore)','India (Bombay)','India (Hyderabad)','India (Madras)','India (New Delhi)','India (PUNE)','Indonesia','Indonesia (Jakarta)','Iran','Iraq','Ireland','Israel','Italy','Ivory Coast, Republic Of','Jamaica','Japan','Jordan','Kazakhstan','Kenya','Kenya (Nairobi)','Kiribati','Korea, North','Korea, South','Kuwait','Kyrgyzstan','Laos','Latvia','Lebanon','Lesotho','Liberia','Libya','Liechtenstein','Lithuania','Luxembourg','Macao','Macedonia, Republic of','Madagascar','Malawi','Malaysia','Maldives','Mali Republic','Malta','Marshall Islands','Mauritania','Mauritius','Mayotte Island','Mexico (All Bands)','Mexico Band 1','Mexico Bands 3-8','Micronesia','Moldova','Monaco','Mongolia','Monteserrat','Morocco','Mozambique','Myanmar','Namibia','Nauru','Nepal','Netherlands','Netherlands Antilles','New Caledonia','New Zealand','Nicaragua','Niger Republic','Nigeria','Nigeria (Lagos)','Norfolk Island','Norway','Oman','Pakistan','Pakistan (Islamabad)','Pakistan (Karachi)','Palau','Palestine','Panama, Republic Of','Papua New Guinea','Paraguay','Peru','Peru (Lima)','Philippines','Phillipines (Manila)','oland','Poland (Warsaw)','Portugal','Puerto Rico','Qatar','Reunion Island','Romania','Russia','Russia (Moscow)','ussia (St. Petersburg)','Rwanda','San Marino','Sao Tome','Saudi Arabia','Saudi Arabia - Jeddah','Saudi Arabia - Riyadh','Senegal (Dakar)','Senegal Republic','Seychelles Islands','Sierra Leone','Singapore, Republic Of','Slovakia','Slovenia','Somalia Republic','South Africa','Spain','Sri Lanka','St Helena','St Kitts and Nevis','St Lucia','St Pierre and Miguelon','St Vincent','Sudan','Suriname','Swaziland','Sweden','Switzerland','Syria','Taiwan','Tajikistan Tanzania','Thailand','Thailand (Bangkok)','Togo','Tonga Islands','Trinidad and Tobago','Tunisia','Turkey','Turkey (Istambul)','Turkmenistan','Turks and Caicos','Tuvalu','U.S. Virgin Islands','Uganda','Ukraine','United Arab Emirates','United Kingdom','United States of America','Uruguay','Uzbekistan Tashkent','Vatican City','Venezuala (Caracas)','Venezuela','Vietnam','Wallis And Futuna Islands','Western Samoa','Yemen','Yugoslavia','Zaire','Zambia','Zimbabwe') is not a supported type at GT::SQL::Admin::editor_update_def line 1892. ). Links (6635): GT::Base::error called at GT::Base::fatal line 290 with arguments (GT::SQL::Creator=HASH(0x844e3d0), BADTYPE, FATAL, enum('Afghanistan','Albania','Algeria','AmericanSamoa','Andorra','Angola','Anguilla','Antarctica','Antigua and Barbuda','Argentina','Argentina (Buenos Aires)','Armenia','Aruba','Ascension Islands','Australia','Austria','Azerbaijan','Bahamas, The','Bahrain','Bangladesh','Bangladesh (Chittagong)','Bangladesh (Dhaka)','Barbados','Belarus','Belgium','Belize','Benin, Republic Of','Bermuda','Bhutan','Bolivia','Bolivia (La Paz)','Bosnia-Herzegovina','Botswana','Brazil','Brazil (Rio Dejanero)','Brazil (Rio-Janeiro)','Brazil (Sao Paulo)','British Virgin Islands','Brunei','Bulgaria','urkina Faso','Burundi','Cambodia','Cameroon','Canada','Cape Verde Island','Cayman Islands','Central African Republic','Chad Republic','Chile','China','Christmas And Cocos Islands','Colombia','Colombia (Bogota)','Colombia (Cali)','Colombia (Medellin)','Comoros Federal And Islamic Republic Of','Congo','Cook Islands','Costa Rica','Croatia','Cuba','Cyprus','Czech Republic','Denmark','Diego Garcia','Djibouti','Dominica','Dominican Republic','Ecuador','Egypt','Egypt (Cairo)','El Salvador','Equatorial Guinea','Eritrea','Estonia','Ethiopia','Faeroe Islands','Fiji Islands','Finland','France','French Antilles (Martinique)','French Guiana','French Polynesia','Gabon Republic','GambiaGeorgia','GermanyGhana','Ghana (Accra)','Gibraltar','Greece','Greenland','Grenada','Guadeloupe','Guam','Guantanamo Bay (US Naval Base) Cuba','Guatemala','Guinea People''s Revolutionary Republic','Guinea-Bissau','Guyana','Haiti','Honduras','Hong Kong','Hungary Iceland','India','India (Ahmedabad)','India (Bangalore)','India (Bombay)','India (Hyderabad)','India (Madras)','India (New Delhi)','India (PUNE)','Indonesia','Indonesia (Jakarta)','Iran','Iraq','Ireland','Israel','Italy','Ivory Coast, Republic Of','Jamaica','Japan','Jordan','Kazakhstan','Kenya','Kenya (Nairobi)','Kiribati','Korea, North','Korea, South','Kuwait','Kyrgyzstan','Laos','Latvia','Lebanon','Lesotho','Liberia','Libya','Liechtenstein','Lithuania','Luxembourg','Macao','Macedonia, Republic of','Madagascar','Malawi','Malaysia','Maldives','Mali Republic','Malta','Marshall Islands','Mauritania','Mauritius','Mayotte Island','Mexico (All Bands)','Mexico Band 1','Mexico Bands 3-8','Micronesia','Moldova','Monaco','Mongolia','Monteserrat','Morocco','Mozambique','Myanmar','Namibia','Nauru','Nepal','Netherlands','Netherlands Antilles','New Caledonia','New Zealand','Nicaragua','Niger Republic','Nigeria','Nigeria (Lagos)','Norfolk Island','Norway','Oman','Pakistan','Pakistan (Islamabad)','Pakistan (Karachi)','Palau','Palestine','Panama, Republic Of','Papua New Guinea','Paraguay','Peru','Peru (Lima)','Philippines','Phillipines (Manila)','oland','Poland (Warsaw)','Portugal','Puerto Rico','Qatar','Reunion Island','Romania','Russia','Russia (Moscow)','ussia (St. Petersburg)','Rwanda','San Marino','Sao Tome','Saudi Arabia','Saudi Arabia - Jeddah','Saudi Arabia - Riyadh','Senegal (Dakar)','Senegal Republic','Seychelles Islands','Sierra Leone','Singapore, Republic Of','Slovakia','Slovenia','Somalia Republic','South Africa','Spain','Sri Lanka','St Helena','St Kitts and Nevis','St Lucia','St Pierre and Miguelon','St Vincent','Sudan','Suriname','Swaziland','Sweden','Switzerland','Syria','Taiwan','Tajikistan Tanzania','Thailand','Thailand (Bangkok)','Togo','Tonga Islands','Trinidad and Tobago','Tunisia','Turkey','Turkey (Istambul)','Turkmenistan','Turks and Caicos','Tuvalu','U.S. Virgin Islands','Uganda','Ukraine','United Arab Emirates','United Kingdom','United States of America','Uruguay','Uzbekistan Tashkent','Vatican City','Venezuala (Caracas)','Venezuela','Vietnam','Wallis And Futuna Islands','Western Samoa','Yemen','Yugoslavia','Zaire','Zambia','Zimbabwe')). Links (6635): GT::Base::fatal called at GT::SQL::Creator::_load_table line 288 with arguments (GT::SQL::Creator=HASH(0x844e3d0), BADTYPE, enum('Afghanistan','Albania','Algeria','AmericanSamoa','Andorra','Angola','Anguilla','Antarctica','Antigua and Barbuda','Argentina','Argentina (Buenos Aires)','Armenia','Aruba','Ascension Islands','Australia','Austria','Azerbaijan','Bahamas, The','Bahrain','Bangladesh','Bangladesh (Chittagong)','Bangladesh (Dhaka)','Barbados','Belarus','Belgium','Belize','Benin, Republic Of','Bermuda','Bhutan','Bolivia','Bolivia (La Paz)','Bosnia-Herzegovina','Botswana','Brazil','Brazil (Rio Dejanero)','Brazil (Rio-Janeiro)','Brazil (Sao Paulo)','British Virgin Islands','Brunei','Bulgaria','urkina Faso','Burundi','Cambodia','Cameroon','Canada','Cape Verde Island','Cayman Islands','Central African Republic','Chad Republic','Chile','China','Christmas And Cocos Islands','Colombia','Colombia (Bogota)','Colombia (Cali)','Colombia (Medellin)','Comoros Federal And Islamic Republic Of','Congo','Cook Islands','Costa Rica','Croatia','Cuba','Cyprus','Czech Republic','Denmark','Diego Garcia','Djibouti','Dominica','Dominican Republic','Ecuador','Egypt','Egypt (Cairo)','El Salvador','Equatorial Guinea','Eritrea','Estonia','Ethiopia','Faeroe Islands','Fiji Islands','Finland','France','French Antilles (Martinique)','French Guiana','French Polynesia','Gabon Republic','GambiaGeorgia','GermanyGhana','Ghana (Accra)','Gibraltar','Greece','Greenland','Grenada','Guadeloupe','Guam','Guantanamo Bay (US Naval Base) Cuba','Guatemala','Guinea People''s Revolutionary Republic','Guinea-Bissau','Guyana','Haiti','Honduras','Hong Kong','Hungary Iceland','India','India (Ahmedabad)','India (Bangalore)','India (Bombay)','India (Hyderabad)','India (Madras)','India (New Delhi)','India (PUNE)','Indonesia','Indonesia (Jakarta)','Iran','Iraq','Ireland','Israel','Italy','Ivory Coast, Republic Of','Jamaica','Japan','Jordan','Kazakhstan','Kenya','Kenya (Nairobi)','Kiribati','Korea, North','Korea, South','Kuwait','Kyrgyzstan','Laos','Latvia','Lebanon','Lesotho','Liberia','Libya','Liechtenstein','Lithuania','Luxembourg','Macao','Macedonia, Republic of','Madagascar','Malawi','Malaysia','Maldives','Mali Republic','Malta','Marshall Islands','Mauritania','Mauritius','Mayotte Island','Mexico (All Bands)','Mexico Band 1','Mexico Bands 3-8','Micronesia','Moldova','Monaco','Mongolia','Monteserrat','Morocco','Mozambique','Myanmar','Namibia','Nauru','Nepal','Netherlands','Netherlands Antilles','New Caledonia','New Zealand','Nicaragua','Niger Republic','Nigeria','Nigeria (Lagos)','Norfolk Island','Norway','Oman','Pakistan','Pakistan (Islamabad)','Pakistan (Karachi)','Palau','Palestine','Panama, Republic Of','Papua New Guinea','Paraguay','Peru','Peru (Lima)','Philippines','Phillipines (Manila)','oland','Poland (Warsaw)','Portugal','Puerto Rico','Qatar','Reunion Island','Romania','Russia','Russia (Moscow)','ussia (St. Petersburg)','Rwanda','San Marino','Sao Tome','Saudi Arabia','Saudi Arabia - Jeddah','Saudi Arabia - Riyadh','Senegal (Dakar)','Senegal Republic','Seychelles Islands','Sierra Leone','Singapore, Republic Of','Slovakia','Slovenia','Somalia Republic','South Africa','Spain','Sri Lanka','St Helena','St Kitts and Nevis','St Lucia','St Pierre and Miguelon','St Vincent','Sudan','Suriname','Swaziland','Sweden','Switzerland','Syria','Taiwan','Tajikistan Tanzania','Thailand','Thailand (Bangkok)','Togo','Tonga Islands','Trinidad and Tobago','Tunisia','Turkey','Turkey (Istambul)','Turkmenistan','Turks and Caicos','Tuvalu','U.S. Virgin Islands','Uganda','Ukraine','United Arab Emirates','United Kingdom','United States of America','Uruguay','Uzbekistan Tashkent','Vatican City','Venezuala (Caracas)','Venezuela','Vietnam','Wallis And Futuna Islands','Western Samoa','Yemen','Yugoslavia','Zaire','Zambia','Zimbabwe')). Links (6635): GT::SQL::Creator::_load_table called at GT::SQL::Creator::load_table line 220 with arguments (GT::SQL::Creator=HASH(0x844e3d0)). Links (6635): GT::SQL::Creator::load_table called at GT::SQL::Admin::editor_update_def line 1892 with arguments (GT::SQL::Creator=HASH(0x844e3d0)). Links (6635): GT::SQL::Admin::editor_update_def called at /home/www/mydomain/cgi-bin/links/admin/GT/SQL/Admin.pm line 121 with arguments (Links::Admin=HASH(0x83e1c00)). Links (6635): GT::SQL::Admin::process called at admin.cgi line 79 with arguments (Links::Admin=HASH(0x83e1c00), db, GT::SQL=HASH(0x82a9a70), cgi, GT::CGI=HASH(0x82ab94c)). Links (6635): main::db_request called at admin.cgi line 57 with no arguments. Links (6635): main::main called at admin.cgi line 24 with no arguments.
Code:
The "livingcountry" looks like this, so what am I doing wrong?
==============================================================
- Column Name ==> livingcountry
- Column Type ==> ENUM
- Column Index ==> None
- Column Values ==> Afghanistan Albania Algeria AmericanSamoa (all countries one per line)
- Not Null ==> No
- Form Display ==> Living Country
- Form Type ==> SELECT
- Form Size ==> 1
- Form Names ==> 1 2 3 4 5 5 (one number per line for all countries)
- Form Values ==> Afghanistan Albania Algeria AmericanSamoa (all countries one per line)
- File Save method ==> HASHED
but if I delete this field, I am able to ReSynch the DB.
Thank you for your help
Mark