Error adding Admin
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz NewsPad
Forum Description: Support forum for the Web Wiz NewsPad application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=23003
Printed Date: 28 March 2026 at 6:03am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Error adding Admin
Posted By: j172
Subject: Error adding Admin
Date Posted: 29 March 2007 at 9:03am
|
Hi
When trying to add a new admin user i get the following error message:
Server Error in Forum Application
An error has occurred while updating database. Please contact the Newsletter Administrator. Support Error Code:- err_Access_add_new_admin File Name:- admin_add_admin_user.asp Error details:- Microsoft JET Database Engine Syntax error in INSERT INTO statement. I'm using the Access database
Regards
Joel
|
Replies:
Posted By: MrMellie
Date Posted: 29 March 2007 at 9:48am
| I've tried that but with MS SQL as the backend and it worked ok. |
Posted By: WebWiz-Bruce
Date Posted: 29 March 2007 at 10:41am
|
Looks like the problem is Access doesn't like the word 'Password' in an Insert SQL query to the database without square brackets around it, SQL server doesn't mind, and mySQL will crash if you do have square brackets. The solution for the Access version is to edit the SQL query around line 86 and change the word Password to:- [Password] ------------- 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: MrMellie
Date Posted: 29 March 2007 at 10:53am
|
Oddly, "password" isn't listed as one of Access's reserved words.
http://support.microsoft.com/default.aspx?scid=kb;en-us;209187 - http://support.microsoft.com/default.aspx?scid=kb;en-us;209187
|
Posted By: WebWiz-Bruce
Date Posted: 29 March 2007 at 11:00am
|
It does seem very odd and didn't come up in testing as originally the Insert statement had brackets around all form fields which both Access and SQL Server like, but these were removed when adding mySQL support as mySQL doesn't like the use of square brackets.
------------- 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: MrMellie
Date Posted: 29 March 2007 at 11:43am
Thanks for the heads up on square brackets and MySQL. I've been naughty and used a reserved word in one of the Photo Album add-on tables. I haven't tested it on MySQL yet, but it looks like it's time to go and do some field name changing! 
|
Posted By: j172
Date Posted: 29 March 2007 at 5:05pm
|
Works a treat
Thanks
|