Web Wiz Support and Community Forums : Short Registration Page Database Problems https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 13:25:09 +0000 Mon, 12 Jun 2006 08:01:49 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20180 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Short Registration Page Database Problems : Try setting a default value for...]]> https://forums.webwiz.net/short-registration-page-database-problems_topic20180_post108885.html#108885 Author: WebWiz-Bruce
Subject: 20180
Posted: 12 June 2006 at 8:01am

Try setting a default value for the tblAuthor Signature field in the mySQL database. Just having it blank will fix the issue.]]> Mon, 12 Jun 2006 08:01:49 +0000 https://forums.webwiz.net/short-registration-page-database-problems_topic20180_post108885.html#108885 <![CDATA[Short Registration Page Database Problems : -boRg- wrote:If it fixes the...]]> https://forums.webwiz.net/short-registration-page-database-problems_topic20180_post108827.html#108827 Author: SMR Group
Subject: 20180
Posted: 11 June 2006 at 2:33am

Originally posted by -boRg- -boRg- wrote:

If it fixes the issue please let me know.
Actually, now I've updated the code it didn't help.
 
Microsoft OLE DB Provider for ODBC Drivers
[MySQL][ODBC 3.51 Driver][mysqld-5.0.22-community-nt]Field 'Attach_signature' doesn't have a default value
 
So still the same error.  The long registration form is fine, the short one errors out.
]]> Sun, 11 Jun 2006 02:33:01 +0000 https://forums.webwiz.net/short-registration-page-database-problems_topic20180_post108827.html#108827 <![CDATA[Short Registration Page Database Problems : -boRg- wrote:Try setting line...]]> https://forums.webwiz.net/short-registration-page-database-problems_topic20180_post108501.html#108501 Author: SMR Group
Subject: 20180
Posted: 06 June 2006 at 5:06pm

Originally posted by -boRg- -boRg- wrote:

Try setting line 907 of register.asp after the Else part to:-

.Fields("Signature") = strSignature

If it fixes the issue please let me know.
Many thanks, I'll give that a try later and let you know how it goes.  I'm fairly sure that should do the trick.
]]> Tue, 06 Jun 2006 17:06:16 +0000 https://forums.webwiz.net/short-registration-page-database-problems_topic20180_post108501.html#108501 <![CDATA[Short Registration Page Database Problems : Yes you would be.mySQL with the...]]> https://forums.webwiz.net/short-registration-page-database-problems_topic20180_post108466.html#108466 Author: WebWiz-Bruce
Subject: 20180
Posted: 06 June 2006 at 10:25am

Yes you would be.

mySQL with the myODBC driver can be buggy and one of those bugs is that when the signature field is set to 'null' certain database updates then fail to work.

The best thing to do is set the signature field to be populated with nothing, rather than have it as a null field, this seems to fix the issue.

Try setting line 907 of register.asp after the Else part to:-

.Fields("Signature") = strSignature

If it fixes the issue please let me know.
]]> Tue, 06 Jun 2006 10:25:25 +0000 https://forums.webwiz.net/short-registration-page-database-problems_topic20180_post108466.html#108466 <![CDATA[Short Registration Page Database Problems : I&#039;m running (and just configuring)...]]> https://forums.webwiz.net/short-registration-page-database-problems_topic20180_post108443.html#108443 Author: SMR Group
Subject: 20180
Posted: 05 June 2006 at 11:26pm

I'm running (and just configuring) 8.02.
 
With the registration form set to the short version, the page errors out with:
 
 
Server Error in Forum Application
An error has occured while writing to the database.
Please contact the forum administrator.
 
Support Error Code:- err_mySQL_register_USR
File Name:- register.asp
 
Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[MySQL][ODBC 3.51 Driver][mysqld-5.0.22-community-nt]Field 'Signature' doesn't have a default value
 
 
The signature field in MySQL is set to "Not Null", which seems to be the problem, it's rejecting the insert because there is no signature field in the short registration form.
 
I can fix this by setting the database field to allowing null entries, but by doing so am I introducing any other problems?
 
Thanks!
]]> Mon, 05 Jun 2006 23:26:25 +0000 https://forums.webwiz.net/short-registration-page-database-problems_topic20180_post108443.html#108443