|
Ocena wątku:
- 1 głosów - średnia: 5
- 1
- 2
- 3
- 4
- 5
|
[mysql] problem z połączeniem po przeniesieniu forum
|
Liczba postów: 7
Liczba wątków: 3
Dołączył: 04-05-2009
Reputacja:
0
04-05-2009, 19:22
(Ten post był ostatnio modyfikowany: 05-05-2009, 14:51 przez Marcin.)
13:36:26
Witam i Prosze o Pomoc !
Chcialem przenisc forum na inny hosting i po wgraniu bazy danych na nowy hosting mam taki blad :
Kod: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'calik_as'@'localhost' (using password: YES) in /home/accounts_c/calik/public_html/db/mysql4.php on line 48
phpBB by Przemo : Critical Error
Could not connect to the database.
Access denied for user 'calik_as'@'localhost' (using password: YES)
Probowalem juz wgrywac to na roznych hostingach i dalej ten sam blad..
Juz sam niewiem co moze byc tego przyczyna wiec prosze o pomoc
adres forum na jakim wystepuje blad to about:www.skilowniaubota.pl
Liczba postów: 938
Liczba wątków: 22
Dołączył: 21-01-2009
Reputacja:
23
Z komunikatu wynika że podałeś złe dane do połączenia, zobacz nazwę bazy danych. Najlepiej podaj tą linijkę 48 z mysql14.php
Liczba postów: 193
Liczba wątków: 18
Dołączył: 26-12-2008
Reputacja:
2
proponuje nadawać adekwatny temat do zawartości !!
Liczba postów: 938
Liczba wątków: 22
Dołączył: 21-01-2009
Reputacja:
23
Możesz tak gadac do każdego jsmp, ja po setnym takim tytule przestałem zwracac uwagę autorom. Bo tym problemem powinni się zając moderatorzy, jednak oni widoczni są tylko na stronie składu forum...
Liczba postów: 193
Liczba wątków: 18
Dołączył: 26-12-2008
Reputacja:
2
eh, też to zauważyłem... 
Liczba postów: 7
Liczba wątków: 3
Dołączył: 04-05-2009
Reputacja:
0
04-05-2009, 20:51
(Ten post był ostatnio modyfikowany: 04-05-2009, 21:04 przez eKiLLeR.)
Zawartość Pliku mysql14.php
Kod: <?php
/***************************************************************************
* mysql4.php
* -------------------
* begin : Saturday, Feb 13, 2001
* copyright : (C) 2001 The phpBB Group
* email : supportphpbb.com
*
* $Id: mysql4.php,v 1.5.2.1 2005/09/18 16:17:20 acydburn Exp $
*
***************************************************************************/
/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
***************************************************************************/
if(!defined("SQL_LAYER"))
{
define("SQL_LAYER","mysql4");
class sql_db
{
var $db_connect_id;
var $query_result;
var $row = array();
var $rowset = array();
var $num_queries = 0;
var $in_transaction = 0;
//
// Constructor
//
function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency = true)
{
$this->persistency = $persistency;
$this->user = $sqluser;
$this->password = $sqlpassword;
$this->server = $sqlserver;
$this->dbname = $database;
$this->db_connect_id = ($this->persistency) ? mysql_pconnect($this->server, $this->user, $this->password) : mysql_connect($this->server, $this->user, $this->password);
if( $this->db_connect_id )
{
if( $database != "" )
{
$this->dbname = $database;
$dbselect = mysql_select_db($this->dbname);
mysql_query('SET NAMES latin2 COLLATE latin2_general_ci', $this->db_connect_id);
if( !$dbselect )
{
mysql_close($this->db_connect_id);
$this->db_connect_id = $dbselect;
}
}
return $this->db_connect_id;
}
else
{
return false;
}
}
//
// Other base methods
//
function sql_close()
{
if( $this->db_connect_id )
{
//
// Commit any remaining transactions
//
if( $this->in_transaction )
{
mysql_query("COMMIT", $this->db_connect_id);
}
return mysql_close($this->db_connect_id);
}
else
{
return false;
}
}
//
// Base query method
//
function sql_query($query = "", $transaction = FALSE)
{
global $show_queries;
if ( $show_queries )
{
global $queries;
}
//
// Remove any pre-existing queries
//
unset($this->query_result);
if( $query != "" )
{
if ( $show_queries )
{
$queries .= $query . '<hr>';
}
$this->num_queries++;
if( $transaction == BEGIN_TRANSACTION && !$this->in_transaction )
{
$result = mysql_query("BEGIN", $this->db_connect_id);
if(!$result)
{
return false;
}
$this->in_transaction = TRUE;
}
$this->query_result = mysql_query($query, $this->db_connect_id);
}
else
{
if( $transaction == END_TRANSACTION && $this->in_transaction )
{
$result = mysql_query("COMMIT", $this->db_connect_id);
}
}
if( $this->query_result )
{
unset($this->row[$this->query_result]);
unset($this->rowset[$this->query_result]);
if( $transaction == END_TRANSACTION && $this->in_transaction )
{
$this->in_transaction = FALSE;
if ( !mysql_query("COMMIT", $this->db_connect_id) )
{
mysql_query("ROLLBACK", $this->db_connect_id);
return false;
}
}
return $this->query_result;
}
else
{
if( $this->in_transaction )
{
mysql_query("ROLLBACK", $this->db_connect_id);
$this->in_transaction = FALSE;
}
return false;
}
}
//
// Other query methods
//
function sql_numrows($query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}
return ( $query_id ) ? mysql_num_rows($query_id) : false;
}
function sql_affectedrows()
{
return ( $this->db_connect_id ) ? mysql_affected_rows($this->db_connect_id) : false;
}
function sql_numfields($query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}
return ( $query_id ) ? mysql_num_fields($query_id) : false;
}
function sql_fieldname($offset, $query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}
return ( $query_id ) ? mysql_field_name($query_id, $offset) : false;
}
function sql_fieldtype($offset, $query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}
return ( $query_id ) ? mysql_field_type($query_id, $offset) : false;
}
function sql_fetchrow($query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}
if( $query_id )
{
$this->row[$query_id] = @mysql_fetch_array($query_id, MYSQL_ASSOC);
return $this->row[$query_id];
}
else
{
return false;
}
}
function sql_fetchrowset($query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}
if( $query_id )
{
unset($this->rowset[$query_id]);
unset($this->row[$query_id]);
while($this->rowset[$query_id] = @mysql_fetch_array($query_id, MYSQL_ASSOC))
{
$result[] = $this->rowset[$query_id];
}
return $result;
}
else
{
return false;
}
}
function sql_fetchfield($field, $rownum = -1, $query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}
if( $query_id )
{
if( $rownum > -1 )
{
$result = mysql_result($query_id, $rownum, $field);
}
else
{
if( empty($this->row[$query_id]) && empty($this->rowset[$query_id]) )
{
if( $this->sql_fetchrow() )
{
$result = $this->row[$query_id][$field];
}
}
else
{
if( $this->rowset[$query_id] )
{
$result = $this->rowset[$query_id][0][$field];
}
else if( $this->row[$query_id] )
{
$result = $this->row[$query_id][$field];
}
}
}
return $result;
}
else
{
return false;
}
}
function sql_rowseek($rownum, $query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}
return ( $query_id ) ? mysql_data_seek($query_id, $rownum) : false;
}
function sql_nextid()
{
return ( $this->db_connect_id ) ? mysql_insert_id($this->db_connect_id) : false;
}
function sql_freeresult($query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}
if ( $query_id )
{
unset($this->row[$query_id]);
unset($this->rowset[$query_id]);
@ mysql_free_result($query_id);
return true;
}
else
{
return false;
}
}
function sql_error()
{
$result['message'] = @mysql_error($this->db_connect_id);
$result['code'] = @mysql_errno($this->db_connect_id);
return $result;
}
} // class sql_db
} // if ... define
?>
Zawartość Pliku mysql.php
Kod: <?php
/***************************************************************************
* mysql.php
* -------------------
* begin : Saturday, Feb 13, 2001
* copyright : (C) 2001 The phpBB Group
* email : [email protected]
*
* $Id: mysql.php,v 1.16.2.1 2005/09/18 16:17:20 acydburn Exp $
*
***************************************************************************/
/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
***************************************************************************/
if(!defined("SQL_LAYER"))
{
define("SQL_LAYER","mysql");
class sql_db
{
var $db_connect_id;
var $query_result;
var $row = array();
var $rowset = array();
var $num_queries = 0;
//
// Constructor
//
function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency = true)
{
$this->persistency = $persistency;
$this->user = $sqluser;
$this->password = $sqlpassword;
$this->server = $sqlserver;
$this->dbname = $database;
if($this->persistency)
{
$this->db_connect_id = @mysql_pconnect($this->server, $this->user, $this->password);
}
else
{
$this->db_connect_id = @mysql_connect($this->server, $this->user, $this->password);
}
if($this->db_connect_id)
{
if($database != "")
{
$this->dbname = $database;
$dbselect = @mysql_select_db($this->dbname);
if(!$dbselect)
{
@mysql_close($this->db_connect_id);
$this->db_connect_id = $dbselect;
}
}
return $this->db_connect_id;
}
else
{
return false;
}
}
//
// Other base methods
//
function sql_close()
{
if($this->db_connect_id)
{
if($this->query_result)
{
@mysql_free_result($this->query_result);
}
$result = @mysql_close($this->db_connect_id);
return $result;
}
else
{
return false;
}
}
//
// Base query method
//
function sql_query($query = "", $transaction = FALSE)
{
global $show_queries;
if ( $show_queries )
{
global $queries;
}
// Remove any pre-existing queries
unset($this->query_result);
if($query != "")
{
if ( $show_queries )
{
$queries .= $query . '<hr>';
}
$this->num_queries++;
$this->query_result = @mysql_query($query, $this->db_connect_id);
}
if($this->query_result)
{
unset($this->row[$this->query_result]);
unset($this->rowset[$this->query_result]);
return $this->query_result;
}
else
{
return ( $transaction == END_TRANSACTION ) ? true : false;
}
}
//
// Other query methods
//
function sql_numrows($query_id = 0)
{
if(!$query_id)
{
$query_id = $this->query_result;
}
if($query_id)
{
$result = @mysql_num_rows($query_id);
return $result;
}
else
{
return false;
}
}
function sql_affectedrows()
{
if($this->db_connect_id)
{
$result = @mysql_affected_rows($this->db_connect_id);
return $result;
}
else
{
return false;
}
}
function sql_numfields($query_id = 0)
{
if(!$query_id)
{
$query_id = $this->query_result;
}
if($query_id)
{
$result = @mysql_num_fields($query_id);
return $result;
}
else
{
return false;
}
}
function sql_fieldname($offset, $query_id = 0)
{
if(!$query_id)
{
$query_id = $this->query_result;
}
if($query_id)
{
$result = @mysql_field_name($query_id, $offset);
return $result;
}
else
{
return false;
}
}
function sql_fieldtype($offset, $query_id = 0)
{
if(!$query_id)
{
$query_id = $this->query_result;
}
if($query_id)
{
$result = @mysql_field_type($query_id, $offset);
return $result;
}
else
{
return false;
}
}
function sql_fetchrow($query_id = 0)
{
if(!$query_id)
{
$query_id = $this->query_result;
}
if($query_id)
{
$this->row[$query_id] = @mysql_fetch_array($query_id);
return $this->row[$query_id];
}
else
{
return false;
}
}
function sql_fetchrowset($query_id = 0)
{
if(!$query_id)
{
$query_id = $this->query_result;
}
if($query_id)
{
unset($this->rowset[$query_id]);
unset($this->row[$query_id]);
while($this->rowset[$query_id] = @mysql_fetch_array($query_id))
{
$result[] = $this->rowset[$query_id];
}
return $result;
}
else
{
return false;
}
}
function sql_fetchfield($field, $rownum = -1, $query_id = 0)
{
if(!$query_id)
{
$query_id = $this->query_result;
}
if($query_id)
{
if($rownum > -1)
{
$result = @mysql_result($query_id, $rownum, $field);
}
else
{
if(empty($this->row[$query_id]) && empty($this->rowset[$query_id]))
{
if($this->sql_fetchrow())
{
$result = $this->row[$query_id][$field];
}
}
else
{
if($this->rowset[$query_id])
{
$result = $this->rowset[$query_id][0][$field];
}
else if($this->row[$query_id])
{
$result = $this->row[$query_id][$field];
}
}
}
return $result;
}
else
{
return false;
}
}
function sql_rowseek($rownum, $query_id = 0){
if(!$query_id)
{
$query_id = $this->query_result;
}
if($query_id)
{
$result = @mysql_data_seek($query_id, $rownum);
return $result;
}
else
{
return false;
}
}
function sql_nextid(){
if($this->db_connect_id)
{
$result = @mysql_insert_id($this->db_connect_id);
return $result;
}
else
{
return false;
}
}
function sql_freeresult($query_id = 0){
if(!$query_id)
{
$query_id = $this->query_result;
}
if ( $query_id )
{
unset($this->row[$query_id]);
unset($this->rowset[$query_id]);
@mysql_free_result($query_id);
return true;
}
else
{
return false;
}
}
function sql_error($query_id = 0)
{
$result["message"] = @mysql_error($this->db_connect_id);
$result["code"] = @mysql_errno($this->db_connect_id);
return $result;
}
} // class sql_db
} // if ... define
?>
Liczba postów: 88
Liczba wątków: 8
Dołączył: 08-04-2009
Reputacja:
1
Na każdym hostingu masz inny host (no prawie) username, bazę i hasło. W tym przypadku zmień nazwę użytkownika (username) na adwekantną do nowego hostingu. Jaki hosting?
Liczba postów: 7
Liczba wątków: 3
Dołączył: 04-05-2009
Reputacja:
0
04-05-2009, 21:43
(Ten post był ostatnio modyfikowany: 04-05-2009, 22:32 przez eKiLLeR.)
xaa.pl
a teraz koleg abaze zrobil i nowy blad tamten znikł co moze zonaczac :
Kod: Parse error: syntax error, unexpected '<' in /home/calik/public_html/index.php on line 67
po wgraniu orginalnego index/php pojawil sie
Kod: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'calik_as'@'localhost' (using password: YES) in /home/calik/public_html/db/mysql4.php on line 48
phpBB by Przemo : Critical Error
Could not connect to the database.
Access denied for user 'calik_as'@'localhost' (using password: YES)
???
Liczba postów: 88
Liczba wątków: 8
Dołączył: 08-04-2009
Reputacja:
1
Jedna z danych do bazy jest zła.
Liczba postów: 7
Liczba wątków: 3
Dołączył: 04-05-2009
Reputacja:
0
tylko ktora dac ci kod czy co ?
|
| Podobne wątki… |
| Wątek: |
Autor |
Odpowiedzi: |
Wyświetleń: |
Ostatni post |
| |
Jak sprawdzić czy adres www znajduje sie w bazie mysql? |
jarekcda |
8 |
9,044 |
13-05-2017, 01:02
Ostatni post: miketodson255
|
| |
Optymalizacja MySQL-a |
tomek_00 |
1 |
3,932 |
01-09-2013, 13:31
Ostatni post: hieroshima
|
| |
[MySQL] Struktura bazy dla słownika |
msx83 |
2 |
3,931 |
24-08-2013, 16:26
Ostatni post: msx83
|
| |
Komunikacja PHP z MySQL na serwerze |
pawstrze |
5 |
6,457 |
16-07-2013, 15:58
Ostatni post: Engine
|
| |
[MySQL] wyszukiwarka problem |
darlowiak |
3 |
3,564 |
13-06-2013, 12:58
Ostatni post: darlowiak
|
Użytkownicy przeglądający ten wątek: 1 gości
|
|
|
Sponsorzy i przyjaciele
|
|
|
![[Obrazek: 2guxq1i.gif]](http://img713.imageshack.us/img713/1035/2guxq1i.gif)
