[RADIATOR] Typo in goodies/blocktime.txt
    Jan Tomasek 
    jan at tomasek.cz
       
    Wed Apr 15 03:14:11 CDT 2009
    
    
  
Hi,
I belive, I've found typo in goodies/blocktime.txt in Radiator 4.4, 
there is:
<AuthBy SQL>
     Identifier Block-Time-SQL
     DBSource        %{GlobalVar:SQLServer1}
     DBUsername      %{GlobalVar:SQLUser1}
     DBAuth          %{GlobalVar:SQLAuth1}
     AuthSelect TIMELEFT from BLOCK_USERS \
         where USERNAME='%n'
I belive it should be:
     AuthSelect select TIMELEFT from BLOCK_USERS \
         where USERNAME='%n'
Without SELECT is SQL server complaining:
> Wed Apr 15 10:08:53 2009: DEBUG: Query is: 'count(*) as count FROM RadOnline WHERE UserName='semik at tomasek.cz'': 
> Wed Apr 15 10:08:53 2009: ERR: Execute failed for 'count(*) as count FROM RadOnline WHERE UserName='semik at tomasek.cz'': 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 'count(*) as count FROM RadOnline WHERE UserName='semik at tomasek.cz'' at line 1
Best regards
-- 
-----------------------
Jan Tomasek aka Semik
http://www.tomasek.cz/
    
    
More information about the radiator
mailing list