Why does LinkedIn OAuth login fail with IntegrityError

On setup the following happens:

IntegrityError at /account/signin/complete-oauth/
(1452, 'Cannot add or update a child row: a foreign key constraint fails (`askbot`.`askbot_message`, CONSTRAINT `user_id_refs_id_7f68bf7c` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`))')
Request Method: GET
Request URL:    http://xxx/account/signin/complete-oauth/?oauth_token=78--220c657e-3b12-4440-bf29-aba8fce8320e&oauth_verifier=56157
Django Version: 1.8.18
Exception Type: IntegrityError
Exception Value:    
(1452, 'Cannot add or update a child row: a foreign key constraint fails (`askbot`.`askbot_message`, CONSTRAINT `user_id_refs_id_7f68bf7c` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`))')
Exception Location: /usr/local/lib/python2.7/dist-packages/MySQLdb/connections.py in defaulterrorhandler, line 36
Python Executable:  /usr/bin/python
Python Version: 2.7.12
Python Path:    
['/usr/lib/python2.7',
 '/usr/lib/python2.7/plat-x86_64-linux-gnu',
 '/usr/lib/python2.7/lib-tk',
 '/usr/lib/python2.7/lib-old',
 '/usr/lib/python2.7/lib-dynload',
 '/usr/local/lib/python2.7/dist-packages',
 '/usr/lib/python2.7/dist-packages',
 '/opt',
 '/opt/SHAZAM',
 '/usr/local/lib/python2.7/dist-packages/askbot/deps']
Server time:    Sun, 4 Feb 2018 04:55:07 +0000

The askbot_message table contains 0 rows. This is the migration of a site to the latest master branch code.

Rupreck's avatar
305
Rupreck
asked 2018-02-03 23:25:14 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments