Microinvest Форум Форуми Microinvest Форум
Microinvest Форум
 
 Въпроси/ОтговориВъпроси/Отговори   ТърсенеТърсене   ПотребителиПотребители   Потребителски групиПотребителски групи   Регистрирайте сеРегистрирайте се 
 ПрофилПрофил   Влезте, за да видите съобщенията сиВлезте, за да видите съобщенията си   ВходВход 

Проблем при използване - постоянно забиване

 
Създайте нова тема   Напишете отговор    Microinvest Форум Форуми -> Warehouse Open за Linux
Предишната тема :: Следващата тема  
Автор Съобщение
toniko



Регистриран на: 19 Мар 2010
Мнения: 40

МнениеПуснато на: Пон Ное 06, 2017 23:28    Заглавие: Проблем при използване - постоянно забиване Отговорете с цитат

Здравейте, инсталирах програмата, но както работи и прави бъг, излиза ми съобщение за критична грешка и това, че програмата ще се затвори. Ето и грешката, която ми излиза:


<?xml version="1.0" encoding="utf-8"?>
<errors os="Linux" osversion="4.13.0-16-generic" product="Warehouse Open">
<error timestamp="11.06.2017 23:21:20" version="1.16.8.29" severity="FatalError">
<exceptions>
<exception type="System.Exception" message="LazyListModel encountered an exception!">
<stackTrace>
<frame class="Warehouse.Data.Model.LazyListModel`1[Warehouse.Business.Operations.Sale]" method="CheckLastError" line="0" />
<frame class="Warehouse.Data.Model.LazyListModel`1[Warehouse.Business.Operations.Sale]" method="get_Count" line="0" />
<frame class="Warehouse.Component.ListView.CellText" method="ComputeRowHeight" line="0" />
<frame class="Warehouse.Component.ListView.ListView" method="get_RowHeight" line="0" />
<frame class="Warehouse.Component.ListView.ListView" method="UpdateAdjustments" line="0" />
<frame class="Warehouse.Component.ListView.ListView" method="OnSizeAllocated" line="0" />
<frame class="Gtk.Widget" method="sizeallocated_cb" line="0" />
</stackTrace>
</exception>
<exception type="System.Exception" message="MySql">
<stackTrace>
<frame class="Warehouse.Data.MySQL.DataProvider" method="ExecuteReader" line="0" />
<frame class="Warehouse.Data.Model.LazyListModel`1[Warehouse.Business.Operations.Sale]" method="Worker" line="0" />
<frame class="Warehouse.Data.ThreadPool.JobWrapper" method="DoWork" line="0" />
</stackTrace>
</exception>
<exception type="MySql.Data.MySqlClient.MySqlException" message="Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'DC-database-Joro.operations.OperType' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by">
<stackTrace>
<frame class="MySql.Data.MySqlClient.MySqlStream" method="ReadPacket" line="0" />
<frame class="MySql.Data.MySqlClient.NativeDriver" method="GetResult" line="0" />
</stackTrace>
</exception>
</exceptions>
</error>
<error timestamp="11.06.2017 23:21:20" version="1.16.8.29" severity="FatalError">
<exceptions>
<exception type="System.Exception" message="LazyListModel encountered an exception!">
<stackTrace>
<frame class="Warehouse.Data.Model.LazyListModel`1[Warehouse.Business.Operations.Sale]" method="CheckLastError" line="0" />
<frame class="Warehouse.Data.Model.LazyListModel`1[Warehouse.Business.Operations.Sale]" method="get_Count" line="0" />
<frame class="Warehouse.Component.ListView.CellText" method="ComputeRowHeight" line="0" />
<frame class="Warehouse.Component.ListView.ListView" method="get_RowHeight" line="0" />
<frame class="Warehouse.Component.ListView.ListView" method="ModelListChanged" line="0" />
<frame class="Warehouse.Component.ListView.ListView" method="ListReset_GlibHandler" line="0" />
<frame class="GLib.Timeout+TimeoutProxy" method="Handler" line="0" />
</stackTrace>
</exception>
<exception type="System.Exception" message="MySql">
<stackTrace>
<frame class="Warehouse.Data.MySQL.DataProvider" method="ExecuteReader" line="0" />
<frame class="Warehouse.Data.Model.LazyListModel`1[Warehouse.Business.Operations.Sale]" method="Worker" line="0" />
<frame class="Warehouse.Data.ThreadPool.JobWrapper" method="DoWork" line="0" />
</stackTrace>
</exception>
<exception type="MySql.Data.MySqlClient.MySqlException" message="Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'DC-database-Joro.operations.OperType' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by">
<stackTrace>
<frame class="MySql.Data.MySqlClient.MySqlStream" method="ReadPacket" line="0" />
<frame class="MySql.Data.MySqlClient.NativeDriver" method="GetResult" line="0" />
</stackTrace>
</exception>
</exceptions>
</error>
<error timestamp="11.06.2017 23:22:01" version="1.16.8.29" severity="FatalError">
<exceptions>
<exception type="System.Exception" message="LazyListModel encountered an exception!">
<stackTrace>
<frame class="Warehouse.Data.Model.LazyListModel`1[Warehouse.Business.Operations.Sale]" method="CheckLastError" line="0" />
<frame class="Warehouse.Data.Model.LazyListModel`1[Warehouse.Business.Operations.Sale]" method="get_Count" line="0" />
<frame class="Warehouse.Component.ListView.CellText" method="ComputeRowHeight" line="0" />
<frame class="Warehouse.Component.ListView.ListView" method="get_RowHeight" line="0" />
<frame class="Warehouse.Component.ListView.ListView" method="UpdateAdjustments" line="0" />
<frame class="Warehouse.Component.ListView.ListView" method="OnSizeAllocated" line="0" />
<frame class="Gtk.Widget" method="sizeallocated_cb" line="0" />
</stackTrace>
</exception>
<exception type="System.Exception" message="MySql">
<stackTrace>
<frame class="Warehouse.Data.MySQL.DataProvider" method="ExecuteReader" line="0" />
<frame class="Warehouse.Data.Model.LazyListModel`1[Warehouse.Business.Operations.Sale]" method="Worker" line="0" />
<frame class="Warehouse.Data.ThreadPool.JobWrapper" method="DoWork" line="0" />
</stackTrace>
</exception>
<exception type="MySql.Data.MySqlClient.MySqlException" message="Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'DC-database-Joro.operations.OperType' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by">
<stackTrace>
<frame class="MySql.Data.MySqlClient.MySqlStream" method="ReadPacket" line="0" />
<frame class="MySql.Data.MySqlClient.NativeDriver" method="GetResult" line="0" />
</stackTrace>
</exception>
</exceptions>
</error>
<error timestamp="11.06.2017 23:22:01" version="1.16.8.29" severity="FatalError">
<exceptions>
<exception type="System.Exception" message="LazyListModel encountered an exception!">
<stackTrace>
<frame class="Warehouse.Data.Model.LazyListModel`1[Warehouse.Business.Operations.Sale]" method="CheckLastError" line="0" />
<frame class="Warehouse.Data.Model.LazyListModel`1[Warehouse.Business.Operations.Sale]" method="get_Count" line="0" />
<frame class="Warehouse.Component.ListView.CellText" method="ComputeRowHeight" line="0" />
<frame class="Warehouse.Component.ListView.ListView" method="get_RowHeight" line="0" />
<frame class="Warehouse.Component.ListView.ListView" method="ModelListChanged" line="0" />
<frame class="Warehouse.Component.ListView.ListView" method="ListReset_GlibHandler" line="0" />
<frame class="GLib.Timeout+TimeoutProxy" method="Handler" line="0" />
</stackTrace>
</exception>
<exception type="System.Exception" message="MySql">
<stackTrace>
<frame class="Warehouse.Data.MySQL.DataProvider" method="ExecuteReader" line="0" />
<frame class="Warehouse.Data.Model.LazyListModel`1[Warehouse.Business.Operations.Sale]" method="Worker" line="0" />
<frame class="Warehouse.Data.ThreadPool.JobWrapper" method="DoWork" line="0" />
</stackTrace>
</exception>
<exception type="MySql.Data.MySqlClient.MySqlException" message="Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'DC-database-Joro.operations.OperType' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by">
<stackTrace>
<frame class="MySql.Data.MySqlClient.MySqlStream" method="ReadPacket" line="0" />
<frame class="MySql.Data.MySqlClient.NativeDriver" method="GetResult" line="0" />
</stackTrace>
</exception>
</exceptions>
</error>
<error timestamp="11.06.2017 23:24:55" version="1.16.8.29" severity="FatalError">
<exceptions>
<exception type="System.Exception" message="LazyListModel encountered an exception!">
<stackTrace>
<frame class="Warehouse.Data.Model.LazyListModel`1[Warehouse.Data.Model.LazyTableDataRow]" method="CheckLastError" line="0" />
<frame class="Warehouse.Data.Model.LazyListModel`1[Warehouse.Data.Model.LazyTableDataRow]" method="get_Count" line="0" />
<frame class="Warehouse.Presentation.WbpReportResult" method="visualizer_Initialized" line="0" />
<frame class="Warehouse.Presentation.Visualization.TableVisualizer" method="InitializeGrid" line="0" />
<frame class="Warehouse.Presentation.Visualization.TableVisualizer" method="OnListChanged" line="0" />
<frame class="Warehouse.Presentation.Visualization.TableVisualizer" method="ListChanged_GlibHandler" line="0" />
<frame class="GLib.Timeout+TimeoutProxy" method="Handler" line="0" />
</stackTrace>
</exception>
<exception type="System.Exception" message="MySql">
<stackTrace>
<frame class="Warehouse.Data.MySQL.DataProvider" method="ExecuteReader" line="0" />
<frame class="Warehouse.Data.Model.LazyListModel`1[Warehouse.Data.Model.LazyTableDataRow]" method="Worker" line="0" />
<frame class="Warehouse.Data.ThreadPool.JobWrapper" method="DoWork" line="0" />
</stackTrace>
</exception>
<exception type="MySql.Data.MySqlClient.MySqlException" message="Expression #11 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'DC-database-Joro.documents.PaymentType' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by">
<stackTrace>
<frame class="MySql.Data.MySqlClient.MySqlStream" method="ReadPacket" line="0" />
<frame class="MySql.Data.MySqlClient.NativeDriver" method="GetResult" line="0" />
</stackTrace>
</exception>
</exceptions>
</error>
</errors>

