View Single Post
  #17  
Old 24th April 2009, 18:12
SirLancelot SirLancelot is offline
Member
 
Join Date: Jul 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko View Post
When you run the queries manually, you must first select the right database:
Code:
USE database;
(replace database with the database name).
Oops! My apologies.

OK I ran:-

Code:
USE dbispconfig; set autocommit=0; SELECT password FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="steve-ftp"; SELECT uid FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="steve-ftp"; SELECT gid FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="steve-ftp"; SELECT dir FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="steve-ftp"; COMMIT
This is the result:-

Code:
USE dbispconfig;# MySQL returned an empty result set (i.e. zero rows).
SET AUTOCOMMIT =0;# MySQL returned an empty result set (i.e. zero rows).
SELECT PASSWORD FROM ftp_user
WHERE active = 'y'
AND server_id = '1'
AND username = "steve-ftp";# Rows: 1
SELECT uid
FROM ftp_user
WHERE active = 'y'
AND server_id = '1'
AND username = "steve-ftp";# Rows: 1
SELECT gid
FROM ftp_user
WHERE active = 'y'
AND server_id = '1'
AND username = "steve-ftp";# Rows: 1
SELECT dir
FROM ftp_user
WHERE active = 'y'
AND server_id = '1'
AND username = "steve-ftp";# Rows: 1
COMMIT # MySQL returned an empty result set (i.e. zero rows).
Mysql seems to think the database is empty?
But the user and password are there in the table ftp_user.
Reply With Quote