Data tables disappear periodically

  • kanopium

    (@kanopium)


    3 years, 6 months ago

    Hi guys,

    I’m using Data Publisher to create tables connected to WP custom tables in order to show race results. I have 99 tables defined.
    Unfortunately, sometimes all the tables’ list disappear completely, leaving my pages empty!!
    It already happened 5 times in last 7 months!!!

    After rewriting them all the first time, I saved all table codes in a text file so that I can import them quickly again, but this is not fair: WHY this happen??

    Does it relate with plugin update or anything else? Am I wrong in any way?
    It is very annoying…
    Can you help?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    3 years, 6 months ago

    Hi @kanopium,

    That’s very unusual. Sorry to hear you’ve experienced that.

    Do the tables disappear both in the backend, as well on the frontend?

    Do they disappear at random times or does it happen after something else happens (WP updates, updates from other plugins, etc)

    If you could give us more details about how this issue surfaces, as well as how your tables are created/set up, that would be very helpful.

    We look forward to your response.

    Thread Starter kanopium

    (@kanopium)

    3 years, 6 months ago

    Hi @kimmyx,
    tables disappear in the backend, and in frontend a message appears stating something like “ERROR: table not found” or similar (I don’t have a screen by now, just fixed the issue again importing all tables). It’s very frustrating.

    I can’t say if it happens after WP updates, even if this was my thaught.
    Wp updates automatically, so in any case I can’t control it.

    Here is an example of table:
    INSERT INTO{wp_prefix}wpda_publisher(pub_name,pub_data_source,pub_schema_name,pub_table_name,pub_column_names,pub_cpt,pub_cpt_fields,pub_cpt_query,pub_cpt_format,pub_format,pub_query,pub_sort_icons,pub_styles,pub_style_premium,pub_style_color,pub_style_space,pub_style_corner,pub_style_modal_width,pub_responsive,pub_responsive_popup_title,pub_responsive_cols,pub_responsive_type,pub_responsive_modal_hyperlinks,pub_responsive_icon,pub_flat_scrollx,pub_show_advanced_settings,pub_default_where,pub_default_orderby,pub_table_options_searching,pub_table_options_ordering,pub_table_options_paging,pub_table_options_serverside,pub_table_options_nl2br,pub_table_options_advanced,pub_extentions) VALUES ('Circuito - Individuali Mediofondo MASCHILE',null,'{wp_schema}','Q_PUNTEGGI_INDIVIDUALI_CIRCUITO_MEDIOFONDO_M','Cognome,Nome,Sesso,Anno,Ente,CodSocieta,Societa,Ebike,KmFatti',null,null,null,null,'{\"pub_format\":{\"column_labels\":{\"IDAtleta\":\"IDAtleta\",\"Cognome\":\"Cognome\",\"Nome\":\"Nome\",\"Sesso\":\"Sesso\",\"Anno\":\"Anno\",\"Ente\":\"Ente\",\"CodSocieta\":\"Cod. Società\",\"Societa\":\"Società\",\"Ebike\":\"E-bike\",\"KmFatti\":\"Km percorsi\",\"Punteggio\":\"Punteggio\"}}}',null,'default','default',null,null,10,0,80,'Yes','Row details',0,'Modal','If not listed','Yes','Yes',null,'','','on','0','on','on','','{}',null);

    All tables where created with WP DATA ACCESS interface.

    Plugin Contributor Kim L

    (@kimmyx)

    3 years, 6 months ago

    Thanks for the response, @kanopium.

    Do these tables disappear from your database as well?

    Are they still accessible from Data Explorer after disappearing?

    Is it possible to see the page where these tables are displayed so we can take a look as well?

    Sorry for the questions, we want to know more as much as possible since this doesn’t happen normally.

    Thread Starter kanopium

    (@kanopium)

    3 years, 6 months ago

    Maybe i didn’t explain correctly.
    I’m not talking about database SQL tables. SQL tables are correctly stored in the database and don’t change in any way.

    I’m instead referring to WP Data Access publications: when I’m inside WP Data Access plugin, I select “Data Publishing” and then “Tables”.
    Here I see the “Data Publisher” list, normally with my 99 publication ID.
    Here I created my publications.
    I already listed a publication example in my last post.

    Sometimes, my list become inexpectly empty. It already happened a lot of times.
    Here is an example of web page where I use those publications:
    https://www.criteriumveneto.it/classifiche-di-circuito/

    It seems like my publication’s list get cleared by some upgrade (WP? Plugin? I don’t know)

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    3 years, 6 months ago

    Hi @kanopium,

    The plugin creates a backup of all your repository tables on each update. Sometimes the structure of a repository table changes. In that case the plugin recreates the table and imports the old values into the new table. If this process fails, it might be possible you lose your table content. This should not happen of course, but it looks like it happened to you. Sorry!

    First of all, there is an easy way to fix this issue. Since the plugin creates a backup before changing the structure, you can always restore your backup as explain here:
    https://wpdataaccess.com/docs/plugin-settings/manage-repository/
    Please check this page before you update next time. It also allows you to create an instant backup of your repository tables which might feel even safer.

    Second, we would love to learn more about your WordPress and database installation. This might help us to setup a similar server, test our update procedure and improve it to prevent similar issues in the future. Could you please send us your server info?

    To send send your server info:
    – Start WP Data Access
    – Go to plugin settings > tab System Info
    – Click copy to clipboard
    – Paste your clipboard content into the contact form on our website:
    https://wpdataaccess.com/contactform/

    Have a nice weekend,
    Peter

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

The topic ‘Data tables disappear periodically’ is closed to new replies.