[web2py] RuntimeError: no driver available ('sqlite2', 'sqlite3')

Hello! I'm trying install the web2py in a new server, but after a few hours, i got the error in the welcome app: RuntimeError: no driver available ('sqlite2', 'sqlite3') web2py 2.8.2-stable+timestamp.2013.11.28.13.54.07 CentOS 5.9 python 2.7.5 Would anyone say what is happening? Thanks!! --

Re: [web2py] Re: Unknown Error

Thanks, Niphlod. I performed some tests to better understand it. I stayed a long time without working with web2py. I needed to remember some things. Thanks again! pyslan On Sat, Oct 19, 2013 at 9:03 AM, Niphlod wrote: > if you don't have blablabla_auth_*.table files in the databases/* folde

Re: [web2py] Re: Unknown Error

Well, I reinstalled the uwsgi e works, but now another error is as follows: 23. OperationalError: (1050, "Table 'auth_user' already exists") Details of my code: In the file models/000_settings.py: settings = Storage( db = Storage(), auth = Storage(), mail = Storage() ) settings.db.migrate_

[web2py] Unknown Error

Hello erevydory!! After upgrade web2py with update-web2py.sh, the error is: (Internal error -> Ticket issued: unknown) [image: Inline image 1] I've restarted the nginx, uwsgi. Even the machine and does not work. Thanks!!! -- Resources: - http://web2py.com - http://web2py.com/book (Document

Re: [web2py] Re: TypeError: not indexable

I'll check again... On Wed, Oct 16, 2013 at 9:25 AM, Niphlod wrote: > you are not using 2.7.4 > Line 218 in trunk doesn't match your traceback. > > https://github.com/web2py/web2py/blob/master/gluon/globals.py#L218 > > Il giorno mercoledì 16 ottobre 2013 13:45:53 UTC+2, __pyslan__ ha scritto: >

Re: [web2py] Re: TypeError: not indexable

I'm using the last version, the 2.7.4... In version 2.7.2 the same thing happened On Wed, Oct 16, 2013 at 3:36 AM, Niphlod wrote: > upgrade web2py, it's a known bug. > > Il giorno mercoledì 16 ottobre 2013 01:46:08 UTC+2, __pyslan__ ha scritto: > >> Hello! >> >> I'm trying update a field (tota

[web2py] TypeError: not indexable

