Forum

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

New Discussion

SQL Server error in on-premise installation

Thegoat   ( User )

Commented 2 years ago

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

Jeremy Miedreich   ( User )

Commented 1 month ago

Hello, did you have to do anything special to change it from mysql to sql server?

Please login or register to leave a response.

Showing 1 to 2 of 2 discussions