A
A
Anton2017-02-02 12:34:16
MySQL
Anton, 2017-02-02 12:34:16

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

1 answer(s)
D
Dmitry Entelis, 2017-02-02
@DmitriyEntelis

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 question

Ask a Question

731 491 924 answers to any question