Hello first of all I am really impressed with the software great job
There is a small problem we are facing and I think its not that difficult to fix but I dont know which part of code to change
When adding a new file attachment in notes if the filename is in English it works perfectly but if the filename is in unicode characters there are some php errors occuring

Type: E_USER_ERROR (256)
Message: mysqlt error: [1366: Incorrect string value: '\xCE_\xCE\xBF\xCF\x83...' for column 'original' at row 1] in EXECUTE("INSERT INTO utils_attachment_file(attach_id,original,created_by) VALUES(19,'�_οσοσ�_�_�_�_�_�_�_�_�_οσ�_�_�_�_�__3.pdf',1)")
File: C:\inetpub\wwwroot\office\libs\adodb\adodb-errorhandler.inc.php
Line=77
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "mysqlt error: [1366: Incorrect string value: '\xCE_\xCE\xBF\xCF\x83...' for column 'original' at row 1] in EXECUTE(\"INSERT INTO utils_attachment_file(attach_id,original,created_by) VALUES(19,'�_οσοσ�_�_�_�_�_�_�_�_�_οσ�_�_�_�_�__3.pdf',1)\") ", "C:\inetpub\wwwroot\office\libs\adodb\adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1366, "Incorrect string value: '\xCE_\xCE\xBF\xCF\x83...' for column 'original' at row 1", "INSERT INTO utils_attachment_file(attach_id,original,created_by) VALUES(19,'�_οσοσ�_�_�_�_�_�_�_�_�_οσ�_�_�_�_�__3.pdf',1)", false, Object (ADODB_mysqlt), "INSERT INTO utils_attachment_file(attach_id,original,created_by) VALUES(19,'�_οσοσ�_�_�_�_�_�_�_�_�_οσ�_�_�_�_�__3.pdf',1)", false, "mysqlt error: [1366: Incorrect string value: '\xCE_\xCE\xBF\xCF\x83...' for column 'original' at row 1] in EXECUTE(\"INSERT INTO utils_attachment_file(attach_id,original,created_by) VALUES(19,'�_οσοσ�_�_�_�_�_�_�_�_�_οσ�_�_�_�_�__3.pdf',1)\") "))

File: C:\inetpub\wwwroot\office\libs\adodb\adodb-errorhandler.inc.php
line 77
function called: trigger_error("mysqlt error: [1366: Incorrect string value: '\xCE_\xCE\xBF\xCF\x83...' for column 'original' at row 1] in EXECUTE(\"INSERT INTO utils_attachment_file(attach_id,original,created_by) VALUES(19,'�_οσοσ�_�_�_�_�_�_�_�_�_οσ�_�_�_�_�__3.pdf',1)\") ", 256)

File: C:\inetpub\wwwroot\office\libs\adodb\adodb.inc.php
line 1074
function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 1366, "Incorrect string value: '\xCE_\xCE\xBF\xCF\x83...' for column 'original' at row 1", "INSERT INTO utils_attachment_file(attach_id,original,created_by) VALUES(19,'�_οσοσ�_�_�_�_�_�_�_�_�_οσ�_�_�_�_�__3.pdf',1)", false, "Object (ADODB_mysqlt)")

File: C:\inetpub\wwwroot\office\libs\adodb\adodb.inc.php
line 1030
function called: _Execute("INSERT INTO utils_attachment_file(attach_id,original,created_by) VALUES(19,'�_οσοσ�_�_�_�_�_�_�_�_�_οσ�_�_�_�_�__3.pdf',1)")

[PHP core called function]
function called: Execute("INSERT INTO utils_attachment_file(attach_id,original,created_by) VALUES(?,?,?)", Array (19, "�_οσοσ�_�_�_�_�_�_�_�_�_οσ�_�_�_�_�__3.pdf", 1))

File: C:\inetpub\wwwroot\office\include\database.php
line 344
function called: call_user_func_array(Array (Object (ADODB_mysqlt), "Execute"), Array ("INSERT INTO utils_attachment_file(attach_id,original,created_by) VALUES(?,?,?)", Array (#3)))

File: C:\inetpub\wwwroot\office\modules\Utils\Attachment\AttachmentCommon_0.php
line 115
function called: Execute("INSERT INTO utils_attachment_file(attach_id,original,created_by) VALUES(%d,%s,%d)", Array ("19", "�_οσοσ�_�_�_�_�_�_�_�_�_οσ�_�_�_�_�__3.pdf", "1"))

File: C:\inetpub\wwwroot\office\modules\Utils\Attachment\AttachmentCommon_0.php
line 710
function called: add_file("19", "1", "�_οσοσ�_�_�_�_�_�_�_�_�_οσ�_�_�_�_�__3.pdf", "data/Utils_Attachment/temp/1\�_οσοσ�_�_�_�_�_�_�_�_�_οσ�_�_�_�_�__3.pdf")

[PHP core called function]
function called: submit_attachment(Array (#15), "added")

File: C:\inetpub\wwwroot\office\modules\Utils\RecordBrowser\RecordBrowserCommon_0.php
line 914
function called: call_user_func(Array ("Utils_AttachmentCommon", "submit_attachment"), Array (#15), "added")

File: C:\inetpub\wwwroot\office\modules\Utils\RecordBrowser\RecordBrowserCommon_0.php
line 975
function called: record_processing("utils_attachment", Array (#15), "added")

File: C:\inetpub\wwwroot\office\modules\Utils\RecordBrowser\RecordBrowser_0.php
line 1264
function called: new_record("utils_attachment", Array (#15))

[PHP core called function]
function called: view_entry("add", null, Array (0, "a:2:{i:0;s:25:\"Utils_RecordBrowserCommon\";i:1;s:27:\"create_default_linked_label\";}", "a:2:{i:0;s:16:\"premium_projects\";i:1;i:1;}", "premium_projects/1"))

File: C:\inetpub\wwwroot\office\include\module.php
line 793
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "view_entry"), Array ("add", null, Array (#4)))

File: C:\inetpub\wwwroot\office\include\module.php
line 713
function called: get_html_of_module(Object (Utils_RecordBrowser), Array ("add", null, Array (#4)), "view_entry")

File: C:\inetpub\wwwroot\office\modules\Base\Box\Box_0.php
line 142
function called: display_module("Object (Utils_RecordBrowser)", Array ("add", null, Array (#4)), "view_entry")

File: C:\inetpub\wwwroot\office\include\epesi.php
line 241
function called: body()

File: C:\inetpub\wwwroot\office\include\epesi.php
line 286
function called: go(Object (Base_Box))

File: C:\inetpub\wwwroot\office\process.php
line 35
function called: process("_qf__libs_qf_ac7449afa706163d3f4103282ba23c10=&submited=1&delete_files=&clipboard_files=&title=&permission=0¬e=&sticky=0&__action_module__=%2FBase_Box%7C0%2FUtils_RecordBrowser%7Ca496880b196019da423076b5386e47fb_r", "")

as you can see the filename is not parsed correctly to the system "strange characters"... while a small part is parsed

anyway thanks a lot

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge