|
|
#61
01-07-2007, 06:58 PM
|
|||
|
|||
Re: v1.03
[ QUOTE ]
[ QUOTE ] creates files with no endings such as this "20070107111033_Stars" ??? [/ QUOTE ] Oh - that may be that password problem. Have a look at this post. [/ QUOTE ] That should be an error log TXT file, viewable in notepad. The postgres function should delete it if all went well. If it's not the password thing, I'd wager it is the spaces in your DB names - I never thought about that since I never bother to reneme my DBs, they are all PTPGSQL! etc. Alteration of the psql function with this changed line I hope will fix it: <font class="small">Code:</font><hr /><pre> command := "psql.exe -A -t -h " . host . " -p 5432 -U " . username . " -d """ . database . """ -f " . file1 . " -o " . file2 . " 2> " . file3 </pre><hr /> I just put quotes around the database variable. Seems to cause no problem on my databases, so I guess it should work for ones with spaces in the names [img]/images/graemlins/smile.gif[/img] I'll probably make a testing database later and try it out... dave. 
|
|
#64
01-07-2007, 07:10 PM
|
|||
|
|||
|
Re: v1.03
[ QUOTE ]
'psql.exe' is not recognized as an internal or external command, operable program or batch file. [/ QUOTE ] go to "c:\program files\Postgresql8.0\bin" copy psql.exe to the same folder as the script. That's the easy way to fix this. Otherwise add postgres bin directory to your PATH variable, a little more complicated, but thn psql is available in any location.
|
|
#65
01-07-2007, 07:49 PM
|
|||
|
|||
|
Re: v1.03
ok dave i copied the file into the folder. new error log contains this... (im importing hands atm in pokertracker not sure if that is casuing an error)
20070107154722_Stars: Permission denied psql: warning: extra command-line argument "MAIN" ignored psql: warning: extra command-line argument "Buddy" ignored psql: warning: extra command-line argument "List.ahk_7048_in.txt" ignored psql: warning: extra command-line argument "Buddy" ignored psql: warning: extra command-line argument "List.ahk_7048_out.txt" ignored psql: warning: extra command-line argument "Buddy" ignored psql: warning: extra command-line argument "List.ahk_7048_error.txt" ignored psql: FATAL: database "STARS" does not exist
|
|
#66
01-07-2007, 08:01 PM
|
|||
|
|||
|
Re: v1.03
[ QUOTE ]
ok dave i copied the file into the folder. new error log contains this... (im importing hands atm in pokertracker not sure if that is casuing an error) 20070107154722_Stars: Permission denied psql: warning: extra command-line argument "MAIN" ignored psql: warning: extra command-line argument "Buddy" ignored psql: warning: extra command-line argument "List.ahk_7048_in.txt" ignored psql: warning: extra command-line argument "Buddy" ignored psql: warning: extra command-line argument "List.ahk_7048_out.txt" ignored psql: warning: extra command-line argument "Buddy" ignored psql: warning: extra command-line argument "List.ahk_7048_error.txt" ignored psql: FATAL: database "STARS" does not exist [/ QUOTE ] Now that is what I'd expect to see because of spaces in the DB names. open your copy of Roland's Functions (functions.ahk) in notepad, scroll right to the end. IIRC the psql function is the last one in there. change the line I posted a correction for out a few posts up ( command := psql .... ). Hopefully fixed it (or at least gives us different errors) dave.
|
|
#67
01-07-2007, 08:56 PM
|
|||
|
|||
|
Re: v1.03
ok dave.
i copied and pasted that line (i didn't change anything to it, not sure if i should have or not). Got these errors. 20070107165554_Stars: Permission denied psql: warning: extra command-line argument "-" ignored psql: warning: extra command-line argument "10/20" ignored psql: warning: extra command-line argument "6" ignored psql: warning: extra command-line argument "MAX" ignored psql: warning: extra command-line argument "OBSERVED" ignored psql: warning: extra command-line argument "Buddy" ignored psql: warning: extra command-line argument "List.ahk_9702_in.txt" ignored psql: warning: extra command-line argument "Buddy" ignored psql: warning: extra command-line argument "List.ahk_9702_out.txt" ignored psql: warning: extra command-line argument "Buddy" ignored psql: warning: extra command-line argument "List.ahk_9702_error.txt" ignored psql: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. 20070107165555_Stars: Permission denied psql: warning: extra command-line argument "MAIN" ignored psql: warning: extra command-line argument "Buddy" ignored psql: warning: extra command-line argument "List.ahk_2040_in.txt" ignored psql: warning: extra command-line argument "Buddy" ignored psql: warning: extra command-line argument "List.ahk_2040_out.txt" ignored psql: warning: extra command-line argument "Buddy" ignored psql: warning: extra command-line argument "List.ahk_2040_error.txt" ignored psql: FATAL: database "STARS" does not exist
|
|
#68
01-08-2007, 07:37 AM
|
|||
|
|||
|
Re: v1.03
Sorry for the mess, I forgot that the postgres function doesn't work out-of-box. I added daves instructions for getting it to work to the documentation and added the double-quotes fix to my functions (please download again if you are having trouble getting the SQL part to work).
|
 |
|
|
Linear Mode
