search

akaunting / docker

Docker Image for Akaunting
https://github.com/akaunting/akaunting
GNU General Public License v3.0
182 stars 85 forks source link

Upgrading to latest produces database errors #109

Open raenrfm opened 7 months ago

raenrfm commented 7 months ago

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 commented 7 months ago

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

raenrfm commented 7 months ago

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.