WordPress.org

Ready to get started?Download WordPress

Forums

dbview
Why limit to WP tables? (3 posts)

  1. Quakebum
    Member
    Posted 2 years ago #

    John,

    Why did you decide to only allow querying from wp tables?

    I have some data stored on another table in the same db, it would be great to be able to query that as well.

    http://wordpress.org/extend/plugins/dbview/

  2. Quakebum
    Member
    Posted 2 years ago #

    I take it back, you can query other tables, but it's not showing up in my post. I've checked public, but blank with no errors.

  3. john ackers
    Member
    Plugin Author

    Posted 2 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags