Posted on: 08/16/14 03:27pm
By: thatlinuxbox
I have Facebook, Twitter, and Google OAuth enabled on my site:
http://thatlinuxbox.com/blog/[*1]
All were working fine previously.
Today I notice that I cannot log in with Google anymore.
My Geeklog error log:
Sat 16 Aug 2014 15:19:11 EDT - 24.170.201.138 - 1064: 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 in .../system/lib-user.php:302. SQL in question: INSERT INTO gl_group_assignments (ug_main_grp_id, ug_uid) VALUES (13, )
Sat 16 Aug 2014 15:19:11 EDT - 24.170.201.138 - E_USER_ERROR(256) - An SQL error has occurred. Please see error.log for details. @ .../system/databases/mysqli.class.php line 279
I tried deleted the Google user, did not change the behavior or error log lines.
I am not sure if this matters, but I have successfully logged in with my Facebook and Twitter accounts (and Google account), all of which are registered with the same email address.
Thanks,
- Dan Stoner
Re: Google OAuth problem
Posted on: 08/16/14 04:26pm
By: Anonymous (ironmax)
Dan,
I just logged into your site, with my Google user name with no issues. Give it another try. If it still doesn't work, then we'll have to look into it further.
Michael
Re: Google OAuth problem
Posted on: 08/16/14 09:49pm
By: thatlinuxbox
Yes, working now. Thanks for testing.
Strangeness!
- Dan Stoner
Re: Google OAuth problem
Posted on: 08/18/14 02:21pm
By: thatlinuxbox
My problem has returned.
I wonder if it is a token timeout of some kind?
I had been logged in and editing a story this morning and when I came back from lunch my "session" had expired (I was directed to the Geeklog "Authentication Required" page when I tried to edit the story again). That page, BTW does not show any OAuth buttons in the body.
I clicked on my Google OAuth button in my sidebar and then received the "Unfortunately, an error has occurred rendering this page. Please try again later." message.
The error log lines (it seems that ug_uid is empty which is why the SQL query is failing):
Mon 18 Aug 2014 14:17:39 EDT - 128.227.127.75 - 1064: 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 in .../system/lib-user.php:302. SQL in question: INSERT INTO gl_group_assignments (ug_main_grp_id, ug_uid) VALUES (13, )
Mon 18 Aug 2014 14:17:39 EDT - 128.227.127.75 - E_USER_ERROR(256) - An SQL error has occurred. Please see error.log for details. @ .../system/databases/mysqli.class.php line 279
- Dan Stoner
Re: Google OAuth problem
Posted on: 08/18/14 06:57pm
By: Laugh
Put a bug report in for the error.
I knew about the Geeklog "Authentication Required" page not having the OAuth buttons. The issue there I believe deals with the fact that there is multiple redirects so the Geeklog Authentication required page couldn't handle that. Still we should either fix the problem (if possible) or show a different page stating something like the story couldn't be saved due to your oauth session timed out.
Re: Google OAuth problem
Posted on: 08/21/14 08:18pm
By: thatlinuxbox
Bug report submitted.
http://project.geeklog.net/tracking/view.php?id=1779