Appion

Bug #4275

Updated by Neil Voss over 8 years ago

<pre> 
   File "/tank/software/myami-3.2/appion/bin/makestack2.py", line 1142, in postLoopFunctions 
     apStackMeanPlot.makeStackMeanPlot(stackid) 
   File "/tank/software/myami-3.2/appion/appionlib/apStackMeanPlot.py", line 53, in makeStackMeanPlot 
     partdatas = sinedon.directq.complexMysqlQuery('appiondata',sqlcmd) 
   File "/tank/software/myami-3.2/sinedon/directq.py", line 24, in complexMysqlQuery 
     results = cur.selectall(query) 
   File "/tank/software/myami-3.2/sinedon/sqldb.py", line 44, in selectall 
     self.c.execute(strSQL, param) 
   File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute 
     self.errorhandler(self, exc, value) 
   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler 
     raise errorclass, errorvalue 
 _mysql_exceptions.ProgrammingError: (1146, "Table 'leginondb.ApStackParticleData' doesn't exist") 
 </pre> 

 Note it says <b>'leginondb.ApStackParticleData'</b> 

 I checked the code and had it print the info: 

 <pre> 
 sqlcmd = "SELECT " + \ 
  "particleNumber, mean, stdev " + \ 
  "FROM ApStackParticleData " + \ 
  "WHERE `REF|ApStackData|stack` = %i"%(stackid) 
 print sinedon.getConfig('appiondata', sinedon.setConfig('appiondata', db=newdbname) 
 partdatas = sinedon.directq.complexMysqlQuery(newdbname, sqlcmd) 
 </pre> 

 <pre> 
 {'passwd': 'xxxx', 'host': '127.0.0.1', 'db': 'ap9', 'user': 'usr_object'} 
 connecting 
 </pre> 

 any ideas? this is the northwestern install using myami 3.2 under debian 8.

Back