Hi @theroom10,
Can you give me database dump with posts and postmeta tables? Please delete all private data from them.
Hi again,
You know something about my problem? My client is a little annoyed because it’s hard for him to find properties and need a solution ASAP.
I you can’t do anything, please tell it to me and i find another solution.
Thanks again! Regards!
Hi @theroom10,
Forgive for the waiting time. Understand me too – I develop my plugin in my spare time for pleasure. I am not able to be available 24/7.
Thanks for the message. I analyzed the dump of your database. You have the field value saved in the wrong way. A correctly added ACF field value in the database has 2 records.
The first one stores the value:
meta_id: 10000
post_id: 100
meta_key: field_name
meta_value: your-value
The second one stores information about the field (meta_id has increased by 1):
meta_id: 10001
post_id: 100
meta_key: _field_name
meta_value: field _ *************
The above ID and meta_key are random – just an example. You are missing 2 records – we have only one entry from meta_key = “reference” and there is no second from meta_key = “_referencia”. Look at other fields, e.g. “venta”, that are correctly saved.
I think this is not true,
Here is a capture of my database:
https://gyazo.com/a8feac986d8a242a4b1b83e76725fbf7
In my database dump I don’t have post with 15293 post_id.
This is the post you wrote about:
View post on imgur.com
One of resulsts (has meta_key with prefix “_”) should have meta_id bigger by 1 than the other. If this is not the case then you have an incorrect database structure – delete this field and add it again.
I deleted the field and added it again and still not working. Its posible that another fields with the same problem are interfering in the search of ‘referencia’ field? What should I do?
Thanks!
Can you give me again database dump with posts and postmeta tables? Please delete all private data from them.
Here is the dump:
https://we.tl/t-UMBH7BifVe
-
This reply was modified 7 years, 3 months ago by
theroom10.
What isID ofpost you want to find and field slug?
The name of the field is ‘referencia’. The key is: ‘field_5c739354aa751’.
I don’t understand about what ID you mean. I want the ID of any Property which I search using this custom field.
For example, if I search for ‘referencia’ = SI1122, I want the search to show that property. If I search for ‘referencia’ = SI1130, I want the search to show that property. And so on.
This field ‘referencia’ is always a unique string, so the search should only display this one property with this value of ‘referencia’.
Listen to me, if I do not get information I need, I will not help you. I am asking what is ID of post you want to find by entering phrase into the search engine (and what a phrase) – just answer my question.
Please give me:
– ID of post you want to find
– phrase typed in search
In the dump there are 2 .sql files:
– joswv_postmeta.sql (postmeta)
– joswv_posts.sql (posts)
But here is the complete sql dump:
https://we.tl/t-sFqQ05OpfZ
The ID that i want is the custom field named ‘referencia’. The info that you want is here:
– ID of post i want to find: anyone
– phrase typed in search: anyone that appear in ‘referencia’ custom field.
I don want certain post. The search don’t work in any case that i do. But if you want an example here is. Example:
-Post id that i want: 15085
-Phrase typed in search: SI1132
You have a bad structure for some fields:
View post on imgur.com
For you field we have 2 records in postmeta table – one of them (has meta_key with prefix “_”) should have meta_id bigger by 1 than the other. If this is not the case then you have an incorrect database structure – delete this field and add it again.
This is an example of correct structure for another post:
View post on imgur.com
Yes I know. But I already deleted the field and I added it again. And that dump is after do this. What should I do now?
