Ask, reply and learn. Join the community of Akaunting.
I am trying to update my Akaunting instance to 3.0.6 on the server for our non-profit. After a failed update, I can no longer access de database or the software.
I found out I can run commands through Artisan. With "php artisan migrate:status" I figured out that the generic error I got was during the database migration process.
After triyng to rollback to the previous version (with php artisan migrate:rollback) -- I'm trying to downgrade, so I can get the information out, i now get this very weird error regarding the SQl.
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'rs5_accounts' already exists (SQL: create table `rs5_accounts` (`id` int unsign
ed not null auto_increment primary key, `company_id` int not null, `name` varchar(191) not null, `number` varchar(191) not null, `currency_code
` varchar(191) not null, `opening_balance` double(15, 4) not null default '0.0000', `bank_name` varchar(191) null, `bank_phone` varchar(191) nu
ll, `bank_address` text null, `enabled` tinyint(1) not null default '1', `created_at` timestamp null, `updated_at` timestamp null, `deleted_at`
timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB ROW_FORMAT=DYNAMIC)
I need help. There is two years of important information on this database. At this point, I don't knwo to what version this database is related, or if 3.0 is compatible with 2.1.33 (from which it was updated). I don't know why I had an error on the update. (It didn't tell me!)
Please let know how I can salvage the information put in the database, or maybe even this installation.
Showing 1 to 1 of 1 discussions