Title: Couldn't be activated
Last modified: August 20, 2016

---

# Couldn't be activated

 *  [Hope](https://wordpress.org/support/users/amalsh/)
 * (@amalsh)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/couldnt-be-activated/)
 * The plugin sounds good from the description but couldn’t be activated, it triggered
   a fatal error…
 * [http://wordpress.org/extend/plugins/php-analytics/](http://wordpress.org/extend/plugins/php-analytics/)

Viewing 1 replies (of 1 total)

 *  [derricksmith01](https://wordpress.org/support/users/derricksmith01/)
 * (@derricksmith01)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/couldnt-be-activated/#post-3206414)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/php-analytics_c6bcca.svg)
 * [phpanalytics](https://wordpress.org/plugins/php-analytics/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/php-analytics/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/php-analytics/)
 * [Active Topics](https://wordpress.org/support/plugin/php-analytics/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/php-analytics/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/php-analytics/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [derricksmith01](https://wordpress.org/support/users/derricksmith01/)
 * Last activity: [13 years, 3 months ago](https://wordpress.org/support/topic/couldnt-be-activated/#post-3206414)
 * Status: not resolved