
Hi,
I have run the SELECT query on database otrs and this is the result:
mysql> SELECT id,name,valid_id FROM ticket_priority;
+----+-------------+----------+
| id | name | valid_id |
+----+-------------+----------+
| 1 | 1 heel laag | 1 |
| 2 | 2 laag | 1 |
| 3 | 3 normaal | 1 |
| 4 | 4 hoog | 1 |
| 5 | 5 heel hoog | 1 |
+----+-------------+----------+
5 rows in set (0.00 sec)
mysql>
2007/10/26, Peter Hoogkamer
I will check this as soon as I am back at the head office agian. Can't reach my server from outside.
Peter
2007/10/25, Torsten Thau
: -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Peter Hoogkamer schrieb:
I think I have checked that but will look there to be sure. What's the deal here?? I think the popmasterpop3 retrieves the email from the box and get its information from the email for filling the entries of the mysql database. There will be an insert query to insert the ticket into the database, but somehow in between there will be no data given for the priority field. Which would be a default of 3. But where does
well, apparently the default priority is known, but there seems to be no corresponding entry in the DB.
OTRS gets it default values when creating a ticket from?? I think that the error will be there somewhere. I am not a programmer so I am not sure if it could be a bug or something. Does somebody have tips for debugging this stuff??
Can you access the database and let us know what the result of the following query is:
SELECT id, name, valid_id FROM ticket_priority;
regards, Torsten Thau
- -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFHILcNvXo8m5PgoXQRAjviAJ9BoMdel0aXCR31S82HleYwEBUmKwCfQqtN wATv1E2UuftNClyk8UoaTaU= =Gso/ -----END PGP SIGNATURE----- _______________________________________________ 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 Support or consulting for your OTRS system? => http://www.otrs.com/