Ask, reply and learn. Join the community of Akaunting.
Downloaded Akaunting from GitHub and when running the installation script (php artisan install --db-name="akaunting"... etc.), the following error occurs:
SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Introducing FOREIGN KEY constraint 'original_media_id' on table 'cn6_media' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. (SQL: alter table "cn6_media" add constraint "original_media_id" foreign key ("original_media_id") references "cn6_media" ("id") on delete set null)
Any ideas as to what to alter in order to resolve this? SQL Server version is 15.0.2005.5, PHP is v7.4.20
Hello, did you have to do anything special to change it from mysql to sql server?
Showing 1 to 2 of 2 discussions