Ask, reply and learn. Join the community of Akaunting.
Hmmm...
Fixed that part and changed password on the DB user, but now there is anew exception:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'something_dbname.kyi_dashboards' doesn't exist (SQL: select `id` from `kyi_dashboards` inner join `kyi_user_dashboards` on `kyi_dashboards`.`id` = `kyi_user_dashboards`.`dashboard_id` where `kyi_user_dashboards`.`user_id` = 1 and `kyi_user_dashboards`.`user_type` = users and `enabled` = 1 and `kyi_dashboards`.`deleted_at` is null and `kyi_dashboards`.`company_id` = 1 and `kyi_dashboards`.`deleted_at` is null)
well every server have different OS , software versions installed so it requires times to troubleshoot the exact issue. there isn't just one way to fix any similar issue as the server environment on which we are running app is different from other users we are comparing with.
can you plz share your server/web hosting environment on which you are running akaunting app ? which OS, which control panel, which php and mysql versions , your akaunting app current installed version ? i just helped another guy from turkey and he was having 1.3.17 akaunting version , i helped him upgrade to 2.0.9 smoothly by installing his files on my server , did trouble shooting and i know whats running on my server and how to fix it. and delivered back to him with the latest version up and running on his machine.
Thank you you much for your kind answer and your willingness to help...
That is appreciated for sure.
Well I already done a roll back of our systems so its back to operational status and the older version for now. I did however check our DB and in the older version those tables do not exist either so it is something that had been added in a newer version.
I did a new thread about it because this is a new issue:
https://akaunting.com/forum/discussion/installation-update/sqlstate42s02-base-table-or-view-not-found
yes in new version database structure is changed so if the akaunting app is successfully updated it will update the database structure as well. anyways best of luck for your troubleshooting.
Thank you! ;-)
Showing 11 to 15 of 15 discussions