Mango Blog Forums : Mango Forums : Bugs : error upgrading to 1.1

Forums home | Profile | Search | Login | RSS

Thread: error upgrading to 1.1

Created on: 06/16/08 04:36 PM

New topic Reply

Page: 1

Replies: 18

MaxwellSmart

Joined: 03/23/08
Posts: 21
06/16/08 4:36 PM

Hi, I just tried upgrading to version 1.1 from 1.0.

If I go to www.domain.com/admin/setup/setup.cfm and follow the instructions I get the following Mango setupp error

"Error Executing Database Query. Table 'slauthor' already exists"

So I thought I would just try and go to www.domain.com/admin and if I try to log in I get the following CF error

"CURRENTROLE.PERMISSIONS is undefined in CURRENTAUTHOR"

I'm running Windows 2003 x64 with MySQL 5.

Any ideas on what to do?

Thanks

Link | Top | Bottom

MaxwellSmart

Joined: 03/23/08
Posts: 21
06/16/08 4:45 PM

Sorry just realised I was trying to install the full version and not the upgrade.

Although this caused the following error instead.

"Could not find the ColdFusion Component components.utilities.PreferencesFile. Please check that the given name is correct and that the component exists."

Thanks

Link | Top | Bottom

Laura
Wizard

Joined: 01/29/05
Posts: 1521
06/16/08 4:47 PM

Hi,
So I should assume your 1.0 install was working, right?
Upgrade from 1.0 to 1.1 only required a couple of new files. No changes in the database were done, nor you need to run the installer again... were you sent to the installer after copying the files? What were your steps exactly?

Link | Top | Bottom

Laura
Wizard

Joined: 01/29/05
Posts: 1521
06/16/08 4:49 PM

Ok, so now you downloaded the updated files only. When do you see that error?

Link | Top | Bottom

MaxwellSmart

Joined: 03/23/08
Posts: 21
06/16/08 5:06 PM

Hi Thanks for quick response.

Yes I initially installed the entire 1.1 by mistake but have restored and just installed the upgrade.

That error appears when I go to www.domain.com/upgrade.cfm

The main site appears and the error appears where a blog post should be. All formated with css....

Link | Top | Bottom

MaxwellSmart

Joined: 03/23/08
Posts: 21
06/17/08 9:27 AM

I've been playing with this a bit more and I don't quite understand what "components.utilities.PreferencesFile" exactly is. Is it the same as "\components\utilities\Preferences.cfc"?

I'm think it may not actually be a CF error as indicated by the original msg, as it is serving the page ok and there is nothing coming up in the CF debug lines.

thanks

Link | Top | Bottom

Laura
Wizard

Joined: 01/29/05
Posts: 1521
06/17/08 11:20 AM

Does the file components/utilities/PreferencesFile.cfc exist? (not Preference.cfc)

Link | Top | Bottom

MaxwellSmart

Joined: 03/23/08
Posts: 21
06/17/08 1:00 PM

No it doesn't. Is this the problem?

If so can I download the full version of 1.1 and extract the file from this or will I need the version 1.0 file?

Thanks

Link | Top | Bottom

MaxwellSmart

Joined: 03/23/08
Posts: 21
06/18/08 4:05 AM

Ok - I downloaded the full version and transfer the PreferencesFile.cfc as well as a few others which were missing.

The upgrade.cfm file said done when I ran it but now when I try and log into admin I get

"Unknown column 'author_blog.role' in 'field list'"

Can I just create this?

Or will it work if I perhaps delete the entire blog - install the complete 1.1 and then restore my database?

thanks

Link | Top | Bottom

Laura
Wizard

Joined: 01/29/05
Posts: 1521
06/18/08 11:54 AM

Hi,
I believe you were running 0.2.5 or earlier, not 1.0. Did you install your blog long ago? It would be important to know if it wasn't an earlier install.

There were many changes from that version to 1.0/1.1, so it is imperative that you run the upgrade.cfm file included in the other upgrade zip. Since you have already copied the files, you'll have to make a change in the upgrade.cfm file included there: change Preferences to PreferencesFile

After that runs successfully, hopefully, I'd recommend to overwrite *all* your files with those included in the full install. I don't want you to have files of all different versions.

Link | Top | Bottom

MaxwellSmart

Joined: 03/23/08
Posts: 21
06/19/08 2:51 AM

Thanks Laura - I am fairly sure I installed v1.0 a few weeks ago but could be wrong.

But I did try your suggestion of installing 0.25-1.0 and it is now throwing up the following error

Element CURRENTROLE.PERMISSIONS is undefined in CURRENTAUTHOR

The error occurred in C:\wwwroot\website\www\admin\navigation.cfm: line 5
Called from C:\wwwroot\website\www\admin\layout.cfm: line 67
Called from C:\wwwroot\website\www\admin\index.cfm: line 59

3 :
4 :
[b]5 : [/b]
6 :

Link | Top | Bottom

MaxwellSmart

Joined: 03/23/08
Posts: 21
06/19/08 2:51 AM

Thanks Laura - I am fairly sure I installed v1.0 a few weeks ago but could be wrong.

But I did try your suggestion of installing 0.25-1.0 and it is now throwing up the following error

Element CURRENTROLE.PERMISSIONS is undefined in CURRENTAUTHOR

The error occurred in C:\wwwroot\website\www\admin\navigation.cfm: line 5
Called from C:\wwwroot\website\www\admin\layout.cfm: line 67
Called from C:\wwwroot\website\www\admin\index.cfm: line 5

****CODEBLOCK:1:KCOLBEDOC****

Link | Top | Bottom

MaxwellSmart

Joined: 03/23/08
Posts: 21
06/19/08 2:52 AM

Thanks Laura - I am fairly sure I installed v1.0 a few weeks ago but could be wrong.

But I did try your suggestion of installing 0.25-1.0 and it is now throwing up the following error

Element CURRENTROLE.PERMISSIONS is undefined in CURRENTAUTHOR

The error occurred in C:\wwwroot\website\www\admin\navigation.cfm: line 5
Called from C:\wwwroot\website\www\admin\layout.cfm: line 67
Called from C:\wwwroot\website\www\admin\index.cfm: line 5

****CODEBLOCK:1:KCOLBEDOC****

Link | Top | Bottom

MaxwellSmart

Joined: 03/23/08
Posts: 21
06/19/08 2:53 AM

sorry about the multiple posts - was trying to show the full error msg but it won't show using the code tags.

but the gist of the error is
"Element CURRENTROLE.PERMISSIONS is undefined in CURRENTAUTHOR"

please delete misposts.

Link | Top | Bottom

MaxwellSmart

Joined: 03/23/08
Posts: 21
06/20/08 10:40 AM

I've done a completely fresh install of mango with a brand new database - but I am still getting the above error.

Suggestions? Thanks.

Link | Top | Bottom

Laura
Wizard

Joined: 01/29/05
Posts: 1521
06/20/08 12:16 PM

If after a clean install you still see the error do this:
open admin/Application.cfc and change the line 7 from:
this.name = "mango_#right(hash(GetDirectoryFromPath(GetCurrentTemplatePath())),50)#_v1_1";

to something like:
this.name = "mango_#right(hash(GetDirectoryFromPath(GetCurrentTemplatePath())),50)#_v1_1_new";

Link | Top | Bottom

Laura
Wizard

Joined: 01/29/05
Posts: 1521
06/20/08 12:17 PM

By the way, how did you get to make a clean install? Did you go directly to the setup page?

Link | Top | Bottom

MaxwellSmart

Joined: 03/23/08
Posts: 21
07/24/08 9:39 AM

sorry for the delay.

i have now managed to do another clean install which was almost successful.

