Forum

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

New Discussion

error installing the database

Alfredo Maiuri   ( User )

Commented 4 years ago

I download akaunting 1.3.17 on windows 10 64 bits, Map Server 4.0.0 for windows, Apache 2.4.38, php 7.2.16, MySQL 8

Installing the database gives the following error:

(3/3) QueryException
SQLSTATE[HY000]: General error: 1826 Duplicate foreign key constraint name 'user_roles_role_id_foreign' (SQL: alter table `nwt_user_roles` add constraint `user_roles_role_id_foreign` foreign key (`role_id`) references `nwt_roles` (`id`) on delete cascade on update cascade)

the database is empty

can you help me

Nassim Nasibullah   ( User )

Commented 4 years ago

For windows 10 download laragon 3.1 9 windows 64 bit Server, not the latest version of Laragon 4.0.15.
php 7.1.14 is working on Akaunting_1.3.17-Stable.zip
you no need to modify anything
but if you're using git clone https://github.com/akaunting/akaunting.git method then you need to modify the composer.json file "jenssegers/date": "3.3.*", to "jenssegers/date": "v3.5.0", and also add the "nesbot/carbon": "1.37.1", to your composer.json

Please login or register to leave a response.

Showing 1 to 2 of 2 discussions