duplicate options in admin confiuration

[danmcguire]

Greetings all,

I have a puzzle that I need help solving. In the admin>configuration>Layout Settings I have a number of duplicate entries. I need to find where to fix this: Mysql, php files?

Or should I just dump this install which was an upgrade from 1.25 to 1.3.0.1 done as a fresh install with a database upgrade. Everything seems to be working! This has been my first upgrade that has been discouragingly difficult.

drdan

en Cart 1.3.0.1
Database Patch Level: 1.3.0.1

Server OS: Linux 2.4.21-40.ELsmp
Database: MySQL 4.0.24
PHP Version: 4.3.11 (Zend: 1.3.0)
HTTP Server: Apache/2.0.46 (Red Hat)

[Ajeh]

What you can do is use phpMyAdmin to browse your configuration table ...

Sort on the configuration_key and look for duplicates ...

You can delete the duplicates from the table ... but need to be careful about any changes to them ... meaning if you have duplicate configuration_keys but their descriptions or functions are the same ...

If you are familiar with phpMyAdmin and looking at sql files ... a safe way to fix this would be to delete an configuration_key that is a duplicate ... as in all occurances ... then find the configuration_key in the /zc_install/mysql_zencart.sql file and reload the valid configuration_key ...

This would assure you have the current configuration_key and values and associated functions ...

[danmcguire]

I have gone through the configuration Table and found 10 duplicates. Each one's
configuration_id is about 80 increments apart. Is this the only place to look for this problem page? I think I can assume the higher numbered twin is the newest. They all appear to have the same values.

I have a backup database on line and have just backed up this one to local hard disk before I selectively nuke from orbit.

drdan

[Ajeh]

You can make that assumption ...

However, try to double check against the mysql_zencart.sql file to assure that this is working right ...

[danmcguire]

Mission accomplished. I compared each duplicate with the other and with the mysql_zencart.sql and they were identical. The duplicates were 11 of the last 12 records in the database as ordered in ascending id numbers. The duplicates are now gone in Layout settings in configuration, and the zencart seems to run just fine.

I am tempted to look around in mysql for other duplicates, but I have decided to resist said temptation. My eyeballs are very happy with that decision. There is on the order of 600 records in that table.

Thank you Ajeh,

drdan

[Ajeh]

via phpMyAdmin ... try the following

SELECT configuration_key from configuration

SELECT DISTINCT configuration_key from configuration

Do both pull up the same number of records?

If they match ... then you have no more duplicates ...

[danmcguire]

Took me awhile to find the Distinct checkbox, but I have been able to confirm that there are no more duplicates.

We are happy!

Thank you very much Ajeh.

[Ajeh]

Thanks for the update and letting us know that you are back in business ...