Viewing 1 replies (of 1 total)
  • I had the same problem. Turned out non of the beginning php tags were completed in any of the files. I manually went through them all (maybe 25) and changed ‘<?’ to ‘<?php’. This solved the first problem.

    The second problem I ran into was inserting a new database. This problem was caused by how the wp_an_databases table was created. Since phpanalytics stores the database passwords encrypted (good), the password column needs to be a blob instead of a varchar. I changed

    $qy_table_databases = ‘
    CREATE TABLE IF NOT EXISTS '.$analytics_sql['tname']['databases'].' (
    DB_ID int(10) unsigned NOT NULL AUTO_INCREMENT,
    DB_NAME varchar(256) NOT NULL,
    DB_HOST varchar(256) NOT NULL,
    DB_USER varchar(256) NOT NULL,
    DB_PASS varchar(256) NOT NULL,
    PRIMARY KEY (DB_ID)
    ) — ENGINE = INNODB DEFAULT CHARACTER SET utf8
    ‘;

    to

    $qy_table_databases = ‘
    CREATE TABLE IF NOT EXISTS '.$analytics_sql['tname']['databases'].' (
    DB_ID int(10) unsigned NOT NULL AUTO_INCREMENT,
    DB_NAME varchar(256) NOT NULL,
    DB_HOST varchar(256) NOT NULL,
    DB_USER varchar(256) NOT NULL,
    DB_PASS BLOB NOT NULL,
    PRIMARY KEY (DB_ID)
    ) — ENGINE = INNODB DEFAULT CHARACTER SET utf8
    ‘;

    After the database changes, I had to deactivate the plugin and remove the database tables manually. I then reactivated it and it installed correctly.

    Good luck.

Viewing 1 replies (of 1 total)
  • The topic ‘Couldn't be activated’ is closed to new replies.