Author |
Topic |
|
Peopls
New Member
83 Posts |
Posted - 30 April 2002 : 15:01:52
|
Occasionally I'm getting error messages on my front page (the same one reffering to line 337 of inc_functions.asp). It's strange because it only happens occasionally and if you refresh it goes away. It happened after I installed the "Categorized Icons/Smilies" mod... the lines around line 337 are
quote:
function Smile(fString) strSql = "SELECT Code, Code2, Code3, Filename FROM " & strTablePrefix & "CategorizedIcons" set rsCategorizedIcons = Server.CreateObject("ADODB.Recordset") rsCategorizedIcons.open strSql, my_Conn Do While Not rsCategorizedIcons.Eof fString = replace( fString, rsCategorizedIcons("Code"), "<img src=" & rsCategorizedIcons("Filename") & " border=0 align=middle>") If Not IsNull( rsCategorizedIcons("Code2")) Then fString = replace( fString, rsCategorizedIcons("Code2"), "<img src=" & rsCategorizedIcons("Filename") & " border=0 align=middle>") End If If Not IsNull( rsCategorizedIcons("Code3")) Then fString = replace( fString, rsCategorizedIcons("Code3"), "<img src=" & rsCategorizedIcons("Filename") & " border=0 align=middle>") End If rsCategorizedIcons.MoveNext Loop
rsCategorizedIcons.close set rsCategorizedIcons = nothing
Smile = fString end function
Any suggestions?
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
Peopls
New Member
83 Posts |
Posted - 01 May 2002 : 05:07:02
|
quote:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/inc_functions.asp, line 337
|
|
|
Chiz
Junior Member
245 Posts |
Posted - 01 May 2002 : 05:45:49
|
This is what I'm afraid of. Please... be gentle everyone.
It's also happens in my forum sometimes especially when the traffic are at most. I'm actually doing another MOD testing and was discussing this very same issue with Ruirib. This is really a weird error.
I'm trying out a fix, but I don't recommend it. I put an On Error Resume Next statement. If it still won't work, I plan of re-coding the whole MOD by preventing trips to the database.
BTW, Peopls, what drivers are you using in your connection string? Is it already OLEDB?
My websites: PalmVenue :: PV Mobile My Snitz MODs: Categorized Icons
|
|
|
Chiz
Junior Member
245 Posts |
Posted - 01 May 2002 : 05:50:44
|
Also for everyone's info, the error fires in the line in red...
function Smile(fString) strSql = "SELECT Code, Code2, Code3, Filename FROM " & strTablePrefix & "CategorizedIcons" set rsCategorizedIcons = Server.CreateObject("ADODB.Recordset") rsCategorizedIcons.open strSql, my_Conn
Do While Not rsCategorizedIcons.Eof fString = replace( fString, rsCategorizedIcons("Code"), "<img src=" & rsCategorizedIcons("Filename") & " border=0 align=middle>") If Not IsNull( rsCategorizedIcons("Code2")) Then fString = replace( fString, rsCategorizedIcons("Code2"), "<img src=" & rsCategorizedIcons("Filename") & " border=0 align=middle>") End If If Not IsNull( rsCategorizedIcons("Code3")) Then fString = replace( fString, rsCategorizedIcons("Code3"), "<img src=" & rsCategorizedIcons("Filename") & " border=0 align=middle>") End If rsCategorizedIcons.MoveNext Loop
rsCategorizedIcons.close set rsCategorizedIcons = nothing
Smile = fString end function
I thought I'm the only one who encounters this... Just proves my theory is wrong.
Another thing Peopls, just curious, who hosts your site?
My websites: PalmVenue :: PV Mobile My Snitz MODs: Categorized Icons
Edited by - Chiz on 01 May 2002 05:52:59 |
|
|
Peopls
New Member
83 Posts |
Posted - 01 May 2002 : 06:04:10
|
quote:
BTW, Peopls, what drivers are you using in your connection string? Is it already OLEDB?
Unfortunately I've no real experience programming ASP and therefore have no idea what you're talking about sorry
quote:
Another thing Peopls, just curious, who hosts your site?
http://www.domainwebservices.co.uk they do, and btw this "On Error Resume Next statement" it just skips the error and continues loading it does it? If so how could I impliment this and what would be the side effects?
Edited by - Peopls on 01 May 2002 06:04:39 |
|
|
Chiz
Junior Member
245 Posts |
Posted - 01 May 2002 : 06:16:39
|
quote: Unfortunately I've no real experience programming ASP and therefore have no idea what you're talking about sorry
What I meant was is your connection string in the form of the following?
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=...
quote: http://www.domainwebservices.co.uk
Do you have an idea how many visitors are currently in your site when you encounter the error? Sorry, just had to do this for my own investigation.
quote: and btw this "On Error Resume Next statement" it just skips the error and continues loading it does it? If so how could I impliment this and what would be the side effects?
Yes it would just ignore the error. But I find that the error usually occurs on the default page and I assume that it won't do much impact. I maybe wrong you know. I hope others can help.
My websites: PalmVenue :: PV Mobile My Snitz MODs: Categorized Icons
|
|
|
Peopls
New Member
83 Posts |
Posted - 01 May 2002 : 06:30:14
|
quote: strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath '## MS Access 2000 using virtual path
As for how many users are on it when it occurs I thought it was when there was a load on it but it seems not, it happened just now with only 3 users online...
This does appear on the frontpage and it prevents the rest of the page from loading, so it's a quite a problem. I think I might have to just uninstall the mod since I haven't actually managed to get it to work anyway
Edited by - Peopls on 01 May 2002 06:44:34 |
|
|
Chiz
Junior Member
245 Posts |
Posted - 01 May 2002 : 06:40:54
|
Hey, I didn't expect you to be posting your entire connection string.
Anyway, now that you shown in public, I suggest you rename your mdb and do the necessary changes as there those that are happy with hacking somebody else's site.
My websites: PalmVenue :: PV Mobile My Snitz MODs: Categorized Icons
|
|
|
Peopls
New Member
83 Posts |
Posted - 01 May 2002 : 06:43:41
|
It's a private directory that can only be accessed via the ftp server. (and I doubt anyone would bother) EDIT: Edited it out anyways
Edited by - Peopls on 01 May 2002 06:46:25 |
|
|
|
Topic |
|