On 2/24/07, paul kölle <[EMAIL PROTECTED]> wrote:
> Dr. Markus Gritsch schrieb:
> > Hi,
> >
> > the following simple script fails to run when using SQLObject 0.8.0.
> > It works fine when using SQLObject 0.7.3.
> >
> > ---
> >
> > from sqlobject import *
> >
> > sqlhub.processConnection = connectionForURI('mysql://[EMAIL
> > PROTECTED]/test')
> Can you please turn on debugging for the connection and show the
> generated SQL? This might have something to do with changeing id's to
> UNSIGNED...
Here the output when using
sqlhub.processConnection =
connectionForURI('mysql://[EMAIL PROTECTED]/test?debug=1')
---
1/Query : DESCRIBE person
1/Query : DROP TABLE person
1/Query : DESCRIBE person
1/Query : CREATE TABLE person (
id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
name TEXT
)
1/Query : DESCRIBE shortcut
1/Query : DROP TABLE shortcut
1/Query : DESCRIBE shortcut
1/Query : CREATE TABLE shortcut (
id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
person_id INT
)
1/Query : ALTER TABLE shortcut ADD CONSTRAINT
shortcut_person_id_exists FOREIGN KEY (person_id) REFERENCES person
(id)
Traceback (most recent call last):
File "0.8.py", line 15, in <module>
Shortcut.createTable(ifNotExists=True)
File
"c:\python25\lib\site-packages\sqlobject-0.8.0-py2.5.egg\sqlobject\main.py",
line 1394, in createTable
conn.query(constraint)
File
"c:\python25\lib\site-packages\sqlobject-0.8.0-py2.5.egg\sqlobject\dbconnection.py",
line 316, in query
return self._runWithConnection(self._query, s)
File
"c:\python25\lib\site-packages\sqlobject-0.8.0-py2.5.egg\sqlobject\dbconnection.py",
line 230, in _runWithConnection
val = meth(conn, *args)
File
"c:\python25\lib\site-packages\sqlobject-0.8.0-py2.5.egg\sqlobject\dbconnection.py",
line 313, in _query
self._executeRetry(conn, conn.cursor(), s)
File
"c:\python25\lib\site-packages\sqlobject-0.8.0-py2.5.egg\sqlobject\mysql\mysqlconnection.py",
line 109, in _executeRetry
raise OperationalError(ErrorMessage(e))
sqlobject.dberrors.OperationalError: Can't create table
'.\test\#sql-1d4_4.frm' (errno: 150)
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
