Hi, 

I am encountering an issue while I try to add or edit rows in my table, connected to my Wp database. 

Here's the message error:  Erreur: Unknown column 'project_ID' in 'where clause'

I don't understand what the problem is. Do you have any idea? 

Thanks for your help!

Hi, 

Thanks for your answer. Yes, it is a SQL table, the queries based on the Wordpress database. 

You can see the issue here : 

SELECT posts_project.ID AS project_ID,
       posts_project.post_title AS project_post_title,
       posts_project_author.display_name AS project_post_author,
       project_meta_signataires_tbl.meta_value AS project_meta_signataires,
       project_taxonomy_langue_originale_tbl.name AS project_taxonomy_langue_originale,
       project_meta_titre_du_manifeste_en_anglais_tbl.meta_value AS project_meta_titre_du_manifeste_en_anglais,
       project_meta_premiere_publication_tbl.meta_value AS project_meta_premiere_publication,
       project_taxonomy_mouvements_en_langue_tbl.name AS project_taxonomy_mouvements_en_langue,
       project_taxonomy_mouvement_en_anglais_tbl.name AS project_taxonomy_mouvement_en_anglais,
       project_meta_mouvement_langue_originale_tbl.meta_value AS project_meta_mouvement_langue_originale,
       project_meta_mouvement_anglais_tbl.meta_value AS project_meta_mouvement_anglais,
       project_meta_domaines_dappartenance_tbl.meta_value AS project_meta_domaines_dappartenance,
       project_meta_langue_tbl.meta_value AS project_meta_langue,
       project_taxonomy_Pays_tbl.name AS project_taxonomy_Pays,
       project_taxonomy_support_tbl.name AS project_taxonomy_support,
       project_meta_edition_originale_tbl.meta_value AS project_meta_edition_originale,
       project_meta_revendication_explicite_du_genre_manifestaire_tbl.meta_value AS project_meta_revendication_explicite_du_genre_manifestaire,
       project_meta_correspondance_definition_du_genre_du_manifeste_tbl.meta_value AS project_meta_correspondance_definition_du_genre_du_manifeste,
       project_meta_critique_caracteristiques_manifestaires_tbl.meta_value AS project_meta_critique_caracteristiques_manifestaires,
       project_meta_ref_biblio_liens_tbl.meta_value AS project_meta_ref_biblio_liens,
       project_meta_autres_precisions_public_tbl.meta_value AS project_meta_autres_precisions_public,
       project_meta_autres_precisions_prive_tbl.meta_value AS project_meta_autres_precisions_prive,
       project_meta_identifiant_numerique_tbl.meta_value AS project_meta_identifiant_numerique
