Download & Extend
Trouble ticketing system to support Computer Network Operations » Issues

pg_query error on ticket create -- PostgreSQL

Posted by guodskrap on July 1, 2009 at 2:48pm
Project:Trouble ticketing system to support Computer Network Operations
Version:6.x-3.0-rc4
Component:Code
Category:bug report
Priority:normal
Assigned:mr.york
Status:closed (fixed)

Issue Summary

I receive the following error when attempting to create a ticket.

warning: pg_query() [function.pg-query]: Query failed: ERROR: null value in column "description" violates not-null constraint in /srv/sites/siv3/includes/database.pgsql.inc on line 139.

user warning: query: INSERT INTO ticket_event (tid, reassigned, created, status_id) VALUES (4, 3, 1246450904, 1) in /srv/sites/siv3/sites/all/modules/ticketing/ticket.pages.inc on line 832.

Versions:
Drupal 6.12
Ticketing 6.x-3.0-rc2

Login or register to post comments

Comments

#1

Posted by guodskrap on July 1, 2009 at 2:49pm
Title:pg_query error on ticket create -- pgsql» pg_query error on ticket create -- PostgreSQL

#2

Posted by mr.york on July 6, 2009 at 1:25pm
Component:Miscellaneous» Code

I am not using PGSQL, but I have an idea. Please try to change the original sql commant at the problematic line:
Old:

$SQL = "INSERT INTO {ticket_event} (tid, reassigned, created, status_id) VALUES (%d, %d, %d, %d)";

New:
$SQL = "INSERT INTO {ticket_event} (tid, reassigned, created, status_id, description) VALUES (%d, %d, %d, %d, '')";

If it is working then please report it back.

#3

Posted by mr.york on December 8, 2009 at 1:33pm
Version:6.x-3.0-rc2» 6.x-3.0-rc4
Assigned to:Anonymous» mr.york

Compatibility testing bugs for PostgreSQL was fixed.

#4

Posted by mr.york on July 20, 2010 at 1:21pm
Status:active» closed (fixed)
nobody click here