Personal tools
You are here: Home Lists ZPUG DC List Archives 2005 2005-11 postgreSQL - Archetypes connection / David Greisen <dgreisen@gmail.com>
Navigation
Log in


Forgot your password?
New user?
Mailing Lists
You can read our ZPUGDC mailing list archives online.
You can subscribe to our mailing list:
Book Review

The Definitive Guide to Plone

Reviewer: joel
 

postgreSQL - Archetypes connection / David Greisen <dgreisen@gmail.com>

postgreSQL - Archetypes connection
David Greisen <dgreisen(at)gmail.com>
2005-11-14 19:45:57 [ FULL ]
Hey all,

quick question about using database storage in an AT. I have set up the
database connection, it tests out alright, and i have linked the database
connection to my archetype. It works for storing stringfields and
datetimefields. I have two problems:

When I try to store a textfield I get a mimetype error:

 *AssertionError*[...]



The other problem is I have added a line to my AT:

schema['title'].storage=PostgreSQLStorage()



When I try to create an instance I get the error message:

The database connection *Psycopg_database_connection* cannot be found.[...]
however, the database table has been created by plone and an entry in the
table has been created with the right UID and default value for the datetime
field.

Any help on either of these issues would be greatly appreciated

Thanks,

David
Attachments: 
text.html text/html - 4799 Bytes

Re: [ZPUGDC] postgreSQL - Archetypes connection / Alex Clark <aclark@aclark.net>

Re: [ZPUGDC] postgreSQL - Archetypes connection
Alex Clark <aclark(at)aclark.net>
2005-11-21 09:50:59 [ FULL ]
Have you gotten past these problems yet ? 

In short, in the first error, it looks like Zope is trying to "do something"
(not
sure exactly what assertion error is) on an object that either does not exist
or does not have the fields/attributes/etc that Zope expects.

In the second error, your object cannot be found, for whatever reason. 
If you have a 

     Psycopg_database_connection (Z Psycopg Database Connection)

in the root of your site and you have renamed it to "myconn" or whatever and
that is the object your are referencing... then it would be hard to say
what the problem is.

On Mon, Nov 14, 2005 at 08:50:57PM -0500, David Greisen wrote:[...]
[...]

Powered by Plone, the Open Source Content Management System

This site conforms to the following standards: