Re: [Zope-DB] Can I change the ZSQL max_rows default value?
Robert-Reinder Nederhoed wrote: > Good day, > > > We use Zope 2.8, still from ZMI. We ran into the 1000 limit several > times. Instead of remembering to set it to a higher value, I would like > to change the ZSQL max_rows default to 5000. > > Is it possible to do this? > > > Friendly greetings, Robert-Reinder > > -- > > ___ > Zope-DB mailing list > Zope-DB@zope.org > http://mail.zope.org/mailman/listinfo/zope-db > in your zsql object there is aan "advanced" tab. there you can set the limit. if you set it to 0 all rows will be returned. robert begin:vcard fn:robert rottermann n:rottermann;robert email;internet:[EMAIL PROTECTED] tel;work:031 333 10 20 tel;fax:031 333 10 23 tel;home:031 333 36 03 x-mozilla-html:FALSE version:2.1 end:vcard ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] mayday: zope does not start with ERROR ZODB.Connection Couldn't load state for 0x01 error
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
sorry for crossposting.
after stoping and restarting zope one of the zeo/zope instances does
not start anymore, and stop with an error.
what could be the reason. how can we fix it.
fstest.py does not report any error.
thanks very much
robert
2007-02-06 18:43:44 ERROR ZODB.Connection Couldn't load state for 0x01
Traceback (most recent call last):
File "/webserver/zope/Zope-2.9.3/lib/python/ZODB/Connection.py", line
735, in setstate
self._setstate(obj)
File "/webserver/zope/Zope-2.9.3/lib/python/ZODB/Connection.py", line
789, in _setstate
self._reader.setGhostState(obj, p)
File "/webserver/zope/Zope-2.9.3/lib/python/ZODB/serialize.py", line
604, in setGhostState
state = self.getState(pickle)
File "/webserver/zope/Zope-2.9.3/lib/python/ZODB/serialize.py", line
597, in getState
return unpickler.load()
File "/webserver/zope/Zope-2.9.3/lib/python/ZODB/serialize.py", line
479, in _persistent_load
return self.loaders[reference_type](self, *args)
File "/webserver/zope/Zope-2.9.3/lib/python/ZODB/serialize.py", line
540, in load_multi_oid
conn = self._conn.get_connection(database_name)
File "/webserver/zope/Zope-2.9.3/lib/python/ZODB/Connection.py", line
308, in get_connection
new_con = self._db.databases[database_name].open(
KeyError: 'root'
Traceback (most recent call last):
File "/webserver/zope/Zope-2.9.3/lib/python/Zope2/Startup/run.py",
line 56, in ?
run()
File "/webserver/zope/Zope-2.9.3/lib/python/Zope2/Startup/run.py",
line 21, in run
starter.prepare()
File
"/webserver/zope/Zope-2.9.3/lib/python/Zope2/Startup/__init__.py", line
98, in prepare
self.startZope()
File
"/webserver/zope/Zope-2.9.3/lib/python/Zope2/Startup/__init__.py", line
257, in startZope
Zope2.startup()
File "/webserver/zope/Zope-2.9.3/lib/python/Zope2/__init__.py", line
47, in startup
_startup()
File "/webserver/zope/Zope-2.9.3/lib/python/Zope2/App/startup.py",
line 103, in startup
OFS.Application.initialize(application)
File "/webserver/zope/Zope-2.9.3/lib/python/OFS/Application.py", line
304, in initialize
initializer.initialize()
File "/webserver/zope/Zope-2.9.3/lib/python/OFS/Application.py", line
325, in initialize
self.install_cp_and_products()
File "/webserver/zope/Zope-2.9.3/lib/python/OFS/Application.py", line
345, in install_cp_and_products
app._setObject('Control_Panel', cpl)
File "/webserver/zope/Zope-2.9.3/lib/python/ZODB/Connection.py", line
735, in setstate
self._setstate(obj)
File "/webserver/zope/Zope-2.9.3/lib/python/ZODB/Connection.py", line
789, in _setstate
self._reader.setGhostState(obj, p)
File "/webserver/zope/Zope-2.9.3/lib/python/ZODB/serialize.py", line
604, in setGhostState
state = self.getState(pickle)
File "/webserver/zope/Zope-2.9.3/lib/python/ZODB/serialize.py", line
597, in getState
return unpickler.load()
File "/webserver/zope/Zope-2.9.3/lib/python/ZODB/serialize.py", line
479, in _persistent_load
return self.loaders[reference_type](self, *args)
File "/webserver/zope/Zope-2.9.3/lib/python/ZODB/serialize.py", line
540, in load_multi_oid
conn = self._conn.get_connection(database_name)
File "/webserver/zope/Zope-2.9.3/lib/python/ZODB/Connection.py", line
308, in get_connection
new_con = self._db.databases[database_name].open(
KeyError: 'root'
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org
iD8DBQFFyMEQGaryJ0T9kUYRAjLrAJ92qgUaBl4E1vnhKVcOLD9nk+Gy8gCdGDVf
ZmIaBtkY8Gbl46T9rkth6Vc=
=uZhM
-END PGP SIGNATURE-
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] PloneFormGen + DataGridField -> Updating DB data
Am 06.02.2007, 17:13 Uhr, schrieb Paul Eipper <[EMAIL PROTECTED]>: I need to populate several DG fields on one form that will allow to update, delete and insert new data to my database. Is there a tutorial or some docs about that somewhere? Sorry, I have no idea how DG works. There are tutorials on how to use relational databases in Zope using ZSQL methods in the Zope book. Charlie ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] PloneFormGen + DataGridField -> Updating DB data
Am 06.02.2007, 13:49 Uhr, schrieb Paul Eipper <[EMAIL PROTECTED]>: Hello I'm currently using PFG+DataGrid fields to insert data on a MySQL DB, but now I need a form to allow to update that data. How can I do this with DG fields without having a column showing the ID? Also, how can I delete DG fields from the database? I submitted a feature request for PFG to allow DG fields have hidden columns exactly for this purpouse, but is there another way I can do this without having to wait this feature to (hopefully getting implemented? Sounds like a PFG issue. If you can write your own template for the form then there shouldn't be any problems. Charlie ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] PloneFormGen + DataGridField -> Updating DB data
Hello :) I'm currently using PFG+DataGrid fields to insert data on a MySQL DB, but now I need a form to allow to update that data. How can I do this with DG fields without having a column showing the ID? Also, how can I delete DG fields from the database? I submitted a feature request for PFG to allow DG fields have hidden columns exactly for this purpouse, but is there another way I can do this without having to wait this feature to (hopefully ;) getting implemented? Thanks -- Paul Eipper ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Can I change the ZSQL max_rows default value?
> We use Zope 2.8, still from ZMI. We ran into the 1000 limit several > times. Instead of remembering to set it to a higher value, I would > like to change the ZSQL max_rows default to 5000. > > Is it possible to do this? A bit dirty hack but it is at: lib/python/Shared/DC/ZRDB in class DA If you want then you may modify 'max_rows' value there. or override this in lib/Python/Products/ZSQLMethods -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Can I change the ZSQL max_rows default value?
Am 06.02.2007, 10:29 Uhr, schrieb Robert-Reinder Nederhoed <[EMAIL PROTECTED]>: Good day, We use Zope 2.8, still from ZMI. We ran into the 1000 limit several times. Instead of remembering to set it to a higher value, I would like to change the ZSQL max_rows default to 5000. Is it possible to do this? Yes, click on the "Advanced" tab of your ZSQL method. Charlie ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] Can I change the ZSQL max_rows default value?
Good day, We use Zope 2.8, still from ZMI. We ran into the 1000 limit several times. Instead of remembering to set it to a higher value, I would like to change the ZSQL max_rows default to 5000. Is it possible to do this? Friendly greetings, Robert-Reinder -- ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
