#mysql
12 November 2007
Total 20 pages. You are browsing page 3/20.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
04:21 <****> jmoncayo: into which table
04:21 <****> encrypt is a Triple-DES
04:21 <****> pulpfiction: can you pastebin you query
04:21 <****> fuse_lt: oh yeah been all over that cuz i wrote a sql driver, 16byte vs 41 byte or so
04:21 <****> insert into messages values('0','text','1'); i have a user with userID =1
04:21 <****> kimseong, http://www.simskolanonline.se/demo/test.php
04:21 <****> pulpfiction: the one working as well that gives you wrong result
04:21 <****> yep
04:22 <****> kimseong, www.datazero.net/chico/query.sql
04:22 <****> alnr: password is a double sha-1 hash
04:22 <****>
04:22 <****> it was working before and now that i want to insert a new row it doesnt, all i did was delete all the rows in message, then i did a truncate table messages;
04:23 <****> jmoncayo: your fk is in which table?
04:24 <****> Sorry for bothering you guys, but is there something syntatically incorrect with: Select plugins_replies.id,plugins_replies.title,users.username ?
04:24 <****> in messages
04:24 <****> it tells me users.username doesn't exist, but it does...
04:24 <****> jmoncayo: you are inserting into messages?
04:25 <****> jmoncayo: pastebin the show create table for both table and the insert statement
04:25 <****> fuse_lt: yes. currently i store password() but I was expecting i'd have to change it to encrypt(). basically i need to make a mysql-using application has the same pw as a system account. given a password in hash, not plaintext, form
04:25 <****> oh, stupid mistake
04:26 <****> kimseong, i found the error, stupid phpmyadmin i dont like it but its all i have from my hosting server, i altered the table and it was making messageID the fk
04:26 <****> instead of userID
04:27 <****> pulpfiction: a left join (b join c on b.bb=c.cc) on a.aa=b.b1
04:27 <****> pulpfiction: you put the result of a join into the ( ) then still need the on for the left join
04:28 <****> pulpfiction: too lazy to go through your complicated query
04:28 <****> kimseong, yea that was the problem it works now, i dont know why it was doing that
04:28 <****> ok
04:29 <****> alnr: are you trying to tie in some auth to system passwords, because there is software that currently does that.
04:31 <****> i'm trying to tie an app i wrote, which auths passwords stored in mysql, with a app that authenticates via system account, such as dovecot
04:33 <****> so my task is, a web client transmits a hash representing a pw, and plug that hash into chpasswd -e, as well as my table
04:34 <****> kimseong, nah, didn't work
04:44 <****> ok got a wierd one - i get Access denied with correct password, host and username.. now what?
04:45 <****> Access denied
04:45 <****> Anon696: you need to connect first
04:46 <****> ?
04:46 <****> how do you negate a "Distinct" query?
04:46 <****> sorry
04:46 <****> what is mysql_select() ?
04:46 <****> it's not correct :)
04:46 <****> access denied
04:46 <****> l o l
04:46 <****> exact error message
04:46 <****> from mysql_error
04:46 <****> Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'yourbus5_admin'@'localhost' (using password: YES) in /home/yourbus5/public_html/Install/install.php on line 11
04:46 <****> how do you negate a "Distinct" query? example, i have a database with same name/email and i want to delete them.
04:47 <****> Anon696 - are you sure you have privileges? FLUSH PRIVILEGES;?
04:47 <****> Anon696: wrong password?
04:47 <****> not possible
04:47 <****> triple checked
04:47 <****> how did you check?
04:47 <****> v5: get the MAX(id), store those in a temp able, and delete from tbl where id in (select id from tmp_table)
04:48 <****> thumbs no simpler way?
04:48 <****> i recreated the user 3 times with a short password too at cpanel
04:48 <****> v5: not that I know of.
04:48 <****> thumbs: that delete 1 row for each distinct value :)
04:48 <****> ugh, cpanel.
04:48 <****> Anon696
04:48 <****> v5: you can do a multi-table delete, with a join.
04:48 <****> kimseong: you're right.
04:48 <****> oops
04:48 <****> delete from one table where something matches up
04:48 <****> arjenn how?
04:48 <****> o.o
04:48 <****> sup arjenAU
04:48 <****> v5: seeexamples in the manual
04:48 <****> how can i import a table that i saved.. without overwriting fields/colums/rows that are already there.. only want to import a field/comumn or row that isnt already there
04:49 <****> arjenAU can you show me an example query?
04:49 <****> oh
04:49 <****> what will i be looking for?
04:49 <****> multi table delete
04:49 <****> !m v5 delete
04:49 <****> v5: (DELETE Syntax) : http://dev.mysql.com/doc/mysql/en/delete.html
04:49 <****> v5: delete from a using a,b where a.id=b.id and a = ....
04:49 <****> or whatever
04:51 <****> arjenAU: won't that delete all occurances?
04:52 <****> v5: http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html
04:52 <****> v5: i'd take a look at that page....
04:53 <****> thumbs: depends on how you phrase yur query. you could do a join in a subquery, then use that to join on in the main one as a derived table... plenty of options to do whatever
04:53 <****> fuse_lt: why?
04:53 <****> arjenAU: true enough.
04:55 <****> Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'yourbus5_admin'@'localhost' (using password: YES) in /home/yourbus5/public_html/Install/install.php on line 11
04:55 <****> kimseong: it has some examples of what arjenAU was talking about
04:55 <****> hello, what was the last msg you sent me?
04:55 <****> i got disconnected
04:55 <****> fuse_lt: i see, multi tabel delete
04:55 <****> yep
04:56 <****> Anon696: try without password
04:57 <****> without ?
04:57 <****> why ?
04:57 <****> user must be secured
04:57 <****> Anon696: as a test
04:57 <****> hmm, and what if it works?
04:57 <****> and what if it doesn't work?
04:57 <****> Anon696: select current_user();
04:58 <****> maybe your host isnt permitted?
04:58 <****> requires connection
04:58 <****> its localhost
04:58 <****> Anon696: if no password works, execute that select and check the result
04:59 <****> can someone paste to me the msg intended to me.. that would be like 3 page ups
05:00 <****> v5 check manual for multi table delete
Total 20 pages. You are browsing page 3/20.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last