Column UID missing in custom TYPO3 v10 extension

While updating my TYPO3 project from v7 to v10, I encountered some difficulties with my custom extensions. Due to that I just tried to rebuild the demo extension from the official TYPO3 website: https://docs.typo3.org/m/typo3/book-extbasefluid/10.4/en-us/4-FirstExtension/2-create-folder-structure-and-configuration-files.html to see what has changed over the years. I followed the instruction as stated on the website.

After successfully activating the extension, I browsed to the list view but I get the following error:

Unknown column ‘uid’ in ‘field list’ link to error message

I checked my database and the column ‘uid’ really is missing, column ‘pid’ exists.

This is my ext_tables.sql:

    uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,

    name varchar(255) DEFAULT '' NOT NULL,
    description text NOT NULL,
    quantity int(11) DEFAULT '0' NOT NULL,

    PRIMARY KEY (uid),
    KEY parent (pid)
);

On my second attempt I copied the entire project from https://github.com/TYPO3-Documentation-Examples/store_inventory but still encounter the same error.

Do you have an idea what I have to change, to not receive that error anymore?

Answer

After dropping the database table and creating it newly it worked.

Advertisement

Answer