Mysql console plugin amendments not displaying in cms section editor
2 posts by 2 authors in: Forums > CMS Builder
Last Post: March 5, 2021 (RSS)
Hi,
When I am adding a new section editor based on an existing multi section and then using the mysql console plugin to amend the field names in the new sections with a command to alter the names such as:
ALTER TABLE cms_table_name CHANGE old_name new_name mediumtext;
They seem to not be updating when i go back to section viewer (but viewing phpmyadmin they have been renamed ok in the actual database itself)
Can anyone give me any pointers and to how to make display of these refresh in the section editor within the cms?
I am running the latest version of CMS Builder
Thanks!
Elliot
By gregThomas - March 5, 2021
Hey Elliot,
In future, I'd recommend altering the names of tables and fields via the CMS itself. If I want to duplicate a section, I normally make a duplicate of the schema itself, then go into the CMS and it's automatically imported, then I can modify the fields from there.
To fix the issue with the unlinked fields, go to the cmsb/data/schema directory and open table_name.ini.php and rename the array keys that are the field names that have been changed.
Thanks!
Greg
PHP Programmer - interactivetools.com