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 Offline
        nebulonN Offline
        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 Offline
                  nebulonN Offline
                  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 Offline
                      nebulonN Offline
                      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 Offline
                              imc67I Offline
                              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 Offline
                                    imc67I Offline
                                    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