Hi all, I have been trying to resolve an error that appears when I try to do the following:

------------------------------------------------------------------------------------------------
from sqlobject import *
connection_string = 'mysql://root:password@localhost/kway'
connection = connectionForURI(connection_string)
sqlhub.processConnection = connection

class  Contact(SQLObject):
    name=StringCol()
    surname=StringCol()
   
class Person(SQLObject):
    name=StringCol()
    surname=StringCol()
    tel=StringCol(default=None)
    mobile=StringCol(default=None)
    fax=StringCol(default=None)
    email=StringCol(default=None)
    father=StringCol(default=None)
    mother=StringCol(default=None)
    adt=StringCol(default=None)
    afm=StringCol(default=None)
    contact=ForeignKey('Contact')
   
class Address(SQLObject):
    street=StringCol()
    number=StringCol()
    city=StringCol()
    zip=StringCol(default=None)
    person=ForeignKey('Person')

--------------------------------------------------------------------------------------------------------------------------------
When I try Contact.createTable() everything is OK.
But when I subsequently try Person.createTable() I get the following error (the same happens with Address.createTable() :

Traceback (most recent call last):
  File "<input>", line 1, in ?
  File "c:\python24\lib\site-packages\SQLObject-0.8.0-py2.4.egg\sqlobject\main.py", line 1394, in createTable
    conn.query(constraint)
  File "c:\python24\lib\site-packages\SQLObject-0.8.0-py2.4.egg\sqlobject\dbconnection.py ", line 316, in query
    return self._runWithConnection(self._query, s)
  File "c:\python24\lib\site-packages\SQLObject-0.8.0-py2.4.egg\sqlobject\dbconnection.py", line 230, in _runWithConnection
    val = meth(conn, *args)
  File "c:\python24\lib\site-packages\SQLObject-0.8.0-py2.4.egg\sqlobject\dbconnection.py", line 313, in _query
    self._executeRetry(conn, conn.cursor(), s)
  File "c:\python24\lib\site-packages\SQLObject- 0.8.0-py2.4.egg\sqlobject\mysql\mysqlconnection.py", line 109, in _executeRetry
    raise OperationalError(ErrorMessage(e))
OperationalError: Can't create table 'kway.#sql-28c_4' (errno: 150)


But when I check the created tables, I find out that the tables are actually created.
After some investigation, I found out that this is  due to the ForeignKey declaration (If I comment it out, the error doesn't appear).
I have tried a lot to resolve this error to no avail. Any help will be greatly appreciated!!!!
(I am running winXP sp2, mysql5.1.16b, python2.4 and SQLObject 0.8.0)

thanks, 
Nik