Missing Documents table

Hello Guys,

Just updated to version 2.1 and right after the update. I get the following message.

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ak_akaunting.gfh_documents' doesn't exist (SQL: select * from `gfh_documents` where `gfh_documents`.`type` = invoice and `status` not in (draft, cancelled) and `status` <> paid and `gfh_documents`.`deleted_at` is null and `gfh_documents`.`company_id` = 1 order by `gfh_documents`.`id` asc limit 1000 offset 0

Is this some kind of new table from the version that i am missing? Should i run any migration that may not be installed with the update?

Thanks,

I have updated as well to 2.1.0 and just after received "500 Internal Server Error"

Hello Yaron.

Try to enable APP_DEBUG = true on your .env file to see if we get the same error as well.

Thanks,

Yes, I am getting the same error as you.

Hello Guys,

What is your PHP, MySQL version? From which version of Akaunting did you update?

Regards

PHP 7.3 (ea-php73) not sure from which version, but I think the latest one as I have installed it just a few months ago.

Somehow my other message has been removed or something so second try here..
I've got the same issue; after running the `php artisan migrate` it installed the documents table correctly. So probably thats' missing during the update.

But after the "invoices" are not copied over to the new table so i'm missing the invoices in the view. How can we resolve that issue?

Hi @Denis!

Php Version 7.3.24
MySQL 8.0.20
Akaunting Version 2.0.26

Can you please update your log file somewhere and share the link here?

Available in "storage/logs" folder.

[2021-01-26 17:02:41] production.DEBUG: Console command:: '/usr/local/bin/php' artisan update:finish core 3 2.0.27 2.0.26
[2021-01-26 17:02:41] production.DEBUG: core update failed:: file version > 2.1.0 -vs- request version > 2.0.27
[2021-01-26 17:02:41] production.ERROR: Not able to finalize core installation {"exception":"[object] (Exception(code: 0): Not able to finalize core installation at /home/playwi8/public_html/akaunting-directory/app/Console/Commands/FinishUpdate.php:48)
[stacktrace]
#0 /home/playwi8/public_html/akaunting-directory/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Console\\Commands\\FinishUpdate->handle()
#1 /home/playwi8/public_html/akaunting-directory/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#2 /home/playwi8/public_html/akaunting-directory/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#3 /home/playwi8/public_html/akaunting-directory/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#4 /home/playwi8/public_html/akaunting-directory/vendor/laravel/framework/src/Illuminate/Container/Container.php(610): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#5 /home/playwi8/public_html/akaunting-directory/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array)
#6 /home/playwi8/public_html/akaunting-directory/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#7 /home/playwi8/public_html/akaunting-directory/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#8 /home/playwi8/public_html/akaunting-directory/vendor/symfony/console/Application.php(971): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#9 /home/playwi8/public_html/akaunting-directory/vendor/symfony/console/Application.php(290): Symfony\\Component\\Console\\Application->doRunCommand(Object(App\\Console\\Commands\\FinishUpdate), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#10 /home/playwi8/public_html/akaunting-directory/vendor/symfony/console/Application.php(166): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#11 /home/playwi8/public_html/akaunting-directory/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#12 /home/playwi8/public_html/akaunting-directory/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#13 /home/playwi8/public_html/akaunting-directory/artisan(22): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#14 {main}
"}
[2021-01-26 17:02:41] production.DEBUG: Console output:: The command "'/usr/local/bin/php' artisan update:finish core 3 2.0.27 2.0.26" failed.

Exit Code: 1(General error)

Working directory: /home/playwi8/public_html/akaunting-directory

Output:
================
Finishing update...
Application cache cleared!

In FinishUpdate.php line 48:

Not able to finalize core installation


‹