|
From: cvigny <cv...@ar...> - 2003-09-22 17:23:23
|
Hi,
I have a problem using the Style object, I create my style for the
foreign key building in idtable but it don't work.
Please could you help with that ?
here the py, sql and traceback code.
I try to subscribe the mailling list but no response right now
Traceback (most recent call last):
File "D:\python\artonline\tt.py", line 55, in ?
u = Url.new(protocol=p)
File "C:\Python22\Lib\site-packages\SQLObject\SQLObject.py", line 800,
in new
inst._SO_finishCreate()
File "C:\Python22\Lib\site-packages\SQLObject\SQLObject.py", line 820,
in _SO_finishCreate
names, values)
File "C:\Python22\Lib\site-packages\SQLObject\DBConnection.py", line
127, in queryInsertID
return self._runWithConnection(self._queryInsertID, table, idName,
names, values)
File "C:\Python22\Lib\site-packages\SQLObject\DBConnection.py", line
73, in _runWithConnection
val = meth(conn, *args)
File "C:\Python22\Lib\site-packages\SQLObject\DBConnection.py", line
370, in _queryInsertID
c.execute(q)
File "C:\Python22\lib\site-packages\MySQLdb\cursors.py", line 95, in
execute
return self._execute(query, args)
File "C:\Python22\lib\site-packages\MySQLdb\cursors.py", line 114, in
_execute
self.errorhandler(self, exc, value)
File "C:\Python22\lib\site-packages\MySQLdb\connections.py", line 33,
in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1054, "Unknown column 'protocol_id'
in 'field list'")
CREATE TABLE `url` (
`id` int(25) unsigned NOT NULL auto_increment,
`idprotocol` int(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM
CREATE TABLE `protocol` (
`id` int(3) unsigned NOT NULL auto_increment,
`protocol` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM
|