SQL_CALC_FOUND_ROWS

  • Resolved munaterai

    (@munaterai)


    2 years, 9 months ago

    Hello, thank you very much for your plugin.
    I currently have a problem with my hosting service.

    they tell me that SQL_CALC_FOUND_ROWS is causing problems, this is located in em-events.php

    I currently remove ->> if( $calc_found_rows ) $selectors = ‘SQL_CALC_FOUND_ROWS ‘ . $selectors; //for storing total rows found <<-

    Now, It doesn’t seem pagination, and the problem with my hosting service is over. but I do not show pagination of more results.

    I have tried to change this line of code, from what I read, this function will be removed in new updates of mysql and php (Deprecate).

    Is there a way to change this code to use count() which has more support or something similar?

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Support angelo_nwl

    (@angelo_nwl)

    Hi,

    You can try to hook into em_events_count filter instead; for reference, this is located under classe/em-events.php

Viewing 1 replies (of 1 total)
  • The topic ‘SQL_CALC_FOUND_ROWS’ is closed to new replies.