[LemonPOS-general] Antw.: Why there are corrupted tables in my lemonpos database?

[<tux...@t-...>]

Hello Enrique,
Hello @alii,


These tables are views - not real tables so there can't be analysed like normal tables.

Views are containing predefined SQL-Selects and are providing a specified access-tier to the Störer data.


Regards
tuxtrainer

----- Reply message -----
Von: "Enrique Martínez" <ema...@ip...>
Datum: So., Jul. 29, 2012 04:57
Betreff: [LemonPOS-general] Why there are corrupted tables in my lemonpos	database?
An: <lem...@li...>

Hi, I've analyzed all tables in my lemonpos database using phpmyadmin and I
get the following error in some tables:

lemondb.v_groupedSO analyze Error 'lemondb.v_groupedSO' is not BASE TABLE
lemondb.v_groupedSO analyze error Corrupt lemondb.v_transactionitems analyze
Error 'lemondb.v_transactionitems' is not BASE TABLE
lemondb.v_transactionitems analyze error Corrupt lemondb.v_transactions
analyze Error 'lemondb.v_transactions' is not BASE TABLE
lemondb.v_transactions analyze error Corrupt lemondb.v_transactionsbydate
analyze Error 'lemondb.v_transactionsbydate' is not BASE TABLE
lemondb.v_transactionsbydate analyze error Corrupt lemondb.v_transS analyze
Error 'lemondb.v_transS' is not BASE TABLE lemondb.v_transS analyze error
Corrupt
do you know what happen? I have done the analysis because I found some rare
transactions on the squeeze records.

Thanks in advance.

-- 
*__________________________________________________
---------------------------------------------------------------------------------------
Enrique Martínez Roldán
Academia de Computación
Departamento de Ingeniería Eléctrica
*
*ESIME - Zacatenco - IPN*
__________________________________________________
---------------------------------------------------------------------------------------

       (    )
        ~oo~
         .. Gnu!
         / =\   \=
        -   -    -   *

No programming language is perfect. There is not even a single
        best language; there are only languages well suited or perhaps
        poorly suited for particular purposes.

--Herbert Mayer
*