I have implemented this into my existing laravel 4.2 project but when I create a message I get:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'users.name' in 'field list' (SQL: select concat(users.name) as name fromusersinner joinparticipantsonusers.id=participants.user_idwhereparticipants.thread_id= 2 andusers.id!= 1) (View: /home/UNIT3D/app/views/messenger/index.blade.php)
Then if I try to goto messenger index I get:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'users.name' in 'field list' (SQL: select concat(users.name) as name fromusersinner joinparticipantsonusers.id=participants.user_idwhereparticipants.thread_id= 2 andusers.id!= 1) (View: /home/UNIT3D/app/views/messenger/index.blade.php)
How and where can I fix this? The messages are posting to DB. I already had a users table when installed this "plugin".
It appears (users.name) as name from users from error above is saying to grab username as name from users table. My users table uses a column named username and not name. Where do I need to edit this?
HDVinnie
commented
7 years ago
I have implemented this into my existing laravel 4.2 project but when I create a message I get:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'users.name' in 'field list' (SQL: select concat(users.name) as name fromusersinner joinparticipantsonusers.id=participants.user_idwhereparticipants.thread_id= 2 andusers.id!= 1) (View: /home/UNIT3D/app/views/messenger/index.blade.php)Then if I try to goto messenger index I get:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'users.name' in 'field list' (SQL: select concat(users.name) as name fromusersinner joinparticipantsonusers.id=participants.user_idwhereparticipants.thread_id= 2 andusers.id!= 1) (View: /home/UNIT3D/app/views/messenger/index.blade.php)How and where can I fix this? The messages are posting to DB. I already had a users table when installed this "plugin".
It appears (users.name) as name from
usersfrom error above is saying to grab username as name from users table. My users table uses a column named username and not name. Where do I need to edit this?