[SQLObject] style trouble

[cvigny <cv...@ar...>]

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