Hi gang, Trying to generate a CSV file using mySQL and I keep getting this error below. The target folder has full permissions to write (777). I am not certain why this is happening. Any answers? Thanks!
Database_Class error: DATABASE_ERROR: Access denied for user 'teal1dwd_teal'@'localhost' (using password: YES) IN [SELECT u.user_id, u.first_name AS u_first_name, u.last_name AS u_last_name, c.client_id AS c_client_id, c.first_name AS c_first_name, c.middle_name AS c_middle_name, c.last_name AS c_last_name, c.address AS c_address, c.city AS c_city, c.state AS c_state, c.zip AS c_zip, c.dob AS dob_ymd, c.phone_home AS c_phone_home, c.phone_cell AS c_phone_cell, c.phone_work AS c_phone_work, c.email AS c_email, c.other_contacts AS c_other_contacts, count(*) as apt_qty FROM tl_appt apt JOIN tl_clients c on c.client_id = apt.client_id JOIN tl_rooms r on r.room_id = apt.room_id JOIN tl_users u on u.user_id = apt.user_id WHERE apt.time_start between '1388552400' and '1420088399' and r.location_id = '1' GROUP BY u.user_id, c.client_id having count(*) > 1 ORDER BY u.first_name, u.last_name, c.last_name, c.first_name INTO OUTFILE '/tmp/1_2031305738.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"'] Don Wieland d...@pointmade.net http://www.pointmade.net https://www.facebook.com/pointmade.band
