473,372 Members | 1,329 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

Website Administrator writes two instances of each user into the database

I applied aspnet_regsql to SQL2K which was working fine throughout Beta 2
development. After installing Visual Studio and SQL Express RTM my
application has blown up. Logging in to the application became
realllllllllllly slow. Content in LoginView Role Groups was not displaying
even after a user in a role had logged in.

It was taking about 15 seconds or so for the login control to display when
the login link was selected on the homepage. I would hear two page clicks
after selecting the Login link. hearing two clicks made me wonder if the
page was posting back twice. Furthermore, entering text into textbox
controls on a page now throws a stack overflow at line: 0 in a windows
dialog. This is the oddest page behavior I have ever experienced. Hello 2.0.

So this all made me suspicious and I went into the database and observed
there were two instances of each user in the aspnet_Users table, a table
that is created by aspnet_regsql when setting up Membership, Roles and
Profiles.

After observing the redundant records I then used the Website Administration
tool to delete all users and confirmed no user could login to the
application. It was interesting to note the login control would then load
without waiting when trying to login from the homepage. The performance
problem seemed to have been resolved. I hoped I had resolved the entire
problem but stack overflows persisted when entering text into textboxes
displayed by an instance of the Wizard control.

What is interesting to observe is the stack overflow does not happen until
the second step in the Wizard control and the value is always at line zero
for all subsequent steps in the Wizard control each of which will throw the
error into a dialog when selecting the Wizard's next button. I really have
no experience with overflow circumstances in a web page so I went back into
the database to look around.
Lo and beholdski the aspnet_Users table still contained records populated
with user data. The same redundant instances (two of each user) were still
present in the database even though I had used the Website Administrator to
delete users. So I used Enterprise Manager and deleted all aspnet_* tables
and ran aspnet_regsql on the database thinking a fresh install of Membership
would resolve this problem and get rid of the redundant records and all
users which was okay because the users were proxy test dummies.

After applying aspnet_regsql I confirmed the aspnet_ tables were installed
into the database restoring a fresh instance of Membersghip. The
aspnet_Users table was empty and I started feeling I would not see anymore
stack overflows. So I then used the Website Administration tool and created
two users. Tried to login and the same thing all over again.

Each user is being created in the database twice and the stackI applied
aspnet_regsql to SQL2K which was working fine throughout Beta 2. After
installing 2.0 RTM I'm having all kinds of problems. Logging in became
realllllllllllly slow. Content in Role Group sections was not displaying
even though a user with a role had logged in after waiting for 15 seconds or
so for the login control to display when the login link was selected. I
would hear two page clicks when selecting the Login link. Furthermore,
entering text into textbox controls now throws a Stack overflow at line: 0
error.

This made me suspicious and I observed there were two instances of each user
in the aspnet_Users table.

I used the Website Administration tool to delete the users and confirmed no
user could login and the display of the login control appeared snappy as one
would expect yet stack overflows persisted. I then observed the aspnet_Users
table still contained the users including redundant instances (two of each
user). So I used Enterprise Manager and deleted all aspnet_* tables and ran
aspnet_regsql on the database thinking a fresh install of Membership would
resolve this problem.

After applying aspnet_regsql I confirmed the aspnet_* tables were installed
into the database and the aspnet_Users table was empty. I then used the
Website Administration tool and created two users. Tried to login and the
same thing all over again.

Each user is being created in the database twice and the stack continues to
overflow.

What the fugowi could be going on here?
<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/

Nov 22 '05 #1
0 1650

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Roland Riess | last post by:
Hi all, at the moment i am developing an app which is sort of an interface to copy data from one database to another and it shall run as a service. As there are several databases the app must be...
2
by: clintonG | last post by:
Website Administrator is adding two users into the aspnet_Users table each time it is used to add a new user. It is also time stamping 6 hours later that the actual system time when the user is...
0
by: clintonG | last post by:
This is wierd. After seeing this anomaly in a Beta 2 app I carried over into RTM 2.0 I've confirmed the anomaly in two different basic page applications I created for testing using two fresh...
2
by: TTT | last post by:
Hi, I have developed a website from the model "Starter kits Classified". Well, the application works good, no problem in my development environment. It uses a SqlServer 2005 express database...
1
by: Ned Balzer | last post by:
Hi all, I have a problem that has me stumped. I developed an asp.net 2.0 application and it works fine. It is located in a subweb of a website, so for instance the main site is called...
1
by: selvamcbe | last post by:
sir I have a problem with installtion of phpbb 2 Forum in my website... I am having a website named http://www.clickonlinejobs.com Also i plan to include forum with it.So i have added my forum in...
1
by: R.A.M. | last post by:
Hello, I have started programming ASP.NET application using SQL Server 2005 Express Edition. The problem is that when C# code tries to access aspnetdb database, for example:...
3
by: =?Utf-8?B?SGVyYg==?= | last post by:
Can I use the Website Administration tool to manage users and roles for multiple ASP.NET applications using a single, common ASPNETDB? If so, what changes do I have to make to the web.config...
4
by: bnashenas1984 | last post by:
Hi everyone I'm sure there are many open source Ecommerce scripts out there but because of some reasons i'm building my own. I'm having a problem with reserving products. Here's what I need :...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.