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.