Eroare php

[Iluminatii]

Care stie de la ce vine aceasta eroare?
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/u843672943/public_html/rpg/includes/servervariables.php on line 13
Linia unde apare eroarea $row = mysql_fetch_array($query);

[catalin25]

Simplu, acel $query nu functioneaza, este FALSE ( boolean, adica TRUE sau FALSE ).Acel $query este o interogare in baza de date intr-un anumit tabel, posibil ca ceva sa fie gresit in sintaxa SQL folosita de tine.

Apropo, vezi ca MySQL este "outdated", foloseste-te de PDO sau MySQLi.

[Iluminatii]

Nu prea inteleg.Ai un id de contact?

[catalin25]

Deci inainte de $row = mysql_fetch_array($query);, probabil ai $query = mysql_query("si aici este sintaxa SQL care probabil nu functioneaza bine");, ai facut bine conexiunea la baza de date? acolo unde ai mysql_connect() si mysql_select_db()

[Iluminatii]

Asta e tot code.Poate tu stii mai bine

Code: Select all

<?php


	define('PASSWORDHASH','BLowE9E&zujN');
	define('BASE_URL',"http://" . $_SERVER['HTTP_HOST'] . "/rpg/");
	define('ROOT_PATH',$_SERVER['DOCUMENT_ROOT'] . "/rpg/");


// ------------------------------------- UCP OPTIONS ---------------------------------------------

// UCP Style
$query = mysql_query("SELECT * FROM `ucp_options` WHERE `option_name` = 'ucp_style'");
$row = mysql_fetch_array($query);
$ucp_style = $row['option_value'];

// Logo
$query = mysql_query("SELECT * FROM `ucp_options` WHERE `option_name` = 'logo'");
$row = mysql_fetch_array($query);
$logo = $row['option_value'];

// Server name
$query = mysql_query("SELECT * FROM `ucp_options` WHERE `option_name` = 'server_name'");
$row = mysql_fetch_array($query);
$servername = $row['option_value'];

// UCP url
$query = mysql_query("SELECT * FROM `ucp_options` WHERE `option_name` = 'ucp_url'");
$row = mysql_fetch_array($query);
$ucpurl = $row['option_value'];

// Website URL
$query = mysql_query("SELECT * FROM `ucp_options` WHERE `option_name` = 'website_url'");
$row = mysql_fetch_array($query);
$websiteurl = $row['option_value'];

// Mail address
$query = mysql_query("SELECT * FROM `ucp_options` WHERE `option_name` = 'mail_address'");
$row = mysql_fetch_array($query);
$mailaddr = $row['option_value'];

// Server IP
$query = mysql_query("SELECT * FROM `ucp_options` WHERE `option_name` = 'server_ip'");
$row = mysql_fetch_array($query);
$serverip = $row['option_value'];

// Forum URL
$query = mysql_query("SELECT * FROM `ucp_options` WHERE `option_name` = 'forum_url'");
$row = mysql_fetch_array($query);
$forumurl = $row['option_value'];

// Shop URL
$query = mysql_query("SELECT * FROM `ucp_options` WHERE `option_name` = 'shop_url'");
$row = mysql_fetch_array($query);
$shopurl = $row['option_value'];

// ------------------------------------- FACTIONS ---------------------------------------------

// Faction 0
$query = mysql_query("SELECT * FROM `ucp_factions` WHERE `faction_id` = '0'");
$row = mysql_fetch_array($query);
$faction0 = $row['faction_name'];
$status_faction0 = $row['faction_status'];

// Faction 1
$query = mysql_query("SELECT * FROM `ucp_factions` WHERE `faction_id` = '1'");
$row = mysql_fetch_array($query);
$faction1 = $row['faction_name'];
$status_faction1 = $row['faction_status'];

// Faction 2
$query = mysql_query("SELECT * FROM `ucp_factions` WHERE `faction_id` = '2'");
$row = mysql_fetch_array($query);
$faction2 = $row['faction_name'];
$status_faction2 = $row['faction_status'];

// Faction 3
$query = mysql_query("SELECT * FROM `ucp_factions` WHERE `faction_id` = '3'");
$row = mysql_fetch_array($query);
$faction3 = $row['faction_name'];
$status_faction3 = $row['faction_status'];

// Faction 4
$query = mysql_query("SELECT * FROM `ucp_factions` WHERE `faction_id` = '4'");
$row = mysql_fetch_array($query);
$faction4 = $row['faction_name'];
$status_faction4 = $row['faction_status'];

// Faction 5
$query = mysql_query("SELECT * FROM `ucp_factions` WHERE `faction_id` = '5'");
$row = mysql_fetch_array($query);
$faction5 = $row['faction_name'];
$status_faction5 = $row['faction_status'];

// Faction 6
$query = mysql_query("SELECT * FROM `ucp_factions` WHERE `faction_id` = '6'");
$row = mysql_fetch_array($query);
$faction6 = $row['faction_name'];
$status_faction6 = $row['faction_status'];

