Can't install W3TC, getting fatal error!

  • I was testing something else, so disabled W3 Total Cache, now I can’t reactivate it, getting fatal error. To get proper error message I activated WP_DEBUG “true”.

    Getting lots of error like below
    ================================

    Notice: get_settings is deprecated since version 2.1! Use get_option() instead. in ~/wp-includes/functions.php on line 

WordPress database error: [DROP command denied to user 'remote_user' for table 'w3tc_cdn_queue']
DROP TABLE IF EXISTS <code>w3tc_cdn_queue</code>;

WordPress database error: [CREATE command denied to user 'remote_user' for table 'w3tc_cdn_queue']
CREATE TABLE IF NOT EXISTS <code>w3tc_cdn_queue</code> ( <code>id</code> int(11) unsigned NOT NULL AUTO_INCREMENT, <code>local_path</code> varchar(500) NOT NULL DEFAULT '', <code>remote_path</code> varchar(500) NOT NULL DEFAULT '', <code>command</code> tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1 - Upload, 2 - Delete, 3 - Purge', <code>last_error</code> varchar(150) NOT NULL DEFAULT '', <code>date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (<code>id</code>), KEY <code>date</code> (<code>date</code>) ) DEFAULT CHARACTER SET utf8;


    =====================

    Stuff like completely deleting w3tc, removing object-cache.php file, manually deleting all old cache file, but does not help. Did any of you experienced that? Any suggestion will be great.

    https://www.ads-software.com/plugins/w3-total-cache/

Viewing 1 replies (of 1 total)
  • Thread Starter M Asif Rahman

    (@asif2bd)

    Ok, I found the solution myself. Issue was with my remote db permission. I loginto remote db and grant permission with this command and was able to install W3TC properly.

    GRANT DROP,CREATE ON dbname.* TO 'dbuser'@'host';

    I described the whole process and some other possible way you should look if you run into issue in re-installing W3TC in my blog post about “Solution to weird W3TC install error and slution“.

Viewing 1 replies (of 1 total)
  • The topic ‘Can't install W3TC, getting fatal error!’ is closed to new replies.