Difference between revisions of "How to install IDS"
| (One intermediate revision by one other user not shown) | |||
| Line 21: | Line 21: | ||
17. cp 20230915_111320-ids-database.sql.gz /home/foldername/ids <br> | 17. cp 20230915_111320-ids-database.sql.gz /home/foldername/ids <br> | ||
18. bench restore 20230915_111320-ids-database.sql.gz --db-root-username postgres --db-root-password root <br> | 18. bench restore 20230915_111320-ids-database.sql.gz --db-root-username postgres --db-root-password root <br> | ||
| − | + | 19. move to /apps/samb git pull origin development <br> | |
| − | + | 20. bench migrate <br> | |
when you have an error psycopg2.errors.DatatypeMismatch: column "item_length" cannot be cast automatically to type numeric | when you have an error psycopg2.errors.DatatypeMismatch: column "item_length" cannot be cast automatically to type numeric | ||
HINT: You might need to specify "USING item_length::numeric(21,9)". <br> | HINT: You might need to specify "USING item_length::numeric(21,9)". <br> | ||
| − | + | 21. connect to your postgress with dbeaver / pgadmin <br> | |
| − | + | 22. set the connection with <br> | |
Host : localhost <br> | Host : localhost <br> | ||
Database : ids <br> | Database : ids <br> | ||
| Line 34: | Line 34: | ||
Password : x!@#$ <br> | Password : x!@#$ <br> | ||
| − | + | 23. open editor <br> | |
ALTER TABLE "tabItem" DROP COLUMN item_length <br> | ALTER TABLE "tabItem" DROP COLUMN item_length <br> | ||
ALTER TABLE "tabItem" DROP COLUMN item_width <br> | ALTER TABLE "tabItem" DROP COLUMN item_width <br> | ||
ALTER TABLE "tabItem" DROP COLUMN item_height <br> | ALTER TABLE "tabItem" DROP COLUMN item_height <br> | ||
| + | 24. load your http://localhost:8001/app <br> | ||
| + | 25. Finish setup <br> | ||
Latest revision as of 03:37, 8 May 2024
0. Setup Frappe (https://frappeframework.com/docs/user/en/installation)
1. bench init ids --frappe-branch version-13
2. cd ids
3. bench new-site ids --db-name ids --db-type postgres
4. bench use ids
5. bench start
6. bench get-app [email protected]:SAMBPLG/ids.git
7. rm -rf apps/samb/*
8. cd apps/samb
9. rm -rf .git
10. rm -rf .github
11. rm .gitignore
12. git clone [email protected]:SAMBPLG/ids.git .
13. bench get-app [email protected]:SAMBPLG/sambcoro.git
14. bench install-app samb
15. bench migrate
16. Download db postgress
DB Restore:
https://sambid-my.sharepoint.com/:u:/g/personal/zulfafalah_samb_co_id/EShSgjMH1zdBmPgEF0z6aPwBiTIw8-19Q564e3vCY4zJnA?e=1tXjmj
17. cp 20230915_111320-ids-database.sql.gz /home/foldername/ids
18. bench restore 20230915_111320-ids-database.sql.gz --db-root-username postgres --db-root-password root
19. move to /apps/samb git pull origin development
20. bench migrate
when you have an error psycopg2.errors.DatatypeMismatch: column "item_length" cannot be cast automatically to type numeric
HINT: You might need to specify "USING item_length::numeric(21,9)".
21. connect to your postgress with dbeaver / pgadmin
22. set the connection with
Host : localhost
Database : ids
Port : 5432
User Name : postgres
Password : x!@#$
23. open editor
ALTER TABLE "tabItem" DROP COLUMN item_length
ALTER TABLE "tabItem" DROP COLUMN item_width
ALTER TABLE "tabItem" DROP COLUMN item_height
24. load your http://localhost:8001/app
25. Finish setup