[web2py] Error importing pydal running from PyCharm

Hi, when running my web2py app from pycharm I get an error importing pydal. The directory is a full source download, so the full dal package is included. When I run direct from command line It works. I'm working in MacOS Ventura on a Macbook Air M2. *Commandline* *tom@Tom-sin-MacBook-Air-2022 w2p

[web2py] Error in gluon parse_all_vars(): TypeError: write() argument must be str, not bytes

I'm running web2py Version 2.24.1-stable+timestamp.2023.03.23.05.07.17 with Python3.9 on Linux RHEL9. I have a web2py application that exposes a website to the public, it succesfully handles about 50 requests per second :) Every day I see a few errors with this traceback: Traceback (most recent

[web2py] Error with redis and web2py 2.24.1: Invalid input of type: 'NoneType'. Convert to a bytes, string, int or float first.

Hey there! I recently updated to Web2py Version 2.24.1-stable+timestamp.2023.03.23.05.07.17 It uses python 3.9.14, running in production serving around 60 requests per second, using resources efficiently and running really smoothly :D Since the update, I'm seeing this error sporadically: *redi

[web2py] Error ticket for "admin" when trying to create a view

Hi guys, I'm updating one of my very early projects, I was trying to create a view and I got an error: Error ticket for "admin", I dont know what's causing it, how do I fix this? Its a new error that I have never encountered before, thats the traceback below. I developed it with Version 2.14.

Re: [web2py] Error running WSGI application-Pythonanywhere

I removed the routes.py file and able to access the error messages. A file was missing prompting the error above. Closed. On Sun, Nov 22, 2020, 17:46 Maurice Waka wrote: > I noticed that my pages reutrned an error: "404 NOT FOUND" > > The error log gives this messages: >

[web2py] Error running WSGI application-Pythonanywhere

I noticed that my pages reutrned an error: "404 NOT FOUND" The error log gives this messages: Error running WSGI application 2020-11-22 11:12:15,623: ModuleNotFoundError: No module named 'fileutils' 2020-11-22 11:12:15,630: File "/var/www/www_hest_com_wsgi.py", line 8, i

[web2py] Error: Connection lost during download

Hi I store my uploaded file in the web2py "static" folder. One of the download link for linux binaries fails. It downloads 1GB, then fails. This is the link: https://cryoem.bcm.edu/cryoem/static/software/continuous_build/eman2_sphire_sparx_huge.linux.unstable.sh . Is this problem due to the file

[web2py] Error with FDB in new version of Web2py

*Error ticket for "application"* *Ticket ID* *127.0.0.1.2020-08-06.08-53-16.232678aa-5c76-4d2f-b740-c3dc5be4668d* * ('Error while preparing SQL statement:\n- SQLCODE: -104\n- Dynamic SQL Error\n- SQL error code = -104\n- Unexpected end of command - line 1, column 8', -104, 335544569)* *Версия* *

[web2py] Error al ejecutar web2py en windows

Hola todos! Pueden ayudarme con lo siguiente al iniciar web2py en windows 10: Traceback (most recent call last): File "", line 6, in File "__main__.py", line 128, in File "__main__web2py__.py", line 33, in TypeError: start() takes no arguments (1 given) Muchas gracias! -- Resources: -

