| Author | 
            Message | 
        
        
			| 
				
				 Thunderspark 
				Handicapper 
				
					 Joined: Sun Sep 19, 2010 7:29 pm Posts: 242
				 
				 
			 | 
			
				
				  Problem Uploading horses for league  
					
						This will be my first time for the league and I don't really know how this works.  Anyways when I try to click on (View/Enter Races), all I get is an error msg. What am I doing wrong?
 
  
					
  
			 | 
		
		
			| Mon Oct 18, 2010 8:02 pm | 
			
				
					 
					
					 
				  
			 | 
    	
		
	
	
		  | 
	
	
			| 
				
				 nick_driver 
				Group 1 winner 
				
					 Joined: Thu May 15, 2008 2:07 pm Posts: 1256 Location: Redhill
				 
				 
			 | 
			
				
				
					
						 You need to log in first or register if you haven't....guessing you have 
					
  
			 | 
		
		
			| Mon Oct 18, 2010 8:06 pm | 
			
				
					 
					
					 
				  
			 | 
    	
		
	
	
		  | 
	
	
			| 
				
				 DodgyDave 
				Handicapper 
				
					 Joined: Mon Mar 12, 2007 12:23 am Posts: 170
				 
				 
			 | 
			
				
				
					
						Just done some quick checking and it appears to be the case.
 
I'll add it to the list of enhancements I'm going to do when I retire    
					
  
			 | 
		
		
			| Mon Oct 18, 2010 8:38 pm | 
			
				
					 
					
					 
				  
			 | 
    	
		
	
	
		  | 
	
	
			| 
				
				 anubisrich 
				Group 1 winner 
				
					 Joined: Fri Apr 04, 2008 6:53 pm Posts: 2325
				 
				 
			 | 
			
				
				
					
						nick_driver wrote: You need to log in first or register if you haven't....guessing you have  
This is correct  
					
  
			 | 
		
		
			| Mon Oct 18, 2010 8:57 pm | 
			
				
					 
					
					 
				  
			 | 
    	
		
	
	
		  | 
	
	
			| 
				
				 Thunderspark 
				Handicapper 
				
					 Joined: Sun Sep 19, 2010 7:29 pm Posts: 242
				 
				 
			 | 
			
				
				
					
						 Thanx
 
 Everything is working now. 
					
  
			 | 
		
		
			| Mon Oct 18, 2010 9:40 pm | 
			
				
					 
					
					 
				  
			 | 
    	
		
	
	
		  | 
	
	
			| 
				
				 David1uk 
				Group 3 winner 
				
					 Joined: Sun May 27, 2007 1:31 am Posts: 694 Location: Doncaster
				 
				 
			 | 
			
				
				
					
						 Hi DD
 
 When i click on any horse from the the past history page i get this message 
 
 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 'AND ((rac_seas<4) or (rac_seas=4 AND adj_wk <= 1)) ORDER BY rac_seas, adj_wk' at line 1
 
 hope you can fix this if its no trouble 
					
  
			 | 
		
		
			| Tue Oct 19, 2010 1:56 pm | 
			
				
					 
					
					 
				  
			 | 
    	
		
	
	
		  | 
	
	
			| 
				
				 N3W_4PPROACH 
				
				
					
				 
				 
			 | 
			
				
				
					
						 I had a similar problem, when i went to upload Sea Bird, it said error:SQL:Thishorseistogoodfortheleague:richisscared:
 
 I eventually hacked into the mainframe and got him uploaded anyway so no problem. 
					
  
			 | 
		
		
			| Tue Oct 19, 2010 4:33 pm | 
			
				
					 
					
					 
				
			 | 
    	
		
	
	
		  | 
	
	
			| 
				
				 anubisrich 
				Group 1 winner 
				
					 Joined: Fri Apr 04, 2008 6:53 pm Posts: 2325
				 
				 
			 | 
			
				
				
					
						 I am le terrified 
					
  
			 | 
		
		
			| Tue Oct 19, 2010 6:38 pm | 
			
				
					 
					
					 
				  
			 | 
    	
		
	
	
		  | 
	
	
			| 
				
				 hackett 
				Group 1 winner 
				
					 Joined: Mon Jun 22, 2009 4:17 pm Posts: 1049 Location: Southampton
				 
				 
			 | 
			
				
				
					
						N3W_4PPROACH wrote: I had a similar problem, when i went to upload Sea Bird, it said error:SQL:Thishorseistogoodfortheleague:richisscared:
  I eventually hacked into the mainframe and got him uploaded anyway so no problem.  
great post N/A    .  
					
  
			 | 
		
		
			| Tue Oct 19, 2010 9:39 pm | 
			
				
					 
					
					 
				  
			 | 
    	
		
	
	
		  | 
	
	
			| 
				
				 DodgyDave 
				Handicapper 
				
					 Joined: Mon Mar 12, 2007 12:23 am Posts: 170
				 
				 
			 | 
			
				
				
					
						David1uk wrote: Hi DD
  When i click on any horse from the the past history page i get this message 
  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 'AND ((rac_seas<4) or (rac_seas=4 AND adj_wk <= 1)) ORDER BY rac_seas, adj_wk' at line 1
  hope you can fix this if its no trouble  
So do I   
Will have a look when I get a chance but it won't be the next 24 hours.
 We'll be getting our gold watches soon    
					
  
			 | 
		
		
			| Tue Oct 19, 2010 10:10 pm | 
			
				
					 
					
					 
				  
			 | 
    	
		
	
	
		  | 
	
	
			| 
				
				 dragontrainer 
				Group 3 winner 
				
					 Joined: Sat Jul 25, 2009 1:50 am Posts: 541 Location: W. Yorkshire
				 
				 
			 | 
			
				
				
					
						N3W_4PPROACH wrote: I had a similar problem, when i went to upload Sea Bird, it said error:SQL:Thishorseistogoodfortheleague:richisscared:
  I eventually hacked into the mainframe and got him uploaded anyway so no problem.  
Excellent!
 Unfortunately I would get the exact opposite response, if TOM could make a noise I`m sure it would be laughing and chuckling as I do my uploads.  
					
  
			 | 
		
		
			| Tue Oct 19, 2010 11:16 pm | 
			
				
					 
					
					 
				  
			 | 
    	
		
	
	
		  | 
	
	
			| 
				
				 DodgyDave 
				Handicapper 
				
					 Joined: Mon Mar 12, 2007 12:23 am Posts: 170
				 
				 
			 | 
			
				
				
					
						If TOM had a twin, I suspect it make a noise like a drum    
					
  
			 | 
		
		
			| Wed Oct 20, 2010 1:00 am | 
			
				
					 
					
					 
				  
			 | 
    	
		
	
	
		  | 
	
	
	
		 |