Extension:Email notification/FAQ

'Please use Your feedback'' for questions to me, I will answer you directly as soon as possible. Thank you. --Nyxos 12:00, 14 Oct 2004 (UTC)'''

Place your questions here:

Error applying the patch to Mediawiki 1.3.4
Reported by an anonymous user:

After applying the path (patch -u -b < enotiff.diff) i try to access the Wiki (mediawiki 1.3.4) and a Database error occour, i think the patch needs changes on database, but how can i apply the changes of the new structure ??? the error was : UPDATE watchlist SET wl_notificationtimestamp = 0 WHERE wl_title='Wickle_Projects_and_Docs' AND wl_namespace = 0 AND wl_user = 2

El error de retorno de MySQL fue"1054: Unknown column 'wl_notificationtimestamp' in 'field list'".

Same question and one answer reported by Nick Triantos:

Hi Tom,

First issue I noticed: I downloaded the full mw1.3.5_incl_enotif1.2 package, but didn't realize the watchlist table needed a new field. It was easy enough to fix, it looks like I just need to add a wl_notificationtimestamp field of type varchar(14), binary.

Minor issue, but maybe worth mentioning in the rel notes or enotif docs page. best, -Nick

Answer: You are both right.

Solution:

OR
 * Apply this sql TABLE command manually to the database
 * use the mysqlcc program

to add the needed wl_notificationtimestamp column manually to the watchlist table of your wiki database.

Content of file /maintenance/archives/patch-email-notification.sql (this file is part of the enotif patch suite and the tgz file)

-- Patch for email notification on page changes T.Gries/M.Arndt 11.09.2004

-- A new column 'wl_notificationtimestamp' is added to the table 'watchlist'. -- When a page watched by a user X is changed by someone else, an email is sent to the watching user X -- if and only if the field 'wl_notificationtimestamp' is '0'. The time/date of sending the mail is then stored in that field. -- Further pages changes do not trigger new notification mails as long as user X has not re-visited that page. -- The field is reset to '0' when user X re-visits the page or when he or she resets all notification timestamps -- ("notification flags") at once by clicking the new button on his/her watchlist page. -- T. Gries/M. Arndt 11.09.2004

ALTER TABLE watchlist ADD (wl_notificationtimestamp varchar(14) binary NOT NULL default '0');