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!

Daniel
Technical Lead
interactivetools.com