ShawnClake / UserExtended

An extension to the existing RainLab.User plugin for OctoberCMS
http://octobercms.com/plugin/clake-userextended
GNU General Public License v3.0
23 stars 12 forks source link

SQL Errors in backend #121

Closed noxify closed 3 years ago

noxify commented 7 years ago

Hi,

tested with a fresh installation and the following OC Plugins:

bildschirmfoto 2017-05-01 um 15 33 21

Now, while trying to open the "Comments" Page in the backend, I got the following error:

SQLSTATE[42702]: Ambiguous column: 7 ERROR: ORDER BY "user_id" is ambiguous LINE 1: ...rextended_comments"."deleted_at" is null order by "user_id" ... ^ (SQL: select "clake_userextended_comments".*, (select name from "users" where "clake_userextended_comments"."user_id" = "users"."id") as "user_id", (select name from "users" where "clake_userextended_comments"."author_id" = "users"."id") as "author_id" from "clake_userextended_comments" where "clake_userextended_comments"."deleted_at" is null order by "user_id" desc limit 20 offset 0)

Same for "Friends"

SQLSTATE[42702]: Ambiguous column: 7 ERROR: ORDER BY "user_that_sent_request" is ambiguous LINE 1: ...erextended_friends"."deleted_at" is null order by "user_that... ^ (SQL: select "clake_userextended_friends".*, (select name from "users" where "clake_userextended_friends"."user_that_sent_request" = "users"."id") as "user_that_sent_request", (select name from "users" where "clake_userextended_friends"."user_that_accepted_request" = "users"."id") as "user_that_accepted_request" from "clake_userextended_friends" where "clake_userextended_friends"."deleted_at" is null order by "user_that_sent_request" desc limit 20 offset 0)

ENV:

mnvx commented 7 years ago

I stuck with this problem too. My database is PostgreSQL.