You want this bot on your irc channel ?. Please contact me at
nospam2[aT]lo2k.net

Already 102208 links catched

See channels list

102208 Links

retour

hit

57
hits

http://rafb.net/p/ZjN1qC71.html

Said by

port4l from #mysql time

2 yearss ago

detail

report as explicit

show keywords context

context

----------------
Xgc : port4l: That's really rough. Can you attempt to write that as a JOIN?
port4l : Ok
Xgc : You'll need to do that if you plan to go further.
Xgc : and you won't be able to use the correlated subqueryies, at least you shouldn't.
Xgc : s/y//
port4l : http://rafb.net/p/ZjN1qC71.html
port4l : Is there any way to get this to give me a list by PatientID ?
port4l : Could I add PatientID to the SELECT, and do a group by?
Xgc : port4l: Remove the WHERE clause. Make the JOIN do all the work.
port4l : I don't know how to make the JOIN specify only a certain ID
javaJake : Xgc, you mean you can do multiple conditions on a JOIN? Brilliant!
javaJake : With commas I assume?
Xgc : javaJake: AND
javaJake : Ah, of course
Xgc : javaJake: Just like any condition.

57
hits

http://pastebin.com/d5bedcee1

Said by

MinusCreative from #mysql time

2 yearss ago

detail

report as explicit

show keywords context

context

----------------
acidfingers : but I can't set it to anything between there, even 2007-04-01 02:00:00 and 2007-04-01 02:59:59
acidfingers : that entire hour seems to cause an error
landley : Ok, according to the /etc/mysql/my.conf that Debian comes with, bind-address=127.0.0.1 and there is no skip-networking.
landley : Yet lsof -i doesn't show the mysqld bound to anything.
archivist : what did the bot tell you about bind-address=
MinusCreative : http://pastebin.com/d5bedcee1
landley : To remove it.
MinusCreative : can someone help me out with getting all clients even if they don't have a site in that query?
landley : huh, it's listening to port 28514. Why is it doing that?
adaptr : is the site in a different table from the clients ?
adaptr : landley: it isn't - lsof does not show ports
MinusCreative : adaptr: elaborate? i don't understand the question.
MinusCreative : clients hold clients, and sites holds sites, clients_sites ties them together
MinusCreative : which sites belong to which client
adaptr : MinusCreative: I thought it was very clear: are the sites in a different table from the clients ?

57
hits

http://rafb.net/p/HQx62U28.html

Said by

Xgc from #mysql time

2 yearss ago

detail

report as explicit

show keywords context

context

----------------
acidfingers : yeah, they changed it from what would have been april 1st this year, to march 11th
ki77a77 : acidfingers: sorry, I didn't scroll back far enough.
acidfingers : so all the embedded computers that don't get updates were oblivious
acidfingers : after reading around a bit it looks like it is caused by the server's OS not being aware of the time chance
acidfingers : change*
Xgc : port4l: http://rafb.net/p/HQx62U28.html Explain plans for the original (derived table) version and the optimized version.
landley : After running the root password reset script linked to earlier, it still won't do "mysqladmin version".
landley : It still says it can't connect to server at localhost.
landley : I tried mysqladmin version -p and typedin the password. Didn't help.
landley : the_wench: what do you do if mysql just doesn't work?
landley : Reinstall?
the_wench : debug , read error messages
acidfingers : for what it's worth, I just updated my windows with the DST fix and restarted the mysql server, and it works now
landley : the_wench: And if the error messages provide no information.
the_wench : I dont believe you, read error messages are allways helpful, ask the friendly people in the channel

57
hits

http://paste.ishock.kwix.info/3

Said by

iShock from #mysql time

2 yearss ago
duped by user

Rootshell @ #mysql time

2 yearss ago

detail

report as explicit

show keywords context

context

----------------
Xgc : javaJake: Why did you use a LEFT JOIN?
javaJake : Xgc, I want a list of times, and the classes that are assigned to those times, but only if a specific user is assigned to that same class as well
Xgc : javaJake: There's no reason for an outer join if you didn't need to show classes not associated with the chosen user.
javaJake : Xgc, please read my entire message.
Xgc : javaJake: I did. The problem is your description doesn't match your example.
javaJake : Xgc, the example is completely fake based on only the data I will use.
javaJake : Xgc, to geenrate the output I want, I either have to go through tedious recreation of what it would've been, or have to figure out how to get something to generate it for me.
Xgc : javaJake: Well, based on your output, you want the most trivial form of inner join between a few tables.
Xgc : javaJake: SELECT ... FROM t1 JOIN t2 ON ... JOIN t3 ON ...;
Xgc : javaJake: The user selection criteria can be in the join criteria or in the WHERE clause: WHERE tx.user='Tim'
javaJake : But if I use a WHERE clause, and the user has not signed up for classes in particular times, the empty times will not be included in the results
Port4l : Xgc - I'm ack.
Port4l : back*
Xgc : javaJake: Your output doesn't show that case, so I have to assume you didn't want that.
Xgc : javaJake: That's why I asked for a full example case with some classes not selected by some user.

