Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Humhub
  3. Internal Server Error: profile.firstname / profile.lastname / profile.birthday

Internal Server Error: profile.firstname / profile.lastname / profile.birthday

Scheduled Pinned Locked Moved Humhub
24 Posts 4 Posters 3.2k Views 4 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • randyjcR Offline
    randyjcR Offline
    randyjc
    wrote on last edited by randyjc
    #1

    My Humhub instance is giving me some troubles now that users are using it.

    I cannot open the https://domain/admin/user-profile and I get the below error in the logging.
    It's also impossible to add users to a space when searching & adding them.

    How can I access the database?

    yii\base\InvalidConfigException: Unable to locate message source for category 'profile.firstname'. in /app/code/protected/vendor/yiisoft/yii2/i18n/I18N.php:201
    Stack trace:
    #0 /app/code/protected/humhub/components/i18n/I18N.php(172): yii\i18n\I18N->getMessageSource()
    #1 /app/code/protected/vendor/yiisoft/yii2/i18n/I18N.php(89): humhub\components\i18n\I18N->getMessageSource()
    #2 /app/code/protected/humhub/components/i18n/I18N.php(148): yii\i18n\I18N->translate()
    #3 /app/code/protected/vendor/yiisoft/yii2/BaseYii.php(538): humhub\components\i18n\I18N->translate()
    #4 /app/code/protected/humhub/modules/user/views/profile/about.php(40): yii\BaseYii::t()
    #5 /app/code/protected/vendor/yiisoft/yii2/base/View.php(347): require('...')
    #6 /app/code/protected/vendor/yiisoft/yii2/base/View.php(257): yii\base\View->renderPhpFile()
    #7 /app/code/protected/vendor/yiisoft/yii2/base/View.php(156): yii\base\View->renderFile()
    #8 /app/code/protected/vendor/yiisoft/yii2/base/Controller.php(407): yii\base\View->render()
    #9 /app/code/protected/humhub/modules/user/controllers/ProfileController.php(96): yii\base\Controller->render()
    #10 [internal function]: humhub\modules\user\controllers\ProfileController->actionAbout()
    #11 /app/code/protected/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
    #12 /app/code/protected/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams()
    #13 /app/code/protected/vendor/yiisoft/yii2/base/Module.php(552): yii\base\Controller->runAction()
    #14 /app/code/protected/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction()
    #15 /app/code/protected/vendor/yiisoft/yii2/base/Application.php(384): yii\web\Application->handleRequest()
    #16 /app/code/index.php(23): yii\base\Application->run()
    #17 {main}

    ×Een onbekende serverfout deed zich voor; neem bij herhaling contact op met een beheerder van deze site.
    {
    "url": "/s/duinzijde-blok-f/space/membership/members-list",
    "status": 500,
    "response": {
    "error": true,
    "message": "Er is een interne serverfout opgetreden."
    },
    "textStatus": "error",
    "xhr": {
    "readyState": 4,
    "responseText": "{"error":true,"message":"Er is een interne serverfout opgetreden."}",
    "responseJSON": {
    "error": true,
    "message": "Er is een interne serverfout opgetreden."
    },
    "status": 500,
    "statusText": "error"
    },
    "dataType": "json",
    "error": true,
    "message": "Er is een interne serverfout opgetreden.",
    "errorThrown": "",
    "validationError": false
    }

    1 Reply Last reply
    0
    • nebulonN Away
      nebulonN Away
      nebulon
      Staff
      wrote on last edited by
      #2

      If you open a webterminal into the app, there is a button to inject the mysql client commandline for database access.

      For the actual error, can you try to set a displayname for that user in Cloudron with two words "first last" and see if that helps temporarily?

      Either way this looks like an upstream bug in humhub itself.

      1 Reply Last reply
      0
      • randyjcR Offline
        randyjcR Offline
        randyjc
        wrote on last edited by
        #3

        I'm gonna do a restore first, because in panic I added something that I thought would fix it..
        NOT xD

        1 Reply Last reply
        0
        • randyjcR Offline
          randyjcR Offline
          randyjc
          wrote on last edited by randyjc
          #4

          Okay, I found out that this is also happening on a fresh install.

          I get the exact same error when opening this:
          "url": "/s/test/space/membership/members-list

          PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'profile.lastname' in 'order clause' in /app/code/protected/vendor/yiisoft/yii2/db/Command.php:1302
          Stack trace:
          #0 /app/code/protected/vendor/yiisoft/yii2/db/Command.php(1302): PDOStatement->execute()
          #1 /app/code/protected/vendor/yiisoft/yii2/db/Command.php(1168): yii\db\Command->internalExecute()
          #2 /app/code/protected/vendor/yiisoft/yii2/db/Command.php(410): yii\db\Command->queryInternal()
          #3 /app/code/protected/vendor/yiisoft/yii2/db/Query.php(249): yii\db\Command->queryAll()
          #4 /app/code/protected/vendor/yiisoft/yii2/db/ActiveQuery.php(133): yii\db\Query->all()
          #5 /app/code/protected/humhub/modules/user/widgets/UserListBox.php(72): yii\db\ActiveQuery->all()
          #6 /app/code/protected/vendor/yiisoft/yii2/base/Widget.php(146): humhub\modules\user\widgets\UserListBox->run()
          #7 /app/code/protected/humhub/modules/space/controllers/MembershipController.php(295): yii\base\Widget::widget()
          #8 [internal function]: humhub\modules\space\controllers\MembershipController->actionMembersList()
          #9 /app/code/protected/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
          #10 /app/code/protected/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams()
          #11 /app/code/protected/vendor/yiisoft/yii2/base/Module.php(552): yii\base\Controller->runAction()
          #12 /app/code/protected/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction()
          #13 /app/code/protected/vendor/yiisoft/yii2/base/Application.php(384): yii\web\Application->handleRequest()
          #14 /app/code/index.php(23): yii\base\Application->run()
          #15 {main}

          Next yii\db\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'profile.lastname' in 'order clause'
          The SQL being executed was: SELECT user.* FROM user LEFT JOIN profile ON user.id = profile.user_id LEFT JOIN space_membership ON space_membership.user_id=user.id WHERE (user.status=1) AND (space_membership.status=3) AND (space_id=1) AND (user.status=1) ORDER BY profile.lastname LIMIT 8 in /app/code/protected/vendor/yiisoft/yii2/db/Schema.php:676
          Stack trace:
          #0 /app/code/protected/vendor/yiisoft/yii2/db/Command.php(1307): yii\db\Schema->convertException()
          #1 /app/code/protected/vendor/yiisoft/yii2/db/Command.php(1168): yii\db\Command->internalExecute()
          #2 /app/code/protected/vendor/yiisoft/yii2/db/Command.php(410): yii\db\Command->queryInternal()
          #3 /app/code/protected/vendor/yiisoft/yii2/db/Query.php(249): yii\db\Command->queryAll()
          #4 /app/code/protected/vendor/yiisoft/yii2/db/ActiveQuery.php(133): yii\db\Query->all()
          #5 /app/code/protected/humhub/modules/user/widgets/UserListBox.php(72): yii\db\ActiveQuery->all()
          #6 /app/code/protected/vendor/yiisoft/yii2/base/Widget.php(146): humhub\modules\user\widgets\UserListBox->run()
          #7 /app/code/protected/humhub/modules/space/controllers/MembershipController.php(295): yii\base\Widget::widget()
          #8 [internal function]: humhub\modules\space\controllers\MembershipController->actionMembersList()
          #9 /app/code/protected/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
          #10 /app/code/protected/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams()
          #11 /app/code/protected/vendor/yiisoft/yii2/base/Module.php(552): yii\base\Controller->runAction()
          #12 /app/code/protected/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction()
          #13 /app/code/protected/vendor/yiisoft/yii2/base/Application.php(384): yii\web\Application->handleRequest()
          #14 /app/code/index.php(23): yii\base\Application->run()
          #15 {main}
          Additional Information:
          Array
          (
          [0] => 42S22
          [1] => 1054
          [2] => Unknown column 'profile.lastname' in 'order clause'
          )

          1 Reply Last reply
          0
          • randyjcR Offline
            randyjcR Offline
            randyjc
            wrote on last edited by
            #5

            Opened upstream: https://github.com/humhub/humhub/issues/6427

            1 Reply Last reply
            0
            • randyjcR Offline
              randyjcR Offline
              randyjc
              wrote on last edited by
              #6

              @girish saw in one of the topics that you also use humhub.
              Do you perhaps experience the same issues?

              I'm wondering if it is a Cloudron specific issue, because I don't really see any topics about it on github.

              1 Reply Last reply
              0
              • nebulonN Away
                nebulonN Away
                nebulon
                Staff
                wrote on last edited by
                #7

                we use humhub internally yes, but I can't seem to hit this issue there.

                1 Reply Last reply
                0
                • randyjcR Offline
                  randyjcR Offline
                  randyjc
                  wrote on last edited by
                  #8

                  I'm trying to exclude cloudron, but I don't have another cloudron instance anymore to test humhub on another server.

                  If someone could possibly deploy a temporary humhub as well and see if the same errors happens?
                  I could report upstream if it is

                  1 Reply Last reply
                  0
                  • nebulonN Away
                    nebulonN Away
                    nebulon
                    Staff
                    wrote on last edited by
                    #9

                    hm from your support ticket with more logs, it kinda looks like the initial app startup didn't even succeed, as the errors indicate, that basic db columns don't exist.

                    On a fresh installation, can you ensure that in the app logs you see echo "==> Setup complete" at some point?

                    1 Reply Last reply
                    0
                    • randyjcR Offline
                      randyjcR Offline
                      randyjc
                      wrote on last edited by randyjc
                      #10

                      Got that line on the root.dev (test humhub)
                      2023-07-13T14:20:44.000Z ==> Create admin user
                      2023-07-13T14:20:44.000Z ==> Finish configuration
                      2023-07-13T14:20:44.000Z ==> Running upgrade
                      2023-07-13T14:20:44.000Z ==> Setup complete

                      But I added these tables manually:
                      ALTER TABLE profile ADD COLUMN lastname VARCHAR(255);
                      ALTER TABLE profile ADD COLUMN firstname VARCHAR(255);
                      ALTER TABLE profile ADD COLUMN birthdayVARCHAR(255);

                      And after that I could open the members table. Need to test the rest if that fixes the rest of the problem as well.

                      Can anyone possibly show their database profiles table?

                      Mines got firstname, lastname, birthday in it.
                      But I’m not sure if there’s more or not.

                      EDIT:
                      Tried to find it in their github repo:
                      This could possibly all of the colomns?
                      https://paste.cloudbasis.nl/?e458eab20259eb41#EhytDcgtGdio68qJ7BNLpzqyJEtpLce5BMLimBoDgPJK

                      1 Reply Last reply
                      0
                      • randyjcR Offline
                        randyjcR Offline
                        randyjc
                        wrote on last edited by
                        #11

                        @nebulon I've tested again a new install on a Digital Ocean Droplet (cloudron)
                        I can reproduce this error, same problem with the missing colomns.

                        When I install it manually without cloudron on a test Digital Ocean vm it works out of the box.
                        When I install Humhub via a droplet, it also works out of the box.

                        I think there must be something wrong with package humhub inside cloudron?

                        1 Reply Last reply
                        0
                        • girishG Offline
                          girishG Offline
                          girish
                          Staff
                          wrote on last edited by
                          #12

                          I have seen this happen before when HumHub installation did not complete properly. I will investigate on a fresh install.

                          1 Reply Last reply
                          0
                          • imc67I Online
                            imc67I Online
                            imc67
                            translator
                            wrote on last edited by
                            #13

                            Same issue here, I was surprised that such software was so buggy but hopefully it’s a package bug?

                            girishG 1 Reply Last reply
                            0
                            • imc67I imc67

                              Same issue here, I was surprised that such software was so buggy but hopefully it’s a package bug?

                              girishG Offline
                              girishG Offline
                              girish
                              Staff
                              wrote on last edited by
                              #14

                              @imc67 is yours a fresh install too?

                              How can I reproduce this?

                              • Install HumHub
                              • Login as admin
                              • Visit /admin/user-profile and observe crash?
                              imc67I 1 Reply Last reply
                              0
                              • randyjcR Offline
                                randyjcR Offline
                                randyjc
                                wrote on last edited by randyjc
                                #15

                                I've reproduced it over here:
                                https://files.cloudbasis.nl/yAhu8/TImiNulo31.gif

                                https://files.cloudbasis.nl/yAhu8/VayuVuDe71.gif

                                1 Reply Last reply
                                2
                                • girishG girish

                                  @imc67 is yours a fresh install too?

                                  How can I reproduce this?

                                  • Install HumHub
                                  • Login as admin
                                  • Visit /admin/user-profile and observe crash?
                                  imc67I Online
                                  imc67I Online
                                  imc67
                                  translator
                                  wrote on last edited by
                                  #16

                                  @girish yes it was @randyjc thanks for your excellent reproducing! (en goed te zien dat ik niet de enige Nederlander ben :-))

                                  1 Reply Last reply
                                  1
                                  • girishG Offline
                                    girishG Offline
                                    girish
                                    Staff
                                    wrote on last edited by
                                    #17

                                    @imc67 @randyjc thanks, I can reproduce this one. It's a regression in the package.

                                    1 Reply Last reply
                                    1
                                    • girishG Offline
                                      girishG Offline
                                      girish
                                      Staff
                                      wrote on last edited by
                                      #18

                                      @imc67 @randyjc Can you please do a fresh installation and check? I have also updated our tests now to check if the migrations completed properly.

                                      1 Reply Last reply
                                      0
                                      • girishG Offline
                                        girishG Offline
                                        girish
                                        Staff
                                        wrote on last edited by
                                        #19

                                        Unfortunately, I couldn't find an obvious way to update from previous broken installations to a working one.

                                        1 Reply Last reply
                                        0
                                        • randyjcR Offline
                                          randyjcR Offline
                                          randyjc
                                          wrote on last edited by
                                          #20

                                          Thanks! Will do a fresh install. Just from my understanding, what exactly was causing this?

                                          Again, thanks!

                                          girishG 1 Reply Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • Bookmarks
                                          • Search