| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<Alex_C> Hum, it says I have an syntax error in this query:
<Alex_C> SELECT * FROM inv_admin_logs LIMIT 5 ORDER BY Date
<domas> wooooooo
<domas> IT WORKED!!!!!!!!!
<domas> IT WORKED
<SpComb> stuff usually does if you don't mess up
<Alex_C> lol
<SpComb> so no need to get excited
<domas> looooooook
<domas> doesn't work again
<domas> but it worked!!
<Alex_C> What is wrong with the syntax on my query: SELECT * FROM inv_admin_logs LIMIT 5 ORDER BY Date
<SpComb> domas: the star*keylogger thing is basically a DoS attack, and thence I wouldn't be surprised if it was illegal
<SaintCrowdness> Apachez, thanks for your help
<codergeek42> Alex_C: not sure, but I think your LIMIT clause needs to be the last thing in your statement
<codergeek42> s/statement/query/
<domas> look:
<domas> mysql> select * from b;
<domas> +-------+-------+
<domas> | x | y |
<domas> +-------+-------+
<domas> | mysql | rocks |
<domas> +-------+-------+
<domas> 1 row in set (0.00 sec)
<domas> it's so amazing!!!!
<SpComb> uuh
<SpComb> righto
<SpComb> nothing to get excited about
<domas> SpComb: why not? :)
<domas> now I wonder why it worked
<SpComb> because it was designed to work?
<domas> it was not ;-)
<domas> ok, I can show you how I created this table
<SpComb> how silly
<SpComb> oh, something more interesting?
<domas> CREATE TABLE b (x VARCHAR(255), y VARCHAR(255)) ENGINE=FIFO;
<SpComb> hmm, some twisted stuff
<SpComb> tell me more :o
<domas> SpComb: cp ha_example.cc ha_fifo.cc ;-)
<domas> I insert in one thread, read in another
<domas> woooooo
<domas> now I have to find why it doesn't work at the beginning... that is... what do I need to initialize
<domas> doesn't work too properly ;-)
<codergeek42> domas: race condition perhaps? (one thread tries to read before the other can finish INSERTing?)
<domas> codergeek42: naaah
<domas> codergeek42: seconds p*** ;-)
<domas> and it is in-memory
<Apachez> mysql rocks in-memory ?
<domas> sure it does
<CrazyTux> will, happen to be around? :)
<will> Not anymore
<will> It's the weekend! You want me to work on a weekend?
<Alex_C> is it possible to store a $var in memory? So if I set $Var1 = 'hello' on Page1.php, then I redirect to Page2.php and do echo $Var1 it will return 'Hello' ?
<SpComb> sessions are a nescesary evil
<MrCraig> hi all - can someone please tell me how I could discover the number of rows that would be returned by a query without actually returning the data?
<MrCraig> I need row counts only on m***ive tables.
<mhillyer> !man sql_calc_found_rows
<SQL> (SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/SELECT.html
<mhillyer> there ya go
<MrCraig> thank you :)
<isolate> hello everyone
<isolate> can someone please help me? my newly installed apache and php work but I don't know how to get mysql to run
<isolate> I have a simple script that pulls information from a mysql database that works on my installation of LAMP on windows
<isolate> sorry... it's not LAMP on windows but I'm sure you know what I mean :)
<bobfield> WAMP?
<isolate> yeah... WAMP
<isolate> how do I add the mysql module to apache in linux?
<MrCraig> if your php is working - open php.ini and make sure its extensions dir / root points to the php extensions (usually php/ext or php/extensions depending on version) then find the lines that say extension *mysql* (where * is wild) and uncomment them. (a google for "php apache mysql wamp" should find a more detailed how-to)
<isolate> I think that's my only problem
<bobfield> !google php apache mysql wamp
<SQL> php apache mysql wamp: http://www.en.wampserver.com/
<isolate> it's not for windows though...
<isolate> it's for linux
<isolate> my php is working
<MrCraig> infact I was reading one only yesterday - bookmark =
<MrCraig> http://www.thesitewizard.com/archive/php4install.shtml
<isolate> <?php
<isolate> phpinfo();
<isolate> ?> works just fine
<isolate> cool I will go check it out
<isolate> I noticed though in my folder with the .so modules that mysql isn't there
<MrCraig> then look at the "configuring php" part of the how-to - it should have what you need to connect php to mysql.
<MrCraig> did you use the windows installer for php ?
<isolate> *this is not for windows*
<isolate> it's for ubuntu linux
<MrCraig> Get the zip version and simply extract it over your existing php installation - for some reason the installer doesn't seem to have the right libs.
<MrCraig> (oh - then my appologies *blushes* I was sure I read windows up there somewhere)
<Tzuriel> i'm trying to access my db which i install some time ago and don't remember my root pw, i have root, but ... mysqladmin -u root p***wd can't connect, what should i do?
<isolate> I said that I could get it working just fine in windows but having a tough time in linux :)
<MrCraig> :-) Well I wish I could offer the same help for linux, but I've only ever used distro's where all three were pretty much pre-configured.
<isolate> I appreciate the help regardless though... :)
<isolate> Tzuriel, reinstall or bruteforce?
<isolate> yeah... I wished that it was that easy :)
<bobfield> I installed php 5 once, maybe it was beginner's luck but I got it right the first time
<Tzuriel> isolate: wow, i'm sure there's a better way than that ... but might be a good time to put 5 on, if only emerge offered it
<isolate> but it's not :)
<isolate> using linux?
<bobfield> yes, linux
<MrCraig> omg - my sql_calc_found_rows ran out of memory.
<isolate> bobfield, which version of linux are you using?
<bobfield> slackware 10.2
<isolate> Tzuriel, there is probably a better way.... :)
<bobfield> 2.4.31 kernel
<isolate> is that based on debian?
<bobfield> not that I'm aware of
<isolate> bobfield, did you install everything manually or did you have something like yum, apt-get, or some other "auto" installer install everything?
<bobfield> I install things manually
<bobfield> well I did use the apache that was preinstalled
<isolate> that's probably my downfall with my current install.
<isolate> I used apt-get
<isolate> it installed apache and php beautifully but mysql does seem to want to play
<bobfield> I downloaded php from php.net
<isolate> do you have any idea what would need to be done in order to get the mysql module recognized by apache? I have gone through the manual but can't seem to find how I would add a module
<bobfield> Just like I downloaded mysql from mysql.com
<bobfield> to my knowledge apache doesn't interact with mysql directly
<bobfield> I only enable php in apache
<bobfield> configured/built php with mysql support
<bobfield> worked like a charm except I forgot to enable mysqli functions
<isolate> that's what the manual told me to do. this is what it said: " This means that your PHP version isn't compiled with MySQL support. You can either compile a dynamic MySQL module and load it into PHP or recompile PHP with built-in MySQL support. This is described in detail in the PHP manual."
<isolate> oh... load it into php
<isolate> not apache
<bobfield> apache -> php -> mysql
<isolate> so I need to tell php where mysql is
<isolate> but how do I do that? :S
<will> php.net/mysql
<bobfield> [php] configure --with-mysql[=dir] --with-mysql-sock[=dir] --with-mysqli[=file]
<bobfield> I got a warning and threw in one other option, I can't remember it
<domas> php-config....
<domas> ergh, mysql-config
<bobfield> I'm just quoting the help
<bobfield> like I said I forget the mysqli part
<bobfield> I let the dirs default too
<will> You don't want to, actually.
<bobfield> must be beginners luck then
<will> Because there is no default directory. Not specifying a directory tells PHP (in the case of the mysql extension) to use the built in library, which is old.
<isolate> will, thanks... it looks like I will have to uninstall php and reinstall with mysql support
<will> How did you install PHP?
<will> There are usually packages you can download/install that comes with what you need./
<isolate> I used Synaptic package installer in ubuntu
<bobfield> gunzip, tar, configure, make
<bobfield> working like a charm so not messing with it
<isolate> I think synaptic uses apt-get
<isolate> the down side to using auto-installers is that you can p*** any configuration switches or anything like that
<minDscrm> hey guys is it good to start an ID at 0 or 1 ??
<minDscrm> if i just want to have it be my index
<isolate> *can't
<will> minDscrm, What do you ask?
<minDscrm> will, i want to have an index for my data... is it good to start the index at 0 or at 1 ?
Return to
#mysql
or
Go to some related
logs:
Philosophae Naturalis Principia Mathematica
No rule to make target * infiniband
#egghelp
super grub img to floppy kubuntu how
selectall_hashref not working
osdev rtc
how to install nerolinux
#linux
rhel4 mysql5
configure-trackpoint deb
|
|
