Niemand rašė:
Annikute rašė: Ar čia tikrai visas klaidos tekstas? Taip pat reikia visos info apie pirmą klaidą.
Panašu, kad dėl kažkokių priežasčių sugadintas programos nustatymų failas.
Galima paleisti paiešką pgl apskaita5, ras kažkur keistoje vietoje folderį, kurio pavadinimas daugmaž Apskaita5.exe_Url_vg5mtmym2fnnxltpdbpbx245pe1l5bsx
Juos reikia ištrinti, kad priversti programą iš naujo sukurti settingus.
Dėkoju už atsakymą. Atlikome aukščiu paminėtus veiksmus, bet dabar nebeleidžia prisijungti prie duomenų bazės, meta naują klaidą. Labai bijau, ar nebūsiu praradusi trijų mėnesių darbo...
Nauja klaida:
Klaida vykdant SELECT sakinį (statement): [SELECT C.I_Kodas, C.I_Pavadinimas, C.I_PVM_kodas, C.I_Mail, C.I_Vadas, C.I_SD, C.NumbersInInvoice, C.AddDateToInvoiceNumber, C.DefaultInvoiceMadeContent, C.DefaultInvoiceReceivedContent, C.AccountClassPrefix11, C.AccountClassPrefix12, C.AccountClassPrefix21, C.AccountClassPrefix22, C.AccountClassPrefix31, C.AccountClassPrefix32, C.AccountClassPrefix41, C.AccountClassPrefix42, C.AccountClassPrefix51, C.AccountClassPrefix52, C.AccountClassPrefix61, C.AccountClassPrefix62, C.DefaultTaxNpdFormula, C.MeasureUnitInvoiceReceived, C.MeasureUnitInvoiceMade, C.I_Adresas, C.I_Bankas, C.I_Banko_sask, C.AddDateToTillIncomeOrderNumber, C.AddDateToTillSpendingsOrderNumber, C.BaseCurrency, C.Accountant, C.Cashier, (SELECT MAX(b.Op_data) FROM bz b WHERE b.Op_dok_rusis='uz' OR b.Op_dok_rusis='lik') FROM Imone C;='uz' OR b.Op_dok_rusis='lik') FROM Imone C;], Params:
Klaidos turinys: 'Unknown column 'C.NumbersInInvoice' in 'field list''.
Klaidos duomenys:
Klaidos tekstas:
DataPortal.Fetch failed (System.Exception: Klaida vykdant SELECT sakinį (statement): [SELECT C.I_Kodas, C.I_Pavadinimas, C.I_PVM_kodas, C.I_Mail, C.I_Vadas, C.I_SD, C.NumbersInInvoice, C.AddDateToInvoiceNumber, C.DefaultInvoiceMadeContent, C.DefaultInvoiceReceivedContent, C.AccountClassPrefix11, C.AccountClassPrefix12, C.AccountClassPrefix21, C.AccountClassPrefix22, C.AccountClassPrefix31, C.AccountClassPrefix32, C.AccountClassPrefix41, C.AccountClassPrefix42, C.AccountClassPrefix51, C.AccountClassPrefix52, C.AccountClassPrefix61, C.AccountClassPrefix62, C.DefaultTaxNpdFormula, C.MeasureUnitInvoiceReceived, C.MeasureUnitInvoiceMade, C.I_Adresas, C.I_Bankas, C.I_Banko_sask, C.AddDateToTillIncomeOrderNumber, C.AddDateToTillSpendingsOrderNumber, C.BaseCurrency, C.Accountant, C.Cashier, (SELECT MAX(b.Op_data) FROM bz b WHERE b.Op_dok_rusis='uz' OR b.Op_dok_rusis='lik') FROM Imone C;='uz' OR b.Op_dok_rusis='lik') FROM Imone C;], Params:
Klaidos turinys: 'Unknown column 'C.NumbersInInvoice' in 'field list''. ---> MySql.Data.MySqlClient.MySqlException: Unknown column 'C.NumbersInInvoice' in 'field list'
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.DatabaseAccess.SQLUtilities.FetchCompanyInfo(String DatabaseName, String Password, CustomCompanyInfoFetchRoutine CustomFetchRoutine)
at ApskaitaObjects.Settings.CompanyInfo.Fetch(String Database, String Password)
at ApskaitaObjects.Settings.CompanyInfo..ctor(String Database, String Password)
at ApskaitaObjects.Settings.CompanyInfo.LoadCompanyInfoToGlobalContext(String Database, String Password)
at ApskaitaObjects.CustomCacheManager.AddCompanyInfoToLocalContext(String cDatabase, String cPassword)
at AccDataAccessLayer.Security.AccIdentity.DataPortal_Fetch(Criteria criteria))
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
Fetch
Klaidos stekas:
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCompanyInfo(String DatabaseName, String Password, CustomCompanyInfoFetchRoutine CustomFetchRoutine)
at ApskaitaObjects.Settings.CompanyInfo.Fetch(String Database, String Password)
at ApskaitaObjects.Settings.CompanyInfo..ctor(String Database, String Password)
at ApskaitaObjects.Settings.CompanyInfo.LoadCompanyInfoToGlobalContext(String Database, String Password)
at ApskaitaObjects.CustomCacheManager.AddCompanyInfoToLocalContext(String cDatabase, String cPassword)
at AccDataAccessLayer.Security.AccIdentity.DataPortal_Fetch(Criteria criteria)
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.Server.SimpleDataPortal.Fetch(Type objectType, Object criteria, DataPortalContext context)
at Csla.DataPortal.Fetch(Type objectType, Object criteria)
at Csla.DataPortal.Fetch[T](Object criteria)
at AccDataAccessLayer.Security.AccIdentity.GetIdentity(String cDatabase, ICacheManager cCacheManager, String cPassword)
at AccDataAccessLayer.Security.AccPrincipal.Login(String cDatabase, ICacheManager cCacheManager, String cPassword)
at ApskaitaWUI.MDIParent1.Baze(Object sender, EventArgs e)
----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal_Fetch method call failed
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
CallMethod
Klaidos stekas:
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCompanyInfo(String DatabaseName, String Password, CustomCompanyInfoFetchRoutine CustomFetchRoutine)
at ApskaitaObjects.Settings.CompanyInfo.Fetch(String Database, String Password)
at ApskaitaObjects.Settings.CompanyInfo..ctor(String Database, String Password)
at ApskaitaObjects.Settings.CompanyInfo.LoadCompanyInfoToGlobalContext(String Database, String Password)
at ApskaitaObjects.CustomCacheManager.AddCompanyInfoToLocalContext(String cDatabase, String cPassword)
at AccDataAccessLayer.Security.AccIdentity.DataPortal_Fetch(Criteria criteria)
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.Server.SimpleDataPortal.Fetch(Type objectType, Object criteria, DataPortalContext context)
----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Klaida vykdant SELECT sakinį (statement): [SELECT C.I_Kodas, C.I_Pavadinimas, C.I_PVM_kodas, C.I_Mail, C.I_Vadas, C.I_SD, C.NumbersInInvoice, C.AddDateToInvoiceNumber, C.DefaultInvoiceMadeContent, C.DefaultInvoiceReceivedContent, C.AccountClassPrefix11, C.AccountClassPrefix12, C.AccountClassPrefix21, C.AccountClassPrefix22, C.AccountClassPrefix31, C.AccountClassPrefix32, C.AccountClassPrefix41, C.AccountClassPrefix42, C.AccountClassPrefix51, C.AccountClassPrefix52, C.AccountClassPrefix61, C.AccountClassPrefix62, C.DefaultTaxNpdFormula, C.MeasureUnitInvoiceReceived, C.MeasureUnitInvoiceMade, C.I_Adresas, C.I_Bankas, C.I_Banko_sask, C.AddDateToTillIncomeOrderNumber, C.AddDateToTillSpendingsOrderNumber, C.BaseCurrency, C.Accountant, C.Cashier, (SELECT MAX(b.Op_data) FROM bz b WHERE b.Op_dok_rusis='uz' OR b.Op_dok_rusis='lik') FROM Imone C;='uz' OR b.Op_dok_rusis='lik') FROM Imone C;], Params:
Klaidos turinys: 'Unknown column 'C.NumbersInInvoice' in 'field list''.
Klaidos šaltinis(Ex.Source):
AccDataAccessLayer
Klaidos metodas (Ex.TargetSite):
FetchCompanyInfo
Klaidos stekas:
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCompanyInfo(String DatabaseName, String Password, CustomCompanyInfoFetchRoutine CustomFetchRoutine)
at ApskaitaObjects.Settings.CompanyInfo.Fetch(String Database, String Password)
at ApskaitaObjects.Settings.CompanyInfo..ctor(String Database, String Password)
at ApskaitaObjects.Settings.CompanyInfo.LoadCompanyInfoToGlobalContext(String Database, String Password)
at ApskaitaObjects.CustomCacheManager.AddCompanyInfoToLocalContext(String cDatabase, String cPassword)
at AccDataAccessLayer.Security.AccIdentity.DataPortal_Fetch(Criteria criteria)
----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Unknown column 'C.NumbersInInvoice' in 'field list'
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)