| chat.freenode.net #tryton log beginning Tue Jun 22 00:00:02 CEST 2010 | ||
| 2010-06-22 00:25 -!- Timitos(~timitos@88.217.184.172) has joined #tryton | ||
| 2010-06-22 01:47 -!- yangoon(~mathiasb@p549F70E5.dip.t-dialin.net) has joined #tryton | ||
| 2010-06-22 01:59 -!- zodman(~zodman@foresight/developer/zodman) has joined #tryton | ||
| 2010-06-22 02:30 -!- ikks(~ikks@200.118.243.193) has joined #tryton | ||
| 2010-06-22 03:00 -!- zodman(~zodman@foresight/developer/zodman) has joined #tryton | ||
| 2010-06-22 04:09 -!- juanfer(~juanfer@190.25.54.252) has joined #tryton | ||
| 2010-06-22 04:28 -!- zodman(~zodman@foresight/developer/zodman) has joined #tryton | ||
| 2010-06-22 05:19 -!- yangoon(~mathiasb@p549F6E3A.dip.t-dialin.net) has joined #tryton | ||
| 2010-06-22 07:06 -!- mr_amit(~amit@117.254.178.73) has joined #tryton | ||
| 2010-06-22 07:18 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2010-06-22 08:06 -!- paepke(~paepke@p4FEB0154.dip0.t-ipconnect.de) has joined #tryton | ||
| 2010-06-22 08:10 -!- enlightx(~enlightx@static-217-133-61-144.clienti.tiscali.it) has joined #tryton | ||
| 2010-06-22 09:18 -!- Shalabh_OL1(~shalabh@122.176.50.143) has joined #tryton | ||
| 2010-06-22 09:19 -!- Shalabh_OL1(~shalabh@122.176.50.143) has left #tryton | ||
| 2010-06-22 09:23 -!- shalabh_OL(~shalabh@122.176.50.143) has joined #tryton | ||
| 2010-06-22 09:25 <shalabh_OL> i tried to save some data in a text field. An error popped up saying "OperationalError: index row requires 16668 bytes, maximum size is 8191". | ||
| 2010-06-22 09:25 <shalabh_OL> What is this error about and how to deal with it? | ||
| 2010-06-22 09:33 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2010-06-22 09:44 <shalabh_OL> cedk: i tried to save some data in a text field. An error popped up saying "OperationalError: index row requires 16668 bytes, maximum size is 8191". | ||
| 2010-06-22 09:44 <shalabh_OL> What is this error about and how to deal with it? | ||
| 2010-06-22 09:45 -!- Timitos(~timitos@88.217.184.172) has joined #tryton | ||
| 2010-06-22 09:48 -!- paepke(~paepke@p4FEB0154.dip0.t-ipconnect.de) has joined #tryton | ||
| 2010-06-22 09:48 <cedk> shalabh_OL: are you using MySQL as backend? | ||
| 2010-06-22 09:48 <shalabh_OL> cedk: no, postgres | ||
| 2010-06-22 09:49 <cedk> shalabh_OL: what is the lenght of the text? | ||
| 2010-06-22 09:53 -!- bechamel(~user@chimie-prtx11.scf.fundp.ac.be) has joined #tryton | ||
| 2010-06-22 09:57 <shalabh_OL> cedk: cant be exact, but it is a lot of text, it is about 68 KB in a .txt file | ||
| 2010-06-22 09:59 <udono> shalabh_OL: did you put select= in fields definition for this field? | ||
| 2010-06-22 10:00 <udono> shalabh_OL: is there an index created for this field in postgres? | ||
| 2010-06-22 10:01 <shalabh_OL> udono: it has select=True in the fields definition | ||
| 2010-06-22 10:02 <udono> shalabh_OL: this won't work for long field content. Remove it from the fields definition, update the database and put the select into the xml fields definition, when you want to have it in the search, but without an index. | ||
| 2010-06-22 10:04 -!- eLBati(~elbati@94.162.24.54) has joined #tryton | ||
| 2010-06-22 10:04 <udono> shalabh_OL: maybe you need to write a migration for removing the select from fields definition in *.py, but I'am unsure about this. | ||
| 2010-06-22 10:06 <shalabh_OL> udono: i ll try doing it | ||
| 2010-06-22 10:08 <shalabh_OL> udono: thnx it worked. | ||
| 2010-06-22 10:09 <udono> shalabh_OL: welcome | ||
| 2010-06-22 10:09 -!- Red15(~red15@unaffiliated/red15) has joined #tryton | ||
| 2010-06-22 10:15 <paepke> is it possible to add additional fields to a many2many relation table and access it via a view? | ||
| 2010-06-22 10:17 <paepke> i was looking for examples, but did not find anything. | ||
| 2010-06-22 10:17 <paepke> can someone give me a hint to an existing module? | ||
| 2010-06-22 10:18 <cedk> paepke: yes it is a model like others | ||
| 2010-06-22 10:18 <cedk> paepke: but you must be sure it has ModelView to display it in the client | ||
| 2010-06-22 10:19 <paepke> cedk, i added modelView, but how to address it? should i use that model instead of the original target? | ||
| 2010-06-22 10:20 <paepke> cedk, that just came to my mind ;-) | ||
| 2010-06-22 10:21 <cedk> paepke: don't know | ||
| 2010-06-22 10:21 <cedk> paepke: I never tried | ||
| 2010-06-22 10:22 <paepke> cedk, i'll try to enhance the connection between two models with additional information(fields) hope that is the right direction. | ||
| 2010-06-22 10:22 <paepke> cedk, i'll give it a try. | ||
| 2010-06-22 10:24 <cedk> paepke: we tried to design for this purpose but not yet find a case to use it :-( | ||
| 2010-06-22 10:26 <paepke> cedk, i have currently the case for a connection between a product and a party. different customers have different names for that product. | ||
| 2010-06-22 10:26 <paepke> cedk, but internally its the same product | ||
| 2010-06-22 10:27 <cedk> paepke: you must use the supplierinfo | ||
| 2010-06-22 10:28 <cedk> paepke: I mean purchase.product_supplier | ||
| 2010-06-22 10:29 <paepke> cedk, supplierinfo? | ||
| 2010-06-22 10:29 <cedk> paepke: supplierinfo is the OE name :-) | ||
| 2010-06-22 10:29 <paepke> cedk, intresting. i take a look into it. but its not connected to a purchase in my case | ||
| 2010-06-22 10:32 <cedk> paepke: ha yes, I readed supplier instead of customer | ||
| 2010-06-22 10:32 <paepke> cedk, its normal cause that is mostly related to supplier | ||
| 2010-06-22 10:33 <paepke> cedk, i have to use the other way round. | ||
| 2010-06-22 10:34 <paepke> cedk, is the same already there for "sale"? | ||
| 2010-06-22 10:34 <cedk> paepke: no because it is realy not a standard way :-) | ||
| 2010-06-22 10:35 <paepke> cedk, :-) yes, agree. | ||
| 2010-06-22 10:36 <paepke> cedk, anyway its a good hint where to look for examples for my special case | ||
| 2010-06-22 10:40 <cedk> paepke: you can try to make a generic module that could be included in standard set | ||
| 2010-06-22 10:45 <paepke> cedk, well maybe. have to look how generic it can be. i'd like to be famous and have a module in the standard set :-) | ||
| 2010-06-22 10:52 -!- shalabh_OL(~shalabh@122.176.50.143) has joined #tryton | ||
| 2010-06-22 11:00 <paepke> cedk, what is the use of that product.template vs. product.product? ok, it inherits. but why was it devided? | ||
| 2010-06-22 11:00 <udono> paepke it is done to have the possibility to make variants from product templates in a further module. | ||
| 2010-06-22 11:02 <udono> but for the moment each product refers to its own template. | ||
| 2010-06-22 11:06 <paepke> udono, ok, the standard way for now is to modify that product.template to have it in every product. | ||
| 2010-06-22 11:08 <udono> paepke: no, take a look to the tables product_product and product_template. As I said, each product refers to its own template | ||
| 2010-06-22 11:13 -!- tekknokrat(~lila@dslb-094-223-095-014.pools.arcor-ip.net) has joined #tryton | ||
| 2010-06-22 11:16 <paepke> udono, understand. i'm digging through the tables. its getting clearer | ||
| 2010-06-22 11:21 -!- plantian(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has left #tryton | ||
| 2010-06-22 11:34 -!- shalabh_OL(~shalabh@122.176.50.143) has joined #tryton | ||
| 2010-06-22 11:42 -!- shalabh_OL(~shalabh@122.176.50.143) has joined #tryton | ||
| 2010-06-22 12:12 -!- shalabh_OL(~shalabh@122.176.50.143) has joined #tryton | ||
| 2010-06-22 13:23 -!- shalabh_OL(~shalabh@122.176.50.143) has left #tryton | ||
| 2010-06-22 13:46 -!- ikks(~ikks@200.118.243.193) has joined #tryton | ||
| 2010-06-22 14:37 -!- JamesPharaoh(~james@ed.phsys.co.uk) has joined #tryton | ||
| 2010-06-22 14:41 -!- eLBati(~elbati@94.163.4.150) has joined #tryton | ||
| 2010-06-22 14:53 -!- pepeu(~manuel@201.155.193.192) has joined #tryton | ||
| 2010-06-22 15:46 -!- zodman(~Miranda@67.223.236.231) has joined #tryton | ||
| 2010-06-22 16:27 -!- Red15(~red15@unaffiliated/red15) has joined #tryton | ||
| 2010-06-22 16:49 -!- bugthing(~benjamin@213.131.188.209) has joined #tryton | ||
| 2010-06-22 17:05 -!- pepeu(~manuel@201.155.193.192) has joined #tryton | ||
| 2010-06-22 18:18 -!- plantian(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton | ||
| 2010-06-22 18:25 -!- enlightx(~enlightx@dynamic-adsl-84-220-82-224.clienti.tiscali.it) has joined #tryton | ||
| 2010-06-22 18:33 -!- eLBati(~elbati@94.161.40.120) has joined #tryton | ||
| 2010-06-22 18:42 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2010-06-22 19:28 -!- woakas(~woakas@190.26.105.211) has joined #tryton | ||
| 2010-06-22 19:33 -!- juanfer(~juanfer@190.25.54.252) has joined #tryton | ||
| 2010-06-22 20:34 -!- hoRn(~chatzilla@dslb-094-223-200-033.pools.arcor-ip.net) has joined #tryton | ||
| 2010-06-22 20:34 <hoRn> hi | ||
| 2010-06-22 20:36 <cedk> hoRn: hi | ||
| 2010-06-22 20:37 <hoRn> Hi, nice to meet you | ||
| 2010-06-22 20:37 <cedk> hoRn: I will continue to communicate for your issue on the bugtracker for the record | ||
| 2010-06-22 20:37 <hoRn> ok | ||
| 2010-06-22 20:37 <hoRn> but trytond.log has only the tracback i posted | ||
| 2010-06-22 20:38 <cedk> hoRn: strange | ||
| 2010-06-22 20:39 <hoRn> yes - i set up a fresh database and no error occurs | ||
| 2010-06-22 20:44 <cedk> hoRn: have you the right version of sale module? | ||
| 2010-06-22 20:45 <hoRn> i will take a look | ||
| 2010-06-22 20:45 <hoRn> 1.6.0 | ||
| 2010-06-22 20:46 <cedk> could you re-run the update with -u sale | ||
| 2010-06-22 20:47 <hoRn> ok | ||
| 2010-06-22 20:49 <hoRn> Field arch of 283@ir.ui.view not updated (id: sale_view_form), because it has changed since the last update | ||
| 2010-06-22 20:49 <cedk> hoRn: that is the issue | ||
| 2010-06-22 20:49 <cedk> hoRn: did you make some SQL queries? | ||
| 2010-06-22 20:50 <hoRn> ok - what to do? i don't saw it before | ||
| 2010-06-22 20:50 <hoRn> what sql-queries? | ||
| 2010-06-22 20:50 <cedk> hoRn: first it will be good to understand why the record changed because it is not allowed to change it from the client | ||
| 2010-06-22 20:52 <cedk> hoRn: did you installed non-standard modules? | ||
| 2010-06-22 20:52 <hoRn> no idea - but there are many people working in this projekt | ||
| 2010-06-22 20:52 <hoRn> yes - i have installed a own module | ||
| 2010-06-22 20:53 <cedk> hoRn: that is perhaps his fault :-) | ||
| 2010-06-22 20:53 <cedk> hoRn: to correct it you can simply delete the view with id 283 and re-run the update | ||
| 2010-06-22 20:53 <cedk> hoRn: Tryton will recreate it | ||
| 2010-06-22 20:53 <hoRn> hoe do i delete it? | ||
| 2010-06-22 20:54 <cedk> hoRn: if I can see your code I could perhaps help you to find the issue | ||
| 2010-06-22 20:54 <cedk> hoRn: with SQL query | ||
| 2010-06-22 20:55 <hoRn> i will check | ||
| 2010-06-22 20:58 <hoRn> great (dance) - thank you | ||
| 2010-06-22 20:58 <hoRn> fixed | ||
| 2010-06-22 20:58 <hoRn> and learned a bit | ||
| 2010-06-22 21:01 <cedk> hoRn: good for you :-) | ||
| 2010-06-22 21:02 <hoRn> we are doing a nice project with tryton - its a good peace of software | ||
| 2010-06-22 21:12 -!- paepke(~paepke@p4FEB0154.dip0.t-ipconnect.de) has left #tryton | ||
| 2010-06-22 22:34 -!- eLBati(~elbati@94.163.36.74) has joined #tryton | ||
| 2010-06-22 22:37 -!- zodman(~zodman@foresight/developer/zodman) has joined #tryton | ||
| 2010-06-22 23:23 -!- udono(~udono@dynamic-unidsl-85-197-22-195.westend.de) has joined #tryton | ||
| 2010-06-22 23:39 -!- sharkcz(~sharkcz@plz1-v-4-17.static.adsl.vol.cz) has joined #tryton | ||
| 2010-06-22 23:42 -!- plantian(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!