MonoX support board

Start the conversation, ask questions and share tips and solutions with fellow developers.

Non-registered users can only browse through our support boards. Please register now if you want to post your questions. It takes a second and it is completely free. Alternatively, you can log in without registration using your credentials at major sites such as Google, Microsoft Live, OpenId, Facebook, LinkedIn or Yahoo.

Monox Upgrade issues. Latest version. (Closed) (Mono Support )

Viewed 49528 time(s), 3 post(s) 6/29/2011 3:26:56 PMby shawndg

Related topics

shawndg

shawndg

6/29/2011 3:26:56 PM
Hello,

I decided that it was time for me to upgrade my Monox installation today..

Ok so I uploaded and had a issue with the web config.. had to replace one section so far..

had to replace the section with this updated section..

<RssStorage defaultProvider="RequestRssStorageProvider">
<providers>
<add name="DiskRssStorageProvider" type="MonoSoftware.Web.RssEngine.Providers.DiskRssStorageProvider, MonoX" workingFolder="/MonoX/ApplicationData/RssStorage" sqlConnectionString="" timeout="30"/>
<add name="CacheRssStorageProvider" type="MonoSoftware.Web.RssEngine.Providers.CacheRssStorageProvider, MonoX" workingFolder="" sqlConnectionString="" timeout="30"/>
<add name="RequestRssStorageProvider" type="MonoSoftware.Web.RssEngine.Providers.RequestRssStorageProvider, MonoX" workingFolder="" sqlConnectionString="" timeout="30"/>
</providers>
</RssStorage>

after I updated that section I was able to operate basic monox.. but since then I have been unable to view profiles.. and there may be more errors as well.

when i go to view a profile I get the following error.

Invalid column name 'Abrv'. Description:
An unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the error and
where it originated in the code.

Exception Details:
System.Data.SqlClient.SqlException: Invalid column name 'Abrv'.

Now this quickly points to a problem with the database..
So.. is there any easy to update database scripts ?

I remember some stuff about the installer but I never done a upgrade like this before..
So any way you can point me in the right direction to how to properly update my database ?

This content has not been rated yet. 
1871 Reputation 252 Total posts
shawndg

shawndg

6/29/2011 3:41:06 PM
Ok..

figured it out.. prob not the best way but here what I found..

I looked into the monox/installer.upgradescripts. and could clearly see the paths of the scripts I had to run..

since I only upgrades from the prev version.. I only had one script to run..


ALTER TABLE PrivacyLevel ADD Abrv nvarchar(50) NULL
GO
UPDATE [dbo].[PrivacyLevel]
SET [Abrv] = [PrivacyLevel]
GO
ALTER TABLE dbo.PrivacyLevel Alter Column Abrv nvarchar(50) NOT NULL

Once I ran this script.. all is good so far..

This content has not been rated yet. 
1871 Reputation 252 Total posts
denis

denis

6/29/2011 9:23:10 PM
Hi Shawn,
There is a detailed article that describes the manual upgrade process: http://www.mono-software.com/Blog/post/Mono/86/Upgrading-to-new-MonoX-version/
You were on the right track - the main tasks that need to be done include web.config synchronization and running the SQL upgrade scripts.
This content has not been rated yet. 
7207 Reputation 956 Total posts