Multiple tables not loading on Frontend

  • kfranz160

    (@kfranz160)


    5 years ago

    Hello,
    My name is Kyle and I am a student working on a capstone project for a client. The webpage we developed displays the donor nameplates of the Duluth Library Foundation in multiple tables on one web page. The issue we have is while NOT logged into our wordpress account, only the first 5 tables (out of 9 total) load into the page. The remaining 4 do not have a response at all. But, if I stay logged in, all the tables load in the backend and frontend to view properly. Any help would be greatly appriciated.

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years ago

    Hi Kyle,

    This might be related to an issue with version 4.2.6. Can you please updated to 4.2.7 to see if this fixes your problem?

    Thanks,
    Peter

    Thread Starter kfranz160

    (@kfranz160)

    5 years ago

    Hello Peter,

    Thank you for the quick response. I have updated to version 4.2.7 and the problem persists. Any idea why only the published version of the page (not logged into a wordpress account) is the only part that does not load all the tables? I have done some developer tools troubleshooting and it appears that only the first (5) tables pass any JSON while the remaining pass nothing. If I change the order of the tables in the page, it continues to only load the first (5) of the (9) tables. The website otherwise loads and works perfectly as expected while one is logged into the wordpress account…
    Thank you for you time,
    Kyle

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years ago

    Hi Kyle,

    Are you using any environment variables in the default where clause of those publications?

    Thanks,
    Peter

    Thread Starter kfranz160

    (@kfranz160)

    5 years ago

    Hi Peter,

    If I am understanding correctly, we only use the following in the data publisher for each table:
    WHERE Clause: dw_literary_lions = ‘$100,000 Carnegie’
    Table Options: `{ “dom”: “ftip”,
    “language”: {
    “info”: “Showing _START_ to _END_ of _TOTAL_ donors”,
    “infoFiltered”: “”
    },
    “serverSide”:false
    }`
    For the (9) tables the Table Options are the same, the WHERE Clause is slightly different in each; “$100,000 Carnegie”/”$50,000 Carnegie”/”$25,000 Cranegie”/etc

    Thank you,
    Kyle

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years ago

    Thanks Kyle!

    Can you please enable debug mode?
    > Go to Settings > WP Data Access > Plugin
    > Enabled debug mode and save

    After that you can view the response in your browser to see the query that is actually performed.

    Please let me know…
    Peter

    Thread Starter kfranz160

    (@kfranz160)

    5 years ago

    Hi Peter,
    I have made the change to enable Debug Mode, what/where is the information we are exactly looking for?

    Thank you,
    Kyle

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years ago

    Hi Kyle,

    Please open the inspector in your browser and click on the Network tab. Then refresh the page and look for the response starting with admin-ajax.php.

    When you look into the response you’ll see that the plugin debugger adds a debug node. The debug node contains a query node. Please check the query to see what’s wrong.

    I can’t reproduce this error anymore. The publication returning an error are now gone when I view the page.

    Please let know…
    Peter

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Multiple tables not loading on Frontend’ is closed to new replies.