Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
2 Pages12>
Sql Server 2008 upgradation isse
Options
Previous Topic Next Topic
kaustubh007
#1 Posted : Monday, December 26, 2011 10:48:42 AM(UTC)
Rank: Member
Groups: Registered

Joined: 12/22/2011(UTC)
Posts: 24
Location: new delhi
I am trying to change the provider from xml to the Sql Server 2008 R2 database. But I am getting this error

Could not load type 'Kooboo.CMS.Content.Persistence.Default.WorkflowHistoryProvider' from assembly 'Kooboo.CMS.Content, Version=3.0.2.2, Culture=neutral, PublicKeyToken=null'.

The steps I have followed is as follows:

1. I have copied the Kooboo.CMS.Content.Persistence.SQLServer.dll and SqlServer to the bin folder .
2. I have updated the SqlServer config file with the server configration.
3. Restarted the application


Can you tell where's it wrong.. and how this issue can be resolved??

Thanks
Kaustubh Shukla
Back to top
jifeng
#2 Posted : Monday, December 26, 2011 12:49:11 PM(UTC)
Rank: Administration
Groups: Administrators, Registered

Joined: 9/3/2009(UTC)
Posts: 1,555
Location: Xiamen China
I think you used the wrong version, please download the match version.
Regards,

Jifeng Huang

Kooboo Team

Microsoft ASP.NET MVP
Back to top
WWW BLOG
kaustubh007
#3 Posted : Tuesday, December 27, 2011 6:36:38 AM(UTC)
Rank: Member
Groups: Registered

Joined: 12/22/2011(UTC)
Posts: 24
Location: new delhi
After adding correct dlls and sqlServer config to the project .. I am getting the following error after doing login to my CMS app.



what's the reason of this? Do I need to add the connection string to the main application web config.
Back to top
jifeng
#4 Posted : Tuesday, December 27, 2011 9:44:57 AM(UTC)
Rank: Administration
Groups: Administrators, Registered

Joined: 9/3/2009(UTC)
Posts: 1,555
Location: Xiamen China
You need to add the connection string in the SQLServer.config under the bin folder.
Regards,

Jifeng Huang

Kooboo Team

Microsoft ASP.NET MVP
Back to top
WWW BLOG
kaustubh007
#5 Posted : Tuesday, December 27, 2011 12:18:08 PM(UTC)
Rank: Member
Groups: Registered

Joined: 12/22/2011(UTC)
Posts: 24
Location: new delhi
I have added the connectionstring to the webconfig. and able to view the site cluster page after login. how can I configure kooboo CMS to use sql server provider not xml provider.
Back to top
jifeng
#6 Posted : Wednesday, December 28, 2011 6:34:50 AM(UTC)
Rank: Administration
Groups: Administrators, Registered

Joined: 9/3/2009(UTC)
Posts: 1,555
Location: Xiamen China
http://www.kooboo.com/Do...QLCE-RavenDB-and-MongoDB
Regards,

Jifeng Huang

Kooboo Team

Microsoft ASP.NET MVP
Back to top
WWW BLOG
kaustubh007
#8 Posted : Wednesday, December 28, 2011 10:07:48 AM(UTC)
Rank: Member
Groups: Registered

Joined: 12/22/2011(UTC)
Posts: 24
Location: new delhi
Let me 1st summerize steps I followed so far:

I copied the following DLL files to the bin folder of the Kooboo CMS:

Kooboo.CMS.Account.Persistence.SqlSever.dll
Kooboo.CMS.Content.Persistence.SQLServer.dll
Kooboo.Connect.Providers.SqlServer.dll
EntityFramework.dll

tried to removing
Kooboo.CMS.Account.dll
Kooboo.CMS.Content.dll
Kooboo.Connect.dll

But got error
Could not load file or assembly 'Kooboo.Connect, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.

So didn't remove these files.

After that I run the SqL script to add CMS data tables to the database. Then I copied the SQLServer.config file with the following settings.

