[web2py] UnicodeEncodeError
web2py Web Framework Created by Massimo Di Pierro, Copyright 2007-2020 Version 2.20.4-stable+timestamp.2020.05.03.05.18.50 Database drivers available: sqlite3, psycopg2, imaplib, pymysql please visit: http://127.0.0.1:8000/ use "kill -SIGTERM 7474" to shutdown the web2py server ERROR:Rocket.Errors.Thread-4:Traceback (most recent call last): File "/home/aab/web2py/gluon/rocket.py", line 1292, in run self.run_app(conn) File "/home/aab/web2py/gluon/rocket.py", line 1806, in run_app self.write(data, sections) File "/home/aab/web2py/gluon/rocket.py", line 1726, in write self.conn.sendall(b'%x\r\n%s\r\n' % (len(data), to_bytes(data, 'ISO-8859-1'))) File "/home/aab/web2py/gluon/packages/dal/pydal/_compat.py", line 141, in to_bytes return obj.encode(charset, errors) UnicodeEncodeError: 'latin-1' codec can't encode character '\u0430' in position 0: ordinal not in range(256) -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/c0e598c3-2b0a-4a29-a3af-cc9c2df1dd88o%40googlegroups.com.
[web2py] Error importing Russian characters from csv file
When importing data (russian characters) from a .csv-file into a table, an
error occurs:
'ascii' codec can't decode byte 0xd0 in
position 65: ordinal not in range(128).
Standalone PyDAL works fine!
=
import locale
print('locale.getpreferredencoding(False) =',
locale.getpreferredencoding(False))
db.import_from_csv_file(
open('applications/upoweron/databases/csv/all.csv'),
restore=True,
encoding="utf-8",
)
db.commit()
=
Result:
locale.getpreferredencoding(False) = ANSI_X3.4-1968
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/f7b13070-34b6-49f7-aa2c-1cedca02de86%40googlegroups.com.
[web2py] APScheduler ValueError
At the start of the function XXX() from the library uLib.py using APScheduler ValueError exception occurs. What to do? OS - Ubuntu 12.04 64 bits Web2py version - 2.9.8 APScheduler version = 3.0.0 controller - opros.py ~ import uLib as l from apscheduler.schedulers.background import BackgroundScheduler from apscheduler.triggers.date import DateTrigger sched = BackgroundScheduler() sched.start() sched.add_job( l.XXX, trigger=DateTrigger(), args=[db, session] ) user library - uLib.py ~~ def XXX(db, ss): print db print db.tables print db(db.bus.id==ss.iBusId).select(db.bus.snaim).first().snaim #enddef Log file 2014-09-09 09:19:30,615 - apscheduler.scheduler - INFO - start(132) - Scheduler started 2014-09-09 09:19:30,624 - apscheduler.scheduler - INFO - _real_add_job(743) - Added job XXX to job store default 2014-09-09 09:19:30,640 - apscheduler.scheduler - INFO - remove_job(513) - Removed job 91d564aae40c4848a8e87d836f6d1eea 2014-09-09 09:19:30,647 - apscheduler.executors.default - INFO - run_job(106) - Running job XXX (trigger: date[2014-09-09 09:19:30 MSK], next run at: 2014-09-09 09:19:30 MSK) (scheduled at 2014-09-09 09:19:30.614321+04:00) DAL uri=sqlite://upoweron.sqlite ['obj', 'bus', 'krp', 'pdr', 'lgh', 'sht', 'cdz', 'cdp', 'par', 'trf', 'osht', 'opas', 'opke', 'ojrn', 'ompf', 'oenr', 'opwr', 'opw1', 'opw2', 'owri', 'orqs', 'orpt', 'oini', 'auth_user', 'auth_group', 'auth_membership', 'auth_permission', 'auth_event', 'auth_cas'] 2014-09-09 09:19:30,701 - apscheduler.executors.default - ERROR - _LogErrorReplacement(1426) - Job XXX (trigger: date[2014-09-09 09:19:30 MSK], next run at: 2014-09-09 09:19:30 MSK) raised an exception Traceback (most recent call last): File /usr/local/lib/python2.7/dist-packages/apscheduler/executors/base.py, line 108, in run_job retval = job.func(*job.args, **job.kwargs) File applications/upoweron/modules/uLib.py, line 11858, in XXX sNaim = db(db.bus.id==ss.iBusId).select(db.bus.snaim).first().snaim File /home/aab/MyPython/web2py/gluon/dal.py, line 10724, in select return adapter.select(self.query, fields, attributes) File /home/aab/MyPython/web2py/gluon/dal.py, line 2464, in select return super(SQLiteAdapter, self).select(query, fields, attributes) File /home/aab/MyPython/web2py/gluon/dal.py, line 1874, in select return self._select_aux(sql, fields, attributes) File /home/aab/MyPython/web2py/gluon/dal.py, line 1839, in _select_aux self.execute(sql) File /home/aab/MyPython/web2py/gluon/dal.py, line 1960, in execute return self.log_execute(*a, **b) File /home/aab/MyPython/web2py/gluon/dal.py, line 1945, in log_execute if not self.connection: raise ValueError(a[0]) ValueError: SELECT bus.snaim FROM bus WHERE (bus.id = 7); -- 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/d/optout.
[web2py] How to run the sheduler on AppFog?
-- --- 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.
[web2py] Re: TypeError: __call__() takes exactly 3 arguments (4 given)
It works! Thanks... понедельник, 14 января 2013 г., 21:43:26 UTC+4 пользователь Massimo Di Pierro написал: Very odd. Can you try replace thread.start_new_thread(start_browser, (get_url(ip, proto=proto, port=port),), dict(startup=True)) with thread.start_new_thread(start_browser, (get_url(ip, proto=proto, port=port), True)) On Sunday, 13 January 2013 23:44:45 UTC-6, aabelyakov wrote: ubuntu v.11.04 (Natty), v.12.04 (Precise), windows 8 web2py v.2.3.2 (2012-12-17 15:03:30) stable When you run web2py.py without parameter -a recycle Exception in Tkinter callback Traceback (most recent call last): File /usr/lib/python2.7/lib-tk/Tkinter.py, line 1413, in __call__ return self.func(*args) File /home/aabelyakov/MyPython/web2py/gluon/widget.py, line 514, in start dict(startup=True)) TypeError: __call__() takes exactly 3 arguments (4 given) --
[web2py] TypeError: __call__() takes exactly 3 arguments (4 given)
ubuntu v.11.04 (Natty), v.12.04 (Precise), windows 8 web2py v.2.3.2 (2012-12-17 15:03:30) stable When you run web2py.py without parameter -a recycle Exception in Tkinter callback Traceback (most recent call last): File /usr/lib/python2.7/lib-tk/Tkinter.py, line 1413, in __call__ return self.func(*args) File /home/aabelyakov/MyPython/web2py/gluon/widget.py, line 514, in start dict(startup=True)) TypeError: __call__() takes exactly 3 arguments (4 given) --
[web2py] Re: TypeError: can't pickle file objects
GLib.py put in the directory modules. Import it from the model file scheduler.py. Run it in the background with the parameters db and session. it works! Thank you! The question is closed... вторник, 28 августа 2012 г., 20:17:40 UTC+4 пользователь Massimo Di Pierro написал: The definitively goes in modules. On Monday, 27 August 2012 23:50:27 UTC-5, aabelyakov wrote: gLib.py - this is a common library of functions and procedures. It uses global variables attached to the session. понедельник, 27 августа 2012 г., 23:00:37 UTC+4 пользователь Massimo Di Pierro написал: gLib.py is probably a module, not a model. I would put it there. Why it fails I cannot say, I do not know what it does. --
[web2py] TypeError: can't pickle file objects
After placing gLib.py module into directory models web2py (versions 2.0 and 1.99.7 on Windows and Ubuntu) fails: Traceback (most recent call last): File /home/aabelyakov/MyPython/web2py/gluon/main.py, line 528, in wsgibase session._try_store_on_disk(request, response) File /home/aabelyakov/MyPython/web2py/gluon/globals.py, line 594, in _try_store_on_disk cPickle.dump(dict(self), response.session_file) File /usr/lib/python2.7/copy_reg.py, line 70, in _reduce_ex raise TypeError, can't pickle %s objects % base.__name__ TypeError: can't pickle file objects In what could be the reason? --
[web2py] Re: TypeError: can't pickle file objects
gLib.py - this is a common library of functions and procedures. It uses global variables attached to the session. понедельник, 27 августа 2012 г., 23:00:37 UTC+4 пользователь Massimo Di Pierro написал: gLib.py is probably a module, not a model. I would put it there. Why it fails I cannot say, I do not know what it does. --
[web2py] KeyError: 'routes_logging'
OS - Ubuntu 10.04 LTS - Lucid Lynx
web2py - Version 1.82.1 (2010-08-04 18:57:33)
pull from https://web2py.googlecode.com/hg/
KeyError: 'routes_logging'
File /home/aabelyakov/Web2py/web2py.py, line 17, in module
import gluon.widget
File /home/aabelyakov/Web2py/gluon/widget.py, line 28, in module
import main
File /home/aabelyakov/Web2py/gluon/main.py, line 66, in module
rewrite.load()
File /home/aabelyakov/Web2py/gluon/rewrite.py, line 129, in load
if p['routes_logging']:
routes.py
=
routes_in = (('/', '/PowerOn/default/index'))
routes_out = (('/PowerOn/default/index', '/'))
After replacing the contents of the line 129
error has disappeared
=
#if p['routes_logging']:
if p.get('routes_logging'):
[web2py] Re: How to return the resources?
Yes, this is the right decision! Topic closed. Thanks On 16 апр, 17:30, mdipierro mdipie...@cs.depaul.edu wrote: I think there is a problem with multithreading because of PySerial. Pyserial open a post connected to COM and COM is a resource that cannot be shared. In web2py every request is executed in its own thread so it is not obvious who open the COM, who closes it and how conflicts are avoided. Please tell us more of what you are doing. The best solution may be not to use pyserial in a web2py problem but use it in a single bachground process that talks to web2py via queued messages. Massimo On Apr 16, 2:13 am, aabelyakov aabelya...@gmail.com wrote: I do not use os.chdir or explicit calls to thread module. I'm using PySerial and after the error COM port remains open. To close it, I restart the web server. How to avoid this? On 15 ÁÐÒ, 22:46, mdipierro mdipie...@cs.depaul.edu wrote: Do you use os.chdir or explicit calls to the thread module in your code? On Apr 15, 12:15špm, aabelyakov aabelya...@gmail.com wrote: During my application error occurs and it stops giving error ticket. How can I in my application to return the resources of the operating system (eg close the COM port) šbefore the error ticket not to restart the web server? Excuse my bad English... Regards- óËÒÙÔØ ÃÉÔÉÒÕÅÍÙÊ ÔÅËÓÔ - - ðÏËÁÚÁÔØ ÃÉÔÉÒÕÅÍÙÊ ÔÅËÓÔ - -- Subscription settings:http://groups.google.com/group/web2py/subscribe?hl=en- Скрыть цитируемый текст - - Показать цитируемый текст -
[web2py] Re: NameError: global name 'formstyle' is not defined
I re-downloaded a working copy of trunk from https://web2py.googlecode.com/hg/. Error disappeared. Topic closed. Thanks On 16 апр, 17:25, mdipierro mdipie...@cs.depaul.edu wrote: where did you get web2py from? On Apr 16, 2:01 am, aabelyakov aabelya...@gmail.com wrote: On 16 апр, 10:21, mdipierro mdipie...@cs.depaul.edu wrote: In the version in trunk that line is 768 and not 977 and it is defined. It is an argument of the function. Your file appear longer than it should be and that is very odd. Please try download it again. I added into sqlhtml.py 2 missing strings: formstyle = 'table3cols', self.formstyle = formstyle but got the following error: File D:\MyProg\_MyPython\Web2py\gluon\sqlhtml.py, line 803, in __init__ for id,a,b,c in xfields: ValueError: need more than 3 values to unpack -- Subscription settings:http://groups.google.com/group/web2py/subscribe?hl=en- Скрыть цитируемый текст - - Показать цитируемый текст -
[web2py] Re: How to return the resources?
Jason, thank you for the important addition... On 17 апр, 13:07, Jason Brower encomp...@gmail.com wrote: To add to the closed topic. (: Massimo and I worked over this with PySerial and yeah, having a separate program to manage the serial connection is actually VITAL. Especially if your making devices that send important other data. Have that external app just update a file in queue with information, and when you need it displayed in the webbrowser you can just make a request for the status from that file. This is similar to the issues found in a webcam. You don't make the web application take a picture of a file when a webpage requests it as it would pile full of requests and errors as everyone is trying to use the same device. With a file, like an image, everyone should have access to it very easily. In my setup I was dealing with industrial robots, some logic had to be done faster than the webbrowser could do it. So having a machine server as we call it at work, helps take care of those common logic steps so that web2py doesn't worry about it. BR, Jason Brower On Sat, 2010-04-17 at 01:46 -0700, aabelyakov wrote: Yes, this is the right decision! Topic closed. Thanks On 16 апр, 17:30, mdipierro mdipie...@cs.depaul.edu wrote: I think there is a problem with multithreading because of PySerial. Pyserial open a post connected to COM and COM is a resource that cannot be shared. In web2py every request is executed in its own thread so it is not obvious who open the COM, who closes it and how conflicts are avoided. Please tell us more of what you are doing. The best solution may be not to use pyserial in a web2py problem but use it in a single bachground process that talks to web2py via queued messages. Massimo On Apr 16, 2:13 am, aabelyakov aabelya...@gmail.com wrote: I do not use os.chdir or explicit calls to thread module. I'm using PySerial and after the error COM port remains open. To close it, I restart the web server. How to avoid this? On 15 ÁÐÒ, 22:46, mdipierro mdipie...@cs.depaul.edu wrote: Do you use os.chdir or explicit calls to the thread module in your code? On Apr 15, 12:15špm, aabelyakov aabelya...@gmail.com wrote: During my application error occurs and it stops giving error ticket. How can I in my application to return the resources of the operating system (eg close the COM port) šbefore the error ticket not to restart the web server? Excuse my bad English... Regards- óËÒÙÔØ ÃÉÔÉÒÕÅÍÙÊ ÔÅËÓÔ - - ðÏËÁÚÁÔØ ÃÉÔÉÒÕÅÍÙÊ ÔÅËÓÔ - -- Subscription settings:http://groups.google.com/group/web2py/subscribe?hl=en-Скрыть цитируемый текст - - Показать цитируемый текст -- Скрыть цитируемый текст - - Показать цитируемый текст -
[web2py] NameError: global name 'formstyle' is not defined
Version 1.76.5 (2010-03-20 12:12:17) web2py source code from trunk File D:\MyProg\_MyPython\Web2py\gluon\sqlhtml.py, line 799, in __init__ if formstyle == 'table3cols': NameError: global name 'formstyle' is not defined -- Subscription settings: http://groups.google.com/group/web2py/subscribe?hl=en
[web2py] Re: NameError: global name 'formstyle' is not defined
On 16 апр, 10:21, mdipierro mdipie...@cs.depaul.edu wrote: In the version in trunk that line is 768 and not 977 and it is defined. It is an argument of the function. Your file appear longer than it should be and that is very odd. Please try download it again. I added into sqlhtml.py 2 missing strings: formstyle = 'table3cols', self.formstyle = formstyle but got the following error: File D:\MyProg\_MyPython\Web2py\gluon\sqlhtml.py, line 803, in __init__ for id,a,b,c in xfields: ValueError: need more than 3 values to unpack -- Subscription settings: http://groups.google.com/group/web2py/subscribe?hl=en
[web2py] Re: How to return the resources?
I do not use os.chdir or explicit calls to thread module. I'm using PySerial and after the error COM port remains open. To close it, I restart the web server. How to avoid this? On 15 апр, 22:46, mdipierro mdipie...@cs.depaul.edu wrote: Do you use os.chdir or explicit calls to the thread module in your code? On Apr 15, 12:15 pm, aabelyakov aabelya...@gmail.com wrote: During my application error occurs and it stops giving error ticket. How can I in my application to return the resources of the operating system (eg close the COM port) before the error ticket not to restart the web server? Excuse my bad English... Regards- Скрыть цитируемый текст - - Показать цитируемый текст - -- Subscription settings: http://groups.google.com/group/web2py/subscribe?hl=en
[web2py] How to return the resources?
During my application error occurs and it stops giving error ticket. How can I in my application to return the resources of the operating system (eg close the COM port) before the error ticket not to restart the web server? Excuse my bad English... Regards -- To unsubscribe, reply using remove me as the subject.
