Search found 24 matches

by pquotto
Fri Dec 19, 2025 2:52 pm
Forum: Installation & Upgrades
Topic: Installation in docker environnement
Replies: 1
Views: 24210

Re: Installation in docker environnement

Did you ever dockerize this software?

Thanks
by pquotto
Fri Dec 19, 2025 2:26 pm
Forum: Installation & Upgrades
Topic: 25.04: cannot add new import profile
Replies: 7
Views: 13554

Re: 25.04: cannot add new import profile

It wasnt failing with the modified tomcat/conf/server.xml anymore. Thread can be closed.
by pquotto
Fri Dec 19, 2025 2:00 pm
Forum: Installation & Upgrades
Topic: CSV Import fails with "user_status" cannot be null
Replies: 28
Views: 58357

Re: CSV Import fails with "user_status" cannot be null

Do you still have access to the .ova files and can share them? I want to test the migration on the .ova files to make sure its not some setting on my servers. I have access to 22.10, 24.04, 24.10 and 25.04 but I am missing 20.04, 20.10, 21.04, 21.10, 22.04 and 23.x. So far I did not test any upgrade...
by pquotto
Fri Dec 19, 2025 12:00 pm
Forum: Installation & Upgrades
Topic: CSV Import fails with "user_status" cannot be null
Replies: 28
Views: 58357

Re: CSV Import fails with "user_status" cannot be null

user_status = NULL would fix it for the databse. But what would a casted value of NULL mean for the customer? Its also wierd that while debugging I dont see where a "NULL" value would be. SELECT event_time, argument FROM mysql.general_log WHERE argument LIKE '%tmp_imp%' AND DATE(event_time...
by pquotto
Fri Dec 19, 2025 10:57 am
Forum: Installation & Upgrades
Topic: CSV Import fails with "user_status" cannot be null
Replies: 28
Views: 58357

Re: CSV Import fails with "user_status" cannot be null

My system 24.10.000.167 DESC customer_1_binding_tbl; +------------------+------------------+------+-----+---------------------+-------------------------------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------------------+------------------...
by pquotto
Thu Dec 18, 2025 1:55 pm
Forum: Installation & Upgrades
Topic: CSV Import fails with "user_status" cannot be null
Replies: 28
Views: 58357

Re: CSV Import fails with "user_status" cannot be null

Does the mapping contain all fields which are present in the import file? Yes. https://imgur.com/a/pgQ9bXU The logs are from this system: ================================================= = OpenEMM Maintenance Tool (OMT) v24.10.000.036 = ================================================= Hostname: -...
by pquotto
Thu Dec 18, 2025 12:57 pm
Forum: Installation & Upgrades
Topic: CSV Import fails with "user_status" cannot be null
Replies: 28
Views: 58357

Re: CSV Import fails with "user_status" cannot be null

Here is the test import profile. Import profile: "Test" (ID: 2) Character set: UTF-8 Headings in first row: true Zipped file: false Zip password: false Automatic mapping: false Separator: , Text recognition character: NONE Decimal separator: . Date format: dd.MM.yyyy HH:mm HtmlTagCheck: no...
by pquotto
Thu Dec 18, 2025 12:37 pm
Forum: Installation & Upgrades
Topic: CSV Import fails with "user_status" cannot be null
Replies: 28
Views: 58357

Re: CSV Import fails with "user_status" cannot be null

It should be the one from the first page. This is the latest: [ WARN] (WorkerExecutorService-emm-thread-#2) Error: 1048-23000: Column 'user_status' cannot be null 2025-12-17 17:09:12,828: ERROR [WorkerExecutorService-emm-thread-#2] org.agnitas.dao.impl.ImportRecipientsDaoImpl - Error: PreparedStatem...
by pquotto
Wed Dec 17, 2025 5:13 pm
Forum: Installation & Upgrades
Topic: CSV Import fails with "user_status" cannot be null
Replies: 28
Views: 58357

Re: CSV Import fails with "user_status" cannot be null

I still didnt manage to import multiple CSVs on any version past 22.10. This is error logs from 24.10.000.167. I've activated debug logging in mysql, but its not very clear to me how it shows me the error: SET GLOBAL log_warnings = 2; SET GLOBAL general_log = ON; SET GLOBAL log_output = 'TABLE'; SEL...
by pquotto
Wed Dec 17, 2025 2:20 pm
Forum: Installation & Upgrades
Topic: 25.04: cannot add new import profile
Replies: 7
Views: 13554

Re: 25.04: cannot add new import profile

Just reporting my findings: Now I am using the .ova file for testing, its filename is "OpenEMM-25.04.000.124.ova". I've just imported it fresh into Virtualbox. I've set a new password for user "root" (default: OpenEMM) and tried starting OpenEMM with the "openemm" user....
by pquotto
Tue Sep 30, 2025 1:27 pm
Forum: Installation & Upgrades
Topic: CSV Import fails with "user_status" cannot be null
Replies: 28
Views: 58357

Re: CSV Import fails with "user_status" cannot be null

From which version of OpenEMM do you come initially? Is "uupload_tb" a typo from your side? But "upload_tbl" is not part of OpenEMM either. "uupload_tb" is from the json file you gave me to download. I am not sure where its coming from, when it isnt from OpenEMM. The p...
by pquotto
Mon Sep 29, 2025 3:40 pm
Forum: Installation & Upgrades
Topic: CSV Import fails with "user_status" cannot be null
Replies: 28
Views: 58357

Re: CSV Import fails with "user_status" cannot be null

I have diffed my table now, and this is the result: { "obsoleteTables" : [ "triggerdlg_fields_tbl", "mailtrack_process_tbl", "upload_tbl", "webservice_user_backup_tbl", "mailtrack_process_hk_tbl" ], "missingTables" : [ "uuplo...
by pquotto
Fri Sep 12, 2025 12:44 pm
Forum: Installation & Upgrades
Topic: 25.04: cannot add new import profile
Replies: 7
Views: 13554

Re: 25.04: cannot add new import profile

The above text was with version 25.04.000.145, but I can confirm I have the same issue with 25.04.000.171.
by pquotto
Fri Sep 12, 2025 12:31 pm
Forum: Installation & Upgrades
Topic: CSV Import fails with "user_status" cannot be null
Replies: 28
Views: 58357

Re: CSV Import fails with "user_status" cannot be null

Hey, where can I find the schematic file?
by pquotto
Fri Sep 12, 2025 12:30 pm
Forum: Development
Topic: OpenEMM 25.04 code
Replies: 2
Views: 16282

Re: OpenEMM 25.04 code (solved)

Thank you :)