# Web form with select field with 1.300 cities.

**URL:** <https://forum.mautic.org/t/web-form-with-select-field-with-1-300-cities/5922>\
**Category:** Product Support\
**Created:** [February 26, 2016, 10:48pm UTC](https://forum.mautic.org/t/web-form-with-select-field-with-1-300-cities/5922 "2016-02-26T22:48:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jd26](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jd26/32/62_2.png) [@jd26](https://forum.mautic.org/u/jd26)\
**Post date:** [February 26, 2016, 10:48pm UTC](https://forum.mautic.org/t/web-form-with-select-field-with-1-300-cities/5922/1 "2016-02-26T22:48:29Z")

</div>

Hello!!  
  
MaxMind-Geo2 lite, doesn’t show small towns in Colombia, so I want make another field with a list of all towns and cities here in Colombia. I have the list in excel it counts 1.300 cities. Also I want to make a webform with a select field for people choose their city. I have entered in phpmyadmin and I’ve gone to the respective tables like mau\_form\_fields and posted the 1.300 cities, but in Mautic shows mistake. Somebody can help me to create this select field in the webform.

---

<div class="post-metadata">

**Author:** ![jd26](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jd26/32/62_2.png) [@jd26](https://forum.mautic.org/u/jd26)\
**Post date:** [February 26, 2016, 10:48pm UTC](https://forum.mautic.org/t/web-form-with-select-field-with-1-300-cities/5922/2 "2016-02-26T22:48:29Z")

</div>

Hello!!  
MaxMind-Geo2 lite, doesn’t show small towns in Colombia, so I want make another field with a list of all towns and cities here in Colombia. I have the list in excel it counts 1.300 cities. Also I want to make a webform with a select field for people choose their city. I have entered in phpmyadmin and I’ve gone to the respective tables like mau\_form\_fields and posted the 1.300 cities, but in Mautic shows mistake. Somebody can help me to create this select field in the webform.

---

<div class="post-metadata">

**Author:** ![jd26](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jd26/32/62_2.png) [@jd26](https://forum.mautic.org/u/jd26)\
**Post date:** [February 26, 2016, 10:49pm UTC](https://forum.mautic.org/t/web-form-with-select-field-with-1-300-cities/5922/3 "2016-02-26T22:49:57Z")

</div>

Log show this  
[2016-02-26 17:45:59] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALTypesConversionException: “Could not convert database value “a:3:{s:4:“list”;a:1:…” to Doctrine Type array” at /home/compre23/public\_html/zatrez.com/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php line 46 {“exception”:"[object] (Doctrine\DBAL\Types\ConversionException(code: 0): Could not convert database value “a:3:{s:4:“list”;a:1:…” to Doctrine Type array at /home/compre23/public\_html/zatrez.com/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:46)"} []