[TYPO3] Data fields missing

[R. van Twisk]

Gunda,

I have seen this type of error already on quite a number of occasions
including myself.

It looks like that typo3 in combination with MySQL 5.x drops
the uid field during installation. I think it's the SQL parser
that is buggy one way or the other, not sure though...

I always managed to solve the issue by manually adding the uid myself.


Ries



> Hi, 
> A problem occurred in extension tt_products which might not be extension specific:
> When setting up a new product (record) in the sys-folder, I get the following error 
> message:
>
> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result 
> resource in C:\typo3wamp\t3lib\class.t3lib_db.php on line 801
> this is repeated twice and followed by:
> Unknown column'tt_products_cat.uid' in 'field list'. This may indicate a table defined 
> in tables.php is not existing in the database! C:\type3\htdocs\typo3wamp\t3lib_db.php 
> on line 789
>
> First two lines repeated for line 826 followed by:
> Unknow column 'tt_products.uid' in 'field list' this may indicate a table defined ... as 
> above.
>
> Further, when checking the extension, it says that an Update is needed in the 
> following tables:
> Alter Table tt_products ADD uid int(11) unsigned NOT NULL auto_increment;
> Alter Table tt_products ADD PRIMARY KEY (uid);
> Alter Table tt_products_cat ADD uid int(11) unsignded NOT NULL auto_increment;
> Alter Table tt_products_cat ADD PRIMARY KEY (uid);
>
> It does not seem to do any update. I have tried 3 times to make updates, and every 
> time I check this extension, I get the same fields that need to be updated.
>
> Database status: Table Error
>
> I have the following installations: WIN XP, Typo3 4.0, tt_products 2.5.1 with latest 
> fh_library and table ext. MySQL Version 5.0.15, PHP Version 5.0.5
>
> Can anybody help me please? 
>
> Many thanks in advance!
> Gunda
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>   


-- 
Ries van Twisk
Freelance Typo3 Developer
=== Private:
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/freelance-typo3.html
skype: callto://r.vantwisk