This seems to have worked for me, however, since I am using the v2 snapshot stuff, the table to update is 'physmessage' instead of 'messages'.
Thanks for the info! -Craig Bret Baptist ([EMAIL PROTECTED]) wrote: > > This code uses the next year of this current week if the last week of the > year: > strftime(timestr, sizeof(timestr), "%G-%m-%d %H:%M:%S", &tm); > > > This code will always use the current year: > strftime(timestr, sizeof(timestr), "%Y-%m-%d %H:%M:%S", &tm); > > You need to go through the dbmail sources and change all strftime lines to > look like above, with a %Y, instead of a %G. > > > Command to fix mysql entries. > > // It subtracts 1 year from the date in the internal_date column of the > messages table > > UPDATE messages SET internal_date = DATE_SUB(internal_date, INTERVAL 1 YEAR) > WHERE internal_date > now(); >
