| Author |
 Topic  |
|
|
Beano_ie
Junior Member
Ireland
328 Posts |
 Posted - 05 April 2005 : 07:41:44
|
Was using Snitz V 3.4.03, upgraded it to V 3.4.05, since upgrading, new users are unable to register. Upon completing the registration form, and clicking on 'Submit', they get the following error;
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/forum/register.asp, line 571
Line 571 reads;
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
You can view the full register code by clicking here.
Any help would be greatly appreciated, I have not edited the register file in any way. |
Steve
Drogheda, Ireland @ www.droghedatown.com |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
Beano_ie
Junior Member
Ireland
328 Posts |
Posted - 05 April 2005 : 08:42:30
|
INSERT INTO FORUM_MEMBERS_PENDING (M_NAME, M_PASSWORD, M_KEY, M_LEVEL, M_APPROVE, M_EMAIL, M_DATE, M_COUNTRY, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_POSTS, M_HOMEPAGE, M_LASTHEREDATE, M_STATUS, M_RECEIVE_EMAIL, M_LAST_IP, M_IP, M_SIG, M_VIEW_SIG, M_SIG_DEFAULT, M_FIRSTNAME, M_LASTNAME, M_CITY, M_STATE, M_PHOTO_URL, M_LINK1, M_LINK2, M_AGE, M_DOB, M_MARSTATUS, M_SEX, M_OCCUPATION, M_BIO, M_HOBBIES, M_LNEWS, M_QUOTE, M_SHA256, M_AVATAR_URL) VALUES ('Ddfgds', '5656f687e127sgdsfg86ddsjklhfs76fsdk3jd093122a6f49b0c62176', '2l04hv4x570mnogn4pk1k0t7vu58xs7q', -1, 1, 'XXX@Xmail.com', '20050412743934', ' ', ' ', ' ', ' ', ' ', 0, ' ', '200545645133934', 0, 1 , '194.46.73.21', '194.46.73.21', ' ', 1, 1, ' ', ' ', ' ', '', '', ' ', ' ', ' ', '', '', ' ', '', '', ' ', ' ', ' ', 1)
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/forum/register.asp, line 573 |
Steve
Drogheda, Ireland @ www.droghedatown.com |
Edited by - Beano_ie on 05 April 2005 10:18:55 |
 |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
Beano_ie
Junior Member
Ireland
328 Posts |
Posted - 05 April 2005 : 10:17:59
|
Yes Podge, that was exactley it, one line of code;
strSql = strSql & ", '" & ChkString(Request.Form("Avatar_URL"),"SqlString") & "'"
Having put the response.write strSql in register.asp I should have realised that if register.asp was not modified that the avatar Mod would have caused an error.
Thansk for your time a chairde. |
Steve
Drogheda, Ireland @ www.droghedatown.com |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
| |
Topic |
|
|
|
Topic Locked
