KARMA ERROR email

[jerwarren]

I just installed the karma plugin on a brand new blog, and have found that it works, but every time you rate an entry as a logged in user, you get an email containing this:

Code: Select all

INSERT INTO serendipity_karmalog
                                      (entryid, points, ip, user_agent, votetime)
                               VALUES (2, -2, '24.20.92.178', 'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.12) Gecko/20051010 Firefox/1.0.7 (Ubuntu package 1.0.7)', 1144037834)<br /><pre>INSERT INTO serendipity_karmalog
                                      (entryid, points, ip, user_agent, votetime)
                               VALUES (2, -2, '24.20.92.178', 'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.12) Gecko/20051010 Firefox/1.0.7 (Ubuntu package 1.0.7)', 1144037834)</pre> / Unknown column 'votetime' in 'field list'<br />

If you disable 'log karma votes' it still works properly, just doesn't mail you errors.

[garvinhicking]

Hi!

That message tells you your serendipity_karmalog is missing the "votetime" column. Maybe you had that DB table installed at one point, and upgraded the karma plugin without it knowing about the previous update?

If you have access to phpMyadmin or so on your install, please add the votetime oclumn to your table; it's a simple "int(11)" fieldtype.

Regards,
Garvin

[jerwarren]

Well, this was on a fresh install of s9y-1.0-beta1, brand new database, everything.

I only mention it because it clearly isn't properly creating all the necessary columns, and I thought you'd want to know.

[garvinhicking]

Hi!

Great, thanks! In fact the code was branching to the wrong code location where it created the wrong table. Thanks for letting me know, I just fixed it.

Regards,
Garvin