Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Unable to add tag to Users table

Quote Reply
Unable to add tag to Users table
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):

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

Last edited by:

Mark2: Jan 16, 2006, 6:35 PM
Quote Reply
Re: [Mark2] Unable to add tag to Users table In reply to
Hi,

Try it as a SELECT, with CHAR 255.

Then, in form_values put the list of countries (one per line), and then the same in form_names.

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Unable to add tag to Users table In reply to
Thanks Andy, worked the way you said. eventhough it converts CHAR to VARCHAR when I ReSynch. I think this is OK. Thanks again...

Now, why can not I see the added selection fields in signup_form.html template?? as when I put <%new_field_name%>, I get UNKOWN TAG new_field_name????
Quote Reply
Re: [Mark2] Unable to add tag to Users table In reply to
Hi,

No problem =)

Regarding your other problem - do you have an "if" wrapped around it?

i.e;

<input name="new_field_name" <%if new_field_name%>value="new_field_name"<%endif%> size="15" />

If not, then thats probably where your problem lies. Cool

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Unable to add tag to Users table In reply to
You are right as usual Andy. I did not use the if statement.
But what about if I have a selection list (same one in the DB) and not a text field, how would I show it in the signup_form.html.
I used the code below but it did not show anything.
Thanks again and agin...
Mark
Code:

<div class="row required clear" >
<label for="livingcountry" class="name" ><b>Living Country</b><span>*</span></label>
<div class="value" >
<%if livingcountry%><select id="livingcountry" name="livingcountry"><%endif%>
</div></div>