it's a little confusing still, to me - it's not clear if by entering a blank form I clear all tags, or only my own
2007-10-04 27751, 2007
ruaok
"To clear your tags"
2007-10-04 27706, 2007
ruaok
what would you suggest I do to make that more clear?
2007-10-04 27708, 2007
brianfreud
but I get it - and it looks, then, like there would be no way for me to remove "mipe" is it were something offensive, say, "memberofNAMBLA"
2007-10-04 27718, 2007
brianfreud
*s/is/if
2007-10-04 27753, 2007
ruaok
that's correct. :)
2007-10-04 27756, 2007
brianfreud
well, let's say I personally had tagged it "food" and "love". If I wanted to add a third tag, would I need to enter "food love great" in the blank to avoid clearing the old two tags when adding "great", or would I just have to enter "great" to add it?
2007-10-04 27713, 2007
brianfreud
or is it only a completely empty form that removes tags?
2007-10-04 27722, 2007
ruaok
doesn't the fact that your old tags get loaded give you enough of a clue?
2007-10-04 27728, 2007
gioele
(comma separated tags I hope)
2007-10-04 27759, 2007
brianfreud
ah, ok, I see what you mean
2007-10-04 27723, 2007
brianfreud
just kind of, for me, non-intuitive
2007-10-04 27751, 2007
ruaok
I can see that.
2007-10-04 27759, 2007
ruaok
fortunately its a nice system once you clue in.
2007-10-04 27704, 2007
brianfreud
also, what is a "word characters"?
2007-10-04 27708, 2007
ruaok
getting people clued in right away will be the challenge.
2007-10-04 27718, 2007
ruaok
alpha numberic.
2007-10-04 27723, 2007
ruaok
-b
2007-10-04 27733, 2007
ruaok
suggestion for a better word?
2007-10-04 27739, 2007
gioele
do you really have to say that?
2007-10-04 27744, 2007
brianfreud
"alpha numeric characters"?
2007-10-04 27752, 2007
gioele
just say any character except commas
2007-10-04 27707, 2007
gioele
or except commas, periods and...
2007-10-04 27709, 2007
FauxFaux
Letters and numbers.
2007-10-04 27727, 2007
ruaok
faux ftw!
2007-10-04 27742, 2007
gioele
"Letters, numbers and spaces" (I push for comma separated tags ;) )
2007-10-04 27742, 2007
Aankhen`` has quit
2007-10-04 27703, 2007
ruaok
gioele: did you even read the link?
2007-10-04 27705, 2007
FauxFaux
Anyone who gets "word characters" has done /far/ too much perl. :p
2007-10-04 27713, 2007
brianfreud
only thing I don't like about "alpha numeric" is it implies that 青木麻由子 wouldn't be valid, and it is
2007-10-04 27734, 2007
LotR
FauxFaux: you can't do too much Perl
2007-10-04 27736, 2007
gioele
ruaok: yes, but often implementors slip on what the specs say ;)
2007-10-04 27741, 2007
brianfreud
I guess the question more is, what characters are *not* valid?
though artist mbids don't seem to actually be found...
2007-10-04 27737, 2007
ruaok
any sql experts in the house? i need some help on a left join.
2007-10-04 27746, 2007
ruaok <=== sucks
2007-10-04 27754, 2007
gioele
[silence]
2007-10-04 27713, 2007
rpedro joined the channel
2007-10-04 27723, 2007
ruaok
IS NULL is not the same as = NULL
2007-10-04 27727, 2007
ruaok
grr. I keep forgetting that.
2007-10-04 27709, 2007
brianfreud
hmmm, I'm not getting my own verification email :D
2007-10-04 27732, 2007
ruaok
select m.name, mp.name, mp.value from moderator as m left join moderator_preference as mp on m.id = mp.moderator where mp.name is null or (mp.name = 'tags_public' and mp.value = '1');
2007-10-04 27739, 2007
ruaok
is what I wanted.
2007-10-04 27751, 2007
ruaok
brianfreud: your email isn't setup either I see. :)
2007-10-04 27702, 2007
brianfreud
you mean apart from providing it during registration?
2007-10-04 27729, 2007
brianfreud wonders if he needs a mail daemon on this virtual server
2007-10-04 27737, 2007
FauxFaux
Nooo!
2007-10-04 27705, 2007
gioele
FauxFaux smelled an open relay?
2007-10-04 27705, 2007
ruaok was referring to the email server
2007-10-04 27704, 2007
brianfreud
umm, ok - what command starts that?
2007-10-04 27729, 2007
ruaok
apt-get install exim4
2007-10-04 27735, 2007
brianfreud hasn't felt this much a newbie in a while
2007-10-04 27737, 2007
ruaok
but I've always had issues with that.
2007-10-04 27711, 2007
brianfreud
hmmm, "exim4 is already the latest version"
2007-10-04 27725, 2007
brianfreud
*s/newest/latest
2007-10-04 27726, 2007
ruaok
case in point. :0
2007-10-04 27758, 2007
brianfreud
lol, have to find it kind of funny that I can't verify myself to myself
2007-10-04 27725, 2007
ruaok
cd admin
2007-10-04 27730, 2007
ruaok
./psql READWRITE
2007-10-04 27739, 2007
ruaok
select id from moderator.
2007-10-04 27747, 2007
ruaok
s/./l/g
2007-10-04 27749, 2007
ruaok
;
2007-10-04 27752, 2007
ruaok
feh.
2007-10-04 27729, 2007
ruaok
update moderator set email='foo [at bar.com]', emailconfirmdate = now() where id = <id from listing>;
2007-10-04 27733, 2007
ruaok
log out and back in.
2007-10-04 27748, 2007
ruaok
\q
2007-10-04 27757, 2007
ruaok
to get back to the shell
2007-10-04 27730, 2007
brianfreud
ok, did that, now it doesn't like my password
2007-10-04 27759, 2007
ruaok
redo the first select and double check your password
2007-10-04 27754, 2007
brianfreud
what command do I give psql to show all moderator info for moderator rowid = foo?
2007-10-04 27727, 2007
ruaok
select * from moderator where id = <rowid>;
2007-10-04 27731, 2007
xlotlu has quit
2007-10-04 27754, 2007
brianfreud
it just takes me back to a psql prompt when I try that
2007-10-04 27701, 2007
brianfreud
musicbrainz_db->
2007-10-04 27708, 2007
Muzzz
You need to put ; at the end
2007-10-04 27711, 2007
Muzzz
Otherwise it won't execute
2007-10-04 27723, 2007
brianfreud
oh, I see
2007-10-04 27716, 2007
brianfreud
that's why the email thing failed too
2007-10-04 27719, 2007
brianfreud
thanks
2007-10-04 27729, 2007
Muzzz
np
2007-10-04 27730, 2007
ruaok
np
2007-10-04 27731, 2007
Muzzz
I may be drunk
2007-10-04 27734, 2007
Muzzz
But I can do stuff!
2007-10-04 27720, 2007
ruaok
Muzzz: we haven't done this in nearly 7 years, but still:
«Every time you compile the program and it fails to compile without errors or warnings: one drink»
2007-10-04 27723, 2007
xlotlu joined the channel
2007-10-04 27736, 2007
gioele
«fails to compile without errors»
2007-10-04 27739, 2007
ruaok
und der groschen fällt
2007-10-04 27740, 2007
ruaok
:-)
2007-10-04 27713, 2007
ruaok wundert sich obs eine modernere version gibt
2007-10-04 27720, 2007
ruaok
-s
2007-10-04 27735, 2007
gioele
I must be asleep... how can a program fail to compile *without* errors or warnings?
2007-10-04 27755, 2007
ruaok
dude, the guy who wrote that was drunk. (me)
2007-10-04 27759, 2007
brianfreud
hmm, ok, it won't let me log in via the web - I've even tried manually resetting the password in the terminal, and I can see that it is correctly updated in the terminal...
