[rt-users] Error creating tickets

[Bill Cole]

On 22 Jun 2012, at 17:25, Borngunners wrote:

> I can access the database using the mysql command line... The database 
> was dumped from a previous RT database with 3.8 version and restored 
> to a newly created RT database with 4.02 version on a different 
> machine... Everything else looks like okay except creating tickets...

That leaves doing the database conversion from 3.8.x to 4.x as the most 
likely reason for a problem. Did you run "make upgrade" AND "make 
upgrade-database" with the database running?

> -----Original Message-----
> From: Bill Cole <rtusers-20090205 at billmail.scconsult.com>
> To: RT-Users at lists.bestpractical.com 
> <rt-users at lists.bestpractical.com>
> Sent: Fri, Jun 22, 2012 4:51 pm
> Subject: Re: [rt-users] Error creating tickets
>
>
> On 22 Jun 2012, at 6:55, Al Kay wrote:
>
>> [Thu Jun 21 21:09:47 2012] [error]: Couldn't create a ticket group of
>> type 'Requestor' for ticket 879: Could not create group 
>> (/opt/rt4/sbi$
>> [Thu Jun 21 21:09:47 2012] [crit]: Couldn't create ticket groups for
>> ticket 879. aborting Ticket creation.
>> (/opt/rt4/sbin/../lib/RT/Ticket.$
>> [Thu Jun 21 21:09:47 2012] [error]: WebRT: Ticket could not be 
>> created
>> due to an internal error (/opt/rt4/share/html/Elements/Error:82)
>> [Thu Jun 21 17:13:12 2012] [notice] caught SIGTERM, shutting down
>> [Thu Jun 21 17:13:09 2012] [notice] Apache/2.2.22 (Ubuntu)
>> PHP/5.3.10-1ubuntu3.2 with Suhosin-Patch mod_perl/2.0.5 Perl/v5.14.2
>> configured $
>>
>
> Those log lines are truncated and out of order, so it is hard to trust
> that they are accurate and meaningful or to discern much meaning from
> them.
>
> However, the most likely cause of a problem like this is database
> misconfiguration. Are you sure that your $DatabaseUser and
> $DatabasePassword settings are correct? Can you access the database
> using the mysql command-line client?