vtiger CRM 5.0.4 validation testbuild II
  • Hi vtigers,

    First we thank you all for the great support you have provided to us in the validation of the vtigerCRM 5.0.4 test build. We kindly request you to provide us with the same help in the validation of the vtigerCRM 5.0.4 test build II.

    In this build we have focussed mainly on the security issues to avoid the sql injection attacks. For this we have changed most of the SQL statements to Prepared Statements. Some of the other major issues that we have addressed are as follows:

    1. Selective Export of Records
    2. Import/Export functionalities for Trouble Tickets & Vendors module
    3. Outgoing Server configuration with Gmail SMTP
    4. UTF-8 support for WebMail
    5. FTP Backup Script Fix
    6. Migration Support
    7. HTML Based E-mail Templates
    8. Role based PickList

    and many more (Refer the Release Notes)

    Kindly post your valuable feedbacks and suggestions to us.

    NOTE: This is a development build released only for testing purposes and not meant to be used in production.

    Release Notes:
    http://wiki.vtiger.com/index.php/Vtiger ... ease_Notes

    5.0.4 Online Demo: http://en.vtiger.com/wip/

    Download URL's for vtigerCRM 5.0.4 validation build II

    .exe package
    http://64.14.15.24/archives/validation- ... uild-2.exe

    .zip source
    http://64.14.15.24/archives/validation- ... d-2.tar.gz

    .bin package
    http://64.14.15.24/archives/validation- ... uild-2.bin

    Firefox plugin
    http://64.14.15.24/archives/validation- ... uild-2.xpi

    Office plugin
    http://64.14.15.24/archives/validation- ... uild-2.exe

    Outlook plugin
    http://64.14.15.24/archives/validation- ... uild-2.exe

    Thunderbird plugin
    http://64.14.15.24/archives/validation- ... uild-2.xpi

    Customer Portal
    http://64.14.15.24/archives/validation- ... uild-2.zip

    Webforms
    http://64.14.15.24/archives/validation- ... uild-2.zip

    SVN Source
    http://trac.vtiger.com/svn/vtiger/vtige ... -5.0.4-rc4

    Patch from 5.0.0 to 5.0.4 testbuild2
    http://64.14.15.24/archives/validation- ... uild-2.zip

    Patch from 5.0.3 to 5.0.4 testbuild2
    http://64.14.15.24/archives/validation- ... uild-2.zip

    Thanks & Regards,
    Prasad
    vtiger Team
  • 42 Comments sorted by
  • the e-mail templates in the admin section have got a option to make the new template you make either public or private.

    but as you have to be an admin to make one, only admins can have their own custom made templates in the private folder.

    or have i missed something?
  • hi audiopleb,

    you are right. only admin has the ability to mark an email template as private or public.

    few of the use cases i could think with this feature are:
    1. create email template drafts and make it available to all once it is complete.
    2. mark obsolete email templates a private.

    regards,
    prasad
    vtiger team
  • i would have thought a much better idea would be to have everyone able to create templates so that each individual can create their own e-mail signature which they would mark as private.
  • hi audiopleb,

    great! we would like to provide such features going forward.

    regards,
    prasad
    vtiger team
  • excellent! are you going to add it to trac as an enhancement request?

    thanks.

    john
  • new changes kill utf-8 reading from dbase.
    rev. 11383 - ok
    rev.11539 (about) - bad

    see:
    http://en.vtiger.com/wip/index.php?action=detailview&module=helpdesk&record=141&parenttab=support

    ======================
    jagi

    http://vtiger.artcode.eu
  • installation was ok, however the following need to be rectified ( jpg is attached)
    =======================================
    notice: undefined offset: 1 in /opt/lampp/htdocs/vtigercrm/modules/system/includes/os/class.linux.inc.php on line 106

    warning: division by zero in /opt/lampp/htdocs/vtigercrm/modules/system/includes/os/class.linux.inc.php on line 476

    notice: undefined variable: results in /opt/lampp/htdocs/vtigercrm/modules/system/includes/os/class.parseprogs.inc.php on line 129


    warning: division by zero in /opt/lampp/htdocs/vtigercrm/modules/system/includes/xml/filesystems.php on line 128
    errors
    file line command message
    common_functions.php 176 /usr/bin/who busybox v1.2.2 (2006.12.07-15:23+0000) multi-call binary usage: who
    common_functions.php 176 /bin/df /bin/df: invalid option -- p busybox v1.2.2 (2006.12.07-15:23+0000) multi-call binary usage: df [-hmk] [filesystem ...]
    common_functions.php 176 /bin/df /bin/df: invalid option -- i busybox v1.2.2 (2006.12.07-15:23+0000) multi-call binary usage: df [-hmk] [filesystem ...]
    ========================================
  • hi well fighting vtiger team! how ever it seem to be some utf-8 problem as mentioned above. i note the following when i testing the wip 5.0.4.

    if add a new contact or what ever and first manually tells my browser (firefox) to use iso8859-1 and the keys in "å ä ö å ä ö ü ü ßß" in all fields and then press save then all is ok!!

    but.. if i use the standard setting utf-8 that vtiger tells the browser to use it all messes up...

    hope you can fix this rapidly and upload a new wip installation. otherwise i'm afraid that many tester/user will wondering whats happening. and search some where else to find a crm-system.

    regards
    /johan
  • hi,

    thanks a lot for trying the utf-8 support.

    we will focus our energy in getting utf-8 support to stability during this validation phase.

    please report any issues that you face with utf-8 to us.

    regards,
    prasad
    vtiger team
  • migration went fine without any errors. after login the home shows following error message
    fatal error: call to a member function fetchrow() on a non-object in d:\xampp\htdocs\4net_validation\include\database\peardatabase.php on line 388

    other modules are running fine.
  • hi eberled,

    migration went fine without any errors...


    can you please let us know you migrated from which vtiger version?

    regards,
    prasad
    vtiger team
  • hi prasad

    i migrated from version 5.0.3

    previously i compared the db with a clean 5.0.3 installation to ensure that i have a all tables etc. everything was ok.

    for installation i copied all 5.0.4 in a new directory and modified the config.inc.php. i had also to copy the files under user_privilegeds.

    afterwards i logged in as admin and run the migration. the migration showed only success messages.
  • hi,

    we found few places where utf-8 support was missed which showed up problems while displaying records.

    fix has been found to it and we will update the servers soon.

    kindly watch out for any other issues and let us know.

    regards,
    prasad
    vtiger team
  • hi,

    we missed in some places to include utf-8 support. due to this, problem occurred in displaying records.

    issue got fixed and also updated in demo server also.

    kindly include the following change in your setup also.

    file : include/utils/utils.php
    method : to_html()
    change :
    $string = htmlentities($string, ent_quotes);
    to
    $string = htmlentities($string, ent_quotes,"utf-8");

    kindly update us if you get any other issues.

    regards,
    prasad
    vtiger team
  • great improvement since last night!

    so far i found one utf-8 bug. when i create a new qoute the address fields becomes corrupted when the addresses is automatically populated from the customers addresses if it contains: "åäöåäöüüßßåäö " (see the wip installation)

    please don't forget to test the search fields for "your" tricky utf-8 character's.

    regards
    johah
  • sending of portal login information fails if the db was migrated.

    please see ticket http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/4463
  • fatal error on home still exists
  • hi,

    patch from 5.0.0 to 5.0.4 testbuild2
    http://64.14.15.24/archives/validation- ... uild-2.zip

    we will update you on patch from 5.0.3 to 5.0.4 testbuild2 soon. kindly bear with us.

    regards,
    prasad
    vtiger team
  • 1. utf-8 bug qoute
    "vtigersweden" said:

    so far i found one utf-8 bug. when i create a new qoute the address fields becomes corrupted when the addresses is automatically populated from the customers addresses if it contains: "åäöåäöüüßßåäö " (see the wip installation)
    regards
    johah


    i see that i have to add the following:
    ok if the address is fetched from the custommers address but not if it's fetched from the potential. but if i writes the address directly into the fields its ok.


    2. utf-8 bug purchase order
    as above, if a vendor address contains åäöåäöüüßßåäö utf-8 test and i add it to purchase order the address is messed up.

    3. utf-8 bug settings
    in "settings > custom field settings" you are not allowed to use: " utf-8 test åäöåäöüüßßåäö" as a label or in the label fields.

    4. utf-8 bug leads addresses
    ok for street but the other address fields not ok. they transforms like this when i save the adress:
    utf-8 test åäöåäöüüßßåäö->save->utf-8 test åäöåäöüüß��

    i have this error when i attempts to upload a "mail merge templates" whit file named åäöåäöüüßßåäö_utf-8_test.txt

    "warning: move_uploaded_file(/home/vtiger/demo/en/wip//test/upload/åäöåäöüüßßåäö_utf-8_test) [function.move-uploaded-file]: failed to open stream: permission denied in /home/vtiger/demo/en/wip/modules/settings/savewordtemplate.php on line 31

    warning: move_uploaded_file() [function.move-uploaded-file]: unable to move '/tmp/phpglrmdm' to '/home/vtiger/demo/en/wip//test/upload/åäöåäöüüßßåäö_utf-8_test' in /home/vtiger/demo/en/wip/modules/settings/savewordtemplate.php on line 31"

    i guess that that function is blocked at the wip or? could some one else try that on an local test installation?

    that all so far. will eat and countinue to test invoices.

    regards
    johan
  • hi johan,

    keep up the good work on product testing.

    regards,
    prasad
    vtiger team
  • hi johan,

    "warning: move_uploaded_file(/home/vtiger/demo/en/wip//test/upload/åäöåäöüüßßåäö_utf-8_test) [function.move-uploaded-file]: failed to open stream: permission denied in /home/vtiger/demo/en/wip/modules/settings/savewordtemplate.php on line 31

    warning: move_uploaded_file() [function.move-uploaded-file]: unable to move '/tmp/phpglrmdm' to '/home/vtiger/demo/en/wip//test/upload/åäöåäöüüßßåäö_utf-8_test' in /home/vtiger/demo/en/wip/modules/settings/savewordtemplate.php on line 31"

    we have added required permission now, this should not re-appear on wip. kindly let us know if it still persist.

    regards,
    prasad
    vtiger team
  • hi prasad
    i will test that soon. but if you please could check whats wrong with the wip for the moment. try to add a new invoice by clicking at the "+" and and save it. after that the invoice are missing the invoice number. may be thats why it's gone??

    i was trying to add a custom invoice number in the settings. maybe that's reason for this error.
    /johan
  • utf-8 invoice bugg popup ok
    add a new invoice
    -> use select to add a related account name
    ->pic one with a tricky name like åäöåäö
    bug1.
    now you get the question where the popup ask you if you like to overwrite the existing invoice address with the new ones. the error is utf-8 presentation of the name in the pop up
    -> press yes
    bug2.
    back at the invoice view the selected name is wrong.

    keep up:-)
    /johan
  • "vtigersweden" said:
    utf-8 invoice bugg popup ok
    add a new invoice
    -> use select to add a related account name
    ->pic one with a tricky name like åäöåäö
    bug1.
    now you get the question where the popup ask you if you like to overwrite the existing invoice address with the new ones. the error is utf-8 presentation of the name in the pop up
    -> press yes
    bug2.
    back at the invoice view the selected name is wrong.

    keep up:-)
    /johan


    hi johan,

    this has been added to our bug tracker, kindly find the details
    http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/4464

    regards,
    prasad
    vtiger team
  • "vtigersweden" said:

    3. utf-8 bug settings
    in "settings > custom field settings" you are not allowed to use: " utf-8 test åäöåäöüüßßåäö" as a label or in the label fields.


    if i was you i wouldn't fix this at this time as it for sure creates many new bugs. i think its better to just make this release so bug free as possible with this level of utf-8 support. and then make an 5.0.5 release with the rest and don't add any other new features then full utf-8 support and bug fixes to that release.

    regards
    johan
  • "vtigersweden" said:
    if i was you i wouldn't fix this at this time as it for sure creates many new bugs. i think its better to just make this release so bug free as possible with this level of utf-8 support. and then make an 5.0.5 release with the rest and don't add any other new features then full utf-8 support and bug fixes to that release.

    hi johan,

    thank you for sharing your opinion on the fixes.

    the utf-8 support was being made stable in vtiger 5.0.4, so it becomes
    important we get more focus from community to test the support and file issues.

    we are not planning to fix the issues as soon as it is reported, as pointed out, we are aware of the impact that can happen at other places.
    after gathering all the issues, we can estimate the time frame that will take to fix them.

    hence we are requesting our community to help us in identify all those areas where utf-8 support is missing.
    i'm certainly happy to see the response with this :)

    regards,
    prasad
    vtiger team
  • bug testing analytics > reports

    1. "click here to add new folder"
    ->folder name: åäö -> save
    bug/feature request: allow characters like this.
    when: next release.


    2. analytics > dashboards the wip installation. maybe some of the bugs bellow vanish if the wip is populated with more data the periods. but it's important to fix them any why. because the first impression last and this is one of the places in an crm where many decisions makers looks. and they also takes decisions if or not to use vtiger....

    ___________________________________________
    1 pipeline by sales stage
    warning: invalid argument supplied for foreach() in /home/vtiger/demo/en/wip/modules/potentials/charts.php on line 833

    warning: invalid argument supplied for foreach() in /home/vtiger/demo/en/wip/modules/potentials/charts.php on line 833

    warning: invalid argument supplied for foreach() in /home/vtiger/demo/en/wip/modules/potentials/charts.php on line 833

    warning: invalid argument supplied for foreach() in /home/vtiger/demo/en/wip/modules/potentials/charts.php on line 833

    warning: division by zero in /home/vtiger/demo/en/wip/modules/potentials/charts.php on line 869
    no data available with the specified time period
    __________________________________

    3 all opportunities by lead source by outcome
    warning: invalid argument supplied for foreach() in /home/vtiger/demo/en/wip/modules/potentials/charts.php on line 531

    warning: invalid argument supplied for foreach() in /home/vtiger/demo/en/wip/modules/potentials/charts.php on line 531

    warning: invalid argument supplied for foreach() in /home/vtiger/demo/en/wip/modules/potentials/charts.php on line 531

    warning: division by zero in /home/vtiger/demo/en/wip/modules/potentials/charts.php on line 585
    no data available with the specified time period
    _______________________________________________

    i mostly focus on utf-8 testing. i'm sorry if i report some bug that some one else already has reported.

    on my own testing plan i have this areas left.
    * invoice testing (can't add new invoices to the wip at the moment.)
    * install a clean vtiger installation on my own server.
    test webmail for utf-8 support
    * make a test upgrade of my earlier 5.0.3 rc2 working vtiger installation.

    best regards
    johan
  • hi,

    you should be able to create the invoice on wip now.

    creating invoice was failing due to duplicate entry for invoiceno. we are try to analyze for the cause of this issue.

    if you notice any other issues when using http://en.vtiger.com/wip

    kindly share the details with us.

    sorry for the inconvenience.

    regards,
    prasad
    vtiger team
  • hello again.
    "prasad.a" said:
    hi,
    creating invoice was failing due to duplicate entry for invoiceno. we are try to analyze for the cause of this issue.


    i have tried to do the same as i did last time and now it's all working.
    what i did last time was that i entered the invoice custom prefix "åäöåäöüüßßåäö" in the settings and then went to the invoice view..
    now i have done the same but it's working :-) or maybe we we should we look like :-( depending on if the vtiger team have done some thing to solve it.


    an other utf-8 bug exist in the filters. it not possible to make an advance filter that has a rule that contains characters like åäöåäöüüßßåäö. if i search for customer names containing "å" i get an empty result set.

    regards
    johan
  • sorry this report was not correct.

    "vtigersweden" said:

    an other utf-8 bug exist in the filters. it not possible to make an advance filter that has a rule that contains characters like åäöåäöüüßßåäö. if i search for customer names containing "å" i get an empty result set.
    johan


    corrected:
    it not possible to make an correctly working advance filter view that has a rule that contains characters like åäöåäöüüßßåäö. if i make an filter view that search for customer names containing "å" i get an in correct result set.
    for the moment the filter set gives this result set (when tested at the wip test bed):
    account name
    aaažšđćčλλλ
    胡萝卜
    � � � � � � � � ���
    一家香港的培训公司

    but not this name that would be correct:
    "åäöåäöüüßßåäö ok now!" or "test å ä ö åäö"

    how ever both the gloabal search/find and the account are working and gives the correct result sets :-)
  • "vtigersweden" said:

    it not possible to make an correctly working advance filter view that has a rule that contains characters like åäöåäöüüßßåäö. if i make an filter view that search for customer names containing "å" i get an in correct result set.

    try this test locatin for swedish letters:
    vtiger.artcode.eu

    i use my utf8fix in db connect to search work well without needed conversions (mysql- db and all tables in vtiger collation sets utf8_xxx_ci )
    //in db special characters iso show and insensitive searching by jagi // artcode.eu
    $fixutf8 = $adb->query("set names 'utf8'");
  • hi jagi,

    i tested couple of function in your 5.0.4 testsite using scandinavian letters.

    - account creation with scands is ok
    - account searching ok
    - contact creation ok
    - contact searching using firstname and lastname ok

    matching using scandinavian letters is not excact. if i try to find accounts containint swedisn o (å), results will give me also accounts containing a.

    i'm not too worried about that....


    br, harri
  • "hpiili" said:

    matching using scandinavian letters is not excact. if i try to find accounts containint swedisn o (å), results will give me also accounts containing a.

    i'm not too worried about that....
    br, harri

    this is mysql specification - my demo site works on collation utf8_polish_ci. you can use utf8_swedish_ci.
    i was take this same effect with all national letters when i use collation utf8_general_ci - hmm... anyway - this is very useful in searching results , because peoples makes bugs in writing this specials letters.
  • hi,

    patch from 5.0.3 to 5.0.4 testbuild2
    http://64.14.15.24/archives/validation- ... tbuild.zip

    regards,
    prasad
    vtiger team
  • "prasad.a" said:
    hi,

    patch from 5.0.3 to 5.0.4 testbuild2
    http://64.14.15.24/archives/validation- ... tbuild.zip

    regards,
    prasad
    vtiger team


    sorry, but the above link is wrong.
    please fix this one.
  • hi,

    sorry for the inconvenience. kindly use the link given below.
    http://64.14.15.24/archives/validation- ... uild-2.zip


    thanks & regards,
    minnie.
  • hi minnie,

    is there any difference between 5.04vtii and 5.04rc4?
    the email modul and utf8 problems in 5.04vtii are so evident that i would like to switch to rc4 directly. but there is no download link...

    thanks.
  • hi demostrator,

    vtiger 5.0.4 testbuild ii is what we have made available for download but in svn we have tagged it as vtigercrm-5.0.4-rc4 (to keep the tag names readable)

    we don't plan to provide migrations from testbuild ii to other version going forward and requested not to be used for production server.

    regards,
    prasad
    vtiger team
  • hello guys.

    i've had a problem with 5.0.4 testbuild ii installation. after installation the currency that i've inserted during installation was not displaying correctly (i wrote my native ukrainian currency in ukrainian characters).

    also after installation the system details are not working. i've tried 2 types of installation (from stack installer and on my xampp server).

    regards, eugene.
  • hi eugene,

    please check if the two issues you reported are related to the 2 trac tickets given below:

    currency symbol issue -
    http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/4453

    system details issues -
    http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/4462

    if so, these are recently fixed and you can refer to the changeset given in the ticket comment to get the issue fixed.

    please get back to me if this doesn't solve your problem.
  • "asha" said:
    hi eugene,

    please check if the two issues you reported are related to the 2 trac tickets given below:

    currency symbol issue -
    http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/4453

    system details issues -
    http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/4462

    if so, these are recently fixed and you can refer to the changeset given in the ticket comment to get the issue fixed.

    please get back to me if this doesn't solve your problem.
    hi asha.

    thanks for your fast reply. but the first fix that you offered i tried and got such errors on the start page when i'm trying to login:

    warning: cannot modify header information - headers already sent by (output started at d:\xampp\htdocs\vtiger\include\utils\utils.php:1) in d:\xampp\htdocs\vtiger\index.php on line 78

    warning: session_start() [function.session-start]: cannot send session cookie - headers already sent by (output started at d:\xampp\htdocs\vtiger\include\utils\utils.php:1) in d:\xampp\htdocs\vtiger\index.php on line 83

    warning: session_start() [function.session-start]: cannot send session cache limiter - headers already sent (output started at d:\xampp\htdocs\vtiger\include\utils\utils.php:1) in d:\xampp\htdocs\vtiger\index.php on line 83

    the second one i didn't try because it's not so important for me. i can wait till the stable release.

    regards, eugene.
  • hi eugene,

    not sure if you have picked up even some unwanted changes which might be causing this issue. for the currency issue, the only changes that you need to pick up is from include/utils/utils.php