SQL Script

[Berserker]

Hello,

Once you have installed a SQL Script, can it be undone? I installed a mod that required me to install a SQL script but I now want to remove this. Do I have to remove the SQL script as well or can i leave it?

If i decided to delete it, how do i go about in doing that?

If i decided to leave it, will it affect the site?

[Ajeh]

A SQL file can do 50 bazillion things to your database ...

You want to clean up what ever it did or you may have extra database tables, fields, changes to fields etc. that could alter how the normal site runs ...

Perhaps if you said "what" add-on you ran a SQL file from it would help someone help you know what to do ...

[Berserker]

It's the News & Articles Management by Dreamscape

[DrByte]

It's the News & Articles Management by Dreamscape

Run this SQL to remove the module's SQL components:

delete from configuration_group where configuration_group_title = 'News & Articles Management';
delete from configuration where configuration_key in ('DISPLAY_NEWS_SUMMARY', 'DISPLAY_NEWS_SUMMARY_DAYS', 'DISPLAY_NEWS_SUMMARY_LENGTH', 'NEWS_COMMENTS_REQUIRE_CUSTOMER', 'ENTRY_NEWS_NAME_MIN_LENGTH', 'ENTRY_NEWS_COMMENTS_MIN_LENGTH',   'NEWS_COMMENTS_EMAIL_ADMIN_NOTICE', 'NEWS_RSS_FEED_NUMBER_OF_DAYS', 'NEWS_SCROLLER_NUMBER_OF_DAYS', 'NEWS_SCROLLER_HEIGHT', 'NEWS_SCROLLER_AMOUNT', 'NEWS_TICKER_NUMBER_OF_DAYS', 'NEWS_TICKER_HEIGHT', 'NEWS_TICKER_AMOUNT', 'NEWS_TICKER_DELAY');

DROP TABLE IF EXISTS news_articles;
DROP TABLE IF EXISTS news_articles_text;
DROP TABLE IF EXISTS news_authors;
DROP TABLE IF EXISTS news_comments;
DROP TABLE IF EXISTS news_comments_description;

[Berserker]

Dr Byte,

It doesn't seem to work. I get the error below:

delete from configuration_group where configuration_group_name = 'News & Articles Management';

1054 Unknown column 'configuration_group_name' in 'where clause'
in:
[DELETE FROM configuration_group where configuration_group_name = 'News & Articles Management';]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[DrByte]

oops -- corrected my post ... configuration_group_title ... not configuration_group_name