Question about google table

[edo_romero]

I've have piler installed, but only one google user are added into google table, at all of emails and users table were added correctly (the SSO works fine).

The problem is with piler-import just only download emails just for the user in google table (the admin user, api owner, etc), not for the rest. I've check the API permission on Google user Security interfaces and were added ok.

I''ve try to reproduce the insert query into google table, and sql says that 'id' column are duplicated, so nobody adds into this table. I've try to find how the $id variable is generated (bigger number), but can't find yet.

Thanks in advance Eduardo.

[edo_romero]

my google user on table says:

id email access_token refresh_token created
184467440737095* [e-mail] yaee29.1.AN_WLq-JtqFNJC6nXhEzeSyThG_QMjXu0wwhiCOt... 1/5JwlioY1-sVu_BoaIaxBxD45kT5nZrWMVLxeBjXqtsU 1389813779

[Janos SUTO]

Have the other google users successfully logged in to the piler gui?

[edo_romero]

The user login successfull, but don't have any emails

[Janos SUTO]

OK, firstly please verify that each successfully logged in account is present in the "google" table. The 'id' column you mentioned should be unique, it's the google account id, they assign to each account.

Then please verify that piler user's crontab has an entry for downloading emails from google (check for a line with gmail-imap-import.php), and another entry for actually importing them (check for a line with pilerimport).

[edo_romero]

The crontab por imap import a piler load are installed and run, the problem is in google table, the sql inserts a new user with the same id of only user added, so i've test to alter the id record and can add new user, and the interface seems runs ok.

[Janos SUTO]

I think I found it. Please execute the following schema change on the "google" table:

alter table google change column id id char(32) not null primary key;

then delete the current user, and try to login at least with 2-3 google accounts.

[Janos SUTO]

and do the same with the google_imap table

[Janos SUTO]

If it won't solve your problems, then reopen this issue.