Page 1 of 1

table_name returns empty array

PostPosted: Tue Jan 22, 2013 2:39 pm
by samweiss
The sql query "SELECT ALL table_name FROM tourney_holdem_table"

is returning an empty array on my machine.

Do I need to add an additional table to the FROM statement?

Re: table_name returns empty array

PostPosted: Tue Jan 22, 2013 2:49 pm
by kraada
I don't think you should, do you have holdem tournaments imported into your database?

Re: table_name returns empty array

PostPosted: Tue Jan 22, 2013 2:51 pm
by samweiss
Im certain that I do have tournaments imported.

I can read the tournament start times with

query ='SELECT ALL id_table FROM tourney_holdem_hand_summary';


but "table_name" is always empty

Re: table_name returns empty array

PostPosted: Tue Jan 22, 2013 3:00 pm
by samweiss
This is strange -

I can access table names from holdem_table, perfectly, but nothing from tourney_holdem_table.

Tournaments must be in the database because I can read their start times

Re: table_name returns empty array

PostPosted: Tue Jan 22, 2013 4:17 pm
by kraada
I've never had a report of that particularly being broken before. I don't have a PT3 database handy to test on right now but in PT4 the analogous table does populate properly for tournaments.

Re: table_name returns empty array

PostPosted: Wed Jan 23, 2013 2:46 pm
by samweiss
Could you please test a PT3 database, just to confirm whether it is a problem with my install or PT3 in general?