Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

DataError: invalid input syntax for integer: "Administrator"

By
Apoorv Soral
on 11/22/16, 7:29 AM 119 views

2016-11-22 12:16:06,462 13933 ERROR SREPL_Prashant openerp.sql_db: bad query: INSERT INTO "confirm_auction" ("id", "amt_bid", "date_bid", "product_id", "customer_auc_id", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('confirm_auction_id_seq'), 2550.0, '2016-11-22', ' Aluminium Busbar 25x5x230mm (B)', 'Administrator', 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING idTraceback (most recent call last):
  File "/home/pchouksey1/workspace/dexciss/core/openerp/sql_db.py", line 234, in execute    res = self._obj.execute(query, params)

DataError: invalid input syntax for integer: "Administrator"LINE 1: ...'2016-11-22', ' Aluminium Busbar 25x5x230mm (B)', 'Administr...
                                                             ^
2016-11-22 12:16:06,463 13933 ERROR SREPL_Prashant openerp.http: Exception during JSON request handling.
Traceback (most recent call last):
  File "/home/pchouksey1/workspace/dexciss/core/openerp/http.py", line 543, in _handle_exception    return super(JsonRequest, self)._handle_exception(exception)  File "/home/pchouksey1/workspace/dexciss/core/openerp/http.py", line 580, in dispatch    result = self._call_function(**self.params)  File "/home/pchouksey1/workspace/dexciss/core/openerp/http.py", line 316, in _call_function    return checked_call(self.db, *args, **kwargs)  File "/home/pchouksey1/workspace/dexciss/core/openerp/service/model.py", line 118, in wrapper    return f(dbname, *args, **kwargs)  File "/home/pchouksey1/workspace/dexciss/core/openerp/http.py", line 313, in checked_call    return self.endpoint(*a, **kw)  File "/home/pchouksey1/workspace/dexciss/core/openerp/http.py", line 809, in __call__    return self.method(*args, **kw)  File "/home/pchouksey1/workspace/dexciss/core/openerp/http.py", line 409, in response_wrap    response = f(*args, **kw)  File "/home/pchouksey1/workspace/dexciss/core/addons/web/controllers/main.py", line 948, in call_button    action = self._call_kw(model, method, args, {})  File "/home/pchouksey1/workspace/dexciss/core/addons/web/controllers/main.py", line 936, in _call_kw    return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)  File "/home/pchouksey1/workspace/dexciss/core/openerp/api.py", line 268, in wrapper    return old_api(self, *args, **kwargs)  File "/home/pchouksey1/workspace/dexciss/core/openerp/api.py", line 439, in old_api    result = new_api(recs, *args, **kwargs)  File "/home/pchouksey1/workspace/dexciss/core/openerp/api.py", line 443, in new_api    result = [method(rec, *args, **kwargs) for rec in self]  File "/home/pchouksey1/workspace/dexciss/repo/auction/auction.py", line 113, in bid_confirm    'amt_bid':self.amount_auc  File "/home/pchouksey1/workspace/dexciss/core/openerp/api.py", line 266, in wrapper    return new_api(self, *args, **kwargs)  File "/home/pchouksey1/workspace/dexciss/repo/web_auto_refresh/web_auto_refresh.py", line 48, in create    record_id = create_original(self, vals)  File "/home/pchouksey1/workspace/dexciss/core/openerp/api.py", line 266, in wrapper    return new_api(self, *args, **kwargs)  File "/home/pchouksey1/workspace/dexciss/repo/connector/producer.py", line 48, in create    record_id = create_original(self, vals)  File "/home/pchouksey1/workspace/dexciss/core/openerp/api.py", line 266, in wrapper    return new_api(self, *args, **kwargs)  File "/home/pchouksey1/workspace/dexciss/core/openerp/models.py", line 4100, in create    record = self.browse(self._create(old_vals))  File "/home/pchouksey1/workspace/dexciss/core/openerp/api.py", line 266, in wrapper    return new_api(self, *args, **kwargs)  File "/home/pchouksey1/workspace/dexciss/core/openerp/api.py", line 508, in new_api    result = method(self._model, cr, uid, *args, **old_kwargs)  File "/home/pchouksey1/workspace/dexciss/core/openerp/models.py", line 4244, in _create    tuple([u[2] for u in updates if len(u) > 2])  File "/home/pchouksey1/workspace/dexciss/core/openerp/sql_db.py", line 158, in wrapper    return f(self, *args, **kwargs)  File "/home/pchouksey1/workspace/dexciss/core/openerp/sql_db.py", line 234, in execute    res = self._obj.execute(query, params)

DataError: invalid input syntax for integer: "Administrator"LINE 1: ...'2016-11-22', ' Aluminium Busbar 25x5x230mm (B)', 'Administr...


==========================================================================================

_name = "bid"   

_rec_name = "auc_id"   

auc_id = fields.Char("Auction Id", readonly = True)   

product_id = fields.Char("Product",readonly= True)   

amount_auc = fields.Float("Amount")   

state= fields.Selection([('publish','Publish'),('cancel','Cancel'),('done','Done')],'Status',readonly=True,copy=False,select=True,default='draft')        

@api.one   

def bid_confirm(self):
                date =  time.strftime("%Y-%m-%d")

               partner = self.env['res.users'].browse(self.env.uid)               

                auc = self.env['auction'].search([('auction_id','=',self.auc_id)])                

                res = self.env['confirm.auction'].create({

                            'conf_auc_id':auc.id, 

                             'product_id':self.product_id,

                            'customer_auc_id':partner.name,

                            'date_bid':date,

                            'amt_bid':self.amount_auc               

})

self.write({'state':'done'})


=======================================================================================================

_name = "confirm.auction"    

product_id = fields.Char("Product", readonly = True)   

customer_auc_id = fields.Many2one("res.user","Customer", readonly = True)
date_bid = fields.Date("Bid Date", readonly = True)   

amt_bid = fields.Float("Bid Amount", readonly = True)   

conf_auc_id = fields.Many2one("auction","Auction")

======================================================================================================


_name = "auction"   

_rec_name = 'auction_id'   

auction_id = fields.Char("Auction Number")   

start_auc_date = fields.Date("Auction Start Date")   

end_auc_date = fields.Date("Auction End Date")   

state= fields.Selection([('draft','Draft'), ('publish','Publish'),('cancel','Cancel'),('done','Done') ],'Status',readonly=True,copy=False,select=True,default='draft')       

auc_product_id = fields.One2many("auction.product","auc_id","Product")   

auc_confirm_id = fields.One2many("confirm.auction","conf_auc_id")



0
Sarga
On 11/22/16, 9:27 AM

Hi,

Just change value for key customer_auc_id: partner.id in duct your passing to create confirm auction and I can't find a field auc_confirm_id defined in confirm.auction model

Hi Sarga

oh sorry there is not auc_confirm_id field there is conf_auc_id m2o field

Issue is how to assign value in m2o field i'm doing this.

res = self.env['confirm.auction'].create({

'conf_auc_id':auc.id,

'product_id':self.product_id,

'customer_auc_id.id':partner.name,

'date_bid':date,

'amt_bid':self.amount_auc

})

problem is not assign value of partner.id in customer_auc_id.id this is M2o field of "res.user".

Apoorv Soral
on 11/23/16, 1:59 AM

Hi apoorv,

For assigning value to a many to one field you should pass id as in database all many to one fields stored as integer fields.. So if my field is

login_user then I should assign login_user : uid where uid is integer( user id)

Sarga
on 11/23/16, 7:39 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 11/22/16, 7:29 AM
Seen: 119 times
Last updated: 11/23/16, 2:01 AM