Forums › Forums › Search & Filter Pro › problem getting results

Viewing 10 posts - 11 through 20 (of 29 total)
1 2 3
  • Anonymous
    (Private)  November 24, 2015 at 3:31 pm #30619

    This error is being displayed only when i activate the S&F PRO plugin.
    With the free S&F it didn’t happened.

    You copied and pasted your last answer but with no solution.
    Please tell me what can i do to fix it.

    Ross Moderator
    (Private)  November 24, 2015 at 3:43 pm #30620

    Hmm I had another look.

    When search & filter is activated, like most plugins, it checks for the necessary tables, and creates them automatically.

    We use the WordPress function dbDelta:
    https://codex.wordpress.org/Creating_Tables_with_Plugins#Creating_or_Updating_the_Table

    Now it seems for some reason in your environment this is not working- it just fails silently.

    This is most unusual, this has never been reported before, so I’m thinking its something to do with your environment.

    The quickest workaround to fix this would be to manually create the tables in your database.

    If I supply some SQL code, are you happy to add this to your DB via something like phpmyadmin?

    Thanks

    Ross Moderator
    (Private)  November 24, 2015 at 3:45 pm #30621

    PS, you are right, S&F free doesn’t require this – there is no cache in S&F free – one of the advantages of pro 😉

    Anonymous
    (Private)  November 24, 2015 at 3:51 pm #30624

    If it will fix things around and make it work, no probs.
    Supply the SQL.

    But please be as friendly as you can with the code.

    P.S.
    Is the problem will happen every site i install this plugin?

    Ross Moderator
    (Private)  November 24, 2015 at 4:01 pm #30627

    Considering it has not happened before, to any user, I think its safe to say this is a one off 🙂

    You need to create 2 tables.

    In phpMyAdmin, click on your database in the left side of the screen.

    Once you see a list of tables, hit the SQL tab.

    Then paste each code separately and hit go.

    CREATE TABLE wp_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_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)
	
)

    Obviously the wp_ prefix to the table names needs to match your environment.

    Thanks

    Anonymous
    (Private)  November 25, 2015 at 6:57 am #30693

    Hey,
    Again…no luck.
    Nothing happens on the results side.
    When im updating im getting this message:

    What can be the problem with my environment?
    Is there any thing else i can do? does all of my settings are configured properly?
    Its really frustrating…

    Anonymous
    (Private)  November 25, 2015 at 7:56 am #30696

    Great news!
    I have deleted both free S&F and the PRO,
    installed again the PRO version but didn’t activated it,
    build the DB with the missing tables that you supplied,
    activated the plugin….and baaaaaaaaaaaaam it works!!!

    But….
    I’m reaching a “blog” page and the URL structure is not as the free version.
    Is there a way to make the act as the free version???
    I bought the PRO version because i needed to have a relationship between the dropdowns, but i wasn’t aware to the fact that it will change my whole structure.

    For example, if i choose only one dropdown:

    If the URL structure looked like that:
    http://carmel.mixermedia.co.il/trip_type/%D7%98%D7%99%D7%95%D7%9C%D7%99-%D7%9E%D7%A9%D7%A4%D7%97%D7%95%D7%AA/

    Now it looks like that:
    http://carmel.mixermedia.co.il/?sfid=1759&_sft_trip_type=%D7%98%D7%99%D7%95%D7%9C%D7%99-%D7%9E%D7%A9%D7%A4%D7%97%D7%95%D7%AA

    if the BODY tag looked like that on the free version:
    <body class=”rtl archive tax-trip_type term-36 logged-in admin-bar group-blog customize-support”>

    now it looks like that:
    <body class=”rtl blog logged-in admin-bar group-blog customize-support”>

    This causes me a huge amount of client side problems.

    Sorry for the long post…hope you can find a solution for the above issues.

    Thanks!

    Anonymous
    (Private)  November 26, 2015 at 10:03 am #30795

    Hey, is there a solution for the above???

    Ross Moderator
    (Private)  November 27, 2015 at 8:32 am #30858

    Hey there

    Ok so just to explain a little.

    S&F Pro doesn’t work completely the same way as free – I’ve had to change some things in order to add the new features, such as ajax and various other things.

    You can see this behavior in the demos: http://demo.designsandcode.com/sfpro-movie-reviews/

    It sounds like the real thing you need to do is get those classes added to the body tag.

    To manually add the different body tags to your pages you would likely need to use a combination of:

    https://codex.wordpress.org/Function_Reference/body_class

    and

    http://www.designsandcode.com/documentation/search-filter-pro/accessing-search-data/

    Hope that helps

    Thanks

    Anonymous
    (Private)  December 6, 2015 at 3:35 pm #31545
    This reply has been marked as private.
  • Author
    Posts
Viewing 10 posts - 11 through 20 (of 29 total)
1 2 3