| Author |
 Topic  |
|
lancem
Starting Member
USA
10 Posts |
 Posted - 26 November 2004 : 22:51:57
|
Where to start fixing the following???
Microsoft OLE DB Provider for SQL Server error '80040e14'
There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.
/register.asp, line 576 |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 26 November 2004 : 23:11:12
|
you have more values trying to be inserted into a database than you have columns.
for example:
INSERT INTO myTable (fldOne, fldTwo, fldThree) VALUES ('One', 'Two', 'Three', 'Four')
by trying to insert the value 'Four' I have caused the same error because there are only 3 fields declared. Look at your SQL statement and make sure everything matches up. |
 |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
lancem
Starting Member
USA
10 Posts |
Posted - 27 November 2004 : 07:48:01
|
| I have 2-mods installed but I thought they were done when site was still running on Access DB and before upgrade to SQL. Maybe not? Other than the mods, no other code modified for any reason. Mods work, but guess I missed something else? |
Edited by - lancem on 27 November 2004 14:14:16 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 27 November 2004 : 09:54:46
|
You need the check the Active Users Mod's instructions regarding the statements preceding line 576, because there is some error there.
You may also add these lines
Response.Write strSql
Response.End
just before line 576 and post the output here. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
lancem
Starting Member
USA
10 Posts |
Posted - 27 November 2004 : 12:35:23
|
| Okay, I have reviewed the Active Users Mod step by step. Obviously I am overlooking something. |
Edited by - lancem on 27 November 2004 14:13:40 |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
lancem
Starting Member
USA
10 Posts |
Posted - 27 November 2004 : 13:37:05
|
Here is the result from adding Response.Write strSql:
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_AUHIDE, M_SHA256) VALUES ('barney', '6b86b273ff34fce19d6b804eff5a3f5747ada4eaa22f1d49c01e52ddb7875b4b', 'pwc512n1f21df376y2yyu74y5s5rt4c7', -1, 1, 'barney@gibsoncity.net', '20041127143252', ' ', ' ', ' ', ' ', ' ', 0, ' ', '20041127143252', 0, 1 , '12.109.70.70', '12.109.70.70', ' ', 1, 1, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '', '', '', '', ' ', '', '', '', ' ', 1), '1' |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
Posted - 27 November 2004 : 13:51:01
|
Find the following code in your register.asp (lines 563-672): if strQuote = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'"
else
if strAUAnon = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("AUHide"),"") & "'"
else
strSql = strSql & ", '1'"
end if
strSql = strSql & ", ''"
end ifand replace it with the following code: if strQuote = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'"
else
strSql = strSql & ", ''"
end if
if strAUAnon = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("AUHide"),"") & "'"
else
strSql = strSql & ", '1'"
end if |
My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch
Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
|
|
|
|
lancem
Starting Member
USA
10 Posts |
Posted - 27 November 2004 : 14:01:30
|
Actually OWM, before I read your code fix, I moved the line
strSql = strSql & ")"
to just before
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
After doing the Response.Write I noticed the closing ")" was not the last character. Seems like that fixed the immediate problem but I wonder if I have caused something else to not work? |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
lancem
Starting Member
USA
10 Posts |
Posted - 27 November 2004 : 17:10:35
|
| Sorry OWM, I don't understand the specifics of your question. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
lancem
Starting Member
USA
10 Posts |
Posted - 27 November 2004 : 18:16:17
|
For one, I noticed in my admin profile it is set to "show on active users" = NO but still does so up. I never receive emails even though I am subscribed to the whole board. Honestly cannot ever remember getting email notices. I am sure this is totally unrelated to the recent issue.
Any idea what OWM means? "Can you update the link with the latest version of the file?" |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
Topic |
|
|
|
Topic Locked
