1045 database error message after upgrade

9 posts by 3 authors in: Forums > CMS Builder
Last Post: August 17   (RSS)

By CommonSenseDesign - August 12

Hi, there. I just did a CMSB upgrade on my client's site, and now I'm getting a 1045 - Access denied for user message.

Does anyone know hot to fix this, please?


By gkornbluth - August 12 - edited: August 12


Try renaming your backup settings.dat file from your previous working install (so you don't overwrite it by mistake) and then compare that file to the upgraded on-line version of your settings.dat file (cmsAdmin/data/settings.dat).

My bet is that you'll find differences, especially in the DB area, and those are probably leading to your problem (they have in the past for me).

Also, make sure that all the paths in the new settinbgs.dat file match your current server paths.

Hope that helps,

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!

Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By CommonSenseDesign - August 16

I've just realized that the original installation was in a directory called cmsAdmin, whereas the up-to-date version uses a directory cmsb. Should I upload the new software files to cmsAdmin, or create a new directory labelled cmsb?

By daniel - August 16

Hi CommonSenseDesign,

You should be able to upgrade by replacing the files in your existing folder (cmsAdmin). As always, we recommend making a backup of your files and database prior to upgrading in case there are any issues.

Let me know if you have any other questions!



Technical Lead


By CommonSenseDesign - August 16

Thanks for the reply, Daniel. Unfortunately, this is now happening:



By CommonSenseDesign - August 17 - edited: August 17

Hi, Daniel.

Yes, the details near the top of the code look correct to me.

Here's the load viewer code from my homepage.

// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/services3/webpages/m/w/mwisilo.com/public/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

Sorry, I can't recall which version I had installed previously, but I think it's at least five years old.

By daniel - August 17

Hi CommonSenseDesign,

This is a curious issue - I think it would be fastest if we're able to look into it directly. Can you send a 2nd level support request (https://www.interactivetools.com/support/request/) and reference this forum post?



Technical Lead


By CommonSenseDesign - August 17

Will do. Thank you.