Bug #63770
closedSQL Error when Page Behaviour is "use as root page"
0%
Description
Page properties -> Behaviour
Misc -> Use as Root Page -> Enable
When saving, an error occurs:
2: SQL error: 'Unknown column 'categories' in 'field list'' (pages:1)
Updated by Lars Brinkmann over 9 years ago
Same error occurs, when I try to change other properties, e.g. "Hide in menu" or change the value in the layout field.
Updated by Markus Klein over 9 years ago
- Status changed from New to Needs Feedback
Please go to the Install Tool and run the Database Analyzer (Important Actions). You DB seems to be outdated.
Updated by Lars Brinkmann over 9 years ago
Markus Klein wrote:
Please go to the Install Tool and run the Database Analyzer (Important Actions). You DB seems to be outdated.
It was a clean, new installation. So I didn't thought of this. Now I checked it and the result was the following:
Database analyzer
Add tables
1. select/deselect all
2. CREATE TABLE cf_extbase_typo3dbbackend_queries ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) NOT NULL default '', expires int(11) unsigned NOT NULL default '0', content mediumblob, PRIMARY KEY (id), KEY cache_id (identifier,expires) ) ENGINE=InnoDB;
3. CREATE TABLE cf_extbase_typo3dbbackend_queries_tags ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) NOT NULL default '', tag varchar(250) NOT NULL default '', PRIMARY KEY (id), KEY cache_id (identifier), KEY cache_tag (tag) ) ENGINE=InnoDB;
Add fields to tables
1. select/deselect all
2. ALTER TABLE pages ADD categories int(11) NOT NULL default '0';
3. ALTER TABLE sys_file_metadata ADD categories int(11) NOT NULL default '0';
4. ALTER TABLE tt_content ADD categories int(11) NOT NULL default '0';
I executed the queries and after that, the errors didn't appear anymore.
But - it was a clean, new installation of TYPO3 7.02.
Thx for help.
Updated by Markus Klein over 9 years ago
Thanks for the detailed report. It looks like there's a problem with the SchemaMigrator then, because those two cache-tables should be added automatically.
Will try to do a clean install again.
Updated by Markus Klein over 9 years ago
I tried it just now and couldn't find any issue.
Can you try to reproduce this issue with another new installation?
Otherwise I would close this ticket.
Updated by Lars Brinkmann over 9 years ago
Markus Klein wrote:
I tried it just now and couldn't find any issue.
Can you try to reproduce this issue with another new installation?
Otherwise I would close this ticket.
Hm, it was an automate installation with a software manager of a specialized TYPO3-Hoster. I had contact to the support team and reflected, if it could be a problem with the tool. They called back and told me, that it is a known bug and not a problem with the tool. I think, you can close this ticket.
Updated by Markus Klein over 9 years ago
- Status changed from Needs Feedback to Closed
- Priority changed from Won't have this time to -- undefined --
Really a pity that we wasted our time with a bug in a hoster's script.
Besides that, please always post in the forum first before opening a ticket in the bug tracker. You'll get help faster there.