Short Registration Page Database Problems
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20180
Printed Date: 11 April 2026 at 11:42am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Short Registration Page Database Problems
Posted By: SMR Group
Subject: Short Registration Page Database Problems
Date 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!
|
Replies:
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: SMR Group
Date Posted: 06 June 2006 at 5:06pm
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.
|
-boRg- wrote:Posted By: SMR Group
Date Posted: 11 June 2006 at 2:33am
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.
|
Posted By: WebWiz-Bruce
Date 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.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |