| 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/!