RE: [Zope] Frustrating
First thing, if your product is broken you won't get anywhere. So, first step is to delete the broken product, and shutdown and restart your zope server. This is because Zope apparently won't replace a broken product with a working one. If it is still broken, click on it, and then on the screen that comes up, look for the 'traceback' tab on the top of the screen. Copy this traceback and mail it to the list. If your product no longer says broken, then you will be able to go to a folder above where you want to use SQL methods, and from the pull-down menu beside the add button, choose to install the SQL Adapter. I don't know for certain the format for the connection string, but if you go to <zope_homedir>/lib/python/Products/ and look in the directory for the ZPyGreSQLDA and read the top of any *.py file you see, it should say. Once you have a working adapter, you can add an SQL Method, and it will list your adapter's id on its list of db connections.
From this point on the documentation in the SQL Guide should be sufficient.
Good luck! Howard C. Shaw III Programmer/SysAdmin St. Thomas High School
---------- From: Tom Deprez[SMTP:Tom.Deprez@uz.kuleuven.ac.be] Sent: Tuesday, March 30, 1999 4:28 AM To: zope@zope.org Subject: [Zope] Frustrating
Hi,
I'm getting really frustrating on this subject. Pff, I believe the Zope-people have made already a great effort in their documentation. So I guess my problem is my own bad english. shhg.
I finally got the Postgressql adapter compiled, thanks to two great people! Thanks for this already.
But now I'm confused? How to use it in Zope? When I go to the product management I see the all the installed products including : ZPyGreSQLDA (broken product APyGreSQL).... I guess here is already something wrong (broken... is not a positive word :-( )
But then, how can I work with it? How can I use it in Zope...? How can I add it to the 'Add list' . I read of a connection string... but where to place it?
Sggh, I've read in the manuals, Q&A, ... but I still don't get how to use it....
Please, somebody, help...!
Thanks in advance,
The Idiot,
Tom.
_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope
(For developer-specific issues, use the companion list, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )
Hi! I get this error when trying to start the server with start.bat: Traceback (innermost last): File "serve.py", line 100, in ? ZopeHTTPServer.main(args) File "E:\appl\net\Zope\Rio\ZopeHTTPServer\ZopeHTTPServer.py", line 498, in main start(module_file,host,port,threading,env) File "E:\appl\net\Zope\Rio\ZopeHTTPServer\ZopeHTTPServer.py", line 436, in start set_published_module(module_file,BoboRequestHandler,env) File "E:\appl\net\Zope\Rio\ZopeHTTPServer\ZopeHTTPServer.py", line 432, in set _published_module __import__(name) # to catch problem modules right away File "E:\appl\net\Zope\Rio\lib\python\Main.py", line 103, in ? Bobobase=OFS.Application.open_bobobase() File "E:\appl\net\Zope\Rio\lib\python\OFS\Application.py", line 319, in open_bobobase Bobobase=Globals.Bobobase=Globals.PickleDictionary( File "E:\appl\net\Zope\Rio\lib\python\BoboPOS\PickleDictionary.py", line 159, in __init__ db=apply(DBType,(),storage_options) File "E:\appl\net\Zope\Rio\lib\python\BoboPOS\SimpleDB.py", line 221, in __init__ self.open(file_name,create,revision_time,meta_index,read_only) File "E:\appl\net\Zope\Rio\lib\python\BoboPOS\SimpleDB.py", line 287, in open try: self.index,self.pos=read_index( File "E:\appl\net\Zope\Rio\lib\python\BoboPOS\SimpleDB.py", line 1365, in read _index raise DatabaseError, ('Corrupted data record at %s' % pos) DatabaseError: Corrupted data record at 1903771 Can I recover? The db doesn't contain anything important so it's really okay to reinstall, should that be neccessary. /J ------ ---- --- -- -- -- - - - - - Johan Lindström BossMedia Sourcerer johanl@bahnhof.se http://www.bahnhof.se/~johanl/ If the only tool you have is a hammer, everything tends to look like a nail
On Tue, Mar 30, 1999 at 07:53:09PM +0200, Johan Lindstrom wrote:
Hi!
I get this error when trying to start the server with start.bat:
Traceback (innermost last): [snipped] File "E:\appl\net\Zope\Rio\lib\python\BoboPOS\SimpleDB.py", line 1365, in read _index raise DatabaseError, ('Corrupted data record at %s' % pos) DatabaseError: Corrupted data record at 1903771
Can I recover? The db doesn't contain anything important so it's really okay to reinstall, should that be neccessary.
It looks like you're running an older release 1.9.x something? 1.10.x will automatically fix the database under 90% of the circumstances by simply truncating the bad record. This should fix your problem. BTW, it's always helpful to give information on what release of Zope you're using. Chris -- | Christopher Petrilli ``Television is bubble-gum for | petrilli@amber.org the mind.''-Frank Lloyd Wright
Johan Lindstrom wrote:
Hi!
I get this error when trying to start the server with start.bat:
Traceback (innermost last): File "serve.py", line 100, in ? ZopeHTTPServer.main(args) File "E:\appl\net\Zope\Rio\ZopeHTTPServer\ZopeHTTPServer.py", line 498, in main start(module_file,host,port,threading,env) File "E:\appl\net\Zope\Rio\ZopeHTTPServer\ZopeHTTPServer.py", line 436, in start set_published_module(module_file,BoboRequestHandler,env) File "E:\appl\net\Zope\Rio\ZopeHTTPServer\ZopeHTTPServer.py", line 432, in set _published_module __import__(name) # to catch problem modules right away File "E:\appl\net\Zope\Rio\lib\python\Main.py", line 103, in ? Bobobase=OFS.Application.open_bobobase() File "E:\appl\net\Zope\Rio\lib\python\OFS\Application.py", line 319, in open_bobobase Bobobase=Globals.Bobobase=Globals.PickleDictionary( File "E:\appl\net\Zope\Rio\lib\python\BoboPOS\PickleDictionary.py", line 159, in __init__ db=apply(DBType,(),storage_options) File "E:\appl\net\Zope\Rio\lib\python\BoboPOS\SimpleDB.py", line 221, in __init__ self.open(file_name,create,revision_time,meta_index,read_only) File "E:\appl\net\Zope\Rio\lib\python\BoboPOS\SimpleDB.py", line 287, in open try: self.index,self.pos=read_index( File "E:\appl\net\Zope\Rio\lib\python\BoboPOS\SimpleDB.py", line 1365, in read _index raise DatabaseError, ('Corrupted data record at %s' % pos) DatabaseError: Corrupted data record at 1903771
Can I recover?
At a minimum, you can truncate the data file (var\Data.bbb) at the position indicated. (Let me know if you need help with this.)
The db doesn't contain anything important so it's really okay to reinstall, should that be neccessary.
You could also just delete the database (var\Data.*) and a new database will be created when you restart. I'd appreciate it if you'd send me the corrupted database as a zipped or gzipped attachment in a private email. Also, what version of Zope were you running? What OS? What products (not included in the Zope distribution) did you have installed? Can you tell me anything more about what might have led up to this? Jim -- Jim Fulton mailto:jim@digicool.com Technical Director (540) 371-6909 Python Powered! Digital Creations http://www.digicool.com http://www.python.org Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email address may not be added to any commercial mail list with out my permission. Violation of my privacy with advertising or SPAM will result in a suit for a MINIMUM of $500 damages/incident, $1500 for repeats.
"Shaw, Howard" wrote First thing, if your product is broken you won't get anywhere. So, first step is to delete the broken product, and shutdown and restart your zope server. This is because Zope apparently won't replace a broken product with a working one.
Yah - this _really_ needs to be emphasised in the "how to write products" docs. It drove me nuts for about 10 minutes before I realised what was happening...
participants (5)
-
Anthony Baxter -
Christopher Petrilli -
Jim Fulton -
Johan Lindstrom -
Shaw, Howard