| Author | 
                
                  Topic   | 
                  | 
              
              
                | 
                 HellRazor 
                New Member 
                  
                 
                
                59 Posts  | 
                
                  
                    
                      
                       Posted - 29 April 2001 :  20:50:13
                        
                      
  | 
                     
                    
                       Can anyone tell me what is wrong with this SQL statement?  My Snitz forum errors out when trying to edit messages, here is the SQL statement and the error I am getting:
  SELECT FORUM_TOPICS.CAT_ID, FORUM_TOPICS.FORUM_ID, FORUM_TOPICS.TOPIC_ID, FORUM_TOPICS.T_SUBJECT, FORUM_TOPICS.T_AUTHOR, FORUM_TOPICS.T_MAIL, FORUM_TOPICS.T_MESSAGE , FORUM_TOPICS.T_ORDER FROM FORUM_TOPICS WHERE FORUM_TOPICS.TOPIC_ID = 4 AND FORUM_TOPICS.T_STATUS = 1  Microsoft JET Database Engine error '80040e10' 
  No value given for one or more required parameters 
  /forum/post.asp, line 454 
 
 
  | 
                     
                   
                 | 
              
              
                | 
                 HuwR 
                Forum Admin 
                      
                 
                
                United Kingdom 
                20611 Posts  | 
                
                  
                    
                      
                       Posted - 29 April 2001 :  21:14:28
                        
                        
                      
  | 
                     
                    
                       DO you have the topic sorting MOD installed ? if not then this FORUM_TOPICS.T_ORDER is what is causing your problem
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 HellRazor 
                New Member 
                  
                 
                
                59 Posts  | 
                
                  
                    
                      
                       Posted - 29 April 2001 :  23:21:03
                        
                      
  | 
                     
                    
                       Yep, its installed.  In fact I'm running the latest HUWR Snitz forum with a few mods added to it (mainly the Avatar mod).
  HellRazor
 
 
 quote:
  DO you have the topic sorting MOD installed ? if not then this FORUM_TOPICS.T_ORDER is what is causing your problem
   
 
  
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 HellRazor 
                New Member 
                  
                 
                
                59 Posts  | 
                
                  
                    
                      
                       Posted - 29 April 2001 :  23:39:25
                        
                      
  | 
                     
                    
                       Well, I take that back...does the HUWR forum come with this mod installed?
  If not, I think these changes might be part of the Content Management System, which I also added.
 
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 HellRazor 
                New Member 
                  
                 
                
                59 Posts  | 
                
                  
                    
                      
                       Posted - 29 April 2001 :  23:44:02
                        
                      
  | 
                     
                    
                       In any event, I checked my database and it didn't have that field included...I added it and that seems to have fixed the problem.
  Can you point me to where this mod is located?  I'm betting that I only have the mod partially installed from when I added the Content Management System.
  Thanks for your help!
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                |   | 
                
                  Topic   | 
                  |