3.53 Upgrade Error
2 posts by 2 authors in: Forums > CMS Builder
Last Post: August 20, 2019 (RSS)
By KennyH - August 19, 2019
I am still getting an error with a 3.53 upgrade.
Notice: MySQL Error: Table 'cmsbuild.cms__log_audit' doesn't exist - in auditlog_functions.php on line 27 by mysql_insert() in /home/public_html/webadmin/lib/common.php on line 278
I checked the admin_functions.php and it looks like the fix for the previous version is there.
function upgradeIfNeeded() {
global $SETTINGS, $APP;
if (!isUpgradePending()) { return; }
// rename default files
renameOrRemoveDefaultFiles();
// run upgrades
require "lib/upgrade_functions.php";
// log upgrade
auditLog_addEntry('CMS Version Changed from ' . $SETTINGS['programVersion'] . ' to ' . $APP['version']);
// update version in settings
$SETTINGS['programVersion'] = $APP['version'];
saveSettings();
}
By daniel - August 20, 2019
Hi KennyH,
Can you verify that the file "_log_audit.ini.php" exists in your data/schema/ folder? By default, this will be in "cmsb/data/schema/", but the exact location may differ if you are using a custom data folder. It sounds like there may have been an issue copying this file during the upgrade.
If the file doesn't exist, you should be able to copy it from the v3.53 installation files, and then visit the "CMS Setup > Section Editors" page to make sure the schema installs correctly.
Let me know if that helps solve the issue, or if you have any questions.
Thanks!
Technical Lead
interactivetools.com