[TYPO3] Data fields missing
Gunda
gunda at intekom.co.za
Fri Dec 8 22:37:48 CET 2006
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
More information about the TYPO3-english
mailing list