After voting for an article, i got the following Mail from my webserver:
INSERT INTO serendipity_karmalog
(entryid, points, ip, user_agent, votetime)
VALUES (391, 1, '123.123.123.123', 'Mozilla/5.0 (Windows; U; Windows NT 5.0; de-DE; rv:1.7. Gecko/20050511 Firefox/1.0.4', 1120039749)<br /><pre>INSERT INTO serendipity_karmalog
(entryid, points, ip, user_agent, votetime)
VALUES (391, 1, '123.123.123.123', 'Mozilla/5.0 (Windows; U; Windows NT 5.0; de-DE; rv:1.7. Gecko/20050511 Firefox/1.0.4', 1120039749)</pre> / Unknown column 'votetime' in 'field list'<br />
I had a look into the table and...surprise...there was no votetime column.
I added the column by hand...maybe its a bug in the plugin?
Plugin Version is 1.01
Karma Logging: Column missing?
-
- Regular
- Posts: 59
- Joined: Mon Apr 18, 2005 8:18 am
- Contact:
It could be that version 1.01 is a special case of 1.0 and is not handled, hmm
Code: Select all
if ($version == '1.1') {
$q = "ALTER TABLE {$serendipity['dbPrefix']}karma ADD visits INT(11) default 0";
$sql = serendipity_db_schema_import($q);
$this->set_config('version', PLUGIN_KARMA_VERSION);
} elseif ($version == '1.0') {
$q = "ALTER TABLE {$serendipity['dbPrefix']}karma ADD visits INT(11) default 0";
$sql = serendipity_db_schema_import($q);
$q = "CREATE TABLE {$serendipity['dbPrefix']}karmalog (
entryid int(11) default null,
points int(4) default null,
ip varchar(15),
user_agent varchar(255),
votetime int(11) default null
)";
-
- Regular
- Posts: 59
- Joined: Mon Apr 18, 2005 8:18 am
- Contact: