Hi, I am currently (among other things) evaluating the PostgreSQL backend for OTRS (mainly because I don't really like MySQL, but also because of restrictions a customer of mine makes with respect to the database engine - if something other than PostgreSQL is required, there must be very good reasons for it).
So far, everything is fine. However, when I want to create a new queue from the GUI, I get the following error message: ERROR: invalid input syntax for integer: "", SQL: 'INSERT INTO queue (name, group_id, unlock_timeout, system_address_id, calendar_name, default_sign_key, salutation_id, signature_id, first_response_time, first_response_notify, update_time, update_notify, solution_time, solution_notify, follow_up_id, follow_up_lock, valid_id, comments, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)' Versions are: OTRS 3.0.5, CentOS 5.5, PostgreSQL 8.1.22 (also tried 8.4.5, same result). This is a completely new installation, all required perl modules are present according to otrs.CheckModules.pl. DBI originally (CentOS package) was version 1.52, DBD::Pg 1.49. Tried to upgrade to 1.616/2.17.2 during debugging, but that didn't change anything. Probably anyone has seen that before, since there are some PostgreSQL installations around, as far as I can see. What am I missing? Thanks in advance, Peter. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
