hi all, can anyone tel me how to query string in URL for querying data from ZSQL from page containg DTML code.<br>thanx in advance.. <br><br><div class="gmail_quote">On Sat, Apr 12, 2008 at 9:30 PM, <<a href="mailto:zope-request@zope.org">zope-request@zope.org</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Send Zope mailing list submissions to<br>
<a href="mailto:zope@zope.org">zope@zope.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://mail.zope.org/mailman/listinfo/zope" target="_blank">http://mail.zope.org/mailman/listinfo/zope</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:zope-request@zope.org">zope-request@zope.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:zope-owner@zope.org">zope-owner@zope.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Zope digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: Upgrade to 2.7.2 results in all content unavailable (Jonathan)<br>
2. Re: Upgrade to 2.7.2 results in all content unavailable<br>
(Wes Modes)<br>
3. Re: Upgrade to 2.7.2 results in all content unavailable<br>
(Thomas Bennett)<br>
4. Critical System Hosed, Plan B - upgrade zope, convert db<br>
(Wes Modes)<br>
5. Database conversion (Wes Modes)<br>
6. Re: Database conversion (Andreas Jung)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Fri, 11 Apr 2008 14:24:09 -0400<br>
From: "Jonathan" <<a href="mailto:dev101@magma.ca">dev101@magma.ca</a>><br>
Subject: Re: [Zope] Upgrade to 2.7.2 results in all content<br>
unavailable<br>
To: "Wes Modes" <<a href="mailto:wmodes@ucsc.edu">wmodes@ucsc.edu</a>>, <<a href="mailto:zope@zope.org">zope@zope.org</a>><br>
Message-ID: <146101c89c01$3bf93fb0$677ba8c0@DESKTOP><br>
Content-Type: text/plain; format=flowed; charset="iso-8859-1";<br>
reply-type=original<br>
<br>
<br>
----- Original Message -----<br>
From: "Wes Modes" <<a href="mailto:wmodes@ucsc.edu">wmodes@ucsc.edu</a>><br>
To: "Dieter Maurer" <<a href="mailto:dieter@handshake.de">dieter@handshake.de</a>>; <<a href="mailto:zope@zope.org">zope@zope.org</a>><br>
Sent: Friday, April 11, 2008 1:44 PM<br>
Subject: Re: [Zope] Upgrade to 2.7.2 results in all content unavailable<br>
<br>
<br>
> 2008-04-11 10:36:54 ERROR ZODB.lock_file Error locking file<br>
> /var/lib/zope/var/Data.fs.lock<br>
> Traceback (most recent call last):<br>
> File "/usr/lib/zope/lib/python/ZODB/lock_file.py", line 63, in<br>
> __init__<br>
> lock_file(self._fp)<br>
> File "/usr/lib/zope/lib/python/ZODB/lock_file.py", line 42, in<br>
> lock_file<br>
> fcntl.flock(file.fileno(), _flags)<br>
> IOError: [Errno 11] Resource temporarily unavailable<br>
<br>
Make sure you have read/write access to the /var/lib/zope/var directory and<br>
that is 'owned' by 'zope'<br>
<br>
<br>
Jonathan<br>
<br>
<br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Fri, 11 Apr 2008 12:14:30 -0700<br>
From: Wes Modes <<a href="mailto:wmodes@ucsc.edu">wmodes@ucsc.edu</a>><br>
Subject: Re: [Zope] Upgrade to 2.7.2 results in all content<br>
unavailable<br>
To: Dieter Maurer <<a href="mailto:dieter@handshake.de">dieter@handshake.de</a>>, <a href="mailto:zope@zope.org">zope@zope.org</a><br>
Message-ID: <<a href="mailto:47FFB896.4030402@ucsc.edu">47FFB896.4030402@ucsc.edu</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
Better yet, here's a more informative debug output. It tells me that<br>
zope thinks this is a new instance. Though the old database is it place<br>
right where it should expect to see it.<br>
<br>
*[root@library zope]# bin/zopectl debug*<br>
Starting debugger (the name "app" is bound to the top-level Zope object)<br>
2008-04-11 12:04:05 WARNING Init Class<br>
Products.HappySession.HappySession.HappySession has a security<br>
declaration for nonexistent method 'manage_menu'<br>
[snipped a bunch of warnings...]<br>
<br>
*>>> import Zope, ZPublisher*<br>
<br>
*>>> ZPublisher.Zope('')*<br>
<br>
Status: 200 OK<br>
X-Powered-By: Zope (<a href="http://www.zope.org" target="_blank">www.zope.org</a>), Python (<a href="http://www.python.org" target="_blank">www.python.org</a>)<br>
Content-Length: 4066<br>
Content-Type: text/html<br>
<br>
[snipped a bunch of html and helpful info]<br>
Zope Quick Start<br>
You have not created any users in this Zope instance. In order to<br>
log in and manage this Zope instance, you'll need to add an<br>
adminstrative<br>
user account.<br>
<br>
If you're running Zope on UNIX or Linux, you can create an<br>
administrative<br>
user account via the "zopectl adduser" command from a shell.<br>
<b>Note: You'll<br>
need to shut Zope itself down before "zopectl adduser" will work.<br>
Restart<br>
Zope after executing this command in order to log in.</b><br>
<br>
WARNING: you are running Zope 2.8.X with python 2.4.X, this is not a<br>
supported<br>
combination. Don't file bugreports or ask for support on <a href="http://zope.org" target="_blank">zope.org</a>.<br>
____________________________________________________________<br>
<br>
<br>
<br>
And apparently, I'm running 2.8.7 not 2.7.2 as I thought. And I'm not<br>
supposted to ask you for help. Help!<br>
<br>
W.<br>
<br>
<br>
><br>
><br>
><br>
> Dieter Maurer wrote:<br>
>> Dieter Maurer wrote at 2008-4-11 19:13 +0200:<br>
>><br>
>>> Wes Modes wrote at 2008-4-10 21:04 -0700:<br>
>>><br>
>>>> I upgraded to Zope 2.7.2 and all of my content can't be seen by Zope.<br>
>>>> Honestly I'm not sure what the previous version I was running was (nor<br>
>>>> am I sure how to find out).<br>
>>>><br>
>>>> Now, every page results in<br>
>>>><br>
>>>> Site Error<br>
>>>> An error was encountered while publishing this resource.<br>
>>>> Resource not found<br>
>>>> Sorry, the requested resource does not exist.<br>
>>>> Check the URL and try again.<br>
>>>> Resource: Zope GET<br>
>>>><br>
>>> Difficult problems can be analyzed in interactive Python<br>
>>> sessions.<br>
>>><br>
>>> Under *nix, you start such a session with "bin/zopectl debug"<br>
>>> (under Windows, this does not work but there are alternatives).<br>
>>><br>
>>> from request import getRequest<br>
>>> request = getRequest()<br>
>>> obj = request.traverse('pathpart_of_your_url')<br>
>>> obj()<br>
>>><br>
>>> If authentication is required, you use<br>
>>><br>
>>> from request import getAuthRequest<br>
>>> request = getAuthRequest(user, password)<br>
>>> ....<br>
>>><br>
>>> If there are problems, you use "pdb.pm()" (or "dm.pdb.zpbd.pm()"<br>
>>> for better Zope support) to analyse them.<br>
>>><br>
>><br>
>> I forgot. You can download "request.py" from<br>
>><br>
>> <a href="http://www.dieter.handshake.de/pyprojects/zope/request.py" target="_blank">http://www.dieter.handshake.de/pyprojects/zope/request.py</a><br>
>><br>
>><br>
>> In order to get rid of a deprecation warning, you must replace "Zope"<br>
>> with "Zope2".<br>
>><br>
>><br>
>><br>
><br>
> --<br>
><br>
> Wes Modes<br>
> Server Administrator & Programmer Analyst<br>
> McHenry Library<br>
> Computing & Network Services<br>
> Information and Technology Services<br>
> 459-5208<br>
> ------------------------------------------------------------------------<br>
><br>
> _______________________________________________<br>
> Zope maillist - <a href="mailto:Zope@zope.org">Zope@zope.org</a><br>
> <a href="http://mail.zope.org/mailman/listinfo/zope" target="_blank">http://mail.zope.org/mailman/listinfo/zope</a><br>
> ** No cross posts or HTML encoding! **<br>
> (Related lists -<br>
> <a href="http://mail.zope.org/mailman/listinfo/zope-announce" target="_blank">http://mail.zope.org/mailman/listinfo/zope-announce</a><br>
> <a href="http://mail.zope.org/mailman/listinfo/zope-dev" target="_blank">http://mail.zope.org/mailman/listinfo/zope-dev</a> )<br>
><br>
<br>
--<br>
<br>
Wes Modes<br>
Server Administrator & Programmer Analyst<br>
McHenry Library<br>
Computing & Network Services<br>
Information and Technology Services<br>
459-5208<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://mail.zope.org/pipermail/zope/attachments/20080411/2d1aa22a/attachment-0001.htm" target="_blank">http://mail.zope.org/pipermail/zope/attachments/20080411/2d1aa22a/attachment-0001.htm</a><br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Fri, 11 Apr 2008 16:17:56 -0400<br>
From: Thomas Bennett <<a href="mailto:bennetttm@appstate.edu">bennetttm@appstate.edu</a>><br>
Subject: Re: [Zope] Upgrade to 2.7.2 results in all content<br>
unavailable<br>
To: <a href="mailto:zope@zope.org">zope@zope.org</a><br>
Message-ID: <<a href="mailto:200804111617.56442.bennetttm@appstate.edu">200804111617.56442.bennetttm@appstate.edu</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
have you used locate or any other utility to make sure you only have one Zope<br>
installed, like "locate zope.conf" ?<br>
<br>
Thomas<br>
<br>
On Friday 11 April 2008 15:14, Wes Modes wrote:<br>
> Better yet, here's a more informative debug output. It tells me that<br>
> zope thinks this is a new instance. Though the old database is it place<br>
> right where it should expect to see it.<br>
><br>
> *[root@library zope]# bin/zopectl debug*<br>
> Starting debugger (the name "app" is bound to the top-level Zope<br>
> object) 2008-04-11 12:04:05 WARNING Init Class<br>
> Products.HappySession.HappySession.HappySession has a security<br>
> declaration for nonexistent method 'manage_menu'<br>
> [snipped a bunch of warnings...]<br>
><br>
> *>>> import Zope, ZPublisher*<br>
><br>
> *>>> ZPublisher.Zope('')*<br>
><br>
> Status: 200 OK<br>
> X-Powered-By: Zope (<a href="http://www.zope.org" target="_blank">www.zope.org</a>), Python (<a href="http://www.python.org" target="_blank">www.python.org</a>)<br>
> Content-Length: 4066<br>
> Content-Type: text/html<br>
><br>
> [snipped a bunch of html and helpful info]<br>
> Zope Quick Start<br>
> You have not created any users in this Zope instance. In order to<br>
> log in and manage this Zope instance, you'll need to add an<br>
> adminstrative<br>
> user account.<br>
><br>
> If you're running Zope on UNIX or Linux, you can create an<br>
> administrative<br>
> user account via the "zopectl adduser" command from a shell.<br>
> <b>Note: You'll<br>
> need to shut Zope itself down before "zopectl adduser" will work.<br>
> Restart<br>
> Zope after executing this command in order to log in.</b><br>
><br>
> WARNING: you are running Zope 2.8.X with python 2.4.X, this is not a<br>
> supported<br>
> combination. Don't file bugreports or ask for support on <a href="http://zope.org" target="_blank">zope.org</a>.<br>
> ____________________________________________________________<br>
><br>
><br>
><br>
> And apparently, I'm running 2.8.7 not 2.7.2 as I thought. And I'm not<br>
> supposted to ask you for help. Help!<br>
><br>
> W.<br>
><br>
> > Dieter Maurer wrote:<br>
> >> Dieter Maurer wrote at 2008-4-11 19:13 +0200:<br>
> >>> Wes Modes wrote at 2008-4-10 21:04 -0700:<br>
> >>>> I upgraded to Zope 2.7.2 and all of my content can't be seen by Zope.<br>
> >>>> Honestly I'm not sure what the previous version I was running was (nor<br>
> >>>> am I sure how to find out).<br>
> >>>><br>
> >>>> Now, every page results in<br>
> >>>><br>
> >>>> Site Error<br>
> >>>> An error was encountered while publishing this resource.<br>
> >>>> Resource not found<br>
> >>>> Sorry, the requested resource does not exist.<br>
> >>>> Check the URL and try again.<br>
> >>>> Resource: Zope GET<br>
> >>><br>
> >>> Difficult problems can be analyzed in interactive Python<br>
> >>> sessions.<br>
> >>><br>
> >>> Under *nix, you start such a session with "bin/zopectl debug"<br>
> >>> (under Windows, this does not work but there are alternatives).<br>
> >>><br>
> >>> from request import getRequest<br>
> >>> request = getRequest()<br>
> >>> obj = request.traverse('pathpart_of_your_url')<br>
> >>> obj()<br>
> >>><br>
> >>> If authentication is required, you use<br>
> >>><br>
> >>> from request import getAuthRequest<br>
> >>> request = getAuthRequest(user, password)<br>
> >>> ....<br>
> >>><br>
> >>> If there are problems, you use "pdb.pm()" (or "dm.pdb.zpbd.pm()"<br>
> >>> for better Zope support) to analyse them.<br>
> >><br>
> >> I forgot. You can download "request.py" from<br>
> >><br>
> >> <a href="http://www.dieter.handshake.de/pyprojects/zope/request.py" target="_blank">http://www.dieter.handshake.de/pyprojects/zope/request.py</a><br>
> >><br>
> >><br>
> >> In order to get rid of a deprecation warning, you must replace "Zope"<br>
> >> with "Zope2".<br>
> ><br>
> > --<br>
> ><br>
> > Wes Modes<br>
> > Server Administrator & Programmer Analyst<br>
> > McHenry Library<br>
> > Computing & Network Services<br>
> > Information and Technology Services<br>
> > 459-5208<br>
> > ------------------------------------------------------------------------<br>
> ><br>
> > _______________________________________________<br>
> > Zope maillist - <a href="mailto:Zope@zope.org">Zope@zope.org</a><br>
> > <a href="http://mail.zope.org/mailman/listinfo/zope" target="_blank">http://mail.zope.org/mailman/listinfo/zope</a><br>
> > ** No cross posts or HTML encoding! **<br>
> > (Related lists -<br>
> > <a href="http://mail.zope.org/mailman/listinfo/zope-announce" target="_blank">http://mail.zope.org/mailman/listinfo/zope-announce</a><br>
> > <a href="http://mail.zope.org/mailman/listinfo/zope-dev" target="_blank">http://mail.zope.org/mailman/listinfo/zope-dev</a> )<br>
<br>
--<br>
====================================================================<br>
Thomas McMillan Grant Bennett Appalachian State University<br>
Operations & Systems Analyst P O Box 32026<br>
University Library Boone, North Carolina 28608<br>
(828) 262 6587<br>
<br>
"... using OpenOffice.org, and save them back to disk automatically,<br>
in MS Word format. They surf the Web, check e-mail, do instant<br>
messsaging, view YouTube videos, visit their Facebook pages, learn<br>
touch-typing skills and lots more. Our public library has been<br>
offering these Linux public stations for the past three years."<br>
- Phil Shapiro Linux Journal January 2008<br>
<br>
Library Systems Help Desk: <a href="https://www.library.appstate.edu/help/" target="_blank">https://www.library.appstate.edu/help/</a><br>
====================================================================<br>
<br>
<br>
------------------------------<br>
<br>
Message: 4<br>
Date: Fri, 11 Apr 2008 13:56:31 -0700<br>
From: Wes Modes <<a href="mailto:wmodes@ucsc.edu">wmodes@ucsc.edu</a>><br>
Subject: [Zope] Critical System Hosed, Plan B - upgrade zope, convert<br>
db<br>
To: <a href="mailto:zope@zope.org">zope@zope.org</a><br>
Message-ID: <<a href="mailto:47FFD07F.3030803@ucsc.edu">47FFD07F.3030803@ucsc.edu</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
Okay, I accept that Zope is a mysterious god that requires sacrifice.<br>
And I wasn't able to solve the mysteries of how to get it up and running<br>
again with my old data after an unintentional "upgrade."<br>
<br>
However... I can upgrade Python from 2.4.2 to 2.4.4 and upgrade Zope<br>
from 2.7.2 to 2.10.5, get that working, and then hopefully convert my<br>
old data.<br>
<br>
I can handle the python and zope upgrades, but have no idea how to take<br>
my old zope database and use it with my brand new zope installation.<br>
<br>
Any ideas?<br>
<br>
Wes<br>
<br>
--<br>
<br>
Wes Modes<br>
Server Administrator & Programmer Analyst<br>
McHenry Library<br>
Computing & Network Services<br>
Information and Technology Services<br>
459-5208<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://mail.zope.org/pipermail/zope/attachments/20080411/63a7fd94/attachment-0001.htm" target="_blank">http://mail.zope.org/pipermail/zope/attachments/20080411/63a7fd94/attachment-0001.htm</a><br>
<br>
------------------------------<br>
<br>
Message: 5<br>
Date: Fri, 11 Apr 2008 17:12:07 -0700<br>
From: Wes Modes <<a href="mailto:wmodes@ucsc.edu">wmodes@ucsc.edu</a>><br>
Subject: [Zope] Database conversion<br>
To: <a href="mailto:zope@zope.org">zope@zope.org</a><br>
Message-ID: <<a href="mailto:47FFFE57.4090302@ucsc.edu">47FFFE57.4090302@ucsc.edu</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
I am running Zope 2.10.5 I've just upgraded from Zope 2.7<br>
<br>
I would like to move my database to the newly created instance.<br>
<br>
I followed the very reasonable and clear instructions here,<br>
<a href="http://svn.zope.org/*checkout*/Zope/trunk/doc/FAQ.txt" target="_blank">http://svn.zope.org/*checkout*/Zope/trunk/doc/FAQ.txt</a> (esentially, just<br>
moving the Data.fs file)<br>
<br>
However, the old data does not come up when I bring up the server again.<br>
<br>
Perhaps the old objects need conversion or some other juju?<br>
<br>
Any suggestions?<br>
<br>
W.<br>
<br>
<br>
<br>
<br>
--<br>
<br>
Wes Modes<br>
Server Administrator & Programmer Analyst<br>
McHenry Library<br>
Computing & Network Services<br>
Information and Technology Services<br>
459-5208<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://mail.zope.org/pipermail/zope/attachments/20080411/10ff79ea/attachment-0001.htm" target="_blank">http://mail.zope.org/pipermail/zope/attachments/20080411/10ff79ea/attachment-0001.htm</a><br>
<br>
------------------------------<br>
<br>
Message: 6<br>
Date: Sat, 12 Apr 2008 05:50:24 +0200<br>
From: Andreas Jung <<a href="mailto:lists@zopyx.com">lists@zopyx.com</a>><br>
Subject: Re: [Zope] Database conversion<br>
To: Wes Modes <<a href="mailto:wmodes@ucsc.edu">wmodes@ucsc.edu</a>>, <a href="mailto:zope@zope.org">zope@zope.org</a><br>
Message-ID: <22828623676BA87FC44FC6B2@suxmac.local><br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
<br>
<br>
--On 11. April 2008 17:12:07 -0700 Wes Modes <<a href="mailto:wmodes@ucsc.edu">wmodes@ucsc.edu</a>> wrote:<br>
<br>
> I am running Zope 2.10.5 I've just upgraded from Zope 2.7<br>
><br>
> I would like to move my database to the newly created instance.<br>
><br>
> I followed the very reasonable and clear instructions here,<br>
> <a href="http://svn.zope.org/*checkout*/Zope/trunk/doc/FAQ.txt" target="_blank">http://svn.zope.org/*checkout*/Zope/trunk/doc/FAQ.txt</a> (esentially, just<br>
> moving the Data.fs file)<br>
><br>
> However, the old data does not come up when I bring up the server again.<br>
><br>
> Perhaps the old objects need conversion or some other juju?<br>
<br>
Even within the third new thread on this issue you have not told us about<br>
your "old" application. Is it core Zope? Using any third party-products?<br>
Please provide details about the things you have installed. We're not good<br>
in problem-solving-by-guessing.<br>
<br>
And please: don't create a new mail thread for followups. You have one issue<br>
and one mail thread is enough. We don't need three.<br>
<br>
Andreas<br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: not available<br>
Type: application/pgp-signature<br>
Size: 194 bytes<br>
Desc: not available<br>
Url : <a href="http://mail.zope.org/pipermail/zope/attachments/20080412/0cbd8303/attachment-0001.bin" target="_blank">http://mail.zope.org/pipermail/zope/attachments/20080412/0cbd8303/attachment-0001.bin</a><br>
<br>
------------------------------<br>
<br>
_______________________________________________<br>
Zope maillist - <a href="mailto:Zope@zope.org">Zope@zope.org</a><br>
<br>
<br>
<br>
End of Zope Digest, Vol 47, Issue 13<br>
************************************<br>
</blockquote></div><br><br clear="all"><br>-- <br>Best Regards<br>\madhan<br><br>Things must be learned only to be unlearned again or, more likely, to be corrected.<br> -- Richard Feynman