Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Users cannot register - 500 error
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

webby4x4
Starting Member

44 Posts

Posted - 18 April 2006 :  22:34:40  Show Profile
**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  Show Profile  Send ruirib a Yahoo! Message
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
Go to Top of Page

webby4x4
Starting Member

44 Posts

Posted - 19 April 2006 :  09:18:03  Show Profile
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
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 19 April 2006 :  10:02:56  Show Profile  Visit AnonJr's Homepage
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?
Go to Top of Page

webby4x4
Starting Member

44 Posts

Posted - 19 April 2006 :  11:18:36  Show Profile
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
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 19 April 2006 :  11:24:54  Show Profile  Visit AnonJr's Homepage
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.
Go to Top of Page

webby4x4
Starting Member

44 Posts

Posted - 19 April 2006 :  13:35:22  Show Profile
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
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 19 April 2006 :  14:02:25  Show Profile  Visit AnonJr's Homepage
Glad its all working now.
Go to Top of Page

webby4x4
Starting Member

44 Posts

Posted - 19 April 2006 :  14:07:14  Show Profile
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. ;)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.36 seconds. Powered By: Snitz Forums 2000 Version 3.4.07