| Author |  Topic  | 
              
                | JohnJohn1186Junior Member
 
   
 
                103 Posts | 
                    
                      |  Posted - 28 November 2004 :  15:44:08   
 |  
                      | Microsoft JET Database Engine error '80040e14' 
 Number of query values and destination fields are not the same.
 
 /vertical/forum/register.asp, line 576
 
 
 Any suggestings? I cant finish my forum.
 
 Here is the script, btw:
 
 strSql = strSql & ", 1"
 strSql = strSql & ")"
 
 LINE 576		my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
 
 if strEmail = "1" and strEmailVal = "1" then
 |  
                      | Edited by - ruirib on 28 November 2004  16:49:30
 |  | 
              
                | JohnJohn1186Junior Member
 
   
 
                103 Posts | 
                    
                      |  Posted - 28 November 2004 :  15:45:11   
 |  
                      | someone tried to register, but it messed up. I guess adding that mod did something to it |  
                      |  |  | 
              
                | NikkolForum Moderator
 
      
 
                USA6907 Posts
 | 
                    
                      |  Posted - 28 November 2004 :  15:47:55   
 |  
                      | the error is just as it sounds.  somewhere in your sql statement, you added a field name but did not add the value or visa versa.  go over the changes for whatever mod you added. |  
                      | Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
 |  
                      |  |  | 
              
                | JohnJohn1186Junior Member
 
   
 
                103 Posts | 
                    
                      |  Posted - 28 November 2004 :  15:58:37   
 |  
                      | Would this mess up my active users page if i reinstalled the non-modded version? |  
                      |  |  | 
              
                | Jorrit787Average Member
 
    
 
                Netherlands681 Posts
 | 
                    
                      |  Posted - 28 November 2004 :  16:09:42     
 |  
                      | If you're talking about the whole forum then, yes, it would... The active/inactive status wouldn't be processed anymore, and some other problems would occur - I wouldn't recommend it. I would get a version of register.asp when it was still working, and re-edit it for the MOD you want to install. |  
                      | eXtremeGossip
  |  
                      |  |  | 
              
                | JohnJohn1186Junior Member
 
   
 
                103 Posts | 
                    
                      |  Posted - 28 November 2004 :  16:12:35   
 |  
                      | well, i didnt try to install another mod...its still the same mod. can i send you the register.asp code? |  
                      |  |  | 
              
                | JohnJohn1186Junior Member
 
   
 
                103 Posts | 
                    
                      |  Posted - 28 November 2004 :  16:13:38   
 |  
                      | you can visit the register.asp, but it that error comes up when trying to submit the registration information |  
                      |  |  | 
              
                | Jorrit787Average Member
 
    
 
                Netherlands681 Posts
 | 
                    
                      |  Posted - 28 November 2004 :  16:19:19     
 |  
                      | quote:Originally posted by JohnJohn1186
 
 well, i didnt try to install another mod...its still the same mod. can i send you the register.asp code?
 
 Sure you can, I'll have a look
  |  
                      | eXtremeGossip
  |  
                      |  |  | 
              
                | JohnJohn1186Junior Member
 
   
 
                103 Posts | 
                    
                      |  Posted - 28 November 2004 :  16:22:45   
 |  
                      | whats ur email? |  
                      |  |  | 
              
                | Jorrit787Average Member
 
    
 
                Netherlands681 Posts
 |  | 
              
                | JohnJohn1186Junior Member
 
   
 
                103 Posts | 
                    
                      |  Posted - 28 November 2004 :  16:30:50   
 |  
                      | you got mail |  
                      |  |  | 
              
                | Jorrit787Average Member
 
    
 
                Netherlands681 Posts
 |  | 
              
                | JohnJohn1186Junior Member
 
   
 
                103 Posts | 
                    
                      |  Posted - 28 November 2004 :  22:48:07   
 |  
                      | Oh no man! You made it worse! Now i cant even open the register.asp heres da error: 
 Microsoft VBScript compilation error '800a03f6'
 
 Expected 'End'
 
 /vertical/forum/register.asp, line 610
 
 else
 ^
 
 
 CODE:
 
 <!--#INCLUDE FILE="inc_mail.asp" -->
 <%
 end if
 LINE 610		else
 Response.Write	"      <p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strHeaderFontSize & """ color=""" & strHiLiteFontColor & """>There Was A Problem With Your Details</font></p>" & vbNewLine & _
 |  
                      |  |  | 
              
                | JohnJohn1186Junior Member
 
   
 
                103 Posts | 
                    
                      |  Posted - 28 November 2004 :  22:49:48   
 |  
                      | n/m about that man...i just added another end if and got it to work! Wow, your rubbing off on me lol |  
                      |  |  | 
              
                | JohnJohn1186Junior Member
 
   
 
                103 Posts | 
                    
                      |  Posted - 28 November 2004 :  22:53:21   
 |  
                      | Ok, it works and all now, however, when ever i try to register it doesnt save it or something because i tried to register a new name, and it does not save that registration data...kinda like the poll mod i tried to install...it doesnt save the configuration on that either. >_<...any help? |  
                      |  |  | 
              
                | TamNew Member
 
  
 
                Sweden56 Posts
 | 
                    
                      |  Posted - 29 November 2004 :  04:20:44     
 |  
                      | Try to update your forumvariables with "Check installation" in the admin-settings. |  
                      |  |  | 
              
                
                |  Topic  |  |