Error install plugin 0.56 - piwik 2.15.0

[Bulinator]

Error message received: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'piwik.piwik_bot_db' doesn't exist 2.15.0

table piwik.piwik_bot_db_stats' is created when we installed the plugin through piwik.

[Thomas--F]

Did you make a new install or did you update an old version of BotTracker?

If the plugin is installed but the table is still missing, try to execute the following SQL:

CREATE TABLE `piwik.piwik_bot_db`
     (`botId` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
     `idsite` INTEGER(10) UNSIGNED NOT NULL,
     `botName` VARCHAR(100) NOT NULL,
     `botActive` BOOLEAN NOT NULL,
     `botKeyword` VARCHAR(32) NOT NULL,
     `botCount` INTEGER(10) UNSIGNED NOT NULL,
     `botLastVisit` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
     `extra_stats` BOOLEAN NOT NULL DEFAULT FALSE,
     PRIMARY KEY(`botId`)
     )  DEFAULT CHARSET=utf8

[Bulinator]

Hi,

I actually try to install it as new plugin.

To my mind, with this, it should be work. I try right now.

I let you know.

Thanks

Le 25/10/15 20:03, Thomas Fasselt a écrit :

Did you make a new install or did you update an old version of BotTracker?

If the plugin is installed but the table is still missing, try to execute the following SQL:

CREATE TABLE piwik.piwik_bot_db (botId INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, idsite INTEGER(10) UNSIGNED NOT NULL, botName VARCHAR(100) NOT NULL, botActive BOOLEAN NOT NULL, botKeyword VARCHAR(32) NOT NULL, botCount INTEGER(10) UNSIGNED NOT NULL, botLastVisit TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', extra_stats BOOLEAN NOT NULL DEFAULT FALSE, PRIMARY KEY(botId) ) DEFAULT CHARSET=utf8

— Reply to this email directly or view it on GitHub https://github.com/Thomas--F/BotTracker/issues/36#issuecomment-150959355.

[Thomas--F]

It seems, the plugin tries to run the update-statements. Just delete all files in the update-folder of the plugin.

I think I will delete the files in the next release. No one will update an old version of BotTracker (below 0.46).

[Bulinator]

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512

Oki it's working fine now ;)

Thanks.

Le 25/10/15 20:15, Thomas Fasselt a écrit :

It seems, the plugin tries to run the update-statements. Just delete all files in the update-folter of the plugin.

I think I will delete the files in the next release. No one will update an old version of BotTracker (below 0.46).

— Reply to this email directly or view it on GitHub https://github.com/Thomas--F/BotTracker/issues/36#issuecomment-150959 960.

-----BEGIN PGP SIGNATURE----- Comment: GPGTools - https://gpgtools.org

iQIcBAEBCgAGBQJWLSuSAAoJEPB077jqiebMjegP/1ivVYaSZVgzKIUMOnpJ9+eC MjCDZkfgZ5fXIWnT7Yt63evhRJ+xO3MNwt0efp6zDOnzFBYhpMP/TZsRJUg4X133 OpAv9fFHRgIrWAxo+oBBUMsMpRR/k1I+n8l9Ezb8Z/8D9qbPpRYdPlGHLIn5Es2+ ifqkO+3CHKNJ81mD7vHyC7U26O7s6/YnMWMJcTQcn/p/UAiAjVs4hoISKnNM9wWU w8OV9SGUmDbiWHyx5J93mpEX8XkAzj2tqPTqBTw2ztmGVH9/bu0ts5wqAet7pmj6 oQNj1U2zy6DLajRD7sUdjwGtO7j5HNsotYAva+9eof1Sa25WhGvbWnzgcfVbbAoS vSfHIMLioetQUPHeEloK/UmnvvvybSpSdn0dXf/6hWvXzfUj8IX2kiPYMyYYa2PW tA+k282b/ENGdVTT7vlYpMAcRxU7bmbTbbLz3qzg/xg7yi8aKvoM7EHaabHtghsN 2fQxSjxvt59tZ87kMtG0ydAL6fzvaEZwvJB9HKXnLmP0yn5nLwwmIycb9tooZd2o 5bnPJgY/u4fGlOGIIqWN3sWHiLEILwAmxj2TtP4PqKagJZHHmaGbJYGJi1uqN6NC 7jTTVuwqzBeNBwRciTWw4bAqWlSjRNigYVhaZxJxGKC1jF1+7UwzYjdmacdYgB+d 9zmVuVqMnz9VzXP3YGSZ =yfg+ -----END PGP SIGNATURE-----

[Thomas--F]

Thanks for testing. I'm closing this issue.