Имате ли идея, защо се получава? Благодаря предварително.
Върнете се в началото
Вижте профила на потребителя Изпратете лично съобщение
andrewa



Регистриран на: 01 Юли 2008
Мнения: 365
Местожителство: Пловдив

МнениеПуснато на: Вто Ное 07, 2017 23:28    Заглавие: Отговорете с цитат

Може би този пост ще помогне:
https://stackoverflow.com/questions/23921117/disable-only-full-group-by
Описанието:
"Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'DC-database-Joro.operations.OperType' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by">
загатва че този режим не се харесва. При мен СкладПро работи с MySQL база и в нея този режим не е активен:
MariaDB [(none)]> SELECT @@sql_mode;
+--------------------------------------------+
| @@sql_mode |
+--------------------------------------------+
| NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+--------------------------------------------+
1 row in set (0.13 sec)
Може би ако се издялка, както съветват в отговорите на въпроса в горния линк, и при Вас работата ще потръгне.
_________________
Материали, машини и технологии за рекламата - 24 години точност и коректност!
Върнете се в началото
Вижте профила на потребителя Изпратете лично съобщение Посетете сайта на потребителя
toniko



Регистриран на: 19 Мар 2010
Мнения: 40

МнениеПуснато на: Сря Ное 08, 2017 17:54    Заглавие: Отговорете с цитат

