Guest Posted December 11, 2005 Posted December 11, 2005 Hi all, I don't know what happen with my admin side. I think after upgrading the osc. Somehow all the options in admin has duplicated. Sorry for my english, but what i mean is that like in My Store. all the options are display twice, for example Zone Zone Send Extra-emails to: Send Extra-emails to: etc it doesn't affect my osc store anyhow but it just a bit annoying to fill in twice the same thing in the configuration. If anyone know how to fix this problem, i will be very grateful. Hope to hear from you soon and thank you in advance. Regards Kevin Doan
♥Vger Posted December 11, 2005 Posted December 11, 2005 You need to access your database via phpMyAdmin, and look in particular at all of the Configuration table. You will find that some tables are listed more than once, and you need to delete (drop) the second entry for those tables that are repeated. Before you do this remember to take a backup of your database, in osC 'admin' under Tools --> Backup. Vger
Guest Posted December 11, 2005 Posted December 11, 2005 You need to access your database via phpMyAdmin, and look in particular at all of the Configuration table. You will find that some tables are listed more than once, and you need to delete (drop) the second entry for those tables that are repeated. Before you do this remember to take a backup of your database, in osC 'admin' under Tools --> Backup. Vger Hi Vger, Thank you for your reply. I have checked and go through my databases tables 4-5 times before i wanted to get back to you. I would like to tell you that i couldn't find any tables that were listed twice. I have 46 tables in my database as following: address_book address_format banners banners_history categories categories_description configuration configuration_group counter counter_history countries currencies customers customers_basket customers_basket_attributes customers_info geo_zones languages manufacturers manufacturers_info newsletters orders orders_products orders_products_attributes orders_products_download orders_status orders_status_history orders_total products products_attributes products_attributes_download products_description products_notifications products_options products_options_values products_options_values_to_products_options products_to_categories reviews reviews_description sessions specials tax_class tax_rates whos_online zones zones_to_geo_zones I also tried to check for the fields that is there any fields that been duplicated but i didn't see any as well. What really confuses me most is that, not all the options in Administration are duplicated, only the Configuration bit. For example under the Configuration --> Stock, all the options in there are duplicated. But if i look under "My Store" Then only certain options been duplicated, such as Zone, Allow Guest To Tell A Friend, etc. Whereas like Store Name, Store Owner is OK. Is there any other way to get around with this? Any suggestion or ideas are appreciated. Kevin Doan
AlanR Posted December 12, 2005 Posted December 12, 2005 Hi Vger, Thank you for your reply. I have checked and go through my databases tables 4-5 times before i wanted to get back to you. I would like to tell you that i couldn't find any tables that were listed twice. I have 46 tables in my database as following: Browse the table: configuration and you'll find them, ie: 13 Allow Guest To Tell A Friend ALLOW_GUEST_TO_TELL_A_FRIEND false Allow guests to tell a friend about a product Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)
Guest Posted December 12, 2005 Posted December 12, 2005 Browse the table: configuration and you'll find them, ie: 13 Allow Guest To Tell A Friend ALLOW_GUEST_TO_TELL_A_FRIEND false Allow guests to tell a friend about a product Thanks AlanR, I went to my database via phpmyadmin, and went to configuration table and browse to: 13 Allow Guest To Tell A Friend ALLOW_GUEST_TO_TELL_A_FRIEND true Allow guests to tell a friend about a product 1 15 2005-11-26 00:08:42 2005-11-25 23:44:58 NULL tep_cfg_select_option(array('true', 'false'), I delete that particular field and other fields that i see been duplicated in Administration site, which including also best sellers, etc. But after i removed those rows, all data was gone as well :(. The one that got removed i believe was the default fields in the table, cause the ones with duplication i couldn't see any of them in the configuration table :(. I'm really really confused myself now, i did backup my database, but i can't even restore it anymore successfully. All my products in my category are gone! I get this error message everytime i restore my database. ---------------------------------------------------------------------------------------------------------------------------- Error SQL query: INSERT INTO products_description( products_id, language_id, products_name, products_description, products_url, products_viewed ) VALUES ( '28', '1', 'Ba Me Chong Gay Gat (Wars of In-Laws)', '<font color=\"red\"><b>Tựa Цamp;#7873; (Title):</b></font> Bࠍẹ Chồng Gay Gắt (Wars of In-Laws) <br> <font color=\"red\"><b>DVD:</b></font> 4 <br> <font color=\"red\"><b>Diễn V쪮 (Movie Stars):</b></font> U?Minh Tuyꮬ Hồ Hạnh Nhi, Huỳnh T?hạch <br> <font color=\"red\"><b>Thể Loại:</b></font> HƯớc <br> <font color=\"red\"><b>H㮧 Sản Xuất:</b></font> TVBI', '', '17' ); MySQL said: #1406 - Data too long for column 'products_description' at row 1 ---------------------------------------------------------------------------------------------------------------------------- Is there anyway to fix this? Or do i have to add in all the products again one by one?. I think only the products aren't restoring, all the rest is fine (i hope). Oh and one more thing, may i ask you that if the options in the Administration been duplicated, shouldn't it show in the database as well as identical fields in configuration table? Because i can see only one field each and no copy of any of those fields at all. Hope you understand my low level of English and hope you could help me. Once again thank you to everyone who have help me out and have a nice day. Hope to hear from you in the near future. Best regards Kevin Doan
Recommended Posts
Archived
This topic is now archived and is closed to further replies.