Hi halojoy,
Below is part of the code, from line 37 to 58
<?php
...
$sql = "SELECT request_id,session_id,store_front_channel,msisdn,operator_code,short_code,message,request_type // <-- line 37
FROM tbl_content_request
WHERE
request = 1 AND
retry = 0 AND
process = 0
ORDER BY request_date ASC";
$result = mysql_query($sql, $conn);
if ($result !== FALSE && mysql_ping($conn)) {
$rec_count = ((!mysql_ping($conn) || $conn === FALSE) ? 0 : mysql_num_rows($result));
$data_query = array();
if ($conn !== FALSE && mysql_ping($conn)) {
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
array_push($data_query, $row);
}
}
if ($conn !== FALSE && mysql_ping($conn)) {
mysql_free_result($result);
} // <-- line 58
...
}
...
?>
Is it any possibility that the problem caused by MySQL integer overflow?
halojoy;10945984 wrote:Can you post
your php code of Lines 40-50 in store_fronts/sf/handler/mt_sender.php
Because right BEFORE Line 46, you have one mysql_query()
This query did not work well and produced an invalid resource, result,
that was not suitable for the mysql_num_rows() in Line 46.
PHP Warning: mysql_num_rows(): -2147483648 is not a valid MySQL result resource in
/home/andalabs/mobisuite/mobisuite/store_fronts/sf/handler/mt_sender.php on line 46
