Jump to content
  • 0

change mysql error?


xMrPwN

Question

kalispera pedia, 8elw help se kt ligo para3eno...

exw valei sto site m bars gia total characters, accounts, top pvp ktl ktl

ala an px i database den ine prosvasimi m vgazei ena megalo error k logo tou tropou p ine ta bars sto site, me to error megalwnei k m g@maei to site, to bg kovete sti mesi e3afanizete i bara me ta votes kai ala...

(to error: Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /home/xxx/public_html/config/stats.php on line 8. Coudn't connect to ["IP"] )

 

iparxei kapios tropos, na to kanw na min vgazei olo auto to error ala kati opos "Connection Problem"?

 

Ta scripts p exw einai:

<?php include "config/stats.php" ?>
<?php

mysql_connect($db_serv,$db_user,$db_pass) or die (mysql_error());

mysql_select_db($db_name) or die(mysql_error());

//Total Accounts
$query = ("SELECT * FROM accounts WHERE accesslevel>=0");

$result = mysql_query($query) or die(mysql_error());

$acc2=mysql_numrows($result);


//Total Characters
$query = ("SELECT * FROM characters WHERE accesslevel>=0");

$result = mysql_query($query) or die(mysql_error());

$char2=mysql_numrows($result);

//Clan
$get_config_data="SELECT clan_id FROM clan_data";

$query = ("SELECT clan_id FROM clan_data WHERE clan_id>0");

$result = mysql_query($query) or die(mysql_error());

$clan2=mysql_numrows($result);


mysql_close();

mysql_connect($db_serv,$db_user,$db_pass) or die (mysql_error());

mysql_select_db($db_name) or die(mysql_error());
?>
Total Accounts: <?php print ("$acc2"); ?><br>
Total Characters: <?php print ("$char2"); ?><br>
Total Clans: <?php print ("$clan2"); ?><br>
<a href="top_50_pvp.php" class="mainlevel-nav">Top 50 PvP</a><br>
<a href="top_50_pk.php" class="mainlevel-nav">Top 50 Pk</a><br>

 

0pi0s 3erei as help ligo (:

Link to comment
Share on other sites

11 answers to this question

Recommended Posts

  • 0

nop

 

hmm .. parakseno na sou xalaei olo to site + na exeis tosa errors.

 

Auto den ginetai na to bgaleis oste na sou leei connection failed h den kserw ti alla mporeis na ftiaxeis to problima auto.

 

Prospathw na brw lisi sto problima sou.

Link to comment
Share on other sites

  • 0

re si, den ine provlima, mia xara douleuei :P

apla rotisa an ginete na ala3w to error p 8a dixnei gt megalwnei to "kouti" p to exw mesa, k alazei 8esi se ola ta ipolipa

giati 0tan 3erw gw i database ine offline to site m 8a ginete baxalo...

 

otan ine i db on mia xara ta dixnei ola =P

Link to comment
Share on other sites

  • 0

re si, den ine provlima, mia xara douleuei :P

apla rotisa an ginete na ala3w to error p 8a dixnei gt megalwnei to "kouti" p to exw mesa, k alazei 8esi se ola ta ipolipa

giati 0tan 3erw gw i database ine offline to site m 8a ginete baxalo...

 

Fisiko einai otan i database sou den einai on na ginete baxalo to site , alla giati exo tin ipopsia oti xrhsimopoieis diskw?

 

Anyway , to error den ginetai na to alakseis.Emfanizetai otan h database sou den ginetai na sindethi me to website sou.

Link to comment
Share on other sites

  • 0

den xrisim0piw diskw leme, to site monos to xw ftia3ei (ligo help me to template apo edw) k ta scripts gia top k total ktl ta xa vrei edw se share (tis clan to ekana monos), k to site ine sto 000webhost

 

vasika na to kanw na min dixnei ka8olou error ginete?

k 3erw gw apla na ta dixnei ola midenismena?

Link to comment
Share on other sites

  • 0

den xrisim0piw diskw leme, to site monos to xw ftia3ei (ligo help me to template apo edw) k ta scripts gia top k total ktl ta xa vrei edw se share (tis clan to ekana monos)

 

vasika na to kanw na min dixnei ka8olou error ginete?

k 3erw gw apla na ta dixnei ola midenismena?

 

Den eimai sigouros alla nomizw pos den ginetai.Dioti apo tin stigmi pou den mporei na sindethi to website sou me tin database , bgazei auto to mysql error.

Link to comment
Share on other sites

  • 0

an svisw auto ti pezi na ginei?

 

mysql_connect($db_serv,$db_user,$db_pass) or die (mysql_error());

 

(to ipogramismeno)

 

Auto skeftika kai egw alla pali den eimoun sigouros kai den ithela na se parw sto laimo mou.

 

Dokimase na bgaleis autes tis grammes alla prin to kaneis auto krata ena copy tou php script sou kalou kakou.

Link to comment
Share on other sites

  • 0

parse error, gamato...

 

tecpa thanks, an skefteis kt p borei na work pes...

 

Sou eipa pos den nomizw na ginetai alla anyway an skeftw kati tha sou pw.

 

Locked.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.


×
×
  • Create New...