I had a similar issue some time ago, but Windows was my testing machine,
not the production server OS. So it was not very annoying...
If you want to host on Windows, you may have to store the original filename
in the database, and change it on the disk :
http://web2py.com/books/default/chapter/29/07?search=uploads#Storing-the-original-filename
Le jeudi 14 novembre 2013 11:03:05 UTC+1, Rahul a écrit :
>
> Okay -
> So in my case the file name actually passed to DB is as highlighted below
> - this is 229 characters long (still smaller than 260 limit). Can the
> upload field handle such long file names ? Do you think that could be the
> problem? How do we specify file name character limit in db.py when defining
> files I know we can specify the size but how names of files ? Any idea?
>
> in db.py I have -
> Field('attach_file','upload'))
>
> I am not using blob to store files- instead files are stored on server at
> a specified path.
>
>
> issues.attach_file.8ddd3149b14cb8e9.4d6f6e6579204d617474657273206578706f7365205072696d6172792041647669736f722066726f6d20436f6e7461637420746f20496e76204163636f756e74207669657720616e642064796e616d6963207265706f7274732e70707478.pptx
> Regards, Rahul
>
> On Thursday, November 14, 2013 2:11:13 PM UTC+5:30, Niphlod wrote:
>>
>>
>>
>> On Thursday, November 14, 2013 6:21:26 AM UTC+1, Rahul wrote:
>>>
>>> Hi Ricardo,
>>> Thanks for the response, but I don't understand why it should
>>> be a windows limit. I have many files with much larger names in windows,
>>> never had such a problem. Besides this only occurs when we are uploading it
>>> in web2py. Could SQLite database be a constraint ? I am using sqlite for
>>> this app. What might cause this, for now I have reduced the file name and
>>> it gets uploaded just fine.
>>>
>>> Sincerely, Rahul D.
>>>
>>>>
>>>>
>> There's no way you can have a path with more than 260 characters in
>> windows. Any database has no issues on handling long paths, only the
>> underlying filesystem. If you choose to store files in your uploads folder,
>> and you are on windows, you need to limit the length of the filenames users
>> try to upload. Alternatively, you can store files in the database in a blob
>> field.
>>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
