Forum

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

New Discussion

Missing Documents table

Stefan Wempe   ( User )

Commented 3 years ago

root@55a1f8be7d9c:/var/www/akaunting# php -v
PHP 7.4.10 (cli) (built: Sep 10 2020 14:00:50) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
root@55a1f8be7d9c:/var/www/akaunting# php artisan update:finish core 1 2.1.0 2.0.27
Finishing update...
Application cache cleared!

In Connection.php line 678:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'akaunting_db.bvg_modules' doesn't exist (SQL: select * from `bvg_modules` where `alias` = core and `bvg_modules`.`deleted_at` is null and `bvg_modules`.`comp
any_id` = 1 limit 1)


In Exception.php line 18:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'akaunting_db.bvg_modules' doesn't exist


In PDOConnection.php line 77:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'akaunting_db.bvg_modules' doesn't exist


root@55a1f8be7d9c:/var/www/akaunting# ls
LICENSE.txt app bootstrap config index.php modules overrides public routes storage web.config
README.md artisan composer.json database manifest.json nginx.example.com.conf phpunit.xml resources serviceworker.js vendor
root@55a1f8be7d9c:/var/www/akaunting#

Stefan Wempe   ( User )

Commented 3 years ago

seperate post for conclusion:
i am on PHP7.4 (inside docker)
table is not found. my instance wont start.

Chris   ( User )

Commented 3 years ago

I too have this issue. I ran the command set from within /var/www/akaunting and got all the confirmations the caches were cleared and the update was finishing - but now when I log on I get a "this page isn't working" error with http error 500.

I am running this on a VM, so I have my system backed up - but lost two day's worth of entries, stupidly I didn't do a full VM cloning before backing up which I normally do.

Anyway of recovering this broken system still?

Jahangir Mohammad Ali Siddique   ( User )

Commented 3 years ago

how to i go back old version 2.0.26

Jaimy Borgman   ( User )

Commented 3 years ago

@dennis,

it looks btw that the PDF version is broken, it's looking for:
partials.documents.item.print

but that path doesn't exist also verified this with your github branch

Keith Halter   ( User )

Commented 3 years ago

Any update on how to go back to 2.0.26 for those of us who cannot get the upgrade to work for whatever reason?

Luis Stumpf   ( User )

Commented 3 years ago

When upgading from 2.0.26 to 2.1.16 I also had the problem with missing database tables. ( ak.documents etc.. ).
Unfortunatelly I can't use any console command ( laravel etc..), since My host doens allow access.
After installing a fresh new verion 2.1.15 , I copied all the missing table to the old database .
Run Akaunting in the 2.1.15 version with the old database.
Made a second update to version 2.1.16 using the update menu inside the program.
It's working.

Please login or register to leave a response.

Showing 31 to 37 of 37 discussions