Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Joe Bordes
    @joebordes
    you have an error in the call that is saving the password
    capture the network call and share the result
    Ranieri
    @slemernet
    Hi @joebordes
    Never mind, I think cert ssl, error, cause that. I solved that and problem not occurs
    When my user generated reported, system add module in column
    like that
    ErrorReport.jpeg
    it´s possible show only data, without module name? contacts:::
    Ranieri
    @slemernet

    hi @joebordes i am follow discussion about branding in invoice

    there any way shows different company logo, for each user?

    Ranieri
    @slemernet
    hi @joebordes
    I think in mysql 8 not have problem with emoticons in string tickets
    But I have that error
    [2022-07-29 13:41:14:444322{2581}] DB.DEBUG: > pquery insert into vtiger_crmentity (crmid,smcreatorid,smownerid,setype,description,modifiedby,createdtime,modifiedtime,cbuuid) values(?,?,?,?,?,?,?,?,?) :::: []
    [2022-07-29 13:41:14:444343{2581}] DB.DEBUG: parameters :::: [26824,"10","10","HelpDesk","Comprei 2 géis e endureceu entrei em contato com vocês e fizeram a troca, Mas aí o que chegaram também estão duro.😭\r\n\r\nPink natural e nude chic","10","2022-07-29 13:41:14","2022-07-29 13:41:14","aeca3bd11d0eee5021873d93d14bdad7ab2a6f2e"]
    Joe Bordes
    @joebordes
    hi
    that is great
    glad they got around to fixing it
    using UTF8MB4 or bigger is probably the trick
    any way shows different company logo, for each user?
    you could try adding an image field on the user (or using the one that is there) and then using that field to indicate the {image} directive
    Joe Bordes
    @joebordes
    it´s possible show only data, without module name? contacts:::
    what module is that? I can't reproduce it
    Ranieri
    @slemernet
    sorry i forgot mentioned, works if your user is admin
    Ranieri
    @slemernet
    and field relation to, with also modified into graphics interface, with more than on module
    Ranieri
    @slemernet

    it´s possible show only data, without module name? contacts:::

    report module tickets, and contacts, and accounts

    Joe Bordes
    @joebordes
    Ranieri
    @slemernet
    nice job!
    @joebordes let me ask you about that
    In past i set in my system GV Document_CreateSelectContactFolder for system create one folder for each contact
    but user after same time, not use more that, and put your files in default folder
    but becase system create many folders, now when user select docment module, that module in extremelly slowly to execute
    I turn debub on and I see

    SELECT vtiger_notes.note_no, vtiger_notes.title, vtiger_notes.filename, vtiger_crmentity.modifiedtime, vtiger_crmentity.smownerid, vtiger_notes.filelocationtype, vtiger_notes.filestatus, vtiger_notes.notesid FROM vtiger_notes INNER JOIN vtiger_crmentity ON vtiger_notes.notesid = vtiger_crmentity.crmid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid LEFT JOIN vtiger_attachmentsfolder ON vtiger_notes.folderid = vtiger_attachmentsfolder.folderid WHERE vtiger_crmentity.deleted=0 AND vtiger_notes.notesid > 0 and vtiger_notes.folderid = 1 LIMIT 0, 20

    SELECT vtiger_notes.note_no, vtiger_notes.title, vtiger_notes.filename, vtiger_crmentity.modifiedtime, vtiger_crmentity.smownerid, vtiger_notes.filelocationtype, vtiger_notes.filestatus, vtiger_notes.notesid FROM vtiger_notes INNER JOIN vtiger_crmentity ON vtiger_notes.notesid = vtiger_crmentity.crmid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid LEFT JOIN vtiger_attachmentsfolder ON vtiger_notes.folderid = vtiger_attachmentsfolder.folderid WHERE vtiger_crmentity.deleted=0 AND vtiger_notes.notesid > 0 and vtiger_notes.folderid = 2 LIMIT 0, 20

    SELECT vtiger_notes.note_no, vtiger_notes.title, vtiger_notes.filename, vtiger_crmentity.modifiedtime, vtiger_crmentity.smownerid, vtiger_notes.filelocationtype, vtiger_notes.filestatus, vtiger_notes.notesid FROM vtiger_notes INNER JOIN vtiger_crmentity ON vtiger_notes.notesid = vtiger_crmentity.crmid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid LEFT JOIN vtiger_attachmentsfolder ON vtiger_notes.folderid = vtiger_attachmentsfolder.folderid WHERE vtiger_crmentity.deleted=0 AND vtiger_notes.notesid > 0 and vtiger_notes.folderid = 3 LIMIT 0, 20

    SELECT vtiger_notes.note_no, vtiger_notes.title, vtiger_notes.filename, vtiger_crmentity.modifiedtime, vtiger_crmentity.smownerid, vtiger_notes.filelocationtype, vtiger_notes.filestatus, vtiger_notes.notesid FROM vtiger_notes INNER JOIN vtiger_crmentity ON vtiger_notes.notesid = vtiger_crmentity.crmid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid LEFT JOIN vtiger_attachmentsfolder ON vtiger_notes.folderid = vtiger_attachmentsfolder.folderid WHERE vtiger_crmentity.deleted=0 AND vtiger_notes.notesid > 0 and vtiger_notes.folderid = 4 LIMIT 0, 20

    SELECT vtiger_notes.note_no, vtiger_notes.title, vtiger_notes.filename, vtiger_crmentity.modifiedtime, vtiger_crmentity.smownerid, vtiger_notes.filelocationtype, vtiger_notes.filestatus, vtiger_notes.notesid FROM vtiger_notes INNER JOIN vtiger_crmentity ON vtiger_notes.notesid = vtiger_crmentity.crmid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid LEFT JOIN vtiger_attachmentsfolder ON vtiger_notes.folderid = vtiger_attachmentsfolder.folderid WHERE vtiger_crmentity.deleted=0 AND vtiger_notes.notesid > 0 and vtiger_notes.folderid = 5 LIMIT 0, 20

    SELECT vtiger_notes.note_no, vtiger_notes.title, vtiger_notes.filename, vtiger_crmentity.modifiedtime, vtiger_crmentity.smownerid, vtiger_notes.filelocationtype, vtiger_notes.filestatus, vtiger_notes.notesid FROM vtiger_notes INNER JOIN vtiger_crmentity ON vtiger_notes.notesid = vtiger_crmentity.crmid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid LEFT JOIN vtiger_attachmentsfolder ON vtiger_notes.folderid = vtiger_attachmentsfolder.folderid WHERE vtiger_crmentity.deleted=0 AND vtiger_notes.notesid > 0 and vtiger_notes.folderid = 6 LIMIT 0, 20

    SELECT vtiger_notes.note_no, vtiger_notes.title, vtiger_notes.filename, vtiger_crmentity.modifiedtime, vtiger_crmentity.smownerid, vtiger_notes.filelocationtype, vtiger_notes.fil

    manySelectinDocuments.png
    Ranieri
    @slemernet
    How I can solved that?
    It´s possible changed all folders to default ? If yes, that changed will affect could be broken document relation? My user normmaly include document in contatcs, cobro pago, service contracts.
    Ranieri
    @slemernet
    Hi @joebordes how are you
    In your "magic toolbox" you have any script for I changed size with custom field, type text?
    Joe Bordes
    @joebordes
    hi
    all good, you?
    can't you just change the size with phpmyadmin?
    Ranieri
    @slemernet

    i think that would be a problem

    so it's simple

    Joe Bordes
    @joebordes
    if you make a text field bigger mysql has no issues
    and coreBOS doesn't either
    making it smaller may be an issue
    Ranieri
    @slemernet
    and now for checking size in input time, need add a business map, right?
    Joe Bordes
    @joebordes
    no
    by default coreBOS will not let you save a text field with a value bigger than defined in the database
    you don't have to do anything
    at most, try it
    and let me know if it doesn't stop you