[rt-devel] Re: [rt-users] Ticket Number Generation

[Ted Serreyn]

I have also tried the following, it was suggested that with innodb, you need
to create and then remote a bogus record, however I can not even insert the
temp record.  This breaks things enough that I can no longer open a ticket.


mysql> ALTER TABLE Tickets AUTO_INCREMENT = 20040308000;
Query OK, 14 rows affected (0.02 sec)
mysql> set INSERT_ID=20040308000;
Query OK, 0 rows affected (0.00 sec)
mysql> ALTER TABLE Tickets AUTO_INCREMENT = 20040308000;
Query OK, 14 rows affected (0.06 sec)
Records: 14  Duplicates: 0  Warnings: 0
,0,0,'rINSERT INTO Tickets Values
(20040308000,1,1,'ticket',0.0,12,'blank',0,0,,
mysql> set INSERT_ID=20040308000;
Query OK, 0 rows affected (0.01 sec)

,0,0,> INSERT INTO Tickets Values
(20040308000,1,1,'ticket',0.0,12,'blank',0,0, 
    -> 'resolved',0,NULL,'1970-01-01 00:00:00','1970-03-08 22:13:23',
    -> '1970-01-01 00:00:00','1970-01-01 00:00:00',12,'1970-01-01 00:00:00',
    -> 12,'1970-01-01 00:00:00',0);
ERROR 1136: Column count doesn't match value count at row 1
mysql>

--
Ted Serreyn                          262-363-9265
Serreyn Network Services, LLC        http://www.serreyn.com/


-----Original Message-----
From: rt-devel-bounces at lists.bestpractical.com
[mailto:rt-devel-bounces at lists.bestpractical.com] On Behalf Of Ted Serreyn
Sent: Monday, March 08, 2004 5:30 PM
To: 'Bruce Campbell'; rt-devel at lists.fsck.com
Subject: RE: [rt-devel] Re: [rt-users] Ticket Number Generation

I can not seem to even get the auto_inc value working manually to set the
next ticket number generated.

Ideas?

A am trying to do the following:

Mysql rt3;
set INSERT_ID=20040308000;
ALTER TABLE Tickets AUTO_INCREMENT = 20040308000;

I would think that the next ticket should be id 20040308001, but I get back
my normal number?

--
Ted Serreyn                          262-363-9265
Serreyn Network Services, LLC        http://www.serreyn.com/


-----Original Message-----
From: rt-devel-admin at lists.fsck.com [mailto:rt-devel-admin at lists.fsck.com]
On Behalf Of Bruce Campbell
Sent: Thursday, August 22, 2002 5:14 PM
To: rt-devel at lists.fsck.com
Subject: [rt-devel] Re: [rt-users] Ticket Number Generation

On Thu, 22 Aug 2002, Pat Steffensen wrote:

> it loaded and running (which was the opposite of painless), but don't want
> to start at number 1...I'd like a YYMMDDTicketNumber sort of syntax...any
> advice or direction would be greatfully apprecated!  Thanks,

Hrm, problem - wanting to have something other than bog-standard
id-from-Tickets-table.  It happens often enough, and why not allow free
text as the identifier.  It'd be easy enough to change the identifier
given to requestors/Ccs, and the inputs shown on the web.

Apart from upping the auto_inc value on the table each night, what other
solutions have people come up with?

-- 
                             Bruce Campbell                            RIPE
                   Systems/Network Engineer                             NCC
                 www.ripe.net - PGP562C8B1B             Operations/Security

_______________________________________________
rt-devel mailing list
rt-devel at lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

_______________________________________________
rt-devel mailing list
rt-devel at lists.bestpractical.com
http://lists.bestpractical.com/mailman/listinfo/rt-devel