Karma Logging: Column missing?

[commanderx]

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

[winkiller]

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
                    )";

[commanderx]

Hm...i installed it with Spartacus.
CVS Version comes with 1.4