- Zope - Zope lists

Problem w/ ZMySQLDA
by tonylabarbara＠aol.com 14 Jul '07

14 Jul '07

Hi; ? I just built out a new server and transfered my databases. I use Zope to server my web sites and ZMySQLDA to interface between the two. Everything seems to be fine. I can see the databases, the tables, the columns in the tables, the permissions are correct, etc. I hook up ZMySQLDA and that seems to be fine. It connects to the database. However, when I go to look at the pages from served the database, the browser hangs. Any ideas how to troubleshoot this? ? TIA, ? Tony ________________________________________________________________________ AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com.

2 1

database conflict error
by Sudesh soni 14 Jul '07

14 Jul '07

BlankHi, I am recieving following errors frequently as shown below: #1------------------------------------------------------------------------- Site Error An error was encountered while publishing this resource. Error Type: ConflictError Error Value: database conflict error (oid 0x09, class Products.Transience.Transience.Increaser, serial this txn started with 0x036ee0b224215066 2007-07-09 16:50:08.468000, serial currently committed 0x036ee0b39eeeeeee 2007-07-09 16:51:37.250000) #2---------------------------------------------------------------------------- database conflict error (oid 0x7b61, class BTrees._OOBTree.OOBTree, serial this txn started with 0x036ee63aae219655 2007-07-10 16:26:40.812000, serial currently committed 0x036ee63b55aa87bb 2007-07-10 16:27:20.078000) Could anyone help me out in fixing this. I am using Zope 2.8.5 in windows 2003. Recently we have moved the data.fs from Zope2.6.1 into this new version Zope2.8.5. I appreciate any help in advance. Regards Sudesh

3 2

[TextIndexNG3] Extension modules now available as eggs
by Andreas Jung 14 Jul '07

14 Jul '07

For all TextIndexNG3 users having had problems with the installation of the extension modules (on Windows)...there is now some relief. The extension modules are now available as an egg. So on any operating system you should be able to install the extensions using easy_install zopyx.textindexng3 The egg also contains some new stemmers for Turkish, Hungarian and Romanian. Andreas -- ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany Web: www.zopyx.com - Email: info(a)zopyx.com - Phone +49 - 7071 - 793376 Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535 Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK ------------------------------------------------------------------------ E-Publishing, Python, Zope & Plone development, Consulting

1 0

Zope 2.10.4 Upgrade
by David Ayres 13 Jul '07

13 Jul '07

I recently upgraded from Zope 2.10.0 to 2.10.4. However, the Zope instance still reflects 2.10.0 in the control panel. I installed Zope 2.10.4. Then, in my instance, I changed the variables in 'zopectl' and 'zope.conf' to reflect the new 2.10.4 version and restarted. Did I miss a step? Thanks in Advance, Dave

5 7

greedy acquisition problem
by SpiderX 13 Jul '07

13 Jul '07

I have a site, in a folder called 'kb' you access it via http://webserver/kb it has a knowledge base. Inside this, is the index_html and I have some search pages... ---F_problemsearch--- * a form for searching. It's put on the index_html page via tal:replace="structure here/F_problemsearch" contents: <form name="searchbyproblem" action="ProcessSearch"> <input type="text" name="problem" style="color:white; background-color:green;"> <button type="submit" name="st" value="Simple">Simple</button> </form> ------ ProcessSearch is a parameterized python script containing: if st == 'Simple': return container.problemsearch(problem=problem) ------ problemsearch (note the missing F_) is the search results. example: <tr tal:repeat="item here/SQL_search_problems" tal:attributes="bgcolor python:test(path('repeat/item/even'), '#EEEEF3', '#FFFFFF')"> <td tal:content="item/id" valign="top">ID</td> <td tal:content="item/title" valign="top">Title</td> <td tal:content="structure item/problem" valign="top">Problem</td> <td><form name="selection" action="ShowJustOne"><input type="hidden" name="ID" tal:attributes="value item/id" value="42"><input type="submit" value="view"></form></td> </tr> ------ Clicking on the 'simple' button, it changes the URL to http://webserver/kb/ProcessSearch?problem=new&st=Simple. Everything works as expected. However, now I want to add another level. example: http://webserver/kb/review and I want to change only the index_html, and search pages (so someone can review articles after they are submitted). I copied the search pages listed above in the new 'review' folder. I changed the text of the button in "problemsearch" above to "review" instead of "view. When I try it out, I go to http://webserver/kb/review. I type in my search, click "simple" and the URL changes to this: http://webserver/kb/ProcessSearch?problem=new&st=Simple I'd like it to use the files in '/kb/review' before using the files in /kb and I thought that's what acquisition did (index_html behaves this way!) however, it's not doing it correctly. The only way I can get it to properly work is by changing the URL to this: http://webserver/kb/review/ (adding a trailing slash). This website is used internally by users who will be manually typing the URL. Is there some way I can get http://webserver/kb/review to work as well as http://webserver/kb/review/ ? -- Thanks, Derek Wilson

2 2

Logon process
by Garito 13 Jul '07

13 Jul '07

Hi all! I've developed a site that if you are not logged in renders in a way but if you are logged in renders in another way (with more functionality) I would like to create a logon form and the validate the user in an AJAX way Where can I read about it? Or where the acl_users code is located? I would like to avoid the use of alternatives acl_users products if possible because I would like to store users on the ZODB normaly as original acl_users object do (I don't need ExUserFolder or similar if possible) Thanks! -- Mis Cosas http://blogs.sistes.net/Garito

5 16

externalImage
by Lester Cram 13 Jul '07

13 Jul '07

Is there a way to use external image with mysql instead of zodb or is there an example of how to use mysyql to hold metadata and store images on the file system Vision without execution is hallucination

2 1

MailHost and Bcc
by Catherine E. Reinehr 13 Jul '07

13 Jul '07

Good morning! My web site utilizes forms pretty extensively, and I've been trying to figure out how--on one particular form, an admission application--to bcc all copies to another address. Depending on which campus the applicant chooses, the app is emailed to a different person; the program director wants to receive ALL the apps, without the other recipients knowing. But I just can't seem to make it work. Of course, that might have something to do with the fact that I'm not a programmer, which is why I'm asking for help. Any suggestions would be greatly appreciated! The coding looks like this: # Example code: # Import a standard function, and get the HTML request and response objects. from Products.PythonScripts.standard import html_quote request = container.REQUEST RESPONSE = request.RESPONSE try: mailhost=getattr(context, context.superValues('Mail Host')[0].id) except: raise AttributeError, "cant find a Mail Host object" contacts = { 'Bay Minette': 'email1(a)huntingdon.edu', 'Center Point': 'email2(a)huntingdon.edu', 'Pell City': 'email2(a)huntingdon.edu', 'Shelby': 'email2(a)huntingdon.edu', 'Enterprise': 'email3(a)huntingdon.edu', 'Daphne': 'email1(a)huntingdon.edu', 'Montgomery': 'email4(a)huntingdon.edu' } if request.has_key('campus'): mTo = contacts[request['campus']] else: mTo = 'School of Business and Professional Studies <email(a)huntingdon.edu>' mFrom = 'School of Business and Professional Studies <email(a)huntingdon.edu>' if request.has_key('email') and request.has_key('first_name') and request.has_key('last_name'): if request['email'] != '' and request['first_name'] != '' and request['last_name'] != '': mFrom = "%s %s <%s>" % (request['first_name'], request['last_name'], request['email']) mSubj = 'SBPS Application' print " Application Information" print "-------------------------------------------------" print " Term:\t\t", request['term'] print " Campus:\t", request['campus'] print " Name:\t\t", request['prefix'], request['first_name'], request['middle_name'], request['last_name'] print " Preferred Name:\t\t", request['preferred_name'] print " Maiden Name:\t\t", request['maiden_name'] print " DOB:\t\t%s/%s/%s" % (request['dob_month'], request['dob_day'], request['dob_year']) print " Address:\t\t", request['address'] if request.has_key('address_2'): if request['address_2'] != '': print "\t\t\t", request['address_2'] print " City:\t\t", request['city'] print " State:\t\t", request['state'] print " Zip Code:\t\t", request['zip'] print " Email:\t\t", request['email'] print " Home Phone:\t", request['phone_home'] print " Work Phone:\t", request['phone_work'] print " Cell Phone:\t", request['phone_cell'] print "" if request.has_key('citizenship'): if request['citizenship'] == 'U.S.': print " Citizenship:\t\t", request['citizenship'] else: print " Citizenship:\t\t", request['citizenship_other'] print " Marital Status:\t", request['optional_martial_status'] print " Ethnic Origin:\t", request['optional_ethnicity'] print " Religion:\t", request['optional_religion'] if request.has_key('work_experience'): print ' Work Experience:\t', request['work_experience'] if request.has_key('financial_aid'): print ' Financial Aid:\t\t', request['financial_aid'] if request.has_key('veteran'): print ' Veteran\'s Benefits:\t', request['veteran'] print "" print 'Academic Information' print ' High School:\t', request['high_school'] print ' City:\t\t', request['high_school_city'] print ' State:\t\t', request['high_school_state'] print ' Graduated:\t', request['high_school_graduated'] print '' if request.has_key('school_name') and request.has_key('school_city') and request.has_key('school_state') and request.has_key('school_credits'): schools = [school for school in request['school_name'] if school != ''] i = 0 print "Other schools attended:" print "-----------------------" for school in schools: print " School:\t", school print " City:\t", request['school_city'][i] print " State:\t", request['school_state'][i] print " Credits:\t", request['school_credits'][i] print "" i = i + 1 print "Applicable Military Training:" if request.has_key('military_training'): if request['military_training'] != '': print request['military_training'] else: print 'None' print 'Source:' print request['source'] print "" #print request #return printed try: mailhost.send(printed, mTo, mFrom, mSubj) request.RESPONSE.redirect('/sbps/application_success') except: request.RESPONSE.redirect('/sbps/application_error') #return printed ----- Catherine E. Reinehr Webmaster & Publications Designer Huntingdon College 1500 E. Fairview Ave. Montgomery, AL 36106 (334) 833-4429 / Flowers 207

3 2

2.6 to 2.10 migration: RuntimeError: maximum recursion depth exceeded
by Jonas Meurer 12 Jul '07

12 Jul '07

Hello, after importing a product from zope 2.6.4 to a 2.10.3 instance, trying to open the product produces quite a lot of errors in my event.log, and a traceback in the zope management interface. I found a lot of mails regarding plone upgrades which report a similar RuntimeError. What exactly does this mean? this is what i get in event.log: ------ 2007-07-12T00:47:24 ERROR ZODB.Connection Couldn't load state for 0x0aa5 Traceback (most recent call last): File "/usr/lib/zope2.10/lib/python/ZODB/Connection.py", line 749, in setstate self._setstate(obj) File "/usr/lib/zope2.10/lib/python/ZODB/Connection.py", line 807, in _setstate self._reader.setGhostState(obj, p) File "/usr/lib/zope2.10/lib/python/ZODB/serialize.py", line 604, in setGhostState state = self.getState(pickle) File "/usr/lib/zope2.10/lib/python/ZODB/serialize.py", line 597, in getState return unpickler.load() File "/usr/lib/zope2.10/lib/python/ZODB/serialize.py", line 471, in _persistent_load return self.load_oid(reference) File "/usr/lib/zope2.10/lib/python/ZODB/serialize.py", line 537, in load_oid return self._conn.get(oid) File "/usr/lib/zope2.10/lib/python/ZODB/Connection.py", line 208, in get obj._p_jar = self File "/usr/lib/zope2.10/lib/python/ZClasses/_pmc.py", line 65, in __setattr__ super(ZClassPersistentMetaClass, self).__setattr__(name, v) File "/usr/lib/zope2.10/lib/python/ZODB/persistentclass.py", line 84, in __set__ jar.setstate(inst) File "/usr/lib/zope2.10/lib/python/ZODB/Connection.py", line 754, in setstate exc_info=sys.exc_info()) File "logging/__init__.py", line 999, in error File "logging/__init__.py", line 1078, in _log File "logging/__init__.py", line 1064, in makeRecord File "logging/__init__.py", line 246, in __init__ def setupConfiguredLoggers(self): File "threading.py", line 677, in currentThread return _DummyThread() RuntimeError: maximum recursion depth exceeded ------ [ hundredthousands of lines with similar tracebacks, which become longer and longer ] ------ 2007-07-12T00:47:26 ERROR Zope.SiteErrorLog https://sandbox.kicms.de/Control_Panel/Products/BasicCMS/manage_main 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 Shared.DC.Scripts.Bindings, line 313, in __call__ Module Shared.DC.Scripts.Bindings, line 350, in _bindAndExec Module App.special_dtml, line 178, in _exec Module DocumentTemplate.DT_Let, line 76, in render Module DocumentTemplate.DT_In, line 643, in renderwob Module DocumentTemplate.DT_In, line 771, in sort_sequence Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate Module ZODB.serialize, line 604, in setGhostState Module ZODB.serialize, line 597, in getState Module ZODB.serialize, line 471, in _persistent_load Module ZODB.serialize, line 537, in load_oid Module ZODB.Connection, line 208, in get Module ZClasses._pmc, line 65, in __setattr__ Module ZODB.persistentclass, line 84, in __set__ Module ZODB.Connection, line 749, in setstate Module ZODB.Connection, line 807, in _setstate RuntimeError: maximum recursion depth exceeded greetings, jonas -- "In post-historical society, the rulers have ceased to rule, but the slaves remain slaves." - Perry Anderson

5 8

html2pdf
by Garry Saddington 12 Jul '07

12 Jul '07

I am trying to use html2pdf and htmldoc to generate pdfs on the fly. I can get it to work perfectly if I set all view permissions for anonymous. However, this is not suitable for a member only site. Can anyone point me in the right direction for such use? I am using: (Zope 2.9.0, python 2.4.2, win32) and latest version of html2pdf. Regards Garry

3 3