| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> Yeah, nobody uses kaya so there's nobody there
<1> what's Kaya ?
<1> oh
<2> another useless 2 member channel that Kii inceasently floods
<0> it's my CMS..
<0> Which isn't finished :\
<3> Ok, now that everyone knows, we can drop the subject and move on.
<0> but I mean, it works.. Just the admin cp isn't done.
<1> Kii: if you are having trouble getting users.....
<2> got a link kii? I didn't get my sql injection fill yet tonight
<1> ... are you announcing on Freshmeat.Net ?
<0> gone, kiirani.com
<2> hack time
<0> good luck injecting anything into it
<0> If you can even get to the admin cp.
<0> Oh wait
<1> Kii: be sure and announce your project on Freshmeat
<1> and update frequently
<2> holy ****, what an advanced CMI
<1> and you will get traffic
<0> Sneaky_Bastard, I can't, I don't update regularly at all.
<0> gone, ok you can cut the sarcasm now. You don't like me. I get it.
<0> it's just my pet project for now.. Maybe when it's actually finished..
<2> bahahah already hacked it Parse error: parse error, unexpected '\"' in /public_html/index.php on line 82
<2> that was too easy dude
<2> learn to mysql_real_escape_string()
<0> Funny, I don't see anything :)
<2> cause you're not hacking
<0> well if you find an actual weakness that doesn't just give you a parse error and actually want to point it out to me and tell me how to fix it so that I can IMPROVE, that would be nice.
<2> I would tell you how to fix it but this isnt #php
<0> Well shut the hell up and leave me alone then.
<2> awe, now I won't help at all :(
<4> its not #hack_ppls_pet_projects either.
<3> C'mon now...
<5> heh
<0> If you want so badly to be an ***hole to someone, go find someone else because I'm not in the goddamned mood.
<3> That's enough.
<0> I can't for the life of me imagine what I ever did to piss -you- off.
<6> how did freenode get everyone to host their official channels here?
<3> Ask lilo
<7> ^Migs^: the same way sf.net did :-P
<8> ok xgc, if you're still there, I've reinstalled my ftp server and it's now working
<9> Hey! Is there an easy way to fill a datetime, or seperate date and time variables, with values synchronous to when they're created?
<3> Insert NOW() ?
<3> INSERT INTO table ( datetime_column ) VALUES ( NOW() );
<10> what the hell is this? "select @a accountcode"?
<9> Sweeeeeeet. Thanks. :D
<3> !m Avochelm user variables
<11> Avochelm: (User Variables) : http://dev.mysql.com/doc/mysql/en/Variables.html
<10> ta
<8> still there xgc?
<12> Would it be difficult for me to store hagul (korean) characters in my database along with english ?
<13> aaarrrggh: Check your league_rankings tables.
<13> aaarrrggh: Your teams are not properly ***ociated with a league. See the league_id.
<8> ok hang on
<8> let me check
<13> aaarrrggh: That's why all your d.field references are null. There are no matching entries in d.
<13> aaarrrggh: See? It's all about the data.
<8> hang on though
<8> arent they ***ociated through the 'idteams' field?
<13> aaarrrggh: It's the league_id test that is the issue.
<8> ah yes
<8> I think I'm seeing it now
<13> WHERE leagues.league_id = 32
<8> think so
<8> hmm
<8> hang on
<13> HOld on.
<8> ok
<8> hmm.. but doesnt that get sorted out in the 'teams' table
<8> I mean... check that idteams are the same in teams and 'league_rankings', then check that leagues. league_id = teams.league_id
<8> I thought that would do it?
<13> aaarrrggh: team_names_id don't appear to match idteams.
<13> LEFT JOIN league_rankings AS d ON b.team_names_id = d.idteams
<8> hang on
<8> I dont think those should match
<13> aaarrrggh: Yes. You should be using idteams in both tables.
<8> how come?
<8> I mean, team_names is only there to store the text for each team name
<13> aaarrrggh: Because you need to join on like fields?
<8> yes, but what I mean is, 'team_names' only stores the name of each team... there should only be say 25 team_names if I've got 25 differently named teams in the database, but in 'teams', which is where the information about each team ***igned to a player is stored, there could be thousands of records
<8> does that make sense?
<13> aaarrrggh: To join league_rankings to team_names, you need to use the idteams key, which is the common field between those tables.
<8> idteams is different though
<8> that identifies a team that has been ***igned a player
<13> aaarrrggh: I'm explaining why your query is returning all those nulls.
<8> ok go on
<13> aaarrrggh: The idteam key is the field you need to use to join rankings (which has an idteam field) and the team_names table (which also has an idteams field).
<13> I meant idteams in all cases there.
<8> team_names doesnt currently have an 'idteams' field though
<8> I'm not sure why that should be needed in team_names to be honest
<13> aaarrrggh: Sorry. I was referring to the teams table (b).
<8> ah yeah
<13> aaarrrggh: You used the wrong key.
<8> but it's already done inside the query though isnt it?
<8> did I?
<8> hang on
<8> where?
<13> LEFT JOIN league_rankings ...
<13> Look at that.
<8> xgc
<8> I love you
<8> lol
<8> finally
<8> it works
<8> I see
<8> b.idteams = d.idteams
<8> that's the bit that was wrong before
<8> it was saying b.team_names_id = d.idteams
<8> gotcha
<8> thanks :)
<13> You're welcome.
<9> Hey, everybody! :D My error is...ERROR: 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 'posted='2006-04-03 23:06:14'' at line 1
<9> I'm just trying to insert a date.
<9> The actual code is posted=$posted
<14> i think a 152-line mysql query isn't a query, per se, it's a program.
<9> But then the $posted is...$posted = date('Y').'-'.date('m').'-'.date('d').' '.date('H').':'.date('i').':'.date('s');
<14> i'd love to structure this beast a bit. time to learn about stored procedures.
<15> anyone awake? I'm having trouble with apache/MySQL. I'm actually trying to install phpbb and everytime I try to use a user I created it attempts to use the user 'apache@localhost' which is the user apache is set to use. Anyone have any idea why this is happening and how to correct it?
<7> TheChronoTrigger: wrong room
<7> you gotta check #phpbb and you most likely won't find any help.
<7> i recommend you study a few mysql/php/apache books and familiarize yourself with http://docs.mysql.com
<15> I was there, they were stuck as well
<15> all works if I create a apache user in my database with the appropriate permissions, but I can't select to use another user
<7> TheChronoTrigger: sounds like a ##php problem.
<7> in any case, i doubt you'd find much help for installing scripts...
<7> the channels here are more for development help, not for a support desk for other pre-written scripts...
<15> ok thanks
<16> trying to install static tar file locally under a home directory. on startup of mysqld I get [ERROR] Can't find messagefile '/usr/local/mysql/share/mysql/english/errmsg.sys'
<16> I though that the tar distribution would look for its files relatively to the directory from where it's executed..
<17> Hi!
<17> I am in a truble with mysql character set, and I need a little help (Of course I'm a beginner)
<17> My webserver and webpage uses UTF-8 encoding
<17> I set the database and later, the table encoding (using phpMyAdmin) to utf8
<17> but I have still problems with special caracters
<17> What and where should I take a modification in order to get the special caracters displayed correctly?
<18> Hi. I'm trying to connect to a remote mysql port using ssh port forwarding ( ssh -L 4999:localhost:3306 remotehost ). When I try to access the port (mysql -P4999 -uuser@localhost -p) I get this "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)" . Any ideas ?
<19> tecnico: yeah
<19> tecnico: when it sees the "localhost" part it decides that it has to connect through a socket not through a tcp port
<19> tecnico: i think there is a way to force it to always use a port and not a local unix socket. I might try "127.0.0.1" instead of localhost
<19> tecnico: I have an application that does the exact same thing
<18> tnx. I'll try the IP
<19> tecnico: makes a mysql connection to localhost that is actually an ssh port forwarded mysql daemon from another machine
<18> link ?
<19> it is a proprietary application
<19> :/
<18> :) !! :) ok. np.
Return to
#mysql
or
Go to some related
logs:
#ubuntu
hdparm + enabling dma on dvd writer + gentoo
#centos
if (select * from Table ) is null mysql
intel 220bg ubuntu drivers
ultrabios100
#bash
#osdev
#gentoo
#perl
|
|