Quote:
<SqlServerSettings xmlns="http://schemas.datacontract.org/2004/07/Kooboo.CMS.Content.Persistence.SqlServer" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
<Connections>
<ConnectionSetting>
<ConnectionString>Data Source=xxxxx;Initial Catalog=Book_Test;User ID=xxxx;Password=xxxx;</ConnectionString>
<Name>Sample</Name>
</ConnectionSetting>
</Connections>
<CreateDatabaseSetting></CreateDatabaseSetting>
<SharingDatabase>true</SharingDatabase>
<SharingDatabaseConnectionString>Data Source=xxxxx;Initial Catalog=Book_Test;User ID=xxxx;Password=xxxx;</SharingDatabaseConnectionString>
</SqlServerSettings>


I also add the also added the 2 connection strings in the main application config.

After this I restarted my web application. When I run the CMS app. , After I login and create new website and try to export the website or do anything related to database. It gives me

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'book_test.Article'.

I think page information isn't getting added to the Database because there's no record of these, Am I missing something? Please let me know...

Regards,
Kaustubh Shukla
Back to top
kaustubh007
#9 Posted : Wednesday, December 28, 2011 11:17:44 AM(UTC)
Rank: Member
Groups: Registered

Joined: 12/22/2011(UTC)
Posts: 24
Location: new delhi
I have also tried with the following SqlServer.config

Quote:
<SqlServerSettings xmlns="http://schemas.datacontract.org/2004/07/Kooboo.CMS.Content.Persistence.SqlServer" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
<Connections>
<ConnectionSetting>
<ConnectionString>Data Source=xxxxx;Initial Catalog=Book_Test;User ID=xxxx;Password=xxxx;</ConnectionString>
<Name>Sample</Name>
</ConnectionSetting>
</Connections>
<CreateDatabaseSetting>Data Source=xxxxx;Initial Catalog=Book_Test;User ID=xxxx;Password=xxxx;</CreateDatabaseSetting>
<SharingDatabase>true</SharingDatabase>
<SharingDatabaseConnectionString>Data Source=xxxxxx;Initial Catalog=Book_Test;User ID=xxxx;Password=xxxx;</SharingDatabaseConnectionString>
</SqlServerSettings>
Back to top
jifeng
#10 Posted : Wednesday, December 28, 2011 11:33:45 AM(UTC)
Rank: Administration
Groups: Administrators, Registered

Joined: 9/3/2009(UTC)
Posts: 1,555
Location: Xiamen China
HI

You just need to copy this file:Kooboo.CMS.Content.Persistence.SQLServer.dll. DO NOT remove any file under the BIN folder!
Regards,

Jifeng Huang

Kooboo Team

Microsoft ASP.NET MVP
Back to top
WWW BLOG
kaustubh007
#11 Posted : Wednesday, December 28, 2011 12:00:48 PM(UTC)
Rank: Member
Groups: Registered

Joined: 12/22/2011(UTC)
Posts: 24
Location: new delhi
I added the other 2 DLL so that I can store CMS credentials to the database too. I got the same

System.Data.SqlClient.SqlException: Invalid object name 'book_test.Article'.


problem after remove other two DLLs


one more question, if I am using shared database mode, do I still need to specify the <CreateDatabaseSetting></CreateDatabaseSetting>?? can't we left it blank?


Regards,

Kaustubh Shukla
Back to top
jifeng
#12 Posted : Wednesday, December 28, 2011 12:40:24 PM(UTC)
Rank: Administration
Groups: Administrators, Registered

Joined: 9/3/2009(UTC)
Posts: 1,555
Location: Xiamen China
1. The message told you, you setup the sql server provider successfully,
but the sample site cannot found the dynamic table. Solution is: Recreate
the site, OR Export the site in the XML version then import the site into
the sql server version.


2. You can ignore the CreateDatabaseSetting setting when you use shared
database mode.
Regards,

Jifeng Huang

Kooboo Team

Microsoft ASP.NET MVP
Back to top
WWW BLOG
kaustubh007
#13 Posted : Thursday, December 29, 2011 5:44:41 AM(UTC)
Rank: Member
Groups: Registered

Joined: 12/22/2011(UTC)
Posts: 24
Location: new delhi
I created the new website giving Database name in Website configuration window same as SQL server database name. Still I got the same error page. Meanwhile, I also tried to delete all the sample pages from the newly created website and then create a new page, still got the error

System.Data.SqlClient.SqlException: Invalid object name 'book_test.__ContentCategory'

