[TYPO3-dev] Table error in extension

[Rainer Kuhn]

Thomas Mammitzsch wrote:
> i'm writing an extension which adds some tables and a new column to the
> tt_content table (holds information how the plugin is configured). The
> extension works fine, but in Ext-Manager->Information view i see some
> error messages:
> 
> Database status: Table error! Probably one or more required
> fields/tables are missing in the database!
> 
> Errors:	Some tables or fields are missing!
> [...]
> i also took a look in the InstallTool but the only thing it suggests is:
> 
> ALTER TABLE tx_vxreferences_clients CHANGE clientname clientname
> varchar(255) NOT NULL default "";
> Current value: varchar(255) NOT NULL default ''
> 
> ALTER TABLE tx_vxreferences_clients CHANGE description_short
> description_short varchar(255) NOT NULL default "";
> Current value: varchar(255) NOT NULL default ''
> 
> which seems to be the same as is.

Hi Thomas,
edit your extension file ext_tables.sql and replace all

NOT NULL default ""

with

NOT NULL default ''

This should fix your error messages in the extension manager.

HTH,
Rainer

--
PGP Key Fingerprint: 79B1 E6CF A6EB 60A1 D1E4 E41E 4C1E F87F 7B40 126C