"Subquery returns more than 1 row" error on quick registration
By Aikaterini Koutsouflaki on Tuesday, 13 February 2018
Posted in Technical Issues
Replies 3
Likes 0
Views 747
Votes 0
Hello

While trying to set quick registration on our site we get "Subquery returns more than 1 row" on a blank page.

What we need to do is...

Have the users able to register filling just a few fields at the beginning, and then when loged in, to complete their profile fields. !!! (Some of the remaining fields re mandatory) !!!

Can you please advise about the "Subquery returns more than 1 row" error?

Thank you in advance.
Hi,

Regarding your issue, I've temporary enable the quick registration on your site and I am able to replicate this issue from your site. Can you pass me your FTP account so that I can further investigate your issue?

Please advise.
Sam
·
Tuesday, 13 February 2018 19:04
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you
I have edited post with the ftp credentials.
Aikaterini Koutsouflaki
·
Tuesday, 13 February 2018 19:23
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

Thanks for your ftp account.

Regarding your issue, it seems like your this table #__social_profiles_maps doesn't have the primary key which causing the data error during registration. Please see:

http://take.ms/1mLML
http://take.ms/nVypY

It seems like your EasySocial is working fine before the date on 09 Jan 2018. After this date, any records that added into this table will not have id. Please see http://take.ms/ZPzDJ

Did you migrate your database from other site?

Anyway, I've alter your this table to add the primary key and now the quick registration is working fine.
Please verify again.
Sam
·
Tuesday, 13 February 2018 20:12
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post