#mysql
23 October 2007
Total 29 pages. You are browsing page 4/29.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
02:18 <****> I'm not telling
02:18 <****> that might be why
02:18 <****> ?
02:19 <****> just trying to rationalize
02:20 <****> !owners
02:20 <****> I am owned by: Therion, dean, will, [RainMkr], arjenAU, HarrisonF, salle, will[werk], flipmcf, litheum, _RainMkr_, alphablue, GwaiLo, Leithal, Leith, Xgc, mhillyer, pcarsten, snoyes
02:20 <****> You know, that flags a lot of people...
02:20 <****> is there a script to remove table prefix from a large DB
02:20 <****> flags, beeps...
02:20 <****> oh it does?
02:20 <****> this: SELECT title, subtitle, body MATCH(title, subtitle, body) AGAINST ('designer'); gives me an ERROR 1064 (42000). Why? What are the reserved words?
02:20 <****> this is on a 5.0.45 on Debian
02:21 <****> eleftherios: Full error message
02:21 <****> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MATCH(title, subtitle, body) AGAINST ('designer')' at line 1
02:21 <****> So look before MATCH... you have an error there...
02:21 <****> Hint... you're missing something...
02:21 <****> an apostrophe?
02:21 <****> no....
02:22 <****> colon
02:22 <****> shhhhh
02:22 <****> hehe
02:22 <****> ?
02:22 <****> eleftherios: Look before MATCH(... you're missing something rather important
02:23 <****> !man full-text
02:23 <****> (Full-Text Restrictions) : http://dev.mysql.com/doc/mysql/en/fulltext-restrictions.html
02:23 <****> will[werk]: could you please tell me, it is 3 in the morning and I have been coding all day...
02:23 <****> Go to sleep then
02:23 <****> Do this in the morning after a good rest
02:23 <****> I need to finish this to sanely go to bed :-)
02:23 <****> I have work in the morning, this is a personal project
02:23 <****> :-)
02:23 <****> eleftherios: do this a sensible way
02:24 <****> http://labs.google.com/sets?hl=en&q1=colon&q2=apostrophe&q3=&q4=&q5=&btn=Large+Set
02:24 <****> i said colon and apostrophe as hints
02:24 <****> Huh?
02:24 <****> google labs can solve anything
02:24 * eleftherios is lost
02:25 <****> where do I need a colon before MATCH?
02:25 <****> oh nevermind I misread what you were doing
02:25 <****> SELECT title, subtitle, body MATCH(title, subtitle, body) AGAINST ('designer');
02:25 <****> this seems fine...
02:26 <****> How about this.. take out everything after MATCH... does the query work?
02:26 <****> what table does it examne?
02:26 <****> ISELECT title, subtitle, body MATCH(title, subtitle, body) AGAINST ('designer') AS score FROM articles WHERE MATCH(title, subtitle, body) AGAINST ('designer') ORDER BY score DESC;
02:26 <****> this is the full query as a matter of fact
02:27 <****> No "I"
02:27 <****> it examines `articles` chadmaynard
02:27 <****> Seriously, look right before MATCH
02:27 <****> eleftherios: And for the record, don't put ";" in your example if you don't really mean it
02:28 <****> the google sets caught it first try
02:28 <****> will[werk]: this exact query works on an other site I have...
02:28 <****> No it doesn't
02:29 <****> eleftherios: what do you have between title and subtitle?
02:29 <****> eleftherios: what do you have between subtitle and body?
02:29 <****> eleftherios: what doN'T you have between body and MATH?
02:29 <****> eleftherios: what doN'T you have between body and MATCH?
02:29 <****> a comma
02:30 <****> Woohoo!
02:30 <****> couldn't you tell me that I needed a comma? I am so sleepy I can't see it!
02:30 <****> Thank you though
02:30 <****> better late than never
02:30 <****> I did
02:30 <****> That's why you should sleep
02:30 <****> yes I should
02:31 <****> thank you
02:31 <****> :-)
02:31 <****> arg, this is such a pain
02:32 <****> set, what is?
02:32 <****> set, who is arg?
02:32 <****>proxy() for LWP, so I can fetch articles from this news site, so I can test my INSERT syntax, and update my database with the article content, author, date.
02:32 <****> What a royal PITA.
02:36 <****> setuid: you shouldn't be using anonymous proxies
02:36 <****> set, are you doing something naughty?
02:37 <****> blobaugh:
02:37 <****> chadmaynard:
02:38 <****> blobaugh: we just finished talking about you
02:38 <****> chadmaynard, And why is that?
02:38 <****> will[werk], Nope, not naughty
02:38 <****> setuid: what then?
02:38 <****> will[werk], Just trying to get some articles, but the upstream site is enforcing 1/30 minute reading
02:38 <****> chadmaynard: :( i always come in at the wrong time
02:38 <****> blobaugh: yea
02:38 <****> setuid: So stop reading so fast
02:38 <****> chadmaynard, If I shouldn't be using anonymous proxies, what should I be using then?
02:39 <****> stop reading so fast... hahahaha, you're funny
02:39 <****> set: obviously the owner doesn't want you to get these article at that speed.
02:39 <****> set, you can always contact them and ask the restriction to be removed for you
02:39 <****> sounds naughty to me
02:39 * blobaugh|sp checks logs ;)
02:39 <****> blobaugh|sp: i was just kidding!
02:39 <****> chadmaynard, One every 30 minutes? The articles are like 4 paragraphs
02:39 <****> will[werk], Thst's a good idea
02:40 <****> setuid: well i doubt they introduced the limit by accident
02:40 <****> will[werk], I can't use CDN, I can't use Google Cache, and I have to read them with Javascript and cookies enabled. Fsckers.
02:40 <****> chadmaynard: heh, i know. i needed to get into that acct cause someone sent me a link i needed to get. so i decided to have some fun ;)
02:40 <****> set, we're going to throttle the amount of lines allowed in #mysql soon...
02:41 <****> blobaugh: ahhhh, we have to call you blo or blob or bloba when set is around
02:41 <****> call me your mom
02:41 <****> muahahaha
02:42 <****> : (
Total 29 pages. You are browsing page 4/29.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last