Deleting a user in backend issue
By Jason Wells on Thursday, 23 November 2017
Posted in General Issues
Replies 3
Likes 0
Views 742
Votes 0
I am trying to delete a test user "John Morris" from the backend Users > Manage and get the following message:

42000 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

When I go Components > Easy Social > Users and try to delete I get the following message

An error has occurred.
0 Too few arguments to function EasySocialModelProfiles::updateUserProfile(), 2 passed in /home/jasoncwells/public_html/plugins/payplans/easysocialprofiletype/easysocialprofiletype.php on line 126 and exactly 3 expected
I already help you remove those conversation id (4) data from your database, and i can able to delete that user from your site backend now.
Arlex Wong
·
Thursday, 23 November 2017 15:34
·
0 Likes
·
0 Votes
·
0 Comments
·
Hm, something is strange from this conversation id (4), because this person John Morris created that conversation, when you delete this user, system will try to remove what he created those conversation in previously.

And I also can't replicate this issue in my locally, can I have the permission to help you manually delete this conversation id (4) data from your database?
Arlex Wong
·
Thursday, 23 November 2017 12:37
·
0 Likes
·
0 Votes
·
0 Comments
·
Please do what you need.

I am using John Morris as a test user for the registration process and other site activities.

Thanks a lot for the help.
Jason Wells
·
Thursday, 23 November 2017 14:44
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post