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