| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> but thats not until the second step
<1> it is treating them as a empty string
<1> try either
<0> but im not populating the link
<0> ok lol
<1> see if anyone works
<0> Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/videomod/public_html/movies/modcp.php on line 9
<1> you will understand why afterwards
<2> all: NULL just means it's never been explicitly set
<0> "SELECT name, author, link, status, file_id, description FROM files WHERE status = 0 AND link IS NOT """
<1> yes null never been set but if he is inserting nothing in that column it is already set.. since the form treats nothign as "
<1> link !=
<2> _m00: yah, I'd hope that's obvious, he should know that]
<1> i don't think he does :x
<0> wait what
<3> The madness
<0> im not inserting it till the second step though
<2> this should all be very straight forward.
<3> Unless you're a newbie!
<1> noobies are cool
<1> Jezek
<1> just try it :)(
<1> see what happens
<0> argh it showed a smilie face haha
<0> what did you put
<1> asking mysql questions wont hurt the database
<2> _m00: not always true, haha
<1> heh
<0> checking if it is blank doesnt seem to be working
<0> 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 '""' at line 1
<1> ohoy
<1> != ""
<0> oh ok
<3> What's the full query?
<1> I don't know
<1> :)
<1> its a mind game
<3> Time to find out!
<1> i tihnk he is doing IS NOT ""
<1> !man IS NOT
<4> (Comparison Functions and Operators) : http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
<0> yeah that works
<0> thanks
<1> != or <>
<0> ok
<1> look at the docs
<1> it says IS NOT is for boolean
<1> "" is not a boolean
<0> oh
<1> docs are always good :(
<1> don't know why people hate them :>
<1> IS boolean_value, IS NOT boolean_value
<1> Tests a value against a boolean value, where boolean_value can be TRUE, FALSE, or UNKNOWN.
<0> i see
<5> hi all, I just did a clean install of mysql 4.1 on my debian box. I did a 'create databse foo'. Then as root 'select * from mysql.db' comes up empty ...
<5> is there something obvious I'm missing ?
<6> mysql_install_db , ran that?
<6> basvg ^^^
<5> damn, no.
<6> .. comes up empty.. or is there an error?
<6> must be error
<5> Kemurii: Empty set
<6> euh
<6> basvg: then mysql_install_db is not the problem..
<6> erm
<5> Kemurii: just to be on the safe side, I'll re-do the install and this time run the mysql_install_db script
<6> basvg: that table only gets filled when you set permissions ofcourse, like using GRANT
<6> basvg: nono, wait, how you installed it?
<7> hmm you can't lock and unlock from within an SP :((
<7> I wonder why
<5> Kemurii: I just did a `apt-get install mysql-server-4.1`
<6> basvg: k, just create a user then like: GRANT SELECT ON foo.* TO 'auser'@'localhost' IDENTIFIED BY 'ap***';
<6> basvg: should get entries then in mysql.db
<5> Kemurii: ok, I have another debian box and I just did a clean install there too
<5> so, this time I ran the script you mentioned, creating a new db now
<6> you don't have to, as the debian package does that.. but ok
<5> Kemurii: I did what you said (the grant line)
<5> but it's still empty
<6> and the mysql.user?
<5> the new user shows up in mysql.user
<8> http://www.mp3.muzyka.oz.pl :P
<6> basvg: huh.. what was your grant then?
<8> no grant
<8> only music
<6> Mortis_kruuul: just.. go..
<5> Kemurii: mysql> grant all privileges on wordpress to 'wordpress'@'localhost' identified by 'foobar';
<5> Query OK, 0 rows affected (0.00 sec)\
<5> Kemurii: the new user can log in with the p***word no problem
<5> 'show databases' only lists 'mysql'
Return to
#mysql
or
Go to some related
logs:
sql to diagram
#gentoo
ubuntu ndiswarper
mysql DROP USER 1268
xgcc: Internal error: Killed (program cc1) gentoo
pod2doc
#suse
#suse
#lgp
ndiswapper deb
|
|