IRC logs of #tryton for Thursday, 2012-06-07

chat.freenode.net #tryton log beginning Thu Jun 7 00:00:02 CEST 2012
2012-06-07 08:29 <grek324> I have some problems with a sale and his shippment. I made a sale and an invoice with seperat sale an shipping adress. Then the customer called and say only one adress is nessesary so I delete the shipping adress.
2012-06-07 08:30 <grek324> Now the shippmentcan't be canceld, set to draft or assigned because the delivery address no longer exists: The value of the field "Delivery Address" on "Customer Shipment" is not valid according to its domain.
2012-06-07 08:31 <grek324> I created now an new address with the same informations inside but that is not working
2012-06-07 08:32 <grek324> The problem is also, that I cannot even make a database update: trytond.exceptions.UserError: ('UserError', (u'The value of the field "Shipment Address" on "Sale" is not valid according to its domain.', ''))
2012-06-07 08:32 <grek324> What can I do?
2012-06-07 08:56 -!- grek324(~johannes@91.183.32.14) has left #tryton
2012-06-07 10:16 <sharoonthomas> grek324: do you have access to your database on the command line ?
2012-06-07 10:17 <sharoonthomas> grek324: if you can execute sql against your database, just update the record's address id with the id of the new address you created.
2012-06-07 10:19 <cedk> grek324: what kind of database are you using?
2012-06-07 10:46 <grek324> cedk: postgres
2012-06-07 10:47 <grek324> sharoonthomas: tryton is still working on 2.0 - but I cannot make update to 2.4 because of this - thats the main problem
2012-06-07 10:48 <cedk> grek324: it is a strange problem because there is a foreign key on the delivery_address with "ON DELETE RESTRICT"
2012-06-07 10:48 <cedk> which meanse you can not remove address that is used on shipment
2012-06-07 10:49 <grek324> cedk: I delete before the invice was payed
2012-06-07 10:50 <grek324> cedk: maybe thats the reason, because shipping created after paying invoice
2012-06-07 10:50 <cedk> grek324: no
2012-06-07 10:51 <cedk> grek324: just set an address on the shipemnt
2012-06-07 10:51 <grek324> cedk: cannot set to draft because ot that error
2012-06-07 10:52 <cedk> grek324: how did you delete the address?
2012-06-07 10:53 <grek324> cedk: In Party of that customer
2012-06-07 10:56 <cedk> grek324: I don't understand how it was possible, but any way, just update the table and set correctly the delivery_address
2012-06-07 10:58 <grek324> cedk: I will try, but how can I find the correct table in database?
2012-06-07 11:00 <cedk> grek324: it is stock_shipment_out
2012-06-07 11:00 <cedk> grek324: and addresses are in party_address
2012-06-07 11:01 <grek324> cedk: thanks
2012-06-07 12:07 <grek324> what is the correct command to set the "delivery_address" (integer) in "stock_shipment_out" from "152" to "153" ?
2012-06-07 12:08 <cedk> grek324: in SQL ?
2012-06-07 12:09 <bechamel> grek324: something like: UPDATE stock_shipment_out SET delivery_address=XX WHERE id in (152, 153)
2012-06-07 12:09 <cedk> http://www.postgresql.org/docs/current/static/sql-update.html
2012-06-07 12:47 <bechamel> grek324: does it work ?
2012-06-07 13:04 <grek324> i test it now
2012-06-07 13:13 <grek324> bechamel: why delivery_address=XX?
2012-06-07 13:14 <grek324> bechamel: its on ID 151
2012-06-07 13:18 <grek324> UPDATE stock_shipment_out SET delivery_address = 153 WHERE id = 151
2012-06-07 13:25 <grek324> delivery-address ist now on the new adress, but the error still appears in programm, but not on database update
2012-06-07 13:27 <grek324> also tried to set delivery_address in stock_shipment_out to invoice_address
2012-06-07 13:27 <grek324> It always shows only the old address in shippment
2012-06-07 13:30 <grek324> ist working now
2012-06-07 13:30 <grek324> *its
2012-06-07 13:37 <grek324> I choosed the wrong id
2012-06-07 13:38 <grek324> thx for help
2012-06-07 13:56 <bechamel> grek324: you are welcome :)
2012-06-07 18:07 <grek324> What can I do to get the old way back, that I can open sales or articles in two or more times? I used this very often an miss this "feature".
2012-06-07 22:12 -!- grek324(~johannes@91.183.32.14) has left #tryton
2012-06-07 23:44 <quil8__> I'm considering Tryton after having a bad OpenERP experience. How stable/complete is the accounting module for use in Canada? The OpenERP one was completely f***ed.
2012-06-07 23:52 <kwmiebach> quil8__, I am curious what went wrong for you?
2012-06-07 23:55 <kwmiebach> also try at different tims here in the chanel. today was holiday in some countries, and it is midnight now in belgium

Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!