CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:




Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.dotnetnuke.getting_started Tags:
Item Type: NewsGroup Date Entered: 11/21/2005 4:32:51 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 0 Views: 28 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
5 Items, 1 Pages 1 |< << Go >> >|
anthonyar
Asp.Net User
Subquery returned more than 1 value11/21/2005 4:32:51 AM

0/0


I appreciate anyone who can give me help with the following error:

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
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: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 

Stack Trace:


[SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.]
   System.Data.SqlClient.SqlDataReader.Read() +176
   DotNetNuke.Globals.ConvertDataReaderToDataTable(IDataReader reader) +227
   DotNetNuke.PortalSettings.GetPortalSettings(Int32 TabId, Int32 PortalId) +402
   DotNetNuke.PortalSettings..ctor(Int32 tabId, Int32 PortalId) +253
   DotNetNuke.Global.Application_BeginRequest(Object sender, EventArgs e) +756
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87




Anthony Alvarado

http://www.anthonyalvarado.info

http://www.mentores.net
anthonyar
Asp.Net User
Re: Subquery returned more than 1 value11/21/2005 5:44:34 AM

0/0

i'm using DNN 2.1 at webhost4life

you can see the error at http://www.ecoleexperience.com/

thanks in advanced


Anthony Alvarado

http://www.anthonyalvarado.info

http://www.mentores.net
MobileNow
Asp.Net User
Re: Subquery returned more than 1 value11/21/2005 6:36:50 AM

0/0

You probobally just upgraded to DNN3.2, right?  There's a problem with the Authentication tab.  What you'll need to do is go to the Tabs table in the database and set its portal id from NULL to the appropiate portal ID.

-Tony Valenti
PowerDNN Hosting is the best

Eliminate DNN Startup Lag
anthonyar
Asp.Net User
Re: Subquery returned more than 1 value11/21/2005 7:18:45 PM

0/0

no i wast try to upgrade it!

it have running very well for a year and now the error just appear.
i dont know if the cause is in the USERS, TABS or another database table

any help will be appreciated!

thanks.


Anthony Alvarado

http://www.anthonyalvarado.info

http://www.mentores.net
anthonyar
Asp.Net User
Re: Subquery returned more than 1 value11/21/2005 10:22:12 PM

0/0

i have resolving the problem looking for the tabs with the same PortalID

i think the problem was for a duplicated tab name

thanks


Anthony Alvarado

http://www.anthonyalvarado.info

http://www.mentores.net
5 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Beginning SQL Authors: Paul Wilton, John W. Colby, Pages: 501, Published: 2005
Learning SQL Authors: Alan Beaulieu, Pages: 289, Published: 2005
Learning SQL on SQL Server 2005 Authors: Sikha Bagui, Richard Earp, Pages: 324, Published: 2006
Programming Data-driven Web Applications with ASP.NET Authors: Don Wolthuis, Donny Mack, Doug Seven, Pages: 704, Published: 2002
Oracle Database 10g SQL: Master SQL and PL/SQL Authors: Jason Price, Pages: 608, Published: 2004
Oracle Database 11g SQL: Master SQL and PL/SQL in the Oracle Database Authors: Jason Price, Pages: 656, Published: 2007
MySQL in a Nutshell Authors: Russell Dyer, Pages: 545, Published: 2008
The Guru's Guide to Transact-SQL Authors: Ken Henderson, Pages: 551, Published: 2000
Sams Teach Yourself Mysql in 10 Minutes Authors: Chris Newman, Pages: 277, Published: 2006
Code Centric: T-SQL Programming with Stored Procedures and Triggers Authors: Garth Wells, Pages: 692, Published: 2001

Web:
Subquery returned more than 1 value - Tony Rogerson's ramblings on ... May 31, 2006 ... Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an ...
Subquery returned more than 1 value error - MSDN Forums But I can't figure out for the life of me how I even have a subquery, much less how it's returning more than 1 value. My entire SQL statement follows: ...
Subquery returned more than 1 value. This is not permitted when ... Subquery returned more than 1 value. This is not permitted when the subquery follows. Get answers to your questions in our Microsoft SQL ...
SQL Server programming Stored Procedure - Subquery returned more ... By the way, the error message is "Subquery returned more than 1 value. This is not permitted when the subquery follows =, ! ...
Subquery returned more than 1 value : more, returned, than, 1, value Dear all, I know this question has been asked many times, but I still got the error after tried their solution. I have MS sql Db table named [Testing] ...
Update trigger !!!! Subquery returned more than 1 value [Archive ... Server: Msg 512, Level 16, State 1, Procedure emp_lock_id, Line 8 > Subquery returned more than 1 value. This is not permitted when the ...
'Subquery returned more than 1 value' error on UPDATE - ASP.NET Forums I keep getting the 'Subquery returned more than 1 value' error. Is there really no way of updating several or all records in a table at once ...
Subquery returned more than 1 value Error... im getting a 'Subquery returned more than 1 value Error' because there are two rows of xml in the @tempLogicalTable... how can i get this to work, ...
System.Data.SqlClient.SqlException: Subquery returned more than 1 ... Data.SqlClient.SqlException: Subquery returned more than 1 value. ... Data. SqlClient.SqlException: Subquery returned more than 1 value. ...
RE: Subquery returned more than 1 value. This is not permitted wh ... Subject: RE: Subquery returned more than 1 value. This is not permitted wh en the subquery follows =, !=, <, <= , >, >= Date: Tue, 6 Jul 2004 10:54:38 -0500 ...




Search This Site:










http error 401.1 - unauthorized: access is denied due to invalid credentials.

authentication with windows and forms together

dynamically setting the webpartslistusercontrolpath

how to define gridview paramaters for update sql

can't install ttt.authentication module! help!!!

having same controls two times in a page

unhändled exception

need for dnn installers

trying to figure out...

greek dotnetnuke community

how do i inherit more then 1 class into my current class

problem with opening microsoft sql server manadement studio

forms authentication timeout event?

word to the wise on sql logs... performance issues

ctlurl issue in custom module

editing a php based website

i get "the stored procedure 'dbo.adddesktopmodule' doesn't exist" error installing 3.012 and 3.013. version 2.12 installs fine.

asp hosting recommendation

protecting pdf files

how to create directory listing and show link

ibuyspy store hosting problem

wp desing for not autenticated needed!

string functions

3.0.9 tease...

grid layout gone

ide settings error

deleting the user configured in machine.config

vs 2005 error

an error occurred while try to load the string resources (getmodulehandle failed with error -2147023899).

access dataprovider - code smith templates

 
All Times Are GMT