Results 1 to 2 of 2

Thread: #1030 error

  1. #1
    Join Date
    Oct 2007
    Location
    Manila, Philippines
    Posts
    132

    Unanswered: #1030 error

    hi,
    my VIEWS table has this error
    when i try to select them...

    Code:
    Error
    SQL query:  
    
    SHOW TABLE STATUS LIKE 'loanspaidregister';
    
    
    
    MySQL said:  
    
    #1030 - Got error 12 from storage engine
    but my other tables are ok...
    only the VIEWS table

    please kindly help....

    thanks
    Take Nothing But Pictures;
    Leave Nothing But Footprints;
    Kill Nothing But Time;

  2. #2
    Join Date
    Oct 2007
    Location
    Manila, Philippines
    Posts
    132
    still an error
    my view code is
    Code:
    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 )
    when i try to execute this on phpmyadmin of my webhost
    it has an error of #1030 - Got error 12 from storage engine

    please i need help
    Take Nothing But Pictures;
    Leave Nothing But Footprints;
    Kill Nothing But Time;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •