As a workaround i created some sql code to migrate data after successfull traq 3.0 installation.
Use it at your own risk :)
[code]
-- Attachements
INSERT INTO traq3_attachments SELECT id,name,contents,type,size,owner_id user_id,ticket_id,FROM_UNIXTIME(uploaded) created_at created FROM traq_attachments;
-- Components
INSERT INTO traq3_components (id,name,project_id) SELECT id,name,project_id FROM traq_components;
-- Custom Fields
INSERT INTO traq3_custom_fields (id,name,code,project_ids) SELECT id,name,code,project_ids FROM traq_custom_fields;
-- Milestones
INSERT INTO traq3_milestones (id,name,slug,codename,info,changelog,due,is_locked,project_id,displayorder) SELECT id,milestone name,slug,codename,info,changelog,due,locked is_locked,project_id,displayorder FROM traq_milestones;
-- priorities
INSERT INTO traq3_priorities (id,name) SELECT id,name FROM traq_priorities;
-- projects
INSERT INTO traq3_projects (id,name,slug,codename,info,next_tid,displayorder) SELECT id,name,slug,codename,info,next_tid,displayorder FROM traq_projects;
-- severities
INSERT INTO traq3_severities (id,name) SELECT id,name FROM traq_severities;
-- statuses
INSERT INTO traq3_statuses (id,name,status,changelog) SELECT id,name,status,changelog FROM traq_ticket_status;
-- subscriptions
INSERT INTO traq3_subscriptions (id,type,user_id,project_id,data) SELECT id,type,user_id,project_id,data FROM traq_subscriptions;
-- tickets
INSERT INTO traq3_tickets (id,ticket_id,summary,body,user_id,project_id,milestone_id,version_id,component_id,type_id,status_id,priority_id,severity_id,assigned_to_id,is_closed,is_private,created_at,updated_at,extra)
SELECT id,ticket_id,summary,body,user_id,project_id,milestone_id,version_id,component_id,type type_id,status status_id,priority priority_id,severity severity_id,assigned_to,closed is_closed,private is_private,from_unixtime(created) created_at,from_unixtime(updated),'' updated_at FROM traq_tickets;
-- ticket_history
INSERT INTO traq3_ticket_history (id,user_id,ticket_id,changes,comment,created_at) SELECT id,user_id,ticket_id,changes,comment,from_unixtime(timestamp) created_at FROM traq_ticket_history;
-- timeline
INSERT INTO traq3_timeline (id,project_id,owner_id,action,data,user_id,created_at) SELECT id,project_id,owner_id,action,data,user_id,from_unixtime(timestamp) created_at FROM traq_timeline;
-- types
INSERT INTO traq3_types (id,name,bullet,changelog,template) SELECT id,name,bullet,changelog,template FROM traq_ticket_types;
-- wiki
INSERT INTO traq3_wiki (id,project_id,title,slug,body,main) SELECT id,project_id,title,slug,body,main FROM traq_wiki;
-- usergroups
INSERT INTO traq3_usergroups (id,name,is_admin) SELECT id,name,is_admin FROM traq_usergroups;
[/code]
As a workaround i created some sql code to migrate data after successfull traq 3.0 installation.
Use it at your own risk :) [code] -- Attachements INSERT INTO traq3_attachments SELECT
id,name,contents,type,size,owner_id user_id,ticket_id,FROM_UNIXTIME(uploaded) created_at created FROM traq_attachments;-- Components INSERT INTO traq3_components (id,name,project_id) SELECT id,name,project_id FROM traq_components;
-- Custom Fields INSERT INTO traq3_custom_fields (id,name,code,project_ids) SELECT id,name,code,project_ids FROM traq_custom_fields;
-- Milestones INSERT INTO traq3_milestones (
id,name,slug,codename,info,changelog,due,is_locked,project_id,displayorder) SELECT id,milestone name,slug,codename,info,changelog,due,locked is_locked,project_id,displayorder FROM traq_milestones;-- priorities INSERT INTO traq3_priorities (id,name) SELECT id,name FROM traq_priorities;
-- projects INSERT INTO traq3_projects (id,name,slug,codename,info,next_tid,displayorder) SELECT id,name,slug,codename,info,next_tid,displayorder FROM traq_projects;
-- severities INSERT INTO traq3_severities (id,name) SELECT id,name FROM traq_severities;
-- statuses INSERT INTO traq3_statuses (id,name,status,changelog) SELECT id,name,status,changelog FROM traq_ticket_status;
-- subscriptions INSERT INTO traq3_subscriptions (id,type,user_id,project_id,data) SELECT id,type,user_id,project_id,data FROM traq_subscriptions;
-- tickets INSERT INTO traq3_tickets (id,ticket_id,summary,body,user_id,project_id,milestone_id,version_id,component_id,type_id,status_id,priority_id,severity_id,assigned_to_id,is_closed,is_private,created_at,updated_at,extra) SELECT id,ticket_id,summary,body,user_id,project_id,milestone_id,version_id,component_id,type type_id,status status_id,priority priority_id,severity severity_id,assigned_to,closed is_closed,private is_private,from_unixtime(created) created_at,from_unixtime(updated),'' updated_at FROM traq_tickets;
-- ticket_history INSERT INTO traq3_ticket_history (id,user_id,ticket_id,changes,comment,created_at) SELECT id,user_id,ticket_id,changes,comment,from_unixtime(timestamp) created_at FROM traq_ticket_history;
-- timeline INSERT INTO traq3_timeline (id,project_id,owner_id,action,data,user_id,created_at) SELECT id,project_id,owner_id,action,data,user_id,from_unixtime(timestamp) created_at FROM traq_timeline;
-- types INSERT INTO traq3_types (id,name,bullet,changelog,template) SELECT id,name,bullet,changelog,template FROM traq_ticket_types;
-- wiki INSERT INTO traq3_wiki (id,project_id,title,slug,body,main) SELECT id,project_id,title,slug,body,main FROM traq_wiki;
-- usergroups INSERT INTO traq3_usergroups (id,name,is_admin) SELECT id,name,is_admin FROM traq_usergroups; [/code]