Nemokama apskaitos programa

SF šablono įkėlimas per regioninius nustatymus jau senokai veikia...

Bandyk spausti ne ant dropdown'o pasirinkimų, o ant pačio preview mygtuko.

Kažkada bandžiau taip padaryti, ar blogai kažką padariau, ar dar koks velnias buvo, bet man išmetė klaidą ir viskas dingau padarė, teko išnaujo visą programą prsiinstaliuoti.....pabandysiu vakare pakartoti manevrą :)

Laba diena
Gal galėtumėte padaryti dar viena formą prie Darbo užmokesčio išmokėjimo žiniaraščio, tiesiog DU žiniaraštį, kur matytųsi tik Priskaičiuota, išskaičiuota, Išmokėti, sumos Viso prie Sodros ir VMI grafų, ir kad nebūtų parašų stulpelio ir išmokėta, bei deponuota eilučių

Sveiki
Norėjau paklausi dėl KPO. Išrašant KPO rodo, jog reikia nurodyti lėšų sąskaitą. Paspaudus rodyklę, lentelė yra tuščia, todėl negaliu užbaigti pildyti ir įvesti KPO. Ką darau ne taip ? Galbūt kažkur neįvedžiau reikiamos informacijos anksčiau ? Ačiū

Nueikite dokumentai -> piniginės lėšos -> piniginių lėšų sąskaitos. Susiveskite duomenis.

Ačiū už pagalbą.

Įvedus kasos išlaidų orderį Kasos Piniginių lėšų apyvartos žiniaraštyje viską gerai rodo, bet pasirinkus banką ta pati suma su minuso ženklu ir likutį jos visai neprideda. Kasa.xls Bankas.xls

O kodel kontrahentu istraukimas veikia ant senos versijos, o ant naujos meta klaida. Apsisarvuoti kantrybe ir laukti?

Manau, kad kontrahentus galite ir rankiniu būdu susivesti, ne taip jau sudėtinga.

Neveikia nei ant kurios versijos. VMI su Registrų centru kažką su savo sistemomis daro, VMI senos versijos PVM mokėtojų paieška (kur be captcha) guli nuo vakar.

Labas vakaras,

atnaujinimo šiandien nepadarėte ar ne? Nes 5/6 uždarymas man vis dar apvalinasi. O atnaujinimo neranda.

Tik pasitikslinu.

Nes programa įnešimą iš kasos į banką ir priešingai palaiko tik per atskaitingą asmenį, o ne tiesiogiai.

Ačiū veikia :)

Jau.

