[arch-projects] [projects] [archweb] [PATCH] Update Readme with Troubleshoot guide for SQLITE and POSTGRES
--- README | 15 +++++++++++++++ 1 file changed, 15 insertions(+) diff --git a/README b/README index 707ab7c..6ed574c 100644 --- a/README +++ b/README @@ -77,4 +77,19 @@ needed. Ask someone who knows, or you are going to be in trouble. +# Installation Troubleshooting + +- SQLITE index problem +If you get an error on ./manage.py migrate with: + django.db.utils.DatabaseError: no such index: packages_cab2cbcf +you need to open a database shell (./manage.py dbshell) and execute the recommended command from the stacktrace, in this case: + CREATE INDEX "packages_cab2cbcf" ON "packages" ("pkgname"); +Rerun migrate and continue as normal + +- POSTGRES +While testing with Postgres I came accross another issue for missing index: +Again solution is to open dbshell and execute the command: + CREATE INDEX "packages_pkgname" ON "packages" ("pkgname"); +Rerun migrate and continue as normal + vim: set syntax=markdown et: -- 1.7.12.2
participants (1)
-
Leonidas Spyropoulos