search

TohurTV / oc-socialconnect-plugin

Allows users to sign-in with their Social accounts on your OctoberCMS website
https://octobercms.com/plugin/tohur-socialconnect
5 stars 3 forks source link

Column not found: 1054 Unknown column 'provider_userid' in 'field list' #8

Closed chrisvidal closed 4 years ago

chrisvidal commented 4 years ago

when I tried to login using FB, this is the exception I am facing. It was working fine before the update.

in /var/www/html/eclia/plugins/tohur/socialconnect/vendor/laravel/socialite/src/Two/AbstractProvider.php on line 210
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'provider_userid' in 'field list' in /var/www/html/eclia/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:77
TohurTV commented 4 years ago

ok will find the issue it has to do with the migrations as you stated in the other post. will do some back tracking and make new migrations for people upgrading

TohurTV commented 4 years ago

the easiest way to fix this for now and I should update the plugin page to so is run php artisan plugin:refresh Tohur.SocialConnect. this will reset the tables for the plugin and install the new fields but if everyones user info is the same it will still log them into the proper accounts. Do a backup before the refresh just to be sure. In the future I will be handling migrations better