| Author |
 Topic  |
|
|
Sandro
Starting Member
Belgium
26 Posts |
 Posted - 27 August 2002 : 11:32:25
|
I had an error on my default page several times, and I think it involves adding a category (or forum) and the sorting, I think (because when I sort forums in admin page problem gets solved). But At the moment I'm unable to recreate the error, so I can't copy the error, anyone else with this error?
Sandro |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 27 August 2002 : 13:38:37
|
| We can't help much if you don't give us a clue on what the error was. |
Support Snitz Forums
|
 |
|
|
Sandro
Starting Member
Belgium
26 Posts |
Posted - 27 August 2002 : 14:59:40
|
ok, when i got back to my forum the error just came back, so here it is:
Microsoft JET Database Engine error '80040e57'
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
/forums/inc_func_common.asp, line 587
I posted the report without the error in the hope maybe someone else heard of it before 
now, when I change the order of categories and items this wil go away, like it did before. |
Edited by - Sandro on 27 August 2002 15:05:07 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 27 August 2002 : 15:14:53
|
| What were you trying to do before you got that error? |
Support Snitz Forums
|
|
|
|
Sandro
Starting Member
Belgium
26 Posts |
Posted - 27 August 2002 : 15:24:28
|
| i did nothing, i just went back to my forum. I hadn't been doing anything, but appears that after I login it disappears, so nothing to do with order of items. When i left the forum nothing was wrong. |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 27 August 2002 : 16:28:54
|
So the error only happens when you access your the default.asp page logged out?
Do this: right before line 587 in inc_func_common.asp file, put this bit of code:Response.Write strSql So it would look like this:strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkString(UserName, "SQLString") & "' "
Response.Write strSql
my_conn.Execute (strSql),,adCmdText + adExecuteNoRecords And try to reproduce the error. You should get some more code displayed on the default.asp along with the error. Post the code you see, here.
A link to your forum would be helpful too. |
Support Snitz Forums
|
|
|
|
Sandro
Starting Member
Belgium
26 Posts |
|
|
Sandro
Starting Member
Belgium
26 Posts |
Posted - 27 August 2002 : 18:17:13
|
this is the sql string and now I know what the error seems to be:
UPDATE FORUM_MEMBERS SET M_LASTHEREDATE = '20020828000227', M_LAST_IP = '213.224.243.###, 213.224.83.46' WHERE M_NAME = 'Sandro'
I modded the ip detection to show my real ip instead of my providers proxy, normally I get my own ip except when the file gets called as defaultpage
like: www.site.com/forum/
and the problem does nog appear when you visit
www.site.com/forum/default.asp
I don't know why I haven't thougt about the response.write strSql code
I'm going to update my code so this doesn't happen anymore.
Maybe this is a good Idea to use in new release?
what would be the best way to get only the first IP? the split function? but how does that one work? I haven't used that one before.
(changed my Ip, to prevent hackers from trying me out ) |
Edited by - Sandro on 27 August 2002 19:14:54 |
|
|
|
Sandro
Starting Member
Belgium
26 Posts |
Posted - 27 August 2002 : 18:36:52
|
ok, I looked into the forum code and found how the split function works, It's rather simple, I panict for nothing
now it is fixed.
All in all it worked out fine, it was even my fault without knowing
Sorry for posting in bug forum even if it was my fault
If you want I'll send you the code I use to get a more accurate IP.
Greetings,
Sandro |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 28 August 2002 : 04:11:56
|
Sure. You can send me the code. Or you can post it here if it's not too much code.
Glad you got it fixed. |
Support Snitz Forums
|
|
|
|
Sandro
Starting Member
Belgium
26 Posts |
Posted - 28 August 2002 : 06:24:25
|
| I'll Clean Up the code a bit, and then I will post it, it isn't much code |
|
|
|
Sandro
Starting Member
Belgium
26 Posts |
Posted - 28 August 2002 : 08:06:53
|
when I was making it look nicer, i tought: why not make it a mod for the forum, so I added the headers (gpl and stuff) and a little manual about how to use it and I've posted it in the mods forum http://forum.snitz.com/forum/topic.asp?TOPIC_ID=33830
Greetings,
Sandro |
|
|
| |
Topic |
|
Topic Locked