i deleted the original database and all the files and installed mango from scratch.

however i then decided to restore my original database which i am now finding out appears to have been a mistake.

everything appears normal - but editing existing posts does strange things... for example if i edit a post the changes do not show up on the website. even if i delete a post - the website still shows the post as if it was still there. its not the browser cache as i have tried different machines, browsers, etc.

are there changes that i need to do to the database to make this work properly - i am guessing perhaps the problems arise with the idea numbers for entries in the table slentry?

thanks

Link | Top | Bottom

elizas

Joined: 02/24/10
Posts: 1
02/24/10 4:53 AM

Few important tips and notes about Application.cfm/cfc:
This is the first ColdFusion file that gets executed by the ColdFusion Application server even if we request for some other file. Example: When we type http://www.mySite.com/index.cfm, Application.cfm/cfc gets executed first and then index.cfm. Application.cfc/cfm and all objects gets instantiated for each server page request.
We may or may not have Application.cfc/cfm inside one project web root.
Application files are mainly used to set application (global) level objects before executing the server files of the project.
What if we are requesting for a ColdFusion file present inside a deep subfolder level? If we have Application.cfc/cfm inside the same folder (where our requested file resides) then the same Application.cfc/cfm will be executed. If we do not have Application.cfm/cfm inside the same folder (where our requested file resides) then ColdFusion application server will search for the Application files in the next higher folder level (backward), it still does not find then one level up till the web root. At any level if it finds the Application files then it will execute that.
What if we have both Application.cfc and Application.cfm present in the same folder? Application.cfc will be given more priority (Application.cfm will be ignored) if the ColdFusion version is ColdFusion MX 7 +. If it is any version less that ColdFusion MX 7 then Application.cfm will be given more priority (Application.cfc will be ignored). Reason: Application.cfc got introduced in CFMX 7 version onwards and given more priority over Application.cfm.
Linux is case sensitive. If it is a Linux box then, Application.cfc/cfm will be executed by the ColdFusion application server NOT application.cfc/cfm. So it is always a good habit to use "A" instead of "a" for Application.cfc/cfm.

Link | Top | Bottom

New Post

Please login to post a response.

Replies: 18
MaxwellSmart Joined: 03/23/08 Posts: 21	06/16/08 4:36 PM Hi, I just tried upgrading to version 1.1 from 1.0. If I go to www.domain.com/admin/setup/setup.cfm and follow the instructions I get the following Mango setupp error "Error Executing Database Query. Table 'slauthor' already exists" So I thought I would just try and go to www.domain.com/admin and if I try to log in I get the following CF error "CURRENTROLE.PERMISSIONS is undefined in CURRENTAUTHOR" I'm running Windows 2003 x64 with MySQL 5. Any ideas on what to do? Thanks
	Link \| Top \| Bottom
MaxwellSmart Joined: 03/23/08 Posts: 21	06/16/08 4:45 PM Sorry just realised I was trying to install the full version and not the upgrade. Although this caused the following error instead. "Could not find the ColdFusion Component components.utilities.PreferencesFile. Please check that the given name is correct and that the component exists." Thanks
	Link \| Top \| Bottom
Laura Wizard Joined: 01/29/05 Posts: 1521	06/16/08 4:47 PM Hi, So I should assume your 1.0 install was working, right? Upgrade from 1.0 to 1.1 only required a couple of new files. No changes in the database were done, nor you need to run the installer again... were you sent to the installer after copying the files? What were your steps exactly?
	Link \| Top \| Bottom
Laura Wizard Joined: 01/29/05 Posts: 1521	06/16/08 4:49 PM Ok, so now you downloaded the updated files only. When do you see that error?
	Link \| Top \| Bottom
MaxwellSmart Joined: 03/23/08 Posts: 21	06/16/08 5:06 PM Hi Thanks for quick response. Yes I initially installed the entire 1.1 by mistake but have restored and just installed the upgrade. That error appears when I go to www.domain.com/upgrade.cfm The main site appears and the error appears where a blog post should be. All formated with css....
	Link \| Top \| Bottom
