Okay
  Public Ticket #2603999
Error Table in data source has no rows.
Closed

Comments

  • Jimmy Chang started the conversation

    The table I had set up was working perfectly until tonight when my users alerted me that no data was showing. I don't know why this would be the case. Nothing was changed. 

    When I go through your tutorial I keep getting the error: Error: Table in data source has no rows.

    This is extremely frustrating, in addition to the fact that I cannot easily freeze rows or columns. 

    I feel like I paid a lot of money for this product and two add ons but the results are frustrating and the program feels unfinished and has some needs for improvement.

  • Jimmy Chang replied

    I created a new table by importing the data from the Google sheets data source which was time consuming and will not auto populate the responses from my Google forms like I had it set up previously. The old broken table which says there is no data can still be found below the new table that I put together.

  • Minsu replied

    I'm having exactly same problem. Is there any progress?

    I want this problem to be solved very soon.


  •  1
    Andrey replied

    ~6 hours ago all my tables that were imported from Google Sheets broke. No data can be loaded on page load as of now. I'm getting "Table in data source has no rows." error in the back-end.
    Is this something that Google broke?

  • nakagawa replied

    me too. no rows 

  • Kristofer replied

    I am also experiencing this. Did Google do an update? We need an update for the plugin as soon as possible. 

  •  1
    Andrey replied

    Crossposting from George from another thread

    Fix / WorkAround
    Looks like Google made some kind of a change. After tinkering around a bit more I found that in the sheet after (1) Stopping the publish, (2) change share to anyone with a link can view and (3) then Re-publishing the sheet. it works again. 

  • Kristofer replied

    @Andrey - Thanks for your fix, but this only works for me as a logged in WP admin. The public version doesn't display anything for some reason... is it the same for you?

  •  1
    brazenracing replied

    Same issue here started yesterday. We have hundreds of sheets/tables, really would like to avoid digging up each sheet to update it.  Is this something that can be fixed with an update? 

  •  1
    Andrey replied

    @Kristofer For me it works in the back-end and in the front-end as a non logged-in user.

  • Kristofer replied

    @Andrey - Actually. Your fix (from George) seems to work now for everyone after I reinstalled wpdatatables. 

  •  1
    Kevin replied

    This is now also working again for me. Thanks!


  •  2,572
    Aleksandar replied

    Hi all.

    Unfortunately, all plugins and software that relied on Google's API are now affected.

    Google changed their API, and almost all tables created by linking to a Google Spreadsheet are affected.

    Please take a look at this FAQ thread, and you’ll see how you can resolve the issue.

    The issue is displayed either as "Table in data source has no rows" error when trying to create a new table:

    3912529812.png

    Or "No data available in the table" in an existing table:

    4272394449.png

    Sorry for the inconvenience.


    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables