|
andretti
New Member
70 Posts |
 Posted - 19 March 2005 : 16:03:50
|
Just downloaded TheSnitz My Personalization Mod...
Looks real good and creates a great users page that displays all theusers latest info...
This mod allows each user to select a color profile that they want.
I ran the dbs file
My Snitz Personalization V3.4
[CREATE]
MY_CONFIG
MEMBER_ID#int##
THEME_ID#int##0
MAX_MY_TOPICS#int##5
SHOW_RECENT_TOPICS#int##1
SHOW_MY_TOPICS#int##1
SHOW_PM#int##0
[END]
And it went thru just fine.
Then went to my page and on that page is a link called Edit My Page
When i click on that link I get this error
[Microsoft][ODBC Microsoft Access Driver] The field 'FORUM_MY_CONFIG.THEME_ID' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.
/my_edit_config.asp, line 94
Then I open the file my_edit_config.asp and get the following lines
From 86 to Line 94 which I have pasted here
'######GetMemberID
id = getMemberID(Request.Cookies(strUniqueID & "User")("Name"))
'###Check if Memeber has already enabled his personal Page account in the database
strSQL = "SELECT * FROM " & strTablePrefix & "MY_CONFIG WHERE MEMBER_ID=" & id
Set objRS = ObjDB.Execute(strSQL)
If objRS.EOF then 'Insert the Members ID
strSQL = "INSERT INTO " & strTablePrefix & "MY_CONFIG (Member_ID) VALUES ('" & id & "')"
objDB.Execute(strSQL)
Response.Write "<CENTER><FONT SIZE=" & strDefaultFontSize & " FACE=" & strDefaultFontFace & "><B><font color=red>Welcome First Time User </font>" & strDBNTUSername & "! Your Personal Page has been Enabled..</b></font><HR size=1></CENTER>"
Else
edit_flag = 1 'Used ahead to check if already the member has edited options
End if
#############End Of paste############
Anyone know what I will need to do to be able to correct this error?
Thanks in advance
David |
|
Topic Locked
