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)
 Setup Error on db insert
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

CHarrier
Starting Member

United Kingdom
3 Posts

Posted - 03 August 2009 :  03:27:59  Show Profile
I'm trying to set up a new forum using Access and the latest release downloaded from the site.

I've configured the database OK, and get to the setup.asp page that asks for an admin username and password. I enter this informtion, but then get an error when the form attempts tp insert the new record into the member table. The error relates to a non-zero length field not being allowed in the firstname field.

This is understandable as all the setup.asp form posts is the username and hashed paswword.

Should I change the constraints on all the columns in the member table to allow for zero values, or is the setup.asp form not displaying correcly, i.e. should it include all the other required fields?

Any help gratefully received.

HuwR
Forum Admin

United Kingdom
20600 Posts

Posted - 03 August 2009 :  04:43:14  Show Profile  Visit HuwR's Homepage
the database that comes with Snitz doe not have any required fields. you should be able to insert a completey blank record.
Go to Top of Page

CHarrier
Starting Member

United Kingdom
3 Posts

Posted - 03 August 2009 :  15:16:33  Show Profile
OK, I'll deinstall and set all fields in the db to 'Allow zero length' in Access. I'll update forum once tried this out.

I notice that there is another post by omega1 with exactly the same error.
Go to Top of Page

omega1
Junior Member

United Kingdom
127 Posts

Posted - 03 August 2009 :  15:25:29  Show Profile  Visit omega1's Homepage
Hi there CHarrier, sounds lie same problem... I haven't had this problem before and as per my post, have installed a few Snitz forums over the years...

Will have to wait for someone that knows a bit more than me!

Visit : My personal site - Website Hosting - Register a domain
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20600 Posts

Posted - 03 August 2009 :  16:34:48  Show Profile  Visit HuwR's Homepage
see here http://forum.snitz.com/forum/topic.asp?whichpage=1&TOPIC_ID=68834#392343
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 1.87 seconds. Powered By: Snitz Forums 2000 Version 3.4.07