Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Upgrading to latest produces database errors #109

Open
raenrfm opened this issue Jan 25, 2024 · 2 comments
Open

Upgrading to latest produces database errors #109

raenrfm opened this issue Jan 25, 2024 · 2 comments

Comments

@raenrfm
Copy link

raenrfm commented Jan 25, 2024

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
Copy link
Author

raenrfm commented Jan 25, 2024

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

@raenrfm
Copy link
Author

raenrfm commented Jan 27, 2024

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant