#mysql
27 December 2007
Total 16 pages. You are browsing page 1/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Thu Dec 27 00:00:51 2007
00:06 <****> how do you return a linux timestand from a datetime field?
00:06 <****> timestamp*
00:07 <****> just slipped my mind the functin
00:07 <****> unix timestamp*
00:07 <****> unis_timestamp()
00:07 <****> *unix
00:07 <****> yea just found it :)
00:07 <****> thank
00:07 <****> s
00:56 <****> hello
00:56 <****> pls I need help
00:56 <****> hi all
00:57 <****> helloo good morning
00:57 <****> you are welcomed!
00:57 <****> i have problem with mysql
00:57 <****> I also have a problem
00:57 <****> what is your problem?
00:57 <****> got joomla and everything workas just fine
00:57 <****> maybe you can solve eachother's problems
00:57 <****> ok
00:57 <****> and now... when i try to open some articles
00:57 <****> ??
00:58 <****> what happened?
00:58 <****> page is loading 2h ?
00:58 <****> 2h?
00:58 <****> i didnt do nothing in joomla
00:58 <****> ok
00:58 <****> what is the best datatype to store a password? VARCHAR or CHAR?
00:58 <****> Urden probably varchar
00:59 <****> depending on if they are variable lenght
00:59 <****> Urdern, you can store a password in Password format, encrypt it or leave it plain with VARCHAR
00:59 <****> how to see what is happening in mysql when i try to open article ?
00:59 <****> ok skyrider, listening to you!
00:59 <****> there is a "password" type in mysql?
00:59 <****> no
01:00 <****> there is!
01:00 <****> look in phpmyadmin
01:00 <****> or maybe I am getting it wrong!
01:00 <****> ebergen, i have it as a varchar at the moment. looking for a way to encrypt it
01:01 <****> hmm...
01:01 <****> Urden: do it in your application
01:01 <****> so i try to remove some components
01:01 <****> Urden mysql will not do that for you
01:01 <****> and seo
01:01 <****> but still get same problem
01:01 <****> are you using phpmyadmin?
01:01 <****> ok
01:01 <****> also, you should hash your passwords, not encrypt them
01:01 <****> me ?
01:01 <****> yes
01:01 <****> and then compare the hash of the entered password to the one in the db ebergen ?
01:02 <****> yes
01:02 <****> ok
01:02 <****> ok
01:02 <****> thanks
01:02 <****> in your phpmyadmin, you will have a hash, password, md5 encryption
01:02 <****> specially in varchar option
01:02 <****> phpmyadmin has nothing to do with the question
01:02 <****> ok, skyrider,
01:03 <****> you were talking about your problem
01:03 <****> urden talk about storying variable to mysql database
01:03 <****> passwords
01:03 <****> right?
01:03 <****> yep
01:04 <****> what to do ? where to look ?
01:04 <****> you have 2 choice. either from php or phpmyadmin
01:04 <****> skyrider
01:04 <****> still you have not yet explained clearly your problem
01:04 <****> still listening to you
01:05 <****> i cant find what is problem with long querys or something like that ?
01:06 <****> waht error message have you got?
01:06 <****> non
01:06 <****> slow?
01:06 <****> to slow
01:06 <****> !m SkyR1der slow lo
01:06 <****> !m SkyR1der slow log
01:06 <****> Sorry - I have no idea what function you're talking about! but try http://dev.mysql.com/slow lo
01:06 <****> Sorry - I have no idea what function you're talking about! but try http://dev.mysql.com/slow log
01:06 <****> !m SkyR1der slow query
01:06 <****> SkyR1der see http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
01:07 <****> ok now, let me come in
01:07 <****> I am working on an ajax script and it si requesting for odbc driver
01:07 <****> where can I locate it pls
01:08 <****> the the php information is located at
01:08 <****> afidegnum: dev.mysql.com/downloads
01:08 <****> http://www.realtipper.com/info.php
01:08 <****> no I mean on my server
01:08 <****> if you want odbc drivers for mysql, download it
01:09 <****> myqsl is working right, but the developer tell me I have specify a dfiver path
01:09 <****> to my sript
01:09 <****> and secondly, I am workong on a shared server
01:09 <****> wher I cannot install things there like that and expect it to work
01:10 <****> what driver you want? mysql ext or odbc? thats different
01:10 <****> ok look at http://www.realtipper.com/info.php
01:10 <****> you already has mysql ext
01:10 <****> have you located any driver there?
01:11 <****> afidegnum: find "mysql" there is 1 section with the paths
01:13 <****> ok
01:13 <****> pls for those who have some knowledge in php
Total 16 pages. You are browsing page 1/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last