// Faction 7
$query = mysql_query("SELECT * FROM `ucp_factions` WHERE `faction_id` = '7'");
$row = mysql_fetch_array($query);
$faction7 = $row['faction_name'];
$status_faction7 = $row['faction_status'];

// Faction 8
$query = mysql_query("SELECT * FROM `ucp_factions` WHERE `faction_id` = '8'");
$row = mysql_fetch_array($query);
$faction8 = $row['faction_name'];
$status_faction8 = $row['faction_status'];

// Faction 9
$query = mysql_query("SELECT * FROM `ucp_factions` WHERE `faction_id` = '9'");
$row = mysql_fetch_array($query);
$faction9 = $row['faction_name'];
$status_faction9 = $row['faction_status'];

// Faction 10
$query = mysql_query("SELECT * FROM `ucp_factions` WHERE `faction_id` = '10'");
$row = mysql_fetch_array($query);
$faction10 = $row['faction_name'];
$status_faction10 = $row['faction_status'];

// Faction 11
$query = mysql_query("SELECT * FROM `ucp_factions` WHERE `faction_id` = '11'");
$row = mysql_fetch_array($query);
$faction11 = $row['faction_name'];
$status_faction11 = $row['faction_status'];

// Faction 12
$query = mysql_query("SELECT * FROM `ucp_factions` WHERE `faction_id` = '12'");
$row = mysql_fetch_array($query);
$faction12 = $row['faction_name'];
$status_faction12 = $row['faction_status'];

// Faction 13
$query = mysql_query("SELECT * FROM `ucp_factions` WHERE `faction_id` = '13'");
$row = mysql_fetch_array($query);
$faction13 = $row['faction_name'];
$status_faction13 = $row['faction_status'];

// Faction 14
$query = mysql_query("SELECT * FROM `ucp_factions` WHERE `faction_id` = '14'");
$row = mysql_fetch_array($query);
$faction14 = $row['faction_name'];
$status_faction14 = $row['faction_status'];

// Faction 15
$query = mysql_query("SELECT * FROM `ucp_factions` WHERE `faction_id` = '15'");
$row = mysql_fetch_array($query);
$faction15 = $row['faction_name'];
$status_faction15 = $row['faction_status'];

// Faction 16
$query = mysql_query("SELECT * FROM `ucp_factions` WHERE `faction_id` = '16'");
$row = mysql_fetch_array($query);
$faction16 = $row['faction_name'];
$status_faction16 = $row['faction_status'];

// ------------------------------------- JOBS ---------------------------------------------

// job 0
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '0'");
$row = mysql_fetch_array($query);
$job0_value = $row['job_name'];
$job0 = $row['job_name'];
$status_job0 = $row['job_status'];

// job 1
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '1'");
$row = mysql_fetch_array($query);
$job1_value = $row['job_name'];
$job1 = $row['job_name'];
$status_job1 = $row['job_status'];
if($status_job1 == 0) $job1 = $job0;

// job 2
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '2'");
$row = mysql_fetch_array($query);
$job2_value = $row['job_name'];
$job2 = $row['job_name'];
$status_job2 = $row['job_status'];
if($status_job2 == 0) $job2 = $job0;

// job 3
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '3'");
$row = mysql_fetch_array($query);
$job3_value = $row['job_name'];
$job3 = $row['job_name'];
$status_job3 = $row['job_status'];
if($status_job3 == 0) $job3 = $job0;

// job 4
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '4'");
$row = mysql_fetch_array($query);
$job4_value = $row['job_name'];
$job4 = $row['job_name'];
$status_job4 = $row['job_status'];
if($status_job4 == 0) $job4 = $job0;

// job 5
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '5'");
$row = mysql_fetch_array($query);
$job5_value = $row['job_name'];
$job5 = $row['job_name'];
$status_job5 = $row['job_status'];
if($status_job5 == 0) $job5 = $job0;

// job 6
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '6'");
$row = mysql_fetch_array($query);
$job6_value = $row['job_name'];
$job6 = $row['job_name'];
$status_job6 = $row['job_status'];
if($status_job6 == 0) $job6 = $job0;

// job 7
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '7'");
$row = mysql_fetch_array($query);
$job7_value = $row['job_name'];
$job7 = $row['job_name'];
$status_job7 = $row['job_status'];
if($status_job7 == 0) $job7 = $job0;

// job 8
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '8'");
$row = mysql_fetch_array($query);
$job8_value = $row['job_name'];
$job8 = $row['job_name'];
$status_job8 = $row['job_status'];
if($status_job8 == 0) $job8 = $job0;

// job 9
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '9'");
$row = mysql_fetch_array($query);
$job9_value = $row['job_name'];
$job9 = $row['job_name'];
$status_job9 = $row['job_status'];
if($status_job9 == 0) $job9 = $job0;

// job 10
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '10'");
$row = mysql_fetch_array($query);
$job10_value = $row['job_name'];
$job10 = $row['job_name'];
$status_job10 = $row['job_status'];
if($status_job10 == 0) $job10 = $job0;

