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

I have a lot of "bad query" errors in odoo log, this are some errors I want your opinion "read all please"!

By
Nefi Lopez Garcia
on 5/26/16, 9:22 PM 529 views

I changed my database to other server, because the pass server was failed, and I coudn't recover my information, I was lucky, I had a DB backup of a week back


2016-05-27 00:09:10,015 11612 INFO Arsabe openerp.sql_db: bad query: INSERT INTO "account_bank_statement_line" ("id", "account_id", "statement_id", "sequence", "ref", "pos_statement_id", "journal_id", "amount", "date", "partner_id", "name", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('account_bank_statement_line_id_seq'), 7, 326, 1,

'POS/2016/05/26/309', 19135, 9, 20.0, '2016-05-27', 30, 'MADERO CAJA 3 PUBLICO/3984: ', 16, 16, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id

2016-05-27 00:09:10,015 11612 INFO Arsabe openerp.service.model: SERIALIZATION_FAILURE, retry 1/5 in 0.0373 sec...

2016-05-23 19:47:57,428 11612 INFO Arsabe openerp.sql_db: bad query: UPDATE "product_product" SET "barcode"='7501755553337',"write_uid"=1,"write_date"=(now() at time zone 'UTC') WHERE id IN (18444)


2016-05-24 14:27:03,515 11612 INFO Arsabe openerp.sql_db: bad query: delete from ir_attachment where id IN (5461, 5460)

2016-05-24 14:27:03,516 11612 INFO Arsabe openerp.service.model: SERIALIZATION_FAILURE, retry 1/5 in 0.7626 sec...

2016-05-24 16:21:24,098 11612 INFO Arsabe openerp.sql_db: bad query: delete from stock_picking where id IN (11001)

this is a big problem, I want your opinion 

right now I saw a product with a internal reference in point of sale/products and purchases/OP have another name but its the same internal reference, can you help me? please


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: 5/26/16, 9:22 PM
Seen: 529 times
Last updated: 5/27/16, 1:11 AM