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

Timestamp:

01/20/10 22:04:09 (15 years ago)

Author:

Fran Boon

Comment:

--

UserGuidelines/Admin/DataMigration/Haiti

@@ -118 +118 @@
 }}}
 ==== Dealing with database corruption ====
-We had problems with the or_organisation table - queries wouldn't complete.
+ 1. 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'}}}
+
+By commenting out each field in turn in the model, discovered that this was the timestamp column which included this data.
+
+(Note the file was also {{{chown root:root}}}!)
+
 To fix this we needed to:
  * Delete column from model
@@ -157 +162 @@
 Ctrl+D
 }}}
+
+ 2. rms_sms_request table couldn't be recreated
+
+Since this part of the system is under active development, it was necessary to drop the table as part of the [wiki:ReleaseManagement release process].
+ * Although normally we can re-populate the tables from their source feeds simply using:
+{{{
+cd /home/haiti/web2py
+python web2py.py -S prod -M -N
+feature_class_id = db(db.gis_feature_class.name == 'SMS').select().first().id
+db(db.gis_location.feature_class_id == feature_class_id).delete()
+db.rms_tweet_request.truncate()
+db.rms_sms_request.truncate()
+db.commit()
+Ctrl+D
+}}}
+
+However this didn't complete fully as there was still an associated view file in {{{databases/}}} & hence when model tries to create:
+ * {{{SyntaxError: invalid table name: rms_sms_request}}}
+
+To resolve this
 === Web Services ===
 Better to avoid locks & do without SSH login