| Author |
 Topic  |
|
rabufo
Junior Member
Italy
328 Posts |
 Posted - 01 December 2004 : 15:49:17
|
Hi all,
a problem making me crazy: when a new user register it seems all OK, but when he tries to login, he receives this error message:
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'cLng'
/forum/inc_func_common.asp, line 1077
When I look at Members list, the fields "Title" and "Posts" of that user say "Error"
If i edit his nickname, then all works fine and he can login.
Where have I to look to fix this problem?
Thank you very much
|
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 01 December 2004 : 15:54:36
|
| what function is it kicing the error in inc_func_common.asp? |
De Priofundus Calmo Ad Te Damine |
 |
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 01 December 2004 : 17:07:53
|
sorry, I forgot...
the line 1077 is the one in red:
MemberID = rsCheck("MEMBER_ID")
if (rsCheck("MEMBER_ID") & "" = fAuthor & "") and (cLng(rsCheck("M_LEVEL")) <> 3) then
chkUser = 1 '## Author |
|
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 01 December 2004 : 17:18:32
|
whats the function is it tho, not the line  |
De Priofundus Calmo Ad Te Damine |
|
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 01 December 2004 : 17:34:53
|
sorry PeeWee, please tell me how can I be clearer and indicate the function  ...that error message appears when a new user tries to login for the first time. |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 01 December 2004 : 18:37:57
|
quote:
Originally posted by Davio
What mods have you installed?
oh my God, the forum is really super-modded Anyway, no one new MOD in this last period, I've that problem since a lot of time, and I've always solved it changing any new user nickname, but it's really frustating 
I thought that it'd be easy to discover the bug from the line appearing in the error message, but it's not, right? |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 01 December 2004 : 18:48:35
|
It's just that rsCheck("M_LEVEL") is returning a null value. It's not supposed to. Supposed to be returning a number. So you need to find out why it is returning null. The field is supposed to have a default value of 1.
First place to start looking is the sql query in your register.asp file that inserts the member details into the database. |
Support Snitz Forums
|
Edited by - Davio on 01 December 2004 18:49:45 |
|
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 01 December 2004 : 19:10:34
|
done, Davio...it seems OK
Could it be a problem of the database? I say this because I've uploaded to the forum all .asp files of another forum of mine, same Snitz version and exactly with the same MODs but with no problem related to the first login of the new users: well, the first forum has always the same problem....... |
|
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 01 December 2004 : 19:41:49
|
| just checked the database: you were right, Davio, the new user M_LEVEL field of FORUM_MEMBERS is empty (instead of 1) and it's empty also the M_ALEVEL field (Admin Level MOD), where the correct value is 0 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 01 December 2004 : 19:46:25
|
| Seems like the default values aren't set for those fields then. |
Support Snitz Forums
|
|
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 01 December 2004 : 19:51:35
|
quote:
Originally posted by Davio
Seems like the default values aren't set for those fields then.
Have I to set them in register.asp, Davio? |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 01 December 2004 : 20:00:21
|
| If you're not using Email Validation or using Restrict Registration, the register.asp page does not insert anything into the M_LEVEL field. That's why the field has the Default Value set to 1. So just make sure you made that change to your database. |
Support Snitz Forums
|
Edited by - Davio on 01 December 2004 20:00:47 |
|
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 01 December 2004 : 20:25:05
|
quote:
Originally posted by Davio
So just make sure you made that change to your database.
please be patience, Davio...how can I make that change to the db? |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 01 December 2004 : 20:34:26
|
Huh? I'm not being impatient. I'm in no rush. Take your time. It's your forum. 
If you're using an Access database, you will need to download it, open it in Microsoft Access, open the FORUM_MEMBERS table in Design View. Select the M_LEVEL field. Set the "Default Value" option to 1. Save it. Then upload the database back to your site. |
Support Snitz Forums
|
|
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 01 December 2004 : 20:36:52
|
quote:
Originally posted by Davio
Huh? I'm not being impatient. I'm in no rush. Take your time. It's your forum.
no no, I was asking to be patience with me, if I'm annoying with all these questions
quote:
If you're using an Access database, you will need to download it, open it in Microsoft Access, open the FORUM_MEMBERS table in Design View. Select the M_LEVEL field. Set the "Default Value" option to 1. Save it. Then upload the database back to your site.
Thank you! I'll make and will let you know. |
|
|
|
Topic |
|
Topic Locked
