compare_tables.php nuke_stats field key problem

Worker Joined: May 26, 2006 Posts: 153

I have just run the table compare utilities on both of my websites after upgrading and have the following errors:

tables processed: 166
fields processed: 1222
fields not found on your system 0
tables not found in your system: 0
field types do not match nuke_pollcomments subject : Base varchar(60) Your table varchar(100)
field keys do not match nuke_stats_date year : Base PRI Your table
field keys do not match nuke_stats_date month : Base PRI Your table
field keys do not match nuke_stats_date date : Base PRI Your table
field keys do not match nuke_stats_hour year : Base PRI Your table
field keys do not match nuke_stats_hour month : Base PRI Your table
field keys do not match nuke_stats_hour date : Base PRI Your table
field keys do not match nuke_stats_hour hour : Base PRI Your table
field keys do not match nuke_stats_month year : Base PRI Your table
field keys do not match nuke_stats_month month : Base PRI Your table
field keys do not match nuke_stats_year year : Base PRI Your table

I believe the pollcomments subject was increased a while back for some reason, but not sure about the nuke_stats errors. I have tried looking at the Install program, but not sure if it was updated or not.

Posted: Mon Jun 04, 2012 8:00 am

If you look in the rn_core_sql file in the installation directory you will see the "official" definition of the stats table. All the stats fields you are referencing are defined as primary keys. You can use PHPmyadmin to make them primary keys in your tables. Likewise, for the pollcomments_subject field is defined as 60 characters in the official definition but 100 in your table. You could redefine it to 60 but realize that will truncate any data in your system that is between 60 and 100 characters.

Posted: Mon Jun 04, 2012 11:56 am

fkelly wrote:

If you look in the rn_core_sql file in the installation directory you will see the "official" definition of the stats table. All the stats fields you are referencing are defined as primary keys. You can use PHPmyadmin to make them primary keys in your tables. Likewise, for the pollcomments_subject field is defined as 60 characters in the official definition but 100 in your table. You could redefine it to 60 but realize that will truncate any data in your system that is between 60 and 100 characters.

Looking in the INSTALLATION\rndb_upgrade.php file it has the following lines 1039 to 1053:

/*
* Add/Delete indexes per Mantis 0001086
* Table to add indexes to:
* nuke_counter : Add PRIMARY INDEX (type(20), var(20))
* nuke_nsngr_users : Add INDEX (gid, uid, uname)
* nuke_poll_check : Add PRIMARY INDEX (ip, pollID)
* nuke_stats_date : ADD PRIMARY KEY (year, month, `date`)
* nuke_stats_hour : ADD PRIMARY KEY (year, month, `date`, hour)
* nuke_stats_month : ADD PRIMARY KEY (year, month)
* nuke_stats_year : ADD PRIMARY KEY (year)
* Tables with duplicate indexes defined:
* nuke_banner : Remove regular INDEX bid
* nuke_banner_clients : Remove regular INDEX cid
* nuke_mail_config : Remove unique INDEX mailer
*/

And again at lines 1075 to 1085:

/****
** Removed per Mantis issue 1254.
** See further information up above in the fixStatsTables() function.
**
fixStatsTables('stats_year',' `year`');
fixStatsTables('stats_month','`year`, `month`');
fixStatsTables('stats_date','`year`, `month`, `date`');
fixStatsTables('stats_hour','`year`, `month`, `date`, `hour`');
****/

/*

So not even sure if these tables are still being used.