| Author | 
                
                  Topic   | 
                  | 
               
              
                | 
                 Carefree 
                Advanced Member 
                      
                 
                
                Philippines 
                4224 Posts  | 
                
                  
                    
                      
                       Posted - 20 May 2016 :  07:26:31
                        
                        
                      
  | 
                     
                    
                       Here's an excerpt from "post_info.asp":
 
 
  Now, here's the result:
  There has been a problem!
  INSERT INTO FORUM_FORUM (CAT_ID, F_PARENT, F_STATUS, F_PRIVATEFORUMS, F_LAST_POST, F_LAST_POST_AUTHOR, F_SUBJECT, F_URL, F_DESCRIPTION, F_TYPE, F_L_ARCHIVE, F_ARCHIVE_SCHED, F_L_DELETE, F_DELETE_SCHED, F_SUBSCRIPTION, F_MODERATION, F_ORDER, F_DEFAULTDAYS) VALUES (3, , 1, 0, '20160520170043', 1, 'Snitz Forums', 'http://forum.snitz.com/forum', 'Snitz Forums 2000', 1, '', 30, '', 365, 0, 0, 1, 30) There was an error = Syntax error in INSERT INTO statement.
  Go back to correct the problem.
 
 
 
  I've looked at this until I went cross-eyed.  Can't see the issue. | 
                     
                   
                 | 
               
              
                | 
                 HuwR 
                Forum Admin 
                      
                 
                
                United Kingdom 
                20611 Posts  | 
                
                  
                    
                      
                       Posted - 20 May 2016 :  08:06:58
                        
                        
                      
  | 
                     
                    
                       My gues is this bit here INSERT INTO FORUM_FORUM (CAT_ID, F_PARENT, F_STATUS, F_PRIVATEFORUMS, F_LAST_POST .... VALUES (3,There should be either a value or NULL here , 1, 0, '20160520170043'
  As you can see, there is no value for F_PARENT in the corresponding VALUES section | 
                     
                    
                        | 
                     
                   
                 | 
               
              
                | 
                 Carefree 
                Advanced Member 
                      
                 
                
                Philippines 
                4224 Posts  | 
                
                  
                    
                      
                       Posted - 20 May 2016 :  09:46:55
                        
                      
  | 
                     
                    
                      |  Found it.  It was actually caused by another section of code, a method_type comparison didn't include URLs. | 
                     
                    
                        | 
                     
                   
                 | 
               
              
                |   | 
                
                  Topic   | 
                  | 
               
             
           | 
         
       
     |