Duplicate sections in admin ? why

[bgrcmodels]

Hello, in my " Admin " " My Store " section of my website i seem to have a small problem.

 

I have duplicated options, so for every option in the my store section it is duplicated.

 

Please see the below image to illustarte what i mean.

 

I am not aware that this causes any problems to my site but would be nice to get it back to normal.

 

http://img170.imageshack.us/my.php?image=b...elsadminbv5.jpg

 

Many Thanks in advance

Ben

[Guest]

Is this a new install? Have you installed any contributions lately?

 

I duplicated a chunk of my Admin section when I installed Credit Class/Gift Voucher a while back. My fault.

 

Just try to retrace your steps and think of what you've done lately that may have created this.

 

If it's a new install, you may have to do it again.

[bgrcmodels]

Is this a new install? Have you installed any contributions lately?

 

I duplicated a chunk of my Admin section when I installed Credit Class/Gift Voucher a while back. My fault.

 

Just try to retrace your steps and think of what you've done lately that may have created this.

 

If it's a new install, you may have to do it again.

 

 

It is not a really old install but there are quite a few contrib's added now.

 

I think i might be something to do when i tried to install it again when it went wrong the first time. The files must be duplicated some where maybe in the tables. I dont know.

 

Thanks anyway.

Ben

[♥Monika in Germany]

clean them up carefully manually in phpmyadmin

[bgrcmodels]

clean them up carefully manually in phpmyadmin

 

I would love to know how to do that, i think some advise might be needed before i try that :blush:

 

:'(

 

Many Thanks

Ben

[♥Monika in Germany]

go though your admin configuration section and highlight all double entries one by one. the url will show a configuration ID which you need to note down. Make sure when there are 2 entries, you only note down the second one, as those you write down will be deleted. Click through the configuration box categories (my store, max values .... etc down to sessions etc), one by one, double entry by double entry.

 

When the list of those you want to delete is complete, open a phpmyadmin sql window and copy in this statement:

 

delete from configuration where configuration_id in (---------------);

 

where I have the ---------------, you have to add a comma separated list of the IDs you collected for deleting.

 

If I wanted to delete 200, 300 and 400, my statement would be:

delete from configuration where configuration_id in (200,300,400);

 

HTH

[bgrcmodels]

Thank You Monika in Germany,

 

I shall try this now.

 

:)

[bgrcmodels]

ok i am in the SQL server for my site and i can only find this:

 

Run SQL query/queries on server localhost:

 

In the box below, i type in this code:

 

delete from configuration where configuration_id in (6);

 

and this is the message that i get:

 

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_meta_style.inc.php:27) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/common.lib.php on line 1154

 

 

 

The line that i would like to test delete i as follows:

 

http://www.bgrcmodels.com/catalog/admin/co...gID=1&cID=6

 

Any help please ?

thanks Ben

[♥Monika in Germany]

open the table configuration in display rows mode and try to delete the row with ID 6 by clicking the red X. If that doesn't work, it seems to me like your phpmyadmin install has a problem...

[bgrcmodels]

open the table configuration in display rows mode and try to delete the row with ID 6 by clicking the red X. If that doesn't work, it seems to me like your phpmyadmin install has a problem...

 

Ok, after going back into my osCommerce admin, i can see that 6 has been removed. All though it didnt look like it would have reomved it did, i am going to try the rest now.

 

I will let you know how i get on :)

[bgrcmodels]

Ok, I have done it.

 

MANY MANY Thanks.

 

In the end this was the final code:

 

delete from configuration where configuration_id in (161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,211

,213,116,215,216,218,219,220,221,222,125,225,226,227,228,230,231,232,233,234,236,

237,238,239,240);

 

 

:)

 

Thanks Ben

[♥Monika in Germany]

well done Ben! I have seen several such setups, and they came like this directly from the default host install!

[bgrcmodels]

well done Ben! I have seen several such setups, and they came like this directly from the default host install!

 

 

Hello Again, Really sorry to say that i think i may have made a mistake with one of the numbers.

 

I dont seem to have a " STORE NAME " in my Admin Store Settings now.

 

Can you advise on how i can install or set this up please.

 

Many Thanks

Ben

[♥Monika in Germany]

sure ... you should always have a vanilla osC in a folder for reference, i got this from mine for your phpmyadmin:

 

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Store Name', 'STORE_NAME', 'osCommerce', 'The name of my store', '1', '1', now());

[bgrcmodels]

sure ... you should always have a vanilla osC in a folder for reference, i got this from mine for your phpmyadmin:

 

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Store Name', 'STORE_NAME', 'osCommerce', 'The name of my store', '1', '1', now());

 

 

I will try this now,

 

Many Thanks for your prompt reply.

[bgrcmodels]

FANTASTIC :

 

Worked a treat.

 

Thank You So Much.

 

Just while i am here monika, do you know why i am not receiving e-mails from my store to aol address.

When an aol, yahoo or hotmail e-mail addressed member registeed the welcome e-mail is all ways returned and e-mails are not received ?

 

Not to worry if you dont know.

 

Many Thanks

Ben

[♥Monika in Germany]

:-) ... seen that too before. I'm pretty sure they have some kind of a spam filter turned on. I just saw that this week from a client who insisted osC didn't send out pw forgotten emails ... well it did for me, and it did for his alternate email, and then he found the osc emails for his other name in the spam folder. It may be cause the so called "bulk mailer" is used for sending emails ...