# diff tracpm.py tracpm.py.ori
96,109c96,104
<     def environment_needs_upgrade(self):
<         with self.env.db_query as db:
<             cursor = db.cursor()
<             cursor.execute('SELECT value FROM system WHERE name=%s',
<                            (db_default.name, ))
<             value = cursor.fetchone()
<             try:
<                 self.found_db_version = int(value[0])
<                 if self.found_db_version < db_default.version:
<                     self.log.info('TracPM environment out of date.')
<                     return True
<             except:
<                 self.log.info('TracPM environement missing.')
<                 self.found_db_version = 0
---
>     def environment_needs_upgrade(self, db):
>         cursor = db.cursor()
>         cursor.execute('SELECT value FROM system WHERE name=%s',
>                        (db_default.name, ))
>         value = cursor.fetchone()
>         try:
>             self.found_db_version = int(value[0])
>             if self.found_db_version < db_default.version:
>                 self.log.info('TracPM environment out of date.')
110a106,109
>         except:
>             self.log.info('TracPM environement missing.')
>             self.found_db_version = 0
>             return True
116c115
<     def upgrade_environment(self,db):
---
>     def upgrade_environment(self, db):
120c119
<         
---
> 
128,133c127,132
<             
<             # Create tables
<             for table in db_default.tables:
<                 for sql in db_manager.to_sql(table):
<                     cursor.execute(sql)
<                     
---
> 
>         # Create tables
>         for table in db_default.tables:
>             for sql in db_manager.to_sql(table):
>                 cursor.execute(sql)
> 
328c327
<            and isinstance(ticket[self.fields[field]], datetime) and len(str(ticket[self.fields[field]])) != 0:
---
>                 and len(ticket[self.fields[field]]) != 0:
340,346c339,342
<            if isinstance(dateString, datetime):
<                d = dateString
<            else:
<                d = datetime(*time.strptime(dateString,
<                                            self.dbDateFormat)[0:7])
<            d = d.replace(hour=0, minute=0, second=0, microsecond=0,
<                          tzinfo=localtz)
---
>             d = datetime(*time.strptime(dateString,
>                                         self.dbDateFormat)[0:7])
>             d = d.replace(hour=0, minute=0, second=0, microsecond=0,
>                           tzinfo=localtz)