Admin configuration messed up :(

[Guest]

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]

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]

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]

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

[Guest]

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