| Author |
 Topic Search  Topic Options
|
MaximeRoy77 
Groupie
Joined: 21 November 2010
Location: Québec, Canada
Status: Offline
Points: 54
|
 Topic: Access Denied & Session Timeouts
Posted: 21 November 2010 at 8:45pm |
My logged in members are having some issues with permissions and login.
The only thing that the LOGGING FEATURE might indicate the cause is this line
2010-11-21 14:35:15 - 123.125.156.136 - Guest - ERROR - File: functions_session_data.asp - Error Details: err_SQLServer_getSessionData()_save_new_session_data - Microsoft OLE DB Provider for SQL Server - Violation of PRIMARY KEY constraint 'PK__tblSession__30CE2BBB'. Cannot insert duplicate key in object 'dbo.tblSession'.
That occurs many times a day.
SQLSession are ACTIVE.
Any clues why and if it's problematic ?
Edited by MaximeRoy77 - 24 November 2010 at 2:51pm
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Posted: 22 November 2010 at 5:20pm |
|
There will be a fix for this problem in the next release.
|
|
|
|
MaximeRoy77
Groupie
Joined: 21 November 2010
Location: Québec, Canada
Status: Offline
Points: 54
|
Posted: 22 November 2010 at 5:45pm |
In the mean time I get complaints from long time members (10 years) like this:
Forum: Internal news
Topic: *** FORUM UPGRADE / OFFLINE SOON ***
Posted By: The T
This forum is much worse than it used to be. Every two posts I get the stupid "you don't have permission" message.
Is frustrating.
Should I revert to NON-SessionSQL ? Standard !
PS: When the new release ?
|
|
MaximeRoy77
Groupie
Joined: 21 November 2010
Location: Québec, Canada
Status: Offline
Points: 54
|
Posted: 22 November 2010 at 6:01pm |
|
Can i revert back to 9.53 from 9.69 ?
|
|
MaximeRoy77
Groupie
Joined: 21 November 2010
Location: Québec, Canada
Status: Offline
Points: 54
|
Posted: 23 November 2010 at 2:25pm |
My members keep on receiving this, either on SQLSessions or Applications variables.
Tell me how can I fix it ?
Thanks
|
|
MaximeRoy77
Groupie
Joined: 21 November 2010
Location: Québec, Canada
Status: Offline
Points: 54
|
Posted: 23 November 2010 at 3:06pm |
I am starting to think that WEBWIZ is not recommended for over 100 active users, even on SQL Server 
|
|
123Simples
Senior Member
Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
|
Posted: 23 November 2010 at 7:20pm |
 MaximeRoy77 wrote:
I am starting to think that WEBWIZ is not recommended for over 100 active users, even on SQL Server |
That's not true. Web Wiz will run comfortably on that amount of users, and in actual fact, despite the earlier comments, I myself have not had any issues like you mention. Have you actually modified any files, or have you started with a fresh upload? I'm curious, as to why the problems have presented themselves on your forum. Can you PM me your actual forum address so I may look myself?
|
|
|
|
MaximeRoy77
Groupie
Joined: 21 November 2010
Location: Québec, Canada
Status: Offline
Points: 54
|
Posted: 23 November 2010 at 9:41pm |
|
I'd like to believe that, but since the 9.69 upgrade , it's been quite difficult to believe again....
|
|
Access Denied & Session Timeouts