Error when work with contents / add module to page ....

[GoogleCodeExporter]

What steps will reproduce the problem?
1. When you try to work with contents
2. Add new module
3.

What is the expected output? What do you see instead?
Error:

Exception System.Web.HttpUnhandledException: Exception of type 
'System.Web.HttpUnhandledException' was thrown. ---> 
System.Data.SqlClient.SqlException: Invalid object name 'rb_Tabs'. at 
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, 

What version of the product are you using? On what operating system?
RainbowPortal2.0.Beta1.7z

Please provide any additional information below.

in old versions there was a table called "rb_Tabs" (Invalid object 
name 'rb_Tabs'. ) which now not exists in the new database 
installation, instead there is new one called rb_pages, so some stored 
procedures are not working 

Fixes:
you have to update 2 stored procedures as in attached file :

rb_ContentMgr_GetModuleInstances
rb_ContentMgr_GetModuleInstancesExc

now works fine

Original issue reported on code.google.com by GhalibGhniem on 21 Feb 2010 at 9:46

Attachments:

• rainbowdbsql.txt

[GoogleCodeExporter]

fix committed for RainbowPortal2.0.Beta1.7z
https://rainbow.googlecode.com/svn/NET_2_0/stage/trunk
rev. 409 

Original comment by moudr...@gmail.com on 8 Mar 2010 at 9:03

• Changed state: Started

[GoogleCodeExporter]

fix committed for 2.1 devint
https://rainbow.googlecode.com/svn/NET_2_0/devint/trunk
rev. 412
db version 1884

Original comment by moudr...@gmail.com on 8 Mar 2010 at 7:52

• Changed state: Fixed

[GoogleCodeExporter]

Moudrick, 

I am using DB version 1885 on SQL Server 2008 and using the builtin web server 
for vs 
2010 and I'm getting this error 

Do you think if I downgraded to 2005 it will work?

--
2.0.0.1884.sql

Invalid object name 'dbo.rb_ContentMgr_GetModuleInstances'.
-- see issue #79 -- http://code.google.com/p/rainbow/issues/detail?id=79 ALTER 
PROCEDURE [dbo].[rb_ContentMgr_GetModuleInstances] ( @ItemID int, @PortalID int 
) AS 
SELECT ModuleID,(PageName + '\' + ModuleTitle) AS TabModule FROM 
rb_ContentManager,rb_ModuleDefinitions,rb_Modules,rb_Pages WHERE 
rb_ContentManager.ItemID = @ItemID AND rb_ContentManager.SourceGeneralModDefID 
= 
rb_ModuleDefinitions.GeneralModDefID AND rb_ModuleDefinitions.ModuleDefID = 
rb_Modules.ModuleDefID AND rb_ModuleDefinitions.PortalID = @PortalID AND 
rb_Modules.TabID = rb_Pages.PageID ORDER BY 
rb_Pages.PageName,rb_Modules.ModuleTitle

ExecuteScript Failed: -- see issue #79 -- 
http://code.google.com/p/rainbow/issues/detail?id=79 ALTER PROCEDURE 
[dbo].[rb_ContentMgr_GetModuleInstances] ( @ItemID int, @PortalID int ) AS 
SELECT 
ModuleID,(PageName + '\' + ModuleTitle) AS TabModule FROM 
rb_ContentManager,rb_ModuleDefinitions,rb_Modules,rb_Pages WHERE 
rb_ContentManager.ItemID = @ItemID AND rb_ContentManager.SourceGeneralModDefID 
= 
rb_ModuleDefinitions.GeneralModDefID AND rb_ModuleDefinitions.ModuleDefID = 
rb_Modules.ModuleDefID AND rb_ModuleDefinitions.PortalID = @PortalID AND 
rb_Modules.TabID = rb_Pages.PageID ORDER BY 
rb_Pages.PageName,rb_Modules.ModuleTitle
Invalid object name 'dbo.rb_ContentMgr_GetModuleInstances'.

--

Original comment by rahul.xa...@gmail.com on 1 Jun 2010 at 9:45

[GoogleCodeExporter]

I'm removing [dbo] from the alter statements so that it installs on SQL Server 
2008 on 
a remote db server. 

Original comment by rahul.xa...@gmail.com on 2 Jun 2010 at 12:38