- Zope - Zope lists

RE: [Zope] Trouble compiling ZMySQLDA
by Eric L. Walstad 10 Jul '00

10 Jul '00

Hi Again, Ewald, // I think I'ts a shame information like this isn't in the ZMySQLDA docs. I // think // it's also a bit of a shame that it's so easy (at least for stupid folks // like me :-) // to download an old version of ZMySQLDA from zope.org while installing // version 1.2 // is a piece of cake. If you search the archives for my name (Walstad) you will see a LOT of questions on how to compile the MySQLDA and MySQLDB. I had a really hard time with it. I now have it working nicely and am happy with it on my "hobby" sites (www.walstads.net) However, I am now considering going to PostgreSQL, instead of MySQL, to serve a business site I am working on so I may have even more to learn. If you are going to use your DB for a production site, I would recommend you look into the comparisons between MySQL and PostgreSQL. PostgreSQL may be a better fit for you and getting started with it now may save you some frustration later on. The mailing list archives have a few discussions on the differences and benefits of each DB. As far as poor documentation goes, I feel your pain. If you believe in "No Pain, No Gain" then relax, you are going to gain a lot from the experience. I'm not a masichist, but I am glad I stuck with it. I like the "open sores" (that's what my wife calls it) community as it has no borders and promotes boundless learning. I'm sure everyone on the list has had similar experiences and will help out as "free" time allows. Good luck. Eric.

1 0

Testing For Filesize
by Terry Babbey 10 Jul '00

10 Jul '00

I am trying to create a automated drop down list, and here is my code so far: <form NAME="BOOGER"> <SELECT name="myList"> <dtml-in "objectValues(['DTML Document'])"> <OPTION value='<dtml-var id>'><dtml-var title></OPTION> </dtml-in> </SELECT> </form> I would like to be more specific though and only list files of zero byte size. Is this possible? Terry -- __________________________________________________________________ Terry Babbey Technical Support Specialist Lambton College, Sarnia, Ontario, Canada __________________________________________________________________

2 1

Re: Zippy not working.
by Terje Malmedal 10 Jul '00

10 Jul '00

[Terje Malmedal] > Hi, I can't get Zippy to work with Zope 2.1.6, I had it working in > Zope 2.0, did something change? Strange, now it works. Oh well never mind. -- - Terje tm(a)funcom.com

1 0

Zippy not working.
by Terje Malmedal 10 Jul '00

10 Jul '00

Hi, I can't get Zippy to work with Zope 2.1.6, I had it working in Zope 2.0, did something change? -- - Terje tm(a)funcom.com

1 0

Re: [Zope] C:\Program Files\WebSite>"C:\Program Files\WebSite\bin\python.exe"
by Dieter Maurer 10 Jul '00

10 Jul '00

Jonathan DESP writes: > I'm getting a problem, I don't understand what it is, my friend and me > didnot find the problem too. > > .... > > raise CorruptedTransactionError, message > ZODB.FileStorage.CorruptedTransactionError: C:\Program > Files\WebSite/var/Data.fs > data record exceeds transaction record at 34224435 > > C:\Program Files\WebSite> Your "var/Data.fs" is corrupted. You could use the "tranalyser" product (-> zope.org) to analyse your file and fix it. Dieter

1 0

ANNOUNCE: Zope 2.2.0 beta 4 released
by Brian Lloyd 10 Jul '00

10 Jul '00

Hi all, Zope 2.2.0 beta 4 has been released - you can download it from Zope.org: http://www.zope.org/Products/Zope/2.2.0b4/ This release includes fixes for a number of bugs found in the beta cycle, including a fix for the recent database packing issue. It also contains updated online help and API documentation. I expect this to be the last beta before 2.2 final. For more information, see the CHANGES.txt file for the release: http://www.zope.org/Products/Zope/2.2.0b4/CHANGES.txt If you are still using a 2.1.x version of Zope, be sure to see the document upgrading to Zope 2.2: http://www.zope.org/Products/Zope/2.2.0b4/upgrading_to_220 for information on the recent changes to the Zope security model and other upgrade information. Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

C:\Program Files\WebSite>"C:\Program Files\WebSite\bin\python.exe" "C:\Program F "C:\Program F
by Jonathan DESP 10 Jul '00

10 Jul '00

Hi, I'm getting a problem, I don't understand what it is, my friend and me didnot find the problem too. It's not a problem of size, because I have it on my computer, and I can easily handle that amount of size. Also, it's not the size limit inside Zope, because I have another data.fs, and it's about 60 000, and all work fine. and it's not the zope files around, because I run under windows, and my server run under linux. so, when I upload the data.fs in my new zope in my computer, the files are not the same, but I assure you that my zope in my local machine is clean. but the proplem is still there. so I think it's in the core of this accurate data.fs 36 000. here you can read --> C:\Program Files\WebSite>"C:\Program Files\WebSite\bin\python.exe" "C:\Program F iles\WebSite\z2.py" -D Traceback (innermost last): File "C:\Program Files\WebSite\z2.py", line 449, in ? exec "import "+MODULE in {} File "<string>", line 1, in ? File "C:\Program Files\WebSite\lib\python\Zope\__init__.py", line 109, in ? DB=ZODB.FileStorage.FileStorage(Globals.BobobaseName) File "C:\Program Files\WebSite\lib\python\ZODB\FileStorage.py", line 301, in _ _init__ self._pos, self._oid, tid = read_index( File "C:\Program Files\WebSite\lib\python\ZODB\FileStorage.py", line 1358, in read_index name, pos) File "C:\Program Files\WebSite\lib\python\ZODB\FileStorage.py", line 218, in p anic raise CorruptedTransactionError, message ZODB.FileStorage.CorruptedTransactionError: C:\Program Files\WebSite/var/Data.fs data record exceeds transaction record at 34224435 C:\Program Files\WebSite>

3 2

product import error - please help
by Eagan hills 10 Jul '00

10 Jul '00

All, I am working on a new installation of Zope under Red Hat 6.3. When trying to import any product (Portal Toolkit, Squishdot, KM news etc.), I get an error - internal server error (500). It seems as if the page isnt there. There is an import directory under the Zope root directory. Any ideas or suggestions will be greatly appreciated. Thanks Demos __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com

2 1

Trouble compiling ZMySQLDA
by Ewald Wasscher 10 Jul '00

10 Jul '00

Hello all, When I try to compile ZMySQLDA I get the following error messages after typing make: [root@catv6216 src]# make gcc -fPIC -I/usr/local/mysql/include -I/usr/include/mysql -g -O2 -I/usr/include/python1.5 -I/usr/include/python1.5 -DHAVE_CONFIG_H -c ./MySQLmodule.c ./MySQLmodule.c: In function `pythonify_row': ./MySQLmodule.c:238: warning: assignment from incompatible pointer type ./MySQLmodule.c: In function `pythonify_res_fields': ./MySQLmodule.c:384: invalid lvalue in unary `&' ./MySQLmodule.c: In function `STH_fetchdict': ./MySQLmodule.c:1125: invalid lvalue in unary `&' ./MySQLmodule.c:1147: invalid lvalue in unary `&' make: *** [MySQLmodule.o] Error 1 [root@catv6216 src]# I can't even read a single line of c so I have no idea what's wrong exactly. FYI: OS: Immunix 6.2 (= RedHat 6.2 + stackguard) Zope: 2.1.6 (compiled from Jeff Rush's source rpm, 2.2b3 doesn't work either) MySQL: 3.22.32 and 3.23.21 Python MySQLdb: 2.0 2.1 Ewald Wasscher

4 9

MySQLDA Won't build
by Darin Lee 10 Jul '00

10 Jul '00

Help, I cannot get the MySQL Database Adaptor to build. Error: gcc -shared _mysqlmodule.o -L/usr/local/lib/mysql -o _mysqlmodule.so Whoa, couldn't import _mysql: ./_mysqlmodule.so: undefined symbol: mysql_store_result Probably _mysqlmodule.so didn't compile correctly. Or your library paths may be bad. Check the FAQ. I checked the faq (also downloaded and compiled lastest versions - MySQL, Python, and Zope from source) - nada. I've set LD_LIBRARY_CONFIG, I've also edited the "Setup.in" file many, many times. No joy (My MySQL is in /usr/local). System is Redhat 6.1 - Intel... Any idea on what could be wrong?? Thanks, -Darin Lee

3 2