eventid eventname repeattype every period
1 Christmas Day N 0  
2 News Years Day N 0  
3 Arcadia Rodeo N 0  
4 Arcadia Rodeo N 0  
5 Arcadia Rodeo N 0  
6 Western Parade N 0  
7 Lehigh Fire Board meeting N 0  
8 Lee County Sheriff Open House N 0  
9 Lehigh Town Hall Meeting-re crime N 0  
10 Phoenix Award N 0  
11 Medieval Faire N 0  
12 Medieval Faire N 0  
13 Medieval Faire N 0  
14 Medieval Faire N 0  
15 Lee County Senior Games N 0  
16 VIVA NAVIDAD N 0  
17 Small Business Workshop N 0  
18 Little League Signups N 0  
20 3/21 7:30 pm - LAFD Board Meeting @ Station 1 on Joel Blvd N 0  
21 4/19 7:30 pm - LAFD Board Meeting N 0  
22 5/16 7:30 pm - LAFD Board Meeting @ Library N 0  
23 LAFD Board Meeting N 0  
24 LAFD Board Meeting N 0  
25 LAFD Board Meeting N 0  
27 Fire Board Meeting N 0  
28 Cape Coral Firefighters vs Cape Coral Police N 0  
29 Super Bowl Game N 0  
30 DAYTONA WEEK N 0  
31 Public Meeting LAFD-Workshop type N 0  
32 3/13 5:00 pm - Public Mtg w/Lehigh Lighting District @ Cty Commissioners' Chambers N 0  
33 Ribbon Cutting N 0  
34 Membership Committee Meeting N 0  
35 Business After Hours N 0  
36 Anastasini N 0  
37 Taste of Lehigh N 0  
38 RN/LPN JOB FAIR N 0  
39 Lehigh Little League N 0  
40 3/17 10:00 am - Lehigh Little League Picture Day N 0  
41 3/24 11:00 am - Lehigh Spring Festival Parade N 0  
42 Daylight Savings Time N 0  
43 3/16 thru 3/24 - Lehigh Annual Spring Festival N 0  
44 4/18 6:30 pm - FGUA UAC Meeting @ Veterans' Park N 0  
45 FGUA UAC Meeting N 0  
46 FGUA UAC Meeting N 0  
47 FGUA UAC Meeting N 0  
48 FGUA UAC Meeting N 0  
49 3/26 6:30 p.m. - ECWCD Board Meeting N 0  
50 4/23 6:30 pm - ECWCD Board Meeting N 0  
51 5/29 6:30 pm - ECWCD Board Meeting N 0  
52 ECWCD Board Meeting N 0  
53 ECWCD Board Meeting N 0  
54 ECWCD Budget Meeting N 0  
55 ECWCD Board Meeting N 0  
56 ECWCD Board Meeting N 0  
57 CANCELED - Lee Cty School Board Town Hall Meeting - Lehigh Acres N 0  
58 Luckett Rd Ext Meeting N 0  
60 3/14 6:30 pm - Lehigh Acres Community Planning Corp. BOD Monthly Meeting N 0  
61 4/11 6:30 pm - Lehigh Acres Community Planning Corp. BOD Monthly Meeting - CANCELLED N 0  
62 5/9 6:30 pm - Lehigh Acres Community Planning Corp. BOD Monthly Meeting N 0  
63 3/12 6:30 pm - LACPC Water Mgt Subcommittee Mtg N 0  
64 3/15 7:00 pm - LACPC Beautification & Conservation Subcommittee Mtg N 0  
65 3/22 7:00 pm - LACPC Roads & Infrastructure Subcommittee Mtg N 0  
67 3/12 6:30 pm - LACPC Arch Review/Code Enforcement subcommittee mtg @ E. Cty. Library N 0  
68 4/19 7:00 pm - LACPC Beautification & Conservation Subcommittee Mtg N 0  
69 3/21 6:00 pm - Lehigh Acres Community Visioning Session - EVENING @ Lehigh Sr. High School N 0  
70 3/22 9:00 am - Lehigh Acres Community Visioning Session - MORNING @ Veterans' Park N 0  
71 3/22 6:00 pm Lehigh Acres Community Visioning Session - EVENING @ Veterans' Park N 0  
72 Spring Training Game N 0  
74 4/6 7:05 Miracle Baseball Game N 0  
75 Literacy Council fundraiser N 0  
76 Law Enforcement Softball/baseball game N 0  
77 LAL Miracle Baseball Game N 0  
78 5/26 7:00 pm - LAL @ Miracles' Baseball Game! N 0  
79 4/28 10:00 a.m. - Lehigh Community Visioning Session IV - Faith Lutheran Church N 0  
80 4/22 10:00 a.m. Public Safety Teams Softball Tourny N 0  
81 Bike Nite in Cape Coral N 0  
82 4/24 6:00 p.m. Waste Treatment Plant Meeting N 0  
83 5/9 2:00 p.m. - Mtg. re. proposal for 2 entry/exit points req'd for Lehigh developers N 0  
84 5/11 8:00 a.m. - Mtg. re. proposal for 2 entry/exit points req'd for Lehigh developers N 0  
85 5/21 8:30 a.m. - Mtg. re. proposal for 2 entry/exit points req'd for Lehigh developers N 0  
86 6/12 5:00 p.m. - BCC public hearing re. proposal for 2 entry/exit points req'd for Lehigh developers N 0  
87 6/26 5:00 p.m. - Final PUBLIC HEARING re. proposal for 2 access points req'd for Lehigh developers N 0  
90 Independence Day N 0  
92 5/3 6:30 p.m. - Lehigh Clean Sweep Meeting @ Veterans Park N 0  
93 Support Your Sheriff!! N 0  
94 Lee Co Sheriff vs Fire Depart Softball Game N 0  
95 LACPC Monthly Board of Directors Meeting (open to the public) N 0  
96 Sonny Haas to speak/answer questions at East Cty library (Gunnery Rd.) N 0  
97 Happy B-Day Mommyof1inla N 0  
98 Town Hall Meeting with Senators Aaronberg and Bennett N 0  
99 Public Auction - Admiral Lehigh Resort's contents N 0  
100 Free Hurricane Preparedness Seminar with Tom Johnston, Fox 4’s chief meteorologist N 0  
102 I-75 Toll Concept N 0  
103 Jim Fleming Eco Park on Lee Boulevard - Groundbreaking Ceremony N 0  
105 Happy Birthday, wysiwyg ! N 0  
106 sobaka_sam's Birthday P1 1 Y
107 Sheriff's Budget Workshop N 0  
108 jbekmom's Birthday P1 1 Y
109 Zoning Hearing for 'The Villages' - Your Support is NEEDED So Project Can Proceed To Planning Stage! N 0  
110 Community Visioning Sessions Summary Workshop N 0  
111 Public Information Workshop on Luckett Rd/Sunshine Corridor Extension Studies N 0  
114 Anniversary of Lehigh Acres Live P1 365 D
116 Labor Day N 0  
119 Sonny Haas Trash Bash Fishing Tournament N 0  
120 NE Patriots beat the Tampa Bucs in Tampa N 0  
122 Community Blood Drive N 0  
123 BLOOD DRIVE AT LEHIGH REGIONAL MEDICAL CENTER N 0  
124 Meet & Greet "Fun Raiser" for Lehigh's own resident running for County Commissioner N 0  
126 VoteLehigh.org Voter Drive Meeting N 0  
127 LAL 1 year Anniversary Party N 0  
128 LAFD BUDGET HEARING-FINAL N 0  
129 LAFD BOARD MTG N 0  
130 LACPC Meeting N 0  
131 BOCC Incorporation Meeting N 0  
132 Lee County Board of County Commissioners Budget mtg N 0  
133 Town Hall Meeting N 0  
134 Town Hall Meeting N 0  
135 Town Hall Meeting N 0  
136 Town Hall Meeting N 0  
137 Fire Prevention and Safety Day N 0  
138 LAFD COMMISSION MTG-LIBRARY N 0  
139 LAFD COMMISSION MTG-library N 0  
140 LAFD COMMISSION MTG-Station 105 on 636 S. Thomas Sherwin Ave (corner of Bell & Milwaukee) N 0  
144 Community Blood Drive N 0  
145 FGCU 10 Year Anniversary "Community Day" - Free BBQ Lunch! N 0  
146 Lehigh Charter Review N 0  
147 Sonny Haas Fundraiser at the CRU N 0  
148 Community Blood Drive Mayer Dental N 0  
149 Community Blood Drive Lehigh Regional Hospital N 0  
150 Community Blood Drive Publix Plaza Homestead Rd. N 0  
151 Lehigh Acres Chamber of Commerce Business After Hours N 0  
152 Family Fun Day - Get Out The Vote! 11-4 N 0  
153 Veterans Day N 0  
154 Thanksgiving N 0  
156 Live Nativity N 0  
157 News Years Eve P1 1 Y
158 New Years Day N 0  
159 Merry Christmas N 0  
160 Lee County Legislative Delegation Meeting re. Lehigh Incorporation Issue @Edison College - IMPORTANT N 0  
161 Citizens for Cityhood - Speakers Group Meeting - Prepare for Lee Cty Legislative Delegation Meeting N 0  
162 Dr. Martin Luther King Jr, Day N 0  
163 Valentines Day N 0  
164 Presidents Day (No School) N 0  
165 Ash Wednesday N 0  
166 St Patrick's Day N 0  
167 George Washington's Birthday N 0  
168 Abraham Lincoln's Birthday N 0  
169 Mexican Flag Day N 0  
170 Palm Sunday N 0  
171 Good Friday N 0  
172 Easter Sunday N 0  
173 May Day N 0  
174 Mother's Day N 0  
175 Memorial Day N 0  
176 Father's Day N 0  
177 Independence Day N 0  
178 Labor Day N 0  
179 Columbus Day N 0  
180 Halloween N 0  
181 Veterans Day N 0  
182 Thanksgiving N 0  
185 MICHIGAN vs florida N 0  
192 Community Council LA N 0  
193 Citizens For Cityhood; Spanish Meeting for Cityhood N 0  
194 ECWCD Brd Mtg; CHA bdg N 0  
195 Citizens For Cityhood MTG; Majestic GC N 0  
196 LA FIRE COMMISSION MTG N 0  
197 Incorporation Town Hall Meeting N 0  
198 Early Voting N 0  
199 Election Day N 0  
200 WRT to meet with LACPC - open to public - Veterans Park N 0  
201 WRT to host Town Hall meetings. N 0  
202 Yard of the Month Nomination N 0  
203 Sonny Haas Townhall Meeting N 0  
204 Kiwanis and Rotary Erect Pavilions at Park N 0  
205 Kiwanis Club Meeting N 0  
206 Richter Townhall Meeting Cancelled N 0  
207 LAFD commission mtg-station 105 N 0  
208 The ABC's of Avoiding Foreclosure N 0  
209 LSHS Band Fundraiser N 0  
210 LAFD COMMISSION MTG-station 5 N 0  
211 ECWCD Board Mtg M1 4 1
212 Community Council of LA M1 3 1
213 Online Town Hall Meeting N 0  
214 LAFD COMMISSION MTG-Veterans Park N 0  
215 ECWCD Sprecial Meeting at District Offices N 0  
216 Earth Day N 0  
217 Fallen Heros Poker Run N 0  
218 Scholarship Fund-Raiser N 0  
219 Music in the Park N 0  
220 Meet Rod Shoap N 0  
221 LAFD Commission mtg @ Veterans Park N 0  
222 LAFD Commission Mtg N 0  
224 Community Blood Drive N 0  
225 Blood Pressure Screening N 0  
226 Blood Pressure Screening N 0  
227 Blood Pressure Screening N 0  
228 LMH Blood Drive N 0  
229 FBC Community Blood Drive N 0  
230 Oldtimers Softball League N 0  
231 PC's Pet Party N 0  
232 Meet The Candidates N 0  
233 Shadow's Birthday P1 1 Y
234 Chrissy's Birthday P1 1 Y
235 Sonny Haas Fundraiser @Coral Lanes/Cape Coral 4-6 p.m. N 0  
236 Flag Day P1 1 Y
237 Freedom Fun Fest N 0  
238 LAFD Budget Workshop N 0  
239 LAFD Budget Workshop N 0  
240 LAFD Budget Workshop N 0  
241 LAFD Budget Workshop N 0  
242 LAFD Budget Hearing N 0  
243 LAFD Final Budget Hearing N 0  
244 LAFD Commish Meeting N 0  
245 LAFD Commish Meeting N 0  
246 LAFD Commish Meeting N 0  
247 wysiwyg's birthday N 0  
248 Happy Birthday stratman! N 0  
249 Truth About Child Abuse N 0  
250 Meet Senator Aronberg N 0  
251 Ft. Myers Shores Chorale Seventh Day Adventist Church N 0  
252 Meet the Candidates N 0  
253 Go Vote! N 1 D
254 Go Vote N 0  
255 Go Vote N 1 D
256 Go Vote N 0  
257 Election Day - Go Vote N 0  
258 Panther Community Bank - August Sneaker Drive N 0  
259 Women’s event to aid homeless, working poor and their children N 0  
260 $5 CAR WASH @ Reliance Bank on Lee Blvd N 0  
261 Politics in the Park N 0  
262 High School Car Wash N 0  
263 Pasta Palooza N 0  
264 Meet Kreegel Aide N 0  
265 Blood Drive N 0  
267 RaeRae's B-Day! N 0  
268 Lean Sigma for Health Care N 0  
269 Lean Sigma for Healthcare N 0  
270 Lean Sigma for Healthcare N 0  
271 Lean Sigma for Healthcare N 0  
272 Lean Sigma for Healthcare N 0  
273 Lean Sigma for Healthcare N 0  
274 Lean Sigma for Healthcare N 0  
275 Lean Sigma for Healthcare N 0  
276 Dynamics of Supervision l N 0  
277 Dynamics of Supervision l N 0  
278 Dynamics of Supervision l N 0  
279 1yrLARes's Birthday! P1 1 Y
280 Panther Community Bank Friday Showcase Book Signing. N 0  
282 Lehigh Democratic Club Meeting N 0  
283 LAFD Annual Fire Prevention and Safety Day N 0  
284 LAFD Commish Meeting N 0  
285 LAFD Commish Meeting N 0  
286 LAFD Commish Meeting N 0  
287 LAFD Commish Meeting N 0  
288 LAFD Commish Meeting N 0  
289 LAFD Commish Meeting N 0  
290 LAFD Commish Meeting N 0  
291 LAFD Commish Meeting N 0  
292 LAFD Commish Meeting N 0  
293 LAFD Commish Meeting N 0  
294 LAFD Commish Meeting N 0  
295 LAFD Commish Meeting N 0  
296 Walgreen's Flu Vaccines Begin N 0  
297 Presidential Debates N 0  
298 Vice Presidential Debates N 0  
299 Presidential Debate N 0  
300 Presidential Debate N 0  
301 LAFD Fire Station Grand Opening N 0  
302 Early Voting P1 1 D
303 Early Voting N 0  
304 Early Voting P1 1 D
305 Early Voting N 0  
306 General Election Go Vote N 0  
307 Spring Break Cruise N 0  
308 Stuffed Baked Potato Dinner To Benefit Our Daily Bread N 0  
309 David Byers Benefit N 0  
310 LA Chamber of Commerce Golf Tournament N 0  
311 Panther Community Bank Monthly Book Swap N 0  
312 Lehigh Acres Chamber Commerce Trade Show N 0  
313 Yankkeezephyr's B-Day! P1 1 Y
314 Truth Seeker's B-Day P1 1 Y
315 Riddler's B-Day Y1 1 3/31/2010
316 iloveLA's B-Day P1 1 Y
317 Wold1's Birthday! P1 1 Y
318 aksmedic's Birthday! P1 1 Y
319 Pili's Son's Birthday! P1 1 Y
320 Mac Daddy's Birthday P1 1 Y
321 Silverine77's B-Day P1 1 Y
323 Pili's B-Day P1 1 Y
326 TRUNKER TREAT NIGHT N 0  
328 ETHNIC FASHION FLARE N 0  
329 Blood Drive N 0  
330 Lehigh Acres Post Office Food Drive N 0  
331 Panther Community Bank Book Swap N 0  
332 Panther Book Signing Even N 0  
333 Dynamics of Supervision I N 0  
334 Implementing Lean Concepts in YOUR Organization N 0  
335 LA Community Forum @ Microtel Inn N 0  
336 Blood Drive N 0  
337 Blood Drive N 0  
338 Donnie & Jeff's 7th Annual Charity Golf Benefit N 0  
339 Animal Medical Center Open House N 0  
340 Halloween Dance and Party @ Lehigh Senior Center N 0  
341 Leave A Legacy to Lehigh Community Services N 0  
342 Fall rummage sale N 0  
343 Keys To Retaining Your Employees N 0  
344 Valentine's Day! P1 1 Y
345 No Garbage Pickup N 0  
346 No Trash Pickup P1 1 Y
347 Merry Christmas P1 1 Y
348 Dr. Martin Luther King Holiday N 0  
349 New Years Day P1 1 Y
350 No Garbage Pickup P1 1 Y
352 Lehigh Community Services 1st Annual Golf Tournament N 0  
353 Panther Community Bank - Book Signing N 0  
354 Luncheon for emergency workers N 0  
361 Meet Rep. Kreegel Staff N 0  
365 Dynamics of Supervision II N 0  
366 Dynamics of Supervision II N 0  
367 Dynamics of Supervision II N 0  
368 SUPERVISOR TRAINING N 0  
378 Final Public Hearing on LA Community Plan developed by consulting firm WRT- LACPC annual mtg follows N 0  

 

4.00.02

Assuming you didn't get the message in my last post, because it looks like it got part way through the upgrade, you can try running this script. It will set your system up to re-run the 4.1.0 upgrade processing (it will not do 4.1.1 or 4.1.2). You will need to retart the application to get the upgrade to run (or at least that is the quickest way), which can be done in the Hoset Settings dialogue right at the bottom. You will need to tick Execute as Script in the Host/SQL dialogue.

Cheers
Roger

Delete from {databaseOwner}{objectQualifier}Permission where PermissionKey='EVENTSCAT' OR PermissionKey='EVENTSLOC'
GO

UPDATE    {databaseOwner}{objectQualifier}EventQueue
SET              IsComplete = 0,
                      Attributes = '<Attributes><Attribute><Name>BusinessControllerClass</Name><Value>DotNetNuke.Modules.Events.EventController, DotNetNuke.Modules.Events</Value></Attribute><Attribute><Name>DesktopModuleId</Name><Value>'
                       + CONVERT(varchar, DesktopModuleID)
                      + '</Value></Attribute><Attribute><Name>UpgradeVersionsList</Name><Value>04.01.00</Value></Attribute></Attributes>'
FROM         {databaseOwner}{objectQualifier}EventQueue CROSS JOIN
                      {databaseOwner}{objectQualifier}DesktopModules
WHERE     (EventQueue.EventMessageID IN
                          (SELECT     MAX(EventMessageID) AS Expr1
                            FROM          {databaseOwner}{objectQualifier}EventQueue AS EventQueue_1
                            WHERE      (Attributes LIKE '%DotNetNuke.Modules.Events.EventController, DotNetNuke.Modules.Events%') AND
                                                   (ProcessorCommand = N'upgrademodule'))) AND (ModuleName = N'DNN_Events')
GO