Forum

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

New Discussion

SQLSTATE[42S02]: Base table or view not found

Power Quest   ( User )

Commented 4 years ago

After updating this exception happens:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbname_ybiyi02.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)
The tables are suddenly gone it seems?

I understand the tables need to be recreated manually in phpMyAdmin etc, but to do that you need to know what data they should contain....

Power Quest   ( User )

Commented 4 years ago

I done a rollback of the system to the old version so it works now, but after I done that I checked the database and the tables that is mentioned in the exception above does not exist at all. Not sure how I can update the system if those tables are not added during the update process...

I also tried to find out the version number of the system we are running but I cannot seem to find anyplace in the system where you can see that.
Please advise.
Thank you.

Denis Dulici   ( Admin )

Commented 4 years ago

Hello Power,

The error message says that the update has failed. You should check the logs under storage/logs directory.

Regards

Power Quest   ( User )

Commented 4 years ago

Right, thanks Denis.
I have to perform the upgrade again to be able to do that because all that is of course gone due to the roll back.

Please login or register to leave a response.

Showing 1 to 4 of 4 discussions