mysql error......

mohammadi Peon

Messages:: 78

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#1

I've install an mp3 script at my site but my site shown a mysql error so how to resolve it,,, please see the below link & help me...

http://www.room.pk/mp3/search/mp3/1/ready.html

mohammadi, Jun 4, 2011 IP

mwasif Active Member

Messages:: 816

Likes Received:: 23

Best Answers:: 1

Trophy Points:: 70

#2

This is because your MySQL query has problem. It was not successfully executed and returned invalid resource.

mwasif, Jun 4, 2011 IP

mohammadi Peon

Messages:: 78

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#3

mwasif said: ↑

This is because your MySQL query has problem. It was not successfully executed and returned invalid resource.
Click to expand...

so how to resolve it.....

mohammadi, Jun 5, 2011 IP

mwasif Active Member

Messages:: 816

Likes Received:: 23

Best Answers:: 1

Trophy Points:: 70

#4

Fix your query....

mwasif, Jun 5, 2011 IP

mohammadi Peon

Messages:: 78

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#5

mwasif said: ↑

Fix your query....
Click to expand...

can you let me know the step by step b'coz i'm new in this.....

mohammadi, Jun 5, 2011 IP

mohammadi Peon

Messages:: 78

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#6

dear,
no i've try at my another domain but have same prob....
http://hungamapk.com/search/mp3/1/mast+mast.html
Code (markup):

mohammadi, Jun 5, 2011 IP

mwasif Active Member

Messages:: 816

Likes Received:: 23

Best Answers:: 1

Trophy Points:: 70

#7

Post the query that you are running just before this line.

mwasif, Jun 5, 2011 IP

mohammadi Peon

Messages:: 78

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#8

mwasif said: ↑

Post the query that you are running just before this line.
Click to expand...

please know me the step by step which line ....... my function file is.....

<?php

function enc($string) {
$key = "123abc"; //preset key to use on all encrypt and decrypts.
$result = '';
for($i=0; $i<strlen($string); $i++) {
$char = substr($string, $i, 1);
$keychar = substr($key, ($i % strlen($key))-1, 1);
$char = chr(ord($char)+ord($keychar));
$result.=$char;
}
return urlencode(base64_encode($result));
}
function dec($string) {
$key = "123abc";
$result = '';
$string = base64_decode(urldecode($string));
for($i=0; $i<strlen($string); $i++) {
$char = substr($string, $i, 1);
$keychar = substr($key, ($i % strlen($key))-1, 1);
$char = chr(ord($char)-ord($keychar));
$result.=$char;
}
return $result;
}

if (!function_exists("openurl")) {
include dirname(__FILE__) . "/Snoopy.class.php";
function openurl($url, $referer = "http://www.google.com/firefox?client=firefox-a&rls=org.mozilla:frfficial"){
$snoopy = new Snoopy;
$snoopy->agent = "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.1.7) Gecko Firefox/3.5.7";
$snoopy->referer = $referer;
if ($snoopy->fetch($url)){
return $snoopy->results;
} else {
return false;
}
}
}

function expstr($content, $start, $end)
{
if ($content && $start && $end)
{
$r = explode($start, $content);
if (isset($r[1]))
{
$r = explode($end, $r[1]);
return $r[0];
}
return '';
}
}

function CheckDupe($item, $table, $field) {
if (@mysql_num_rows(mysql_query("SELECT ".$field." FROM ".$table." WHERE ".$field." = '".$item."'")) > 0) {
if (PASS_DUPES == 'true') {
return false;
} else {
return true;
}
} else {
return true;
}
}

function isValidEmail ($emailaddy) {
return eregi("^[a-z0-9_]+@[a-z0-9\-]+\.[a-z0-9\-\.]+$", $emailaddy);
}
function GetMainBaseFromURL($url)
{
$chars = preg_split('//', $url, -1, PREG_SPLIT_NO_EMPTY);

$slash = 3; // 3rd slash

$i = 0;

foreach($chars as $key => $char)
{
if($char == '/')
{
$j = $i++;
}

if($i == 3)
{
$pos = $key; break;
}
}

$main_base = substr($url, 0, $pos);

return $main_base.'/';
}

function Get_Date() {
return date( 'Y-m-d H:i:s');
}

function clean($input) {
$input = trim($input);
$input = get_magic_quotes_gpc() ? stripslashes($input) : $input;
$input = is_numeric($input) ? intval($input) : mysql_real_escape_string($input);
$input = htmlspecialchars($input);
return $input;
}

function Make_Pretty($input) {
$input = strip_tags($input);
$input = stripslashes($input);
$input = str_replace("&", "", $input);
$input = str_replace("?", "", $input);
$input = str_replace("/", "", $input);
$input = str_replace("-", " ", $input);
$input = str_replace(".", " ", $input);
$input = str_replace("--", "-", $input);
$input = str_replace("'", "", $input);
return $input;
}

function Make_Pretty_Tag($input) {
$input = strip_tags($input);
$input = urldecode($input);
return $input;
}

function Run_Results($search, $page, $limit) {
global $b;
if (SOURCES_ENABLED == 'true') {
Run_Indexed($search, $page, $limit);
}
Run_Sources($search, $page, $limit);
if ($b == 0) {
if ($page >= 2) {
echo '<h3>Sorry, no results could be found</h3>';
echo '<a href="'.WEB_PATH.'search/mp3/1/'.UrlText($search).'.html">Try the first page?</a>';
} else {
echo '<h3>Sorry, no results could be found</h3>
<a href="javascript:history.go(-1)">Go Back</a>';
}
} else {
echo '<div id="pages">';
$previous = $page -1;
$next = $page +1;
if ($page >= 2) {
echo '<a href="'.WEB_PATH.'search/mp3/'.$previous.'/'.UrlText($search).'.html">Previous</a>';
} else {
echo 'Previous';
}
echo ' - ';
echo '<a href="'.WEB_PATH.'search/mp3/'.$next.'/'.UrlText($search).'.html">Next</a>';
echo '</div>';
}
}

function Run_Sources($search, $page, $limit) {
include dirname(__FILE__) ."/../config.php";
$adsshown = 1;
foreach ($settings['sources'] as $source) {
if ($adsshown <= BET_RES_ADS_LIMIT) {
echo '<center>'.BET_RES_ADS.'</center>';
$adsshown ++;
}
include dirname(__FILE__)."/sources/".$source;

}
}
function Run_Indexed($search, $page, $limit) {
$ser = strip_tags($search);

$search_query = str_replace("-", " ", $ser);
$search_query = trim($search_query);
$search_query = preg_replace('!\s+!', ' ', $search_query);
$ser = str_replace("-", " ", $ser);
$start = RESULTS_LIMIT * ($page-1);
$max = RESULTS_LIMIT * $page;
if (strlen($ser) <= 3) {
$query = "SELECT * FROM downloads WHERE title || artist LIKE '%$ser%' ORDER BY id DESC LIMIT $start, $max";
if(mysql_num_rows(mysql_query($query))==0){
$search_queries = explode(" ", $search_query);
$i = 0;
foreach ($search_queries as $asearch) {
$tosearch .= " OR title LIKE '%" . $asearch . "%'";
$i += 1;
if ($i > 10) {
break;
}
}
$query = "SELECT * FROM downloads WHERE title || artist LIKE '%$search_query%' $tosearch ORDER BY id DESC LIMIT $start, $max";
}
} else {

$search_queries = explode(" ", $search_query);

foreach ($search_queries as $search1){
$sql_items = $sql_items . ''.$search1.' ';
}
$query = "SELECT * FROM downloads WHERE MATCH (title, artist)
AGAINST ('$sql_items' IN BOOLEAN MODE) LIMIT $start, $max";
}

$result = mysql_query($query) or die(mysql_error());
if ($result) {
$b = 0;
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$b ++;
$name =$row['title'];
$artist = $row['artist'];
$bitrate = $row['bitrate'];
$playtime = $row['playtime'];
$md5 = md5(preg_replace("/[^a-zA-Z0-9\s]/", "",$row['download']));
$download = WEB_PATH. 'download/'.md5(preg_replace("/[^a-zA-Z0-9\s]/", "",$row['download'])).'.html';
$listen = WEB_PATH. 'download/'.md5(preg_replace("/[^a-zA-Z0-9\s]/", "",$row['download'])).'.mp3';
$redirect = WEB_PATH. 'listen/'.md5(preg_replace("/[^a-zA-Z0-9\s]/", "",$row['download'])).'.mp3';

include dirname(__FILE__)."/../templates/layout_result.php";

}
}
}

function UrlText($text) {
$text = str_replace(' ', '+', $text);
$text = preg_replace("/[^a-zA-Z0-9-+]/", "", $text);
return $text;
}

function getmicrotime(){
list($usec, $sec) = explode(" ",microtime());
return ((float)$usec + (float)$sec);
}

function GetMD5Info($md5, $field) {
$query = "SELECT * FROM downloads WHERE md5 = '".$md5."'";
$result = mysql_query($query);
$song = mysql_fetch_array($result);
return mysql_escape_string($song[$field]);
}

function MakeDownload($download_row, $download, $index) {
if ($index == 'true') {
return WEB_PATH. 'download/'.md5(preg_replace("/[^a-zA-Z0-9\s]/", "",$download_row)).'.mp3';
} else {
if ($download) { return WEB_PATH. 'download/'.md5(preg_replace("/[^a-zA-Z0-9\s]/", "",$download_row)).'.html';} else
{ return WEB_PATH. 'download/'.md5(preg_replace("/[^a-zA-Z0-9\s]/", "",$download_row)).'.mp3'; }
}
}

function MakeListen($download_row, $index) {
return WEB_PATH. 'listen/'.md5(preg_replace("/[^a-zA-Z0-9\s]/", "",$download_row)).'.mp3';
}

function AlreadyThere($md5, $playlistid) {
$download =MakeDownload(GetMD5Info($md5, 'download'), false, DISPLAY_INDEXED);
$result = mysql_query("SELECT * FROM playlist_songs WHERE plsong_url = '".$download."' and user_id = '".$_SESSION['serid']."'") or die(mysql_error());
if (mysql_num_rows($result) > 0) {
return true;
} else {
return false;
}
}

function user_login ($username, $password){
$username = mysql_real_escape_string($username);
$password = md5($password);
$sql = mysql_query("SELECT * FROM users WHERE username = '$username' AND password = '$password' LIMIT 1");
$rows = mysql_num_rows($sql);
if ($rows<=0 ){
echo "Incorrect username/password";
}else{
$result = mysql_query("SELECT * FROM users WHERE username = '$username' LIMIT 1") or die(mysql_error());
$row = mysql_fetch_array($result);
$userid = $row['userid'];
$email = $row['email'];
$_SESSION['sername'] = $username;
$_SESSION['serid'] = $userid;
$_SESSION['email'] = $email;
}
}

function user_logout()
{
session_unset ();
session_destroy ();
}

?>
Click to expand...

mohammadi, Jun 5, 2011 IP

mwasif Active Member

Messages:: 816

Likes Received:: 23

Best Answers:: 1

Trophy Points:: 70

#9

Sorry, I can not read all the file. Post the lines from 160 to 181.

mwasif, Jun 5, 2011 IP

mohammadi Peon

Messages:: 78

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#10

mwasif said: ↑

Sorry, I can not read all the file. Post the lines from 160 to 181.
Click to expand...

ok no prob..... but which query i put in....

mohammadi, Jun 5, 2011 IP

mwasif Active Member

Messages:: 816

Likes Received:: 23

Best Answers:: 1

Trophy Points:: 70

#11

Post here the lines of code from line 160 to line 181.

mwasif, Jun 5, 2011 IP

mohammadi Peon

Messages:: 78

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#12

mwasif said: ↑

Post here the lines of code from line 160 to line 181.
Click to expand...

now line 158 to 181 here.........

function Run_Sources($search, $page, $limit) {
include dirname(__FILE__) ."/../config.php";
$adsshown = 1;
foreach ($settings['sources'] as $source) {
if ($adsshown <= BET_RES_ADS_LIMIT) {
echo '<center>'.BET_RES_ADS.'</center>';
$adsshown ++;
}
include dirname(__FILE__)."/sources/".$source;

}
}
function Run_Indexed($search, $page, $limit) {
$ser = strip_tags($search);

$search_query = str_replace("-", " ", $ser);
$search_query = trim($search_query);
$search_query = preg_replace('!\s+!', ' ', $search_query);
$ser = str_replace("-", " ", $ser);
$start = RESULTS_LIMIT * ($page-1);
$max = RESULTS_LIMIT * $page;
if (strlen($ser) <= 3) {
$query = "SELECT * FROM downloads WHERE title || artist LIKE '%$ser%' ORDER BY id DESC LIMIT $start, $max";
if(mysql_num_rows(mysql_query($query))==0){
Click to expand...

mohammadi, Jun 5, 2011 IP

mwasif Active Member

Messages:: 816

Likes Received:: 23

Best Answers:: 1

Trophy Points:: 70

#13

Change this line for debugging
if(mysql_num_rows(mysql_query($query))==0){
Code (markup):
to
$rs = mysql_query($query) or die("Error in query: ".mysql_error());
if(mysql_num_rows($rs)==0){
Code (markup):
Post here what your got in the page now

mwasif, Jun 5, 2011 IP

mohammadi Peon

Messages:: 78

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#14

this is show............check this

http://hungamapk.com/search/mp3/1/old+romentic+songs.html

mohammadi, Jun 5, 2011 IP

mohammadi Peon

Messages:: 78

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#15

asif,,, after add your reply....... plz inform me at 03232010307 through sms.....................

mohammadi, Jun 5, 2011 IP

mwasif Active Member

Messages:: 816

Likes Received:: 23

Best Answers:: 1

Trophy Points:: 70

#16

It seems that your script is providing limit in -ve numbers. To confirm this make a little more modification and replace the line
$rs = mysql_query($query) or die("Error in query: ".mysql_error());
with
$rs = mysql_query($query) or die("Query: $query <br> Error: ".mysql_error());

mwasif, Jun 5, 2011 IP

mohammadi Peon

Messages:: 78

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#17

mwasif said: ↑

It seems that your script is providing limit in -ve numbers. To confirm this make a little more modification and replace the line
$rs = mysql_query($query) or die("Error in query: ".mysql_error());
with
$rs = mysql_query($query) or die("Query: $query <br> Error: ".mysql_error());
Click to expand...

nop solved....... check this http://hungamapk.com/search/mp3/1/tarap.html

mohammadi, Jun 5, 2011 IP

mwasif Active Member

Messages:: 816

Likes Received:: 23

Best Answers:: 1

Trophy Points:: 70

#18

This query is wrong
SELECT * FROM downloads WHERE title || artist LIKE '%%' ORDER BY id DESC LIMIT [B]-10[/B], 0
Code (markup):
LIMIT should be +ve. It can't be -ve.

This line is the problem
$start = RESULTS_LIMIT * ($page-1);
Code (markup):

mwasif, Jun 5, 2011 IP

mohammadi Peon

Messages:: 78

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#19

so what i do.............how to resolve it..........

mohammadi, Jun 5, 2011 IP

mohammadi Peon

Messages:: 78

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#20

asif,,,, thanks for your support my this problem is solved now....

mohammadi, Jun 5, 2011 IP

Log in or Sign up

mysql error......

mohammadi Peon

mwasif Active Member

mohammadi Peon

mwasif Active Member

mohammadi Peon

mohammadi Peon

mwasif Active Member

mohammadi Peon

mwasif Active Member

mohammadi Peon

mwasif Active Member

mohammadi Peon

mwasif Active Member

mohammadi Peon

mohammadi Peon

mwasif Active Member

mohammadi Peon

mwasif Active Member

mohammadi Peon

mohammadi Peon

Useful Searches