MySQL Column Type

4 posts by 2 authors in: Forums > CMS Builder
Last Post: April 14, 2014   (RSS)

By Chris - April 11, 2014

Hi Karls,

If you open up cmsAdmin/lib/database_functions.php in a text editor and search for 999, you can change the limit that CMS Builder imposes on "get option from database (advanced)" list fields:

      $query        = "SELECT `$valueField`, `$labelField` FROM `$selectTable` $where $orderBy LIMIT 0, 999";

If you do make this change, I highly recommend you create a file called CUSTOM_CHANGES.txt in your cmsAdmin/ directory and take notes about what you've changed so that you can re-apply your changes after upgrading CMS Builder in the future.

Hope this helps!

All the best,

By ht1080z - April 12, 2014

Hi Chris,

Thank you for the fix, worked perfectly!


By Chris - April 14, 2014

Hi Karls,

Glad to hear it! :)

All the best,