Changes between Version 31 and Version 32 of UserGuidelines/Admin/DataMigration/Haiti

Timestamp:

02/01/10 00:39:52 (15 years ago)

Author:

Fran Boon

Comment:

--

UserGuidelines/Admin/DataMigration/Haiti

@@ -220 +220 @@
 Ctrl+D
 }}}
+==== Migration Error recovery ====
+ * Error: "Unknown column \'gis_location.lon_min\' in \'field list\'"
+ * Cause: MySQL didn't have the field, model did & the migration log in databases\ said that the migration had happened.
+To recover: 
+{{{
+vim /etc/crontab
+#0-59/1 * * * * www-data cd /home/haiti/web2py/ && python web2py.py -C -D 1 >> /tmp/cron.output 2>&1
+
+ln -sf /etc/apache2/sites-available/test-maintain /etc/apache2/sites-enabled/test
+/etc/init.d/apache2 force-reload
+
+http://haiti-test.sahanafoundation.org/phpmyadmin/index.php?db=haititest&table=gis_location
+Export as SQL
+
+rm -f /home/haiti/test/databases/a54f35709b0d09d927454f2b745571db_gis_location.table
+
+mysql
+\r haititest
+drop TABLE gis_location;
+\q
+
+vim /home/haiti/test/models/00_db.py
+migrate=True
+ln -sf /etc/apache2/sites-available/uat /etc/apache2/sites-enabled/test
+/etc/init.d/apache2 force-reload
+
+http://haiti-test.sahanafoundation.org/test/
+
+http://haiti-test.sahanafoundation.org/phpmyadmin/index.php?db=haititest&table=gis_location
+Import SQL
+
+vim /etc/crontab
+0-59/1 * * * * www-data cd /home/haiti/web2py/ && python web2py.py -C -D 1 >> /tmp/cron.output 2>&1
+
+vim /home/haiti/test/models/00_db.py
+migrate=False
+}}}
+
 === Web Services ===
 Better to avoid locks & do without SSH login