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. Nextcloud
  3. Nextcloud won't start :(

Nextcloud won't start :(

Scheduled Pinned Locked Moved Nextcloud
13 Posts 4 Posters 2.4k 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.
  • scookeS Offline
    scookeS Offline
    scooke
    wrote on last edited by
    #4

    Disable ALL the apps to be sure.

    A life lived in fear is a life half-lived

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

      @max turns out there was a memories plugin (https://apps.nextcloud.com/apps/memories) that you possibly installed in the past. This plugin had a table which was using some geometry stuff. I deleted that table manually (memory_geometry iirc) and the app starts up after that.

      M 1 Reply Last reply
      1
      • girishG girish

        @max turns out there was a memories plugin (https://apps.nextcloud.com/apps/memories) that you possibly installed in the past. This plugin had a table which was using some geometry stuff. I deleted that table manually (memory_geometry iirc) and the app starts up after that.

        M Offline
        M Offline
        max
        wrote on last edited by
        #6

        @girish thanks Girish, that's amazing!

        I had disabled Memories and NC still wouldn't start.

        I did recently install geolocations so Memories coukd worked with locations. I was suspicious that this was the app requiring polygons on Postgres, but I couldn't find anything else about it. It was running for 5 or 6 weeks after that, until the update of NC.

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

          @max I can easily reproduce this.

          • Install nextcloud
          • Install memories
          • Restart nextcloud
          Jun 03 10:44:40 => Healtheck error: Error: connect ECONNREFUSED 172.18.20.56:80
          Jun 03 10:44:40 Nextcloud is already latest version
          Jun 03 10:44:40
          Jun 03 10:44:40 In AbstractPlatform.php line 396:
          Jun 03 10:44:40
          Jun 03 10:44:40 Unknown database type polygon requested, Doctrine\DBAL\Platforms\PostgreSQL
          Jun 03 10:44:40 100Platform may not support it.
          
          • I have to DROP table oc_memories_planet_geometry manually to get it working again . It seems disabling/removing the app does not remove the tables...
          ei8fdbE 1 Reply Last reply
          0
          • girishG girish

            @max I can easily reproduce this.

            • Install nextcloud
            • Install memories
            • Restart nextcloud
            Jun 03 10:44:40 => Healtheck error: Error: connect ECONNREFUSED 172.18.20.56:80
            Jun 03 10:44:40 Nextcloud is already latest version
            Jun 03 10:44:40
            Jun 03 10:44:40 In AbstractPlatform.php line 396:
            Jun 03 10:44:40
            Jun 03 10:44:40 Unknown database type polygon requested, Doctrine\DBAL\Platforms\PostgreSQL
            Jun 03 10:44:40 100Platform may not support it.
            
            • I have to DROP table oc_memories_planet_geometry manually to get it working again . It seems disabling/removing the app does not remove the tables...
            ei8fdbE Offline
            ei8fdbE Offline
            ei8fdb
            wrote on last edited by ei8fdb
            #8

            Hi @girish I have this exact issue also. I was trying out Memories over NC Photos, and my server updated and boom 💥 my instance won't start.

            I have to DROP table oc_memories_planet_geometry manually to get it working again . It seems disabling/removing the app does not remove the tables...

            Could you post the commands for dropping the relevant table? Databases are one thing I'm really not confident working with and it'd save me a lot of work. If it helps, I cannot get to the Nextcloud instance commandline as it won't start. Thanks.

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

              @ei8fdb Something like:

              • Enable recovery mode
              • Open webterminal.
              • Click MySQL button on top . This will paste a command. Press enter. This will give a MySQL shell.
              • execute DROP table oc_memories_planet_geometry; (note the semicoloon at the end)
              • Disable recovery mode
              ei8fdbE 1 Reply Last reply
              2
              • girishG girish

                @ei8fdb Something like:

                • Enable recovery mode
                • Open webterminal.
                • Click MySQL button on top . This will paste a command. Press enter. This will give a MySQL shell.
                • execute DROP table oc_memories_planet_geometry; (note the semicoloon at the end)
                • Disable recovery mode
                ei8fdbE Offline
                ei8fdbE Offline
                ei8fdb
                wrote on last edited by
                #10

                @girish said in Nextcloud won't start 😞:

                ;

                Gah. I originally used that exact syntax, but forgot the ; !

                Only when you highlighted it did I remember. 🤦 Thanks very much @girish you saved me a lot of time. And even more so on a Saturday.

                The one thing I could not figure out was how to make the connection between the error message (for others, bolded below)

                Jun 03 10:45:37 In AbstractPlatform.php line 396:
                Jun 03 10:45:37
                **Jun 03 10:45:37 Unknown database type polygon requested, Doctrine\DBAL\Platforms\PostgreSQL
                Jun 03 10:45:37 100Platform may not support it.**
                

                and that it was related to 1) an pp, and 2) what app in particular.

                I'd appreciate if you could explain how you made this connection. (When you have time. It's Saturday and everyone deserves their time off!)

                M girishG 2 Replies Last reply
                0
                • ei8fdbE ei8fdb

                  @girish said in Nextcloud won't start 😞:

                  ;

                  Gah. I originally used that exact syntax, but forgot the ; !

                  Only when you highlighted it did I remember. 🤦 Thanks very much @girish you saved me a lot of time. And even more so on a Saturday.

                  The one thing I could not figure out was how to make the connection between the error message (for others, bolded below)

                  Jun 03 10:45:37 In AbstractPlatform.php line 396:
                  Jun 03 10:45:37
                  **Jun 03 10:45:37 Unknown database type polygon requested, Doctrine\DBAL\Platforms\PostgreSQL
                  Jun 03 10:45:37 100Platform may not support it.**
                  

                  and that it was related to 1) an pp, and 2) what app in particular.

                  I'd appreciate if you could explain how you made this connection. (When you have time. It's Saturday and everyone deserves their time off!)

                  M Offline
                  M Offline
                  max
                  wrote on last edited by
                  #11

                  @ei8fdb did you install geo locations for geo tagging your photos?

                  I recently installed geo, and I have been using memories for a long Time without issues, its a great plugin! So either the recent update killed it or it is the geo locations doing it.

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

                    I found the isssue here. The memories app needs the postgis extension in PostgreSQL. For some reason, it doesn't enable this, I guess it expects it to be enabled already.

                    The fix if you want to use this app (for the future) is:

                    • Be sure to be on nextcloud package 4.17.2 atleast
                    • Open Web terminal and click the PostgreSQL button on top. Press enter and run CREATE EXTENSION IF NOT EXISTS postgis; .
                    • Now the app works even after restarts
                    1 Reply Last reply
                    1
                    • ei8fdbE ei8fdb

                      @girish said in Nextcloud won't start 😞:

                      ;

                      Gah. I originally used that exact syntax, but forgot the ; !

                      Only when you highlighted it did I remember. 🤦 Thanks very much @girish you saved me a lot of time. And even more so on a Saturday.

                      The one thing I could not figure out was how to make the connection between the error message (for others, bolded below)

                      Jun 03 10:45:37 In AbstractPlatform.php line 396:
                      Jun 03 10:45:37
                      **Jun 03 10:45:37 Unknown database type polygon requested, Doctrine\DBAL\Platforms\PostgreSQL
                      Jun 03 10:45:37 100Platform may not support it.**
                      

                      and that it was related to 1) an pp, and 2) what app in particular.

                      I'd appreciate if you could explain how you made this connection. (When you have time. It's Saturday and everyone deserves their time off!)

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

                      @ei8fdb said in Nextcloud won't start 😞:

                      The one thing I could not figure out was how to make the connection between the error message

                      I mostly guessed from the Unknown database type polygon requested message. That pointed to some geometry related data type - http://postgis.net/ . From that I went digging into the database (from the dump file) as to who created this type. I got oc_memories_planet_geometry from that. Was quite tricky to figure because the memories app was not installed on the OPs server (but was installed sometime in the past) and this was just the remains of the app in the database.

                      1 Reply Last reply
                      3
                      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