57
hits

http://pastebin.com/m45cbfc54

Said by

javaJake from #mysql time

2 yearss ago

detail

report as explicit

show keywords context

context

----------------
mishehu : but if somebody could look at it and see if/what I am doing wrong I'd appreciate it
javaJake : Xgc, OK, wow, so this appears to be working so far:
javaJake : SELECT * FROM times LEFT JOIN class_time_r ON class_time_r.cid = times.tid LEFT JOIN classes ON class_time_r.cid = classes.cid LEFT JOIN class_user_r ON class_user_r.cid = classes.cid AND class_user_r.uid=18;
javaJake : OOps, I'll use pastebin
Xgc : javaJake: Not necessary. That's a pretty common mistake (misplaced join criteria).
javaJake : Xgc, http://pastebin.com/m45cbfc54
javaJake : Xgc, heheh, yea, as you can see by the output, it wasn't exactly correct
javaJake : Xgc, but it's close
javaJake : Xgc, oh, heheheheh, whoops...
ocho_ha : hey all
ocho_ha : does mysql store the cardinality of a table, the number of rows that is?
ocho_ha : in a place that's easy to get to?
ocho_ha : I'd like to find a way to count the rows in a table more efficiently than max(id) or whatever
Xgc : ocho_ha: MAX(id) isn't a count of the rows.
ocho_ha : oops

57
hits

http://rafb.net/p/45SDNu80.html

Said by

Port4l from #mysql time

2 yearss ago

detail

report as explicit

show keywords context

context

----------------
arjenAU : accidentally.
ki77a77 : Rootshell: sorry, my error
Rootshell : I doubt it, but it's on my linux OS...Gimme a little while
ki77a77 : Rootshell: didn't see it as two tables
arjenAU : Leetziggaj: to recap, in a nutshell... you're running around like a loony. it serves no purpose. the prob is not mysql related. it's unix shell related (bash), and most likely just bad paths. you generally can' just dl a script and run it on any box, it depends onyour distro where htings are and such. however, the key problem is that you are just blah'ing on that you don't understand that what to do next, which kinda puts the problem on other peop
Port4l : http://rafb.net/p/45SDNu80.html
Port4l : How can I turn that into a count of distinct days by patientID ?
Port4l : I tried a couple approaches, but no luck
arjenAU : Port4l: (Pharmacy.DispDate + DaysSupp) still an expression
arjenAU : has to be calculateed, so no index can be used
Port4l : Erm shit
Port4l : Ok, I can fix that before hand.
arjenAU : you appear to be wasting a lot of time
Port4l : how/
Port4l : my time? or processor time..

57
hits

http://www.phpriot.com/6082

Said by

StormTide from #zftalk time

2 yearss ago

detail

report as explicit

show keywords context

context

----------------
ecoleman : so good luck on that one
StormTide : so what am i lookin for here
ecoleman : paste it!
StormTide : uhhh ok
StormTide : sec
StormTide : http://www.phpriot.com/6082
StormTide : (that was way too hard with all this scrolling displays lol)
StormTide : modeline "1680x1050@60" 147.14 1680 1784 1968 2256 1050 1051 1054 1087 -hsync +vsync
StormTide : is the right one for the 22"
ecoleman : which is the sony or the samsung
StormTide : sony is the 15"
StormTide : samsung is the big one
StormTide : modeline "1024x768@75" 78.8 1024 1040 1136 1312 768 769 772 800 +hsync +vsync
StormTide : is the correct one for the sony
StormTide : what is this virtual line

57
hits

http://dpaste.com/27459/

Said by

buggeredfstab from #mysql time

2 yearss ago

detail

report as explicit

show keywords

57
hits

http://www.alexa.com/data/details/traffic_details/lossless.f

Said by

jdl from #funradio time

2 yearss ago

detail

report as explicit

show keywords

57
hits

http://pastebin.com/m8bfa191

Said by

jeffj from #mysql time

2 yearss ago

detail

report as explicit

show keywords context

context

