I'm trying to move an app from a old version of web2py (2.14) to latest 
version. After updating some code i'm stuck on the error below. 

If i remove the left join the query works. And I dont find anything about 
changes on 'left' syntax.

Someone knows whats wrong?

<type 'exceptions.TypeError'> left_join() takes exactly 2 arguments (3 
given)

Traceback

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.

Traceback (most recent call last):
  File "C:\Users\fiscal\Desktop\web2py\gluon\restricted.py", line 219, in 
restricted
    exec(ccode, environment)
  File 
"C:\Users\fiscal\Desktop\web2py\applications\manager\controllers/atendimento.py",
 line 3014, in <module>
  File "C:\Users\fiscal\Desktop\web2py\gluon\globals.py", line 421, in <lambda>
    self._caller = lambda f: f()
  File "C:\Users\fiscal\Desktop\web2py\gluon\tools.py", line 3868, in f
    return action(*a, **b)
  File 
"C:\Users\fiscal\Desktop\web2py\applications\manager\controllers/atendimento.py",
 line 100, in dashboardInicial
    orderby=~dbOracle.OSC.chave
  File "C:\Users\fiscal\Desktop\web2py\gluon\packages\dal\pydal\objects.py", 
line 2378, in select
    return adapter.select(self.query, fields, attributes)
  File 
"C:\Users\fiscal\Desktop\web2py\gluon\packages\dal\pydal\adapters\base.py", 
line 758, in select
    colnames, sql = self._select_wcols(query, fields, **attributes)
  File 
"C:\Users\fiscal\Desktop\web2py\gluon\packages\dal\pydal\adapters\base.py", 
line 651, in _select_wcols
    tokens += [self.dialect.left_join(t, query_env) for t in join_on]
TypeError: left_join() takes exactly 2 arguments (3 given)


Query:

resultado= dbOracle(query
                        &(dbOracle.OSC.chave_cliente == 
dbOracle.clientes.codcli) &(dbOracle.OSC.chave_tecnico == 
dbOracle.tecnicos.chave)
                        &(dbOracle.OSC.chave_tag == dbOracle.tag.chave) 
&(dbOracle.tag.chave_produto==dbOracle.produtos.cprod)
                        &(dbOracle.tipos_chamados.chave == 
dbOracle.OSC.chave_tipo_chamado)
                        ).select(dbOracle.OSC.chave, 
dbOracle.OSC.data_emissao,  dbOracle.tag.numero_serie , dbOracle.tag.chave,
                                dbOracle.clientes.nome, 
dbOracle.clientes.codcli, dbOracle.OSC.sla,  
dbOracle.OSC.previsao_atendimento , dbOracle.OSC.time_abertura 
,dbOracle.OSC.time_atendimento ,

                                [MANY OTHER FIELDS],

                                left=  
[dbOracle.pedidos_contratos.on(dbOracle.OSC.chave_contrato==dbOracle.pedidos_contratos.chave),
 
dbOracle.tecnicos_zonas.on(dbOracle.OSC.chave_tecnico==dbOracle.tecnicos_zonas.chave_tecnico),
 
dbOracle.territorios.on(dbOracle.tecnicos_zonas.chave_territorio==dbOracle.territorios.chave)],
                                orderby=~dbOracle.OSC.chave
                        )

-- 
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.

Reply via email to