Error
SQL query:  

SHOW TABLE STATUS LIKE 'loanspaidregister';



MySQL said:  

#1030 - Got error 12 from storage engine

CREATE VIEW cashinout AS
SELECT
      a.`dateredeem` AS 'Date'
      , SUM( ( a.principal * a.interest ) + a.principal ) AS 'CashIn'
      , 0 AS CashOut
      , b.branch AS 'Branch'
      , 'Redeem' as 'Type'
  FROM
      pawnshop_tbl a
      LEFT JOIN emp_tbl b ON ( a.authorep = b.last_name )
      WHERE a.ServiceType = 'Redeem'
  GROUP BY
      a.`dateredeem`
      ,b.branch

UNION ALL

SELECT
       a.`dateloan` as 'Date loan'
      , 0 AS 'CashIn'
      , SUM(a.principal) AS CashOut
      , b.branch AS 'Branch'
      , 'Pawn' as 'Type'
  FROM
      pawnshop_tbl a
      LEFT JOIN emp_tbl b ON ( a.authorep = b.last_name )
      WHERE a.ServiceType = 'Redeem'
  GROUP BY
     a.`dateloan`
      ,b.branch

UNION ALL

  SELECT
      b.`dateloan`
      , SUM( a.principal * a.interest )
      , 0
      , c.branch
      , 'Renew'
  FROM
      pawnshop_tbl b
      LEFT JOIN pawnshop_tbl a
      ON ( b.OldPT = a.PawnTicketNo )
      LEFT JOIN emp_tbl c ON ( b.authorep = c.last_name )
      WHERE b.ServiceType = 'Renew'
  GROUP BY
      b.`dateloan`
      ,b.branch

UNION ALL

  SELECT
      a.datesold
      , a.auctionprice
      , 0
      , b.branch
      , 'Sold'
  FROM
      sold_tbl a
  INNER JOIN emp_tbl b ON ( a.authorep = b.last_name )
  GROUP BY
      a.datesold
      ,b.branch

UNION ALL

  SELECT
      a.DateLoan
      , 0
      ,  sum(a.principal) as 'CashOut'
      , b.branch
      , 'Pawn'
  FROM
      pawnshop_tbl a
      left JOIN emp_tbl b ON ( a.authorep = b.last_name )
      where a.ServiceType = 'Pawn'
  GROUP BY
      a.DateLoan
      ,b.branch

UNION ALL

  SELECT
      new.dateloan
      ,old.principal - new.principal as 'cashin'
      ,0
      ,c.branch
      ,'RenewPaidPrinc'
  from
      pawnshop_tbl as `new`
      left join pawnshop_tbl as old on ( `new`.OldPT = old.PawnTicketNo )
      LEFT JOIN emp_tbl c ON ( `new`.authorep = c.last_name )