Remove code in SQL

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Meados
Registered User
Posts: 9
Joined: Thu Dec 04, 2008 9:56 pm

Remove code in SQL

Post by Meados »

Hello, I had ran this code in sql:

Code: Select all

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('seo_ext', 'html', 0);
And I would like delete what it did. Somebody can help me? Thanks.
User avatar
HGN
Former Team Member
Posts: 4706
Joined: Wed Dec 03, 2008 1:53 pm
Location: The Netherlands
Name: Alfred
Contact:

Re: Remove code in SQL

Post by HGN »

Code: Select all

DELETE FROM phpbb_config WHERE CONVERT(config_name USING utf8) =  'seo_ext' LIMIT 1
User avatar
Erik Frèrejean
Former Team Member
Posts: 9899
Joined: Tue Oct 09, 2007 9:09 am
Location: The Netherlands, 3.0.x Support Forum
Name: Erik Frèrejean
Contact:

Re: Remove code in SQL

Post by Erik Frèrejean »

Run this query:

Code: Select all

DELETE FROM phpbb_config
   WHERE config_name = 'seo_ext';
[edit]
Beaten to that one :P
Support Toolkit | Support Request Template | Knowledge Base | phpBB 3.0.x documentation
I don't give support via PM or IM! (all unsolicited pms will be trashed!)
Meados
Registered User
Posts: 9
Joined: Thu Dec 04, 2008 9:56 pm

Re: Remove code in SQL

Post by Meados »

Erik Frèrejean wrote:Run this query:

Code: Select all

DELETE FROM phpbb_config
   WHERE config_name = 'seo_ext';
[edit]
Beaten to that one :P
I used that thanks. Ins't necessary excute this code too? (sorry I am a noob at commands in mysql)

DELETE FROM phpbb_config
WHERE config_name = 'html';

Thank you.
User avatar
Lumpy Burgertushie
Registered User
Posts: 67925
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Remove code in SQL

Post by Lumpy Burgertushie »

yes, or you could simply use your sql manager ( phpmyadmin or whatever) and delete that row from the config table.


robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If nobody is in the forest, does a tree really fall?
User avatar
Erik Frèrejean
Former Team Member
Posts: 9899
Joined: Tue Oct 09, 2007 9:09 am
Location: The Netherlands, 3.0.x Support Forum
Name: Erik Frèrejean
Contact:

Re: Remove code in SQL

Post by Erik Frèrejean »

Meados wrote:
Erik Frèrejean wrote:Run this query:

Code: Select all

DELETE FROM phpbb_config
   WHERE config_name = 'seo_ext';
[edit]
Beaten to that one :P
I used that thanks. Ins't necessary excute this code too? (sorry I am a noob at commands in mysql)

DELETE FROM phpbb_config
WHERE config_name = 'html';

Thank you.
No you don't have to run that. This SQL query will remove the whole row you added with your query.
Support Toolkit | Support Request Template | Knowledge Base | phpBB 3.0.x documentation
I don't give support via PM or IM! (all unsolicited pms will be trashed!)
Meados
Registered User
Posts: 9
Joined: Thu Dec 04, 2008 9:56 pm

Re: Remove code in SQL

Post by Meados »

Erik Frèrejean wrote:
Meados wrote:
Erik Frèrejean wrote:Run this query:

Code: Select all

DELETE FROM phpbb_config
   WHERE config_name = 'seo_ext';
[edit]
Beaten to that one :P
I used that thanks. Ins't necessary excute this code too? (sorry I am a noob at commands in mysql)

DELETE FROM phpbb_config
WHERE config_name = 'html';

Thank you.
No you don't have to run that. This SQL query will remove the whole row you added with your query.
Ok thanks. :P
Locked

Return to “[3.0.x] Support Forum”