Difference between revisions of "How to install IDS"
| Line 28: | Line 28: | ||
20. connect to your postgress with dbeaver / pgadmin <br> | 20. connect to your postgress with dbeaver / pgadmin <br> | ||
21. set the connection with <br> | 21. set the connection with <br> | ||
| − | Host : localhost | + | Host : localhost <br> |
| − | Database : ids | + | Database : ids <br> |
| − | Port : 5432 | + | Port : 5432 <br> |
| − | User Name : postgres | + | User Name : postgres <br> |
| − | Password : x!@#$ | + | Password : x!@#$ <br> |
22. open editor <br> | 22. open editor <br> | ||
| − | ALTER TABLE "tabItem" DROP COLUMN item_length | + | ALTER TABLE "tabItem" DROP COLUMN item_length <br> |
| − | ALTER TABLE "tabItem" DROP COLUMN item_width | + | ALTER TABLE "tabItem" DROP COLUMN item_width <br> |
| − | ALTER TABLE "tabItem" DROP COLUMN item_height | + | ALTER TABLE "tabItem" DROP COLUMN item_height <br> |
Revision as of 03:29, 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
18. move to /apps/samb git pull origin development
19. 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)".
20. connect to your postgress with dbeaver / pgadmin
21. set the connection with
Host : localhost
Database : ids
Port : 5432
User Name : postgres
Password : x!@#$
22. open editor
ALTER TABLE "tabItem" DROP COLUMN item_length
ALTER TABLE "tabItem" DROP COLUMN item_width
ALTER TABLE "tabItem" DROP COLUMN item_height