Forum

Ask, reply and learn. Join the community of Akaunting.

New Discussion

Akaunting restored from backup not working

Ion   ( User )

Commented 4 years ago

I had akaunting v.1.3.17 and today was able to do an automatic update to v.13.18. Success
Then I wanted to update 2.0.2. I took a dump of DB and created a copy of files.
Started update and upgrade seems to pass well but wasn't able to reach dashboard. Always getting blank page. So I decided to revert back to my backed up version.
Restored DB from my dump and files.
Now I'm getting "Whoops, looks like something went wrong."
Please help!

Ion   ( User )

Commented 4 years ago

Fixed.
I needed to clean browser cache. Thx

Ion   ( User )

Commented 4 years ago

Upgrade procedure log:

[2020-02-20T19:17:05.931479-05:00] production.INFO: Downloading core update...
Unzipping core update...
Copying core update files...
Finishing core update...
Finishing update...
Application cache cleared!

In Connection.php line 669:

SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `q
gr_items_company_id_sku_deleted_at_unique`; check that it exists (SQL: alte
r table `qgr_items` drop index `qgr_items_company_id_sku_deleted_at_unique`
)


In PDOStatement.php line 119:

SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `q
gr_items_company_id_sku_deleted_at_unique`; check that it exists


In PDOStatement.php line 117:

SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `q
gr_items_company_id_sku_deleted_at_unique`; check that it exists




[2020-02-20T19:17:05.931577-05:00] production.INFO: Not able to update core from UI

Denis Dulici   ( Admin )

Commented 4 years ago

Hello Ion,

What is your database engine?

Please, don't copy/paste the whole error log here.

Regards

Ion   ( User )

Commented 4 years ago

Hello Denis,

My DB is MariaDB 10.4.x

Please login or register to leave a response.

Showing 1 to 5 of 5 discussions