Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter wcten

    (@wcten)

    In short, how do I manually reinstall wslusersprofiles table? Thanks.

    Plugin Author Miled

    (@miled)

    hello,
    ok after i added the correct file to the plugin thgen reuploaded i am getting the same error and when i look in the database the wp_wslusersprofiles is still not there…
    is there a solution for this.

    i am getting this error still:

    WordPress database error: [Table ‘holemcc1_wpHG.wp_wslusersprofiles’ doesn’t exist]
    SELECT id, object_sha FROM wp_wslusersprofiles where user_id = 375 and provider = ‘Facebook’

    WordPress database error: [Table ‘holemcc1_wpHG.wp_wslusersprofiles’ doesn’t exist]
    REPLACE INTO wp_wslusersprofiles (id,user_id,provider,object_sha,identifier,websiteurl,profileurl,photourl,displayname,description,firstname,lastname,gender,language,age,birthday,birthmonth,birthyear,email,emailverified,phone,address,country,region,city,zip) VALUES (‘null’,375,’Facebook’,’bc4ea77900651888640f0ccd5cd6edb8e91e2159′,’1508603979380516′,”,’https://www.facebook.com/app_scoped_user_id/1508603979380516/’,’https://graph.facebook.com/1508603979380516/picture?width=150&height=150′,’Head Gab’,”,’Head’,’Gab’,’female’,’en_US’,”,’6′,’4′,’1993′,’[email protected]’,’[email protected]’,”,”,”,”,”,”)

    Warning: Cannot modify header information – headers already sent by (output started at /home/holemcc1/public_html/headgab.com/hg/wp-includes/wp-db.php:1253) in /home/holemcc1/public_html/headgab.com/hg/wp-includes/pluggable.php on line 913

    Warning: Cannot modify header information – headers already sent by (output started at /home/holemcc1/public_html/headgab.com/hg/wp-includes/wp-db.php:1253) in /home/holemcc1/public_html/headgab.com/hg/wp-includes/pluggable.php on line 914

    Warning: Cannot modify header information – headers already sent by (output started at /home/holemcc1/public_html/headgab.com/hg/wp-includes/wp-db.php:1253) in /home/holemcc1/public_html/headgab.com/hg/wp-includes/pluggable.php on line 915

    Warning: Cannot modify header information – headers already sent by (output started at /home/holemcc1/public_html/headgab.com/hg/wp-includes/wp-db.php:1253) in /home/holemcc1/public_html/headgab.com/hg/wp-includes/pluggable.php on line 913

    Warning: Cannot modify header information – headers already sent by (output started at /home/holemcc1/public_html/headgab.com/hg/wp-includes/wp-db.php:1253) in /home/holemcc1/public_html/headgab.com/hg/wp-includes/pluggable.php on line 914

    Warning: Cannot modify header information – headers already sent by (output started at /home/holemcc1/public_html/headgab.com/hg/wp-includes/wp-db.php:1253) in /home/holemcc1/public_html/headgab.com/hg/wp-includes/pluggable.php on line 915

    Warning: Cannot modify header information – headers already sent by (output started at /home/holemcc1/public_html/headgab.com/hg/wp-includes/wp-db.php:1253) in /home/holemcc1/public_html/headgab.com/hg/wp-includes/pluggable.php on line 1173

    i am also geeting similar error for Twitter too…

    Plugin Author Miled

    (@miled)

    if the table doesn’t exist you can create it manually (assuming the prefix is wp_):

    CREATE TABLE IF NOT EXISTS wp_wslusersprofiles (
    	id int(11) NOT NULL AUTO_INCREMENT,
    	user_id int(11) NOT NULL COMMENT 'refers to wp.users.id',
    	provider varchar(50) NOT NULL COMMENT 'provider id',
    	object_sha varchar(255) NOT NULL COMMENT 'to check if hybridauth user profile object has changed from last time, if yes we update the user profile here',
    	identifier varchar(255) NOT NULL COMMENT 'The Unique user\'s ID on the connected provider. Depending on the provider, this field can be an number, Email, URL, etc.',
    	profileurl varchar(255) NOT NULL,
    	websiteurl varchar(255) NOT NULL,
    	photourl varchar(255) NOT NULL,
    	displayname varchar(150) NOT NULL,
    	description varchar(255) NOT NULL,
    	firstname varchar(150) NOT NULL,
    	lastname varchar(150) NOT NULL,
    	gender varchar(10) NOT NULL,
    	language varchar(20) NOT NULL,
    	age varchar(10) NOT NULL,
    	birthday int(11) NOT NULL,
    	birthmonth int(11) NOT NULL,
    	birthyear int(11) NOT NULL,
    	email varchar(255) NOT NULL,
    	emailverified varchar(255) NOT NULL,
    	phone varchar(75) NOT NULL,
    	address varchar(255) NOT NULL,
    	country varchar(75) NOT NULL,
    	region varchar(50) NOT NULL,
    	city varchar(50) NOT NULL,
    	zip varchar(25) NOT NULL,
    	UNIQUE KEY id (id),
    	KEY idp_uid (provider,identifier),
    	KEY user_id (user_id)
    );

    thanks it works now,
    dont forget to add an escape in the comments (user\’s ID)
    thanks a bunch you guys rock…

    Have similar problem here. Question – where do I insert this code provided by Miled above? Thank you in advance.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘wordpress.wp_wslusersprofiles table missing’ is closed to new replies.