// job 11
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '11'");
$row = mysql_fetch_array($query);
$job11_value = $row['job_name'];
$job11 = $row['job_name'];
$status_job11 = $row['job_status'];
if($status_job11 == 0) $job11 = $job0;

// job 12
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '12'");
$row = mysql_fetch_array($query);
$job12_value = $row['job_name'];
$job12 = $row['job_name'];
$status_job12 = $row['job_status'];
if($status_job12 == 0) $job12 = $job0;

// job 13
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '13'");
$row = mysql_fetch_array($query);
$job13_value = $row['job_name'];
$job13 = $row['job_name'];
$status_job13 = $row['job_status'];
if($status_job13 == 0) $job13 = $job0;

// job 14
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '14'");
$row = mysql_fetch_array($query);
$job14_value = $row['job_name'];
$job14 = $row['job_name'];
$status_job14 = $row['job_status'];
if($status_job14 == 0) $job14 = $job0;

// job 15
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '15'");
$row = mysql_fetch_array($query);
$job15_value = $row['job_name'];
$job15 = $row['job_name'];
$status_job15 = $row['job_status'];
if($status_job15 == 0) $job15 = $job0;

// job 16
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '16'");
$row = mysql_fetch_array($query);
$job16_value = $row['job_name'];
$job16 = $row['job_name'];
$status_job16 = $row['job_status'];
if($status_job16 == 0) $job16 = $job0;

// job 17
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '17'");
$row = mysql_fetch_array($query);
$job17_value = $row['job_name'];
$job17 = $row['job_name'];
$status_job17 = $row['job_status'];
if($status_job17 == 0) $job17 = $job0;

// job 18
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '18'");
$row = mysql_fetch_array($query);
$job18_value = $row['job_name'];
$job18 = $row['job_name'];
$status_job18 = $row['job_status'];
if($status_job18 == 0) $job18 = $job0;

// job 19
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '19'");
$row = mysql_fetch_array($query);
$job19_value = $row['job_name'];
$job19 = $row['job_name'];
$status_job19 = $row['job_status'];
if($status_job19 == 0) $job19 = $job0;

// job 20
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '20'");
$row = mysql_fetch_array($query);
$job20_value = $row['job_name'];
$job20 = $row['job_name'];
$status_job20 = $row['job_status'];
if($status_job20 == 0) $job20 = $job0;

// job 20
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '20'");
$row = mysql_fetch_array($query);
$job20_value = $row['job_name'];
$job20 = $row['job_name'];
$status_job20 = $row['job_status'];
if($status_job20 == 0) $job20 = $job0;

// job 21
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '21'");
$row = mysql_fetch_array($query);
$job21_value = $row['job_name'];
$job21 = $row['job_name'];
$status_job21 = $row['job_status'];
if($status_job21 == 0) $job21 = $job0;

// job 22
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '22'");
$row = mysql_fetch_array($query);
$job22_value = $row['job_name'];
$job22 = $row['job_name'];
$status_job22 = $row['job_status'];
if($status_job22 == 0) $job22 = $job0;

// job 23
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '23'");
$row = mysql_fetch_array($query);
$job23_value = $row['job_name'];
$job23 = $row['job_name'];
$status_job23 = $row['job_status'];
if($status_job23 == 0) $job23 = $job0;

// job 24
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '24'");
$row = mysql_fetch_array($query);
$job24_value = $row['job_name'];
$job24 = $row['job_name'];
$status_job24 = $row['job_status'];
if($status_job24 == 0) $job24 = $job0;

// job 25
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '25'");
$row = mysql_fetch_array($query);
$job25_value = $row['job_name'];
$job25 = $row['job_name'];
$status_job25 = $row['job_status'];
if($status_job25 == 0) $job25 = $job0;

// job 26
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '26'");
$row = mysql_fetch_array($query);
$job26_value = $row['job_name'];
$job26 = $row['job_name'];
$status_job26 = $row['job_status'];
if($status_job26 == 0) $job26 = $job0;

// job 27
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '27'");
$row = mysql_fetch_array($query);
$job27_value = $row['job_name'];
$job27 = $row['job_name'];
$status_job27 = $row['job_status'];
if($status_job27 == 0) $job27 = $job0;

// job 28
$query = mysql_query("SELECT * FROM `ucp_jobs` WHERE `job_id` = '28'");
$row = mysql_fetch_array($query);
$job28_value = $row['job_name'];
$job28 = $row['job_name'];
$status_job28 = $row['job_status'];
if($status_job28 == 0) $job28 = $job0;
?>

[Carnacior]

iti da aia cu boolean pentru ca nu se realizeaza conexiunea mysql
daca se realiza nu mai era bool ca era conexiunea in sine in variabila respectiva

daca scriptul nu e facut de tine si evident nu e facut de tine verifica inca o data datele de logare SQL si vezi ca trebe sa fie si remote daca nu e pe acelasi host cu baza de date