233523 - Remove the obsolete section about MySQL and enum() fields

Status: RESOLVED FIXED

(Bugzilla :: Documentation, defect)

Description

[trevor]

User-Agent:       
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)

The last paragraph of the above URL, the author points out that all his hassle
could have been avoided by simply editing "checksetup.pl". That's not entirely
correct, one needs to edit "localconfig" and then run "checksetup.pl".

As it stands the documentation is a bit confusing since looking through
"checksutup.pl" I thought I had found and changed the variable I needed.

Reproducible: Always
Steps to Reproduce:
1.
2.
3.

Comment 1

[Dave Miller [:justdave]]

Confirming.  I had just been proofreading that section and was about to file
that one myself.

This whole section could use a rewrite anyway.  I really like the original
author's storytelling (we should probably attribute the original author if we
can figure out who wrote it, since it's giving a personal experience), but a lot
of the info is out of date.  My other notes about this section:

4.5.1: need to use -p to prompt for a password.  change "if this works without
prompting you for a password" to "if this works", then add another example with
the -p to prompt for the password.

4.5.1.1: "show tables from bugs;"  " from bugs" is redundant, we just did a "use
bugs" above, and "show tables;" by itself will use the current database.

the table definitions are WAY WAY WAY out of date
many formatting errors and omissions here, too (use <screen>?)

Comment 2

[Gervase Markham [:gerv]]

The original author of that extended anecdote disguised as docs is barnboy, I
believe.

I shoved this lot to the end of the chapter when I was reorganising it, because
rewriting it looked like a lot of work. I think that, nice though the style is,
we should really find out what it's saying that is not being said elsewhere, and
say that elsewhere :-)

Gerv

Comment 3

[Dave Miller [:justdave]]

Preliminarily moving all docs bugs to 2.18, we should make a valiant attempt to
have the docs as up-to-date as possible when 2.18 releases.

Comment 4

[Shane H. W. Travis]

*** Bug 251661 has been marked as a duplicate of this bug. ***

Comment 5

[Shane H. W. Travis]

Some additional comments from bug 251661;
"This renders badly, prints appallingly, makes me want to rip my eyes from 
their sockets.I have no idea how the text made its way into your system, but it 
looks like cut/paste from info followed by something ugly. :-)"

(Also comments, that it potentially a very useful document.)

"that whole section needs some work.  The schema described is outdated
(looks like 2.16) and the manual schema change examle is bad advice."

This part of the document is in an appendix in 2.16, and in the Customization 
section for 2.18/tip, but in all cases it can be reached via 
http://www.bugzilla.org/docs/[2.16|2.18|tip]/html/dbdoc.html

Comment 6

[Frédéric Buclin]

Attachment: remove the whole section

This section is completely obsolete now:

1) we don't use enum() fields anymore.
2) you can customize resolutions from the UI directly.
3) this is MySQL-specific although we support PostgreSQL too.
4) the list of tables is obsolete.
5) a better place to describe tables used by Bugzilla is http://www.ravenbrook.com/project/p4dti/tool/cgi/bugzilla-schema/.

6) <justdave> yeah, nuke it.

Comment 7

[Dave Miller [:justdave]]

Comment on attachment 246088 [details] [diff] [review]
remove the whole section

we're already pointing at the ravenbrook doc from somewhere else, right?

Comment 8

[Frédéric Buclin]

tip:

Checking in docs/xml/customization.xml;
/cvsroot/mozilla/webtools/bugzilla/docs/xml/customization.xml,v  <--  customization.xml
new revision: 1.37; previous revision: 1.36
done


2.22.1:

Checking in docs/xml/customization.xml;
/cvsroot/mozilla/webtools/bugzilla/docs/xml/customization.xml,v  <--  customization.xml
new revision: 1.21.2.7; previous revision: 1.21.2.6
done


2.20.3:

Checking in docs/xml/customization.xml;
/cvsroot/mozilla/webtools/bugzilla/docs/xml/customization.xml,v  <--  customization.xml
new revision: 1.20.2.7; previous revision: 1.20.2.6
done

Comment 9

[Frédéric Buclin]

*** Bug 345680 has been marked as a duplicate of this bug. ***