Comments (7)
Wie gesagt: NO_ZERO_DATE und ONLY_FULL_GROUP_BY muss aus sein. Und das ist default von MySQL 5.7.
from berlicrm.
please read the installation guide -> https://blog.crm-now.de/doc/berliCRM/installation/Installation_berlicrm.html
PHP 7.3 is not supported yet
from berlicrm.
from berlicrm.
Ich habe nun auf PHP 7.2 umgestellt.
Schon beim Login kommt der erste Fehler:
array (
0 =>
array (
'file' => '/mnt/var/customers/webs/medartmedia/crm.medart-media.de/include/database/PearDatabase.php',
'line' => 365,
'function' => 'checkError',
),
1 =>
array (
'file' => '/mnt/var/customers/webs/medartmedia/crm.medart-media.de/modules/Users/models/Module.php',
'line' => 169,
'function' => 'pquery',
),
2 =>
array (
'file' => '/mnt/var/customers/webs/medartmedia/crm.medart-media.de/modules/Users/actions/Login.php',
'line' => 52,
'function' => 'saveLoginHistory',
),
3 =>
array (
'file' => '/mnt/var/customers/webs/medartmedia/crm.medart-media.de/includes/main/WebUI.php',
'line' => 228,
'function' => 'process',
),
4 =>
array (
'file' => '/mnt/var/customers/webs/medartmedia/crm.medart-media.de/index.php',
'line' => 18,
'function' => 'process',
),
)Query Failed:INSERT INTO vtiger_loginhistory (user_name, user_ip, logout_time, login_time, status) VALUES (?,?,?,?,?)::ADODB error Query Failed:INSERT INTO vtiger_loginhistory (user_name, user_ip, logout_time, login_time, status) VALUES (?,?,?,?,?)::->Incorrect datetime value: '0000-00-00 00:00:00' for column 'logout_time' at row 1
Beim Versuch eines Update irgendeinen Eintrags (in dem Fall ein Lead), kommt folgender Fehler:
array (
0 =>
array (
'file' => '/mnt/var/customers/webs/medartmedia/crm.medart-media.de/include/database/PearDatabase.php',
'line' => 365,
'function' => 'checkError',
),
1 =>
array (
'file' => '/mnt/var/customers/webs/medartmedia/crm.medart-media.de/data/CRMEntity.php',
'line' => 416,
'function' => 'pquery',
),
2 =>
array (
'file' => '/mnt/var/customers/webs/medartmedia/crm.medart-media.de/data/CRMEntity.php',
'line' => 87,
'function' => 'insertIntoEntityTable',
),
3 =>
array (
'file' => '/mnt/var/customers/webs/medartmedia/crm.medart-media.de/data/CRMEntity.php',
'line' => 846,
'function' => 'saveentity',
),
4 =>
array (
'file' => '/mnt/var/customers/webs/medartmedia/crm.medart-media.de/modules/Vtiger/models/Module.php',
'line' => 143,
'function' => 'save',
),
5 =>
array (
'file' => '/mnt/var/customers/webs/medartmedia/crm.medart-media.de/modules/Vtiger/models/Record.php',
'line' => 230,
'function' => 'saveRecord',
),
6 =>
array (
'file' => '/mnt/var/customers/webs/medartmedia/crm.medart-media.de/modules/Vtiger/actions/Save.php',
'line' => 49,
'function' => 'save',
),
7 =>
array (
'file' => '/mnt/var/customers/webs/medartmedia/crm.medart-media.de/modules/Vtiger/actions/Save.php',
'line' => 27,
'function' => 'saveRecord',
),
8 =>
array (
'file' => '/mnt/var/customers/webs/medartmedia/crm.medart-media.de/modules/Leads/actions/Save.php',
'line' => 21,
'function' => 'process',
),
9 =>
array (
'file' => '/mnt/var/customers/webs/medartmedia/crm.medart-media.de/includes/main/WebUI.php',
'line' => 228,
'function' => 'process',
),
10 =>
array (
'file' => '/mnt/var/customers/webs/medartmedia/crm.medart-media.de/index.php',
'line' => 18,
'function' => 'process',
),
)Query Failed:select * from vtiger_field where tabid in (?) and tablename=? and displaytype in (1,3) and presence in (0,2) group by columnname::ADODB error Query Failed:select * from vtiger_field where tabid in (?) and tablename=? and displaytype in (1,3) and presence in (0,2) group by columnname::->Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'medartmediasql8.vtiger_field.fieldid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
from berlicrm.
Hallo, da sind offenbar Einstellungen des SQL-Servers zu strikt:
-
NO_ZERO_DATE muss aus sein: https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_no_zero_date
-
ONLY_FULL_GROUP_BY muss aus sein: https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_only_full_group_by
Wo kommt denn diese Konfiguration des sql-Servers her? Ist die individuell oder default irgendeiner bestimmten Distribution?
Viele Grüße
from berlicrm.
Das ist eine stinknormale Ubuntu 18.04 Installation auf einem Server bei Hetzner Cloud, die Configs komplett unverändert. Falls nötig, kann ich dort gerne einen Server für euch zum Testen anlegen.
Edit:
SELECT @@SESSION.sql_mode:
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
from berlicrm.
Durch das korrekte Setzen des SQL-mode ist der Fehler nun komplett verschwunden. Alles funktioniert, wie es soll.
Bleibt nur die Frage, ob man es irgendwie hinbekommt, dass BerliCRM auch mit dem Default-MySQL klarkommt oder ob man ggf. die Installationsanweisung ändern muss. Ansich gibt es ja schon einen Grund, warum der SQL-mode so vorgesehen ist. Das einfach abzustellen, ist ja eigentlich nicht Sinn der Sache.
from berlicrm.
Related Issues (20)
- File Upload by extended create HOT 2
- Can not save calendar feed type HOT 2
- Quick create calendar fail HOT 1
- Installation stuck at "initializing database"? HOT 7
- Widget History HOT 2
- Install error HOT 3
- E-Mails with Ataments are not showing as send with Outlook HOT 7
- Filter date conditions for listview
- Calendar Commits will get Error on non Admin User HOT 2
- Workflow Conditions changed with more than hours later HOT 6
- Feature Requests for HelpDesk and Calendar
- Bithday from Contactrs not Showing up in Calendar HOT 10
- Reelated to Fields are missing HOT 1
- ModComments Bug no reply Tree View with Latest Code HOT 6
- Feature request: add attachments to calendar activities
- Einrichtung eines Mailpostfaches funktioniert nicht HOT 28
- Einrichtung des Mail Managers wirft Fehler HOT 2
- incompatible default sql_mode "STRICT_TRANS_TABLES" for MariaDB >= 10.2.4 partially breaks operation
- Installation instructions still up to date? HOT 1
- Data Import BUG HOT 9
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from berlicrm.