Sveiki, gal galite padėti. perkeliant duomenis is senos i nauja versija, užstringu ties 4 punktu atliekant šį veiksmą Bendras\DB struktūra -> Tikrinti -> Taisyti; išmeta tokią klaida Klaida vykdant SELECT sakinį (statement): [SELECT (SELECT COUNT(*) FROM apyskaitos a LEFT JOIN asmenys b ON b.ID=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;], Params:
Klaidos turinys: 'Unknown column 'k.CashAccountID' in 'where clause''.

Sveiki, gal galite padėti. perkeliant duomenis is senos i nauja versija, užstringu ties 4 punktu atliekant šį veiksmą Bendras\DB struktūra -> Tikrinti -> Taisyti; išmeta tokią klaida Klaida vykdant SELECT sakinį (statement): [SELECT (SELECT COUNT(*) FROM apyskaitos a LEFT JOIN asmenys b ON b.ID=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;], Params:
Klaidos turinys: 'Unknown column 'k.CashAccountID' in 'where clause''.

paspaudus detaliau

Klaidos duomenys:
Klaidos tekstas:
DataPortal.Update failed (System.Exception: Klaida vykdant SELECT sakinį (statement): [SELECT (SELECT COUNT(*) FROM apyskaitos a LEFT JOIN asmenys b ON b.ID=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;], Params:
Klaidos turinys: 'Unknown column 'k.CashAccountID' in 'where clause''. ---> MySql.Data.MySqlClient.MySqlException: Unknown column 'k.CashAccountID' in 'where clause'
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)
--- End of inner exception stack trace ---
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update())
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
Update
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)
at Csla.DataPortal.Update(Object obj)
at Csla.DataPortal.Update[T](T obj)
at Csla.BusinessListBase`2.Save()
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.Save()
at ApskaitaWUI.F_DatabaseStructureError.RepairErrorsButton_Click(Object sender, EventArgs e)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal_Update method call failed
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
CallMethod
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Klaida vykdant SELECT sakinį (statement): [SELECT (SELECT COUNT(*) FROM apyskaitos a LEFT JOIN asmenys b ON b.ID=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;=a.Analit WHERE b.ID IS NULL and a.Analit>0) AS LostPersonApysk, (SELECT COUNT(*) FROM bz a LEFT JOIN asmenys b ON b.ID=a.Op_analitika WHERE b.ID IS NULL and a.Op_analitika>0) AS LostPersonBZ, (SELECT COUNT(*) FROM bzdata a LEFT JOIN asmenys b ON b.ID=a.Op_ana WHERE b.ID IS NULL and a.Op_ana>0) AS LostPersonBZDATA, (SELECT COUNT(*) FROM d_avansai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonAvansai, (SELECT COUNT(*) FROM darbuotojai_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDarbuotojai, (SELECT COUNT(*) FROM du_ziniarastis_d a LEFT JOIN asmenys b ON b.ID=a.AK WHERE b.ID IS NULL and a.AK>0) AS LostPersonDUZ, (SELECT COUNT(*) FROM offsetitems a LEFT JOIN asmenys b ON b.ID=a.PersonID WHERE b.ID IS NULL and a.PersonID>0) AS LostPersonOffsets, (SELECT COUNT(*) FROM advancereports a WHERE NOT a.Account>0) AS AdvanceReportsWithoutAccount, (SELECT COUNT(*) FROM kio k WHERE NOT k.CashAccountID>0) AS KioWithoutCashAccount, (SELECT COUNT(*) FROM kpo k WHERE NOT k.CashAccountID>0) AS KpoWithoutCashAccount, (SELECT COUNT(*) FROM bankoperations b WHERE NOT b.CashAccountID>0) AS BankWithoutCashAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN kio d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kio' AND d.BZ_ID IS NULL) AS LostKio, (SELECT COUNT(*) FROM bz b LEFT JOIN kpo d ON d.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='kpo' AND d.BZ_ID IS NULL) AS LostKpo, (SELECT COUNT(*) FROM bz b LEFT JOIN bankoperations d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='b' AND d.ParentID IS NULL) AS LostBank, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesmade d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sf' AND d.ID IS NULL) AS LostInvoicesMade, (SELECT COUNT(*) FROM bz b LEFT JOIN invoicesreceived d ON d.ID=b.Op_ID WHERE b.Op_dok_rusis='sg' AND d.ID IS NULL) AS LostInvoicesReceived, (SELECT COUNT(*) FROM bz b LEFT JOIN offsetitems d ON d.ParentID=b.Op_ID WHERE b.Op_dok_rusis='sk' AND d.ParentID IS NULL) AS LostOffsets, (SELECT COUNT(*) FROM invoicesmade i WHERE NOT i.InvoiceNumber>0 OR TRIM(i.InvoiceSerial)='') AS InvoicesWithoutNumber, (SELECT COUNT(*) FROM invoicesreceived i WHERE NOT i.AccountSupplier>0) AS InvoicesReceivedWithoutAccount, (SELECT COUNT(*) FROM bz b LEFT JOIN turtas_op d ON d.JE_ID=b.Op_ID WHERE (b.Op_dok_rusis='amo' OR b.Op_dok_rusis='t' OR b.Op_dok_rusis='tsp') AND d.JE_ID IS NULL) AS LostAssetOperations, (SELECT COUNT(*) FROM turtas_op d LEFT JOIN bz b ON b.Op_ID=d.JE_ID WHERE (d.OperationType='aac' OR d.OperationType='amo' OR d.OperationType='nur' OR d.OperationType='per') AND b.Op_ID IS NULL) AS LostAssetOperations2, (SELECT COUNT(*) FROM turtas t LEFT JOIN bz b ON b.OP_ID=t.ID WHERE b.Op_ID IS NULL) AS LostAssets;], Params:
Klaidos turinys: 'Unknown column 'k.CashAccountID' in 'where clause''.
Klaidos šaltinis(Ex.Source):
AccDataAccessLayer
Klaidos metodas (Ex.TargetSite):
FetchCommand
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.CustomDatabaseStructureErrorManager.RepairCustomError(DatabaseStructureErrorList& StructureErrorList, DatabaseStructureError CustomError)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureError.Update(DatabaseStructureErrorList& parent)
at AccDataAccessLayer.DatabaseAccess.DatabaseStructure.DatabaseStructureErrorList.DataPortal_Update()

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Unknown column 'k.CashAccountID' in 'where clause'
Klaidos šaltinis(Ex.Source):
MySql.Data
Klaidos metodas (Ex.TargetSite):
OpenPacket
Klaidos stekas:
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.FetchCommand(SQLCommand SelectCommand)

Dėkui
O kaip pavedimą tarp savo sąskaitų padaryti?
Atskaitingas gi čia nefiguruoja.

Panašu, kad ši klaida yra iš antro bandymo ir beprasmė. Po nepavykusio upgrade'o kaip taisyklė yra sugadinama duombazė. Vėlesnės bandymų klaidos neturi prasmės, tik pirma. Reikia ištrinti duombazę, importuoti, bandyti upgrade'inti ir žiūrėti tik pačią pirmą klaidą.