Здрасти, мисля, че се оправих с помощта на темата, която предложи.

sudo nano /etc/mysql/my.cnf

[mysqld]
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

След това спря да забива. Засега работи, дано да няма повече проблеми. Ако има ще пиша.
Върнете се в началото
Вижте профила на потребителя Изпратете лично съобщение
Виктор Павлов
Microinvest
Microinvest


Регистриран на: 12 Авг 2002
Мнения: 18119

МнениеПуснато на: Пон Ное 20, 2017 16:13    Заглавие: Отговорете с цитат

Темата е много интересна и дори нашите разработчици виждат полезни неща в нея.
_________________
Клиентите на Microinvest по света: http://www.microinside.ru
Върнете се в началото
Вижте профила на потребителя Изпратете лично съобщение Изпрати мейла Посетете сайта на потребителя
Покажи мнения от преди:   
Създайте нова тема   Напишете отговор    Microinvest Форум Форуми -> Warehouse Open за Linux All times are EET (Източна Европа)
Страница 1 от 1

 
Идете на:  
Не Можете да пускате нови теми
Не Можете да отговаряте на темите
Не Можете да променяте съобщенията си
Не Можете да изтривате съобщенията си
Не Можете да гласувате в анкети


Powered by phpBB © 2001, 2005 phpBB Group
Translation by: Boby Dimitrov