3 issues which makes EspoCRM the rock bottom perfect system

[theode]

ok...worked...in which file change Mr. Mrs. Dr. Drs to german?

[yuri]

application\Espo\Modules\Crm\Resources\metadata\en tityDefs\Contact.php

[theode]

changed the words in entire source code and it does not work? is it somewhere in the database? what am I missing?


Thats my last problem before going live tomorrow.!

[yuri]

Translation in language files.

[theode]

I have the problem that my

    "collection": {
        "textFilterFields": ["account","accountId","accountRole","accountType","accounts","address","addressCity","addressCountry"]
    }

is causing error 500 on search....

[yuri]

Maybe you need wrap it into {..}

{
    "collection": {
        "textFilterFields": ["account","accountId","accountRole","accountType","accounts","address","addressCity","addressCountry"]
    }
} 

[theode]

but then its loosing the rest of the file...The file is like this and then it shows all my custom columns. in
custom/Espo/Custom/Resources/metadata/entityDefs/Lead.json

{


    "fields": {
      
        "anfrage": {
            "type": "text",
            "required": false,
            "isCustom": true
        },
        "angebot": {
            "type": "text",
            "required": false,
            "isCustom": true
        },
        "iDALT": {
            "type": "int",
            "required": false,
            "isCustom": true
        }
    }

}

but if I have the

[COLOR=#000000][COLOR=#007700]{
    [/COLOR][COLOR=#DD0000]"collection"[/COLOR][COLOR=#007700]: {
        [/COLOR][COLOR=#DD0000]"textFilterFields"[/COLOR][COLOR=#007700]: [[/COLOR][COLOR=#DD0000]"account"[/COLOR][COLOR=#007700],[/COLOR][COLOR=#DD0000]"anfrage[/COLOR][COLOR=#DD0000]","angebot","iDALT"[/COLOR][COLOR=#007700]]
    }
} [/COLOR][/COLOR]

in it, it broke the custom fields also if I try various variation of where I put brackets

[theode]

ok I have another problem.
I vaidated JSON file but then I have a problem with this field

 
(
[controller] => Lead
)
, InputData:  - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lead.opportunity_amount_converted' in 'where clause' [] []
[2014-09-22 09:30:48] Espo.ERROR: Display Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lead.opportunity_amount_converted' in 'where clause', Code: 42S22 URL: /CRM/api/v1/Lead?maxSize=100&offset=0&sortBy=createdAt&asc=false&where%5B0%5D%5Btype%5D=textFilter&where%5B0%5D%5Bvalue%5D=LBS [] []
[2014-09-22 09:30:58] Espo.ERROR: API [GET]:/:controller, Params:Array
(
    [controller] => Lead
)
, InputData:  - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lead.opportunity_amount_converted' in 'where clause' [] []
[2014-09-22 09:30:58] Espo.ERROR: Display Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lead.opportunity_amount_converted' in 'where clause', Code: 42S22 URL: /CRM/api/v1/Lead?maxSize=100&offset=0&sortBy=createdAt&asc=false&where%5B0%5D%5Btype%5D=textFilter&where%5B0%5D%5Bvalue%5D=%25LBS%25 [] []
[2014-09-22 09:31:08] Espo.ERROR: API [GET]:/:controller, Params:Array

so it seems he wants inside the sql a field which isn't there nor used by us????
please help, this is very imortant!

[yuri]

Hi

Maybe some JSON still broken.

[theode]

the export function acts crazy
it goes to http://domain.de/CRM/?entryPoint=dow...=541fff8e14977 ask for a password and does nothing

[yuri]

Seems it's problem with your server configuration. This shouldn't ask for password.