New table name not updated in "Add Database Column" during Clone of existing object Topic is solved

[Paul]

I have changed the name of one of my tables in nubuilder and thought I have changed everything else I needed to in order to make everything work properly, but apparently I have missed something. When I try to add a new column from the "Add database column" button (while cloning an existing object), it displays the "Add Database Column" window, but the ALTER TABLE statement includes the OLD table name, rather than the new one.

What have I missed?

[kev1n]

Also rename the table in this location:

Table: zzzzsys_object
Column: sob_all_table

[Paul]

Do I need to edit all of the rows (33 rows) where 'pk_location' (old table name) exists?

[kev1n]

Yes - you can replace them with an SQL Update:

Code: Select all

UPDATE zzzzsys_object
SET sob_all_table = REPLACE(sob_all_table, 'old_table_name', 'new_table_name')
WHERE sob_all_table LIKE '%old_table_name%';

[Paul]

Thank you! That worked. Had to first disable 'Safe Updates' (in MySql Workbench).