kanopium
Forum Replies Created
-
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)
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.