[GH-ISSUE #93] production.ERROR: SQLSTATE[42S22]: Column not found #690

New issue

Closed

opened 2026-03-14 10:10:42 +03:00 by kerem · 1 comment

kerem commented

2026-03-14 10:10:42 +03:00

Owner

Originally created by @makua104 on GitHub (Nov 4, 2020).
Original GitHub issue: https://github.com/anonaddy/anonaddy/issues/93

I am trying to self host AnonAddy and followed the self hosting guide at https://github.com/anonaddy/anonaddy/blob/master/SELF-HOSTING.md
I am getting a 500 Server Error when opening the Recipients tab on the app.

MySQL Version: mysql Ver 15.1 Distrib 10.5.6-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

AnonAddy pulled from master today.

The laravel log output is:

[2020-11-04 21:40:07] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'aliases.alias_id' in 'field list' (SQL: select `aliases`.`alias_id`, `aliases`.`aliasable_id`, `aliases`.`email`, `alias_recipients`.`recipient_id` as `pivot_recipient_id`, `alias_recipients`.`alias_id` as `pivot_alias_id` from `aliases` inner join `alias_recipients` on `aliases`.`id` = `alias_recipients`.`alias_id` where `alias_recipients`.`recipient_id` in (...) and `aliases`.`deleted_at` is null) 

more stack trace below...

Originally created by @makua104 on GitHub (Nov 4, 2020). Original GitHub issue: https://github.com/anonaddy/anonaddy/issues/93 I am trying to self host AnonAddy and followed the self hosting guide at https://github.com/anonaddy/anonaddy/blob/master/SELF-HOSTING.md I am getting a 500 Server Error when opening the Recipients tab on the app. MySQL Version: ```mysql Ver 15.1 Distrib 10.5.6-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2``` AnonAddy pulled from master today. The laravel log output is: ``` [2020-11-04 21:40:07] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'aliases.alias_id' in 'field list' (SQL: select `aliases`.`alias_id`, `aliases`.`aliasable_id`, `aliases`.`email`, `alias_recipients`.`recipient_id` as `pivot_recipient_id`, `alias_recipients`.`alias_id` as `pivot_alias_id` from `aliases` inner join `alias_recipients` on `aliases`.`id` = `alias_recipients`.`alias_id` where `alias_recipients`.`recipient_id` in (...) and `aliases`.`deleted_at` is null) more stack trace below... ```

kerem closed this issue

2026-03-14 10:10:47 +03:00

kerem commented

2026-03-14 10:10:53 +03:00

Author

Owner

@makua104 commented on GitHub (Nov 5, 2020):

I found my mistake. I didn't install the exact dependencies in composer.lock, but had upgraded versions.

@makua104 commented on GitHub (Nov 5, 2020): I found my mistake. I didn't install the exact dependencies in composer.lock, but had upgraded versions.

kerem referenced this issue

2026-03-14 11:35:41 +03:00

[GH-ISSUE #690] discogs.com blocks all Anonaddy domains #1051

No labels

bug

pull-request

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

starred/anonaddy#690

No description provided.

Rows
Columns