thanks Massimo for this tip... 

I used the blob field to store AES encrypted Credit Card, and everything 
worked fine to store it but when I was reading records from the table I was 
getting this error: 
File 
"/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/base64.py",
 
line 76, in b64decode
TypeError: Incorrect padding

Once I changed the field from blob to text the problem went away... 


On Wednesday, September 21, 2011 1:21:38 PM UTC-4, Massimo Di Pierro wrote:
>
> I suspect you store something into a text field than changed the type 
> to blob. web2py expects blob data to be store b64encoded. If it was 
> stored when the field was a text, it was not encoded. 
>
> On Sep 21, 11:12 am, Guy Nesher <[email protected]> wrote: 
> > sqlite, is that an issue ? 
> > 
> > On Sep 21, 4:55 pm, Massimo Di Pierro <[email protected]> 
> > wrote: 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > > which db server? 
> > 
> > > On Sep 21, 7:19 am, Guy Nesher <[email protected]> wrote: 
> > 
> > > > Just tried to do a fresh install of GrooverWiki, the install works 
> > > > fine but when I try to run it I get the following error : 
> > 
> > > > Traceback (most recent call last): 
> > > >   File "/var/web2py/gluon/restricted.py", line 192, in restricted 
> > > >     exec ccode in environment 
> > > >   File "/var/web2py/applications/wiki/controllers/default.py", line 
> > > > 148, in <module> 
> > > >   File "/var/web2py/gluon/globals.py", line 145, in <lambda> 
> > > >     self._caller = lambda f: f() 
> > > >   File "/var/web2py/applications/wiki/controllers/default.py", line 
> > > > 11, in show_page 
> > > >     curr_page=db().select(db.WikiPage.ALL)[0] 
> > > >   File "/var/web2py/gluon/dal.py", line 5481, in select 
> > > >     return self.db._adapter.select(self.query,fields,attributes) 
> > > >   File "/var/web2py/gluon/dal.py", line 1192, in select 
> > > >     return self.parse(rows,self._colnames) 
> > > >   File "/var/web2py/gluon/dal.py", line 1421, in parse 
> > > >     colset[fieldname] = base64.b64decode(str(value)) 
> > > >   File "/usr/lib/python2.6/base64.py", line 76, in b64decode 
> > > >     raise TypeError(msg) 
> > > > TypeError: Incorrect padding 
> > 
> > > > I'm sure its something really silly, but I just can't figure what.

Reply via email to