how can I solve this issue? I am also not seeing any page related information in the database

Regards,
Kaustubh Shukla
Back to top
 |  Edit by user
jifeng
#14 Posted : Thursday, December 29, 2011 12:57:00 PM(UTC)
Rank: Administration
Groups: Administrators, Registered

Joined: 9/3/2009(UTC)
Posts: 1,555
Location: Xiamen China
Please create a fresh site on the kooboo cms with sql server.
Regards,

Jifeng Huang

Kooboo Team

Microsoft ASP.NET MVP
Back to top
WWW BLOG
kaustubh007
#15 Posted : Friday, December 30, 2011 7:13:47 AM(UTC)
Rank: Member
Groups: Registered

Joined: 12/22/2011(UTC)
Posts: 24
Location: new delhi
Hi jifeng,

I tried to create a fresh site on the kooboo CMS . I got the same error. that's why I asked you again. Can you brief about configuring the fresh site with sql server. I think somewhere I am doing wrong in setting up new site.


Thanks & Regards,
Kaustubh Shukla
Back to top
jifeng
#16 Posted : Friday, December 30, 2011 8:04:15 AM(UTC)
Rank: Administration
Groups: Administrators, Registered

Joined: 9/3/2009(UTC)
Posts: 1,555
Location: Xiamen China
I think you need to delete the "test" site first.
Regards,

Jifeng Huang

Kooboo Team

Microsoft ASP.NET MVP
Back to top
WWW BLOG
kaustubh007
#17 Posted : Tuesday, January 03, 2012 11:58:04 AM(UTC)
Rank: Member
Groups: Registered

Joined: 12/22/2011(UTC)
Posts: 24
Location: new delhi
Hi Jifeng,

First of all, Happy New Year,

I tried by deleting the 'test' site first. Still the same problem. Can you brief me about steps to be taken to build a new website when we are using Sql Server database not xml provider?

Thanks & Regards,
Kaustubh Shukla
Back to top
jifeng
#18 Posted : Tuesday, January 03, 2012 12:55:22 PM(UTC)
Rank: Administration
Groups: Administrators, Registered

Joined: 9/3/2009(UTC)
Posts: 1,555
Location: Xiamen China
1. Unzip the Kooboo_CMS.zip into a new folder.

2. Remove the "Sites" and "Contents" folder under the Cms_Data folder.

3. Copy the Kooboo.CMS.Content.Persistence.SqlServer.dll and SqlServer.config into the bin folder.(You can get them from the Content_Providers.zip)

4. Create a empty database called Kooboo_CMS on the SQL server.

5. Update the SQLServer.config, to fill the sharing connection string.

Good luck.
Regards,

Jifeng Huang

Kooboo Team

Microsoft ASP.NET MVP
Back to top
WWW BLOG
kaustubh007
#19 Posted : Wednesday, January 04, 2012 1:41:25 PM(UTC)
Rank: Member
Groups: Registered

Joined: 12/22/2011(UTC)
Posts: 24
Location: new delhi
Hi jifeng,

Thanks, now I haven't got any error this time. But still when I try to create a new page in my website, it is been saved on the disk not in my sql server database. I think something is still missing out. What's the reason of this? how can I solve this issue?

I am using Kooboo CMS 3.0.2.2

Thanks & regards,
Kaustubh Shukla
Back to top
jifeng
#20 Posted : Wednesday, January 04, 2012 2:02:32 PM(UTC)
Rank: Administration
Groups: Administrators, Registered

Joined: 9/3/2009(UTC)
Posts: 1,555
Location: Xiamen China
Why don't you use the lastest version?
Regards,

Jifeng Huang

Kooboo Team

Microsoft ASP.NET MVP
Back to top
WWW BLOG
kaustubh007
#21 Posted : Wednesday, January 04, 2012 2:38:33 PM(UTC)
Rank: Member
Groups: Registered

Joined: 12/22/2011(UTC)
Posts: 24
Location: new delhi
That's because my CMS is already in production environment. is there any limitation with this version regarding MS Sql Server database??


Thanks & Regards,
Kaustubh Shukla
Back to top
 |  Edit by user
Users browsing this topic
Guest
2 Pages12>
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.220 seconds.