Tried to change order in Tab and Quick Create List, now everything is gone.

[p.etrus]

Dear all,
i think i messed up big time:
I changed the order of the entries in Tab List and Quick Create LIst in Administration -> User Interface.
Interesting: It actually were two text fields with all the entries in it separated by commas. So i might have had a typo in there...

Now i can't log in at all. If you want here you can see how it looks (nothing to see ;-) ):
crm.perzgartler.com
My question: Is there a way to fix that directly in the database or elsewhere via FTP or so?

Sorry EDIT: i cleared the cache of browser. No i can log in as a user, but there is almost no interface, see image.
I can login as admin, but there only a blank page...

EDIT #2:
i checked the error console in Firefox and i see this (see second image):
What can i do about that?

Please help, i'd appreciate any input!

[shalmaxb]

See your espoCRM Logfile (data/logs)

[yuri]

There should not have been text fields for tab list and quite create list fields. It means something was screwed up, might be metadata. Not sure.

In data/config.php find tabList, quickCreateList, and set them with an empty array `[]`. This should fix errors.


What version do you use? The should be a backend validation not allowing to save data other than array.

[p.etrus]

OK, here's the last entry in the logfile:
I'm looking at the data/config right now.

[2022-04-15 15:28:17] Espo.WARNING: E_WARNING: array_values() expects parameter 1 to be array, string given {"code":2,"message":"array_values() expects parameter 1 to be array, string given",
"file":"/www/htdocs/w0181744/crm/application/Espo/Services/Settings.php","line":140,"context":
{"data":"[object] (stdClass: {\"systemUserAttributes\":{\"id\":\"system\",\"use rName\":\"system\",\"firstName\":\"\",\"lastName\" :\"System\",\"type\":\"system\"},\"passwordGenerat eLength\":10,\"cacheTimestamp\":1650029277,\"useCa che\":true,\"recordsPerPage\":\"20\",\"recordsPerP ageSmall\":\"5\",\"applicationName\":\"P+G EspoCRM\",\"version\":\"5.8.4\",\"timeZone\":\"Eur ope/Vienna\",\"dateFormat\":\"YYYY-MM-DD\",\"timeFormat\":\"hh:mm a\",\"weekStart\":1,\"thousandSeparator\":\".\",\" decimalMark\":\",\",\"exportDelimiter\":\";\",\"cu rrencyList\":[\"EUR\"],\"defaultCurrency\":\"EUR\",\"baseCurrency\":\"EU R\",\"currencyRates\":[],\"outboundEmailIsShared\":true,\"outboundEmailFro mName\":\"EspoCRM\",\"outboundEmailFromAddress\":\ "info@perzgartler.com\",\"language\":\"de_DE\",\"g lobalSearchEntityList\":[\"Account\",\"Contact\",\"Lead\",\"Opportunity\ "],\"tabList\":null,\"quickCreateList\":\"Campaign,L ead,Account,Contact,Opportunity,Meeting,Call,Task, Case,Email\",\"exportDisabled\":false,\"assignment EmailNotifications\":false,\"assignmentEmailNotifi cationsEntityList\":[\"Lead\",\"Opportunity\",\"Task\",\"Case\"],\"assignmentNotificationsEntityList\":[\"Meeting\",\"Call\",\"Task\",\"Email\"],\"portalStreamEmailNotifications\":true,\"streamE mailNotificationsEntityList\":[\"Case\"],\"streamEmailNotificationsTypeList\":[\"Post\",\"Status\",\"EmailReceived\"],\"emailNotificationsDelay\":30,\"emailMessageMaxS ize\":10,\"notificationsCheckInterval\":10,\"follo wCreatedEntities\":false,\"b2cMode\":false,\"theme \":\"HazyblueVertical\",\"massEmailVerp\":false,\" userNameRegularExpression\":\"[^a-z0-9\\\\-@_\\\\.\\\\s]\",\"addressFormat\":1,\"displayListViewRecordCoun t\":\"true\",\"dashboardLayout\":\"[object Object]\",\"calendarEntityList\":[\"Meeting\",\"Call\",\"Task\"],\"activitiesEntityList\":[\"Meeting\",\"Call\"],\"historyEntityList\":[\"Meeting\",\"Call\",\"Email\"],\"cleanupAuthTokenPeriod\":\"1 month\",\"currencyFormat\":2,\"currencyDecimalPlac es\":2,\"aclAllowDeleteCreated\":false,\"aclAllowD eleteCreatedThresholdPeriod\":\"24 hours\",\"inlineAttachmentUploadMaxSize\":20,\"tex tFilterUseContainsForVarchar\":false,\"tabColorsDi sabled\":\"false\",\"massPrintPdfMaxCount\":50,\"e mailKeepParentTeamsEntityList\":[\"Case\"],\"streamEmailWithContentEntityTypeList\":[\"Case\"],\"recordListMaxSizeLimit\":200,\"noteDeleteThresh oldPeriod\":\"1 month\",\"noteEditThresholdPeriod\":\"7 days\",\"emailForceUseExternalClient\":false,\"use WebSocket\":false,\"auth2FAMethodList\":[\"Totp\"],\"personNameFormat\":\"firstLast\",\"newNotificat ionCountInTitle\":false,\"siteUrl\":\"https://crm.perzgartler.com:443\",\"fullTextSearchMinLengt h\":4,\"companyLogoId\":\"6258144146fb9be5d\",\"co mpanyLogoName\":\"LOGO_P+G_S.png\",\"userThemesDis abled\":\"false\",\"avatarsDisabled\":\"false\",\" scopeColorsDisabled\":\"false\",\"tabIconsDisabled \":\"false\",\"dashletsOptions\":{},\"companyLogo\ ":\"\"})",
"ignoreItemList":["systemItems","adminItems","superAdminItems","supe rAdminSystemItems","configPath","cachePath","datab ase","crud","logger","isInstalled","systemUser","d efaultPermissions","passwordSalt","cryptKey","apiS ecretKeys","hashSecretKey","restrictedMode","userL imit","portalUserLimit","stylesheet","userItems"," globalItems","internalSmtpServer","internalSmtpPor t","internalSmtpAuth","internalSmtpUsername","inte rnalSmtpPassword","internalSmtpSecurity","internal OutboundEmailFromAddress","requiredPhpVersion","re quiredMysqlVersion","recommendedMysqlParams","requ iredPhpLibs","recommendedPhpLibs","recommendedPhpP arams","requiredMariadbVersion","recommendedMariad bParams","phpExecutablePath","webSocketDebugMode", "webSocketSslCertificateFile","webSocketSslCertifi cateLocalPrivateKey","webSocketSslCertificatePassp hrase","webSocketSslAllowSelfSigned","webSocketUse SecureServer","webSocketPort","aclStrictMode","act ualDatabaseType","actualDatabaseVersion","devMode" ,"smtpServer","smtpPort","smtpAuth","smtpSecurity" ,"smtpUsername","smtpPassword","jobMaxPortion","jo bPeriod","jobRerunAttemptNumber","jobRunInParallel ","jobPoolConcurrencyNumber","jobPeriodForActivePr ocess","cronMinInterval","daemonInterval","daemonP rocessTimeout","daemonMaxProcessNumber","authentic ationMethod","adminPanelIframeUrl","ldapHost","lda pPort","ldapSecurity","ldapAuth","ldapUsername","l dapPassword","ldapBindRequiresDn","ldapBaseDn","ld apUserLoginFilter","ldapAccountCanonicalForm","lda pAccountDomainName","ldapAccountDomainNameShort"," ldapAccountFilterFormat","ldapTryUsernameSplit","l dapOptReferrals","ldapPortalUserLdapAuth","ldapCre ateEspoUser","ldapAccountDomainName","ldapAccountD omainNameShort","ldapUserNameAttribute","ldapUserF irstNameAttribute","ldapUserLastNameAttribute","ld apUserTitleAttribute","ldapUserEmailAddressAttribu te","ldapUserPhoneNumberAttribute","ldapUserObject Class","maxEmailAccountCount","massEmailMaxPerHour Count","personalEmailMaxPortionSize","inboundEmail MaxPortionSize","authTokenLifetime","authTokenMaxI dleTime","ldapUserDefaultTeamId","ldapUserDefaultT eamName","ldapUserTeamsIds","ldapUserTeamsNames"," ldapPortalUserPortalsIds","ldapPortalUserPortalsNa mes","ldapPortalUserRolesIds","ldapPortalUserRoles Names","cleanupJobPeriod","cleanupActionHistoryPer iod","adminNotifications","adminNotificationsNewVe rsion","adminNotificationsCronIsNotConfigured","ad minNotificationsNewExtensionVersion","leadCaptureA llowOrigin","cronDisabled","defaultPortalId","clea nupDeletedRecords","authTokenPreventConcurrent","e mailParser","passwordRecoveryDisabled","passwordRe coveryForAdminDisabled","latestVersion"],
"item":"latestVersion","portal":null,"scopeLis t":
["ActionHistoryRecord","ArrayValue","Attachment","A uthLogRecord","AuthToken","Currency","DashboardTem plate","Email","EmailAccount","EmailAddress","Emai lFilter","EmailFolder","EmailTemplate","EmailTempl ateCategory","Extension","ExternalAccount","Import ","InboundEmail","Integration","Job","LeadCapture" ,"LeadCaptureLogRecord","NextNumber","Note","Notif ication","PasswordChangeRequest","PhoneNumber","Po rtal","PortalRole","Preferences","Role","Scheduled Job","ScheduledJobLogRecord","Settings","Team","Te mplate","UniqueId","User","UserData","Webhook","We bhookEventQueueItem","WebhookQueueItem","Account", "Call","Campaign","CampaignLogRecord","CampaignTra ckingUrl","Case","Contact","Document","DocumentFol der","EmailQueueItem","KnowledgeBaseArticle","Know ledgeBaseCategory","Lead","MassEmail","Meeting","O pportunity","Reminder","Target","TargetList","Task "],"scope":"Currency","param":"quickCreateList","lis t":"Campaign,Lead,Account,Contact,Opportunity,Meet ing,Call,Task,Case,Email"}} []

