Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

help with SQL


Guest

Recommended Posts

I was trying to get the "Contact Us Choice" to work and was checking my SQL database because it didn't seem to be working so I installed this as the Contrib calls for:

 

INSERT INTO configuration SET configuration_title='Contact Us Email Choices', date_added=NOW(), sort_order='4', configuration_group_id='1', configuration_key='CONTACT_US_LIST', configuration_value= '', configuration_description='The choices of email addresses shown on the Contact Us page. List them this way: Name1 <adrs1@domain.com>, Name2 <adrs2@domain.com>', use_function = NULL , set_function = NULL;

 

but heres the problem, first time I didn't think it worked so I did it twice. Now I have this 2 times in my database. Can somebody tell me how to delete it from there??/ It shows up twice in my admin section. I can't even get the contrib working so I'd like to get rid of both instances. I'm hoping somebody can help.

 

Thanks

Brian

Link to comment
Share on other sites

1) backup your database

2) use phpMyAdmin to find the entries you added in the configuration table

3) delete the entries you found in step 2

 

-jared

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...