| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> ah
<1> dude I can figure that much out
<1> I'm asking if there's a decent way hehe
<0> ok, nevermind then
<2> FIXED IT
<2> Forgot to add datadir= in my.cnf
<3> lol
<0> ok, where did I say that
<2> Now to install qpopper
<2> ...
<0> 19:28:05<0> erf: did you set that in /etc/my.cnf?
<0> 'that' refereing to datadir
<4> hello, I cannot connect to mysql server running on linux machine. ( i am using SQLyog as client to connect to the linux server ) The sql server is running and i have checked that.
<4> my.cnf does not contain any bind parameter ?
<0> intel_in: can you connect using 'normal' mysql client applications?
<0> I guess that's a " I don't know" :)
<3> hahaaaa
<3> 'desperado' on TV
<3> ten years ago it was the only video tape at home
<3> ;-)
<5> Kemurii: http://seattletimes.nwsource.com/html/foodwine/2002884676_cicero24.html
<0> litheum: WHOOT!
<0> Belgians taking over!
<0> litheum: btw, I might come crash at your place.. if PJ comes over.. though, I let you know upfront :P
<5> lol what!
<0> they offer even Croque Monsieur!!!
<5> well of course, that's not so crazy
<0> I'm getting hungry now when I read it
<0> need to visit that place one day
<0> just to check whether the Frites with mussels is ok
<6> belgian frites is horrible.. way to fat :)
<6> too greasy
<0> depends where you eat them, which corner of the street
<6> True :D
<6> As long as they make it in oil and not ossewit it's ok :)
<0> I like the one at the slaughter house in Anderlecht, but the one at my parents place: beik
<0> Shariff: exactly
<0> left of the stock exchange in Brussels there is a good one
<6> I thikn I remember that one...
<4> Kemurii: I have to try that.... ( i mean connecting using normal mysql client applications )
<0> it makes them in oil, ltos of vegies there :)
<0> intel_in: good, if that works, ask the SQLyogiestuff folks :)
<0> domas can hug them at the UC
<5> Kemurii: it's all the beer there that i'm most excited about
<0> litheum: no belgian women around? :/
<5> not that i know of, no
<0> litheum: aah, good :P
<5> haha
<4> kemurii: i have used mysql on linux to connect. It is one of client utilities to run SQL commands
<0> ok got to run :)
<0> laters folks :)
<7> litheum: I got another one, a little less severe.
<4> i think it is networking problem. ( well, i have pgsql and i use pgadmin) for e.g in pgsql , i have to change the pg_hba.conf file to allow connectins outside the localhost ?
<4> where can i find such a file on mysql ?
<3> whom?
<3> ah, sqlyog
<7> litheum: this time it's a 4.0 box
<5> TodoInTX: is it the same problem? can you please write an email to the support issue? i will make sure someone who is working takes a look.
<7> ok thank.
<5> domas: wordpress queries are awful... i turned on strict mode in 5.0 and the whole thing went to hell
<8> hello, could anyone give a hint, I am trying to echo last 5 rows of a field, what for should I look? SELECT LIMIT?
<3> I should try 2.0
<3> before I start making public comments
<3> but I feel like doing that.
<5> big problem i had before was that most of the columns didn't have default values but were not specified in value lists for inserts
<3> well...
<3> 30052 Query SELECT ID, COUNT( comment_ID ) AS ccount ...
<3> is this designed to scale? ;-)
<9> settd: SELECT field1 FROM table1 ORDER BY ordering_expression DESC LIMIT 5;
<3> I'm happy my data is just 24 posts yet
<3> this one is magic: 30052 Query SELECT * FROM wp_users WHERE user_level > 0 ;)
<5> :-O
<8> Xgc what is ordering_expression ?
<9> settd: THe expression you need to use to handle your requirement for "last 5".
<9> settd: Last 5 suggests some ordering from first to last.
<9> settd: In SQL, you get ordering via ORDER BY expressions.
<9> settd: Without the ORDER BY, your result is not ordered.
<8> I see
<8> I wan to order by id
<8> the newest rows 5 rows
<9> settd: Then use id as the order_by_expression.
<8> thank you
<8> sorry, I am total newbie. thx a lot
<9> settd: SELECT ... ORDER BY id DESC LIMIT 5;
<9> You're welcome.
<10> can anyone help me out a bit with my mysql, when i try to import this text file to phpmyadmin im getting a syntax error, I can't figure out what it is
<11> hello.
<12> Dustin__: Take a look just before the text quoted in syntax error message
<10> salle: you french?
<11> under what conditions does mysql write lots of data to a (deleted) scratch file in /tmp?
<12> Dustin__: Nope.
<10> salle can you take a look over this and tell me why im getting the syntax error on import
<10> http://pastebin.com/622029
<10> i know 0 about sql
<12> Dustin__: if you know nothing about SQL start with the basics. Try www.sqlcourse.com for example
<12> Dustin__: So what is the error message you get?
<10> salle: http://pastebin.com/622034
<12> Dustin__: It should be obvious :)
<12> Dustin__: '
<12> Dustin__: Do you see the difference between: 'abc' and 'ab'c' ?
<10> yes on denver omlet
<10> i see the ' before
<12> Dustin__: Escape it with \
<12> Dustin__: .. you can say \'Denver ...
<12> Dustin__: Or change 's to "s around that text
<13> hi everyone
<13> I'm trying to compile mysql workbench from svn but when running autogen.sh I'm getting and error saying that the pkg-config script for glib could not be found or is too old... can someone help me fix this?
<13> (Linux, Ubuntu, Dapper Drake)
<14> why are you trying to compile it?
<13> firewire: because 1.0.5 beta doesn't work :(
<15> !tell us about doesn't work
<16> mhillyer asked me to tell you this: Look buddy, doesn't work is a strong statement. Does it sit on the couch all day? Does it want more money? Is it on IRC all the time? Please be specific! Give us the FULL EXACT error message. Tell us what it does and/or does not do.
<17> SELECT user.id, user.user, birthday, user.gender, user.area FROM user LEFT JOIN user_stats on ln_index ORDER BY ln_index.sortcol; <-- can someone explain whats wrong with that one???
<18> quad_ first find out what your server thinks
<13> quad_: the birthday field may be repeated on both tables?...
<6> FROM user LEFT JOIN user_stats ON ln_index =?...
<6> There is no field defined for the join to use
<13> oh, right, well caught Shariff
<6> It's something I always forget too :D
<13> :)
<13> mhillyer: as for the "doesn't work part", I'm not asking about why mysql workbench doesn't work, I'm asking if someone knows how to make the configure script happy on Ubuntu, because I've tried everything I could think of (not much, to be honest, since I'm no genius when it comes to compiling stuff using autotools & friends)
<13> but for what it's worth, the exact error message is this:
<13> checking for GLIB... configure: error: The pkg-config script could not be found or is too old. Make sure it
<13> is in your PATH or set the PKG_CONFIG environment variable to the full
<13> path to pkg-config.
<15> I always want to know the root of the problem borfast, as do most of the people who provide ***istance in here.
<15> If we answer the first question asked, more often than not we are helping people do the wrong thing.
<13> the root of the problem (or at least as far as I can dig it) is what I said in the first place: the configure/autogen script complains that the pkg-config script for glib could not be found or is too old.
<15> Aah but our first question was why are you trying to compile it, that is the root of the matter I was referring to.
<18> so check and discover where and why your glib is wrong (and maybe read the configure script where it fails)
<13> since I have both glib.pc and glib-2.0.pc in /usr/lib/pkgconfig, I'm not sure why it's complaining :\
<13> mhillyer: lol ok, I understand you, now
<13> well, if someone knows how to make mysql WB work out of the box, I'd certainly appreciate it too but I've searched about it and the only thing I found were questions about how to solve the same problem I have (on Linux/Debian/Ubuntu the program crashes, doesn't start, etc), so I thought it was something that no one had been able to solve, yet
<13> hence, I got the sources from svn and was trying to compile them
<18> borfast what video card ?
<13> archivist: nVidia GeForce 6200
<18> ok
<13> (both GLX and GLX-dev are installed, btw)
<18> check configure script for your error message and see what it was looking for
<13> I already did that, it was looking for glib-2.0
<13> and glib-2.0.pc is installed in /usr/lib/pkgconfig
<13> that's why I don't understand why it's complaining :\
<18> could be a bug in the script (comment out and try again)
<19> can anyone notice an error in this update statement, following my mysql book i think ive got th sql statement right. Phpmyadmin just says theirs an error but doesnt say at what point . UPDATE Banner SET `bannerName`=PromotePhoenix,`clientName`=Phoenix Enterprises,`Url`=http://www.marketing.com,`bannerCode`=Phoenix Add WHERE `id`=2; :
<18> lots of errors there
<18> put strings in ' '
<19> thx, didnt know that, my sql is not so great, thx again archivist
Return to
#mysql
or
Go to some related
logs:
#perl
disks-admin create grayed
#perl
pclinuxos gdl
fopen+ailed to open stream: Permission denied
/bin/sh: cmp: command not found Try setting CONFIG_KALLSYMS_EXTRA_PASS
#mysql
#gimp
configuration directory /root/.synaptic - mkdir
create special device none
|
|