[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 prin

[web2py] error

I cant seem to log in when i get redirected from COursera python basics -- 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

[web2py] Error (web2py on GAE): ImportError: No module named gluon.settings

*web2py on GAE* gives the following error: *ImportError: No module named gluon.settings (/base/data/home/apps/s~appname/appversion.425325282173601763/gaehandler.py:47)* Everything was working fine. Can someone enlighten what is happening? -- Resources: - http://web2py.com - http://web2py.com/

[web2py] ERROR on Request

In py4web, I cant use this syntax: default = request.now Error: Field('modified_on', 'datetime', default=request.now),# update=request.now), NameError: name 'request' is not defined -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Error in factories.py in py4web?

In the class ActionFactory, there's the code below. Is that an error? I don't think requires_login is in the proper place? Maybe I don't understand. def put(self, path=None, template=None): return self._action_maker('PUT', template, requires_login) -- Resources: - http://web2py.com - h

[web2py] Error 400 for Not authorized? Shouldn't we use 401?

Hi Guys, I am using AuthJWT from https://github.com/web2py/web2py/blob/master/gluon/tools.py I could see that an expired token or not authorized token is returning error 400. Shouldn't we use 401 - Unauthorized? https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/401 Thanks! Tito -- Li

[web2py] Error on model db.py

I have attached the code and the error message. Please help! -- 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 sub

[web2py] Error with sessions on redis

Part of db.py file for connection with redis: from gluon.contrib.redis_utils import RConn rconn = RConn('localhost:6379') from gluon.contrib.redis_session import RedisSession sessiondb = RedisSession(redis_conn=rconn, with_lock=True, session_expiry=3600) session.connect(request, response, db = se

[web2py] error tickets missing error snapshot details

In my development environment, on Windows, with web2py 2.18.5, error tickets are truncated, no details are displayed. An example is included below. The ticket file is only ~2kb, so the stored ticket is actually truncated. Any idea why this is happening? In the same environment /admin/default/er

[web2py] Error upload file csv database

Hello !!! I need help , I have four tables in DB, but I migrate for other domin so i have put the datas in DB new, but exist error foreign key incompaltible this ocorred because when upload file example auth_user the column ID is modificate for other number diferents the table original some

[web2py] Error: Tried to send "500 Server Error" to client but received socket error (When user closes browser during load, or when using the requests library.)

Hi, I am building a dashboard/API and am seeing this error a lot in my logs: ERROR:Rocket.Errors.Thread-3:Tried to send "500 Server Error" to client but received socket errorERROR:Rocket.Errors.Thread-6:Traceback (most recent call last): File "/opt/app-root/src/gluon/rocket.py", line 1288, in

[web2py] Error trying to go back to python 2 after testing python 3: TypeError: translate() takes exactly one argument (2 given)

Delete all the .pyc files? /dps -- 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 Group

[web2py] Error trying to go back to python 2 after testing python 3: TypeError: translate() takes exactly one argument (2 given)

I'm testing my web2py application to see what I need to fix in order to make it compatible with python3. I'm using web2py Version 2.17.1-stable+timestamp.2018.08.06.01.02.56 My application has been running with python2 for a long time. Yesterday I tried with python3 (setting up a virtual environm

[web2py] Error that I couldnt catch - TypeError: getattr(): attribute name must be string Error

Hello Has anyone found such an error on web2py ? If yes - any clue what it could be ? Ticket ID 109.102.111.32.2019-09-16.00-02-25.3b80feb4-c283-4a67-8ece-6d7917ba4334 Version web2py™ Version 2.18.5-stable+timestamp.2019.04.08.04.22.03 Python Python 2.7.13: /usr/bin/python (prefix: /usr)Tra

Re: [web2py] Error PIL path

On Friday, July 19, 2019 at 11:04:25 AM UTC-7, Márcio Luis Dresch wrote: > > #this is a copy from > http://www.web2pyslices.com/slice/show/1522/generate-a-thumbnail-that-fits-in-a-box > I'm not sure I agree with Nico, after reading your followup ... is "ImageUploads" the name of your applicat

Re: [web2py] Error PIL path

#this is a copy from http://www.web2pyslices.com/slice/show/1522/generate-a-thumbnail-that-fits-in-a-box #modules\smarthumb.py from gluon import current import os try: from PIL import Image except: import Image def SMARTHUMB(image, box, fit=True, name="thumb"): '''Downsample the image. @param img

[web2py] Error PIL path

The example code assumes that the images are in the standard ‘uploads’ folder. Without looking at at your code, it seems that you defined - in your model file - the download folder to be ‘imageuploads’. That would explain why the thumbnail is not found. Nico de Groot -- Resources: - http:

[web2py] Error PIL path

Hi, I'm new to web2py and am looking for a solution to a problem. The library is returning a path error while fetching an image for the thumbnail. I took the example from: http://www.web2pyslices.com/slice/show/1522/generate-a-thumbnail-that-fits-in-a-box, which returns File "C: \ Users \

[web2py] Error in app: the variable was lost

In my controller I have function: def send_app(): if session.abit_email is None:redirect('https://oas.timacad.ru/application', client_side=True) const = {rec.NAME:rec.TEXT for rec in db((db.t_const.NAME=='RECTOR_RANKU') | (db.t_const.NAME=='PREDSEDU') | (db.t_const.NAME=='VUZ')).select(d

[web2py] Error in json.loads

Try data:{data: JSON.stringify(your_js_object_to_send)} -- 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 subscrib

[web2py] Error in app: cannot unpack non-iterable NoneType object

I have that string in controller: res,flag=send_application(msg,entrant_XML) and send_application function: def send_application(msg,entrant_XML): #my code return('My message',False) I get error: Ticket ID 46.73.180.207.2019-06-20.10-47-49.e820b49a-8731-495f-9156-0d75ad265046 cannot unpack non-

[web2py] Error in json.loads

JS console.log('data={'+fo.slice(0,-1)+'],'+fac.slice(0,-1)+'],'+dir.slice(0,-1 )+'],'+cg_id.slice(0,-1)+'],'+comp_group.slice(0,-1)+'],'+bud.slice(0,-1)+ ']}'); I get that json string: JSON string (from console.log(); in google chrome) data={"fo":["очная","очная","очная"],"fac":["Мелиорации, водно

[web2py] Error after restore

Hello. I've restored from backup a compiled application called hydrover_oleodinamica. Now only on the files that are called from Ajax I've got this 500 internal server error: (dp1 S'output' p2 S" need more than 1 value to unpack" p3 sS'layer' p4 S'/home/tasko/webapps/w2p_2_14_16/web2py/applica

[web2py] Error with couchdb

I want to use couchdb with web2py. It's a little bit hard, because the documenation is missing in the book, but I found something in https://pydal.readthedocs.io/en/latest/ Now I have tried cdb = DAL('couchdb://admin:password@localhost:5984/w2p') and I got: Error ticket for "admin"Ticket ID 213

[web2py] Error using auth.signature

Hi, I' new to web2py and I try to follow Massimo Di Pierro video on YouTube/Vimeo. When I change in db1.py the 4 following 4 rows: Field('dateofcreation', 'datetime'), Field('created_by', 'reference auth_user'), Field('modified_by', 'reference auth_user'), Field('modified_on', 'datetime')) with a

[web2py] Error Ticket Includes Sensitive Information

The error tickets created by the framework are great for debugging, however depending on where a failure can include, they can include very sensitive information like user ID + password combinations. Is it possible to filter certain fields out of the tickets such as user name / password? It se

Re: [web2py] Error when deleting items

Any help on this? On Mon, 18 Mar 2019, 00:31 Maurice Waka wrote: > This is my simple code when using to delete items from my database. > > grid = SQLFORM.grid(db.answered.author == auth.user.id, editable=False > , searchable=False, details= False, fields=None, csv=None, links=None, > create=

[web2py] Error when deleting items

This is my simple code when using to delete items from my database. grid = SQLFORM.grid(db.answered.author == auth.user.id, editable=False, searchable=False, details= False, fields=None, csv=None, links=None, create= False, field_id=None, selectable=lambda ids:delete_them(ids)) return loc

[web2py] Error accessing app edit

When clicking on the edit button for my app, I get this error: 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. Traceback (most recent call last): File "/home/mauricewaka/web2py/gluon/restricted.py", line 219, in restricted exec(ccode, environment) File "/home/mauricewaka/web2py

[web2py] Error after edit project

After I edit project (write or delete any strings) I have got error from time to time like that: Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. Traceback (most recent call last): File ".\gluon\restricted.py", line 219, in restricted exec(ccode, environment) File "C:\inetpub\wwwroot\application

[web2py] Error in app which cause error in web2py 2.18.4

Web2py 2.18.4 give me to save project with error and after that I can not edit it in app. I have dict: {21: '\xd0\x94\xd0\xb8\xd0\xbf\xd0\xbb\xd0\xbe\xd0\xbc \xd0\xbe \xd0\xb2\xd1\x8b\xd1\x81\xd1\x88\xd0\xb5\xd0\xbc \xd0\xbf\xd1\x80\xd0\xbe\xd1\x84\xd0\xb5\xd1\x81\xd1\x81\xd0\xb8\xd0\xbe\xd0\xbd

Re: [web2py] error 'module' object has no attribute 'pbkdf2_hmac' when trying to add user (Ver 2.18.4)

I can't access appadmin under python 3: 'ascii' codec can't decode byte 0xea in position 1: ordinal not in range(128) web2py™ Version 2.18.4-stable+timestamp.2019.03.13.05.27.54 Python Python 3.5.2: /usr/local/bin/uwsgi (prefix: /usr)Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. Traceback (most rece

Re: [web2py] error 'module' object has no attribute 'pbkdf2_hmac' when trying to add user (Ver 2.18.4)

Can you also test it with python3 please? On Fri, Mar 15, 2019 at 5:11 PM Stephan wrote: > Hello there, > > > when trying to add a user in the empty user table via appadmin, I get this > error: *'module' object has no attribute 'pbkdf2_hmac'* > Seems to be related to password encryption? > > > F

[web2py] error 'module' object has no attribute 'pbkdf2_hmac' when trying to add user (Ver 2.18.4)

Hello there, when trying to add a user in the empty user table via appadmin, I get this error: *'module' object has no attribute 'pbkdf2_hmac'* Seems to be related to password encryption? Function argument list (data='!xb2qwtze', salt='b2dfc4f426ee1bbd', iterations=1000, keylen=20, hashfunc=

[web2py] error while reading browser cookies

This is the first time I am trying to use the cookies. Following the appropriate section in the book, here is the line: *if request.cookies.has_key('test_cookie'):* it causes the following error: 'SimpleCookie' object has no attribute 'has_key' what am I missing? -- Resources: -

Re: [web2py] Error importing csv file in python3.6

Narrowed down to the xml(). Can you help? On Mon, Feb 11, 2019 at 10:04 PM sandeep patel wrote: > @Lovedie > Can you explain a little bit more? What you mean by can't access the data? > > If you getting the error to import data from CSV. You can try this as well. > > form = FORM(DIV(LABEL('File

Re: [web2py] Error importing csv file in python3.6

After much study, I noted that the import was successful. Both in python 2.7 and 3.6. Its in python 3.6 that I get problems. Getting to select the items from the database was the problem unless i knew the item's fill name in full. The code below helps to 'auto suggest' and helps in picking the ite

[web2py] Error connecting to MySQL 8.0

Hi! I had previously MySQL 5.5 and web2py 2.9.12 on the local machine, OS Windows 10. My connection strinq db = DAL("mysql://root:passw@127.0.0.1/dbname", db_codec = 'UTF-8') was working fine. I am having now MySQL 8.0 and any of the strings db = DAL("mysql://root:passw@127.0.0.1/dbname", db_

[web2py] error connecting to mysql

Hello. I have this error when I start application "ga" Error ticket for "ga" Ticket ID 127.0.0.1.2019-02-13.20-49-28.fcc1a494-3aa4-42c2-b1a9-ab14a466e72e Failure to connect, tried 5 times: Traceback (most recent call last): File "C:\web2py\gluon\packages\dal\pydal\base.py", line 454, in __init

Re: [web2py] Error importing csv file in python3.6

When I search for an item it returns blank. However I see that the upload to the db took place. When I try to add data to the database, where other data was uploaded, I get this error 1. 2. 3. 4. 5. 6. Traceback (most recent call last): File "/home/mauricewaka/web2py/gluon/restricted.py", line

Re: [web2py] Error importing csv file in python3.6

@Lovedie Can you explain a little bit more? What you mean by can't access the data? If you getting the error to import data from CSV. You can try this as well. form = FORM(DIV(LABEL('File input',_for='exampleInputFile'),INPUT(_type='file',_name='csvsheet',_id="exampleInputFile"),_class='from-gro

Re: [web2py] Error importing csv file in python3.6

Works. But I can't access the data. On Mon, 11 Feb 2019, 21:02 sandeep patel In fact, this is an open issue > for the same problem. You > can check that as well > > On Mon, Feb 11, 2019 at 11:27 PM sandeep patel > wrote: > >> I had the same issue. I

Re: [web2py] Error importing csv file in python3.6

In fact, this is an open issue for the same problem. You can check that as well On Mon, Feb 11, 2019 at 11:27 PM sandeep patel wrote: > I had the same issue. I have solved this way. > Please try this > You have to changing line 926 of gluon/packages

Re: [web2py] Error importing csv file in python3.6

I had the same issue. I have solved this way. Please try this You have to changing line 926 of gluon/packages/dal/pydal/objects.py from reader = csv.reader(csvfile, delimiter=delimiter, quotechar=quotechar, quoting=quoting) to reader = csv.reader(codecs.iterdecode(csvfile,'utf-8'), delimiter=delimi

[web2py] Error importing csv file in python3.6

I shifted to web2py/python3. In python2.7 I was able to upload csv files but using the same code below I get an error. For example: def import_csv(): form = FORM(INPUT(_type = 'file', _name = 'csv_file'), INPUT(_type = 'submit', _value = T('Import'))) return dict(form=form) @m

Re: [web2py] Error: prepared statement «pg8000_statement_0» already exists

Hi there! Finally I was able to solve the problem uninstalling psycopg2* and reinstalling psycopg2-binary. Still, I want to comment what happened, in case it helps others. A packages update broke the psycopg2 package in the server. Actually, the server ended up with two instances: psycopg2 and p

Re: [web2py] Error: prepared statement «pg8000_statement_0» already exists

When psycopg is available web2py will use it when is not it use pg8000 that was included in web2py Il giorno mer 23 gen 2019 alle 14:05 Lisandro ha scritto: > Thank you all for that notes. > > When I run web2py at my server, I see this available drivers: sqlite3, > imaplib, pymysql, pg8000 > I d

Re: [web2py] Error: prepared statement «pg8000_statement_0» already exists

Thank you all for that notes. When I run web2py at my server, I see this available drivers: sqlite3, imaplib, pymysql, pg8000 I don't see psycopg2, so I presume it will be available if I uninstall those two versions and install the psycopg2-binary version. One additional question: which driver

Re: [web2py] Error: prepared statement «pg8000_statement_0» already exists

Try to uninstall psycopg2-* and reinstall only psycopg2-binary On Wed, Jan 23, 2019 at 11:52 AM Massimiliano wrote: > Could be. > > When you strart web2py it show database driver available: > Mine: > Database drivers available: psycopg2, pymysql, imaplib, sqlite3, pg8000, > pyodbc, pymongo > > >

Re: [web2py] Error: prepared statement «pg8000_statement_0» already exists

perhaps this conversation can give a hint: https://github.com/DataDog/dd-agent/issues/2755 did you backup the server before upgrade? best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.goo

Re: [web2py] Error: prepared statement «pg8000_statement_0» already exists

Could be. When you strart web2py it show database driver available: Mine: Database drivers available: psycopg2, pymysql, imaplib, sqlite3, pg8000, pyodbc, pymongo On Wed, Jan 23, 2019 at 10:59 AM Lisandro wrote: > Thanks Massimiliano. > > Apparently psycopg2 is already installed (of course i

Re: [web2py] Error: prepared statement «pg8000_statement_0» already exists

Another weird stuff I noticed: in my server, if I open a terminal, run python and try to import psycopg2, I receive an error: >>> import psycopg2 Traceback (most recent call last): File "", line 1, in File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 50, in from psyc

Re: [web2py] Error: prepared statement «pg8000_statement_0» already exists

Thanks Massimiliano. Apparently psycopg2 is already installed (of course it was already installed, maybe something broke during the packages upgrade). Something weird is that I see psycopg2 installed twice, is this correct? ~$ pip freeze | grep psycopg2 psycopg2==2.7.5 psycopg2-binary==2.7.5 Co

Re: [web2py] Error: prepared statement «pg8000_statement_0» already exists

Have you tried to install psycopg2? Is the standard de facto postgresql driver. The pip package should be psycopg2-binary On Wed, Jan 23, 2019 at 10:39 AM Lisandro wrote: > Hi there! Yesterday I had a MAJOR downtime and I would need your help to > understand what happened. > > The team that is i

[web2py] Error: prepared statement «pg8000_statement_0» already exists

Hi there! Yesterday I had a MAJOR downtime and I would need your help to understand what happened. The team that is in charge of upgrading security packages at my server (CentOS 7 at Linode) did an update that involved an upgrade to pgBouncer. Accordingly to what they said, they noticed pgBounc

[web2py] Error when sending email from my custom web app [Errno 111] Connection refuse

Hi All, I have a custom email function that was working fine previously (with gmail). Now after gmail's policies got updated, I am not able to use it properly. I got myself an email server which works on port 465 (SSL) or port 26(Not secure/not recommended version) for SMTP. Also, I am

Re: [web2py] Error Handling in the view

Thank you very much SP for pointing that out, much appreciated Mostwanted On Monday, December 24, 2018 at 3:11:23 PM UTC+2, sandeep patel wrote: > > @Mostwanted > This is because of try-except block under if block. when price value has > None than if condition false. > I have tested this code th

Re: [web2py] Error Handling in the view

@Mostwanted This is because of try-except block under if block. when price value has None than if condition false. I have tested this code than is work fine for me. .{{ for price in pricing: try: vat=round(price.total*0.12, 2) except: redirect(URL('notRegistered')) else:

[web2py] Error Handling in the view

In my view i have a section that does a calculation of a value plus its VAT(tax), the problem is if this value is not found i get an error like the one below: unsupported operand type(s) for *: 'NoneType' and 'float' What i want to be able to do is to be able to redirect to another page that

[web2py] error exporting data (CSV) using smartgrid

Hello, i have an error when i try to export smartgrid data, smart grid displays fine, but when i try to export data (click on the Export: [CSV] button) i have the following error: (1064, u'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo

[web2py] Error with datetime.

I'm getting this error when using datetime; Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 35. 36. 37. 38. 39. 40. 41. 42. 43. 44. 45. 46. 47. 48. 49. 50. Traceback (most recent call last): File "/home/mau

[web2py] Error processing form with select multiple

Hi everyone!, I'm developing a site which have 3 forms in one page, and one of them have multiples selection fields. I'm facing an error when the form is processed and I have not been able to fix it. Error: * string indices must be integers, not str* *locals* *c* : '' *component_list* :

[web2py] error connecting to postgrsql when running web2py from source on windows

I get the following error when try running from source (git clone 2.17.1 ) on windows. RuntimeError: No driver of supported ones ('psycopg2',) is available The welcome application runs fine. works fine also (connecting to pg) on 2.14.6 source used commandline: C:\Python27\python.exe C:\Dev\web\

[web2py] Error in all functions that I use SQLFORM.grid

Hi people, I have an application that is being used in production almost one year. Today I was making an update in local development environemnt and got the error below. I tried to use other functions where the SQLFORM.grid is used too and got the same error. Traceback (most recent call last)

[web2py] error: cannot switch to a different thread

Deployed web2py to production lately, keep getting an intermittent error *"error: cannot switch to a different thread"*. Please help. - CentOS Linux release 7.4.1708 - web2py Version 2.16.1-stable+timestamp.2017.11.14.05.54.25 - Apache Version 2.4.33 - MySQL Version 10.1.30-MariaDB

[web2py] error: invalid literal for long() with base 10: ''

Hi, i have this table: def tempo_total_produto(produto_id): try: query = ((db.produto.id == produto_id)) result = db(query).select() data_status = result[0]["data_criacao"] data_hoje = datetime.date.today() retorno = abs((data_hoje - data_status).days)

[web2py] Error in mysql connection

Hi all, I am facing some issue to connect to the database with password including '@' symbol. without including '@' symbol in the password, it works. Is this a bug or am I missing something mysql://root:pass@123@localhost/csautomation It workes for following string: mysql://root:pass123@loca

[web2py] Error loging in after authentication changes

My app has been ok with these code; In controller: @auth.requires_login() def notes(): dbhealth.health.id.readable = False g = SQLFORM.grid(dbhealth.health, searchable=True, csv=False, user_signature=True, ) return dict(form = g)code question = db(db.answers.author == auth.u

[web2py] Error on migrate=True

I am getting an "tables already exist" error after adding column to an existing table in db.py and setting migrate from false to true. It's connected to a mysql. Application is running in version 2.8.2. Is there some cahce to be cleared? thx -- Resources: - http://web2py.com - http://web2py.c

Re: [web2py] Error using Postgres

PROBLEM SOLVED [image: http://itjp.net.br] http://itjp.net.b r *Ovidio Marinho Falcao Neto* ovidio...@gmail.com Brasil 2018-02-28 8:02 GMT-03:00 Morganti :

Re: [web2py] Error using Postgres

Hi, The last command before the error in line 54 'for row in rows:' is a selection using 'iterselect'. I changed the 'iterselect' to 'select' and no more errors. Thanks Massimo, Ovidio and Daves. Best regards André Em terça-feira, 27 de fevereiro de 2018 12:29:16 UTC-3, Morganti escreveu: > >

Re: [web2py] Error using Postgres

HI Massimo, I could import psycopg2 in web2py shell manually. I used the installation script inside web2py scripts folder. Bellow the entire error: 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. Traceback (most recent call last): File "/home/www-data/py27env/we

Re: [web2py] Error using Postgres

If it finds psycopg2 it should be using it over pg8000. Is t possible you have two versions of python installed? On Sunday, 25 February 2018 04:46:57 UTC-6, Morganti wrote: > > Hi Massimo, thanks your answer. > > How can force web2py uses psycop2? I install pyscop2 using pip and made a > test

Re: [web2py] Error using Postgres

Hi Massimo, thanks your answer. How can force web2py uses psycop2? I install pyscop2 using pip and made a test importing it in normal python shell. But I got the same error when tried to execute the same function: ((u'ERROR', u'34000', u'portal "pg8000_portal_294" does not exist', u'postgres.c

Re: [web2py] Error using Postgres

I know. It is there and we distribute it but we will remove it in the next version. I run into lots of problems with it, even with simple apps. psycopg2 works instead. On Friday, 23 February 2018 04:57:41 UTC-6, Morganti wrote: > > Hi Dave, > > I found "pg8000" inside "gluon/contrib". > > In "g

Re: [web2py] Error using Postgres

Hi Dave, I found "pg8000" inside "gluon/contrib". In "gluon\packages\dal\pydal\adapters" I found the "postgres.py". So is it wrong? Do I need to move pg8000 to "gluon\packages\dal\pydal\adapters"? You said about socket. I have no idea how to do it. Thanks a lot your support! Best regards Andre

Re: [web2py] Error using Postgres

On Thursday, February 22, 2018 at 8:29:43 AM UTC-8, Morganti wrote: > > Hi, thanks your time. > > How can I check it? If I try to open web2py shell (web2py -S app -M), I > had no errors and all tables could be used. > > Thanks > BR > André > > That's one way to check. The actual files should s

Re: [web2py] Error using Postgres

Hi, thanks your time. How can I check it? If I try to open web2py shell (web2py -S app -M), I had no errors and all tables could be used. Thanks BR André Em quinta-feira, 22 de fevereiro de 2018 13:08:23 UTC-3, Ovidio Marinho escreveu: > > make sure the pg8000 and psycopg2 libraries are insta

Re: [web2py] Error using Postgres

make sure the pg8000 and psycopg2 libraries are installed at the start of web2py [image: http://itjp.net.br] http://itjp.net.b r *Ovidio Marinho Falcao Neto* ovidio...@gmail.com

[web2py] Error using Postgres

Hello, I have a VPS using ubuntu 16.04, nginx, Postgres and web2py 2.16.1. I tried to execute one controller that populate some tables and got the error below. Then, I used that command to create a csv file with all tables and uploaded it in my desktop using SQLITE and no error were found. Th

[web2py] Error in IS_DATE / IS_DATETIME validator?

This one took me a while to figure it out: im declaring a model as: date_format = "%Y-%m-%d" db.define_table("bookings" , Field("start_date", "datetime") , Field("end_date", "date", requires = IS_DATE(format=date_format)) , Field("agency", "reference agencies", format="{agency}")

[web2py] error: 'No module named sanitizer' after upgrading to 2.16.1

After upgrading from 2.15.4 it gave the ticket below. Unfortunately putting it back to the previous or an even older version did not solve the problem. Searching the web it seems to be related to python libs *html5lib *and *bleach* reinstalling or updating them with 'pip install -U bleach' does

[web2py] ERROR : ImportError: No module named gluon.utils in websocket_messaging.py after upgrade to 2.15.4

I have been using websocket_messaging.py without problems in version 2.14.6. After upgrading to 2.15.4 i can not start websocket_messaging anymore, iget this error : ImportError: No module named gluon.utils Any help ? Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documenta

[web2py] Error ticket handling

is there any way to display the user id who generated the error ticket? the user id from the auth_user table -- 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) -

[web2py] Error in appadmin (database admin) on python 3

Hello, when using python3 and database admin, I got this error: name 'unicode' is not defined You need to click on any table name (for example, http://127.0.0.1:8000/mysite/appadmin/select/db?query=db.auth_user.id%3E0). I think this is python3 unicode -> str specific related trouble. -- Re

[web2py] Error with Reading ListReferences in web2py 2.15.2 from database

I have just updated to web2py 2.15.2 and my site www.holidaysenses.com became unstable (unusable). Line codes like: image = db(db.intro_lifestyles.tourism_segment_id == segment.id).select().first() or image = db(db.intro_regions.region_id == region.id).select().first() where db.intro_lifestyl

[web2py] Re: MySQL and web2py error 1103

Is this with the latest version? 2.15.2? On Friday, 28 July 2017 11:13:23 UTC-5, Jorgeluis Ortega wrote: > > Hi, I'm working with web2py for some months, which seems to be a very > interesting tool. > I want to know if there is the possibility of manipulating MySQL data from my > app inventor

[web2py] MySQL and web2py error 1103

Hi, I'm working with web2py for some months, which seems to be a very interesting tool. I want to know if there is the possibility of manipulating MySQL data from my app inventor through web2py. I have tried a few methods but it gives me an error 1103 unable to post or put the text. I want t

[web2py] Error with autocomplete in version 2.15.2

Versión: web2py.exe para windows 2.15.2 When entering data in the autocomplete field, the candidate values are not displayed. When you enter, it indicates an invalid value. And an image in transparent format appears and disappears from the first part of the displayed panel. The panel, is to inse

[web2py] Re: Web2py Error apache2 ubuntu server form two ports

Does the problem go away if you delete your sessions? If not, can you please open a github issue about this? On Friday, 30 June 2017 13:36:22 UTC-5, Marco Antonio Castro Collazos wrote: > > 1073/5000 > Good morning everyone > I have the following problem: > I have web2py installed on an ubuntu se

[web2py] Web2py Error apache2 ubuntu server form two ports

1073/5000 Good morning everyone I have the following problem: I have web2py installed on an ubuntu server with apache2. I have a local network with port 443 and an ip publish port 5043 When I enter my web2py application from the local network, and I navigate without problem. But the entry from

  1   2   3   4   5   6   >