| Author |
 Topic  |
|
DigitalFusion
Starting Member
USA
16 Posts |
 Posted - 27 August 2009 : 12:10:29
|
Hello,
This isnt the first time I have installed and configured Snitz for a website. However, this is the first time I am having issues.
I'd say about 50% of the time when a member registers, and hits submit after typing in their data, nothing happens. By that I mean there are no errors, or successful messages, it just goes back to the forum default page and the member isnt registered.
I have also noticed random "hangs" with the forum. Posting a new topic or replying can either be instant, or it can hang hang forever. Has anyone else had simalar issues? I am using Access, but its because it is for a small organization, and SQL really is overkill.
|
|
|
DigitalFusion
Starting Member
USA
16 Posts |
Posted - 27 August 2009 : 12:12:47
|
| Id say more than 50% of the time on the registrations.... I just tried it 3 times and all 3 "failed" |
 |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
DigitalFusion
Starting Member
USA
16 Posts |
Posted - 27 August 2009 : 12:48:44
|
I tried 10 times total, all failed with no message, just a redirect to the default page.
I came back about 5 minutes later, and tried 3 more times. All 3 registrations worked just fine. ????????? |
|
|
|
DigitalFusion
Starting Member
USA
16 Posts |
Posted - 27 August 2009 : 12:49:49
|
| yes, cookie is set to forum |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
DigitalFusion
Starting Member
USA
16 Posts |
Posted - 27 August 2009 : 12:57:26
|
not yet. However, wouldnt this be a coding issue?
I notice that the .ldb file never goes away. Shouldnt this go away if no one is on the forum? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 27 August 2009 : 13:01:29
|
This is definitely not a coding issue. The random nature of the situation indicates that - a coding error would mean that it wouldn't start working out of the blue. Also, we have no reports of registration issues with the new version.
Likely the issues are access related. Using MySQL can be an option. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
DigitalFusion
Starting Member
USA
16 Posts |
Posted - 27 August 2009 : 13:08:01
|
I realize SQL would be a much better option, I just assumed since this was a small organization with a low amount of traffic, I could get away with Access. I have utilized Access before for small sites and it ran smoothly.
Checking with host now. |
Edited by - DigitalFusion on 27 August 2009 13:08:21 |
|
|
|
DigitalFusion
Starting Member
USA
16 Posts |
Posted - 27 August 2009 : 13:10:18
|
| Event Type: Information Event Source: W3SVC Event Category: None Event ID: 1077 Date: 8/27/2009 Time: 12:55:57 PM User: N/A Computer: POSITRON Description: A worker process with process id of '24252' serving application pool 'mnsma.org(domain)(pool)' has requested a recycle because it reached its virtual memory limit. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. |
|
|
|
DigitalFusion
Starting Member
USA
16 Posts |
Posted - 27 August 2009 : 13:16:55
|
| I have the site integration mod, and proeders file attachment mod installed. Otherwise the forum is the same. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
DigitalFusion
Starting Member
USA
16 Posts |
Posted - 27 August 2009 : 13:24:27
|
| yes and no? it shouldnt keep maxing out the memory... something is leaking somewhere? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 27 August 2009 : 13:29:03
|
| It shouldn't max out on a form submission, with almost no users online, should it? It's either a config thing or another type of problem. Sorry, can't help much, as I am not that knowledgeable on IIS. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
DigitalFusion
Starting Member
USA
16 Posts |
Posted - 27 August 2009 : 13:54:15
|
im super confused.
the host is saying it is something wrong with the code/database queries/connection.
This makes sense to me. There are a few areas that could be causing the issue:
Site Integration Mod
File Attachment Mod
I doubt it is these two.
I access one of the forums on the home page to display "news" postings. However, I dont see where a memory leak could be occuring in the code:
-------------------------------------------------------
<%
strAllowForumCode = "1"
strAtHomePage = "1"
'open database
set ConnTemp = Server.CreateObject("ADODB.Connection")
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/database/snitz_forums_2000.mdb")
connTemp.Open strConnString
'select the news posts
set rstemp = Server.CreateObject("ADODB.Recordset")
mySQL = "SELECT TOP 5 T_SUBJECT, T_MESSAGE, T_DATE FROM FORUM_TOPICS WHERE FORUM_ID = 2 AND TOPIC_ID <> 5 ORDER BY T_LAST_POST DESC"
set rstemp=conntemp.execute(mySQL)
Do While Not rstemp.EOF
'format the date
dtMonth = Mid(rstemp("T_Date"),5,2)
dtDay = Mid(rstemp("T_Date"),7,2)
dtYear = Left(rstemp("T_Date"),4)
dtDatePosted = dtMonth &"/"&dtDay&"/"&dtYear
%>
<table align="center" width="90%" cellspacing="1" cellpadding="0" border="0" bgcolor="#d8d8d8" class="newstable">
<tr>
<td width="20%"> <img src="images/icon.gif" width="84" height="29" border="0" alt=""></td>
<td align="center"><FONT CLASS="regblack"><strong><%=rstemp("T_SUBJECT")%></strong></font></td>
<td align="right" width="30%"><FONT CLASS="smallblack"><%=dtDatePosted%></font> </td>
</tr>
<tr><td colspan="3" bgcolor="#000000"><img src="/images/blk.gif" width="1" height="1" border="0" alt=""></td></tr>
<tr>
<td colspan="3" bgcolor="#FFFFFF">
<table width="100%" cellspacing="2" cellpadding="6" border="0"><tr><td>
<FONT CLASS="smallblack"><%=formatStr(rstemp("T_MESSAGE"))%></FONT>
</td></tr></table>
</td>
</tr>
</table>
<br>
<%rstemp.movenext
Loop
connTemp.close
Set rstemp=Nothing
Set ConnTemp=Nothing%>
Do you see anything that could be causing an issue here?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
