IMxSOxCOOL Posted May 21, 2014 Share Posted May 21, 2014 Every time i try to fix this i keep getting this Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[28000] [1045] Access denied for user 'asdasd'@'localhost' (using password: YES)' in /home/u345945996/public_html/includes/db.php:7 Stack trace: #0 /home/u345945996/public_html/includes/db.php(7): PDO->__construct('mysql:host=loca...', 'asdasd', 'nasdas') #1 /home/u345945996/public_html/index.php(3): require_once('/home/u34594599...') #2 {main} thrown in /home/u345945996/public_html/includes/db.php on line 7 Can someone help me fix this??? Link to comment https://forums.phpfreaks.com/topic/288640-fatal-error/ Share on other sites More sharing options...
Jacques1 Posted May 21, 2014 Share Posted May 21, 2014 You have a database user called “asdasd” with the password “nasdas”? Link to comment https://forums.phpfreaks.com/topic/288640-fatal-error/#findComment-1480244 Share on other sites More sharing options...
bsmither Posted May 21, 2014 Share Posted May 21, 2014 Usually, the message:Access denied for user 'asdasd'@'localhost' (using password: YES)means that, even though a password is being supplied, the problem is...* the username is not recognized by the database server* the password is not recognized by the database server* the database being connected to does not have permission to let this user access it as per the database server* the database server has been told to only allow this user access from a particular computer, other than localhost Link to comment https://forums.phpfreaks.com/topic/288640-fatal-error/#findComment-1480245 Share on other sites More sharing options...
IMxSOxCOOL Posted May 21, 2014 Author Share Posted May 21, 2014 ok i fixed that now i get this error Parse error: syntax error, unexpected '[' in /home/u345945996/public_html/inc/classes/resolvers/skype.class.php on line 14 heres what i have in skype.class.php <?php class SkypeResolver { function __construct($db) { $this->db = new DB($db); } function get_ip($username) { $str = $this->skypeurl(); $str .= $username; $output = file_get_contents($str); return $output; } function skypeurl() { return $this->db->fetch_array($this->db->query("SELECT * FROM `settings` WHERE `ident`='skype-api-url'"))['val']; } } ?> Link to comment https://forums.phpfreaks.com/topic/288640-fatal-error/#findComment-1480361 Share on other sites More sharing options...
Jacques1 Posted May 21, 2014 Share Posted May 21, 2014 You can't apply the bracket syntax to function call expressions unless you have PHP 5.4 or greater (obviously you don't). This doesn't look right, anyway. But I can't tell you without seeing your DB class. Link to comment https://forums.phpfreaks.com/topic/288640-fatal-error/#findComment-1480362 Share on other sites More sharing options...
boompa Posted May 21, 2014 Share Posted May 21, 2014 $this->db->fetch_array($this->db->query("SELECT * FROM `settings` WHERE `ident`='skype-api-url'")) This construct sucks anyway, because what if the query fails? Link to comment https://forums.phpfreaks.com/topic/288640-fatal-error/#findComment-1480363 Share on other sites More sharing options...
IMxSOxCOOL Posted May 21, 2014 Author Share Posted May 21, 2014 here is the db.class.php <?php class DB { function __construct($db) { $this->error = new Error(); $this->mysqli = new mysqli($db['host'], $db['user'], $db['pass'], $db['name']); if($this->mysqli->connect_error) { $this->error->connect_error(); } } function query($i) { return $this->mysqli->query($i); } function fetch_array($i) { return $i->fetch_array(MYSQLI_ASSOC); } function num($i) { return $i->num_rows; } } ?> Link to comment https://forums.phpfreaks.com/topic/288640-fatal-error/#findComment-1480369 Share on other sites More sharing options...
IMxSOxCOOL Posted May 21, 2014 Author Share Posted May 21, 2014 ok i fixed that now i get this error Parse error: syntax error, unexpected '[' in /home/u345945996/public_html/inc/classes/resolvers/skype.class.php on line 14 heres what i have in skype.class.php <?php class SkypeResolver { function __construct($db) { $this->db = new DB($db); } function get_ip($username) { $str = $this->skypeurl(); $str .= $username; $output = file_get_contents($str); return $output; } function skypeurl() { return $this->db->fetch_array($this->db->query("SELECT * FROM `settings` WHERE `ident`='skype-api-url'"))['val']; } } ?> Ok i found my mistake in that one i added a little too much in to it. now once i fixed it i got this one. Deprecated: Function ereg_replace() is deprecated in /home/u345945996/public_html/inc/classes/resolvers/cloudflare.api.php(1) : eval()'d code on line 1 cloudflare.api.php <?php $_F=__FILE__;$_X='Pz48P3BocA0KLy81cnIycl9yNXAycnQ0bmcoMCk7DQoNCg0KY2wxc3MgQ2wyM2RmbDFyNUFQSSB7DQoJcHI0djF0NSBmM25jdDQybiAxbGxfY2ZfNHAoJHIxbmc1KQ0KCXsNCgkJJHIxbmc1XzFyciA9IDFycjF5KCk7DQoJCQk0ZigkcjFuZzUgPT0gIjY3byIpIA0KCQkJew0KCQkJCSRzID0gdTg7DQoJCQkJJDUgPSBlbzsNCgkJCQlmMnIoJHM9dTg7ICRzIDwgJDU7KQ0KCQkJCQl7DQoJCQkJCQkkcysrOw0KCQkJCQkJJDVhID0gYWlpOw0KCQkJCQkJZjJyKCRzYT0wOyAkc2EgPCAkNWE7KQ0KCQkJCQkJCXsNCgkJCQkJCQkJJHNhKys7DQoJCQkJCQkJCTFycjF5X3Azc2goJHIxbmc1XzFyciwgIjY3by5hdWkuIiAuJHMuICIuIiAuJHNhKTsNCgkJCQkJCQkJDQoJCQkJCQkJfQ0KCQkJCQl9DQoJCQkJfQ0KCQkJCQ0KCQkJNGYoJHIxbmc1ID09ICI2OTkiKSANCgkJCXsNCgkJCQkkcyA9IDZhODsNCgkJCQkkNSA9IDZvaTsNCgkJCQlmMnIoJHM9NmE4OyAkcyA8ICQ1OykNCgkJCQkJew0KCQkJCQkJJHMrKzsNCgkJCQkJCSQ1YSA9IGFpaTsNCgkJCQkJCWYycigkc2E9MDsgJHNhIDwgJDVhOykNCgkJCQkJCQl7DQoJCQkJCQkJCSRzYSsrOw0KCQkJCQkJCQkxcnIxeV9wM3NoKCRyMW5nNV8xcnIsICI2OTkuYTcuIiAuJHMuICIuIiAuJHNhKTsNCgkJCQkJCQkJDQoJCQkJCQkJfQ0KCQkJCQl9DQoJCQkJfQ0KCQkJNGYoJHIxbmc1ID09ICI2dTYiKSANCgkJCXsNCgkJCQkkcyA9IGV1Ow0KCQkJCSQ1ID0gNmE3Ow0KCQkJCWYycigkcz1ldTsgJHMgPCAkNTspDQoJCQkJCXsNCgkJCQkJCSRzKys7DQoJCQkJCQkkNWEgPSBhaWk7DQoJCQkJCQlmMnIoJHNhPTA7ICRzYSA8ICQ1YTspDQoJCQkJCQkJew0KCQkJCQkJCQkkc2ErKzsNCgkJCQkJCQkJMXJyMXlfcDNzaCgkcjFuZzVfMXJyLCAiNnU2LjYwNi4iIC4kcy4gIi4iIC4kc2EpOw0KCQkJCQkJCQkNCgkJCQkJCQl9DQoJCQkJCX0NCgkJCQl9DQoJCQk0ZigkcjFuZzUgPT0gIjYwOCIpIA0KCQkJew0KCQkJCSRzID0gNjlhOw0KCQkJCSQ1ID0gYWlpOw0KCQkJCWYycigkcz02OWE7ICRzIDwgJDU7KQ0KCQkJCQl7DQoJCQkJCQkkcysrOw0KCQkJCQkJJDVhID0gYWlpOw0KCQkJCQkJZjJyKCRzYT0wOyAkc2EgPCAkNWE7KQ0KCQkJCQkJCXsNCgkJCQkJCQkJJHNhKys7DQoJCQkJCQkJCTFycjF5X3Azc2goJHIxbmc1XzFyciwgIjYwOC42ZWEuIiAuJHMuICIuIiAuJHNhKTsNCgkJCQkJCQkJDQoJCQkJCQkJfQ0KCQkJCQl9DQoJCQkJfQ0KCQkJNGYoJHIxbmc1ID09ICI2OTAiKSANCgkJCXsNCgkJCQkkcyA9IGF1MDsNCgkJCQkkNSA9IGFpaTsNCgkJCQlmMnIoJHM9YXUwOyAkcyA8ICQ1OykNCgkJCQkJew0KCQkJCQkJJHMrKzsNCgkJCQkJCSQ1YSA9IGFpaTsNCgkJCQkJCWYycigkc2E9MDsgJHNhIDwgJDVhOykNCgkJCQkJCQl7DQoJCQkJCQkJCSRzYSsrOw0KCQkJCQkJCQkxcnIxeV9wM3NoKCRyMW5nNV8xcnIsICI2OTAuOW8uYXUwLiIgLiRzLiAiLiIgLiRzYSk7DQoJCQkJCQkJCQ0KCQkJCQkJCX0NCgkJCQkJfQ0KCQkJCX0NCgkJCQkNCgkJCQ0KCQlyNXQzcm4gJHIxbmc1XzFycjsNCgl9DQoJcDNibDRjIGYzbmN0NDJuIHI1czJsdjUoJHQxcmc1dCwgJGw0ZCwgJDE0cCkgew0KCQkkNHAgPSAkdGg0cy0+ZzV0XzRwKCR0MXJnNXQpOw0KCQlkNDUoJDRwKTsNCgl9DQoJDQoJcHI0djF0NSBmM25jdDQybiBnNXRfNHAoJHQxcmc1dCkgew0KCQkkczVydjVyID0gZzV0X2g1MWQ1cnMoImh0dHA6Ly8iIC4kdDFyZzV0LCA2KTsNCgkJCQkJCTRmKChzdHI0bmcpJHM1cnY1clsnUzVydjVyJ10gPT0gIkFycjF5IikNCgkJCQkJCQl7DQoJCQkJCQkJCSR3NWJfdHlwNSA9ICRzNXJ2NXJbIlM1cnY1ciJdWzBdOw0KCQkJCQkJCX0NCgkJCQkJCQk1bHM1DQoJCQkJCQkJew0KCQkJCQkJCQkkdzViX3R5cDUgPSAkczVydjVyWydTNXJ2NXInXTsNCgkJCQkJCQl9DQoJCQkJCQkkczVydjVyX3R5cDVzID0gMXJyMXkoIkw0dDVTcDU1ZCIsICJjbDIzZGZsMXI1LW5nNG54IiwgIkFwMWNoNSIsICJNNGNyMnMyZnQvSUlTIiwgIm5nNG54IiwgImw0Z2h0dHBkIik7DQoJCQkJCQkNCgkJCQkJCQkJJHc1YnQgPSAiY2wyM2RmbDFyNSI7DQoJCQkJCQkJCSR0MXJnNXQgPSBzdHJfcjVwbDFjNSgiaHR0cDovLyIsICIiLCAkdDFyZzV0KTsNCgkJCQkJCQkJJHQxcmc1dCA9IHN0cl9yNXBsMWM1KCJ3d3cuIiwgIiIsICR0MXJnNXQpOw0KCQkJCQkJCQkkdDFyZzV0ID0gc3RyX3I1cGwxYzUoIi8iLCAiIiwgJHQxcmc1dCk7DQoJCQkJCQkJCSRuMm5fNHAgPSAxcnIxeSgpOw0KCQkJCQkJCQkkcjUxbF80cCA9IDFycjF5KCk7DQoJCQkJCQkJCSRkMm0xNG5zID0gMXJyMXkoJ3c0ZjQuJywgJ2tsMngyLicsICduczYuJywgJ25zYS4nLCAnZG5zNi4nLCAnZG5zYS4nLCAnY3AxbjVsLicsICdmdHAuJywgJ20xNGwuJywgJ3c1Ym0xNGwuJywgJ2Q0cjVjdC4nLCAnZDRyNWN0LWMybm41Y3QuJywgJ3I1YzJyZC4nLCAnc3NsLicsICdkbnMuJywgJ2g1bHAuJywgJ2JsMmcuJywgJ2YycjNtLicsICdzNWMzcjUuJywgJ2gybTUuJywgJzFkbTRuLicpOw0KCQkJCQkJCQlmMnI1MWNoKCRkMm0xNG5zIDFzICR2KQ0KCQkJCQkJCQkJew0KCQkJCQkJCQkJCSRyX2gyc3QgPSAkdi4gJHQxcmc1dDsNCgkJCQkJCQkJCQkkcl80cCA9IGc1dGgyc3RieW4xbTUoJHJfaDJzdCk7DQoJCQkJCQkJCQkJNGYoJHJfNHAgIT0gJHJfaDJzdCkgew0KCQkJCQkJCQkJCVN3NHRjaCgkcl80cCkNCgkJCQkJCQkJCQkJew0KCQkJCQkJCQkJCQkJYzFzNSAiZTkuNmUuNnVvLjY2MCI6DQoJCQkJCQkJCQkJCQkJMXJyMXlfcDNzaCgkbjJuXzRwLCAkcl9oMnN0KTsNCgkJCQkJCQkJCQkJCQlicjUxazsNCgkJCQkJCQkJCQkJCWMxczUgZm5tMXRjaCgiYTB1LjlvLmF1MC4qIiwgJHJfNHApOg0KCQkJCQkJCQkJCQkJCTFycjF5X3Azc2goJG4ybl80cCwgJHJfaDJzdCk7DQoJCQkJCQkJCQkJCQkJYnI1MWs7DQoJCQkJCQkJCQkJCQljMXM1IGZubTF0Y2goImEwdS45by42NzcuKiIsICRyXzRwKToNCgkJCQkJCQkJCQkJCQkxcnIxeV9wM3NoKCRuMm5fNHAsICRyX2gyc3QpOw0KCQkJCQkJCQkJCQkJCWJyNTFrOw0KCQkJCQkJCQkJCQkJYzFzNSBmbm0xdGNoKCI2MG8uYWEuYTAwLioiLCAkcl80cCk6DQoJCQkJCQkJCQkJCQkJMXJyMXlfcDNzaCgkbjJuXzRwLCAkcl9oMnN0KTsNCgkJCQkJCQkJCQkJCQlicjUxazsNCgkJCQkJCQkJCQkJCWMxczUgZm5tMXRjaCgiNjBvLmFhLmEwNi4qIiwgJHJfNHApOg0KCQkJCQkJCQkJCQkJCTFycjF5X3Azc2goJG4ybl80cCwgJHJfaDJzdCk7DQoJCQkJCQkJCQkJCQkJYnI1MWs7DQoJCQkJCQkJCQkJCQljMXM1IGZubTF0Y2goIjYwby5hYS5hMGEuKiIsICRyXzRwKToNCgkJCQkJCQkJCQkJCQkxcnIxeV9wM3NoKCRuMm5fNHAsICRyX2gyc3QpOw0KCQkJCQkJCQkJCQkJCWJyNTFrOw0KCQkJCQkJCQkJCQkJYzFzNSBmbm0xdGNoKCI2MG8uYWEuYTBvLioiLCAkcl80cCk6DQoJCQkJCQkJCQkJCQkJMXJyMXlfcDNzaCgkbjJuXzRwLCAkcl9oMnN0KTsNCgkJCQkJCQkJCQkJCQlicjUxazsNCgkJCQkJCQkJCQkJCWMxczUgNG5fMXJyMXkoJHJfNHAsICR0aDRzLT4xbGxfY2ZfNHAoIjY5OSIpKToNCgkJCQkJCQkJCQkJCQkxcnIxeV9wM3NoKCRuMm5fNHAsICRyX2gyc3QpOw0KCQkJCQkJCQkJCQkJCWJyNTFrOw0KCQkJCQkJCQkJCQkJYzFzNSA0bl8xcnIxeSgkcl80cCwgJHRoNHMtPjFsbF9jZl80cCgiNjdvIikpOg0KCQkJCQkJCQkJCQkJCTFycjF5X3Azc2goJG4ybl80cCwgJHJfaDJzdCk7DQoJCQkJCQkJCQkJCQkJYnI1MWs7DQoJCQkJCQkJCQkJCQljMXM1IDRuXzFycjF5KCRyXzRwLCAkdGg0cy0+MWxsX2NmXzRwKCI2dTYiKSk6DQoJCQkJCQkJCQkJCQkJMXJyMXlfcDNzaCgkbjJuXzRwLCAkcl9oMnN0KTsNCgkJCQkJCQkJCQkJCQlicjUxazsNCgkJCQkJCQkJCQkJCWMxczUgNG5fMXJyMXkoJHJfNHAsICR0aDRzLT4xbGxfY2ZfNHAoIjYwOCIpKToNCgkJCQkJCQkJCQkJCQkxcnIxeV9wM3NoKCRuMm5fNHAsICRyX2gyc3QpOw0KCQkJCQkJCQkJCQkJCWJyNTFrOw0KCQkJCQkJCQkJCQkJYzFzNSA0bl8xcnIxeSgkcl80cCwgJHRoNHMtPjFsbF9jZl80cCgiNjkwIikpOg0KCQkJCQkJCQkJCQkJCQkxcnIxeV9wM3NoKCRuMm5fNHAsICRyX2gyc3QpOw0KCQkJCQkJCQkJCQkJCWJyNTFrOw0KCQkJCQkJCQkJCQkJDQoJCQkJCQkJCQkJCX0NCgkJCQkJCQkJCQk0Zig0bl8xcnIxeSgkcl9oMnN0LCAkbjJuXzRwKSA9PSBmMWxzNSkNCgkJCQkJCQkJCQkJew0KCQkJCQkJCQkJCQkJMXJyMXlfcDNzaCgkcjUxbF80cCwgJHJfNHApOw0KCQkJCQkJCQkJCQl9DQoJCQkJCQkJCQl9IH0NCgkJNGYoITVtcHR5KCRyNTFsXzRwKSkgew0KCQkJcjV0M3JuIDRtcGwyZDUoIiwgIiwgMXJyMXlfM240cTM1KCRyNTFsXzRwKSk7DQoJCX0gNWxzNSB7DQoJCQlyNXQzcm4gIlVuMWJsNSB0MiByNXMybHY1IElQIjsNCgkJfQ0KCX0NCn0NCj8+';eval(base64_decode('JF9YPWJhc2U2NF9kZWNvZGUoJF9YKTskX1g9c3RydHIoJF9YLCcxMjM0NTZhb3VpZScsJ2FvdWllMTIzNDU2Jyk7JF9SPWVyZWdfcmVwbGFjZSgnX19GSUxFX18nLCInIi4kX0YuIiciLCRfWCk7ZXZhbCgkX1IpOyRfUj0wOyRfWD0wOw=='));?> Link to comment https://forums.phpfreaks.com/topic/288640-fatal-error/#findComment-1480371 Share on other sites More sharing options...
jazzman1 Posted May 21, 2014 Share Posted May 21, 2014 You need to change the call to all ereg_* functions to preg_* instead. http://php.net/manual/en/function.preg-replace.php Link to comment https://forums.phpfreaks.com/topic/288640-fatal-error/#findComment-1480373 Share on other sites More sharing options...
IMxSOxCOOL Posted May 21, 2014 Author Share Posted May 21, 2014 thanks bro for that but now i got this now. Warning: mysqli::mysqli(): (42000/1203): User u345945996_admin already has more than 'max_user_connections' active connections in /home/u345945996/public_html/inc/classes/db.class.php on line 7 MySQLi Connection Error Link to comment https://forums.phpfreaks.com/topic/288640-fatal-error/#findComment-1480374 Share on other sites More sharing options...
jazzman1 Posted May 22, 2014 Share Posted May 22, 2014 http://dev.mysql.com/doc/refman/5.0/en/user-resources.html Link to comment https://forums.phpfreaks.com/topic/288640-fatal-error/#findComment-1480377 Share on other sites More sharing options...
IMxSOxCOOL Posted May 22, 2014 Author Share Posted May 22, 2014 http://dev.mysql.com/doc/refman/5.0/en/user-resources.html i still get the error maybe im looking at it wrong??? Link to comment https://forums.phpfreaks.com/topic/288640-fatal-error/#findComment-1480379 Share on other sites More sharing options...
jazzman1 Posted May 22, 2014 Share Posted May 22, 2014 How many number of times this account can connect to the server within one hour? Link to comment https://forums.phpfreaks.com/topic/288640-fatal-error/#findComment-1480380 Share on other sites More sharing options...
IMxSOxCOOL Posted May 22, 2014 Author Share Posted May 22, 2014 idk how do i check, and is there anyway for me to show you it like by skype or teamviewer??? Link to comment https://forums.phpfreaks.com/topic/288640-fatal-error/#findComment-1480385 Share on other sites More sharing options...
jazzman1 Posted May 22, 2014 Share Posted May 22, 2014 I've stopped using any proprietary sofware like skype and teamviewer many years ago idk how do i check ..... Start, explaining us, why are you using mysqli and pdo libraries at the same time? Or, you fixed the issue from your first post replacing pdo with mysqli? Link to comment https://forums.phpfreaks.com/topic/288640-fatal-error/#findComment-1480386 Share on other sites More sharing options...
IMxSOxCOOL Posted May 22, 2014 Author Share Posted May 22, 2014 I've stopped using any proprietary sofware like skype and teamviewer many years ago Start, explaining us, why are you using mysqli and pdo libraries at the same time? Or, you fixed the issue from your first post replacing pdo with mysqli? i just changed the whole sql Link to comment https://forums.phpfreaks.com/topic/288640-fatal-error/#findComment-1480390 Share on other sites More sharing options...
jazzman1 Posted May 22, 2014 Share Posted May 22, 2014 Make sure you use only one library when dealing with DB server in this project. You also need to create one mysqli object to instantiate only one connection per user, then pass that DB object among all the classes that need to use it. Link to comment https://forums.phpfreaks.com/topic/288640-fatal-error/#findComment-1480424 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.