| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9
Comments:
<0> sdf
<0> gh
<0> dfh
<0> df
<0> hf
<0> dfh
<0> amarok is still not showing mysql
<0> forget it
<0> i've wasted enough time
<1> how can i comment lines in mysql scripts?
<1> # ?
<2> has anyone found a way to get apache to dynamically load directives like <directory> from mysql?
<3> BigSinep: with ## or /* */
<3> ... or double hyphen, space
<4> Zyclops, that's a very interesting idea. please let me know if you make progress on this
<4> Zyclops, if you are interesting in hacking apache, i can probably point you to the code you need to play with
<4> s/point you to/point you at/
<2> ericP: apache will be in c++?
<4> Zyclops, c
<4> Zyclops, memory model involves allocations from a per-request pool that gets reaped when the request is finished
<4> Zyclops, so memory's pretty easy to manage -- just call the ap_ functions
<2> hmm, i think thats probably beyond me, i only know ruby, javascript, php and java
<4> Zyclops, are there any web server in those languages?
<4> Zyclops, i guess Jigsaw would count there
<2> i can't understand why there are apache modules that can do auth from a database and not a directory
<2> directive
<2> even
<2> i've seen one use virtualhost
<4> Zyclops, apache loads a set of modules at startup
<4> each module registers itself for certain callbacks which correspond roughly to phases in handling a request
<4> if you load mod_mysql, that module will register itself for the auth callbacks
<4> when invoked, the check_user_access mod_mysql callback will interrogate a simplifed view of the apache conf which just keeps track of what auth is required for what resources
<2> hmm interesting
<2> i might do it the way cpanal does it
<5> im having the following error presented when i try connect to my newly installed mysql http://pastebin.com/635697
<2> fopen the config file, write to the config and restart apache
<3> I'm trying to find the "data in (a,b,c)" documentation in the manual ... what is it under
<3> ?
<3> (found it here: http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html ... just discovered the index to the manual)
<6> archivist ;)
<7> whats the best collation to choose for a websites database?
<7> ?
<8> utf8_general
<3> yeah
<3> browser and php support for utf8 is good now
<7> ok thanks....
<3> (character set also needs to be utf8)
<9> hi! I have a table with track records. How can I select * FROM recordstable ORDER BY recordtime ASC, and get only one hit (the best record) from each `track`
<6> SELECT * FROM recordstable ORDER BY recordtime ASC LIMIT 1
<9> There are many different tracks
<6> GROUP BY track
<9> doesn't seem to work...
<9> SELECT * FROM recordstable GROUP BY track ORDER BY recordtime ASC doesn't work
<9> it doesn't give me the best records
<6> try SELECT track, MIN(recordtime) FROM recordstable GROUP BY track
<9> not successful either
<7> in a web database for a php driven website.. how much should i normalise for a large community website?
<7> as best a poossible?
<7> as*
<8> no, you should normalise as worst as possible
<8> that seems like an absurd question
<7> yeah but balazning the amount of tables versus server performance....
<7> balancing*
<7> is 250 tables feasible for the storage of user information and images?
<8> ....
<8> maybe if you're *myspace*
<8> what kind of website is this?
<7> localised socail network...
<8> ok
<8> so you *are* myspace
<8> then I guess 250 could be reasonable, ***uming you've got that many discrete information sets
<7> well aiming to have about 50,000 users..
<6> Darien you use php?
<7> but having tables for example- favourite drink..? (id,drink_title)
<8> Jax: on occasion, sure
<6> you have mysqli compiled in ?
<7> is that feasible?
<8> maxer: now *that* seems completely absurd
<8> Jax: on my laptop I do
<7> why?
<6> if you have a sec, could you run this php script (about 15 lines) .. a test case i wrote.. think i found another bug again
<6> just need to see if it's reproducable
<8> maxer: that's overnormalisation
<8> maxer: try creating a set of tables with columns for those preferences
<9> "SELECT id, MIN(recordtime) as min FROM records GROUP BY track ORDER BY min" gives me the right recordtime (lowest) but the id is not in sync
<8> maxer: you could have a pref_entertainment table, a pref_food_drink table, a pref_***uality table, etc.
<7> so my question earlier isnt as absurd as you may have thought
<6> Darien: http://pastebin.com/635778
<10> Im trying to make a really long DELETE QUERY and I'm getting ERROR 2013 (HY000): Lost connection to MySQL server during query - my max_allowed_packet is set to 1G - any clues what could be other wrong?
<8> Jax: 2006-04-02 09:43:17<br>2006-04-02 09:43:17<br>PHP Warning: mysqli::close(): Couldn't fetch mysqli in /Users/dan/Desktop/untitled.php on line 17
<6> Darien yeah... gah stupid
<8> :/
<6> if you use fetch_***oc instead, it works
<6> how stupid is that
<6> thanks Darien
<8> np
<9> Why can't I do: SELECT *, MIN(somefield) AS minf WHERE somefield != minf ?
<8> because you can't use aliases in the WHERE clause
<9> Do I have to use a dummy table or something?
<11> hi. I have a problem with charset, i think. My tables are in latin1_spanish_ci charset and the select works fine with phpmyadmin, but THE SAME sentence don't gives the same result if i launch it from php. I suppose that is a codification problem (looks like the spanish characters didn't match in the comparison)
<12> vicentecarro, try doing the following before SELECTing anything:
<12> mysql_query('SET COLLATION_CONNECTION="latin1_spanish_ci"');
<11> thanks, i go to check if it works
<11> Leftmost, it doesn't work
<11> the same effect
<12> What charset is the page being sent in?
<11> none, it has no one. It's php pure
<11> now i'm trying with charset=iso-8859-15, but still the same effect
<11> also i'm making an echo of the string sent to mysql and the 2 sentences are 100% equal
<13> when I get the -> because I haven't correctly written my sql-statement how can I escape without killing the mysql-client process? (like i do with ctrl+c)
<14> i have a strange error when trying to import my *.sql using phpMyAdmin. it's a mysql error: #1064 - 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 'collate latin1_bin NOT NULL default '', `cur_text` mediumtext
<14> on the server i have mysql Ver 14.12 Distrib 5.0.18, for pc-linux-gnu (i486) using readline 5.1, whereas locally i have mysql Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i486) using readline 5.1
<14> is a 'Distrib' difference of 1 enough to justify this error?
<14> the *.sql in questions loads fine locally.
<15> look for typos
<15> prolly the only thing
<14> w32: ok i will, but it loads locally fine, just not on the server.
<15> hmm, don't know for sure
<14> w32: actually i haven't even touched the table 'cur'..
<14> w32: does this look right? : `cur_title` varchar( 255 ) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL default '',
<15> yeah
<14> anyone in here a wizard with mysql error output?
<4> weedar, i don't know how to kill the query conveniently. i use mysqladmin processlist, kill
<14> here's the error: http://pastebin.com/635872
<16> would someone help me troubleshoot a cluster?
<17> im a drunk redneck with a 12 guage staring down bottles lined up on a fence when it comes to troubleshooting clusters
<16> lol
<16> oh c'mon you can do it!
<17> nah im slightly autistic
<17> i would be of minimal use
<16> kk thx anyway
<16> guess I'll tear it all down and start from sratch again! grrrrrrrrrrrr
<16> thx anyway, omni
<16> bye
<18> is there a limit to the number of tables a DB can contain?
<19> hey, guys - can anyone tell me how much overhead mysql + php adds to serverload?
<19> i.e. if vanilla apache can host 1000 html sites comfortably, how many cms driven sites would it most likely be able to host? 80%? 50%? 5%?
<20> soulfreshner: Way to many variables involved to answer that question.
<19> ok - rephrase: apache, php, mysql - php compiled as module, mysql on same server - all sites pulling the same amount of traffic on a 100Mbps backbone.
<19> the php used is for a CMS
<19> so most of the db calls are to retrieve large blobs of text
<21> can anyone point me to the error in this sql syntax? http://pastebin.com/635872 i don't see it.
<14> it imports fine locally, same version of mysql here as on the server..
<19> delire: what is the error message?
<14> soulfreshner: it's at the very bottom of that pastebin in grey. it reads: #
<14> soulfreshner: it's at the very bottom of that pastebin in grey. it reads: #1064 - 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 'collate latin1_bin NOT NULL default '',
<14> # `cur_text` mediumtext
<14> sorry about flood, accidental
<18> trying to run it on a mysql<4?
Return to
#mysql
or
Go to some related
logs:
#perl
#linux
'__offsetof__' was not declared in this scope
#perl
smp 686 locks with dual core
#php
#bash
#css
nvidia nvagp option suse10.1
suse broadcom bcm4303
|
|