[whups] [patch] update_logs_table.php
Jason M. Felice
jfelice at cronosys.com
Fri Aug 22 11:42:00 PDT 2003
My old comments weren't showing up because there were no entries in
whups_logs for the comments in whups_comments.
The following patch to update_logs_table.php will add the appropriate
entries.
It's the first patch from `epm', my new patch manager, so let me know if it
horks (it applies fine here).
--
Jason M. Felice
Cronosys, LLC <http://www.cronosys.com/>
216.221.4600 x302
-------------- next part --------------
epm diff update_logs_table.php
--- update_logs_table.php 2003-08-22 14:35:34.000000000 -0400
+++ update_logs_table.php 2003-08-22 14:37:08.000000000 -0400
@@ -72,6 +72,42 @@
}
}
+$sql = 'INSERT INTO whups_logs (
+ ticket_id,
+ state_id_to,
+ priority_id_to,
+ log_timestamp,
+ user_id,
+ comment_id_log,
+ type_id_to,
+ module_id_to,
+ user_uid_action,
+ user_uid_changed
+ ) SELECT
+ whups_comments.ticket_id,
+ whups_tickets.state_id,
+ whups_tickets.priority_id,
+ whups_comments.comment_timestamp,
+ whups_comments.user_id_creator,
+ whups_comments.comment_id,
+ whups_tickets.type_id,
+ whups_tickets.module_id,
+ NULL,
+ NULL
+ FROM
+ whups_comments,
+ whups_tickets
+ WHERE
+ whups_tickets.ticket_id = whups_comments.ticket_id
+ AND whups_comments.comment_id NOT IN (
+ SELECT comment_id_log FROM whups_logs
+ );';
+$result = $db->query($sql);
+if (is_a($result,'PEAR_Error')) {
+ $output .= 'Could not add log entries for old comments.';
+ $output .= $result->toString() . "\n\n";
+}
+
if (empty($output)) {
echo "Migrated successfully.\n";
} else {
More information about the whups
mailing list