Aykutbey Yedek Alma

kayyo kullanıyrm

Phpmyadmin'e gir.Databaseini seç

MySQL bağlantı karşılaştırması: latin5_bin
İşlemler 'e tıkla "Karşılaştırma: latin5_bin" yaptıktan sonra aşagıdaki dosyayı mysql ayarlarını yaptıktan sonra sunucuna at tr sorunun kalkar.

<?php
/*
  paFileDB 3.1
  ©2001/2002 PHP Arena
  Written by Todd
  todd@phparena.net
  http://www.phparena.net
  Keep all copyright links on the script visible
  Please read the license included with this script for more information.
*/
 
$db[host] = "**********"; //This is the MySQL server paFileDB will connect to
$db[user] = "**********"; //This is the MySQL user name
$db[pass] = "**********"; //This is the MySQL password
$db[name] = "**********"; //This is the MySQL database paFileDB will put it's information in
/*
This is the MySQL table name prefix. The default is "pafiledb" but if you wish to install multiple copies of
paFileDB on the same database, change this to something like "pafiledb2." All tables in the MySQL database will 
be named "$prefix_files," "$prefix_license" ect, for example: "pafiledb_files" and "pafiledb2_files." That will
allow multple copies of paFileDB on the same database. If you are only installing one copy of paFileDB, you dont 
need to change this. NOTE: Your host does not have this information, it is up to you to set it to what you want.
If you are upgrading from an older version of paFileDB, you MUST keep this as "pafiledb"
*/
$db[prefix] = "pafiledb"; //Table name prefix-explained above.
 
class pafiledb_sql {
 function query($db,$query,$type) {
  $result = mysql_query($query);
  $error = mysql_error();
  global $query_count;
  global $queries_used;
  $query_count++;
  $queries_used .= "<tr><td width=\"100%\" align=\"left\" class=\"datacell\">$query</td></tr>";
  if (!empty($error)) {
   $errno = mysql_errno();
   $this->error("paFileDB was unable to successfully run a MySQL query.<br>MySQL Returned this error: <b>$error</b> Error number: <b>$errno</b><br>The query that caused this error was: <b>$query</b>");
  }
  if ($type == 0) {
   return $result;
  }
  if ($type == 1) {
   $array = mysql_fetch_array($result);
   return $array;
  }
  if ($type == 2) {
   $array = mysql_num_rows($result);
   return $array;
  }
  if ($type == 3) {
   $array = mysql_insert_id();
   return $array;
  }
  @mysql_free_result($result);
 }
 function error($error) {
  die($error);
 }
 function connect($db) {
  if(!($dbc = mysql_connect($db[host],$db[user],$db[pass]))) $this->error("paFileDB was unable to successfully connect to the MySQL database. Check your settings including the MySQL server, username, and password and try again.");
                if(!(mysql_select_db($db[name],$dbc))) $this->error("paFileDB was able to connect to the MySQL database, but was unable to select the database <b>$db[name]</b> to use.");
    mysql_query("SET NAMES 'latin5'");
    mysql_query("SET CHARACTER SET 'latin5'");
    mysql_query("SET COLLATION_CONNECTION = 'latin5_bin'");  
 }
}
$pafiledb_sql = new pafiledb_sql;
?>

sql dosyasını görebilir miyim?

Bence Kayyo kullandığın için bu sorunu yaşıyorsun

Kusura bakma ama büyük olasılık.

  <?php


$db[host] = "**********"; //This is the MySQL server paFileDB will connect to
$db[user] = "**********"; //This is the MySQL user name
$db[pass] = "**********"; //This is the MySQL password
$db[name] = "**********"; //This is the MySQL database paFileDB will put it's information in

$db[prefix] = "pafiledb"; //Table name prefix-explained above.

class pafiledb_sql {
 function query($db,$query,$type) {
  $result = mysql_query($query);
  $error = mysql_error();
  global $query_count;
  global $queries_used;
  $query_count++;
  $queries_used .= "<tr><td width=\"100%\" align=\"left\" class=\"datacell\">$query</td></tr>";
  if (!empty($error)) {
   $errno = mysql_errno();
   $this->error("paFileDB was unable to successfully run a MySQL query.<br>MySQL Returned this error: <b>$error</b> Error number: <b>$errno</b><br>The query that caused this error was: <b>$query</b>");
  }
  if ($type == 0) {
   return $result;
  }
  if ($type == 1) {
   $array = mysql_fetch_array($result);
   return $array;
  }
  if ($type == 2) {
   $array = mysql_num_rows($result);
   return $array;
  }
  if ($type == 3) {
   $array = mysql_insert_id();
   return $array;
  }
  @mysql_free_result($result);
 }
 function error($error) {
  die($error);
 }
 function connect($db) {
  if(!($dbc = mysql_connect($db[host],$db[user],$db[pass]))) $this->error("paFileDB was unable to successfully connect to the MySQL database. Check your settings including the MySQL server, username, and password and try again.");
                if(!(mysql_select_db($db[name],$dbc))) $this->error("paFileDB was able to connect to the MySQL database, but was unable to select the database <b>$db[name]</b> to use.");
    mysql_query("SET NAMES 'latin5'");
    mysql_query("SET CHARACTER SET 'latin5'");
    mysql_query("SET COLLATION_CONNECTION = 'latin5_bin'");  
 }
}
$pafiledb_sql = new pafiledb_sql;
?>

bu şimdiki verdigi hata :
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=3' at line 26
</div>

ERROR

The requested URL could not be retrieved

While trying to retrieve the URL: http://pma2.kayyo.com/read_dump.php
The following error was encountered:

• Zero Sized Reply

Squid did not receive any data for this request.
Your cache administrator is webmaster.

o senın hostundan kaynaklanan bişi sanırım

hata kodu sanırım aynı benim şu konuma bir bak https://www.r10.net/php/25935-kucuk-b...pti-lazim.html tırnak işareti olabilirmi sorun ' `

Coojo sanmıyorum aynı problem deqil