EDIT: oh and the second last entry might also be relevant?:

[2022-04-15 15:28:17]
Espo.WARNING: E_WARNING: Invalid argument supplied for foreach()
{"code":2,"message":"Invalid argument supplied for foreach()","file":"/www/htdocs/w0181744/crm/application/Espo/Services/Settings.php","line":135,
...
\"dashboardLayout\":\"[object Object]\",
...

[p.etrus]

OK i found it. So instead of:

'tabList' => 'Campaign,Lead,Account,Contact,Calendar,Task,_deli miter_,Email,Opportunity,Case,Meeting,Call,Documen t,KnowledgeBaseArticle,Stream,User',
'quickCreateList' => 'Campaign,Lead,Account,Contact,Opportunity,Meeting ,Call,Task,Case,Email',

it should say:

'tabList' => [],
'quickCreateList' => [],

Right?
Couldn't i just rightaway type in mydesired array like:

'tabList' => [
    0 => 'Campaign',
    1 => 'Lead',
    2 => 'Account',
],
'quickCreateList' => [],

[p.etrus]

What version do you use?

It's Version 5.8.4

I can low login again and i can go to Administration. But from there when i try to go to User Interface nothing happens.
Here's some error in FF's console:
What's that?

Uncaught (in promise) TypeError: this.dashboardLayout.forEach is not a function
    isEmpty espo.min.js:372
    data espo.min.js:70
    _getData bull.js:623
    _getHtml bull.js:681
    tryReady bull.js:652
    _getNestedViewsHtmlList bull.js:657
    _getHtml bull.js:680
    getHtml bull.js:385
    _getNestedViewsHtmlList bull.js:663
    _getNestedViewsHtmlList bull.js:658
    _getHtml bull.js:680
    getHtml bull.js:385
    _getNestedViewsHtmlList bull.js:663
    _getNestedViewsHtmlList bull.js:658
    _getHtml bull.js:680
    getHtml bull.js:385
    _getNestedViewsHtmlList bull.js:663
    _getNestedViewsHtmlList bull.js:658
    _getHtml bull.js:680
    _renderPromise bull.js:412
    render bull.js:410
    process controller.js:310
    _makeReady bull.js:514
    _tryReady bull.js:500
    setView bull.js:901
    createView/this._viewPromiseHash[key]</< bull.js:869
    _makeReady bull.js:514
    _tryReady bull.js:500
    setView bull.js:901
    createView/this._viewPromiseHash[key]</< bull.js:869
    _makeReady bull.js:514
    _tryReady bull.js:500
    wait bull.js:994
    setup espo.min.js:164

[p.etrus]

And this is the dashboardLayout entry in data/config.php:

'dashboardLayout' => '[object Object]',

[p.etrus]

Guys, i found the solution in another thread. I just put an empty array in dashboardLayout in config.php (provided by yuri).
Thanks both of you, case closed!