Self-hosted update

Self-Hosted | v5
1

Hello, I’ve just updated my system to version v5.11.73 and now I can’t connect. When I open the log file I get this error message:

[2025-05-07 11:00:55] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mybill.locations' doesn't exist (Connection: mysql, SQL: select * from `locations` where `locations`.`client_id` = 3 and `locations`.`client_id` is not null and `locations`.`deleted_at` is null) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mybill.locations' doesn't exist (Connection: mysql, SQL: select * from `locations` where `locations`.`client_id` = 3 and `locations`.`client_id` is not null and `locations`.`deleted_at` is null) at /home/xxxxx/xxxxxx/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825)
[stacktrace]

how can I fix this please?

2

Hi,

Try running php artisan migrate

3

still get this error message when I execute the command php artisan migrate

  INFO  Running migrations.

  2024_10_18_211558_updated_currencies .......................................................................................... 24.07ms FAIL

In Connection.php line 820:

  SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '124' for key 'PRIMARY' (Connection: mysql, SQL: insert into `currenc
  ies` (`id`, `name`, `code`, `symbol`, `precision`, `thousand_separator`, `decimal_separator`) values (124, Bermudian Dollar, BMD, $, 2, ,,
  .))


In MySqlConnection.php line 53:

  SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '124' for key 'PRIMARY'
4

I suggest editing the 2024_10_18_211558_updated_currencies migration file to comment out that line and then try again.

1 Like
6

Thanks.

It Works now

7

Glad to hear it, thanks for the update!

1 Like