Title: Missing wslusersprofiles table
Last modified: August 22, 2016

---

# Missing wslusersprofiles table

 *  [Igor Jerosimić](https://wordpress.org/support/users/x64igor/)
 * (@x64igor)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/missing-wslusersprofiles-table/)
 * I just installed this plugin and when I tried to login via Facebook I got error
   about missing “wp_wslusersprofiles” database table. I tried running CREATE TABLE
   command (which I found in plugin’s PHP files) manually, I got error
 * > #1071 – Specified key was too long; max key length is 1000 bytes
 *  which is probably the reason why database table wasn’t created in the first 
   place.
 * **Hacky solution**: I had to remove index “KEY idp_uid (provider,identifier)”
   as a workaround to create this database table, I’m not sure how it will affect
   performance though.
 * P.S. On a related note, why is “id” not a primary key? THis question goes for
   both tables.
 * [https://wordpress.org/plugins/wordpress-social-login/](https://wordpress.org/plugins/wordpress-social-login/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [Miled](https://wordpress.org/support/users/miled/)
 * (@miled)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/missing-wslusersprofiles-table/#post-5416074)
 * > length is 1000 bytes
 * i use latin1 for my tests which only give 514, and i completely forgot about 
   uft8. many thanks for pointing this out!
 * anyway, idp_uid is now scheduled for removal next release and will be replaced.
 *     ```
       mysql> EXPLAIN SELECT * FROM wp_wslusersprofiles WHERE provider = 'Google' AND identifier = '108839241301472312344';
       +----+-------------+---------------------+-------+---------------+---------+---------+-------------+------+-------+
       | id | select_type | table               | type  | possible_keys | key     | key_len | ref         | rows | Extra |
       +----+-------------+---------------------+-------+---------------+---------+---------+-------------+------+-------+
       |  1 | SIMPLE      | wp_wslusersprofiles | const | idp_uid       | idp_uid | 514     | const,const |    1 | NULL  |
       +----+-------------+---------------------+-------+---------------+---------+---------+-------------+------+-------+
       1 row in set (0.00 sec)
       ```
   
 * > P.S. On a related note, why is “id” not a primary key? THis question goes for
   > both tables.
 * that’s due to few issues i encountered with dbdelta..
    [http://onetarek.com/wordpress/wordpress-dbdelta-database-error-multiple-primary-key-defined/](http://onetarek.com/wordpress/wordpress-dbdelta-database-error-multiple-primary-key-defined/)

Viewing 1 replies (of 1 total)

The topic ‘Missing wslusersprofiles table’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wordpress-social-login_a1a2bc.svg)
 * [WordPress Social Login](https://wordpress.org/plugins/wordpress-social-login/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-social-login/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-social-login/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-social-login/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-social-login/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-social-login/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Miled](https://wordpress.org/support/users/miled/)
 * Last activity: [11 years, 5 months ago](https://wordpress.org/support/topic/missing-wslusersprofiles-table/#post-5416074)
 * Status: not resolved