| chat.freenode.net #tryton log beginning Mon Sep 16 00:00:01 CEST 2013 | ||
| 2013-09-16 07:29 -!- priyankarani(~priyanka@122.177.41.6) has left #tryton | ||
| 2013-09-16 12:12 <beadle_> new install. trbl with MySQL. edited trytond.conf. service won't start. fedora 19 | ||
| 2013-09-16 12:14 <beadle_> I'm able to connect the client to demo | ||
| 2013-09-16 12:23 <cedk> beadle_: using mysql is really not the best choice | ||
| 2013-09-16 12:26 <beadle_> cedk: ok. I think for my needs it's ok. I'm just starting out and comparing to openERP. I use mysql for a few other things and would prefer not to add another DBMS | ||
| 2013-09-16 12:26 <beadle_> I basically just want to set up project and work tracking and invoice generation. at least for now. | ||
| 2013-09-16 12:32 <cedk> beadle_: I'm not sure you will find a lot of help here about MySQL, almost everyone use PostgreSQL or SQLite (for testing) | ||
| 2013-09-16 12:32 <beadle_> I created tryton db and user and gave the user access on all hosts. restarting trytond had no different result. would you do these same actions with SQLite? | ||
| 2013-09-16 12:33 <beadle_> well, and also modified conf to point db type to host/port | ||
| 2013-09-16 12:33 <beadle_> didn't find a way to specify schema name | ||
| 2013-09-16 12:34 <beadle_> if you can help me setup for sqlite that probably would help a lot | ||
| 2013-09-16 12:38 <cedk> beadle_: for SQLite just define the data_path in conf and start trytond | ||
| 2013-09-16 12:38 <cedk> beadle_: use the client to create a database | ||
| 2013-09-16 12:39 <beadle_> ok | ||
| 2013-09-16 12:42 <beadle_> change db_type? it's REMarked in the default conf | ||
| 2013-09-16 12:49 <beadle_> cedk: not working. not so easy on Fedora? | ||
| 2013-09-16 12:50 <cedk> beadle_: https://code.google.com/p/tryton/wiki/SetupAndStart | ||
| 2013-09-16 12:52 <beadle_> thanks. I'm going to take a fresh try tomorrow. as for those guidelines, the client seems to force port8000 and such a profile in creating a db. | ||
| 2013-09-16 14:31 <guillemNaN> cedk: is possible to call 'generate_series()' with python-sql? | ||
| 2013-09-16 14:38 <cedk> guillemNaN: I don't think it is a standard function but you can create your own Function | ||
| 2013-09-16 15:11 <guillemNaN> cedk:it is postgres function. How can I call a function with python-sql? | ||
| 2013-09-16 15:12 -!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has left #tryton | ||
| 2013-09-16 15:27 -!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has left #tryton | ||
| 2013-09-16 15:34 <guillemNaN> cedk: Do I do something like that http://www.mail-archive.com/sqlalchemy@googlegroups.com/msg08872.html ? | ||
| 2013-09-16 15:36 <cedk> guillemNaN: more something like: http://hg.tryton.org/trytond/file/a58dd18fb7bd/trytond/backend/sqlite/database.py#l119 | ||
| 2013-09-16 15:42 <guillemNaN> cedk: good. I add 'generate_series()' [1] as function for postgresql backend (like SQLite adds overlay) | ||
| 2013-09-16 15:43 <guillemNaN> [1] http://www.postgresql.org/docs/8.4/static/functions-srf.html | ||
| 2013-09-16 15:48 <cedk> guillemNaN: for me, it is not a standard SQL function so we can not add it | ||
| 2013-09-16 15:50 <guillemNaN> ok | ||
| 2013-09-16 17:10 -!- priyankarani(~priyanka@101.58.192.70) has left #tryton | ||
| 2013-09-16 17:52 <jvblasco> one question: how do i set a selection field to a value? | ||
| 2013-09-16 17:52 <jvblasco> if i do it from the client i have no issues | ||
| 2013-09-16 17:53 <jvblasco> but when i try from the code i get: [0] => El campo "Tipo de envio" en "Venta" no se encuentra en la selección. | ||
| 2013-09-16 17:53 <nicoe> jvblasco: you're lucky I understand some spanish ;) | ||
| 2013-09-16 17:53 <jvblasco> it means that the field in the model isn't in the selection | ||
| 2013-09-16 17:53 <nicoe> you should use the database value | ||
| 2013-09-16 17:54 <jvblasco> gimme a sec to check the database | ||
| 2013-09-16 17:54 <nicoe> a field selection is (database_value, nice_value) | ||
| 2013-09-16 17:55 <jvblasco> nicoe: im using the database one | ||
| 2013-09-16 17:55 <nicoe> jvblasco: the it should work | ||
| 2013-09-16 17:55 <jvblasco> the problem is that the client can do it without problems, but i can't from the code | ||
| 2013-09-16 17:55 <jvblasco> i always get the same error, no matter what i try | ||
| 2013-09-16 18:11 <nicoe> jvblasco: without the code there is very little I can do to help you | ||
| 2013-09-16 18:33 <jvblasco> nicoe: yeah, gimme a sec | ||
| 2013-09-16 18:34 <jvblasco> nicoe: i was required for other things | ||
| 2013-09-16 18:34 <jvblasco> gimme a sec to generate the paste bins | ||
| 2013-09-16 18:36 <jvblasco> nicoe: http://pastebin.com/Qpgc3h8s | ||
| 2013-09-16 18:36 <jvblasco> nicoe: that's the code, and above i pasted the error | ||
| 2013-09-16 18:37 <jvblasco> nicoe: the client works without any problem | ||
| 2013-09-16 18:38 <nicoe> Your code seems OK to me. | ||
| 2013-09-16 18:39 <nicoe> But it's only a very small snippets | ||
| 2013-09-16 18:43 <jvblasco> i'm creating the object | ||
| 2013-09-16 18:43 <jvblasco> i'm not doing anything special | ||
| 2013-09-16 18:43 <jvblasco> just writing/creating an object | ||
| 2013-09-16 18:43 <jvblasco> i'm trying in a clean database install | ||
| 2013-09-16 18:44 <jvblasco> to check if the issue stays here | ||
| 2013-09-16 19:03 -!- sisalp(~dominique@annecy.sisalp.net) has left #tryton | ||
| 2013-09-16 19:25 <jvblasco> nicoe: in a clean database it doesn't work either | ||
| 2013-09-16 19:27 <jvblasco> well see u tomorrow everyone |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!