Hi

I would like to know how to solve this error

×CloseError! There was an error trying to insert a new row! Error: Unknown column 'empleado_post_title' in 'field list'

It only appears when i pass to the mysql query data from ACF plugin and try to edit any field.

I was looking in support forums about this and I have encountered this post

https://tmsplugins.ticksy.com/ticket/1651310/ in which Milan says...

"If you are using JOINS with more tables please note that in wpdatatables just one table can be editable at the moment"

But as far as i know i am just using only one table. And the code was generated automaticly by the software.

This is the query code...

SELECT posts_empleado.ID AS empleado_ID,
       posts_empleado.post_title AS empleado_post_title,
       empleado_meta_fecha_del_masaje_tbl.meta_value AS empleado_meta_fecha_del_masaje
FROM poa3_posts AS posts_empleado
  INNER JOIN (SELECT empleado_meta_fecha_del_masaje_tbl_posts.ID as id, meta_value, meta_key  FROM poa3_postmeta AS empleado_meta_fecha_del_masaje_tbl_postmeta  INNER JOIN poa3_posts AS empleado_meta_fecha_del_masaje_tbl_posts   ON empleado_meta_fecha_del_masaje_tbl_postmeta.post_id = empleado_meta_fecha_del_masaje_tbl_posts.ID   AND empleado_meta_fecha_del_masaje_tbl_posts.post_type = 'empleado') AS empleado_meta_fecha_del_masaje_tbl
     ON empleado_meta_fecha_del_masaje_tbl.meta_key = 'fecha_del_masaje' AND empleado_meta_fecha_del_masaje_tbl.id = posts_empleado.ID 
WHERE 1=1 
   AND posts_empleado.post_type = 'empleado'

May you help me with that please.

Thanks very much

I was testing in your sand box and aparently a similar problem is displaying.

Is the table called test_19. It's a table very simple, just for displaying post's title. I made it editable. and when i try to enter a new entry, the error is displayed. (See image attached)

And this is how the query is showing... I did it automatically  with the fourth icon "

"

SELECT posts_post.ID AS post_ID,
       posts_post.post_title AS post_post_title
FROM wp_posts AS posts_post
WHERE 1=1 
   AND posts_post.post_type = 'post'

I dont know what i am doing wrong

Hi Aleksandar

Dont worry about the delay, and thanks for your response.

I understand what you are telling me, and for simple queries like the lastone is easy to change in order to work everything properly.

But what I cant overcome, is the other one with avnced custom field and a custom post type.

I was testing creating a custom post type from scratch by code, and with custom post type plugin and with both aproaches have the same problem.

Once the query is created with the fourth image, the filter doesnt work, and the editing neither. Both only work if i disable "server side processing", but if i disable it i can't edit in the front end:((

I was trying to modify the query following the structure you gave before, but it is a little more complex and i can't handle it.

Could you tell what i shoul do?

In this case, i have created a custom post type called 'empleado', and through Advanced custom fields i have created a date type field called 'fecha del masaje'. I made the query through the 4th option selecting empleado.ID, empleado.title and empleado.fecha del masaje and this is the query result

SELECT posts_empleado.ID AS empleado_ID,
       posts_empleado.post_title AS empleado_post_title,
       empleado_meta_fecha_del_masaje_tbl.meta_value AS empleado_meta_fecha_del_masaje
FROM poa3_posts AS posts_empleado
  INNER JOIN (SELECT empleado_meta_fecha_del_masaje_tbl_posts.ID as id, meta_value, meta_key  FROM poa3_postmeta AS empleado_meta_fecha_del_masaje_tbl_postmeta  INNER JOIN poa3_posts AS empleado_meta_fecha_del_masaje_tbl_posts   ON empleado_meta_fecha_del_masaje_tbl_postmeta.post_id = empleado_meta_fecha_del_masaje_tbl_posts.ID   AND empleado_meta_fecha_del_masaje_tbl_posts.post_type = 'empleado') AS empleado_meta_fecha_del_masaje_tbl
     ON empleado_meta_fecha_del_masaje_tbl.meta_key = 'fecha_del_masaje' AND empleado_meta_fecha_del_masaje_tbl.id = posts_empleado.ID 
WHERE 1=1 
   AND posts_empleado.post_type = 'empleado'

What should I modify in order to everything works.

Thanks very much Aleksandar for your help.

Hi Aleksandar

Thanks very much for your help.

Just a couple of things...

1º When you are telling me 'Queries from multiple tables with joins cannot be used as an editable feature'. Are you talking about tables from the tables created by wpdatatables plugin, or tables in the data base?

Because in both cases are just one table. In case of wpdatatbles plugin is just one table and in the case of tables inside my database you must bare in mind wordpress save all data from advanced custom fields and from the custom post type that I have created from scratch by code, inside the table called 'whatever_posts'. Just one table as well.

2º In second place i would like to tell you that i am working in local host with xampp. So i can create a copy of the site with the plugin  all in one wp migration and give it to you (It's for me the easiest one). Or if it is posible to create a site in your sandbox...you give me the credentials and i'll import there the site with the plugin.Or i'll have to upload the site to one server. Could you tell what is the best option for you Aleksandar?

Thanks very much again. See you

Hi Aleksandar

Based on what you are telling me these days and knowing that everything in wordpress related with ACF plugin and custom post types is stored in the same table prefix_posts, I am making tests trying to pull data from this unique table selecting diferent columns, and so almost everything is running ok.

And I prefer to do some new tests before boring you with more quetions. 

Let me test some extra things in the weekend, and according to my results I'll give you my response.

Thanks Aleksandar

It's already done Aleksandar

Tnkas very much