Thomas--F/BotTracker

Error install plugin 0.56 - piwik 2.15.0

Closed this issue · 5 comments

Bulinator commented

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 commented

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 commented

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 commented

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 commented

-----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 commented

Thanks for testing. I'm closing this issue.