Adding fields via mySQL and not via CMS

[a-ok]

I've had to add a new field to the DB via mySQL (and not via the CMS) under the table 'field_archive_text'; only issue is now I need it to appear as a field (which would then be populated by the data) in the CMS to add to a template but alas when I try to make the field it states it already exists. Is there a way to force re-check the tables from the DB and if a new one exists to add it as a field?

Anyone else had a similar issue?

[adrian]

Adding a field via SQL is not that simple. It also needs an entry in the "fields" table. Add that and things might work.

The real question is why are you adding it that way? If you need to do it programmatically, why not via the API?

Tell us more and we can help more.

[a-ok]

I had to import a table from an old CMS; I just wrote a mySQL query to do it... but maybe I could've used the API?

[a-ok]

Adding a field via SQL is not that simple. It also needs an entry in the "fields" table. Add that and things might work.

Yes that worked, adrian. Thanks and sorry for overlooking that section.