Changes between Version 2 and Version 3 of Pakistan

Timestamp:

08/11/10 23:21:33 (15 years ago)

Author:

Fran Boon

Comment:

--

Pakistan

@@ -5 +5 @@
  * http://pakistan.sahanafoundation.org
 
-A new SitRep module has been built to manage:
+A new !SitRep module has been built to manage:
  * Flood Reports
- * Assessments
-
+ * Assessments from WFP
+ * School Reports
+ 
 These can be uploaded as files, but we really want volunteers using a Mechanical Turk process to input the data into the structured fields.
 
@@ -14 +15 @@
 
 Would be good to write a custom PDF writer for this format of report so we can consider getting people to enter data into DB directly.
+
+Bugs:
+ * Setting a Parent to a GIS Location causes an error on MySQL/Python25 (sqlite on Python26 fine)
+{{{
+Traceback (most recent call last):
+  File "gluon/restricted.py", line 186, in restricted
+    exec ccode in environment
+  File "/home/web2py/applications/eden/controllers/gis.py", line 1672, in <module>
+  File "gluon/globals.py", line 96, in <lambda>
+    self._caller = lambda f: f()
+  File "/home/web2py/applications/eden/controllers/gis.py", line 491, in location
+    output = shn_rest_controller(module, resource)
+  File "/home/web2py/applications/eden/models/01_crud.py", line 1891, in shn_rest_controller
+    res, req = s3xrc.parse_request(module, resource, session, request, response)
+  File "applications/eden/modules/s3xrc.py", line 2798, in parse_request
+    debug=self.debug)
+  File "applications/eden/modules/s3xrc.py", line 2780, in request
+    debug=self.debug)
+  File "applications/eden/modules/s3xrc.py", line 1755, in __init__
+    self.resource.load()
+  File "applications/eden/modules/s3xrc.py", line 600, in load
+    self.__set = self.__db(self.__query).select(self.table.ALL, limitby=limitby)
+  File "gluon/sql.py", line 3214, in select
+    rows = response(query)
+  File "gluon/sql.py", line 3209, in response
+    db._execute(query)
+  File "gluon/sql.py", line 978, in <lambda>
+    self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
+  File "/var/lib/python-support/python2.5/MySQLdb/cursors.py", line 166, in execute
+    self.errorhandler(self, exc, value)
+  File "/var/lib/python-support/python2.5/MySQLdb/connections.py", line 35, in defaulterrorhandler
+    raise errorclass, errorvalue
+ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near
+}}}