Sorry, I should've send the error logs...
here is the last few lines of output of:

paster setup-app development.ini

----------
Traceback (most recent call last):
  File "/home/tim/tg2env/bin/paster", line 8, in <module>
    load_entry_point('PasteScript==1.7.3', 'console_scripts', 'paster')()
File "/home/tim/tg2env/lib/python2.6/site-packages/PasteScript-1.7.3-py2.6.egg/paste/script/command.py", line 84, in run
    invoke(command, command_name, options, args[1:])
File "/home/tim/tg2env/lib/python2.6/site-packages/PasteScript-1.7.3-py2.6.egg/paste/script/command.py", line 123, in invoke
    exit_code = runner.run(args)
File "/home/tim/tg2env/lib/python2.6/site-packages/PasteScript-1.7.3-py2.6.egg/paste/script/appinstall.py", line 68, in run
    return super(AbstractInstallCommand, self).run(new_args)
File "/home/tim/tg2env/lib/python2.6/site-packages/PasteScript-1.7.3-py2.6.egg/paste/script/command.py", line 218, in run
    result = self.command()
File "/home/tim/tg2env/lib/python2.6/site-packages/PasteScript-1.7.3-py2.6.egg/paste/script/appinstall.py", line 456, in command
    self, config_file, section, self.sysconfig_install_vars(installer))
File "/home/tim/tg2env/lib/python2.6/site-packages/PasteScript-1.7.3-py2.6.egg/paste/script/appinstall.py", line 598, in setup_config
    mod.setup_app, command, filename, section, vars)
File "/home/tim/tg2env/lib/python2.6/site-packages/PasteScript-1.7.3-py2.6.egg/paste/script/appinstall.py", line 612, in _call_setup_app
    func(command, conf, vars)
File "/home/tim/tg2env/nms/nms/websetup/__init__.py", line 19, in setup_app
    bootstrap.bootstrap(command, conf, vars)
File "/home/tim/tg2env/nms/nms/websetup/bootstrap.py", line 18, in bootstrap
    u = model.User()
  File "<string>", line 4, in __init__
File "/home/tim/tg2env/lib/python2.6/site-packages/SQLAlchemy-0.5.1-py2.6.egg/sqlalchemy/orm/attributes.py", line 878, in initialize_instance
    fn(self, instance, args, kwargs)
File "/home/tim/tg2env/lib/python2.6/site-packages/SQLAlchemy-0.5.1-py2.6.egg/sqlalchemy/orm/mapper.py", line 1738, in _event_on_init
    instrumenting_mapper.compile()
File "/home/tim/tg2env/lib/python2.6/site-packages/SQLAlchemy-0.5.1-py2.6.egg/sqlalchemy/orm/mapper.py", line 661, in compile
    mapper._post_configure_properties()
File "/home/tim/tg2env/lib/python2.6/site-packages/SQLAlchemy-0.5.1-py2.6.egg/sqlalchemy/orm/mapper.py", line 689, in _post_configure_properties
    prop.init()
File "/home/tim/tg2env/lib/python2.6/site-packages/SQLAlchemy-0.5.1-py2.6.egg/sqlalchemy/orm/interfaces.py", line 405, in init
    self.do_init()
File "/home/tim/tg2env/lib/python2.6/site-packages/SQLAlchemy-0.5.1-py2.6.egg/sqlalchemy/orm/properties.py", line 707, in do_init
    self._determine_joins()
File "/home/tim/tg2env/lib/python2.6/site-packages/SQLAlchemy-0.5.1-py2.6.egg/sqlalchemy/orm/properties.py", line 796, in _determine_joins
    "many-to-many relation, 'secondaryjoin' is needed as well." % (self))
sqlalchemy.exc.ArgumentError: Could not determine join condition between parent/child tables on relation Message.from_person. Specify a 'primaryjoin' expression. If this is a many-to-many relation, 'secondaryjoin' is needed as well.
----------

Sanjiv Singh yazmış:
Hi Timucin,

You will have to provide more information, e.g. how you are trying to
join the tables? and what errors you are getting? for people to be
able to help you.

regards
Sanjiv

2010/2/11 Timuçin Kızılay <[email protected]>:
I'm getting errors when I try to join multiple fields from one table to
another. can anybody help me? I'm stuch reading documents for hours with no
luck.

here is the table definitions : http://pastebin.com/m1c358058

---------

class Person(DeclarativeBase):
    __tablename__ = 'person'
    id = Column(Integer,primary_key=True)
    name = Column(Unicode(50), index=True, unique=True, nullable=False)
    email = Column(Unicode(100), index=True)
    address = Column(Unicode(255), index=True)

#ürün tablosu
class Message(DeclarativeBase):
    __tablename__ = 'message'
    id = Column(Integer, primary_key=True)
    message_text = Column(Unicode(1000), index=True)
    from_person_id = Column(Integer, ForeignKey('person.id'),
nullable=False)
    from_person = relation('Person', foreign_keys=from_person_id,
backref='messages_sent')
    to_person_id = Column(Integer, ForeignKey('person.id'), nullable=False)
    to_person = relation('Person', foreign_keys=to_person_id,
backref='messages_rcvd')

------------



--
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en.



--
You received this message because you are subscribed to the Google Groups 
"TurboGears" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/turbogears?hl=en.

Reply via email to