Conflicts with Facebook and Regular registration

ScottUlmer

plug-in but I had to disable because whenever a new person would register they would get the “Bonk page” at first I check the mail settings as this was the first error, then Facebook, all of this to no avail. Eventually I got to the correct error Field “TransCount” doesn’t have default value insert GDN_KarmaBankBalance (UserID, Balance) values (:UserID, :Balance) line 280 of \libary\database\class.database.php . I disable this plug-in and no more issue. Please tell me know to fix (I assume set value = “1” or w/e, nut what value and where?)

x00

You might have mysql on strict mode, or stricter version MySQL, it might be that warning are set high. It should automatically put the default value 0 with integer, when not null otherwise.

The default value should be 0, so it can increment from that. I will put it in next release but it is so small a change it is worth releasing on it own.

x00

ALTER TABLE GDN_KarmaBankTransTally ALTER COLUMN LastTally SET DEFAULT 0;

ScottUlmer

I did that and 0.00 as it is a decimal and i even did 1.00 all have the same result and error.

x00

try to change Null to yes.

ScottUlmer

No go. I even tried to change "as defined" to none.

x00

sorry wrong column

ALTER TABLE GDN_KarmaBankTransTally ALTER COLUMN TransCount SET DEFAULT 0;

ScottUlmer

I do not see that column, should I create a new one?

x00

Sorry its early lol the table is KarmaBankBalance

ALTER TABLE GDN_KarmaBankBalance ALTER COLUMN TransCount SET DEFAULT 0;

ScottUlmer

This looks right, but it still part of the error. in My config I set it to 1 (so it shouldnt be 0, only database has 0 like you said to do).

x00

set what to 1? the balance is something else.

ScottUlmer

Awesome job thanks mate! Both of them work without a any issues. I appreciate all your work.

x00

oh I see you point, the trans count is actually an offset. like offset, limit so the first values should be 0

x00

well for pagination to work correctly TransCount default need to be 0. It was perhaps an ill conceived name but there you go.

x00

Updated version
http://vanillaforums.org/addon/karmabank-plugin-0.9.6.3b