| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> select 1 from A_table where 1 limit 1
<1> archivist: information_schema and mysql dbs are guaranteed to be there right?
<2> man i have no idea how to do that....
<2> i don't even think asterisk supports that
<0> never heard of asterisk
<2> asterisk.org
<2> check it out
<3> archivist: Open Source VOIPO PBX.
<4> hi. Is 5.0 considered production realy?
<3> archivist: I want to play with it sometime when I have some time.
<0> I contemplating
<2> its very cool stuff
<0> ^ am
<2> i just need to figure out how to store my call data in to a DB instead of the CVS file
<5> gandhijee: CSV file?
<2> comma delimited text file.
<5> gandhijee: yes, I know. You said "CVS".
<6> heh, I was thinking "concurrent versioning," too.
<5> Hi infi_
<7> Gandhiji ?
<6> hiya rindolf :)
<5> infi_: I'm having problem with MySQL on my home Mandriva box, and no-one here helps.
<2> yes?
<7> interesting name
<4> hi. Is 5.0 considered production realy?
<7> yes
<4> ready that is
<3> yes
<4> I keep getting a weird error with mysql in 5.0 that I never get in 4.1
<7> what error ?
<4> does anyone know how to resolve the problem with authdaemon and mysql? seems I ran into the snag of authdaemon complaining bout mysql going away.... and begins to reject all logins to the imap server
<7> authdaemon is connecting to mysql more than it should perhaps ?
<7> check with the courier people
<4> well it's not courier
<7> isn't authdaemon part of the courier tools ?
<4> I kinda figured someone in this chan would say something to that affetc
<4> if I use 4.1 it works fine
<4> but with 5.0 it complains
<7> did you compile authdaemon with 5.0 ?
<7> turn on debugging in authdaemon to see where the problem is ?
<4> okay, thanks
<7> you have two problems, 1. mysql's connect ignore setting is being reached, 2. there is something up with courier that it's reaching that
<4> sorry I didn't mean to be a jerk. Thats just a typical answer I usually get
<7> i figured :)
<4> :-)
<0> does authdeamon use pconnect
<7> not by default
<8> hi i'm a newbie and i have big login-in problems
<8> can anybody help me?
<4> we can't troubleshoot without knowing the problem
<9> i am having some trouble with the C function mysql_num_rows(), my query is returning successfully and i do int rows = mysql_num_rows(result); which always returns 0..
<8> the problem is:
<4> yes it was compiled with 5.0 the problem is.. its a old authdaemon.. I wonder if that coud be the pro
<8> (i'm in --skip-grant-tables mode)
<8> mysql -uroot -p
<8> Enter p***word:
<8> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using p***word: YES)
<10> I seem to be having a problem with courier's authdaemond.... for some reason once in awhile it seems to fail.. and reject any imap logins... saying that mysql has gone away.. a simple restart of the authdaemon seems to fix this... does anyone have any information on this
<8> w0ls0n, can you troublshoot now?
<10> its a old version of courier-authdaemon and I am wondering if that could be the problem...
<0> bit silly giving a p***word in skip grant mode
<8> mysql -uroot meccaniche
<8> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using p***word: NO)
<8> server:~#
<8> archivist, without giving a p***word, is the same ting
<8> archivist, without giving a p***word, is the same thing
<8> can anybody pls help me?
<0> !m mozz reset root
<11> mozz: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<5> Fixed it. Just dropped some unused tables.
<8> SQL, i followed the instructions on the links you gave me, but i didn't solve the problem
<12> sql is a bot
<3> Ssshhh\
<13> T1(id auto_increment, posting_id INT) // is there a way to insert a row into T1 with unique posting_id without doing two calls, one to get MAX(postign_id) and then the actual INSERT ?
<8> Jy, could you pls help me
<14> hmm
<14> someone just nominated me to write PHP|Architect's MySQL training course
<12> lucky you
<14> yeah
<0> get writing and we all can have a laugh
<14> roger that
<14> I wish Therion was online
<14> he could give me a reference
<14> and then the joke would be on PHP|A
<14> and we could all laugh at them when they pay me for it :p
<0> this is open source you dont need paying
<14> for writing a training course? could be :p
<0> getting paid to do open source would be nice though
<14> to do open-source training, yeah
<14> dunno how that would work with my work schedule
<14> but I could write the course, at any rate
<15> join the MySQL training team :-)
<14> I might, if this goes well :p
<14> and if they pay well :p
<16> Amount: $164.15 USD Sedo Parking Earnings April
<16> wewps
<16> disregard that was trying to post a line of code hehe
<14> :/
<17> lol
<0> moosey is cheap
<0> earns more that me!
<16> wish i was, i piss away money so stupid, live outta gas stations etc lol
<0> most of my money goes to uk tax man
<16> oh my mysqld was stuck at 99% now i know why it ran so slow
<18> I see the manual has been updated to reflect 5.1.11. Does this mean 5.1.10 is going to be released soon?
<18> The manual already shows updates to 5.1.11
<19> I have a table with 59 fields (not very well normalized, but I'm working through updating everything systematically, and this table is of low importance). This table has a PRIMARY KEY that is a multiple-column index (co_id, id). If I want to duplicate a row, changing only the id (auto-incremented column), and 1 other column (num_units), what's the best way to do that?
<19> a REALLY long subselect? (59 fields to dictate 2x right? Once in the INSERT, and once in the subselect?)
<19> I'm using 4.1.12
<20> This query gives me the right number select SUM(PRODUCTSOUT.PRICE*PRODUCTSOUT.UNITS) as ' ' FROM PRODUCTSOUT, TICKETS where PRODUCTSOUT.TICKETID = TICKETS.TICKETID and TICKETS.PERSON = 'Missy' AND DATE_SUB(CURDATE(),INTERVAL 1 DAY) <= DATENEW;
<20> and this one gives me double. SELECT SUM(PRODUCTSOUT.PRICE*PRODUCTSOUT.UNITS) as ' ' FROM PRODUCTSOUT, TICKETS, PRODUCTS where PRODUCTSOUT.TICKETID = TICKETS.TICKETID AND DATE_SUB(CURDATE(),INTERVAL 1 DAY) <= DATENEW and TICKETS.PERSON = 'Missy' and PRODUCTS.CATEGORY = '2';
<20> But I need it do do things by products.category.
<20> Where is the second one screwed up? I've been over it again and again, but no love...
<21> ola friends.
<22> I just read Sheeri's blog entry http://sheeri.com/archives/81
<22> but I don't understand why the trick is so neat.
<22> can anyone explain briefly?
<3> Good question, maybe ask in her comments.
<22> yes, I may do that, but I figured I'd rather look like an idiot in here.
<3> Though I would guess she thinks it is a good way to see the result of a convoluted query generation scheme
<22> except...
<22> I thought of that,
<3> Though in my code I just have the code finish by printing a string.
<22> but I'm not sure how you'd apply the technique in that case.
<22> hmm.
<22> okay,
<22> so SELECT "print anything at all, need not be a query";
<3> You would tack a select " to the front and a " AS debugstring to the back.
<22> I guess I got hung up that she was printing a query and saying it was a neat trick.
<23> also the "look how interesting my obsession with karma whoring in some pathetic web forum is"
<22> LOL.
<22> true.
<3> But again, just have your convoluted query generation scheme finish by producing a string and echo it.
<22> right,
<23> maybe it's useful if you look at mysql's own querylos ?
<23> *logs
<3> FurnaceBoy: Do us a favor and ask regarding the point in her comments.
<22> since how ELSE would you get at the result of the SELECT other than by issuing a query to SELECT <string> ...
<22> mhillyer, okay, I've got to go out for a bit, I'll think it over and maybe do that on my return.
<22> I just couldn't believe it was as pointless as it looked.
<3> Because I too only see 'look, I can echo a string! And the string itself looks like a query!
<22> osfameron, yeah, but if you're logging queries already.....
<22> then printing queries is doubly pointless, no?
<23> er...
<23> yeah!
<22> :-)
<3> well echoing them when developing is better than log watching.
<23> gosh, the more you read it, the moer you discover new depths of pointlessness
<23> it's like JAmes Joyce only the other way round
Return to
#mysql
or
Go to some related
logs:
gentoo konsolerc
#ai
#suse
kuroo eix
#perl
cpanel sucks
#physics
+quit gaim
mysql querey browser
gentoo epia-pd10000 ethernet
|
|