[Rainbowportal-devel] [RBJIRA] Closed: (RBP-576) rb_Modules.ModuleTitle SQL init error in SQL 2005

[<ji...@ra...>]

Message:

   The following issue has been closed.

   Resolver: Jos=C3=A9 Viladiu
       Date: mar, 18 gen 2005 2:38 PM

SQL 2005 still in beta. Nothing to fix in this version
---------------------------------------------------------------------
View the issue:
  http://support.rainbowportal.net/jira/browse/RBP-576

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: RBP-576
    Summary: rb_Modules.ModuleTitle SQL init error in SQL 2005
       Type: Bug

     Status: Closed
   Priority: Minor
 Resolution: WON'T FIX

    Project: Rainbow Portal
 Components:=20
             Installation
   Fix Fors:
             1.6
   Versions:
             1.4
             1.3
             1.5

   Assignee: Emmanuele De Andreis
   Reporter:=20

    Created: lun, 20 dic 2004 9:01 AM
    Updated: mar, 18 gen 2005 2:38 PM
Environment: SQL 2005

Description:
rb_Modules.ModuleTitle

Not sure why this happens when I install Rainbow... created the DB fine in =
SQL 2005 latest release but when opening site initially and it is creating =
tables, I get this:

      1.1.7.1111.sql

      Multi-part identifier 'rb_Modules.ModuleTitle' could not be bound.=20
ORDER BY items must appear in the select list if the statement contains a=
=20
UNION operator.
      CREATE PROCEDURE rb_GetModulesByName ( @ModuleName varchar(128),=20
@PortalID int ) AS SELECT 0 ModuleID, ' Nessun modulo' ModuleTitle UNION=20
SELECT rb_Modules.ModuleID, rb_Modules.ModuleTitle FROM=20
rb_GeneralModuleDefinitions INNER JOIN rb_ModuleDefinitions ON=20
rb_GeneralModuleDefinitions.GeneralModDefID =3D=20
rb_ModuleDefinitions.GeneralModDefID INNER JOIN rb_Modules ON=20
rb_ModuleDefinitions.ModuleDefID =3D rb_Modules.ModuleDefID WHERE=20
(rb_ModuleDefinitions.PortalID =3D @PortalID) AND=20
(rb_GeneralModuleDefinitions.FriendlyName =3D @ModuleName) ORDER BY=20
rb_Modules.ModuleTitle

      Multi-part identifier 'rb_Modules.ModuleTitle' could not be bound.=20
ORDER BY items must appear in the select list if the statement contains a=
=20
UNION operator.







Msg 4104, Level 16, State 1, Procedure rb_GetModulesByName, Line 9

Multi-part identifier 'rb_Modules.ModuleTitle' could not be bound.

Msg 104, Level 16, State 1, Procedure rb_GetModulesByName, Line 9

ORDER BY items must appear in the select list if the statement contains a=
=20
UNION operator.

Msg 4104, Level 16, State 1, Procedure rb_GetModulesAllPortals, Line 5

Multi-part identifier 'rb_Modules.ModuleTitle' could not be bound.

Msg 104, Level 16, State 1, Procedure rb_GetModulesAllPortals, Line 5

ORDER BY items must appear in the select list if the statement contains a=
=20
UNION operator.

Msg 4104, Level 16, State 1, Procedure rb_GetModulesByName, Line 8

Multi-part identifier 'rb_Modules.ModuleTitle' could not be bound.

Msg 104, Level 16, State 1, Procedure rb_GetModulesByName, Line 8

ORDER BY items must appear in the select list if the statement contains a=
=20
UNION operator.

Msg 4104, Level 16, State 1, Procedure rb_GetModulesSinglePortal, Line 7

Multi-part identifier 'rb_Modules.ModuleTitle' could not be bound.

Msg 104, Level 16, State 1, Procedure rb_GetModulesSinglePortal, Line 7

ORDER BY items must appear in the select list if the statement contains a=
=20
UNION operator.

(0 row(s) affected)

(0 row(s) affected)



---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://support.rainbowportal.net/jira/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira