Phpmadmin : Tracking Disabled

[piropeator]

I installed Xampp 1.7.4.
When I run http://localhost/phpmyadmin/
I have this message:The additional features for working with linked tables have been deactivated. To find out why click here.

In Control Panel I put unticked and ticked the SVC modules in Apache and MySQL but nothing.
I added this line in config.inc.php:
$cfg['Servers'][$i]['tracking'] = 'pma_tracking'; but the error does not gone.
I imported create_tables.sql........
How do I fix this.

[Altrea]

Have you doublechecked, that the pma_tracking table is created in your phpmyadmin database?
How does your phpmyadmin config.inc.php now looks like?
Do you have added the tracking configuration parameters?
If not, add this in your config.inc.php file:

Code: Select all

/* Tracking configuration */
$cfg['Servers'][$i]['tracking_version_auto_create'] = true;
$cfg['Servers'][$i]['tracking_default_statements'] = 'CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,CREATE INDEX,DROP INDEX,INSERT,UPDATE,DELETE,TRUNCATE,REPLACE,CREATE VIEW,ALTER VIEW,DROP VIEW,CREATE DATABASE,ALTER DATABASE,DROP DATABASE';
$cfg['Servers'][$i]['tracking_version_drop_view'] = true;
$cfg['Servers'][$i]['tracking_version_drop_table'] = true;
$cfg['Servers'][$i]['tracking_version_drop_database'] = true;


[piropeator]

Have you doublechecked, that the pma_tracking table is created in your phpmyadmin database?
How does your phpmyadmin config.inc.php now looks like?
Do you have added the tracking configuration parameters?
If not, add this in your config.inc.php file:

Code: Select all

/* Tracking configuration */
$cfg['Servers'][$i]['tracking_version_auto_create'] = true;
$cfg['Servers'][$i]['tracking_default_statements'] = 'CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,CREATE INDEX,DROP INDEX,INSERT,UPDATE,DELETE,TRUNCATE,REPLACE,CREATE VIEW,ALTER VIEW,DROP VIEW,CREATE DATABASE,ALTER DATABASE,DROP DATABASE';
$cfg['Servers'][$i]['tracking_version_drop_view'] = true;
$cfg['Servers'][$i]['tracking_version_drop_table'] = true;
$cfg['Servers'][$i]['tracking_version_drop_database'] = true;


Wow!!! Excellent!! now is ok.
Can you explain me what mean and what to do this code??
Thanks a lot.

[Altrea]

Can you explain me what mean and what to do this code??

No i can't. I have quoted one of mine earlier posts in the german section of this board.
I have found that solution in this post @ sourceforge

But you can find phpmyadmin configuration variables at it's wiki

[piropeator]

Can you explain me what mean and what to do this code??

No i can't. I have quoted one of mine earlier posts in the german section of this board.
I have found that solution in this post @ sourceforge

But you can find phpmyadmin configuration variables at it's wiki

Well, I founded several solutions but none worked...
Thanks again.

[piropeator]

Have you doublechecked, that the pma_tracking table is created in your phpmyadmin database?
How does your phpmyadmin config.inc.php now looks like?
Do you have added the tracking configuration parameters?
If not, add this in your config.inc.php file:

Code: Select all

/* Tracking configuration */
$cfg['Servers'][$i]['tracking_version_auto_create'] = true;
$cfg['Servers'][$i]['tracking_default_statements'] = 'CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,CREATE INDEX,DROP INDEX,INSERT,UPDATE,DELETE,TRUNCATE,REPLACE,CREATE VIEW,ALTER VIEW,DROP VIEW,CREATE DATABASE,ALTER DATABASE,DROP DATABASE';
$cfg['Servers'][$i]['tracking_version_drop_view'] = true;
$cfg['Servers'][$i]['tracking_version_drop_table'] = true;
$cfg['Servers'][$i]['tracking_version_drop_database'] = true;


Hey man, I installed Xampp in other pc (my house) but doesn't work. I have the same message.... !

[Altrea]

Hey man, I installed Xampp in other pc (my house) but doesn't work. I have the same message.... !

"doesn't work" is no qualified error report.

To fix that tracking error, there are different steps needed:

Create the pma_tracking table in the phpmyadmin database
for example with this SQL Statement in phpmyadmin:

Code: Select all

CREATE TABLE IF NOT EXISTS `pma_tracking` (
  `db_name` varchar(64) collate utf8_bin NOT NULL,
  `table_name` varchar(64) collate utf8_bin NOT NULL,
  `version` int(10) unsigned NOT NULL,
  `date_created` datetime NOT NULL,
  `date_updated` datetime NOT NULL,
  `schema_snapshot` text collate utf8_bin NOT NULL,
  `schema_sql` text collate utf8_bin,
  `data_sql` longtext collate utf8_bin,
  `tracking` set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') collate utf8_bin default NULL,
  `tracking_active` int(1) unsigned NOT NULL default '1',
  PRIMARY KEY  (`db_name`,`table_name`,`version`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT;

Change the phpmyadmin config.inc.php file:

add the pma_tracking line to explain phpmyadmin, which name your tracking table has:

Code: Select all

$cfg['Servers'][$i]['tracking'] = 'pma_tracking';

At the end of the file add the pma_tracking configuration like explained in the previous post and save the file.

After that clear your Browser caches and try if the message is gone.
These was my steps to enable the tracking in a standard XAMPP 1.7.4