----------------
Illarane : chadmaynard: No, MATCH(field) AGAINST('words') is actually pretty useful.
chadmaynard : didn't say it wasn't
chadmaynard : i just said it sucks
Illarane : ;)
chadmaynard : ....
jeffj : anyone explain the crash here on the third query as anything other than a mysql bug? http://pastebin.com/m8bfa191
legolas-San_ : "Needs boxes that are built like bulls, though."
legolas-San_ : Heh...
Illarane : jeffj: Is -1 a valid unix time?
jeffj : no
jeffj : it's not
Illarane : Should produce a syntax error, though, shouldn't it.
legolas-San_ : Well, this is very painful for somebody with decidophobia.
jeffj : sig11, restarts daemon, but corrupts the fuck out of the tables
Illarane : :(

57
hits

http://www.paste2.org/p/10396

Said by

SpotSec from #zftalk time

2 yearss ago

detail

report as explicit

show keywords context

context

----------------
PartickThistle : So you want ZF to ignore this directory?
PartickThistle : and not try to interpret MailingController?
gunter_ : yep
gunter_ : it's not a controller. it's a seperate app
PartickThistle : I understand that, but your index.php file doesn't.
SpotSec : http://www.paste2.org/p/10396
Ai : [ Paste2: Next Generation Pastebin - Viewing Paste 10396 ]
SpotSec : it's very relaxed
SpotSec : RewriteCond %{REQUEST_FILENAME} !-f
SpotSec : RewriteCond %{REQUEST_FILENAME} !-d
SpotSec : means only rewrite if the file or directory does not exist
gunter_ : got that. will give that a try. Thanks SpotSec!
ShadwWulf : Question - Has anybody been having difficulty in reaching the http://framework.zend.com site in the last 24-48 hours?
Ai : [ Zend Framework ]
SpotSec : nopr

57
hits

http://eu.wowarmory.com/character-sheet.xml?r=Throk\'Feroth&

Said by

|Pixel| from #throkferoth time

2 yearss ago

detail

report as explicit

show keywords

57
hits

http://dev.mysql.com/no-auto-rehash

Said by

the_wench from #mysql time

2 yearss ago

detail

report as explicit

show keywords

57
hits

http://pastebin.ca/812928

Said by

aib from #mysql time

2 yearss ago

detail

report as explicit

show keywords context

context

----------------
Linex : I mean one for open cases and one for close cases.
thumbs : Linex: nah
thumbs : Linex: store all the cases in the same table, and add a 'status' field.
thumbs : Linex: which would be 'open' by default, and could be set to 'closed'
FFfanatics : even with the new index
aib : sigh, no love for me today http://pastebin.ca/812928
thumbs : Linex: there is no point in having two tables in this case
thumbs : Linex: the only reason to go with two would be if you have million of rows in it, and need to segment the data.
thumbs : Linex: KISS
thumbs : (Keep It Simple Stupid)
Linex : thumbs: ok. Its just that sometimes I need to search for something within open cases and sometimes I need to search for something within closed cases.
thumbs : Linex: WHERE `status` = 'open'
thumbs : replace 'open' with 'closed' when needed.
aib : alright i figured out how to do a cross database copy so screw the cross database join
thumbs : aib: what version of mysql are you using?

57
hits

http://pastebin.com/m42831fdb

Said by

chronosx from #mysql time

2 yearss ago

detail

report as explicit

show keywords context

context

----------------
ding0 : domas: Like I said I don't know howto do this but <a href="<?php if($name = !$name) { $addressBook_query = mysql_query("SELECT * FROM addressbook WHERE addressbook.client_idclient = 1000000 AND address_type = 'a' ORDER BY lname DESC"); } else { $addressBook_query = mysql_query("SELECT * FROM addressbook WHERE addressbook.client_idclient = 1000000 AND address_type = 'a' ORDER BY lname"); } ?>")">Name</a></th>
fdask : ding0: i'd consider taking that php outta that link tag XD
chronosx : MidMark: HAVING is always after the GROUP BY clause
fdask : just to make it easier to read
ding0 : <?php if($name = !$name) { $addressBook_query = mysql_query("SELECT * FROM addressbook WHERE addressbook.client_idclient = 1000000 AND address_type = 'a' ORDER BY lname DESC"); } else { $addressBook_query = mysql_query("SELECT * FROM addressbook WHERE addressbook.client_idclient = 1000000 AND address_type = 'a' ORDER BY lname"); } ?>
chronosx : MidMark: http://pastebin.com/m42831fdb
MidMark : SELECT NAME, TYPE, SUM(POWER) FROM rules GROUP BY NAME, TYPE HAVING (((Q_ID=1 AND ANSWER='no') + COUNT(Q_ID=2 AND ANSW+ COUNT(Q_ID=6 AND ANSWER='no') + COUNT(Q_ID=7 AND ANSWER='no') + COUNT(Q_ID=8 AND ANSWER='no') + COUNT(Q_ID=9 AND ANSWER='no') + COUNT(Q_ID=10 AND ANSWER='no') + COUNT(Q_ID=11 AND ANSWER='no')) > 8)
jeffj : please paste more sql
smxy : please don't
chronosx : MidMark: then remove the COUNT
MidMark : chronosx: oh yes
smxy : pastie is your friend
MidMark : chronosx: Error 1054: Unknown column 'Q_ID' in 'having clause'
MidMark : strange!!
MidMark : SELECT NAME, TYPE, SUM(POWER) FROM rules GROUP BY NAME, TYPE HAVING (((Q_ID=1 AND ANSWER='no') + (Q_ID=3 AND ANSWER='no') + (Q_ID=4 AND ANSWER='no') + (Q_ID=5 AND ANSWER='no') + (Q_ID=6 AND ANSWER='no') + (Q_ID=7 AND ANSWER='no') + (Q_ID=8 AND ANSWER='no') + (Q_ID=9 AND ANSWER='no') + (Q_ID=10 AND ANSWER='no') + (Q_ID=11 AND ANSWER='no')) > 8)

57
hits

http://pastebin.akrabat.com/97

Said by

Littlex from #zftalk time

2 yearss ago

detail

report as explicit

show keywords context

context

----------------
Akrabat : Littlex: http://pastebin.akrabat.com/96
Ai : [ PHP pastebin - collaborative debugging tool at akrabat.com ]
Littlex : crap, refreshed the wrong window
Littlex : yeah okay seems like i got my error
Akrabat : paste code into a pastebin ?
Littlex : http://pastebin.akrabat.com/97
Ai : [ PHP pastebin - collaborative debugging tool at akrabat.com ]
Littlex : yeah i am on it
Littlex : he still doesnt detect my helpers
_elemental : Mac speech recognition pwns
Akrabat : I would have thought that the constructor was a bit early?
Akrabat : require_once 'Zend/Controller/Plugin/Abstract.php';
Akrabat : require_once 'Zend/Controller/Action/HelperBroker.php';
Akrabat : class Viazenetti_Plugin_ViewHelperDirectory extends Zend_Controller_Plugin_Abstract
Akrabat : {

57
hits

http://forum.ubuntu-fr.org/viewtopic.php?pid=1371103#p137110

Said by

redox from #funradio time

2 yearss ago

detail

report as explicit

show keywords

rha y a plus pork que moi

57
hits

http://whois.domaintools.com/208.67.220.220)

Said by

poseidon from #freebox time

2 yearss ago

detail

report as explicit

show keywords context

context

----------------
poseidon : tu t'en fous des fonctions nat pour l'instnat
poseidon : *fout
Aanim : hello
Gady : j'ai pas l'icone "activer "
Aanim : euh petite question...
poseidon : erf
Aanim : comment on peut savoir l'etat du reseau ?
poseidon : pk?
poseidon : il fonctionne bien le réseau là... ^^
nine : hello aanim
Gady : aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaah !!!
Gady : C'est bon, ba didont !!!
Gady : J'ai trouvé !!
Gady : Je coche activé !!
Aanim : vraiment depuis ce midi

57
hits

http://fr.news.yahoo.com/afp/20080107/tod-autriche-animaux-i

Said by

Jack from #funradio time

2 yearss ago

detail

report as explicit

show keywords context

context

----------------
jdl : effectivement
X-Blaster : ah ouais ?
X-Blaster : "ils" c toi...
jdl : ah ... c'est pas du multiplayer ?
jdl : jpensais que c'etait du multiplayer moi
Jack : on a retrouvÃ© le chien de kamu http://fr.news.yahoo.com/afp/20080107/tod-autriche-animaux-insolite-7f81b96_1.html
flz : Bonjour, excusez-moi de vous importuner, j'ai besoin de votre assistance dans la transaction de la somme de dix millions sept cents mille dollars américains. Je vais vous donner 20% en contrepartie. Pour plus de détails, veuillez me recontacter. Merci.
flz : Mlle Deborah
X-Blaster : fait un reply
r_ : flz: ptin la chance
r_ : pourquoi ça m'arrive jamais à moi ?
X-Blaster : "tu m'importunes CONNASSES"
r_ : je serais riche
X-Blaster : S
X-Blaster : -S

57
hits

http://www.cdiscount.com/informatique/imprimantes-multifonct

Said by

jdl from #funradio time

2 yearss ago

detail

report as explicit

show keywords

57
hits

http://doc.ubuntu-fr.org/materiel/liste_portables

Said by

uBOTu-fr from #ubuntu-fr time