Trag I have no idea if it is a dash 1 or a -1 and I don't know how I could tell the difference. I copied the error directly from the log file. The function that is logging the error is:
function querymeres($query){
#query with result
global $mysqli;
#include_once('./bits/show-connect.inc.php');
$result = $mysqli->query($query);
if($result == false) {
error_log("Query failed:\n".$mysqli->error."\n$query");
}else{
return $result;
}
}
One of the queries that produced such an error is:
select * from inventy
WHERE shop
='1' and qty
>='1' and cat
!='out' and imag_url
!='' order by rand() limit 10
I happen to know that there are probably at least 100 items that satisfy the criteria in the table.
Dalecosp All of the tables in the database are MyIsam tables so I don't think some InnoDB issue would be the cause.
I'm supposed to have unlimited space and my databases are not ginormous. A couple of them I would call pretty large but none of my tables have as many as 7 or 8 thousand entries and most have less than 1000