| Author |
 Topic  |
|
|
FeDe
New Member
62 Posts |
 Posted - 15 May 2002 : 12:52:50
|
I really do not know what's happening at my forum, i get an error just when replying to some threads, but with other threads there's no problem..
I'm using a Snitz 3.3 version, Access 2000, and the url of my forum is: http://www.clubp3.com/foro/default1.asp
This is the error I get:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.
/foro/post_info.asp, line 774
I already tried uploading the post_info from the Snitz zip file, but i still get that error.
Hope you can help me
Edited by - FeDe on 15 May 2002 13:51:27 |
|
|
FeDe
New Member
62 Posts |
Posted - 16 May 2002 : 16:30:37
|
**bump**
Sorry to do this, but really big problem  .
|
 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 16 May 2002 : 17:00:04
|
If you give me a few days I will try to somehow look at your post_info.asp file and figure out what is on your line 774.
But if you want to help me solve your problem a bit quicker, you can make it easier on me and post what is on your line 774.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
FeDe
New Member
62 Posts |
Posted - 16 May 2002 : 17:10:39
|
Thanks for the reply! 
This is that part of the code (the third line is the 774):
set rs = my_Conn.Execute (strSql)
if rs.BOF or rs.EOF or not(QuoteOk) or not(ChkQuoteOk(Password)) then '## Invalid Password
err_Msg = "Nombre de Usuario o Contraseña no Valido"
Go_Result(err_Msg), 0
Response.End
else
if not(chkForumAccess(Forum_ID,getNewMemberNumber())) then
Go_Result "No tenes permitido responder en este foro !", 0
end if
txtMessage = ChkString(Request.Form("Message"),"message")
if txtMessage = " " then
Go_Result "Tenes que ingresar un mensaje!", 0
Response.End
end if
if Request.Form("sig") = "yes" and GetSig(STRdbntUserName) <> "" then
txtMessage = txtMessage & vbNewline & vbNewline & ChkString(GetSig(STRdbntUserName), "signature" )
end if
I really think it's a database error.. though i've no idea what might be happening.. i just had an error in pop_delete when trying to delete a post:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The search key was not found in any record.
/foro/pop_delete.asp, line 81
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 17 May 2002 : 03:22:24
|
You're sayin this line:err_Msg = "Nombre de Usuario o Contraseña no Valido" is line 774 that is giving the error?
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
FeDe
New Member
62 Posts |
Posted - 17 May 2002 : 06:00:25
|
No, in my document 774 would be the line before that and it's just (There's no real line between invalid and password, just a space):
if rs.BOF or rs.EOF or not(QuoteOk) or not(ChkQuoteOk(Password)) then '## Invalid
Password <--- Line 774
|
|
|
|
ThomFoolery
Starting Member
USA
1 Posts |
Posted - 17 May 2002 : 08:41:46
|
What's up with all the sided scrolling on this topic?
"Life in the fun lane!" |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 17 May 2002 : 10:05:48
|
The lines of code do not wrap when the get to the edge of your screen, this will cause horizonal scrolling.
My monitor is big enough though, that this topic is not a problem 
 Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 17 May 2002 : 14:29:04
|
Post a link to a txt version of your post_info.asp file.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
FeDe
New Member
62 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 18 May 2002 : 01:28:01
|
Line 774 is not where you specified earlier. The line you were pointing me to was line 722 in your file. Line 774 is actually:my_Conn.Execute (strSql) Can you put Response.Write strSql right before that line? And then try and recreate the error again by making a reply. When you get the error copy the sql query and post it here.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
FeDe
New Member
62 Posts |
Posted - 18 May 2002 : 09:47:48
|
Just did it:
INSERT INTO FORUM_REPLY (TOPIC_ID, FORUM_ID, CAT_ID, R_AUTHOR, R_DATE , R_IP, R_STATUS, R_MESSAGE) VALUES (1324, 12, 10, 6, '20020518103926', '**my Ip here**', 1, 'fede
http://clubp3.com/foro/forum.asp?FORUM_ID=45
')
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.
/foro/post_info.asp, line 775
|
|
|
|
FeDe
New Member
62 Posts |
Posted - 19 May 2002 : 10:14:59
|
**bump again**
Sorry  .
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 19 May 2002 : 20:26:24
|
You're using a 3.3 Final version. The latest version is 3.3.04. So your version is not 'Current'.
But I have to say that error has me stumped. Does it error out on every reply made to the forum? Have you made any modifications to your forum files? Like added any mods or anything.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 May 2002 : 21:38:20
|
Ok, just a wild guess: have you thought about changing your connection string to an OLEDB driver, instead of using an ODBC driver?
There is nothing to lose in doing it, it may not solve your problem, but I've seen really weird things happen with ODBC drivers.
Just use a connection string like one of these, changing for your path to the database:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("database/snitz_forums_2000.mdb") '## MS Access 2000 using virtual
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\database\snitz_forums_2000.mdb" '## MS Access 2000
Just pick one of them. If you don't know the path to your DB use the one with the Server.MapPath.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
| |
Topic |
|
Topic Locked
