New Install 1.0.9, Can't find "GetPortalSettings" sproc error

I have read all of the threads with the "Can't find GetPortalSettings stored procedure" error.  Can't seem to find the fix.

I have SQL 2000 Server, MachineName/ASPNET account has full control of the dotnetnuke directory, the stored procedure has been corrected in the .9 version for the .[Level] error.
Whats left? Anyone
0
PLord
6/4/2003 12:38:27 AM
asp.net.dotnetnuke 25171 articles. 0 followers. Follow

7 Replies
649 Views

Similar Articles

[PageSpeed] 57
Get it on Google Play
Get it on Apple App Store

if you had the xml skins in your system from 108 when you upgraded, you will need to remove the skins before upgrading.  this is only two sprocs.. getportalsettings and updateportalinfo.


Intuition without concept is blind; Concept without intuition is empty -- I. Kant : Critique of Pure Reason

In the olden days, books were burned. Now the website is shut down.

KodHedZ Software Development
0
xpdit
6/4/2003 2:23:28 AM
Thanks xpdit,

Actually my config is a new install not an upgrade. What I failed to tell you, however, is that I ran the sql database scripts manually. I am not actually sure of the steps and proper order to doing a clean install. Can you point me to a complete and concise enumeration of the procedure? Somehow I am fouling up the process to get the scripts to install automatically.
Here is my procedure:
create c:\dotnetnuke folder
assign full control permissions in c:\dotnetnuke to the MACHINENAME\ASPNET account
assign full control permissions in c:\dotnetnuke to my user account with Admin Permissions
create new "dotnetnuke" db in SQL Server 2000
unzip 1.0.9 to c:\dotnetnuke
create new virtual directory pointing to c:\dotnetnuke
verify that virdir is properly configured as application
modify the web.config file connection string: Trusted_Connection=true; replaces uid=;pwd=;
When are the scripts supposed to run?
Are there any prerequisites, such as preparing the SQL db, in some way, for accepting the scripts?
Since they did not run up until this point I run all of them manually with Query Analyzer.
Does compiling the project in VS.Net perform necessary tasks?
0
PLord
6/4/2003 11:30:04 PM
the MACHINENAME\ASPNET user needs rights to the database (using Windows Security) for trusted connection use.  I give it db_owner rights when I use it.

Jeremy
Jeremy White
Webstone, LLC
My DNN Blog
0
jwhite
6/5/2003 1:25:36 AM
I got the same error, I have some info but I need help too

from what I know once you create the initial database and run the portal
http://localhost/dotnetnuke. it connect to the db and creates all the tables, stored procedures and enters the initial data for the default portal.
after i got my error i went to the database server and noticed that about 15 stored procedures were missing,
so i tryied to copy the stored procedure code and manually create the stored procedure using Query analyzer
i then got this error
Server: Msg 156, Level 15, State 1, Procedure GetPortalSettings, Line 87
Incorrect syntax near the keyword 'Level'.
basically there is a field called Level in the tabs table and it seems that level is a RESERVED keyword on the server i'm trying to update to.
the portal was not able to create this stored procedure on the server is what it boils down too.
thiss server is a SQL 7.0 server.
I have got this working great on a 2000 sql server.
how do i check the reserved keywords on a sql 7.0 server.
can someone validate my research for me please.

here are some answers i have found about this issue
http://www.aspplayground.net/forum/Error_Messages_while_setting_up_the_database_script!/m_376136/p_1/tmode_5/smode_1/tm.htm
0
nestor_vives
7/19/2003 5:32:31 AM
I had the same error and this worked for my error

Add to the top of the sql script
SET QUOTED_IDENTIFIER OFF
GO
---------------------------------------
then replace every instance of the word level with [level]
brackets are the key
0
nestor_vives
7/19/2003 5:53:28 AM
Hi,

