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

chat.freenode.net #tryton log beginning Thu Jun 7 00:00:02 CEST 2012
grek324I 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.08:29
grek324Now 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.08:30
grek324I created now an new address with the same informations inside but that is not working08:31
grek324The 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.', ''))08:32
grek324What can I do?08:32
-!- grek324(~johannes@91.183.32.14) has left #tryton08:56
sharoonthomasgrek324: do you have access to your database on the command line ?10:16
sharoonthomasgrek324: if you can execute sql against your database, just update the record's address id with the id of the new address you created.10:17
cedkgrek324: what kind of database are you using?10:19
grek324cedk: postgres10:46
grek324sharoonthomas: tryton is still working on 2.0 - but I cannot make update to 2.4 because of this - thats the main problem10:47
cedkgrek324: it is a strange problem because there is a foreign key on the delivery_address with "ON DELETE RESTRICT"10:48
cedkwhich meanse you can not remove address that is used on shipment10:48
grek324cedk: I delete before the invice was payed10:49
grek324cedk: maybe thats the reason, because shipping created after paying invoice10:50
cedkgrek324: no10:50
cedkgrek324: just set an address on the shipemnt10:51
grek324cedk: cannot set to draft because ot that error10:51
cedkgrek324: how did you delete the address?10:52
grek324cedk: In Party of that customer10:53
cedkgrek324: I don't understand how it was possible, but any way, just update the table and set correctly the delivery_address10:56
grek324cedk: I will try, but how can I find the correct table in database?10:58
cedkgrek324: it is stock_shipment_out11:00
cedkgrek324: and addresses are in party_address11:00
grek324cedk: thanks11:01
grek324what is the correct command to set the "delivery_address" (integer) in  "stock_shipment_out" from "152" to "153" ?12:07
cedkgrek324: in SQL ?12:08
bechamelgrek324: something like: UPDATE stock_shipment_out SET delivery_address=XX WHERE id in (152, 153)12:09
cedkhttp://www.postgresql.org/docs/current/static/sql-update.html12:09
bechamelgrek324: does it work ?12:47
grek324i test it now13:04
grek324bechamel: why delivery_address=XX?13:13
grek324 bechamel: its on ID 15113:14
grek324UPDATE stock_shipment_out SET delivery_address = 153 WHERE id = 15113:18
grek324delivery-address ist now on the new adress, but the error still appears in programm, but not on database update13:25
grek324also tried to set delivery_address in stock_shipment_out to invoice_address13:27
grek324It always shows only the old address in shippment13:27
grek324ist working now13:30
grek324*its13:30
grek324I choosed the wrong id13:37
grek324thx for help13:38
bechamelgrek324: you are welcome :)13:56
grek324What 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".18:07
-!- grek324(~johannes@91.183.32.14) has left #tryton22:12
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.23:44
kwmiebachquil8__, I am curious what went wrong for you?23:52
kwmiebachalso try at different tims here in the chanel. today was holiday in some countries, and it is midnight now in belgium23:55

Generated by irclog2html.py 2.11.0 by Marius Gedminas - find it at mg.pov.lt!