ISSUE :
 
Profile photo
Submitted by Fernanda Santos
on July 18th, 2015 at 18:05:40 EST

Error No: 5 PLEASE HELP

my website is down because of a code error
i need help fixing this please
error message says:

Warning: mysql_query(): Unable to save result set in /hsphere/local/home/fetutti/lojae-stilo.com/system/database/mysql.php on line 21Notice: Error: Out of memory (Needed 4194276 bytes)
Error No: 5
SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '157' in /hsphere/local/home/fetutti/lojae-stilo.com/system/database/mysql.php on line 49




<?php
final class MySQL {
private $link;

public function __construct($hostname, $username, $password, $database) {
if (!$this->link = mysql_connect($hostname, $username, $password)) {
trigger_error('Error: Could not make a database link using ' . $username . '@' . $hostname);
}

if (!mysql_select_db($database, $this->link)) {
trigger_error('Error: Could not connect to database ' . $database);
}

mysql_query("SET NAMES 'utf8'", $this->link);
mysql_query("SET CHARACTER SET utf8", $this->link);
mysql_query("SET CHARACTER_SET_CONNECTION=utf8", $this->link);
mysql_query("SET SQL_MODE = ''", $this->link);
}

public function query($sql) {
$resource = mysql_query($sql, $this->link);

if ($resource) {
if (is_resource($resource)) {
$i = 0;

$data = array();

while ($result = mysql_fetch_assoc($resource)) {
$data[$i] = $result;

$i++;
}

mysql_free_result($resource);

$query = new stdClass();
$query->row = isset($data[0]) ? $data[0] : array();
$query->rows = $data;
$query->num_rows = $i;

unset($data);

return $query;
} else {
return true;
}
} else {
trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br />' . $sql);
exit();
}
}

public function escape($value) {
return mysql_real_escape_string($value, $this->link);
}

public function countAffected() {
return mysql_affected_rows($this->link);
}

public function getLastId() {
return mysql_insert_id($this->link);
}

public function __destruct() {
mysql_close($this->link);
}
}
?>


Profile photo
Replied by SBajra
on July 20th, 2015 at 13:10:08 EST
The error you are getting is "Out of Memory". So the question is how big is your database? If your database is too big, you may need to optimize the query.