BANTU KOREKSI KESALAHAN DI PHP

error alert

 Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1356 View 'lokcay_base.v_xx' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them in C:\xampp\htdocs\piran\project\class.project.php:113 Stack trace: #0 C:\xampp\htdocs\piran\project\class.project.php(113): PDOStatement->execute() #1 C:\xampp\htdocs\piran\project\data_project.php(42): project->view(Object(PDOStatement)) #2 {main} thrown in C:\xampp\htdocs\piran\project\class.project.php on line 113

class.project.php line 110 - 140

 	public function view($query)
	{
		$query = $this->db->prepare($query);
		$query->execute();
		$no = 1;
		if($query->rowCount()>0)
		{
			while($row=$query->fetch(PDO::FETCH_ASSOC))
			{
				?>
                <tr>
                <td><div align="center"><?php print($row['kd_proyek']); ?></div></td>
                <td><?php print($row['nm_proyek']); ?></td>
                <td><?php print($row['kategori']); ?></td>
                <td><?php print($row['customer']); ?></td>
                <td><div align="center"><?php print($row['pic']); ?></div></td>
                <td><?php print(number_format( $row['nilai_kontrak'],1-10)); ?></td>
                <td><?php print(tgl_indo($row['wkt_mulai'])); ?></td>
                <td><?php print(tgl_indo($row['wkt_selesai'])); ?></td>
                <td><div align="center"><?php print($row['rencana']); ?></div></td>
                <td><div align="center"><?php print($row['progres']); ?></div></td>
                <td><div align="center"><?php print($row['deviasi']); ?></div></td>
                <td><div align="center"><?php echo "
	                <a href='javascript:void(0)' onclick=\"Progress('$row[kd_proyek]')\" >Progress</a>";?></div></td>
                <td><div align="center">
                <?php echo "
                <a href='javascript:void(0)' onclick=\"editData('$row[kd_proyek]')\" ><i class='icon-trash icon-pencil bigger-130'></i></i> </a>
                <a href='javascript:void(0)' onclick=\"deleteData('$row[kd_proyek]','$row[nm_proyek]')\" ><i class='icon-trash icon-red bigger-130'></i></i> </a>
                ";?>
                </div>
                </td>
                </tr>
                <?php
                $no++;
			} ?>