I have tracked the problem down. I started with a clean install of CMSB 3.68, no problems creating a new database.
Copied schemas from a current project that uses CMSB 3.68 into the clean install. I could not enter the Database editor - error Field "num" does not exist.
Removed all add schemas and moved them in one at a time until I hit the error. Turns out the menugroup type is the cause.
Old Format
<?php /* This is a PHP data file */ if (empty($LOADSTRUCT)) { die("This is not a program file."); }
return array (
'_description' => '',
'_detailPage' => '',
'_disableAdd' => '0',
'_disableErase' => '0',
'_disableEraseFromModify' => '0',
'_disableModify' => '0',
'_disablePreview' => '0',
'_disableView' => '0',
'_filenameFields' => '',
'_hideRecordsFromDisabledAccounts' => '0',
'_indent' => '0',
'_listPage' => '',
'_maxRecords' => '',
'_maxRecordsPerUser' => '',
'_perPageDefault' => '25',
'_previewPage' => '',
'_primaryKey' => 'num',
'_requiredPlugins' => '',
'_tableName' => 'blog_module',
'listPageFields' => NULL,
'listPageOrder' => '',
'listPageSearchFields' => '',
'menuHidden' => false,
'menuName' => 'Blog Module',
'menuOrder' => '0000000007',
'menuType' => 'menugroup',
);
New Format
<?php /* This is a PHP data file */ if (empty($LOADSTRUCT)) { die("This is not a program file."); }
return array (
'_detailPage' => '',
'_filenameFields' => '',
'_indent' => '0',
'_primaryKey' => 'num',
'_tableName' => 'testing_menugroup',
'menuName' => 'testing',
'menuOrder' => 1714325050,
'menuType' => 'menugroup',
);
The solution was to delete all the MenuGroup tables in the database editor and then recreate them to get the new format.
Jeff Shields