search

sarapis / orservices

ORServices is an open source, smartphone-friendly directory application that enables you to collect, verify, organize and share information about social services in your community with your stakeholders, beneficiaries, partner organizations and more.
https://sarapis.org/human-services/orservices/
22 stars 16 forks source link

Crash on loading database dump #128

Closed royappa closed 7 months ago

royappa commented 7 months ago

Hello, I am testing the latest version (v5.0) with the HSDS changes, with a fresh install.

1) There was a database crash at the "php artisan db:seed", I have fixed this in my fork, here is the commit hash.

https://github.com/sarapis/orservices/commit/5e3653dfc4d13d71ea21b515767a9f7c7d6e29f1

I can submit a pull request if you like.

2) Unfortunately I can't complete the install because I get a crash when loading any of the database dump tables, e.g.:

 mysql -u ors -p ors < database/dump/09112021.sql
Enter password:
ERROR 1050 (42S01) at line 30: Table 'accessibilities' already exists

Could you please upload a new database to the database/dump that is compatible with the latest version? Thanks!

royappa commented 7 months ago

I went ahead and created a PR in case you wished to use it. Thanks.

d9it commented 7 months ago

We have updated the SQL database in the database > dump folder. Please try to import the dump again and inform us if you encounter any issues.