[arch-projects] [projects] [archweb] [PATCH] Update Readme with Troubleshoot guide for SQLITE and POSTGRES

Leonidas Spyropoulos artafinde at gmail.com
Mon Oct 1 16:08:31 EDT 2012

 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
+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:

More information about the arch-projects mailing list