Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Ranieri
    @slemernet
    I try assigned some value in pick list
    image.png
    but system not allows exclude some itens.
    in log [2021-04-07T11:45:19.436434-03:00] DB.INFO: :::: ["DB error Query Failed:INSERT INTO vtiger_role2picklist VALUES (?,?,?,?)::->[1048]Column 'picklistid' cannot be null"]
    [2021-04-07T11:45:19.436466-03:00] DB.DEBUG: > pquery SELECT * FROM vtiger_cf_1402 WHERE cf_1402=? :::: []
    [2021-04-07T11:45:19.436496-03:00] DB.DEBUG: parameters :::: ["Interesse"]
    Joe Bordes
    @joebordes
    hi
    can you reproduce in the demo?
    Ranieri
    @slemernet
    no, but demo appears not up to date
    appears old version
    Joe Bordes
    @joebordes
    it is up to date now
    just tried in my dev install and it seems to work
    could be the special characters?
    Ranieri
    @slemernet
    in demo shows
    image.png
    in my install words, with accent
    like "Ação"
    but in demo not
    Joe Bordes
    @joebordes
    the table was not created
    how did you create the picklist?
    Ranieri
    @slemernet
    in graphical interface
    layout editor
    Ranieri
    @slemernet
    appears error when create a new custom field
    [2021-04-07T12:16:26.489452-03:00] DB.DEBUG: > pquery CREATE TABLE vtiger_cf_1406 ( cf_1406id int(19) NOT NULL auto_increment, cf_1406 varchar(200) NOT NULL, presence int(1) NOT NULL default '1', picklist_valueid int(19) NOT NULL default '0', PRIMARY KEY (cf_1406id) ) :::: []
    [2021-04-07T12:16:26.509468-03:00] DB.DEBUG: > pquery insert into vtiger_picklist values(?,?) :::: []
    [2021-04-07T12:16:26.509546-03:00] DB.DEBUG: parameters :::: [82,"cf_1406"]
    [2021-04-07T12:16:26.509745-03:00] DB.INFO: :::: ["DB error Query Failed:insert into vtiger_picklist values(?,?)::->[1136]Column count doesn't match value count at row 1"]
    [2021-04-07T12:16:26.509791-03:00] DB.DEBUG: > pquery select picklistid from vtiger_picklist where name=? :::: []
    [2021-04-07T12:16:26.509817-03:00] DB.DEBUG: parameters :::: ["cf_1406"]
    [2021-04-07T12:16:26.510483-03:00] DB.DEBUG: > pquery select cf_1406 from vtiger_cf_1406 :::: []
    [2021-04-07T12:16:26.531541-03:00] DB.DEBUG: > pquery insert into vtiger_cf_1406 values(?,?,?,?) :::: []
    [2021-04-07T12:16:26.531610-03:00] DB.DEBUG: parameters :::: [1,"teste1",1,814]
    [2021-04-07T12:16:26.532985-03:00] DB.DEBUG: > pquery select picklist_valueid from vtiger_cf_1406 where cf_1406=? :::: []
    [2021-04-07T12:16:26.533078-03:00] DB.DEBUG: parameters :::: ["teste1"]
    [2021-04-07T12:16:26.533594-03:00] DB.DEBUG: > pquery insert into vtiger_role2picklist select roleid,814,,0 from vtiger_role :::: []
    [2021-04-07T12:16:26.534181-03:00] DB.INFO: :::: ["DB error Query Failed:insert into vtiger_role2picklist select roleid,814,,0 from vtiger_role::->[1064]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0 from vtiger_role' at line 1"]
    [2021-04-07T12:16:26.534280-03:00] DB.DEBUG: > pquery select cf_1406 from vtiger_cf_1406 :::: []
    [2021-04-07T12:16:26.537109-03:00] DB.DEBUG: > pquery insert into vtiger_cf_1406 values(?,?,?,?) :::: []
    [2021-04-07T12:16:26.537187-03:00] DB.DEBUG: parameters :::: [2,"teste2",1,815]
    [2021-04-07T12:16:26.538422-03:00] DB.DEBUG: > pquery select picklist_valueid from vtiger_cf_1406 where cf_1406=? :::: []
    [2021-04-07T12:16:26.538494-03:00] DB.DEBUG: parameters :::: ["teste2"]
    [2021-04-07T12:16:26.538874-03:00] DB.DEBUG: > pquery insert into vtiger_role2picklist select roleid,815,,1 from vtiger_role :::: []
    [2021-04-07T12:16:26.539088-03:00] DB.INFO: :::: ["DB error Query Failed:insert into vtiger_role2picklist select roleid,815,,1 from vtiger_role::->[1064]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 from vtiger_role' at line 1"]
    [2021-04-07T12:16:26.539202-03:00] DB.DEBUG: > query select distinct vtiger_field.tabid,name from vtiger_field inner join vtiger_tab on vtiger_field.tabid=vtiger_tab.tabid where vtiger_field.tabid not in(9,10,16,15,8,29) :::: []
    [2021-04-07T12:16:26.542814-03:00] DB.DEBUG: > getTabid Leads :::: []
    [2021-04-07T12:16:26.542876-03:00] DB.DEBUG: < getTabid :::: []
    [2021-04-07T12:16:26.542898-03:00] DB.DEBUG: > pquery select blocklabel,blockid from vtiger_blocks where tabid = ? :::: []
    Joe Bordes
    @joebordes
    try now
    update your code or in the demo (which I just updated again)
    and let me know
    Ranieri
    @slemernet
    Yes, works fine again!
    Thanks!!
    Joe Bordes
    @joebordes
    thank you !
    I'll try to find some time for the integer issue
    rather tied up right now
    Ranieri
    @slemernet
    ok!
    Ranieri
    @slemernet
    not works for inline edition is there right?
    Joe Bordes
    @joebordes
    probably not
    Ranieri
    @slemernet
    Hi @joebordes
    lang file potencials ( pt_br )
    I add label "Create Invoice" in this file, is in right place?
    Joe Bordes
    @joebordes
    Hi
    that is for the action?
    Ranieri
    @slemernet
    yes
    Joe Bordes
    @joebordes
    probably, let me check
    Ranieri
    @slemernet
    ah ok
    removed from pt_br.lang. correct
    and translate terms in include/pt_br.lang.php
    thanks!
    Joe Bordes
    @joebordes
    updated. thanks!