| Author |
 Topic  |
|
|
Serevinus
Junior Member
United Kingdom
124 Posts |
 Posted - 11 September 2002 : 13:43:04
|
One of my users is having problems (Error was reported on this page) after setting my mod up on his forum, new members cannot register without getting a database error
The error is
Microsoft JET Database Engine (0x80004005)
Field 'FORUM_MEMBERS.M_LNEWS' cannot be a zero-length string.
/test/register.asp, line 598
I have made changes to the SQL on that page but I cant see any changes that would cause this to start being a problem
if strLNews = "1" then
strsql = strsql & ", '" & ChkString(Request.Form("LNews"),"message") & "'"
else
strSql = strSql & ", ''" '< error is on this line
end if
I tried changing this line
strSql = strSql & ", ''"
to this
strSql = strSql & ", NULL"
and I no longer get the error
If you want to download the zip and see what changes I have made, it is available here... Download ZIP
Can anyone tell me why my MOD would require this change? or am I missing somthing, maybe in one of the #includes |
Edited by - Serevinus on 11 September 2002 15:05:38 |
|
|
Serevinus
Junior Member
United Kingdom
124 Posts |
Posted - 12 September 2002 : 18:01:03
|
OK, I still dont know what causes the problem with registering, but I have updated the zip with a patch that will prevent the problem from occuring
By changing all the strSql = strSql & ", ''" lines in register.asp to strSql = strSql & ", NULL" the problem has vanished
If you have any ideas as to why my MOD would suddenly make SQL not like null text values, please let me know
Any Ideas Richard? |
 |
|
| |
Topic |
|
|
|
Topic Locked
