- Zope - Zope lists

ODBC adapter
by Miguel Beltran R. 08 Jul '16

08 Jul '16

Hi again list, Using zope 2.13.23 ZPyODBCDA 1.0.9.dev0 ( https://github.com/tcurvelo/Products.ZPyODBCDA ) I have tried to install ZpyODBCDA but when I try to start the instance i got this error (control-emisiones3) N:\zope\control-emisiones3>"N:\zope\control-emisiones3\Scripts\runzope" -C "N:\zope\control-emisiones3\instance_zope\etc\zope.conf" 2016-07-04 10:48:05 ERROR Application Could not import Products.ZPyODBCDA Traceback (most recent call last): File "n:\zope\control-emisiones3\lib\site-packages\OFS\Application.py", line 606, in import_product product=__import__(pname, global_dict, global_dict, silly) File "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\__init__.py", line 27, in <module> from pyodbc_browser import pyodbcConnectionBrowser, addpyodbcConnectionBrowser, addpyodbcConnectionForm File "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_browser.py", line 23, in <module> from pyodbc_DA import pyodbcConnection, database_type, addpyodbcConnectionForm File "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_DA.py", line 27, in <module> from pyodbc_db import DB File "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_db.py", line 37, in <module> from Shared.DC.ZRDB.TM import TM ImportError: No module named ZRDB.TM Traceback (most recent call last): File "C:\Python27\Lib\runpy.py", line 162, in _run_module_as_main "__main__", fname, loader, pkg_name) File "C:\Python27\Lib\runpy.py", line 72, in _run_code exec code in run_globals File "N:\zope\control-emisiones3\Scripts\runzope.exe\__main__.py", line 9, in <module> File "n:\zope\control-emisiones3\lib\site-packages\Zope2\Startup\run.py", line 22, in run starter.prepare() File "n:\zope\control-emisiones3\lib\site-packages\Zope2\Startup\__init__.py", line 86, in prepare self.startZope() File "n:\zope\control-emisiones3\lib\site-packages\Zope2\Startup\__init__.py", line 262, in startZope Zope2.startup() File "n:\zope\control-emisiones3\lib\site-packages\Zope2\__init__.py", line 47, in startup _startup() File "n:\zope\control-emisiones3\lib\site-packages\Zope2\App\startup.py", line 67, in startup OFS.Application.import_products() File "n:\zope\control-emisiones3\lib\site-packages\OFS\Application.py", line 583, in import_products import_product(product_dir, product_name, raise_exc=debug_mode) File "n:\zope\control-emisiones3\lib\site-packages\OFS\Application.py", line 606, in import_product product=__import__(pname, global_dict, global_dict, silly) File "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\__init__.py", line 27, in <module> from pyodbc_browser import pyodbcConnectionBrowser, addpyodbcConnectionBrows er, addpyodbcConnectionForm File "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_browser.py", line 23, in <module> from pyodbc_DA import pyodbcConnection, database_type, addpyodbcConnectionForm File "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_DA.py", line 27, in <module> from pyodbc_db import DB File "N:\zope\control-emisiones3\instance_zope\Products\ZPyODBCDA\pyodbc_db.py", line 37, in <module> from Shared.DC.ZRDB.TM import TM ImportError: No module named ZRDB.TM What module do I need to install? -- ________________________________________ Lo bueno de vivir un dia mas es saber que nos queda un dia menos de vida

3 4

Re: [Zope] Problemwith unicode
by Miguel Beltran R. 04 Jul '16

04 Jul '16

2016-06-29 20:46 GMT-05:00 Alberto Berti <azazel(a)metapensiero.it>: > >>>>> "Miguel" == Miguel Beltran R <yourpadre(a)gmail.com> writes: > > > Miguel> After search a while, someone can confirm if I undestand it > well? the > Miguel> problem is because it is trying to decode to "ascii" instead > of "iso-8859-1" > > Miguel> if it's true, why is doing it? I set to use iso-8859-1 in my > conf file > > Miguel> 2016-06-28 16:56 GMT-05:00 Miguel Beltran R. < > yourpadre(a)gmail.com>: > > >> Using the ZMI if I check the "Z SQL Method" the data is displayed > >> correctly, but using a "page template" it gives me this error > >> > >> > >> *Expression: <StringExpr u' ${repeat/items/number}. > ${items/nombre}'>* > >> > >> - Module zope.tales.expressions, line 263, in > __call__UnicodeDecodeError: > >> 'ascii' codec can't decode byte 0xf3 in position 10: ordinal not in > >> range(128) > >> > > this is due probably because the template engine tries to convert a > string into an unicode, but it doesn't know the charset of your data, so > it's trying to use the default encoding as set in > /usr/lib/python2.7/site.py during interpreter bootstrap. If you are > using a good database you can trust your data and and let the database > connector (the encoding should be settable somewhere in the connector or > Z SQL method conf, i don't remember since i don't use them anymore) > convert the strings to unicodes for you. > > If you have something like MySQL you can't always trust that the data in > the db is in the expected encoding because some of its table engine > simply don't do any check on the input. If this is your case, it will be > more problematic. > > In my experience, setting a default encoding in the config file didn't > always fix the problem. > > As a last resort you can tweak the site.py, but really if there issues > with data's encoding this doesn't mean you solved the problem. Likely > the user will see wrong charachters where non-ascii ones are supposed to > be. > Thanks Alberto!!! :D Changing the enconding in the site.py file made the trick. To some zope developer in the list, why is not taking the enconding from the zope.conf file? Do I must open a ticket? -- ________________________________________ Lo bueno de vivir un dia mas es saber que nos queda un dia menos de vida

1 0

Zope 2.13.23 installation
by Michael Brunnbauer 30 Jun '16

30 Jun '16

hi all, Tres Seaver wrote: >On behalf of the Zope Foundation and its members, I'm pleased to >announce the 2.13.23 release of the Zope2 package: Great! >/path/to/venv/bin/pip install \ >https://raw.githubusercontent.com/zopefoundation/Zope/2.13.23/requirements.… raboso:/home/zope/2.13.23$ ./bin/pip install https://raw.githubusercontent.com/zopefoundation/Zope/2.13.23/requirements.… Downloading/unpacking https://raw.githubusercontent.com/zopefoundation/Zope/2.13.23/requirements.… Downloading requirements.txt Cannot unpack file /tmp/pip-9UQkA6-unpack/requirements.txt (downloaded from /tmp/pip-GQuiZE-build, content-type: text/plain; charset=utf-8); cannot detect archive format Cannot determine archive format of /tmp/pip-GQuiZE-build Storing complete log in /home/zope/./.pip/pip.log --------------- raboso:/home/zope/2.13.23$ ./bin/pip install --index-url=http://download.zope.org/Zope2/index/2.13.23/ Zope2 Downloading/unpacking Zope2 Could not find any downloads that satisfy the requirement Zope2 No distributions at all found for Zope2 Storing complete log in /home/zope/./.pip/pip.log --------------- raboso:/home/zope/2.13.23$ ./bin/easy_install -i http://download.zope.org/Zope2/index/2.13.23 Zope2 Searching for Zope2 Reading http://download.zope.org/Zope2/index/2.13.23/Zope2/ Couldn't find index page for 'Zope2' (maybe misspelled?) Scanning index of all packages (this may take a while) Reading http://download.zope.org/Zope2/index/2.13.23/ No local packages or download links found for Zope2 Best match: None Traceback (most recent call last): File "./bin/easy_install", line 8, in <module> load_entry_point('setuptools==0.6c11', 'console_scripts', 'easy_install')() File "/home/zope/2.13.23/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg/setuptools/command/easy_install.py", line 1712, in main File "/home/zope/2.13.23/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg/setuptools/command/easy_install.py", line 1700, in with_ei_usage File "/home/zope/2.13.23/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg/setuptools/command/easy_install.py", line 1716, in <lambda> File "/usr/lib/python2.7/distutils/core.py", line 151, in setup dist.run_commands() File "/usr/lib/python2.7/distutils/dist.py", line 953, in run_commands self.run_command(cmd) File "/usr/lib/python2.7/distutils/dist.py", line 972, in run_command cmd_obj.run() File "/home/zope/2.13.23/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg/setuptools/command/easy_install.py", line 211, in run File "/home/zope/2.13.23/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg/setuptools/command/easy_install.py", line 434, in easy_install File "/home/zope/2.13.23/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg/setuptools/package_index.py", line 475, in fetch_distribution AttributeError: 'NoneType' object has no attribute 'clone' --------------- ./bin/easy_install ../Zope2-2.13.23.tar.gz works but seems to use the wrong requirements so Zope2 does not start. How am I supposed to install Zope2 this time? Which INSTALL.rst, INSTALL-buildout.rst or INSTALL-virtualenv.rst am I supposed to read (please provide URL)? Regards, Michael Brunnbauer -- ++ Michael Brunnbauer ++ netEstate GmbH ++ Geisenhausener Straße 11a ++ 81379 München ++ Tel +49 89 32 19 77 80 ++ Fax +49 89 32 19 77 89 ++ E-Mail brunni(a)netestate.de ++ http://www.netestate.de/ ++ ++ Sitz: München, HRB Nr.142452 (Handelsregister B München) ++ USt-IdNr. DE221033342 ++ Geschäftsführer: Michael Brunnbauer, Franz Brunnbauer ++ Prokurist: Dipl. Kfm. (Univ.) Markus Hendel

3 3

Problemwith unicode
by Miguel Beltran R. 29 Jun '16

29 Jun '16

Hi list, my system is Zope 2.11.4 with default enconding iso-8859-1 for in/out and SQL Server 2008. I'm trying to fix a bad desing with a sql server database. it has a mix of encodings, traditional_spanish and modern_spanish. And some tables with both type of fields, unicode and normal (nvarchar and varchar) . The new database is Latin-1 enconding (SQL_Latin1_General_CP1_CI_AI) with only varchar fields. Using the ZMI if I check the "Z SQL Method" the data is displayed correctly, but using a "page template" it gives me this error *Expression: <StringExpr u' ${repeat/items/number}. ${items/nombre}'>* {'container': <Folder at /control-emisiones/campos used for /control-emisiones/oficio/alta>, 'context': <Folder at /control-emisiones/campos used for /control-emisiones/oficio/alta>, 'default': <object object at 0x00ADC528>, 'here': <Folder at /control-emisiones/campos used for /control-emisiones/oficio/alta>, 'loop': {u'items': <Products.PageTemplates.Expressions.PathIterator object at 0x078877D0>}, 'nothing': None, 'options': {'busqueda': 1, 'args': ()}, 'repeat': <Products.PageTemplates.Expressions.SafeMapping object at 0x07802530>, 'request': <HTTPRequest, URL=http://10.28.1.2:91/control-emisiones/oficio/alta/index_html>, 'root': <Application at >, 'template': <ZopePageTemplate at /control-emisiones/campos/campo__oficio_tipo>, 'traverse_subpath': [], 'user': <User 'admin'>} - Module zope.tales.expressions, line 263, in __call__UnicodeDecodeError: 'ascii' codec can't decode byte 0xf3 in position 10: ordinal not in range(128) The data transfer was made using database tools (DTWizard). why it is happening this? -- ________________________________________ Lo bueno de vivir un dia mas es saber que nos queda un dia menos de vida

1 1

that impressed me
by United Nations 12 Jun '16

12 Jun '16

Hello, I'm so excited to tell you that, I was impressed so much, please read here <http://cragefasli.http-programming.org/aehlc> My best to you, United Nations

1 0

be prepared
by alba＠scotlandmail.com 11 Jun '16

11 Jun '16

Hey, I'm sure you are interested in such info, be prepared for something really great! More info here <http://wonedycri.flippinghomeswithnick.com/aeike> Hope this helps, alba(a)scotlandmail.com

1 0

invalid database error, _fs_path
by Arun H. Patil 30 May '16

30 May '16

Hi All, I have upgraded an old server to new server, I have installed the same version of zope (Zope-2.10.9). I am having difficulties importing .zexp files which has MySQL connectivity. I am getting the following error (the password of mysql is retained the same for connecting the database): 2016-05-30T00:00:17 ERROR ZRDB.Connection Error connecting to relational database. Traceback (most recent call last): File "/PATH/Zope-2.10.9-final/zope/lib/python/Shared/DC/ZRDB/Connection.py", line 72, in __setstate__ try: self.connect(self.connection_string) File "/PATH/Zope-2.10.9-final/zope/lib/python/Products/ZGadflyDA/DA.py", line 86, in connect self._v_database_connection=c[s]=DB(s) File "/PATH/Zope-2.10.9-final/zope/lib/python/Products/ZGadflyDA/db.py", line 97, in __init__ self.open() File "/PATH/Zope-2.10.9-final/zope/lib/python/Products/ZGadflyDA/db.py", line 82, in open raise self.database_error, 'invalid database error, ' + connection BadRequest: <strong>Invalid connection string: </strong><CODE>demo</CODE><br>  2016-05-30T00:01:19 ERROR Zope.SiteErrorLog 1464591679.20.682669223649 http://IP_address:8080/new_folder/manage_importObject 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 OFS.ObjectManager, line 610, in manage_importObject Module OFS.ObjectManager, line 632, in _importObjectFromFile Module OFS.ObjectManager, line 327, in _setObject Module zope.event, line 23, in notify Module zope.component.event, line 26, in dispatch Module zope.component._api, line 130, in subscribers Module zope.component.registry, line 290, in subscribers Module zope.interface.adapter, line 535, in subscribers Module zope.component.event, line 33, in objectEventNotify Module zope.component._api, line 130, in subscribers Module zope.component.registry, line 290, in subscribers Module zope.interface.adapter, line 535, in subscribers Module OFS.subscribers, line 107, in dispatchObjectWillBeMovedEvent Module zope.app.container.contained, line 182, in dispatchToSublocations Module zope.component._api, line 130, in subscribers Module zope.component.registry, line 290, in subscribers Module zope.interface.adapter, line 535, in subscribers Module OFS.subscribers, line 107, in dispatchObjectWillBeMovedEvent Module zope.app.container.contained, line 181, in dispatchToSublocations Module OFS.subscribers, line 87, in sublocations Module OFS.ObjectManager, line 420, in objectValues Module Products.LocalFS.FSObject, line 778, in objectIds Module Products.LocalFS.FSObject, line 917, in _fs_load AttributeError: _fs_path Please let me know where I am going wrong and how do I overcome this error. Thank You, Arun

1 0

Zope2 2.13.24
by Michael Brunnbauer 15 Mar '16

15 Mar '16

hi all, I see that Zope2 2.13.24 was released yesterday. Can somebody put the release at http://download.zope.org/Zope2/index/2.13.24/ ? thnx! Regards, Michael Brunnbauer -- ++ Michael Brunnbauer ++ netEstate GmbH ++ Geisenhausener Straße 11a ++ 81379 München ++ Tel +49 89 32 19 77 80 ++ Fax +49 89 32 19 77 89 ++ E-Mail brunni(a)netestate.de ++ http://www.netestate.de/ ++ ++ Sitz: München, HRB Nr.142452 (Handelsregister B München) ++ USt-IdNr. DE221033342 ++ Geschäftsführer: Michael Brunnbauer, Franz Brunnbauer ++ Prokurist: Dipl. Kfm. (Univ.) Markus Hendel

2 4

Zope2: Handling multiple object creations at once from multiple clients and processes?
by Sebastian Tänzer 08 Jan '16

08 Jan '16

Hello ZOPE users, I am dealing with the famous (Write) ConflictErrors in a module that is fetching remote files from a remote URL with the requests lib, storing them as objects with the binary data residing on the file system (no blob is stored in the ZODB). The upload/import routine works by using jQuery’s ajax() and POSTing to the upload handler and using SSE to return a progress while the import is running and before creating the actual object inside the ZODB. The first process of course always works fine, but when a second or third starts these trigger a ConflictError and are beeing restarted, i.e. all selected remote files are downloaded again and then create the objects inside the ZODB. All objects are created inside the same tree structure and most of the time inside the same Folder. The conflict’s object oid mentioned in the error message actually is the new object beeing created. I first thought this had sth. to do with writing to the same object while the addObject routine is running, but it does not seem so. What I don’t understand is why the first process writes to something that triggers the conflict with the second process. What’s the recommended way of dealing with such mass creation of objects running at the same time that are triggered by AJAX calls on the same context without creating conflicts? Best Sebastian

1 0

Problem with Zope
by Jordan Guerder 05 Jan '16

05 Jan '16

Hello, I discovered Zope, however, I see an error output from one of my clients. Indeed its website appears for a few hours this error message: Zope Error Zope HAS Encountered an error while publishing this resource. Error type: IndexError Error Value: 0 Server side all seems ok: - Apache is up - Php fpm is up - Mysql is up The logs do not show me any errors, would you therefore an idea of how I could identify this problem? Jordan

3 2