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")
