Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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!
    Attached Files
    Last edited by p.etrus; 04-15-2022, 03:34 PM.

  • #2
    See your espoCRM Logfile (data/logs)

    Comment


    • #3
      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.

      Comment


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

        Code:
        [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?:
        Code:
        [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]\",
        ...
        Last edited by p.etrus; 04-16-2022, 08:39 AM.

        Comment


        • #5
          OK i found it. So instead of:
          Code:
          '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:
          Code:
          'tabList' => [],
          'quickCreateList' => [],
          Right?
          Couldn't i just rightaway type in mydesired array like:
          Code:
          'tabList' => [
              0 => 'Campaign',
              1 => 'Lead',
              2 => 'Account',
          ],
          'quickCreateList' => [],

          Comment


          • #6
            Originally posted by yuri View Post
            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?

            Code:
            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

            Comment


            • #7
              And this is the dashboardLayout entry in data/config.php:
              Code:
              'dashboardLayout' => '[object Object]',

              Comment


              • #8
                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!

                Comment

                Working...
                X