Page 1 of 1
table_name returns empty array
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
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?