Red Hat Bugzilla – Bug 494475
remove faq and feedback
Last modified: 2009-09-10 16:35:15 EDT
While fixing bug #460136 the only code using customerservice emails was in the FAQ and Feedback code. Since this code was not used, I removed it.
The perl code uses it from Sniglets::Mailer (Sniglets/Mailer.pm)
which only seems to exist in order to support the FAQ page.
https://wrx.devel.redhat.com/help/faq.pxt (I added the .pxt if you
are looking at YOUR satellite remove .pxt).
As you can see that page says at the top that we folks should use
the Red Hat Knowledgebase. I agree 100% with that comment.
I propose we obliterate the FAQ page and all the supporting code
behind it. This include a number of queries and tables (might
affect postgres work).
Code that would get removed:
web/html/help/.htaccess (remove faq entry)
(faq related queries ~ 5 of them)
Then I would add an upgrade script to drop the rhnFAQ* related tables.
also get nuked.
What do we do with the upgrade scripts that reference this table?
Do they remain? or do they get dropped in favor of one that drops
the rhnFAQ* tables?
Here's what I have for an upgrade script:
drop index rhn_faqclass_or_uq;
drop index rhn_faqclass_label_uq;
drop sequence RHN_FAQ_CLASS_ID_SEQ;
drop table rhnFAQClass;
drop trigger rhn_faq_mod_trig;
drop sequence rhn_faq_id_seq;
drop table rhnFAQ;
Created attachment 338455 [details]
diff of the changes that occurred
# modified: branding/css/rhn-special-styles.css
# deleted: documentation/db-schema/spacewalk-0.1/sql_sources/table/rhnfaq.sql
# deleted: documentation/db-schema/spacewalk-0.1/sql_sources/table/rhnfaqclass.sql
# deleted: documentation/db-schema/spacewalk-0.1/table-RHNFAQCLASS.html
# modified: java/buildconf/builder/config/satellite/default/rhn_web.conf
# modified: schema/spacewalk/rhnsat/tables/Makefile.deps
# deleted: schema/spacewalk/rhnsat/tables/rhnFAQ.sql
# deleted: schema/spacewalk/rhnsat/tables/rhnFAQClass.sql
# deleted: schema/spacewalk/rhnsat/tables/rhnFAQClass_data.sql
# deleted: schema/spacewalk/rhnsat/tables/rhnFAQ_satdata.sql
# modified: web/html/help/.htaccess
# deleted: web/html/help/faq
# modified: web/modules/rhn/RHN/DB/DataSource/xml/General_queries.xml
# modified: web/modules/rhn/RHN/DB/DataSource/xml/User_queries.xml
# deleted: web/modules/rhn/RHN/DB/Feedback.pm
# deleted: web/modules/rhn/RHN/Feedback.pm
# modified: web/modules/sniglets/Sniglets/ListView/GeneralList.pm
# modified: web/modules/sniglets/Sniglets/Lists.pm
# deleted: web/modules/sniglets/Sniglets/Mailer.pm
# modified: web/modules/sniglets/Sniglets/Users.pm
# modified: web/spacewalk-web.spec
# new file: schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/102-drop-rhnfaqclass.sql
# new file: schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/103-drop-rhnfaq.sql
verify tables are gone
- desc rhnfaqclass
- observe 'ORA-04043: object rhnfaqclass does not exist'
- desc rhnfaq
- observe 'ORA-04043: object rhnfaq does not exist'
try to browse the faq page
- observe page not found error
on your satellite look for deleted files:
- ls /var/www/lib/Sniglets/Mailer.pm
- ls /var/www/lib/RHN/Feedback.pm
- ls /var/www/lib/RHN/DB/Feedback.pm
- ls /var/www/html/help/faq
- observe 'No such file or directory' message for each of the above
be on the lookout for possible tracebacks related to FAQ or feedback pages.
nothing specific just not sure if there's any other potential errors that might arise during normal Satellite operation.
web page do not exist and additionaly:
[root@xen5 tmp]# locate Feedback
[root@xen5 tmp]# sqlplus -S rhnsat/rhnsat@rhnsat
ORA-04043: object rhnFAQClass does not exist
ORA-04043: object rhnFAQ does not exist
verified in stage on xen5
An advisory has been issued which should help the problem
described in this bug report. This report is therefore being
closed with a resolution of ERRATA. For more information
on therefore solution and/or where to find the updated files,
please follow the link below. You may reopen this bug report
if the solution does not work for you.