V2 Dev Env Problems - Githubissues

ebert-l / avh-booking-system

Booking system based in liabilities

0 stars 0 forks source link

V2 Dev Env Problems #1

Open ebert-l opened 1 year ago

ebert-l commented 1 year ago

All Error Reports have the following Format: Folder in which the command was executed Executed Command Main Error Message

[x] #5 /client go install "main.go:16:12: pattern frontend/dist: no matching files found"
[x] #4 /server go run . "Database Login Info: :@tcp(:)/ 2023/03/10 15:54:56 dial tcp :0: connectex: Die angeforderte Adresse ist in diesem Kontext ungültig."
[ ] #3 /client npm install missing package.json
[x] #2 /client/frontend npm install gyp ERR! not ok Build failed with Error Code 1

ebert-l commented 1 year ago

After solving Error 2 by removing the os.Getenv variables and setting them to a dev database, there is a new error occuring:

[ ] Error 5: /server go run . Key colum "client" doesn't exist in table

ebert-l commented 1 year ago

After solving Error 5 by inserting the wanted column in the table. The following Error occured:

[ ] Error 6: /server go run . Cannot add or update a child row: a foreign key constraint fails (avhbs_wails.#sql-23a0_cb, CONSTRAINT #sql-23a0_cb_ibfk_1 FOREIGN KEY (client) REFERENCES clients (name))

ebert-l commented 1 year ago

Error 6 was finally resolved by adding all missing rows in the database and checking, that every Foreign Key can indeed be matched with their key pair. Some Database entrys where missing at this point.

This issue should teach us, that it is important to write very good "delete User" and "delete Client" procedures, who also delete every bokking entry mentioning the Users Data. If this behaviour is not wanted, a "deactivate/archivate user/client" would be an alterantive.