Quakebum, sorry for slow response. Can i confirm that the view/query produces a table of results on the wp-admin page but there is no output at all, not even an empty table, on a public facing page.
I have just tried creating a one column table not starting with the prefix WP, using dbview
create table mytable (name varchar(16))
followed by
insert mytable values('hello world')
and created a view containing
select * from mytable
embedded that view in a page and I get a 1 row table.
I am disappointed that there is no error. Is the table very large? are you running out of memory? Can you simplify the query i.e. show just one column or one row and see whether this works. Can you embed a query/view for another table like say wp_posts? If there is a bug, I would like to fix it. I am happy to try your table and query.
