From: Damian P. <da...@da...> - 2006-01-18 20:43:59
|
yo, Spiderr has just pointed out a subselect in the 1.8to1.9.sql file as he was making the TikiWiki 1.9 to Bitweaver conversion routines. This wont work on anything before mysql 4.1 and needs to be replaced with something suitable for all databases: ---8<--- UPDATE tiki_user_tasks set title = '-' where title IS NULL; INSERT INTO tiki_user_tasks_history (belongs_to, title, start, description, lasteditor, lastchanges, priority, completed, status, percentage) SELECT taskId, title, date, description, user, date, priority, completed, status, percentage FROM tiki_user_tasks; ---8<--- Thanks -- Damian Parker http://www.damosoft.co.uk |