Connect to existing table

3 posts by 2 authors in: Forums > CMS Builder
Last Post: June 2, 2015   (RSS)

By Dave - June 1, 2015

Hi nmsinc, 

Sure, the software doesn't do that, but try this:

  • First things first, backup your MySQL and CMSB
  • Next, say your missing section was called "news", create a section called "news2".
  • Erase every field except the num field
  • Copy the /data/schema/news2.ini.php file and save it as news.ini.php
  • "News" will now show up under Section Editors, click on it.
  • MySQL fields that don't exist in the schema will show as "(no field label)" and "none"
  • For each one, click modify, select text field (or other field type) and click save.
  • Erase news2 under Section Editors (you can do this last if you want)

Let me know if that works for you (or gets you closer).  

Good luck!

Dave Edis - Senior Developer
interactivetools.com

By nmsinc - June 2, 2015

Thanks Dave, that idea worked great!

nmsinc

nmsinc