Now there's some useful info. Here's the tarceback: Traceback (most recent call last): File "C:\src\ide\wizards\AppWizard\AppWizard.py", line 313, in onLeavePage tables = cursor.getTables() File "C:\src\dabo\db\dCursorMixin.py", line 2379, in getTables return self.BackendObject.getTables(self.AuxCursor, includeSystemTables) File "C:\src\dabo\db\dbMsSQL.py", line 108, in getTables cursor.execute(sql % {'db':dbName}) File "C:\src\dabo\db\dCursorMixin.py", line 406, in execute _records = self.fetchall() File "C:\src\dabo\db\dbMsSQL.py", line 61, in fetchall return tuple([{col: row[col]} for col in row if type(col) != int UnboundLocalError: local variable 'row' referenced before assignment
Thanks Carey On Wed, Dec 5, 2012 at 7:01 PM, Paul McNett <p...@ulmcnett.com> wrote: > Unfortunately Dabo ate the original exception so it's impossible to know > what the > callstack is making it hard to pinpoint. Do this: > > 1) edit dabo/dabo/db/dCursorMixin.py > 2) search for "error fetching records", there should be 1 occurence at > about line 414. > 3) go up to about line 407 (the 'except Exception, e:' line) > 4) right after that line, indent 3 tabs and type "raise" without the quotes > 5) save > 6) now run your script and you should see a full stacktrace now. Post that. > > Thanks > Paul > > > On 12/5/12 4:17 PM, Carey Gagnon wrote: > > Bump > > Anyone? This doesn't seem to be a pymssql problem as it works fine on > it's > > own. Once Dabo is involved I get the error: > > Error fetching records: (<type 'exceptions.UnboundLocalError'>, local > > variable 'row' referenced before assignment) > > > > There are several references to the variable row (row = blahblah..) in > > dCursorMixin.py, 14 to be exact, but I don't know enough about python to > do > > much about it. > > > > Can anyone help please? > > > > Thanks > > Carey > > > > On Mon, Dec 3, 2012 at 7:20 PM, Carey Gagnon <careydeangag...@gmail.com > >wrote: > > > >> That was pretty much the full traceback Ed, but here's the entire > >> enchilada: > >> > >> C:\src\ide\wizards\AppWizard>AppWizard.py > >> C:\src\dabo\lib\SimpleCrypt.py:52: UserWarning: WARNING: SimpleCrypt is > >> not secu > >> re. Please see http://wiki.dabodev.com/SimpleCrypt for more information > >> warnings.warn("WARNING: SimpleCrypt is not secure. Please see > >> http://wiki.dabo > >> dev.com/SimpleCrypt for more information") > >> 2012-12-03 19:14:37 - ERROR - Error fetching records: (<type > >> 'exceptions.UnboundLocalError'>, local variable 'row' referenced before > >> assignment) > >> > >> Thanks > >> Carey > >> > >> > >> > >> On Mon, Dec 3, 2012 at 7:04 PM, Ed Leafe <ed.le...@rackspace.com> > wrote: > >> > >>> On Dec 3, 2012, at 6:35 PM, Carey Gagnon <careydeangag...@gmail.com> > >>> wrote: > >>> > >>>>> Then I run the appwizard (all installed Dabo components at revision > >>> 7288). > >>>>> It connects to the database but doesn't show tables or anything > >>> throwing > >>>>> the following error: > >>>>> Error fetching records: (<type 'exceptions.UnboundLocalError'>, local > >>>>> variable 'row' referenced before assignment) > >>>>> > >>>>> Is this a Dabo error or a pymssql error? > >>> > >>> Could you post the full traceback? That will show where the > error > >>> originated. > >>> > >>> > >>> -- Ed Leafe > >>> > >>> > >>> > >>> _______________________________________________ > >>> Post Messages to: Dabo-users@leafe.com > >>> Subscription Maintenance: > >>> http://mail.leafe.com/mailman/listinfo/dabo-users > >>> Searchable Archives: http://leafe.com/archives/search/dabo-users > >>> This message: > >>> > http://leafe.com/archives/byMID/c2aa8310-517d-4c67-8435-572d475a4...@rackspace.com > >>> > >> > >> > > > > > > --- StripMime Report -- processed MIME parts --- > > multipart/alternative > > text/plain (text body -- kept) > > text/html > > --- > > _______________________________________________ > > Post Messages to: Dabo-users@leafe.com > > Subscription Maintenance: > http://mail.leafe.com/mailman/listinfo/dabo-users > > Searchable Archives: http://leafe.com/archives/search/dabo-users > > This message: > http://leafe.com/archives/byMID/camgtpfebvejkhksnmwksuazmsoov+j+emkbeux21fjownth...@mail.gmail.com > > > > _______________________________________________ > Post Messages to: Dabo-users@leafe.com > Subscription Maintenance: > http://mail.leafe.com/mailman/listinfo/dabo-users > Searchable Archives: http://leafe.com/archives/search/dabo-users > This message: http://leafe.com/archives/byMID/50bfee4e.30...@ulmcnett.com > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/CAMGTPFE6jdhWogn3A46BzQFzUTN-Ki9=4nc8rv1hwdqmqxu...@mail.gmail.com