Actions
Bug #68910
closedDatabase analyzer: crashes in a loop
Start date:
2015-08-10
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
6.2
PHP Version:
5.5
Tags:
Complexity:
Is Regression:
No
Sprint Focus:
Description
Executing Database analyzer ("Compare current database with specification") ends in a loop (caused by the extension "ke_stats"). It is a Typo3 6.2 (initial installation was 6.0, then updated to 6.1)
There are two tasks (see also snapshots):- ALTER TABLE tx_kestats_cache DROP KEY whereclause_index;
- ALTER TABLE tx_kestats_cache ADD KEY whereclause_index (whereclause(260),orderby(20),groupby(20));
Performing (snapshot 1) the first works (it isn't displayed any more, snapshot 2), but after performing the second both tasks are displayed again (snapshot 3).
I performed it several times, it is always the same, it is an infinite loop.
Because of this I cannot finish the Upgrade Wizard.
content of the ext_tables.sql
# # Table structure for table 'tx_kestats_statdata' # CREATE TABLE tx_kestats_statdata ( uid int(11) NOT NULL auto_increment, pid int(11) DEFAULT '0' NOT NULL, tstamp int(11) DEFAULT '0' NOT NULL, crdate int(11) DEFAULT '0' NOT NULL, cruser_id int(11) DEFAULT '0' NOT NULL, type tinytext NOT NULL, category tinytext NOT NULL, element_uid int(11) DEFAULT '0' NOT NULL, element_pid int(11) DEFAULT '0' NOT NULL, element_title tinytext NOT NULL, element_language int(11) DEFAULT '0' NOT NULL, element_type int(11) DEFAULT '0' NOT NULL, counter int(11) DEFAULT '0' NOT NULL, year int(11) DEFAULT '0' NOT NULL, month int(11) DEFAULT '0' NOT NULL, parent_uid int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (uid), KEY parent (pid), KEY index1 (type(20),category(20),element_title(20),year,month), KEY index2 (type(20),category(20),element_uid,element_language,element_type,year,month), KEY index3 (element_title(20)), KEY index4 (type(20),category(20),element_uid,element_pid,element_language,element_type,year,month), KEY index5 (type(20),tstamp) ); # # Table structure for table 'tx_kestats_cache' # CREATE TABLE tx_kestats_cache ( uid int(11) NOT NULL auto_increment, whereclause text NOT NULL, orderby text NOT NULL, groupby text NOT NULL, result longtext NOT NULL, PRIMARY KEY (uid), KEY whereclause_index (whereclause(260),orderby(20),groupby(20)) ); # # Table structure for table 'tx_kestats_queue' # CREATE TABLE tx_kestats_queue ( uid int(11) NOT NULL auto_increment, tstamp int(11) DEFAULT '0' NOT NULL, data text NOT NULL, generaldata text NOT NULL, PRIMARY KEY (uid) );
Files
Actions