| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Comments:
<0> ;/
<1> Magn3tiK: try ORDER BY ID + 0
<0> k
<2> Ajayu, GRANT ALL PRIVILEGES ON {database}.{* OR TABLENAME} TO 'username'@'localhost' IDENTIFIED BY 'p***word'
<3> ok
<4> hi can anyone help me when i am trying to start mysql as root i always get this message:
<4> 060303 19:17:52 [ERROR] Can't start server : Bind on unix socket: Permission denied
<4> 060303 19:17:52 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
<5> i just moved a timestamp field to be first and the previous first-positioned timestamp is being updated on record change. i even restarted the server
<2> Ajayu, You understand that query?
<5> so what is going on
<2> Ajayu, EXAMPLE: GRANT ALL PRIVILEGES ON database.* TO 'admin'@'localhost' IDENTIFIED BY 'p***word'
<1> albo: what version?
<5> shabbs: 4.1
<0> shabbs: $req = scpSql("SELECT `auteur`, `date`, `langage`, `id` FROM `wall` WHERE `nolist`<>1 ORDER BY ID + 0 DESC LIMIT 5");
<0> Dont works
<1> albo: Any single TIMESTAMP column in a table can be used as the one that is initialized to the current timestamp or updated automatically.
<1> albo: http://dev.mysql.com/doc/refman/4.1/en/timestamp-4-1.html
<1> !tell us about doesn't work
<6> shabbs 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.
<1> and if it's more than 2 lines of output please use a pastebin
<4> hi can anyone please help me?
<1> kami22: well do you already have a mysql server running?
<4> yes this server was running
<4> but today it doesnt start its a local small system but i dont know how to find out if the port ist bounded
<1> kami22: no, when you try to start it, is there an instance of it already running?
<4> noo there is no instance running nothing in ps -Af
<5> shabbs: these are the first two timestamps
<5> stupid_idiot: `modified` timestamp NOT NULL default CURRENT_TIMESTAMP,
<5> `startdate` timestamp NOT NULL default '0000-00-00 00:00:00',
<1> kami22: then check /tmp to see if there is already a file there
<1> albo: interesting, I'm not sure. you could check for a bug
<1> though I'm not familiar enough with timestamp to rule that a bug
<7> is it possible for an account to be created that can write to the database (like, via a POS application) but can't see the tables or the info in them?
<4> i cleaned up the complete folder there is nothing inside
<1> kami22: what about rights/ownership on /tmp?
<8> Can anyone help me work out a tricky relationship for me?
<8> I have this (diagram) setup: http://davey.is-a-geek.com/rel.png
<9> craigb***1976: grant insert (and update, if needed), but not select
<8> where 'item' are all in one table, as is their parent relationship, and location is in another table "linked" by a ID in the 'item' table
<8> Currently I only have 3 levels of parent/child, as illustrated, but I'm moving towards unlimited and I see no feasible way to go from the "youngest" child to the location
<1> !tell Davey` about trees
<6> Alrighty.
<8> it must be possible though, right?
<10> so ... do you guys say my-see-queue-ell or my-sequel ?
<11> oracle
<12> ess queue ell
<12> my squirrel
<1> oh-rack-le
<9> pose-gres-quell
<11> heh shabbs: like all the indians ?
<1> I guess? indians say it that way?
<8> shabbs: does this stuff work in MySQL 4.1?
<11> shabbs: a lot of the south indians
<1> Davey`: it's general SQL so it should
<1> Davey`: or rather as generalized as possible
<11> !tell alphablue about trees
<6> Alrighty.
<1> alphablue: I didn't know that. I work with hicks so...
<11> ahh
<11> i used to be surrounded by indians.
<11> probably has to do with me being an india
<11> n
<1> !
<1> a true indian or an injun?
<1> :D
<8> shabbs: I can't do the left/right stuff...
<11> it's funny when they become recruiters, and then call you asking if you could send them your resume .. (like resume operations) instead of resumay
<9> minDscrm: http://dev.mysql.com/doc/refman/5.1/en/what-is.html (see the bottom of the page)
<11> shabbs: the true indian
<1> alphablue: I had that, they called me and I didn't understand a word
<11> yea, it's horrible when they do that.. and usually they're the "screeners"
<10> thx snoyes
<11> you want my resume ? what do you want me to resume ?
<1> alphablue: they've had a special on CBS (I think) for the past week on India, one of the specials was on how young americans go over there to work now
<11> really ? cool. i guess they like roughing it
<1> yeah
<11> driving in new delhi is insane
<1> they all rode in on bikes
<1> I've never been, but my parents lived there for 4 years
<1> back in the 70s
<11> then again, pune and bangalore were rural places.. with the recent tech boom population is increasing.. but like they say. you can't take the trailer out of a person
<11> ahh where did they live ?
<1> new delhi
<11> ahh cool
<11> so emb***y work ?
<1> yeah
<11> i was fortunate that i was exposed to the american and british school from very early on. i used to play soccer with all the emb***y kids.
<11> my father had a colleague fresh off the boat working at metlife, he was amazed cars had Air conditioning and radios
<11> shabbs: i was born in 78, and lived there till 1991, used to live about 20 minutes away from the american school
<1> ah
<11> even then i stole all the american girls from the american boys
<1> I'm hungarian born, my dad works for the foreign ministry
<8> shabbs: what if I just want to deal with the two levels right now, I'm thinking of migrating to a location -> item look up table kept up to date from the code when items are added
<11> ahh
<11> heh sorry for ***uming you were american
<1> alphablue: np, happens all the time. I live here so *shrug*
<1> Davey`: it's probably better if you come up with a scheme to deal with unlimited levels, that way you don't have to redesign stuff later
<11> same with me, with my "american accent" and all people in texas think i'm just another mexican who grew up here
<1> haha
<11> i walk into a taqueria and people start talking to me in spanish
<8> shabbs: I have like 10 million rows, its already a re-design ;)
<1> Davey`: I see... well all the more reason to do it properly
<8> currently we only go from location -> item and we recurse it in the code, but my boss wants to work the other way too :/
<10> mmmm i miss taqueria's :(
<8> shabbs: any sane way to generate the left/right stuff?
<8> using SQL only (MySQL 4.1)
<1> so you have child to parent but you wanna be able to go parent to child?
<8> no, we have locate -> parent -> child (-> child)
<7> snoyes, thanks
<8> we need to go (child ->) child -> parent -> location
<1> hmmm
<8> and actually, there may be no children
<8> it might just be parent -> location
<1> you could recurse backwards I suppose
<8> shabbs: how would I do that in one query though?
<11> looks like i've been using "adjacency lists" without knowing thats what it's called
<1> well in the code
<8> shabbs: that's not fast enough :/
<13> or pivot table
<8> I'm willing to use a slow SQL solution to migrate to the lookup table though. Or a new schema
<1> Davey`: you could try to upgrade to 5.0 and use SPs
<8> archivist: I want to generate a pivot table, but I have to do it using SQL, nothing else
<8> shabbs: not a solution
<8> we already know of one BC break that affects us
<1> meh
<11> archivist: can you explain pivot table to me in 2 sentences ?
<1> !tell me about trees
<8> (we already have MySQL 5 in our timeline though)
<3> !m Ajayu delete user
<6> Ajayu: Nothing found
<3> !m Ajayu remove user
<6> Ajayu: Nothing found
<1> !m Ajayu revoke syntax
<6> Ajayu: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<9> Davey`: ***uming you're using some sort of nested set approach, and you know the childId, couldn't you do something like SELECT locationId FROM items WHERE parent IS NULL AND {childId} BETWEEN left AND right; ?
<9> that parent IS NULL might not be quite right, perhaps something like locationId IS NOT NULL
<2> snoyes, You making a tree system?
<2> Hierarchial Data
<9> not I. see Davey`'s comments.
<2> Nested Sets is a nightmare
<2> It's inefficient
<2> Use Nested Intervals
<3> Keizer: my problem is when i try to install plesk, it says that cnat connect with user admin, do you know why?
<2> Ajayu, Ah
<2> Ajayu, Plesk only works with certain versions of MySQL I believe.
<2> But, maybe you need to use OLD_P***WORD() for your admin p***word.
<2> I can't remember for sure
<2> Well
<3> I reset the p*** of admin
Return to
#mysql
or
Go to some related
logs:
#suse
#debian
netapp+mountvers
39160 ubuntu adaptec
#kde
#perl
debian etch netstat ipv4
#web
2 different isp one gateway
extra qualification ‘MTaskContainer::’ on member ‘drawShadowText
|
|