MaxwellSmart Joined: 03/23/08 Posts: 21	06/17/08 9:27 AM I've been playing with this a bit more and I don't quite understand what "components.utilities.PreferencesFile" exactly is. Is it the same as "\components\utilities\Preferences.cfc"? I'm think it may not actually be a CF error as indicated by the original msg, as it is serving the page ok and there is nothing coming up in the CF debug lines. thanks
	Link \| Top \| Bottom
Laura Wizard Joined: 01/29/05 Posts: 1521	06/17/08 11:20 AM Does the file components/utilities/PreferencesFile.cfc exist? (not Preference.cfc)
	Link \| Top \| Bottom
MaxwellSmart Joined: 03/23/08 Posts: 21	06/17/08 1:00 PM No it doesn't. Is this the problem? If so can I download the full version of 1.1 and extract the file from this or will I need the version 1.0 file? Thanks
	Link \| Top \| Bottom
MaxwellSmart Joined: 03/23/08 Posts: 21	06/18/08 4:05 AM Ok - I downloaded the full version and transfer the PreferencesFile.cfc as well as a few others which were missing. The upgrade.cfm file said done when I ran it but now when I try and log into admin I get "Unknown column 'author_blog.role' in 'field list'" Can I just create this? Or will it work if I perhaps delete the entire blog - install the complete 1.1 and then restore my database? thanks
	Link \| Top \| Bottom
Laura Wizard Joined: 01/29/05 Posts: 1521	06/18/08 11:54 AM Hi, I believe you were running 0.2.5 or earlier, not 1.0. Did you install your blog long ago? It would be important to know if it wasn't an earlier install. There were many changes from that version to 1.0/1.1, so it is imperative that you run the upgrade.cfm file included in the other upgrade zip. Since you have already copied the files, you'll have to make a change in the upgrade.cfm file included there: change Preferences to PreferencesFile After that runs successfully, hopefully, I'd recommend to overwrite all your files with those included in the full install. I don't want you to have files of all different versions.
	Link \| Top \| Bottom
MaxwellSmart Joined: 03/23/08 Posts: 21	06/19/08 2:51 AM Thanks Laura - I am fairly sure I installed v1.0 a few weeks ago but could be wrong. But I did try your suggestion of installing 0.25-1.0 and it is now throwing up the following error Element CURRENTROLE.PERMISSIONS is undefined in CURRENTAUTHOR The error occurred in C:\wwwroot\website\www\admin\navigation.cfm: line 5 Called from C:\wwwroot\website\www\admin\layout.cfm: line 67 Called from C:\wwwroot\website\www\admin\index.cfm: line 59 3 : 4 : [b]5 : [/b] 6 :
	Link \| Top \| Bottom
MaxwellSmart Joined: 03/23/08 Posts: 21	06/19/08 2:51 AM Thanks Laura - I am fairly sure I installed v1.0 a few weeks ago but could be wrong. But I did try your suggestion of installing 0.25-1.0 and it is now throwing up the following error Element CURRENTROLE.PERMISSIONS is undefined in CURRENTAUTHOR The error occurred in C:\wwwroot\website\www\admin\navigation.cfm: line 5 Called from C:\wwwroot\website\www\admin\layout.cfm: line 67 Called from C:\wwwroot\website\www\admin\index.cfm: line 5 **CODEBLOCK:1:KCOLBEDOC**
	Link \| Top \| Bottom
