Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Joe Bordes
    @joebordes
    updated language translation. thanks!!
    probably have to update the service worker
    no, it isn't working there
    probably a PHP version issue
    I'll have a look when I have time but it is time to move that demo to a more up to date server
    Luke1982
    @Luke1982
    OK, no problem
    Joe Bordes
    @joebordes
    Luke1982
    @Luke1982
    Interesting. How is this memory limitation escaped on the corebos side?
    Joe Bordes
    @joebordes
    I don't remember if I do anything specific but we did hit memory exhaustion after 40-50K records
    I was thinking of using the rowGenerator to see if we can go futher
    but it has been in production for some months now and working well
    morning @all
    Luke1982
    @Luke1982
    Ah nice you took it into production?
    That is specifically meant for memory saving
    Morning!
    Joe Bordes
    @joebordes
    yes, it is part of coreBOS now
    Luke1982
    @Luke1982
    Great. Noticeable speed improvements?
    Joe Bordes
    @joebordes
    haven't done anything significant with it yet
    Luke1982
    @Luke1982
    I think something like listview would benefit the most. It yields the best results on larger datasets
    Joe Bordes
    @joebordes
    ideal for the streaming...
    Luke1982
    @Luke1982
    Yes, absolutely.
    Ranieri
    @slemernet
    hi @joebordes
    I created a lead report
    and that's produce a sql error
    [2021-09-08 09:37:16:054014{7276}] DB.INFO: :::: ["DB error Query Failed:SELECT vtiger_contactdetails.contactid FROM vtiger_contactdetails INNER JOIN vtiger_contactdetails as vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_contactdetails.contactid WHERE vtiger_crmentity.deleted=0 and (email=? or secondaryemail=?)::->[1052]Column 'email' in where clause is ambiguous"]
    Ranieri
    @slemernet
    [2021-09-08 09:36:46:830481{7275}] DB.DEBUG: > pquery CREATE TEMPORARY TABLE vtiger_reptmptbl_16138ae5ec9ce27481948780 AS SELECT vtiger_leaddetails.*,cf_1157,cf_1158,cf_1159,cf_1160,cf_1161,cf_1162,cf_1163,cf_1164,cf_1166,cf_1167,cf_1168,cf_1169,cf_1170,cf_1174,cf_1195,cf_1208,cf_1209,cf_1210,cf_1211,cf_1212,cf_1213,cf_1214,cf_1215,cf_1216,cf_1217,cf_1218,cf_1219,cf_1220,cf_1221,cf_1222,cf_1223,cf_1224,cf_1225,cf_1226,cf_1228,cf_1230,cf_1244,cf_1245,cf_1246 FROM vtiger_leaddetails INNER JOIN vtiger_leaddetails as vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_leaddetails.leadid AND vtiger_leaddetails.deleted=0 LEFT JOIN vtiger_leadscf ON vtiger_leadscf.leadid=vtiger_leaddetails.leadid :::: []
    [2021-09-08 09:36:46:877597{7275}] DB.DEBUG: > pquery ALTER TABLE vtiger_reptmptbl_16138ae5ec9ce27481948780 ADD INDEX (leadid) :::: []
    [2021-09-08 09:36:46:911243{7275}] DB.DEBUG: > pquery ALTER TABLE vtiger_reptmptbl_16138ae5ec9ce27481948780 ADD INDEX (rel_id) :::: []
    [2021-09-08 09:36:46:911571{7275}] DB.INFO: :::: ["DB error Query Failed:ALTER TABLE vtiger_reptmptbl_16138ae5ec9ce27481948780 ADD INDEX (rel_id)::->[1072]Key column 'rel_id' doesn't exist in table"]
    [2021-09-08 09:36:46:911619{7275}] DB.DEBUG: > pquery ALTER TABLE vtiger_reptmptbl_16138ae5ec9ce27481948780 ADD INDEX (activityid) :::: []
    [2021-09-08 09:36:46:911816{7275}] DB.INFO: :::: ["DB error Query Failed:ALTER TABLE vtiger_reptmptbl_16138ae5ec9ce27481948780 ADD INDEX (activityid)::->[1072]Key column 'activityid' doesn't exist in table"]
    [2021-09-08 09:36:46:911858{7275}] DB.DEBUG: ReportRun :: sGetSQLforReport 29 :::: []
    Joe Bordes
    @joebordes
    will look into it and get back to you
    can you share the screen shots of the steps?
    modules and columns selected for the report
    so I can try to reproduce easier
    Ranieri
    @slemernet
    Sure
    image.png
    image.png
    image.png
    image.png
    image.png
    image.png
    image.png
    image.png
    Ranieri
    @slemernet
    image.png
    Ranieri
    @slemernet
    hi @joebordes
    I made a fresh install and for purchase order, in picklist
    system show #empty# and for frenquency, first value not translate "--none--" only in that picklist
    image.png
    Ranieri
    @slemernet
    sales order - lang translation pr_br
    Ranieri
    @slemernet
    I translated my tax names in tax setting, but in sales orders, system not shows translated
    TaxNotTranslated.png
    TaxTranslated.png