Changes between Version 18 and Version 19 of UserGuidelines/Admin/DataMigration/Haiti

Timestamp:

01/20/10 21:55:09 (16 years ago)

Author:

Fran Boon

Comment:

--

UserGuidelines/Admin/DataMigration/Haiti

@@ -117 +117 @@
 ./maintenance.off
 }}}
+==== Dealing with database corruption ====
+We had problems with the or_organisation table - queries wouldn't complete.
+
+The tracebacks included: {{{ValueError: invalid literal for int() with base 10: '01/14/10 1'}}}
+To fix this we needed to:
+ * Delete column from model
+{{{
+vim /home/haiti/prod/models/05_or.py
+
+resource = 'organisation'
+table = module + '_' + resource
+db.define_table(table, timestamp, deletion_status,
+  # uuidstamp
+}}}
+ * Export as CSV
+{{{
+cd /home/haiti/web2py
+python web2py.py -S prod -M -N
+db.or_organisation.export_to_csv_file(open('prod_orgs.csv','wb'))
+Ctrl+D
+}}}
+ * Drop table
+{{{
+cd /home/haiti/web2py
+python web2py.py -S prod -M -N
+db.or_organisation.drop()
+db.commit()
+Ctrl+D
+}}}
+ * Rebuild Table
+  * Ensuring that table is owned by www-data
+   * http://haiti.sahanafoundation.org
+ * Reimport from CSV
+{{{
+cd /home/haiti/web2py
+python web2py.py -S prod -M -N
+db.or_organisation.import_from_csv_file(open('prod_orgs.csv','rb'))
+db.commit()
+Ctrl+D
+}}}
 === Web Services ===
 Better to avoid locks & do without SSH login