mmph Posted August 6, 2006 Share Posted August 6, 2006 Hi, I am trying to find the cause of several values in my admin/ configuration page which are showing twice and holding different values. I have checked mysql database and don't see any sure give aways to the cause. Does anyone have an idea what is causing the duplicates? Thanks, here's the snapshot, see how "zone" and others are appearing twice: Link to comment Share on other sites More sharing options...
Jack_mcs Posted August 6, 2006 Share Posted August 6, 2006 They were somehow added to your database. You need to go into your database using phpmyadmin and click into the configuration table. Find the duplicate entries and delete them. Always backup your database before attempting such changes. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted August 6, 2006 Share Posted August 6, 2006 if this was an install by your host, and you have just started out, please start anew with the sql file provided on this website. It should be enough to run the oscommerce.sql file in phpmyadmin. I have seen this problem several times, and manual cleanup will take ages. The whole configuration table probably has duplicate rows here and there, no rules to follow. :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
mmph Posted August 6, 2006 Author Share Posted August 6, 2006 Thanks for your help folks! I had looked a the configuration table but the duplicates were hiding out way down by row 160 and I didn't readily identify them. With your help identifying the configuration table was the right place to look, I uploaded the whole table in a .txt file and searched for the duplicated terms to find the entry numbers, then went into mysql and deleted the duplicates; after backing up my database of course. Life is good. Thanks again! Link to comment Share on other sites More sharing options...
jalonek Posted July 27, 2007 Share Posted July 27, 2007 I have that problem to. I deleted the duplicates on cnf sql file (backup rulez) but after initiate the admin control panel nothing changed. ¿ Do I have to reload DB, or something ? ¿ How to continue ? after that changes i make. It isn't my server , I bay hosting & hav access onli to MyPHPAdmin or simple Host Admin Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.