| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
Comments:
<0> DELETE FROM topaanbod_mail WHERE topaanbod_mail.id in (
<0> Select topaanbod_mail.id
<0> From topaanbod_mail Left Join vastgoed ON topaanbod_mail.id_vast = vastgoed.id
<0> Where vastgoed.int_status Not In (2, 3, 1)
<1> there's is a disable-all. :o ... lol
<2> in ports
<3> yereth: #ysql ?
<3> and use a pastebin
<0> )ow lol
<0> Drakas: sorry :)
<3> Alija_: download manually :]
<4> Alija_: Darwinports?
<0> I have #mysql and #php both open
<2> and how will i compile ?
<5> fact of the day: nusoap has a friggin memory leak.
<0> excuse me if you will
<3> yereth: you need to add a ")" at the end
<2> frixon, freebsd5.3
<2> i am using ports
<0> Drakas: it's there, I failed to copy it :)
<3> :]
<3> yereth: try ot the subquery
<3> and see if it works
<4> port install php5 +apache2 +mysql5 +gd ;)
<2> hm.. i have apache, and mysql
<2> i shouldnt touch that
<0> Drakas: it works and gives me a list of (id)s
<4> Alija_: Those are switches for PHP
<4> Alija_: That doesn't install Mysql oder Apache
<3> oder apache/:)
<0> Drakas: is it possibly because it works on the same table that it won't work?
<3> you're german i guess
<2> Apache Version Apache/1.3.33 (Unix) PHP/5.1.2
<0> otherwise I may need a temp table
<2> i dont use apache2
<3> yereth: im no good at mysql ;] mysql manual would be helpful
<4> Drakas: Yep :)
<4> Common typo
<4> Alija_: So use +apache
<0> Drakas: the manual seems to tell me this is valid
<3> also, try out Select instead of delete
<2> ok
<3> so you wouldn't delete anything :]
<3> and would see what is going to be deleter
<0> hehe.. well the select in between works well and gives the expected result
<2> port install php5 +apache2 +mysql5 +gd thats not the command in freebsd
<0> so if it deletes anything it will delete what I want it to
<3> Alija_: lol
<3> :D
<0> I'll try #mysql, thanx Drakas
<2> :)
<3> ;] SELECT * topaanbod_mail WHERE topaanbod_mail.id in (Select topaanbod_mail.idFrom topaanbod_mail Left Join vastgoed ON topaanbod_mail.id_vast = vastgoed.id Where vastgoed.int_status Not In (2, 3, 1))
<2> I dont know how to compile witout --disable-all
<4> Alija_: I thought you are using Darwinports on BSD :)
<0> Drakas: #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 'topaanbod_mail WHERE topaanbod_mail.id in (Select topaanbod_mai
<2> but why did it use the configure command --disable-all by default ?
<3> Alijawait
<2> oks
<3> ;] SELECT * FROM topaanbod_mail WHERE topaanbod_mail.id in (Select topaanbod_mail.idFrom topaanbod_mail Left Join vastgoed ON topaanbod_mail.id_vast = vastgoed.id Where vastgoed.int_status Not In (2, 3, 1))
<3> ;]
<3> Alija_: install from the source
<3> yourself!
<3> it wouldn't hurt
<2> hm
<0> lol
<2> http://snaps.php.net/
<2> whichone is for me
<3> middle oen
<2> i see 5
<3> middle top on
<0> Drakas: #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 'Select topaanbod_mail . idFrom topaanbod_mail Left Join vastgo
<3> Stable (5.1.x-dev)
<0> this is the same problem I get with the DELETE
<3> hm
<0> it seems it doesn't accept nested queries
<3> yereth: a space?
<3> SELECT * FROM topaanbod_mail WHERE topaanbod_mail.id in (Select topaanbod_mail.id From topaanbod_mail Left Join vastgoed ON topaanbod_mail.id_vast = vastgoed.id Where vastgoed.int_status Not In (2, 3, 1))
<3> :))
<3> anyone know why is http://snaps.php.net/win32/ empty?:))
<4> yereth: You should write all MySQL keywords uppercase
<0> Drakas: how is that making a difference?
<4> Drakas: Because nobody wants to run a Windows server?
<3> yereth: try it :]
<3> lol Frixon
<0> Frixon: I normally do that.. part of the query is generated.. but that normally doesn't make a difference
<3> wi 2k3 is the beast :]
<3> Win*
<3> 14-Apr-2006 08:32 << deleted?:)
<3> oh nvm
<0> Frixon: seriously, case doesn't make a difference
<3> yereth: try it out :}]
<0> I did
<3> yereth: case does make a difference
<3> it helps you to separate things out
<4> yereth: MySQL keywords are to be written uppercase.
<1> yereth: it is easier to read
<0> yes I get that.. so I changed that now
<0> it doesn't change anything in the error I get
<3> SELECT `one`, `two` as `three` FROM `mytable` WHERE `something`='Text' LIMIT 5;
<4> Did you remove the space as Drakas told you?
<3> this is much easier
<2> ./configure --with-mysql --with-apxs=/www/bin/apxs
<2> drakas ?
<3> (add a space, Frixon
<4> Erm...yes
<3> Alija_: /
<3> did you uninstall php5?
<2> no
<4> Dragnslcr: Why do you escape all those identifiers?
<3> uninstall it
<1> the `something` shouldn't be quoted with ` iianm
<0> Frixon: which space anyway?
<0> I copied what he pasted
<3> Alija_: if you know hwo to set build flags on freebsd, do it that way
<3> but im refering you to build from source as i don't know how to use freebsd's ports
<3> you can ask in #freebsd on how to "destroy" the --disable-0all for php 5.1.2
<4> yereth: And the error is?
<6> edit the Makefile
<6> in /usr/ports/lang/php5
<0> Frixon: #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 'SELECT topaanbod_mail . id FROM topaanbod_mail LEFT JOIN vast
<3> ok
<4> yereth: topaanbod_mail . id
<3> lol
<4> Does that look correct to you?
<6> but actually, thats not what oyu want. all php extensions have their own port in freebsd
<0> Frixon: the space is added in the error message
<3> choongii: sessions is not an extension as well as regex
<6> first install lang/php5, which will build the apache moduel for you if it detects apxs, then if you want e.g. GD, build /usr/ports/graphics/gd
<6> it is on freebsd
<1> i was mistaken
<6> ./usr/ports/www/php5-session
<6> and /usr/ports/www/somethingIdontremember/php5-pcre
<4> yereth: Post your query as it is now
<0> Frixon: somehow phpmyadmin adds it to the error message or something
<6> that gd I mentioned a few lines up should be php5-gd ofcourse
<0> Frixon: http://pastebin.com/659234
<4> Which version of MySQL?
<3> yereth: subqueries only >4.1
<0> Drakas: ow darn it
<0> seriously?
<4> Yes
<3> yes
<0> crap
<4> That's why I asked for your MySQL version :)
<3> :))
<3> it has no nuts
<0> It's female?
<4> yereth: Install MySQL <= 5.x
Return to
#php
or
Go to some related
logs:
hostname cmd
xorg viewsonic 15
dpkg fixmbr
#physics
bcm44xx
automatrix for dapper
#postfix
#mysql
Gtk-WARNING **: cannot open display: + iscan
convert wma unbuntu
|
|