I had everything working with dev 3.x but when updating to the latest release I got a bunch of errors upon testing the login process. I tested all the modules and found out that its a problem with "Register Users"

user warning: Duplicate entry '0-2' for key 1
query: INSERT INTO users_roles (uid, rid) VALUES (0, 2) in sites/all/modules/fb/fb_user.module on line 248.
warning: array_keys() [function.array-keys]: The first argument should be an array in sites/all/modules/logintoboggan/logintoboggan.module on line 485.
warning: in_array() [function.in-array]: Wrong datatype for second argument in sites/all/modules/logintoboggan/logintoboggan.module on line 485.
warning: array_fill() [function.array-fill]: Number of elements must be positive in includes/database.inc on line 253.
warning: implode() [function.implode]: Invalid arguments passed in includes/database.inc on line 253.
warning: array_keys() [function.array-keys]: The first argument should be an array in modules/user/user.module on line 513.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
query: SELECT p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in modules/user/user.module on line 513.
warning: array_keys() [function.array-keys]: The first argument should be an array in modules/block/block.module on line 432.
warning: array_fill() [function.array-fill]: Number of elements must be positive in includes/database.inc on line 253.
warning: implode() [function.implode]: Invalid arguments passed in includes/database.inc on line 253.
warning: array_merge() [function.array-merge]: Argument #2 is not an array in modules/block/block.module on line 433.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module' at line 1
query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = '' AND b.status = 1 AND (r.rid IN () OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in modules/block/block.module on line 433.

CommentFileSizeAuthor
#3 fb_july.zip218.25 KBinterfaced

Comments

interfaced’s picture

interfaced commented

On second investigation, it looks like the error is with the User Management module.

Dave Cohen’s picture

Dave Cohen commented
Status: Active » Closed (won't fix)

OK I'll assume that's the case unless you update this issue.

interfaced’s picture

interfaced commented
Status: Closed (won't fix) » Needs review
StatusFileSize
new fb_july.zip218.25 KB

I found the issues, after days of work(reinstalling, uninstalling, debugging).

The issue is with the latest dev release of 3.x. I have an older version, around July 17. This version is fine and redirects after a fbconnect login. However, the latest version of 3.x does not redirect after login, and does not create a user account for the facebook user.

This is easy to replicate.
1. install the latest release
2. Activate user management & fb connect
3. Try to login with facebook, you will see your name, email, pic, but you will remain on the registration page.

Now, delete that module, and install the zip file of the older module attached. You should be able to login, and on login you will be redirected to the correct user page.

I hope this helps someone else in my same situation!

Also, I'm wondering what's new in the latest release. Are there some things that I should integrate into this older version of the module?

Dave Cohen’s picture

Dave Cohen commented

Can you make a patch?

Juan C’s picture

Juan C commented

Hi Dave;

I can confirm this that using the latest 6.3.dev, in my situation, I have to 'reload' the page after successful fb login.

As pointed above #3 (Thanks interfaced), using the older 6.3.dev. (July 16) at #3, I don't have to reload the page to have the fb user name appear on the page.

Juan C’s picture

Juan C commented

On second thought, after re-installing again latest 6.3.dev, my 'reload' problem seems fixed. Sorry.

franzkewd’s picture

franzkewd commented

Love the user mapping option on the latest 6.3.dev (Aug 15), however, it seems, I have to refresh the page on initial facebook login. Tried the older 6.3.dev (#3) seems ok. Anyone else experience this? Would investigate further.

Dave Cohen’s picture

Dave Cohen commented

Do you see one or more alerts after the login? I left some debug code in there that might cause that, but only when $conf['fb_verbose'] == 'extreme'

(And that has nothing to do with Register Users or this thread, right?)