help with inital postgres tables !??
hi I've just CSV'd down OpenTRS, but I'm having some trouble trying to use it with Postgres (I know it's only really been tested with MySQL, but I am being forced to use Postgres from higher up) when I try to run the table creation script, it doesn't seem to like the (0) after the timestamp entries !! will it harm the system if I remove them so the entries simply read create_time timestamp NOT NULL, create_by integer NOT NULL, change_time timestamp NOT NULL, change_by integer NOT NULL, ?? it is also complaining about 'serial8' on the 'article' table :o( any hints on how to force the tables and seeding process through ?? thanks _scott
Hi Scott, On Mon, Jun 24, 2002 at 07:39:44AM -0400, Scott Brewerton wrote:
when I try to run the table creation script, it doesn't seem to like the (0) after the timestamp entries !!
will it harm the system if I remove them so the entries simply read
create_time timestamp NOT NULL, create_by integer NOT NULL, change_time timestamp NOT NULL, change_by integer NOT NULL,
??
it is also complaining about 'serial8' on the 'article' table :o( any hints on how to force the tables and seeding process through ??
Oh. .) Fine. You use probably PostgreSQL < 7.2. Ja, use 'timestamp' instead of 'timestamp(0)' and 'serial' instead of 'serial8'. Then it will work fine. Thanks to Ingo Ciechowski for this hit.
thanks
_scott
Have a lot of fun. Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "The number of Unix installations has grown to 10, with more expected." The Unix Programmer's Manual, 2nd Edition, June 1972
Hi Christoph, On Mon, Jun 24, 2002 at 03:31:40PM +0200, Christoph Kaulich wrote:
Sorry, after doing the same again, 'deinstall - install' it is working
Nice! :)
now, Christoph
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Perfection is our goal, excellence will be tolerated. -- J. Yahl
Hi Christoph, On Mon, Jun 24, 2002 at 03:12:53PM +0200, Christoph Kaulich wrote:
I have upgraded from BETA % to BETA6, and now I get the following message in the error log of my webserver: [Mon Jun 24 15:09:05 2002] [error] Got no QueueObject! at ../../Kernel/System/Permission.pm line 35, <TEMPLATEIN> line 255575. In Mozilla, I only see.
Internal Server Error [...]
Does anyone know, what was going wrong?
You really updated all files? RPM or tar? The problem here is in Kernel/System/Permission.pm. In 0.5 BETA5 Permission.pm has needed a QueueObject. But not in 0.5 BETA6. -==> Your Kernel/System/Permission.pm is still from 0.5 BETA5 (I suppose it). It looks like your $OTRS_HOME/bin/* is up to date. But the $OTRS_HOME/Kernel/* is still 0.5 BETA5. Check your Kernel/System/Permission.pm. If it's 'Revision 1.4' then it's BETA6... Correct? PS: Just plain text emails to the list would be nice for us. .-)
Thanks, Christoph
Have a lot of fun. Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "There are two major products that come out of Berkeley: LSD and Unix. We don't believe this to be a coincidence." -- Jeremy S. Anderson
participants (3)
-
Christoph Kaulich -
Martin Edenhofer -
Scott Brewerton