when updating the user profile the following message occurs, however the update is executed.

PDOException: SQLSTATE[HY000]: General error: 1364 Field 'token' doesn't have a default value: INSERT INTO {facebook_rules_user_tokens} (uid, user_grant) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1); Array ( [:db_insert_placeholder_0] => 9542 [:db_insert_placeholder_1] => ) in facebook_rules_profile_submit() (line 94 of /var/www/sites/all/modules/facebook_rules/facebook_rules.module).

CommentFileSizeAuthor
#10 facebook_rules-error_while_saving_users-1619508.patch798 bytesnodeAche
#5 facebook_rules-PDOexception-1619508.patch673 bytesfotuzlab

Comments

fotuzlab’s picture

fotuzlab commented

Thanx for reporting. I'd look into it this weekend.

franxo’s picture

franxo commented

Same error for me!

oscar_arnulfo’s picture

oscar_arnulfo commented

Same here, nothing yet?

iangohye’s picture

iangohye commented

Hi im running into this same error too.

Created a non facebook account and the following shows up:

Notice: Undefined index: facebook_rules_allow in facebook_rules_profile_submit() (line 92 of /var/www/sites/all/modules/facebook_rules/facebook_rules.module).
PDOException: SQLSTATE[HY000]: General error: 1364 Field 'token' doesn't have a default value: INSERT INTO {facebook_rules_user_tokens} (uid, user_grant) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1); Array ( [:db_insert_placeholder_0] => 120 [:db_insert_placeholder_1] => ) in facebook_rules_profile_submit() (line 94 of /var/www/sites/all/modules/facebook_rules/facebook_rules.module).
fotuzlab’s picture

fotuzlab commented
Status: Active » Fixed
StatusFileSize
new facebook_rules-PDOexception-1619508.patch673 bytes

attached patch. Committed to dev.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

optalgin’s picture

optalgin commented

Instead of patching manually running from issue to issue (I patched 3 already)
Can you enable the dev release in the project page?
Or better create a new stable release :)

Thanks

fotuzlab’s picture

fotuzlab commented

I have enabled dev release.

semei’s picture

semei commented

First of all, thanks for this great module!

attached patch. Committed to dev.

I experience the same problem with the latest dev. Optalgin is right, could someone please commit all the patches that have acccumulated over the last weeks into dev? I'm having problems to apply several patches to the same module, patching always fails.

nodeAche’s picture

nodeAche commented
StatusFileSize
new facebook_rules-error_while_saving_users-1619508.patch798 bytes

I had the same issue, Please check this patch.

idealform01’s picture

idealform01 commented

Subscribing, just ran into this error.