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

New Discussion

SQL Problems and with updated installation

Fabio Dos Santos   ( User )

Commented 1 year ago


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.

Please login or register to leave a response.

Showing 1 to 1 of 1 discussions