MaxwellSmart Joined: 03/23/08 Posts: 21	06/19/08 2:52 AM Thanks Laura - I am fairly sure I installed v1.0 a few weeks ago but could be wrong. But I did try your suggestion of installing 0.25-1.0 and it is now throwing up the following error Element CURRENTROLE.PERMISSIONS is undefined in CURRENTAUTHOR The error occurred in C:\wwwroot\website\www\admin\navigation.cfm: line 5 Called from C:\wwwroot\website\www\admin\layout.cfm: line 67 Called from C:\wwwroot\website\www\admin\index.cfm: line 5 **CODEBLOCK:1:KCOLBEDOC**
	Link \| Top \| Bottom
MaxwellSmart Joined: 03/23/08 Posts: 21	06/19/08 2:53 AM sorry about the multiple posts - was trying to show the full error msg but it won't show using the code tags. but the gist of the error is "Element CURRENTROLE.PERMISSIONS is undefined in CURRENTAUTHOR" please delete misposts.
	Link \| Top \| Bottom
MaxwellSmart Joined: 03/23/08 Posts: 21	06/20/08 10:40 AM I've done a completely fresh install of mango with a brand new database - but I am still getting the above error. Suggestions? Thanks.
	Link \| Top \| Bottom
Laura Wizard Joined: 01/29/05 Posts: 1521	06/20/08 12:16 PM If after a clean install you still see the error do this: open admin/Application.cfc and change the line 7 from: this.name = "mango_#right(hash(GetDirectoryFromPath(GetCurrentTemplatePath())),50)#_v1_1"; to something like: this.name = "mango_#right(hash(GetDirectoryFromPath(GetCurrentTemplatePath())),50)#_v1_1_new";
	Link \| Top \| Bottom
Laura Wizard Joined: 01/29/05 Posts: 1521	06/20/08 12:17 PM By the way, how did you get to make a clean install? Did you go directly to the setup page?
	Link \| Top \| Bottom
MaxwellSmart Joined: 03/23/08 Posts: 21	07/24/08 9:39 AM sorry for the delay. i have now managed to do another clean install which was almost successful. i deleted the original database and all the files and installed mango from scratch. however i then decided to restore my original database which i am now finding out appears to have been a mistake. everything appears normal - but editing existing posts does strange things... for example if i edit a post the changes do not show up on the website. even if i delete a post - the website still shows the post as if it was still there. its not the browser cache as i have tried different machines, browsers, etc. are there changes that i need to do to the database to make this work properly - i am guessing perhaps the problems arise with the idea numbers for entries in the table slentry? thanks
	Link \| Top \| Bottom
elizas Joined: 02/24/10 Posts: 1	02/24/10 4:53 AM Few important tips and notes about Application.cfm/cfc: This is the first ColdFusion file that gets executed by the ColdFusion Application server even if we request for some other file. Example: When we type http://www.mySite.com/index.cfm, Application.cfm/cfc gets executed first and then index.cfm. Application.cfc/cfm and all objects gets instantiated for each server page request. We may or may not have Application.cfc/cfm inside one project web root. Application files are mainly used to set application (global) level objects before executing the server files of the project. What if we are requesting for a ColdFusion file present inside a deep subfolder level? If we have Application.cfc/cfm inside the same folder (where our requested file resides) then the same Application.cfc/cfm will be executed. If we do not have Application.cfm/cfm inside the same folder (where our requested file resides) then ColdFusion application server will search for the Application files in the next higher folder level (backward), it still does not find then one level up till the web root. At any level if it finds the Application files then it will execute that. What if we have both Application.cfc and Application.cfm present in the same folder? Application.cfc will be given more priority (Application.cfm will be ignored) if the ColdFusion version is ColdFusion MX 7 +. If it is any version less that ColdFusion MX 7 then Application.cfm will be given more priority (Application.cfc will be ignored). Reason: Application.cfc got introduced in CFMX 7 version onwards and given more priority over Application.cfm. Linux is case sensitive. If it is a Linux box then, Application.cfc/cfm will be executed by the ColdFusion application server NOT application.cfc/cfm. So it is always a good habit to use "A" instead of "a" for Application.cfc/cfm.
	Link \| Top \| Bottom