Clean Talk & W3 Total Cache

  • Resolved barnabas1

    (@barnabas1)


    10 months ago

    Hello,

    In Woocommerce logs there is always a fatal-error log with a conflict between W3TC plugin and CleanTalk. This is the log if you could please help me understand what is causing it:

    Uncaught TypeError: mysqli_num_fields(): Argument #1 ($result) must be of type mysqli_result, bool given in /opt/bitnami/wordpress/wp-includes/class-wpdb.php:3868 CONTEXT: {"error":{"type":1,"file":"\/opt\/bitnami\/wordpress\/wp-includes\/class-wpdb.php","line":3868},"backtrace":["","#0 \/opt\/bitnami\/wordpress\/wp-includes\/class-wpdb.php(3868): mysqli_num_fields()","#1 \/opt\/bitnami\/wordpress\/wp-includes\/class-wpdb.php(780): wpdb->load_col_info()","#2 \/bitnami\/wordpress\/wp-content\/plugins\/w3-total-cache\/DbCache_WpdbInjection_QueryCaching.php(218): wpdb->__get()","#3 \/bitnami\/wordpress\/wp-content\/plugins\/w3-total-cache\/DbCache_WpdbNew.php(122): W3TC\\DbCache_WpdbInjection_QueryCaching->query()","#4 \/bitnami\/wordpress\/wp-content\/plugins\/cleantalk-spam-protect\/lib\/Cleantalk\/ApbctWP\/DB.php(126): W3TC\\DbCache_WpdbNew->query()","#5 \/bitnami\/wordpress\/wp-content\/plugins\/cleantalk-spam-protect\/lib\/Cleantalk\/ApbctWP\/Firewall\/SFW.php(600): Cleantalk\\ApbctWP\\DB->execute()","#6 \/bitnami\/wordpress\/wp-content\/plugins\/cleantalk-spam-protect\/cleantalk.php(2111): Cleantalk\\ApbctWP\\Firewall\\SFW::sendLog()","#7 [internal function]: ct_sfw_send_logs()","#8 \/bitnami\/wordpress\/wp-content\/plugins\/cleantalk-spam-protect\/lib\/Cleantalk\/Common\/Cron.php(266): call_user_func_array()","#9 \/bitnami\/wordpress\/wp-content\/plugins\/cleantalk-spam-protect\/cleantalk.php(240): Cleantalk\\Common\\Cron->runTasks()","#10 \/opt\/bitnami\/wordpress\/wp-includes\/class-wp-hook.php(324): {closure}()","#11 \/opt\/bitnami\/wordpress\/wp-includes\/class-wp-hook.php(348): WP_Hook->apply_filters()","#12 \/opt\/bitnami\/wordpress\/wp-includes\/plugin.php(517): WP_Hook->do_action()","#13 \/opt\/bitnami\/wordpress\/wp-settings.php(695): do_action()","#14 \/bitnami\/wordpress\/wp-config.php(205): require_once('...')","#15 \/opt\/bitnami\/wordpress\/wp-load.php(50): require_once('...')","#16 \/opt\/bitnami\/wordpress\/wp-blog-header.php(13): require_once('...')","#17 \/opt\/bitnami\/wordpress\/index.php(17): require('...')","#18 {main}","thrown"]}

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor Marko Vasiljevic

    (@vmarko)

    Hello @barnabas1

    Thank you for reaching out and I am happy to help!
    It appears that the TypeError is related to the DB caching. Can you please share which caching method you’re using for DB Caching and please try to disable DB caching in Performance>General settings, save all settings and purge the cache, and let me know if the problem persists.

    Thanks!

    Thread Starter barnabas1

    (@barnabas1)

    Hello @vmarko,

    I’m using Redis DB cache. I’ve disable it now. If the error does not persist while having DB cache disabled does this mean I cannot use DB cache?

    If I use object caching using redis, is there any advantage of using also DB caching?

    • This reply was modified 10 months ago by barnabas1.
    • This reply was modified 10 months ago by barnabas1.
    Plugin Contributor Marko Vasiljevic

    (@vmarko)

    Hello @barnabas1

    Thank you for your feedback.
    In General, you should use one or the other. I would recommend Object Caching in this case. Object Cache?allows us to get data from the database more efficiently. Its purpose is similar to what?a Database Cache?does. But compared to Database Cache,?Object cache?is more efficient as it allows to processing of fewer requests.

    However, like Database Cache, it can be beneficial to use if you are on VPS or dedicated server, get a lot of traffic, have a lot of comments. Also, if you know that database is the bottleneck of your website performance, then Object Cache (like Database Cache) is beneficial to use. But in this case it’s recommended to use Opcode, Memcached or Redis options.

    Thanks!

    Thread Starter barnabas1

    (@barnabas1)

    Thank you @vmarko ????

    Plugin Contributor Marko Vasiljevic

    (@vmarko)

    Hello @barnabas1

    You are most welcome!

    We would really appreciate it if you could take a minute and post a review here. This will help us to continue offering a top-notch product to users.
    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Clean Talk & W3 Total Cache’ is closed to new replies.