[Typo3-dev] tt_products 2.0.0 (table error)

[René Rossi]

Franz Holzinger wrote:

> The syntax in ext_tables.sql was changed due to
> http://bugs.typo3.org/view.php?id=560
> --------
>   CREATE TABLE tt_products (
>     uid int(11) unsigned NOT NULL auto_increment,
> ---------
> There is another bug report: http://bugs.typo3.org/view.php?id=384
>
> Give more details how you came to this error.
>
> Franz
>
ok, i´ve updated an older version of tt_products (1.2.7) on typo3.7.0 
via the extension manager and the only way to get rid this error massage 
was to reinsert the default key in ext_tables.sql.

there are two implementations of the same typosite so i can try to 
reproduce the error.
a dump of the table before the update(from ver 1.2.7):

#
# Tabellenstruktur für Tabelle `tt_products`
#

CREATE TABLE tt_products (
  uid int(11) unsigned NOT NULL auto_increment,
  pid int(11) unsigned NOT NULL default '0',
  tstamp int(11) unsigned NOT NULL default '0',
  hidden tinyint(4) unsigned NOT NULL default '0',
  starttime int(11) unsigned NOT NULL default '0',
  endtime int(11) unsigned NOT NULL default '0',
  title tinytext NOT NULL,
  note text NOT NULL,
  price varchar(20) NOT NULL default '',
  price2 varchar(20) NOT NULL default '',
  image tinyblob NOT NULL,
  www varchar(80) NOT NULL default '',
  itemnumber varchar(40) NOT NULL default '',
  category int(10) unsigned NOT NULL default '0',
  inStock int(11) NOT NULL default '0',
  deleted tinyint(3) unsigned NOT NULL default '0',
  ordered int(10) unsigned NOT NULL default '0',
  fe_group int(11) NOT NULL default '0',
  PRIMARY KEY  (uid),
  KEY parent (pid)
) TYPE=MyISAM;
    




Some infos about the system:
Linux daffy.perf.redhat.com 2.4.20-2.48smp #1 SMP Thu Feb 13 11:44:55 
EST 2003 i686 i686 i386 GNU/Linux
Mysql Version 3.23.52
Apache/2.0.40 (Red Hat Linux)