I also got into this problem but solved it. You just need to delete the Virtual Directory
and recreate it before you retry after correcting your connection string.
Before your second attempt make sure to set up correct connnection string in web.config
<add key="connectionString" value="Server=localhost;Database=DotNetNuke;uid=;pwd=;" />
<!-- database connection details -->
Cheers
nukemount
0
nukemount
7/21/2003 3:16:35 PM

I also had to replace 1 instance of keyword "LEVEL" with "[LEVEL]" in GetTabById.
Setup ran fine after this.
0
sspanogle
8/22/2003 6:36:15 PM
Reply:

Similar Artilces:

New Suse install w/factory disks "can't find CD 1"
Hello, I have some Novell produced disks of SuSE Linux 10.0 from the Boxed version -(I know, I should get a current version, it's what my company provides & mandates for now, I'll chase getting a current version along with this, anyway...)- I've done hundreds of Linux installs, some of these have been SuSE installs, and in this case, I'm using the DVD install disk and receive an error stating that the install program can not find CD1 (yes, with the DVD in the tray). So I replace the DVD with the Novell produced CDs of SuSE and repeat this with CD 1. Sa...

USB-DVD: "Can't find the openSUSE Repository", can't install.
Greetings, A happy openSUSE user on my laptop, I want to use it on a new desktop computer / home server. It doesn't have an optical drive, so I've created a bootable USB stick out of a DVD ISO, based on the instructions at 'SDB:Live USB stick - openSUSE' (http://tinyurl.com/7zyvyt5) I can boot without problem from the USB stick, but I'm getting the error "Could not find the openSUSE Repository. Activating manual setup program". It then leads me to a basic, text-only interface, but I can't continue the install. A helpful soul in #suse suggeste...

mysql 5.0.24 gives error "Can't find messagefile '\MYSQL\bin/\MYSQL\bin/sys:/mysql/share/english/errmsg.sys'"
Hi All I've just tried to do a small mysql update to 5.0.24, but it gives me an error: Can't find messagefile '\MYSQL\bin/\MYSQL \bin/sys:/mysql/share/english/errmsg.sys' I've tried adding basedir=sys:/mysql to the my.cnf: [mysqld] default-character-set=latin1 language=english bind-address=0.0.0.0 port=3306 datadir=web:/mysqldb basedir=sys:/mysql skip-locking skip-innodb but it didn't do any difference, does anybody have an idea to this? NetwareGuy, It appears that in the past few days you have not received a response to your posting. That co...

Re: mysql 5.0.24 gives error "Can't find messagefile '\MYSQL\bin/\MYSQL\bin/sys:/mysql/share/english/errmsg.sys'"
Is there a solution for this? Netware Guy posted it on 05 Aug 06. Thanks. ...

"cannot find page" error: can't install anything.
I hate that my first post to the forums here is a support question. I hoped I could say "hi" in the Something other than support sub forum first. anyway I'm new to openSUSE and am having problems installing new packages. I haven't found a solution with google or the search box here at at the forum. Every time I try to install something I get a series of "cannot find page" errors after the package downloads. It doesn't seem to matter whether it's a one click install, downloaded rpm package or directly through Yast. When I installed Open...

New Install: <?xml version="1.0" encoding="UTF-8" ?> error
Hi,I'm new to .net.  I'm trying to install DotNetNuke on my XP Pro with IIS 5.0 box.  I've made all the changes to web.config, created the db with permissions and I'm still getting the same error.Can't figure it out!Here's the error:  Server Error in '/DotNetNuke' Application. Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parser Error Message: Stream is not a valid resource file.Source Error: Line 1...

Can't get New TB Install to Find "Old" Files
My Win 7-64 C: crashed - installed a new drive, installed TB, but can't get it to find all the Mail that was always stored on F: - in fact, if I look in F:/Thunderbird/Mail/Local Folders I see all the *.sbd folders each of which has all their own *.sbd folders, but each of those is empty. I admit I don't fully understand the profile arrangements - I've tried to work through the MOVE YOUR PROFILE pages but had no luck. I can't be the first person to whom this has happened - is there a thread somewhere (that I haven't found) that will step me through this recovery ....

Can't install DBI on WinNT
Hi, I've fallen at the first hurdle while trying to install the DBI module. I've run Makefile.pl, however my system doesn't recognise the "make" command which the readme.txt states that I should run. I've also tried to install the package via PPM (ActivePerl v 617), however it can't find the DBI module or any other module. Any ideas? Thanks Chris Perl / SGML Developer e-access Public Record Office, Kew Richmond Surrey, TW9 4DU UK Tel: (0208) 392 5300 ext 2213 http://www.pro.gov.uk/ --------------------------------------------------...

I couldn't install Visual Studio.Net 2003, while installing an error message "Internal Error is comming"
[DMW: deleted due to the length of the log, and what follows is what's important][09/29/05,14:28:23] Visual Studio .NET Enterprise Architect 2003 - English: ***ERRORLOG EVENT*** : ACTION FAILURE: Action ended 14:28:23: CADpc.D0DF3458_A845_11D3_8D0A_0050046416B9. Return value 3. See MSI log for details.[09/29/05,14:28:23] Visual Studio .NET Enterprise Architect 2003 - English: ***ERRORLOG EVENT*** : ACTION FAILURE: Action ended 14:28:23: INSTALL. Return value 3. See MSI log for details.[09/29/05,14:28:30] Visual Studio .NET Enterprise Architect 2003 - English: MsiInstallProduct return cod...

After instllation of 3.0.5 Lots of "can't find page" errors
Name: John Ingram Email: sylop729athotmaildotcom Product: Firefox Summary: After instllation of 3.0.5 Lots of "can't find page" errors Comments: since installing .5 several times a day when going from one webpage to another click on bookmark and end up with an error page saying "FF can't find page try BLA BLA. click the same link again and page loads fine. Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5 From URL: http://hendrix.mozilla.org/ Note to readers: Hendrix gives no expectation of a...

qpsmtpd installation help
------=_NextPart_000_0039_01C26008.21EAB530 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit After increasing the verbosity of the logs I am getting this error message. Can't locate object method "new" via package "Qpsmtpd::TcpServer" at /usr/home/smtpd/qpsmtpd/qpsmtpd line 22. Have I missed something, I am running v.10 from cvs. Thanks, Max ------=_NextPart_000_0039_01C26008.21EAB530-- On Thu, Sep 19, 2002 at 06:12:36PM -0700, Max Clark wrote: > After increasing the verbosity of the logs I am gettin...

[Software Error] Can't locate object method "new" via package "Bugzilla::Template" at Bugzilla/Template.pm line 977
Hi, Yesterday I downloaded latest stable version (4.2.1) of bugzilla and I resolved all dependencies even checksetup.pl also run successfully I also checked testagent.cgi which also show OK. but when I use index.cgi, It is showing error which is in subject line. I searched in google and found one suggestion "may be code corrupted" but I downloaded again and did md5sum on file, every thing looks as expected. Can someone please tell me why that behaviour I am getting. Thanks and Regards, Praveen Kumar http://fedoraproject.org/wiki/User:Kumarpraveen http://fedoraproje...

While pb7.0 run SELECTBLOB with oracle 8.1.7 server, w2k system popup an fatel error msg "memory can't write", why?
...

superreview granted: [Bug 49487] If Linux inst msg "dir doesn't exist" is closed by checkbox, install wizard won't advance past "Next" : [Attachment 147374] fix error dialog
Brian Ryner (IBM) <bryner@brianryner.com> has granted Andrew Schultz <ajschult@verizon.net>'s request for superreview: Bug 49487: If Linux inst msg "dir doesn't exist" is closed by checkbox, install wizard won't advance past "Next" http://bugzilla.mozilla.org/show_bug.cgi?id=49487 Attachment 147374: fix error dialog http://bugzilla.mozilla.org/attachment.cgi?id=147374&action=edit ...

Web resources about - New Install 1.0.9, Can't find "GetPortalSettings" sproc error - asp.net.dotnetnuke

Resources last updated: 1/23/2016 9:27:16 PM