[horde] PostgreSQL errors
jan at horde.org
Wed Mar 29 13:26:17 PST 2006
Zitat von "Daniel A. Ramaley" <daniel.ramaley at DRAKE.EDU>:
> On Wednesday 29 March 2006 13:59, Jan Schneider wrote:
>> Zitat von "Daniel A. Ramaley" <daniel.ramaley at DRAKE.EDU>:
>>> Since upgrading to Horde 3.1 i've noticed regular error messages in
>>> PostgreSQL's log:
>>> Mar 29 12:53:54 sun12 postgres: [1-1] ERROR: relation
>>> "horde_histories" does not exist
>>> Was there something that needed to be done to the database as part
>>> of the upgrade? I noticed that there was an upgrade script in the
>>> Horde 3.1 tarball (horde-3.1/scripts/upgrades/3.0_to_3.1.mysql.sql)
>>> for the MySQL database, but none for PostgreSQL.
>> Because noone contributed one. Patch?
> That would explain it. What i've pasted below seems to work; since
> applying it and running "php move_history_out_of_datatree.php" i've
> stopped seeing errors in the log, and Horde still works. You may notice
> a remarkable similarity between what is below and the mysql upgrade
> script; all i did was remove the last line of the mysql script that
> sets permissions as postgresql didn't like the syntax and it didn't
> seem necessary (i applied the below while logged in to postgresql as
Great! Committed to CVS, thanks.
Do you need professional PHP or Horde consulting?
More information about the horde