IRC logs of #tryton for Tuesday, 2010-06-22

chat.freenode.net #tryton log beginning Tue Jun 22 00:00:02 CEST 2010
-!- Timitos(~timitos@88.217.184.172) has joined #tryton00:25
-!- yangoon(~mathiasb@p549F70E5.dip.t-dialin.net) has joined #tryton01:47
-!- zodman(~zodman@foresight/developer/zodman) has joined #tryton01:59
-!- ikks(~ikks@200.118.243.193) has joined #tryton02:30
-!- zodman(~zodman@foresight/developer/zodman) has joined #tryton03:00
-!- juanfer(~juanfer@190.25.54.252) has joined #tryton04:09
-!- zodman(~zodman@foresight/developer/zodman) has joined #tryton04:28
-!- yangoon(~mathiasb@p549F6E3A.dip.t-dialin.net) has joined #tryton05:19
-!- mr_amit(~amit@117.254.178.73) has joined #tryton07:06
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton07:18
-!- paepke(~paepke@p4FEB0154.dip0.t-ipconnect.de) has joined #tryton08:06
-!- enlightx(~enlightx@static-217-133-61-144.clienti.tiscali.it) has joined #tryton08:10
-!- Shalabh_OL1(~shalabh@122.176.50.143) has joined #tryton09:18
-!- Shalabh_OL1(~shalabh@122.176.50.143) has left #tryton09:19
-!- shalabh_OL(~shalabh@122.176.50.143) has joined #tryton09:23
shalabh_OLi tried to save some data in a text field. An error popped up saying "OperationalError: index row requires 16668 bytes, maximum size is 8191".09:25
shalabh_OLWhat is this error about and how to deal with it?09:25
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton09:33
shalabh_OLcedk:  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".09:44
shalabh_OLWhat is this error about and how to deal with it?09:44
-!- Timitos(~timitos@88.217.184.172) has joined #tryton09:45
-!- paepke(~paepke@p4FEB0154.dip0.t-ipconnect.de) has joined #tryton09:48
cedkshalabh_OL: are you using MySQL as backend?09:48
shalabh_OLcedk: no, postgres09:48
cedkshalabh_OL: what is the lenght of the text?09:49
-!- bechamel(~user@chimie-prtx11.scf.fundp.ac.be) has joined #tryton09:53
shalabh_OLcedk: cant be exact, but it is a lot of text, it is about 68 KB in a .txt file09:57
udonoshalabh_OL: did you put select= in fields definition for this field?09:59
udonoshalabh_OL: is there an index created for this field in postgres?10:00
shalabh_OLudono: it has select=True in the fields definition10:01
udonoshalabh_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.10:02
-!- eLBati(~elbati@94.162.24.54) has joined #tryton10:04
udonoshalabh_OL: maybe you need to write a migration for removing the select from fields definition in *.py, but I'am unsure about this.10:04
shalabh_OLudono: i ll try doing it10:06
shalabh_OLudono: thnx it worked.10:08
udonoshalabh_OL: welcome10:09
-!- Red15(~red15@unaffiliated/red15) has joined #tryton10:09
paepkeis it possible to add additional fields to a many2many relation table and access it via a view?10:15
paepkei was looking for examples, but did not find anything.10:17
paepkecan someone give me a hint to an existing module?10:17
cedkpaepke: yes it is a model like others10:18
cedkpaepke: but you must be sure it has ModelView to display it in the client10:18
paepkecedk, i added modelView, but how to address it? should i use that model instead of the original target?10:19
paepkecedk, that just came to my mind ;-)10:20
cedkpaepke: don't know10:21
cedkpaepke: I never tried10:21
paepkecedk, i'll try to enhance the connection between two models with additional information(fields) hope that is the right direction.10:22
paepkecedk, i'll give it a try.10:22
cedkpaepke: we tried to design for this purpose but not yet find a case to use it :-(10:24
paepkecedk, i have currently the case for a connection between a product and a party. different customers have different names for that product.10:26
paepkecedk, but internally its the same product10:26
cedkpaepke: you must use the supplierinfo10:27
cedkpaepke: I mean purchase.product_supplier10:28
paepkecedk, supplierinfo?10:29
cedkpaepke: supplierinfo is the OE name :-)10:29
paepkecedk, intresting. i take a look into it. but its not connected to a purchase in my case10:29
cedkpaepke: ha yes, I readed supplier instead of customer10:32
paepkecedk, its normal cause that is mostly related to supplier10:32
paepkecedk, i have to use the other way round.10:33
paepkecedk, is the same already there for "sale"?10:34
cedkpaepke: no because it is realy not a standard way :-)10:34
paepkecedk, :-) yes, agree.10:35
paepkecedk, anyway its a good hint where to look for examples for my special case10:36
cedkpaepke: you can try to make a generic module that could be included in standard set10:40
paepkecedk, well maybe. have to look how generic it can be. i'd like to be famous and have a module in the standard set :-)10:45
-!- shalabh_OL(~shalabh@122.176.50.143) has joined #tryton10:52
paepkecedk, what is the use of that product.template vs. product.product? ok, it inherits. but why was it devided?11:00
udonopaepke it is done to have the possibility to make variants from product templates in a further module.11:00
udonobut for the moment each product refers to its own template.11:02
paepkeudono, ok, the standard way for now is to modify that product.template to have it in every product.11:06
udonopaepke: no, take a look to the tables product_product and product_template. As I said, each product refers to its own template11:08
-!- tekknokrat(~lila@dslb-094-223-095-014.pools.arcor-ip.net) has joined #tryton11:13
paepkeudono, understand. i'm digging through the tables. its getting clearer11:16
-!- plantian(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has left #tryton11:21
-!- shalabh_OL(~shalabh@122.176.50.143) has joined #tryton11:34
-!- shalabh_OL(~shalabh@122.176.50.143) has joined #tryton11:42
-!- shalabh_OL(~shalabh@122.176.50.143) has joined #tryton12:12
-!- shalabh_OL(~shalabh@122.176.50.143) has left #tryton13:23
-!- ikks(~ikks@200.118.243.193) has joined #tryton13:46
-!- JamesPharaoh(~james@ed.phsys.co.uk) has joined #tryton14:37
-!- eLBati(~elbati@94.163.4.150) has joined #tryton14:41
-!- pepeu(~manuel@201.155.193.192) has joined #tryton14:53
-!- zodman(~Miranda@67.223.236.231) has joined #tryton15:46
-!- Red15(~red15@unaffiliated/red15) has joined #tryton16:27
-!- bugthing(~benjamin@213.131.188.209) has joined #tryton16:49
-!- pepeu(~manuel@201.155.193.192) has joined #tryton17:05
-!- plantian(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton18:18
-!- enlightx(~enlightx@dynamic-adsl-84-220-82-224.clienti.tiscali.it) has joined #tryton18:25
-!- eLBati(~elbati@94.161.40.120) has joined #tryton18:33
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton18:42
-!- woakas(~woakas@190.26.105.211) has joined #tryton19:28
-!- juanfer(~juanfer@190.25.54.252) has joined #tryton19:33
-!- hoRn(~chatzilla@dslb-094-223-200-033.pools.arcor-ip.net) has joined #tryton20:34
hoRnhi20:34
cedkhoRn: hi20:36
hoRnHi, nice to meet you20:37
cedkhoRn: I will continue to communicate for your issue on the bugtracker for the record20:37
hoRnok20:37
hoRnbut trytond.log has only the tracback i posted20:37
cedkhoRn: strange20:38
hoRnyes - i set up a fresh database and no error occurs20:39
cedkhoRn: have you the right version of sale module?20:44
hoRni will take a look20:45
hoRn1.6.020:45
cedkcould you re-run the update with -u sale20:46
hoRnok20:47
hoRnField arch of 283@ir.ui.view not updated (id: sale_view_form), because it has changed since the last update20:49
cedkhoRn: that is the issue20:49
cedkhoRn: did you make some SQL queries?20:49
hoRnok - what to do? i don't saw it before20:50
hoRnwhat sql-queries?20:50
cedkhoRn: first it will be good to understand why the record changed because it is not allowed to change it from the client20:50
cedkhoRn: did you installed non-standard modules?20:52
hoRnno idea - but there are many people working in this projekt20:52
hoRnyes - i have installed a own module20:52
cedkhoRn: that is perhaps his fault :-)20:53
cedkhoRn: to correct it you can simply delete the view with id 283 and re-run the update20:53
cedkhoRn: Tryton will recreate it20:53
hoRnhoe do i delete it?20:53
cedkhoRn: if I can see your code I could perhaps help you to find the issue20:54
cedkhoRn: with SQL query20:54
hoRni will check20:55
hoRngreat (dance) - thank you20:58
hoRnfixed20:58
hoRnand learned a bit20:58
cedkhoRn: good for you :-)21:01
hoRnwe are doing a nice project with tryton  - its a good peace of software21:02
-!- paepke(~paepke@p4FEB0154.dip0.t-ipconnect.de) has left #tryton21:12
-!- eLBati(~elbati@94.163.36.74) has joined #tryton22:34
-!- zodman(~zodman@foresight/developer/zodman) has joined #tryton22:37
-!- udono(~udono@dynamic-unidsl-85-197-22-195.westend.de) has joined #tryton23:23
-!- sharkcz(~sharkcz@plz1-v-4-17.static.adsl.vol.cz) has joined #tryton23:39
-!- plantian(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton23:42

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