[phpGroupWare-users] Re: tts error on .512

[Danny Williams]

I'm just replying to post my solution for anyone else
who gets this and wants the ticket system in their groupware.

here is how the tables SHOULD be created.

--
-- Table structure for table `phpgw_tts_tickets`
--

DROP TABLE IF EXISTS phpgw_tts_tickets;
CREATE TABLE phpgw_tts_tickets (
  ticket_id int(11) NOT NULL auto_increment,
  ticket_group varchar(40) default NULL,
  ticket_priority smallint(6) NOT NULL default '0',
  ticket_owner varchar(10) default NULL,
  ticket_assignedto varchar(10) default NULL,
  ticket_subject varchar(255) default NULL,
  ticket_category varchar(25) default NULL,
  ticket_billable_hours decimal(8,2) NOT NULL default '0.00',
  ticket_billable_rate decimal(8,2) NOT NULL default '0.00',
  ticket_status char(1) NOT NULL default '',
  ticket_details text NOT NULL,
  ticket_type smallint(6) NOT NULL default '0',
  ticket_deadline varchar(10) NOT NULL default '',
  ticket_effort varchar(4) NOT NULL default '',
  ticket_platform smallint(6) NOT NULL default '0',
  ticket_attachment smallint(6) NOT NULL default '0',
  PRIMARY KEY  (ticket_id)
) TYPE=MyISAM;

However in a recent snapshot I downloaded the platform and attachment tables 
did not created and I DID NOT upgrade.
this was a fresh install.

so for those of you who already have the tables installed and already made 
modifications elsewhere and re-installing isn't an option..
Login to mysql and go to your phpgw database.

alter table phpgw_tts_tickets modify ticket_platform smallint(6) not null 
default '0';

and

alter table phpgw_tts_tickets modify ticket_attachment smallint(6) not null 
default '0';

My ticket system is now working.

Also this link
http://216.239.51.104/search?q=cache:j8BxN3YE6fEJ:forums.phpgroupware.org/index.php%3Ft%3Dgetfile%26id%3D81%26rid%3D0%26S%3D2a88957b312e3f0447a44c78757a5367+Unknown+column+%27ticket_attachment%27+in+%27field+list%27&hl=en&ct=clnk&cd=3&gl=us&client=firefox-a

has a cached version of the tables create incase any of you (or me for that 
matter) run across any other failed to be made tables.

Best Regards,
Dan. Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org