The caching tables are missing

Anonymous

#220486

`wp_hcf_search_filter_cache’

i’m trying to set up the caching tables.

i’m working with acf. my table have the prefix hcf.
so what i did is:

CREATE TABLE wp_hcf_search_filter_cache (
id bigint(20) NOT NULL AUTO_INCREMENT,
post_id bigint(20) NOT NULL,
post_parent_id bigint(20) NOT NULL,
field_name varchar(255) NOT NULL,
field_value varchar(255) NOT NULL,
field_value_num bigint(20) NULL,
field_parent_num bigint(20) NULL,
term_parent_id bigint(20) NULL,
PRIMARY KEY (id),
KEY field_name_index (field_name),
KEY field_value_index (field_value),
KEY field_value_num_index (field_value_num)
)

and

CREATE TABLE wp_hcf_search_filter_term_results (
id bigint(20) NOT NULL AUTO_INCREMENT,
field_name varchar(255) NOT NULL,
field_value varchar(255) NOT NULL,
field_value_num bigint(20) NULL,
result_ids text NOT NULL,
PRIMARY KEY (id),
KEY field_name_index (field_name),
KEY field_value_index (field_value),
KEY field_value_num_index (field_value)

)
but the table are still missing. and they are empty in the phpadmin panel.

Trevor

#220487

Is the message still present in the Admin?

Anonymous

#220498

yes.

Trevor

#220500

This reply has been marked as private.

Anonymous

#220504

i used the wrong prefix. – i used the one from the acf – fields. now i realized, i have another prefix. and i tried it again. the prefix has upper and lowercase.

Anonymous

#220506

thanx. so it was the prefix mistake!

[Author]

Posts