| Author |
 Topic  |
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
 Posted - 14 June 2001 : 09:07:37
|
I'm having some sort of problem where the FORUM_MEMBERS.M-LEVEL field is being left NULL after someone registers. At the time of registration, they are allowed in the site, but because the field in the database gets left NULL, on subsequent visits they are not allowed to login.
I'm using a modified version of sr2 but I don't think this has changed to sr4 (except for the cookies thing). Could someone point me to how the M_LEVEL field is set so I can try and fix this? I've probably broken something but can't seen to figure out where...
Much appreciated!
Rob Poretti 
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 14 June 2001 : 10:43:11
|
You need to set a default value of 1 for the M_LEVEL field in FORUM_MEMBERS
|
 |
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 14 June 2001 : 15:21:15
|
Hi HuwR,
Do you mean as a property of the database field in the FORUM_MEMBERS table, so that when a new member is created they are automatically set as M_LEVEL = 1?
Thanks!
Rob
Rob Poretti
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 14 June 2001 : 17:47:32
|
Yes, this should be set in the DB, but if you do a transfer from access to sql, the default values are not transferred unless you use the forum setup.asp to create the tables first
|
|
|
|
Deleted
deleted
4116 Posts |
Posted - 14 June 2001 : 18:21:30
|
Sure you know it, but for others : if you have old members, you may need to modify their records manually, or using SQL.
Think Pink |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 14 June 2001 : 22:04:29
|
I believe HuwR is referring to the default field value in the database definition, not the existing data.
======
Doug G
====== |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 15 June 2001 : 07:00:44
|
quote:
I believe HuwR is referring to the default field value in the database definition, not the existing data.
======
Doug G
======
Sure. Sorry, I had to quote. I was saying this to Rob 
Think Pink |
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 15 June 2001 : 08:28:32
|
Yes I understand... thanks to all...
I updated the SQl table default and changed all my NULLs to 1's...
Thanks again...much appreciated!
Cheers!
Rob Poretti
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960 |
|
|
| |
Topic |
|
Topic Locked
