Project

General

Profile

Actions

Bug #4585

closed

Tools Database Checker keeps reporting MYISAM usage

Added by nant over 9 years ago. Updated over 9 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
05 August 2014
Due date:
% Done:

100%

Estimated time:

Description

On a CB 1.9.1 site that has been upgraded to CB 2.0 RC (latest build of 05/08/2014) running the Tools database checker gives:

Core CB Database structure differences:
Table #__comprofiler_field_values Storage Engine is MyISAM instead of InnoDB
Table #__comprofiler_fields Storage Engine is MyISAM instead of InnoDB
Table #__comprofiler_lists Storage Engine is MyISAM instead of InnoDB
Table #__comprofiler_members Storage Engine is MyISAM instead of InnoDB
Table #__comprofiler_plugin Storage Engine is MyISAM instead of InnoDB
Table #__comprofiler_tabs Storage Engine is MyISAM instead of InnoDB
Table #__comprofiler_userreports Storage Engine is MyISAM instead of InnoDB
Table #__comprofiler_views Storage Engine is MyISAM instead of InnoDB
Table #__comprofiler_sessions Storage Engine is MyISAM instead of InnoDB
Table #__comprofiler_ratings Storage Engine is MyISAM instead of InnoDB
The Core CB database structure differences can be fixed (adjusted) by clicking here: Click here to Fix (adjust) all Core CB database differences listed above (you can also Click here to preview fixing (adjusting) queries in a dry-run), but in all cases you need to backup database first as this adjustment is changing the database structure to match the needed structure for the installed version.

Clicking in the link leads to a success page

With duplicate paragraphs:

Core CB Database adjustments have been performed successfully.
The Core CB database adjustments have been done. If all lines above are in green, database adjustments completed successfully. Otherwise, if some lines are red, please report exact errors and queries to authors forum, and try checking database again.

The database structure can be checked again by clicking here: Click here to Check Core CB database

Core CB Database adjustments have been performed successfully.
Click here to Show details
The Core CB database adjustments have been done. If all lines above are in green, database adjustments completed successfully. Otherwise, if some lines are red, please report exact errors and queries to authors forum, and try checking database again.

The database structure can be checked again by clicking here: Click here to Check Core CB database

Clicking on an one of these links leads to a session error popup:

Session expired or cookies are not enabled in your browser. Please press "reload page" in your browser, and enable cookies in your browser. Please refresh/reload page before filling-in.

Actions #1

Updated by krileon over 9 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

Fixed in MR !311

Actions #2

Updated by beat over 9 years ago

  • Priority changed from High to Normal
Actions #3

Updated by beat over 9 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF