@peopleinside
Hi and thank you both for the time you spend on my problem.
I managed to find a solution by editing the initialization of tinyMCE in ticket.html.twig & savedReplyForm.html.twig
I added the lines
sfTinyMce.init({
...
entity_encoding: "raw",
forced_root_block : "",
...
and now the greek text is saved as readable text in the db.
Cheers!
@peopleinside Yes, the problem is with greek text when entered in the html-editor.
I have not tried to import the backup to the db,
The export made is for reporting and backup of the tickets.
The 'message' field in the 'Create New Ticket' modal is plain text instead of tinyMCE, can i maybe alter the 'message' field code in the 'Edit Ticket' & 'Reply to ticket' Forms to also not load the tinyMCE editor?
Thank you for your time.
The error is resolved if you revert back edits suggested from the developer?
Yes.
Maybe you are having issue for a not fully correct resume of your existing install? Is restored from a database import?
Sorry, i'm not sure what you mean here. The installation is 1.0.18 done through the web installation wizard.
@peopleinside I click on 'Edit Ticket', the modal appears, but the Update button does nothing & i get the error in the browser console.
Same for leaving a reply: The 'Reply' button does nothing & i get the error.
The db is MySQL 8.0.24
@peopleinside said in Html entities in the database.:
php bin/console c:c
I tried clearing the cache both ways, but i still get when the ticket page loads:
Uncaught ReferenceError: sfTinyMce is not defined
at 409:4210
Uncaught TypeError: sfTinyMceNew2.init is not a function
at InitTinyMce (409:4230)
at r.initialize (409:3103)
at r.e.View (backbone.js:1300)
at new r (backbone.js:2060)
at HTMLDocument.<anonymous> (409:4180)
at e (jquery.min.js:2)
at t (jquery.min.js:2)
and when i try to edit a ticket message
Uncaught ReferenceError: tinyMCE is not defined
at r.fn (409:2826)
at Object.fn (backbone-validation-min.js:8)
at nr (underscore-min.js:6)
at Object.<anonymous> (underscore-min.js:6)
at Object.fn (underscore-min.js:6)
at backbone-validation-min.js:8
at r (underscore-min.js:6)
at Function.<anonymous> (underscore-min.js:6)
at i (backbone-validation-min.js:8)
at r.<anonymous> (backbone-validation-min.js:8)
Now, i get an error when i try to edit a message or add an answer
Uncaught ReferenceError: tinyMCE is not defined
So if you will export Database you will simply receive all HTMl with content.
Yes, that would be ok with english text, but greek text is unreadable when inside html in the database because it's saved as html entities: όνομα -> '& Omicron;& Nu;& Omicron;& Mu;& Alpha;' .
And so the export is also unreadable.
Can i disable the html editor in the ticket message field and enter plain text instead?
Thank you.
Hi,
When an agent enters greek text in the html editor in the ticket message field, the text is saved as html entities in the db (& Omicron;& Nu;& Omicron;& Mu;& Alpha; etc...).
This causes a problem when we want to export the data directly from the mysql. Is there a workaround for this?
Can we maybe completely disable the html editor and enter only plain text in every field?
Thank you & a Happy New Year!