http://www.zforum.org/feed_rss?section=latestzForum is a SQL-Based Message Board Based in Zope2010-09-06 09:16:00zForum Internal RSS Aggregatorhttp://blogs.law.harvard.edu/tech/rsshttp://www.zforum.org/view_topic?topic_id=1817Hi all, I have written a ZSQL method named ('getSummaryValue') for fetching the summary result from a table. Please see the following query. SELECT SecID ,SUM(CASE WHEN txnType IN('pi') THEN quantity ELSE 0 END) AS InitPos ,SUM(CASE WHEN txnType IN('pe') THEN quantity ELSE 0 END) AS EndPos FROM Txntemp WHERE Txntemp.fileImportID = GROUP BY SecID This ZSQL method takes a single parameter "seqID" of type "int" This ZSQL method script is called within a Python_script as follows context.getSummaryValue(seqID = SequenceID) the "SequenceID" is passed in as a request variable to the python script. I have two sites one testing and another Live. In testing site the script does return value for the sequenceID passed into it as a request variable. But while running in Live environment it doesn't return any value for the sequenceID passed into it as a request variable. But when the sequeneceID is hardcoded into the python script it does return the details in LIVE . Please help to resolve the issue. All help are really appreciated. Its really critical Please help. http://www.zforum.org/view_topic?topic_id=18172010-05-19 03:58:00http://www.zforum.org/view_topic?topic_id=1812We are using Zope2.9 ( Debian etch 4r4) for developing web applications . We have added/installed zForum(version: 1.1) as Product in the same in the directory : /var/lib/zope2.9/instance/sandbox/Products/zforum . We want to use zforum in our application in hindi language by which user can see every thing in hindi language in zforum. For this the messaging part as given in the documentation is through the po file in the directory : ../zForum/locales/hi/LC-MESSAGES/. There is default option in zforum is es(spanish language) . For this : 1.Should the hindi po file be named as hi.po or zforum.po 2.We are using Mysql(5.0) as the database . Kindly tell whether the separate databases can be made for different languages such as Hindi and english or only one database with utf-8 encoding is to made . 3.How will the zForum(1.1) and zope2.9 system know about the addition what are the commands required ? 4.Any other information /action for the same . Sincerely , dtr http://www.zforum.org/view_topic?topic_id=18122009-10-31 07:53:00http://www.zforum.org/view_topic?topic_id=1811We are using Zope2.9 ( Debian etch 4r4) for developing web applications . We have added/installed zForum(version: 1.1) as Product in the same in the directory : /var/lib/zope2.9/instance/sandbox/Products/zforum . We want to use zforum in our application in hindi language by which user can see every thing in hindi language in zforum. For this the messaging part as given in the documentation is through the po file in the directory : ../zForum/locales/hi/LC-MESSAGES/. There is default option in zforum is es(spanish language) . For this : 1.Should the hindi po file be named as hi.po or zforum.po 2.We are using Mysql(5.0) as the database . Kindly tell whether the separate databases can be made for different languages such as Hindi and english or only one database with utf-8 encoding is to made . 3.How will the zForum(1.1) and zope2.9 system know about the addition what are the commands required ? 4.Any other information /action for the same . http://www.zforum.org/view_topic?topic_id=18112009-10-31 06:58:00http://www.zforum.org/view_topic?topic_id=1810We are using Zope2.9 ( Debian etch 4r4) for developing web applications . We have added/installed zForum(version: 1.1) as Product in the directory : /var/lib/zope2.9/instance/sandbox/Products/zforum . We want to use zforum in hindi language . For this the messaging part as given in the documentation is through the po file in the directory : ../zForum/locales/hi/LC-MESSAGES/. For this : 1.Should the hindi po file be named as hi.po or zforum.po 2.How will the zForum(1.1) and zope2.9 system know about the addition – what are the commands required ? http://www.zforum.org/view_topic?topic_id=18102009-10-31 06:57:00http://www.zforum.org/view_topic?topic_id=1809We are using Zope2.9 ( Debian etch – 4r4) for developing web applications . We have added/installed zForum(version: 1.1) as Product in the directory : /var/lib/zope2.9/instance/sandbox/Products/zforum . We want to use zforum in hindi language . For this the messaging part as given in the documentation is through the po file in the directory : ../zForum/locales/hi/LC-MESSAGES/. For this : 1.Should the hindi po file be named as hi.po or zforum.po 2.How will the zForum(1.1) and zope2.9 system know about the addition – what are the commands required ? http://www.zforum.org/view_topic?topic_id=18092009-10-31 06:55:00http://www.zforum.org/view_topic?topic_id=1808We are using Zope2.9 ( Debian etch – 4r4) for developing web applications . We have added/installed zForum(version: 1.1) as Product in the directory : /var/lib/zope2.9/instance/sandbox/Products/zforum . We want to use zforum in hindi language . For this the messaging part as given in the documentation is through the po file in the directory : ../zForum/locales/hi/LC-MESSAGES/. For this : 1.Should the hindi po file be named as hi.po or zforum.po 2. Kindly tell whether the separate databases can be made for different languages such as Hindi and english or only one database with utf-8 encoding is to made . 3.How will the zForum(1.1) and zope2.9 system know about the addition – what are the commands required ? http://www.zforum.org/view_topic?topic_id=18082009-10-31 06:55:00http://www.zforum.org/view_topic?topic_id=1807We are using Zope2.9 ( Debian etch – 4r4) for developing web applications . We have added/installed zForum(version: 1.1) as Product in the directory : /var/lib/zope2.9/instance/sandbox/Products/zforum . We want to use zforum in hindi language . For this the messaging part as given in the documentation is through the po file in the directory : ../zForum/locales/hi/LC-MESSAGES/. For this : 1.Should the hindi po file be named as hi.po or zforum.po 2.We are using Mysql(5.0) as the database . Kindly tell whether the separate databases can be made for different languages such as Hindi and english or only one database with utf-8 encoding is to made . 3.How will the zForum(1.1) and zope2.9 system know about the addition – what are the commands required ? http://www.zforum.org/view_topic?topic_id=18072009-10-31 06:54:00http://www.zforum.org/view_topic?topic_id=1806We are using Zope2.9 ( Debian etch – 4r4) for developing web applications . We have added/installed zForum(version: 1.1) as Product in the same in the directory : /var/lib/zope2.9/instance/sandbox/Products/zforum . We want to use zforum in our application in hindi language by which user can see every thing in hindi language in zforum. For this the messaging part as given in the documentation is through the po file in the directory : ../zForum/locales/hi/LC-MESSAGES/. There is default option in zforum is es(spanish language) . For this : 1.Should the hindi po file be named as hi.po or zforum.po 2.We are using Mysql(5.0) as the database . Kindly tell whether the separate databases can be made for different languages such as Hindi and english or only one database with utf-8 encoding is to made . 3.How will the zForum(1.1) and zope2.9 system know about the addition – what are the commands required ? 4.Any other information /action for the same . http://www.zforum.org/view_topic?topic_id=18062009-10-31 06:51:00http://www.zforum.org/view_topic?topic_id=1805We are using Zope2.9 ( Debian etch – 4r4) for developing web applications . The following packages which were required to be required have also been installed : Mysql 5.0 , plone 2.5.1 and python mysqldb 1.2.1 & ZmySQLDA 2.0.8 . We have added/installed zForum(version: 1.1) as Product in the same in the directory : /var/lib/zope2.9/instance/sandbox/Products/zforum . We want to use zforum in our application in hindi language by which user can see every thing in hindi language in zforum. For this the messaging part as given in the documentation is through the po file in the directory : ../zForum/locales/hi/LC-MESSAGES/. There is default option in zforum is es(spanish language) . For this : 1.Should the hindi po file be named as hi.po or zforum.po 2.We are using Mysql(5.0) as the database . Kindly tell whether the separate databases can be made for different languages such as Hindi and english or only one database with utf-8 encoding is to made . 3.How will the zForum(1.1) and zope2.9 system know about the addition – what are the commands required ? 4.Any other information /action for the same . http://www.zforum.org/view_topic?topic_id=18052009-10-31 06:49:00http://www.zforum.org/view_topic?topic_id=1804We are using Zope2.9 ( Debian etch – 4r4) for developing web applications . The following packages which were required to be required have also been installed : Mysql 5.0 , plone 2.5.1 and python mysqldb 1.2.1 & ZmySQLDA 2.0.8 . We have added/installed zForum(version: 1.1) as Product in the same in the directory : /var/lib/zope2.9/instance/sandbox/Products/zforum . We want to use zforum in our application in hindi language by which user can see every thing in hindi language in zforum. For this the messaging part as given in the documentation is through the po file in the directory : ../zForum/locales/hi/LC-MESSAGES/. There is default option in zforum is es(spanish language) . For this : 1.Should the hindi po file be named as hi.po or zforum.po 2.We are using Mysql(5.0) as the database . Kindly tell whether the separate databases can be made for different languages such as Hindi and english or only one database with utf-8 encoding is to made . 3.How will the zForum(1.1) and zope2.9 system know about the addition – what are the commands required ? 4.Any other information /action for the same . Sincerely , dtrhttp://www.zforum.org/view_topic?topic_id=18042009-10-31 06:49:00http://www.zforum.org/view_topic?topic_id=1803i m using Zope 2.9.6-final, python 2.4.4 & mysql 5.0, i want to convert zforum(1.1 Revision 1) in hindi,how can i do that.http://www.zforum.org/view_topic?topic_id=18032009-10-31 05:22:00http://www.zforum.org/view_topic?topic_id=1772I use zForum in Plone 2.02. When I add a topic, the display time is faster than my localtime 14 hours! eg: when I prepair to add a topic, it display "Name: XXX 02/11/2009 - 06:20 PM ", after added, it changed to "Added: 02/12/2009 - 08:20 AM ". I use Beijing Timezone.(GMT+8). Who can help me?? Thank a lot!!http://www.zforum.org/view_topic?topic_id=17722009-02-11 04:28:00http://www.zforum.org/view_topic?topic_id=1735Hola! Estamos migrando nuestro sitio a plone y necesitariamos migrar un foro SMF a zForum. Existe alguna herramienta capaz de asistir en la tarea? Muchas Gracias por su atencion, saludos, Rodrigo.http://www.zforum.org/view_topic?topic_id=17352008-11-13 10:09:00http://www.zforum.org/view_topic?topic_id=1420He puesto éste foro para promover el uso del producto en aplicaciones hechas en español, un saludo a la comunidad latina e ibérica.http://www.zforum.org/view_topic?topic_id=14202008-11-13 10:05:00http://www.zforum.org/view_topic?topic_id=1733When it is ready for use in plone 3xx? Would be very nice to have zForum on my site. mfg juergenhttp://www.zforum.org/view_topic?topic_id=17332008-10-23 11:57:00http://www.zforum.org/view_topic?topic_id=1757Is it possible to disable avatars for everyone except a select group of privileged users? http://www.zforum.org/view_topic?topic_id=17572008-10-16 20:13:00http://www.zforum.org/view_topic?topic_id=1755Hi Everyone, I'm totally new to Zope/Plone, but I am following Martin Aspelli's 'Professional Plone Development'. He suggests using GenericSetup, which I think sounds just fine, except I get an error after try to add Generic Setup Tool from the pull down menu. I added the GenericSetup folder, as instructed in the Readme, to my products folder of my instance. Any ideas? The error is: Site Error An error was encountered while publishing this resource. Error Type: BadRequest Error Value: The id "setup_tool" is invalid - it is already in use. Troubleshooting Suggestions * The URL may be incorrect. * The parameters passed to this resource may be incorrect. * A resource that this resource relies on may be encountering an error. and the log shows: Time 2008/10/01 16:45:09.589 GMT-4 User Name (User Id) admin (admin) Request URL http://localhost:8080/manage_addProduct/GenericSetup/addSetupTool Exception Type BadRequest Exception Value The id "setup_tool" is invalid - it is already in use. Traceback (innermost last): * Module ZPublisher.Publish, line 119, in publish * Module ZPublisher.mapply, line 88, in mapply * Module ZPublisher.Publish, line 42, in call_object * Module Products.GenericSetup.tool, line 1268, in addSetupTool * Module OFS.ObjectManager, line 314, in _setObject * Module OFS.ObjectManager, line 102, in checkValidId BadRequest: The id "setup_tool" is invalid - it is already in use. http://www.zforum.org/view_topic?topic_id=17552008-10-01 15:43:00http://www.zforum.org/view_topic?topic_id=1741Hi people! Is it possible to integrate the membership info of the plone site users with zforum?? I have a very large site with many users and I want to use the email information of the users without having to fill this property in the zforum personal preferences. Is it posible?? Thanks a lot! http://www.zforum.org/view_topic?topic_id=17412008-07-29 06:40:00http://www.zforum.org/view_topic?topic_id=1740Hi I am using Zforum 1.1 R 1 on Plone 2.5.5 and Zope 2.9.6-final, and I would like to integrate Zfoum in to Plone but I can not find the 'Plone option when adding zForum in plone' as explained in the Plone integration guide. Did I miss something?http://www.zforum.org/view_topic?topic_id=17402008-07-04 02:55:00http://www.zforum.org/view_topic?topic_id=1739Hello everyone, I have a couple questions related to "conflict errors". During our home page stress testing (20 concurrent users), we detected several conflict errors (see trace below), We thought these could ONLY appear when writing objects in the ZODB. 2008-05-27T18:57:53 INFO ZODB conflict error at /portal/ (26 conflicts since startup at 2008-05-27T13:37:19) I would like to know: - Can conflict errors appear when reading objects from the ZODB? - Could conflict errors be the cause of a "spinning ZOPE" scenario? - Is there any situation where ZOPE could try to write objects when rendering an "only read" page? Our configuration is as follows: Apache + Pound + ZEO architecture (5 ZEO clients, 1 ZEO storage server - 650.000 ZODB objects) Thanks in advance.http://www.zforum.org/view_topic?topic_id=17392008-06-05 03:17:00