Serendipity Forums

Posted: **Mon Apr 03, 2006 6:32 am**

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.

Posted: **Mon Apr 03, 2006 10:47 am**

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

Posted: **Tue Apr 04, 2006 5:11 am**

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.

Posted: **Tue Apr 04, 2006 9:04 am**

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

Serendipity Forums

KARMA ERROR email

KARMA ERROR email

Re: KARMA ERROR email