Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated
Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

Deleted user - Facebook login

10 years 10 months ago
  • Ondrej's Avatar
    Topic Author
  • Ondrej
  • Offline
  • Fresh Boarder
  • Posts: 13
  • Thank you received: 20
Licenses:
JomSocial Expired

Albertus wrote: Hi Ondrej,

please emptying Table: jos_community_connect_users after that the facebook login will back to normal again. something wrong with old existing records for that table.

Regards,
Albert


Hallo Albert,

Thanks for the support. Clearing the table helps to resolve the issue and once deleted user can connect again.

The bug seems to be that deleting the user in the back end does not clear this user from the jos_community_connect_users table. Because once you clear the table and repeat the process (i.e. register via Facebook and delete the user in the back end) the user reapers and stays in this table after being deleted in the back end. It doesn't matter whether he is deleted via Joomla Users or via JomSocial members.

Maybe it is related to this message I get in phpMyAdmin above this table?:

This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

I can delete the individual rows by running the query and conditioning it by the userid. Maybe the code for this table was forgotten in the JomSocial? Will there be an update?

Thank you for finding this.

10 years 10 months ago
Licenses:

Hi Ondrej

please try to add the unique column as auto increment id. execute this query at your phpmyadmin

ALTER TABLE `jos_community_connect_users` ADD `id` INT NOT NULL AUTO_INCREMENT FIRST ,
ADD PRIMARY KEY ( `id` ) ;

I already report to our developer to make improvement.

Regards,
Albert

The following user(s) said Thank You: Ondrej
10 years 10 months ago
  • Ondrej's Avatar
    Topic Author
  • Ondrej
  • Offline
  • Fresh Boarder
  • Posts: 13
  • Thank you received: 20
Licenses:
JomSocial Expired

Yes, this adds the possibility to delete the row without running a querry.

It doesn't effect the fact that the row in jos_community_connect_users is not emptied when you delete a user in the back end. Looking forward for the update.

10 years 10 months ago
Licenses:

Hi Ondrej,

may I know your MySQL version? i need that for tackle this issue at our next update

Regards,
Albert

10 years 10 months ago
  • Ondrej's Avatar
    Topic Author
  • Ondrej
  • Offline
  • Fresh Boarder
  • Posts: 13
  • Thank you received: 20
Licenses:
JomSocial Expired

Database Version 5.5.32-cll-lve
Database Collation utf8_general_ci
PHP Version 5.4.26
Web Server Apache mod_fcgid/2.3.10-dev
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.3.1 Stable [ Ember ] 11-June-2014 13:30 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

Otherwise you can log in to the sandbox page and see the details, it is still up and running.

Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW

About Us

Our product

Support

Contact Us

Site Policies

Elsewhere

© JomSocial.com All Rights Reserved