docker icon indicating copy to clipboard operation
docker copied to clipboard

Upgrading to latest produces database errors

Open raenrfm opened this issue 1 year ago • 2 comments

I'm getting this over and over in the Akaunting log running this as a docker image on my VPS:

In Connection.php line 822:

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'title'

(Connection: mysql, SQL: alter table crf_documents add title varchar(19

  1. null after contact_country, add subheading varchar(191) null after `

title`)

In Connection.php line 580:

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'title'

raenrfm avatar Jan 25 '24 21:01 raenrfm

I dropped the two columns manually and they were recreated with setup=true. This ticket can be closed.

raenrfm avatar Jan 25 '24 21:01 raenrfm

Scratch that, now it's telling me that I have reached the maximum number of companies (I only have one). I went through the database and pruned some erroneous data in there that suggested I had more than one company. (i.e. company id<>1) Still saying I need to upgrade my plan, when all I will ever have is one company.

raenrfm avatar Jan 27 '24 16:01 raenrfm