Hey Jerry and Jeff,
Thanks for bringing this issue to our attention. I managed to track down the cause, to fix the issue you'll need to change line 417 of the file cmsb_install_directory/lib/mysql_functions.php from this:
WHERE table_name = '" .mysql_escape($mysqlTable). "' AND
character_set_name IS NOT NULL AND
collation_name IS NOT NULL"; // check for NULL to skip numeric/date fields that don't have charset/collation
To this:
WHERE table_name = '" .mysql_escape($mysqlTable). "' AND
table_schema = '{$GLOBALS['SETTINGS']['mysql']['database']}' AND
character_set_name IS NOT NULL AND
collation_name IS NOT NULL"; // check for NULL to skip numeric/date fields that don't have charset/collation
The issue seems to happen when you have multiple databases setup in MySQL that have CMS Builder installed with the same prefix. This causes the statement above to select the same column more than once, which invalidated the next MySQL update statement.
I'll push this change to our dev copy of CMS Builder so that the fix is in the next release.
Thanks for helping us track down this issue.
Cheers,
Greg
Greg Thomas
PHP Programmer - interactivetools.com