Phpmadmin : Tracking Disabled

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Phpmadmin : Tracking Disabled

Postby piropeator » 12. August 2011 18:48

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.
Image
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.
piropeator
 
Posts: 6
Joined: 08. February 2010 01:25

Re: Phpmadmin : Tracking Disabled

Postby Altrea » 12. August 2011 19:21

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;
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8286
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Phpmadmin : Tracking Disabled

Postby piropeator » 12. August 2011 19:46

Altrea wrote: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.
piropeator
 
Posts: 6
Joined: 08. February 2010 01:25

Re: Phpmadmin : Tracking Disabled

Postby Altrea » 12. August 2011 20:44

piropeator wrote: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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8286
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Phpmadmin : Tracking Disabled

Postby piropeator » 14. August 2011 17:19

Altrea wrote:
piropeator wrote: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
 
Posts: 6
Joined: 08. February 2010 01:25

Re: Phpmadmin : Tracking Disabled

Postby piropeator » 15. August 2011 19:04

Altrea wrote: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.... !
piropeator
 
Posts: 6
Joined: 08. February 2010 01:25

Re: Phpmadmin : Tracking Disabled

Postby Altrea » 15. August 2011 21:50

piropeator wrote: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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8286
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 65 guests