| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> anyone here running wamp
<1> winamp?
<1> :-P
<0> the server install wamp
<1> i know
<1> and yes, i do
<1> only php thoguh, no perl or python
<0> apache won't start
<0> i tried to install it 3 times now
<0> only 1 of 2 services start
<1> you probalby have a configuration error
<0> what do i have to do
<1> you should run the shortcut called "test server config"
<1> that will usually point out any errors
<1> could be sometihng stupid like port in use
<2> http://pastebin.com/537097 inserting that table into mysql 5.0 gives me this error: "ERROR 1067 (42000) at line 4: Invalid default value for 'id'"
<0> can't find that
<0> what is apache not starting
<1> dg_bluesky, it should be in the start menu
<1> with the other apach options
<0> im trying to install the server it won't let me
<3> tehhh: DEFAULT '0' is not needed.
<1> dg_bluesky, what oaert fails? the service installation?
<1> *part
<2> so i should remove it?
<0> its installed ok wamp but no apache server
<2> thanks
<0> start is grayed out
<0> i click on install but nothing
<1> in that program?
<1> apache monitor?
<0> in the wamp
<4> Hello, I'm sure this question is asked hundreds of times, but is it possible to ORDER BY before GROUP BY?
<0> this is why I hate this wamp program
<1> ooh
<3> mmelin: not really. That doesn't make much sense. What are you trying to do?
<1> i tohught you just had a WAMP setup, not a special program
<1> i would reccomend doing it all seperatly -- it takes longer to setup, but will be earier to maintain and update
<0> yes it did i went through it, and now i can't start any server
<4> inviso: I'm trying to count the number of posts, and at the same time get the timestamp of the last post
<3> !m mendel group-wise max
<5> mendel: (The Rows Holding the Group-wise Maximum of a Certain Field) : http://dev.mysql.com/doc/mysql/en/example-Maximum-column-group-row.html
<6> :)
<0> uninstalling it again now
<3> errr, mmelin that link was for you
<1> dg_bluesky, i would install th eprograms seperate
<4> inviso: thank you
<3> mmelin: np, good luck
<7> hello! what happens if I have an auto_increment column and I specify it to insert a value that is not yet in the column. for example in the column there are 2,4,6 and I want it to insert 5. what happens?
<3> !tell us about TIAS
<5> inviso asked me to tell you this: TIAS: Try It And See. You look silly asking if something will work when you can just try it and see. This channel is not a MySQL server ;-)
<8> DB design question for the panel
<8> do people think that an auto_increment column is necessary for all tables?
<8> I have a table of entries which will never be referenced by ID, so I'm thinking of making a composite primary key
<3> Darien: Anytime you don't have an obvious alternative PK, I'd say yes
<1> and avoid using anythign that could ever change
<7> ok. inviso. sorry.
<8> inviso: it's a preferences table (userid, prefname, prefvalue)
<8> so I was thinking of setting (userid, prefname) as a PK
<3> that seems reasonable
<1> that would make sense
<8> because it will never repeat as far as I can see
<8> the only difficulty would be in storing multiple values, but I don't think that would be a problem
<8> and to be honest, it's a trivial change if we do need to change that later
<8> another table is a list of 'tags' (blah), but it's just one column... should I use a tagid to reference it and JOIN to get the tagname, or should I just reference the tagname directly?
<9> 'lo
<9> how would i select the most recent x records in a table?
<8> !m oblio ORDER BY
<5> oblio: (Sorting Rows) : http://dev.mysql.com/doc/mysql/en/Sorting_rows.html
<1> Darien, if the tags shage, i would use an ID
<8> oblio: ORDER BY the primary key DESC
<1> *change
<8> IvanGirderboot: the tags themselves don't change
<8> IvanGirderboot: it will be a list of tags, and these tags can be applied to other things
<8> now that I think about it, this is a many-many relationship
<1> it still could be easier to work with ID's
<8> I'm going to need a separate table anyway
<1> tisk-tisk
<8> oh wait, I have a separate table
<8> I need to get an energy drink or something
<1> or sometihng hard
<8> I have something hard, that's probably why I'm so distracted :p
<1> ...
<8> :D
<8> I'm just kidding
<1> more than i wanted to know
<1> lol :-P
<8> (or AM I?)
<1> ze SQL gets your mojo goin
<8> aw yeah
<8> I'm an SQL pimp
<1> lol
<8> !tell us about big pimpin'
<5> But I don't know a thing about that.
<8> yeah? well I DO
<8> :(
<9> darien: thanks man
<8> np
<10> Hi all :)
<10> Quick q - anyone here know how to grant all privileges on '%_bugs.*' to ... ?
<10> (3.23.x)
<8> TruPilot: did you try that?
<10> Yep - got a syntax error.
<10> Tried it as '%_bugs.*', '*_bugs.*', %_bugs.*, and *_bugs.* and none of them worked. :/
<3> TruPilot: `backtick` quote it
<10> Should it be % or *?
<3> %
<10> Thanks :)
<3> np, enjoy
<10> '%_bugs`.* worked beautifully :)
<10> sorry ``, not '`
<11> bug report, dunno how to verify
<11> Select * from generalledger where account = 'harrykocot' order by account asc;
<11> result 9 rows
<11> Select distinct account from generalledger where account = 'harrykocot' order by account asc;
<11> empty set
<11> Select * from generalledger where account = 'ruthie' order by account asc;
<12> hmm interesting
<11> result 10 rows
<3> mut: can you pastebin a mysqldump of that table?
<11> Select distinct account from generalledger where account = 'ruthie' order by account asc;
<11> result 1 row with account name
<12> not a great idea to pastebin... sounds like commercial info
<11> inviso: um no, it's customers account data
<3> mut: then repro in a postable test case
<11> 89k rows
<3> yes.. Make... Up... a..... Test... Case...
<12> sigh
<12> postable test case would probably take a couple hours to munge
<3> not munge... *create.
<11> not familiar with any bug like this tho?
<11> if not i can mock up a test
<3> You'll need it for a bug report anyway if that's what it turns out to be
<11> right
<12> it is very weird
<12> um
<11> ah
<11> ahha!
<12> hate to ask you stoopid question, but have you doublechecked that 'harrykocot' = 'harrykocot' (in 1st and 2nd queries?)
<11> i pasted from the window..
<12> (i.e. are you selecting on same account val..... ah)
<11> http://bugs.mysql.com/bug.php?id=15102
<13> I have a master that used to be a slave. How can I get it to stop trying to connect to its old master?
<12> hmm... corrupt indices?
<11> it's an existing bug
<11> the quick fix works
Return to
#mysql
or
Go to some related
logs:
No buildable providers available for required build target
flightgear suse 10.0 rpm
#bash
efnet sql injection
dell inspiron 9300 audacity
#linux
yggdrassil linux
freenode password lost nickserv
running cardserv on ubuntu
#css
|
|