Displaying Zero Rows

  • Resolved thetouchstudios

    (@thetouchstudios)


    9 years, 3 months ago

    Every table I try to connect to shows zero rows.

    Here are all the options I have tried for each table.

    add_db_table_editor(‘title=Consultants&table=news_consultants’);

    add_db_table_editor(array(
    ‘title’=>’Consultants’,
    ‘table’=>’news_consultants’,
    ‘sql’=>’SELECT * FROM news_consultants ORDER BY Consultant_ID DESC’,
    ‘id_column’=>’Consultant_ID’
    ));

    add_db_table_editor(array(
    ‘title’=>’Consultants’,
    ‘table’=>’news_consultants’,
    ‘sql’=>’SELECT * FROM news_consultants ORDER BY Consultant_ID DESC’,
    ));

    add_db_table_editor(array(
    ‘title’=>’Consultants’,
    ‘table’=>’news_consultants’,
    ‘sql’=>’SELECT * FROM news_consultants’,
    ));

    https://www.ads-software.com/plugins/wp-db-table-editor/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author bobbysmith007

    (@bobbysmith007)

    I think this was probably due to a bug in the plugin that I have just released a fix for. Please try 1.5.2 and see if your problem is resolved.

    The problem may have cropped up again with v 1.5.3. I am trying to display a table (not using SELECT) and no rows are displaying. What was the resolution or fix to this issue?

    Same issue. Just installed 1.5.3 and 0 rows on every table. Also having permissions issues accessing any tables, even though I am logged in as admin user.

    0 rows issue fixed. Not a plugin problem.

    Plugin Author bobbysmith007

    (@bobbysmith007)

    tfrancois:

    The plugin displaying 0 rows is just a general sign of failure and doesnt point to any specific cause. You should enable wordpress debugging and database debugging (define(‘WP_DEBUG_DISPLAY’, true);define(‘WP_DEBUG’, true);) and look for error output on your page. You can also examine the javascript console and look for client errors.

    Once you have found a specific error message and provided the configuration you are using to cause it, I can probably help you find the answer

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Displaying Zero Rows’ is closed to new replies.