Answer the question
In order to leave comments, you need to log in
The mysql query is formed, displayed, but an error comes out after a time, what's the problem?
The request is formed, but constantly swears at the request, there is data in the table, it exits every other time. Pliz tell me where to look.
A Database Error Occurred
Error Number: 1356
View 'ru-rv-od.n0001_contract' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
SELECT COUNT(*) AS `numrows` FROM `n0001_contract` WHERE `lb0001_id` = '105' AND `lb0206_id` = 'ie' AND `lb0201_id` = 'CANCELED'
Filename: name/name.php
Line Number: 177
Code:
function dbResultSize($src ,$where=null,$like=null){
$CI =& get_instance();
if($where) $CI->db->where($where);
if($like) $CI->db->like($like);
$r=$CI->db->
if($r>0) return $r;
return null;
}
Answer the question
In order to leave comments, you need to log in
This is not a table, this is a view, judging by the error - it is broken.
If it works every other time, I can assume in telepath mode that you have a sql cluster and view is broken only on one of the nodes.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question