I failed to reproduce this problem. Can anybody reproduce it?
On Dec 28, 5:33 pm, Tito Garrido <titogarr...@gmail.com> wrote:
> Via a webform... using SQLFORM
>
>
>
> On Sat, Dec 26, 2009 at 12:39 PM, mdipierro <mdipie...@cs.depaul.edu> wrote:
> > inserting via web forms or via db.table.insert(...)?
>
> > On Dec 26, 7:54 am, Tito Garrido <titogarr...@gmail.com> wrote:
> > > When I'm inserting strings using ç ã õ é á on GAE
>
> > > you can create a DB like:
> > > db.define_table('content',
> > > Field('title','string'),
> > > Field('subtitle','string'),
> > > Field('data','text'),
> > > )
>
> > > on the "data" column you will be able to add ã ç á... but on title or
> > > subtile will throw an Unicode error.
>
> > > Regards,
>
> > > Tito
>
> > > On Fri, Dec 25, 2009 at 11:19 PM, mdipierro <mdipie...@cs.depaul.edu>
> > wrote:
> > > > Can you describe the problem? Is this when inserting or when
> > > > extracting?
>
> > > > Massimo
>
> > > > On Dec 25, 4:21 pm, Tito Garrido <titogarr...@gmail.com> wrote:
> > > > > I'm getting this error for "string" fields on GAE... is that related?
> > For
> > > > > uploads and texts fields seems to be working...
>
> > > > > Regards,
>
> > > > > Tito
>
> > > > > On Wed, Dec 23, 2009 at 4:38 AM, v <vishal...@gmail.com> wrote:
> > > > > > Great! both solutions work fine now. Have tested with a few
> > binary
> > > > > > file uploads. Using your changes in the trunk to sql.py.
>
> > > > > > Thanks,
> > > > > > V
>
> > > > > > On Dec 23, 1:44 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
> > > > > > > I may have fixed it in trunk. Could you please try it?
>
> > > > > > > On Dec 22, 2:26 pm, v <vishal...@gmail.com> wrote:
>
> > > > > > > > Hi Massimo,
>
> > > > > > > > Thanks for your prompt response.
>
> > > > > > > > I tried uploading multiple binary files (image, pdf, etc.) and
> > it's
> > > > > > > > consistently the case. I'm using latest web2py (downloaded few
> > > > hours
> > > > > > > > back): 1.74.3. File name are pure ascii, so I don't see any
> > issues
> > > > > > > > there. File sizes have been from 32KB to about 300KB. Here's
> > the
> > > > > > > > trace from GAE logs. I've masked my app-id (hope you won't
> > mind).
>
> > > > > > > > ------------
> > > > > > > > 122.172.62.200 - - [22/Dec/2009:11:05:41 -0800] "GET
> > > > /mywiki/default/
> > > > > > > > documents/2007 HTTP/1.1" 500 397 - "Mozilla/5.0 (Windows; U;
> > > > Windows
> > > > > > > > NT 6.1; en-US) AppleWebKit/532.5 (KHTML, like Gecko) Chrome/
> > > > 4.0.249.30
> > > > > > > > Safari/532.5,gzip(gfe)" "XXX.appspot.com"
> > > > > > > > E 12-22 11:05AM 41.509
> > > > > > > > In FILE:
> > > > /base/data/home/apps/XXX/1.338633428120223078/applications/
> > > > > > > > mywiki/controllers/default.py
>
> > > > > > > > Traceback (most recent call last):
> > > > > > > > File "/base/data/home/apps/XXX/1.338633428120223078/gluon/
> > > > > > > > restricted.py", line 173, in restricted
> > > > > > > > exec ccode in environment
> > > > > > > > File
> > "/base/data/home/apps/XXX/1.338633428120223078/applications/
> > > > > > > > mywiki/controllers/default.py:documents", line 112, in <module>
> > > > > > > > File "/base/data/home/apps/XXX/1.338633428120223078/gluon/
> > > > > > > > globals.py", line 96, in <lambda>
> > > > > > > > self._caller = lambda f: f()
> > > > > > > > File
> > "/base/data/home/apps/XXX/1.338633428120223078/applications/
> > > > > > > > mywiki/controllers/default.py:documents", line 63, in documents
> > > > > > > > File
> > > > "/base/data/home/apps/XXX/1.338633428120223078/gluon/contrib/
> > > > > > > > gql.py", line 666, in select
> > > > > > > > return self.parse(self._db, rows, colnames, False)
> > > > > > > > File
> > > > "/base/data/home/apps/XXX/1.338633428120223078/gluon/sql.py",
> > > > > > > > line 2998, in parse
> > > > > > > > value = value.decode(db._db_codec)
> > > > > > > > File "/base/python_dist/lib/python2.5/encodings/utf_8.py",
> > line
> > > > 16,
> > > > > > > > in decode
> > > > > > > > return codecs.utf_8_decode(input, errors, True)
> > > > > > > > UnicodeDecodeError: 'utf8' codec can't decode byte 0xff in
> > position
> > > > 0:
> > > > > > > > unexpected code byte
> > > > > > > > ------------
>
> > > > > > > > Hope I'm not doing something silly. Perhaps if you get a
> > chance to
> > > > > > > > quickly test your mywiki example yourself on GAE, you should be
> > > > able
> > > > > > > > to reproduce it.
>
> > > > > > > > Thanks once again.
>
> > > > > > > > Best Regards,
> > > > > > > > V
>
> > > > > > > > On Dec 23, 1:09 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > > > > > > Thank you v.
>
> > > > > > > > > Are you sure the problem is the file content and not the file
> > > > name or
> > > > > > > > > the file size?
> > > > > > > > > Which verison of web2py do you have?
> > > > > > > > > I any case, can you post the complete traceback?
>
> > > > > > > > > Massimo
>
> > > > > > > > > On Dec 22, 2:01 pm, v <vishal...@gmail.com> wrote:
>
> > > > > > > > > > Hi Massimo,
>
> > > > > > > > > > First of all, thanks for creating web2py.. AMAZING work!!
> > > > Highly
> > > > > > > > > > intuitive and almost flat learning curve, compared with RoR
> > and
> > > > > > > > > > Django.
>
> > > > > > > > > > I was trying the mywiki example from the web2py manual and
> > > > while
> > > > > > the
> > > > > > > > > > documents upload/download worked fine locally with SQLite,
> > it
> > > > > > doesn't
> > > > > > > > > > quite work with GAE datastore, especially for non-ascii
> > > > documents
> > > > > > > > > > uploads. Works fine with ASCII file uploads.
>
> > > > > > > > > > I'm using web2py 1.74.3. Wonder if there's a generic
> > > > limitation to
> > > > > > > > > > upload binary files on GAE using web2py? here's my db.py:
>
> > > > > > > > > > ---------
> > > > > > > > > > if request.env.web2py_runtime_gae:
> > > > > > > > > > db = DAL('gae')
> > > > > > > > > > session.connect(request, response, db=db)
> > > > > > > > > > else:
> > > > > > > > > > db = DAL('sqlite://storage.sqlite')
>
> > > > > > > > > > <snip>
>
> > > > > > > > > > db.define_table('document',
> > > > > > > > > > SQLField('timestamp', 'datetime',
> > default=now),
> > > > > > > > > > SQLField('page', db.page),
> > > > > > > > > > SQLField('name'),
> > > > > > > > > > SQLField('file', 'upload',
> > > > > > > > > > uploadfield='file_storage'),
> > > > > > > > > > SQLField('file_storage', 'blob'))
> > > > > > > > > > --------
>
> > > > > > > > > > Thanks in advance.
>
> > > > > > > > > > Best Regards,
> > > > > > > > > > - V
>
> > > > > > --
>
> > > > > > You received this message because you are subscribed to the Google
> > > > Groups
> > > > > > "web2py-users" group.
> > > > > > To post to this group, send email to web...@googlegroups.com.
> > > > > > To unsubscribe from this group, send email to
> > > > > > web2py+unsubscr...@googlegroups.com<web2py%2bunsubscr...@googlegroups.com>
> > <web2py%2bunsubscr...@googlegroups.com<web2py%252bunsubscr...@googlegroups.com>
>
> > > > <web2py%2bunsubscr...@googlegroups.com<web2py%252bunsubscr...@googlegroups.com>
> > <web2py%252bunsubscr...@googlegroups.com<web2py%25252bunsubscr...@googlegroups.com>
>
> > > > > > .
> > > > > > For more options, visit this group at
> > > > > >http://groups.google.com/group/web2py?hl=en.
>
> > > > > --
>
> > > > > Linux User #387870
> > > > > .........____
> > > > > .... _/_õ|__|
> > > > > ..º[ .-.___.-._| . . . .
> > > > > .__( o)__( o).:_______
>
> > > > --
>
> > > > You received this message because you are subscribed to the Google
> > Groups
> > > > "web2py-users" group.
> > > > To post to this group, send email to web...@googlegroups.com.
> > > > To unsubscribe from this group, send email to
> > > > web2py+unsubscr...@googlegroups.com<web2py%2bunsubscr...@googlegroups.com>
> > <web2py%2bunsubscr...@googlegroups.com<web2py%252bunsubscr...@googlegroups.com>
>
> > > > .
> > > > For more options, visit this group at
> > > >http://groups.google.com/group/web2py?hl=en.
>
> > > --
>
> > > Linux User #387870
> > > .........____
> > > .... _/_õ|__|
> > > ..º[ .-.___.-._| . . . .
> > > .__( o)__( o).:_______
>
> > --
>
> > You received this message because you are subscribed to the Google Groups
> > "web2py-users" group.
> > To post to this group, send email to web...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > web2py+unsubscr...@googlegroups.com<web2py%2bunsubscr...@googlegroups.com>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/web2py?hl=en.
>
> --
>
> Linux User #387870
> .........____
> .... _/_õ|__|
> ..º[ .-.___.-._| . . . .
> .__( o)__( o).:_______
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
