Author |
Topic |
|
webby4x4
Starting Member
44 Posts |
Posted - 18 April 2006 : 22:34:40
|
**Snitz Forums 2000 Version 3.4.04** **Mods installed = Avatar, active users, email validation **
A relatively new problem crept up on me the other day and I'm looking for some expert help (will be GREATLY appreciated)!!!
Anyhow, if a new user goes to register on the forums at: http://www.4x4review.com/discussions2/register.asp?mode=Register, enters the information, they are presented with the following error:
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.
/discussions2/register.asp, line 558
This is line 558: my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
In looking at the code, there are a number of references to the "values" clauses, and they all point to the "Avatar" mod, but that works fine (e.g. I can change avatars, upload avatars, users change them all of the time, etc.).
Any help with this will be immesley appreciated.
Thank you, Rick |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 18 April 2006 : 23:11:59
|
Don't what mod it was, but you definitely made a mistake adding a mod. Look at each of your mods and review the instructions for register.asp, around that line.
You can also post a link to a text version of you register.asp file. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
webby4x4
Starting Member
44 Posts |
Posted - 19 April 2006 : 09:18:03
|
Thanks Ruirib... It started crapping out on me a few weeks ago, but I haven't made any code changes for at least 3 months. I know, it sounds like typical BS, but this has got me scrtching my head.
At any rate, here's a link to a text version of this: http://www.4x4review.com/discussions2/register-asp.txt
I would really appreciate any help you might offer.
Thanks again! Rick |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 19 April 2006 : 10:02:56
|
It could be that no one has tried to register in 3 months too... done that one a couple of times...
I don't see anything that jumps right out (but I am only on the second cup of coffee...)
Have you done a Response.Write of the SQL? |
|
|
webby4x4
Starting Member
44 Posts |
Posted - 19 April 2006 : 11:18:36
|
OK... it looks like it's bombing out where it's trying to insert "M_SHA256"... there is no value associated with it, so the number of inserts does not match the number of values. Here is the result set of the "reponse.write StrSql"...
SELECT M_EMAIL FROM FORUM_MEMBERS WHERE M_EMAIL = 'rick_webster@hotmail.com'
INSERT INTO FORUM_MEMBERS (M_NAME, M_PASSWORD, 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, M_AVATAR_URL)
VALUES ('user_name', '5e884898da28047151d0e56f8dc6292773603d0d6aabbdd62a11ef721d1542d8', 'rick_webster@hotmail.com', '20060419081407', 'USA', 'aim-1234@hotmail.com', '12345icq789', 'nobody@msn.com', 'nobody@yahoo.com', 0, 'http://www.homepage.com', '20060419081407', 1, 1 , '205.242.83.13', '205.242.83.13', 'test signature', 1, 1, 'Joe', 'Blow', 'Tacoma', 'WA', 'http://www.picture.com/url/', 'http://www.coollinks1.com', 'http://www.coolinks2.com', '', '', 'married', 'Male', 'plumber', 'test bio', 'test hobbies', 'test news', 'test favorite quote', 1, '/discussions2/avatars/4x4-1.gif') <-- There should be a value for SHA256 just before the avatar gif.
So...
What does the SHA256 do? / What is it? And, how can this be fixed?
Thanks again, in advance, for your help on this. You have no idea how much I appreciate it.
P.S. I deleted the earlier posts in the thread to make this easier to read.
Rick |
Edited by - webby4x4 on 19 April 2006 11:21:04 |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 19 April 2006 : 11:24:54
|
I suspect that the problem may be with the Active Users MOD and the "M_AUHIDE" field. I do not have that MOD, but the SQL Statement in question on my forum sets M_SHA256 to 1. I see the 1 in the right place, and I see the quote in the right place, but I don't think that M_AUHIDE is being assigned a value.
Just make a backup before you go buck wild testing. |
|
|
webby4x4
Starting Member
44 Posts |
Posted - 19 April 2006 : 13:35:22
|
Thanks a ton guys! I backed out a few lines of code and now it's all fixed.
Ya saved my bacon!
Thanks again, Rick |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 19 April 2006 : 14:02:25
|
Glad its all working now. |
|
|
webby4x4
Starting Member
44 Posts |
Posted - 19 April 2006 : 14:07:14
|
yeah, me too. Thanks for the second set of eyes on this... it's been many months since I've touched code and I got rusty real fast. ;) |
|
|
|
Topic |
|
|
|