Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 forum/inc_func_secure.asp, line 103		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

cmarco
Starting Member

4 Posts
Posted - 01 April 2007 :  15:21:51  Show Profile
I am having the forum/inc_func_secure.asp, line 103 issue. My forum is sitting on a host that does not allow me direct access to the database file. They do allow me to edit the database via their database management tool and I can access to F_PRIVATEFORUMS. It looks like this.

F_PRIVATEFORUMS int 4 10 0 True False False

I have a screen shot here of my options

http://i5.photobucket.com/albums/y152/Landor40/help.jpg?t=1175453027

When I try to make any change to this field i get
Error -2147217873
Cannot insert the value NULL into column 'F_PRIVATEFORUMS', table 'DB_26018A.User_26018A.FORUM_FORUM'; column does not allow nulls. UPDATE fails.

ALTER TABLE [DB_26018A].[User_26018A].[FORUM_FORUM] ALTER COLUMN [F_PRIVATEFORUMS] INT NOT NULL



Any help would be appreciated..

Charlie

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 01 April 2007 :  16:07:12  Show Profile  Send ruirib a Yahoo! Message
Any recent events that we should now about - database migration or server move, mod added?

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

cmarco
Starting Member

4 Posts
Posted - 01 April 2007 :  16:10:03  Show Profile
quote:
Originally posted by ruirib

Any recent events that we should now about - database migration or server move, mod added?

It is a new install.
Edited by - cmarco on 01 April 2007 16:37:42
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 01 April 2007 :  16:13:54  Show Profile  Send ruirib a Yahoo! Message
What database are you using?

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 01 April 2007 :  16:15:14  Show Profile  Send ruirib a Yahoo! Message
Here is the fix: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=60654&SearchTerms=inc_func_secure.asp,,line,103,#336521

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

cmarco
Starting Member

4 Posts
Posted - 01 April 2007 :  16:34:31  Show Profile
quote:
Originally posted by ruirib

Here is the fix: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=60654&SearchTerms=inc_func_secure.asp,,line,103,#336521


I do not have this kind of access. Would it be possible for someone to write a script or something like was done for the password reset?
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 01 April 2007 :  17:31:55  Show Profile  Send ruirib a Yahoo! Message
You can download the database, do it locally and then upload it again.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

cmarco
Starting Member

4 Posts
Posted - 01 April 2007 :  19:43:39  Show Profile
quote:
Originally posted by ruirib

You can download the database, do it locally and then upload it again.


Can you point me to an editor to make the changes with..
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 01 April 2007 :  20:01:30  Show Profile  Send ruirib a Yahoo! Message
You can use Table Editor to run the update query... but now that you mention it, you can use it even online.

http://www.2enetworx.com/dev/projects/tableeditor.asp

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.36 seconds. Powered By: Snitz Forums 2000 Version 3.4.07