FROM wp_664041_posts AS posts_project
  INNER JOIN wp_664041_users AS posts_project_author
     ON posts_project_author.ID = posts_project.post_author
  INNER JOIN (SELECT project_meta_signataires_tbl_posts.ID as id, meta_value, meta_key  FROM wp_664041_postmeta AS project_meta_signataires_tbl_postmeta  INNER JOIN wp_664041_posts AS project_meta_signataires_tbl_posts   ON project_meta_signataires_tbl_postmeta.post_id = project_meta_signataires_tbl_posts.ID   AND project_meta_signataires_tbl_posts.post_type = 'project') AS project_meta_signataires_tbl
     ON project_meta_signataires_tbl.meta_key = 'signataires' AND project_meta_signataires_tbl.id = posts_project.ID 
  INNER JOIN (SELECT name, object_id as id FROM wp_664041_terms AS project_taxonomy_langue_originale_tbl_terms INNER JOIN wp_664041_term_taxonomy AS project_taxonomy_langue_originale_tbl_termtaxonomy ON project_taxonomy_langue_originale_tbl_termtaxonomy.term_id = project_taxonomy_langue_originale_tbl_terms.term_id  AND project_taxonomy_langue_originale_tbl_termtaxonomy.taxonomy = 'langue_originale' INNER JOIN wp_664041_term_relationships AS rel_project_taxonomy_langue_originale_tbl  ON project_taxonomy_langue_originale_tbl_termtaxonomy.term_taxonomy_id = rel_project_taxonomy_langue_originale_tbl.term_taxonomy_id) AS project_taxonomy_langue_originale_tbl
     ON project_taxonomy_langue_originale_tbl.ID = posts_project.id 
  INNER JOIN (SELECT project_meta_titre_du_manifeste_en_anglais_tbl_posts.ID as id, meta_value, meta_key  FROM wp_664041_postmeta AS project_meta_titre_du_manifeste_en_anglais_tbl_postmeta  INNER JOIN wp_664041_posts AS project_meta_titre_du_manifeste_en_anglais_tbl_posts   ON project_meta_titre_du_manifeste_en_anglais_tbl_postmeta.post_id = project_meta_titre_du_manifeste_en_anglais_tbl_posts.ID   AND project_meta_titre_du_manifeste_en_anglais_tbl_posts.post_type = 'project') AS project_meta_titre_du_manifeste_en_anglais_tbl
     ON project_meta_titre_du_manifeste_en_anglais_tbl.meta_key = 'titre_du_manifeste_en_anglais' AND project_meta_titre_du_manifeste_en_anglais_tbl.id = posts_project.ID 
  INNER JOIN (SELECT project_meta_premiere_publication_tbl_posts.ID as id, meta_value, meta_key  FROM wp_664041_postmeta AS project_meta_premiere_publication_tbl_postmeta  INNER JOIN wp_664041_posts AS project_meta_premiere_publication_tbl_posts   ON project_meta_premiere_publication_tbl_postmeta.post_id = project_meta_premiere_publication_tbl_posts.ID   AND project_meta_premiere_publication_tbl_posts.post_type = 'project') AS project_meta_premiere_publication_tbl
     ON project_meta_premiere_publication_tbl.meta_key = 'premiere_publication' AND project_meta_premiere_publication_tbl.id = posts_project.ID 
  INNER JOIN (SELECT name, object_id as id FROM wp_664041_terms AS project_taxonomy_mouvements_en_langue_tbl_terms INNER JOIN wp_664041_term_taxonomy AS project_taxonomy_mouvements_en_langue_tbl_termtaxonomy ON project_taxonomy_mouvements_en_langue_tbl_termtaxonomy.term_id = project_taxonomy_mouvements_en_langue_tbl_terms.term_id  AND project_taxonomy_mouvements_en_langue_tbl_termtaxonomy.taxonomy = 'mouvements_en_langue' INNER JOIN wp_664041_term_relationships AS rel_project_taxonomy_mouvements_en_langue_tbl  ON project_taxonomy_mouvements_en_langue_tbl_termtaxonomy.term_taxonomy_id = rel_project_taxonomy_mouvements_en_langue_tbl.term_taxonomy_id) AS project_taxonomy_mouvements_en_langue_tbl
     ON project_taxonomy_mouvements_en_langue_tbl.ID = posts_project.id 
  INNER JOIN (SELECT name, object_id as id FROM wp_664041_terms AS project_taxonomy_mouvement_en_anglais_tbl_terms INNER JOIN wp_664041_term_taxonomy AS project_taxonomy_mouvement_en_anglais_tbl_termtaxonomy ON project_taxonomy_mouvement_en_anglais_tbl_termtaxonomy.term_id = project_taxonomy_mouvement_en_anglais_tbl_terms.term_id  AND project_taxonomy_mouvement_en_anglais_tbl_termtaxonomy.taxonomy = 'mouvement_en_anglais' INNER JOIN wp_664041_term_relationships AS rel_project_taxonomy_mouvement_en_anglais_tbl  ON project_taxonomy_mouvement_en_anglais_tbl_termtaxonomy.term_taxonomy_id = rel_project_taxonomy_mouvement_en_anglais_tbl.term_taxonomy_id) AS project_taxonomy_mouvement_en_anglais_tbl
     ON project_taxonomy_mouvement_en_anglais_tbl.ID = posts_project.id 
  INNER JOIN (SELECT project_meta_mouvement_langue_originale_tbl_posts.ID as id, meta_value, meta_key  FROM wp_664041_postmeta AS project_meta_mouvement_langue_originale_tbl_postmeta  INNER JOIN wp_664041_posts AS project_meta_mouvement_langue_originale_tbl_posts   ON project_meta_mouvement_langue_originale_tbl_postmeta.post_id = project_meta_mouvement_langue_originale_tbl_posts.ID   AND project_meta_mouvement_langue_originale_tbl_posts.post_type = 'project') AS project_meta_mouvement_langue_originale_tbl
     ON project_meta_mouvement_langue_originale_tbl.meta_key = 'mouvement_langue_originale' AND project_meta_mouvement_langue_originale_tbl.id = posts_project.ID 
  INNER JOIN (SELECT project_meta_mouvement_anglais_tbl_posts.ID as id, meta_value, meta_key  FROM wp_664041_postmeta AS project_meta_mouvement_anglais_tbl_postmeta  INNER JOIN wp_664041_posts AS project_meta_mouvement_anglais_tbl_posts   ON project_meta_mouvement_anglais_tbl_postmeta.post_id = project_meta_mouvement_anglais_tbl_posts.ID   AND project_meta_mouvement_anglais_tbl_posts.post_type = 'project') AS project_meta_mouvement_anglais_tbl
     ON project_meta_mouvement_anglais_tbl.meta_key = 'mouvement_anglais' AND project_meta_mouvement_anglais_tbl.id = posts_project.ID 
  INNER JOIN (SELECT project_meta_domaines_dappartenance_tbl_posts.ID as id, meta_value, meta_key  FROM wp_664041_postmeta AS project_meta_domaines_dappartenance_tbl_postmeta  INNER JOIN wp_664041_posts AS project_meta_domaines_dappartenance_tbl_posts   ON project_meta_domaines_dappartenance_tbl_postmeta.post_id = project_meta_domaines_dappartenance_tbl_posts.ID   AND project_meta_domaines_dappartenance_tbl_posts.post_type = 'project') AS project_meta_domaines_dappartenance_tbl
     ON project_meta_domaines_dappartenance_tbl.meta_key = 'domaines_dappartenance' AND project_meta_domaines_dappartenance_tbl.id = posts_project.ID 
  INNER JOIN (SELECT project_meta_langue_tbl_posts.ID as id, meta_value, meta_key  FROM wp_664041_postmeta AS project_meta_langue_tbl_postmeta  INNER JOIN wp_664041_posts AS project_meta_langue_tbl_posts   ON project_meta_langue_tbl_postmeta.post_id = project_meta_langue_tbl_posts.ID   AND project_meta_langue_tbl_posts.post_type = 'project') AS project_meta_langue_tbl
     ON project_meta_langue_tbl.meta_key = 'langue' AND project_meta_langue_tbl.id = posts_project.ID 
  INNER JOIN (SELECT name, object_id as id FROM wp_664041_terms AS project_taxonomy_Pays_tbl_terms INNER JOIN wp_664041_term_taxonomy AS project_taxonomy_Pays_tbl_termtaxonomy ON project_taxonomy_Pays_tbl_termtaxonomy.term_id = project_taxonomy_Pays_tbl_terms.term_id  AND project_taxonomy_Pays_tbl_termtaxonomy.taxonomy = 'Pays' INNER JOIN wp_664041_term_relationships AS rel_project_taxonomy_Pays_tbl  ON project_taxonomy_Pays_tbl_termtaxonomy.term_taxonomy_id = rel_project_taxonomy_Pays_tbl.term_taxonomy_id) AS project_taxonomy_Pays_tbl
     ON project_taxonomy_Pays_tbl.ID = posts_project.id 
  INNER JOIN (SELECT name, object_id as id FROM wp_664041_terms AS project_taxonomy_support_tbl_terms INNER JOIN wp_664041_term_taxonomy AS project_taxonomy_support_tbl_termtaxonomy ON project_taxonomy_support_tbl_termtaxonomy.term_id = project_taxonomy_support_tbl_terms.term_id  AND project_taxonomy_support_tbl_termtaxonomy.taxonomy = 'support' INNER JOIN wp_664041_term_relationships AS rel_project_taxonomy_support_tbl  ON project_taxonomy_support_tbl_termtaxonomy.term_taxonomy_id = rel_project_taxonomy_support_tbl.term_taxonomy_id) AS project_taxonomy_support_tbl
     ON project_taxonomy_support_tbl.ID = posts_project.id 
  INNER JOIN (SELECT project_meta_edition_originale_tbl_posts.ID as id, meta_value, meta_key  FROM wp_664041_postmeta AS project_meta_edition_originale_tbl_postmeta  INNER JOIN wp_664041_posts AS project_meta_edition_originale_tbl_posts   ON project_meta_edition_originale_tbl_postmeta.post_id = project_meta_edition_originale_tbl_posts.ID   AND project_meta_edition_originale_tbl_posts.post_type = 'project') AS project_meta_edition_originale_tbl
     ON project_meta_edition_originale_tbl.meta_key = 'edition_originale' AND project_meta_edition_originale_tbl.id = posts_project.ID 
  INNER JOIN (SELECT project_meta_revendication_explicite_du_genre_manifestaire_tbl_posts.ID as id, meta_value, meta_key  FROM wp_664041_postmeta AS project_meta_revendication_explicite_du_genre_manifestaire_tbl_postmeta  INNER JOIN wp_664041_posts AS project_meta_revendication_explicite_du_genre_manifestaire_tbl_posts   ON project_meta_revendication_explicite_du_genre_manifestaire_tbl_postmeta.post_id = project_meta_revendication_explicite_du_genre_manifestaire_tbl_posts.ID   AND project_meta_revendication_explicite_du_genre_manifestaire_tbl_posts.post_type = 'project') AS project_meta_revendication_explicite_du_genre_manifestaire_tbl
     ON project_meta_revendication_explicite_du_genre_manifestaire_tbl.meta_key = 'revendication_explicite_du_genre_manifestaire' AND project_meta_revendication_explicite_du_genre_manifestaire_tbl.id = posts_project.ID 
  INNER JOIN (SELECT project_meta_correspondance_definition_du_genre_du_manifeste_tbl_posts.ID as id, meta_value, meta_key  FROM wp_664041_postmeta AS project_meta_correspondance_definition_du_genre_du_manifeste_tbl_postmeta  INNER JOIN wp_664041_posts AS project_meta_correspondance_definition_du_genre_du_manifeste_tbl_posts   ON project_meta_correspondance_definition_du_genre_du_manifeste_tbl_postmeta.post_id = project_meta_correspondance_definition_du_genre_du_manifeste_tbl_posts.ID   AND project_meta_correspondance_definition_du_genre_du_manifeste_tbl_posts.post_type = 'project') AS project_meta_correspondance_definition_du_genre_du_manifeste_tbl
     ON project_meta_correspondance_definition_du_genre_du_manifeste_tbl.meta_key = 'correspondance_definition_du_genre_du_manifeste' AND project_meta_correspondance_definition_du_genre_du_manifeste_tbl.id = posts_project.ID 
  INNER JOIN (SELECT project_meta_critique_caracteristiques_manifestaires_tbl_posts.ID as id, meta_value, meta_key  FROM wp_664041_postmeta AS project_meta_critique_caracteristiques_manifestaires_tbl_postmeta  INNER JOIN wp_664041_posts AS project_meta_critique_caracteristiques_manifestaires_tbl_posts   ON project_meta_critique_caracteristiques_manifestaires_tbl_postmeta.post_id = project_meta_critique_caracteristiques_manifestaires_tbl_posts.ID   AND project_meta_critique_caracteristiques_manifestaires_tbl_posts.post_type = 'project') AS project_meta_critique_caracteristiques_manifestaires_tbl
     ON project_meta_critique_caracteristiques_manifestaires_tbl.meta_key = 'critique_caracteristiques_manifestaires' AND project_meta_critique_caracteristiques_manifestaires_tbl.id = posts_project.ID 
  INNER JOIN (SELECT project_meta_ref_biblio_liens_tbl_posts.ID as id, meta_value, meta_key  FROM wp_664041_postmeta AS project_meta_ref_biblio_liens_tbl_postmeta  INNER JOIN wp_664041_posts AS project_meta_ref_biblio_liens_tbl_posts   ON project_meta_ref_biblio_liens_tbl_postmeta.post_id = project_meta_ref_biblio_liens_tbl_posts.ID   AND project_meta_ref_biblio_liens_tbl_posts.post_type = 'project') AS project_meta_ref_biblio_liens_tbl
     ON project_meta_ref_biblio_liens_tbl.meta_key = 'ref_biblio_liens' AND project_meta_ref_biblio_liens_tbl.id = posts_project.ID 
  INNER JOIN (SELECT project_meta_autres_precisions_public_tbl_posts.ID as id, meta_value, meta_key  FROM wp_664041_postmeta AS project_meta_autres_precisions_public_tbl_postmeta  INNER JOIN wp_664041_posts AS project_meta_autres_precisions_public_tbl_posts   ON project_meta_autres_precisions_public_tbl_postmeta.post_id = project_meta_autres_precisions_public_tbl_posts.ID   AND project_meta_autres_precisions_public_tbl_posts.post_type = 'project') AS project_meta_autres_precisions_public_tbl
     ON project_meta_autres_precisions_public_tbl.meta_key = 'autres_precisions_public' AND project_meta_autres_precisions_public_tbl.id = posts_project.ID 
  INNER JOIN (SELECT project_meta_autres_precisions_prive_tbl_posts.ID as id, meta_value, meta_key  FROM wp_664041_postmeta AS project_meta_autres_precisions_prive_tbl_postmeta  INNER JOIN wp_664041_posts AS project_meta_autres_precisions_prive_tbl_posts   ON project_meta_autres_precisions_prive_tbl_postmeta.post_id = project_meta_autres_precisions_prive_tbl_posts.ID   AND project_meta_autres_precisions_prive_tbl_posts.post_type = 'project') AS project_meta_autres_precisions_prive_tbl
     ON project_meta_autres_precisions_prive_tbl.meta_key = 'autres_precisions_prive' AND project_meta_autres_precisions_prive_tbl.id = posts_project.ID 
  INNER JOIN (SELECT project_meta_identifiant_numerique_tbl_posts.ID as id, meta_value, meta_key  FROM wp_664041_postmeta AS project_meta_identifiant_numerique_tbl_postmeta  INNER JOIN wp_664041_posts AS project_meta_identifiant_numerique_tbl_posts   ON project_meta_identifiant_numerique_tbl_postmeta.post_id = project_meta_identifiant_numerique_tbl_posts.ID   AND project_meta_identifiant_numerique_tbl_posts.post_type = 'project') AS project_meta_identifiant_numerique_tbl
     ON project_meta_identifiant_numerique_tbl.meta_key = 'identifiant_numerique' AND project_meta_identifiant_numerique_tbl.id = posts_project.ID 
WHERE 1=1 
   AND posts_project.post_type = 'project'

Thank you for your time. 

I am sorry but SQL is not my thing, so I am not really sure about what you are asking me. The query is automatically generated by the plugin. I thought it was an acf field issue but even if I try with the classical queries or to build a table on the basis of the classical "posts", the error appears. 

Did you tried the option to "Create a MySQL-query-based data table by generating a query to the WordPress database (posts, taxonomies, postmeta) with a GUI tool."? 

Because that's what I used to connect custom posts in WordPress with the table and the error occurs every time I use that option. 

Hi Blaženka, 

Ok, I understand that. But please note that I tried to use the option to generate a query to the WP database, and even with a very simple query (so, excluding any ACF or custom field, just calling for post_title and ID) the error I reported few days earlier still occurs. That option in particular seems to have some troubles and I suppose that it's important for your team to have returns. 

Unless I misunderstood the use of that option and the plugin is not able to create or edit entries this way.

Thanks again for you answers.