[horde] Installation problem

[o1bigtenor]

On Wed, Jan 15, 2020 at 3:57 PM Luis Felipe Marzagao
<lfbm.andamentos at gmail.com> wrote:
>
> Please, keep replies on the list.

Sorry - - - - some lists require the use of reply all - - - - some do not.
This occasionally produces errors for me.
>
> Em 15/01/2020 18:18, o1bigtenor escreveu:
> > On Wed, Jan 15, 2020 at 3:06 PM Luis Felipe Marzagao
> > <lfbm.andamentos at gmail.com> wrote:
> >>
> >> Em 15/01/2020 12:03, o1bigtenor escreveu:
> >>> On Tue, Jan 14, 2020 at 11:09 AM Luis Felipe Marzagao
> >>> <lfbm.andamentos at gmail.com> wrote:
> >>>>
> >>>> Em 14 de jan de 2020, à(s) 01:06, o1bigtenor <o1bigtenor at gmail.com> escreveu:
> >>>>
> >>>> On Mon, Jan 13, 2020 at 6:20 PM Luis Felipe Marzagao
> >>>> <lfbm.andamentos at gmail.com> wrote:
> >>>>
> >>>>
> >>>>
> >>>> Em 12/01/2020 09:46, o1bigtenor escreveu:
> >>>>
> >>>> Greetings
> >>>>
> >>>> Working on installing horde groupwebmail on a debian buster (10) where
> >>>> apache 2.4.38, postgresql 11.5 and php 7.3.
> >>>>
> >>>> Chose to install using  # apt install  and the installation completed easily.
> >>>> It was in working through the configuration that a roadblock occurred.
> >>>>
> >>>> Quoting the terminal output:
> >>>>
> >>>> Creating and updating database tables...
> >>>>     Fatal Error:
> >>>>     SQLSTATE[42703]: Undefined column: 7 ERROR:  column "increment_by"
> >>>> does not exist
> >>>>     LINE 1: ...q', (SELECT COALESCE(MAX("sentmail_id") + (SELECT
> >>>> increment_...
> >>>>                                                                  ^
> >>>>     In /usr/share/php/Horde/Db/Adapter/Pdo/Base.php on line 233
> >>>>
> >>>>
> >>>> How do I resolve this?
> >>>>
> >>>>
> >>>> Apparently your database was not correctly created. Try running
> >>>> /usr/bin/horde-db-migrate from the command line.
> >>>>
> >>>>
> >>>> # /usr/bin/horde-db-migrate
> >>>> Fatal Error:
> >>>>    Could not instantiate PDO. PDOException: SQLSTATE[HY000] [14] unable
> >>>> to open database file
> >>>>    In /usr/share/php/Horde/Db/Adapter/Pdo/Base.php on line 48
> >>>>
> >>>>
> >>>> It seems you are missing dependencies. My recommendation would be install horde from these instructions:
> >>>>
> >>>> https://www.horde.org/apps/horde/docs/INSTALL
> >>>>
> >>>> And then installing the applications you want according to each documentation, for example for IMP:
> >>>>
> >>>> https://www.horde.org/apps/imp/docs/INSTALL
> >>>>
> >>> Dunno about what you're reading but when I read the error messages - -
> >>> - - well what I'm
> >>> seeing is that there is some kind of sql code in horde at place x
> >>> which is at best not
> >>> appropriate code for the database in question.
> >>>
> >>> Why that would mean that a reinstall would fix the issue - - - -
> >>> that's confusing.
> >>
> >> You could try checking to see if your database server is really up and
> >> running, because the error says it could not open the database file.
> >>
> >> If your db server is ok, then you had some problem when the database was
> >> created or you are missing horde dependencies, which could be caused by
> >> a broken distro package install, or, as Jan has already mentioned,
> >> "there are some patches for newer Postgresql versions on GitHub that
> >> haven't been incorporated yet. Feedback on those is welcome."
> > If you would be so kind as to point me to where I could find those
> > patches . . .    .
>
>
> You could start here: https://github.com/horde/Db/commits/master
>
OK s o I can see the patch. When I'm reading the code (total noob to
coding here)
I can understand what the change is. What I have no clue how to do (looked into
both the use of the program 'patch' and a few write ups on doing a git
patch but
its not clear how I do this.
Did some looking and have found the file on my system. Also have the 'patch'
available. Have not ever done this - - - - so - - - do I add the new
lines into the
file and remove the unwanted lines then save the new version?
Would this 'apply' the patch?

TIA