Support Forums

Support Forums Forums General Support The caching tables are missing

This topic is: resolved

This topic contains 5 replies, has 2 voices, and was last updated by  ouwan 1 week, 4 days ago.

Viewing 6 posts - 1 through 6 (of 6 total)
  • ouwan
    #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 Moderator
    #220487

    Is the message still present in the Admin?

    ouwan
    #220498

    yes.

    Trevor Moderator
    #220500
    This reply has been marked as private.
    ouwan
    #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.

    ouwan
    #220506

    thanx. so it was the prefix mistake!

Viewing 6 posts - 1 through 6 (of 6 total)

The topic ‘The caching tables are missing’ is closed to new replies.