Hello! I'm trying update a field (total_treated) with ajax. I'm using a SQLFORM.grid. In the index.html: {{extend 'masterpage.html'}} $(document).ready(function(){ window.setInterval(function() { var objs = $("[name^='t_']"); for(var i = 0; i < objs.length; i++) { var l = objs[i].getAttribute("

Re: [web2py] Re: onvalidation upload size

Gosh! Of course I should!! Thanks! On Fri, Oct 11, 2013 at 7:41 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > If you read the file (csv.reader(sent_file) or sent_file.readlines(), > etc.) you then have to rewind it: > > sent_file.seek(0) > > > > > On Tuesday, 23 July 2013 21:18:0

Re: [web2py] Re: onvalidation upload size

Hello everybody. This happens both in development environment as in staging environment. If someone can help me... Thanks! On Wed, Oct 9, 2013 at 2:34 AM, __pyslan__ - Ayslan Jenken < ayslan.pyt...@gmail.com> wrote: > Massimo, the strange behavior continues to occur... > >

Re: [web2py] Re: onvalidation upload size

print request.vars >> print request.vars.file_name >> >> But if i put for example: >> print request.var._formname >> Doesn't work! I have to print something related with file_name field. >> >> >> >> >> On Thu, Jul 25, 2013 at 8:30 PM, __pys

Re: [web2py] Re: onvalidation upload size

Works with: print request print request.vars print request.vars.file_name But if i put for example: print request.var._formname Doesn't work! I have to print something related with file_name field. On Thu, Jul 25, 2013 at 8:30 PM, __pyslan__ - Ayslan Jenken < ayslan.pyt...@gmail.co

Re: [web2py] Re: onvalidation upload size

I'm sorry, web2py version is 2.5.1. On Thu, Jul 25, 2013 at 8:27 PM, __pyslan__ - Ayslan Jenken < ayslan.pyt...@gmail.com> wrote: > I don't understand too, I do not see any connection, but I'm sure... > Without "print request" command the file upload

Re: [web2py] Re: onvalidation upload size

I don't understand too, I do not see any connection, but I'm sure... Without "print request" command the file uploaded has 0 bytes. With "print request" command the file uploaded has the correct size... On Thu, Jul 25, 2013 at 10:04 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Ar

[web2py] onvalidation upload size

Hello everybody. I'm trying upload files with SQLFORM.grid. Model: FilesUploaded = db.define_table('files_uploaded', Field('name', notnull=True, label=T("Name")), Field('file_name', 'upload', notnull=False, label=T("File")), Field('owner_group', 'reference auth_group', notnull=True,

[web2py] Re: WebFaction

) ImportError: No module named rama.modules.img_threat Agora fica intermitente, hora abre o admin, hora não, mas o site mesmo agora nem abre... Alguém saberia o que eu posso fazer para funcionar? Valeu! __pyslan__ 2013/3/21 __pyslan__ - Ayslan Jenken > Galera, boa noite! > > Co

Re: [web2py] Re: db.executesql error

Performing the procedure directly in MySQL Workbench returns correctly. The error occurs in: raw_rows = db.executesql(proc, fields=fields) 65. 66. 67. 68. 69. 70. 71. 72. 73. 74. if auth.user_id: user_id = auth.user_id fields = [db.auth_user.generation, db.auth_user.id, db.auth_user.fi

Re: [web2py] Re: db.executesql error

But not is the same error. Is in the same place, but not the same error. I don't understood why "again"? I really don't know what happening... both are ubuntu 12.04. Maybe the nginx... I don't know... Sorry for the mistake with "deployment", but I don't speak English very well, I am brazilian.

Re: [web2py] Re: Error db._adapter

t;> (cursor-objects)<http://mysql-python.sourceforge.net/MySQLdb.html#cursor-objects> >> MySQLdb >> documentation<http://mysql-python.sourceforge.net/MySQLdb-1.2.2/public/MySQLdb.cursors.Cursor-class.html> >> >> >> Suggestions, warnings, and criticisms

Re: [web2py] Re: Error db._adapter

n Tue, Feb 26, 2013 at 2:55 PM, __pyslan__ - Ayslan Jenken < ayslan.pyt...@gmail.com> wrote: > Ok. Thanks. > > > On Tue, Feb 26, 2013 at 2:43 PM, Massimo Di Pierro < > massimo.dipie...@gmail.com> wrote: > >> Now we ruled out web2py completely in this. You need a

Re: [web2py] Re: Error db._adapter

Ok. Thanks. On Tue, Feb 26, 2013 at 2:43 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Now we ruled out web2py completely in this. You need a MySQL expert. > > > On Tuesday, 26 February 2013 06:14:35 UTC-6, __pyslan__ wrote: > >> The result is the same error... >> >> I get the res

Re: [web2py] Re: Error db._adapter

The result is the same error... I get the result as (1), but the error is always thrown. On Tue, Feb 26, 2013 at 2:25 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Try: > > import MySQLdb > conn.MySQLdb.connect(db=db, >user=user, >

Re: [web2py] Re: Error db._adapter

gluon.contrib import from the mysql_connector mysqlconn MySQLAdapter.driver = mysqlconn And the error continues ... On Mon, Feb 25, 2013 at 3:06 PM, __pyslan__ - Ayslan Jenken < ayslan.pyt...@gmail.com> wrote: > I have not the faintest idea how to do that, and this feature

Re: [web2py] Re: Error db._adapter

I have not the faintest idea how to do that, and this feature is essential for the project. I can not build a recursive function due to performance. With great respect I ask, should I give up web2py in this case? On Mon, Feb 25, 2013 at 2:28 PM, Niphlod wrote: > well, I doubt that workbench u

Re: [web2py] Re: Error db._adapter

I got it: In [1]: fields = [db.auth_user.generation, db.auth_user.id, db.auth_user.first_name] In [2]: raw_rows = db.executesql('CALL sp_recursive_start(1);', fields=fields) In [3]: db.rollback() --- ProgrammingError

Re: [web2py] Re: Error db._adapter

No, Massimo, is not ... With or without the try... except... the error is the same ... I've tried this several times. The code of gist: https://gist.github.com/pyslan/5007364 (without try... except...) print it on the terminal server: ERROR:web2py:Traceback (most recent call last): File "/hom

Re: [web2py] Re: Error db._adapter

After reading this thread, as Anthony suggested, I tried this: import MySQLdb from gluon.dal import MySQLAdapter MySQLAdapter.driver = MySQLdb After that, even commenting this block of code I get the result correctly because the print rows, but

Re: [web2py] Re: Error db._adapter

rint row dv.append(DIV(row[2])) print len(db(db.auth_user).select(limitby=(0,1))) return dict(form=dv, subtitle=T('Users')) ... occur the same error: 'NoneType' object is not iterable Can anyone help me please? On Sat, Feb 23, 2013 at 1:51 PM, __pyslan__ - Ay

Re: [web2py] Re: Error db._adapter

I commented the use of _adapter.parser, and the error no longer occurs, but the data of db.executesql('CALL sp_recursive_start(1);') bring nothing every other refresh. On Sat, Feb 23, 2013 at 1:36 PM, __pyslan__ - Ayslan Jenken < ayslan.pyt...@gmail.com> wrote: > Ok...

Re: [web2py] Re: Error db._adapter

ection was closed. You cannot pretent nothing happened. >> >> Massimo >> >> On Saturday, 23 February 2013 09:35:55 UTC-6, __pyslan__ wrote: >>> >>> Hello everybody, >>> >>> I have not found a solution yet ... >>> Does any

Re: [web2py] Re: Error db._adapter

Hello everybody, I have not found a solution yet ... Does anyone have any idea how I could do? Thanks... On Fri, Feb 22, 2013 at 9:33 AM, __pyslan__ - Ayslan Jenken < ayslan.pyt...@gmail.com> wrote: > Well... > > Sorry, but the information about the code comment is wrong...

Re: [web2py] Re: Tip

No. .. I analyzed the code of gluon.tools.py, gluon.validators.py and gluon.dal.py. The application I used the code mentioned is a server for two mobile applications. I don't know much about CAS... sorry. On Fri, Feb 22, 2013 at 1:58 PM, Anthony wrote: > Did you look into > CAS

[web2py] Tip

Hello everybody! Well, I still have not solved the problem with stored procedures in MySQL, but I need to continue the project and I solved another issue, the user login to the same database by another application. I will leave my tip here and ask for more experienced developers evaluate and give

Re: [web2py] Re: Error db._adapter

"/home/ctx/PROJECTS/WEB/web2py/gluon/dal.py", line 588, in reconnect self.cursor = cursor and self.connection.cursor() AttributeError: 'NoneType' object has no attribute 'cursor' On Fri, Feb 22, 2013 at 9:12 AM, __pyslan__ - Ayslan Jenken < ayslan.pyt.

Re: [web2py] Re: Error db._adapter

gt; >> Sorry... >> >> The error occur on line 3 of this file: >> >> https://gist.github.com/**pyslan/5007722<https://gist.github.com/pyslan/5007722> >> >> >> On Thu, Feb 21, 2013 at 4:45 PM, __pyslan__ - Ayslan Jenken < >> ayslan.

Re: [web2py] Re: Error db._adapter

013 9:07:25 PM UTC+1, __pyslan__ wrote: > >> Sorry... >> >> The error occur on line 3 of this file: >> >> https://gist.github.com/**pyslan/5007722<https://gist.github.com/pyslan/5007722> >> >> >> On Thu, Feb 21, 2013 at 4:45 PM, __pyslan__ - A

[web2py] Re: Error db._adapter

Sorry... The error occur on line 3 of this file: https://gist.github.com/pyslan/5007722 On Thu, Feb 21, 2013 at 4:45 PM, __pyslan__ - Ayslan Jenken < ayslan.pyt...@gmail.com> wrote: > Hello, Erevybody! > > I am using MySQL on a project and created two procedures to perfor

[web2py] Error db._adapter

Hello, Erevybody! I am using MySQL on a project and created two procedures to perform a recursion, because users have users parents. The extra fields in the users table: https://gist.github.com/pyslan/5007384 Performing some research and testing, I came to the code as follows: https://gist.gith

Re: [web2py] Many to Many relation

Very good, Anthony, very good! Thanks!! On Sat, Jan 26, 2013 at 7:17 PM, Anthony wrote: > Option 3: https://groups.google.com/d/msg/web2py/CRPySzABQTk/8jylUabyFTQJ > > Anthony > > > On Saturday, January 26, 2013 12:35:26 PM UTC-5, rochacbruno wrote: >> >> I can think on two options. >> >> *1.

Re: [web2py] Many to Many relation

Work, man. Thanks a lot!! On Sat, Jan 26, 2013 at 4:12 PM, Bruno Rocha wrote: > the grid has onvalidation argument. > > > SQLFORM.grid(..., onvalidation=check_unique) > > -- > > > > --

Re: [web2py] Many to Many relation

Bruno, I like the second option, but I take a look: def workers(): make_menu('Ventures') venture_name = '' venture_id = '' fields = [] btn_back = None if request.args(0): if not session.url_back: try: btn_back = make_button_text(" " + T

Re: [web2py] Re: Required Field Error.

1:56 PM, __pyslan__ - Ayslan Jenken < ayslan.pyt...@gmail.com> wrote: > Anthony, work fine, man! > > Reading the web2py book I realized that the problem was in requires and > not in required, but had not understood well what he expects. Now yes! I > also didn't know abo

[web2py] Many to Many relation

I have a relation many-to-many. How to prevent the insertion or alterations of duplicate pairs? Thanks... --

Re: [web2py] Re: Required Field Error.

Anthony, work fine, man! Reading the web2py book I realized that the problem was in requires and not in required, but had not understood well what he expects. Now yes! I also didn't know about the argument _represent! Thank you very much, man! On Sat, Jan 26, 2013 at 1:31 PM, Anthony wrote:

Re: [web2py] Required Field Error.

A information: I'm using SQLFORM.grid... On Sat, Jan 26, 2013 at 12:05 PM, __pyslan__ - Ayslan Jenken < ayslan.pyt...@gmail.com> wrote: > Hi, Bruno! > > Yes, is SQLite... But the default for "required" argument is False , > don't? Even so I added the &quo

Re: [web2py] Required Field Error.

anged required from True to False? > > SQLite does not have ALTER for column type and constraints. > Em 26/01/2013 10:04, "__pyslan__ - Ayslan Jenken" > escreveu: > >> My models: >> >> LogrType = db.define_table('logr_type', >>

Re: [web2py] Re: SQLFORM.grid with reference

Hello, Massimo. I did what you asked me to. Follow the issue: 1274<http://code.google.com/p/web2py/issues/detail?id=1274&sort=-id> Thanks!! On Sun, Jan 13, 2013 at 1:54 PM, __pyslan__ - Ayslan Jenken < ayslan.pyt...@gmail.com> wrote: > Ok. > > Thanks! > > &g

Re: [web2py] Re: SQLFORM.grid with reference

(all lower cases in your case). > > About 2) Please open a ticket in googlecode and link this thread. Will > look into it asap. > > > > On Friday, 11 January 2013 11:35:27 UTC-6, __pyslan__ wrote: > >> I updated now to version 2.3.2 and nothing changed. >> >

Re: [web2py] Re: SQLFORM.grid with reference

I updated now to version 2.3.2 and nothing changed. On Fri, Jan 11, 2013 at 3:28 PM, __pyslan__ - Ayslan Jenken < ayslan.pyt...@gmail.com> wrote: > Hi, Massimo. > > Thanks for your help, but... > > 1) - not work > > 2) - Version 2.2.1 (2012-10-21 16:57:04) stab

[web2py] SQLFORM.grid with reference

Hello, everyone. I have the following Models: Category = db.define_table('category', Field('categ_id', 'integer', notnull=True, label=T('Category')), Field('name', 'string', notnull=True, label=T('Name')), format="%(name)s" ) Reading = db.define_table('reading',