<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">Hi Liza,<DIV><BR class="khtml-block-placeholder"></DIV><DIV>4.5 to 4.6 was a tough upgrade, as I recall. From what I remember, what I had to do on a couple of sites is move back through the update versions. Your database update seems to have missed a column insert in a previous update. (A (mis)educated guess.)</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>I believe a number of people were able to get the update to work by moving backwards through the db upgrade numbers. You might even dig through the update file looking for "severity" and scroll up from there to the update number it involves.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>In fact, I just dug through updates.inc (in the database folder) and found this:</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>function update_115() {</DIV><DIV> $ret = array();</DIV><DIV> if ($GLOBALS['db_type'] == 'mysql') {</DIV><DIV> $ret[] = update_sql("ALTER TABLE {watchdog} ADD severity tinyint(3) unsigned NOT NULL default '0'");</DIV><DIV> }</DIV><DIV> else if ($GLOBALS['db_type'] == 'pgsql') {</DIV><DIV> $ret[] = update_sql('ALTER TABLE {watchdog} ADD severity smallint');</DIV><DIV> $ret[] = update_sql('UPDATE {watchdog} SET severity = 0');</DIV><DIV> $ret[] = update_sql('ALTER TABLE {watchdog} ALTER COLUMN severity SET NOT NULL');</DIV><DIV> $ret[] = update_sql('ALTER TABLE {watchdog} ALTER COLUMN severity SET DEFAULT 0');</DIV><DIV> }</DIV><DIV> return $ret;</DIV><DIV>}</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>You might try rerunning update.php, and manually selecting version 115, and see how that goes.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>OR (safer) extract the MySQL from this update, convert it into mysql syntax and run the commands manually.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Hope this helps!</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>BTW, if this is CivicSpace (which I guess only from your db name), why are you doing a Drupal upgrade and not a CivicSpace upgrade?</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Best,</DIV><DIV>Laura<BR><DIV> <SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Verdana; font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><DIV><FONT class="Apple-style-span" color="#066CBD"><B style="color: rgb(6, 108, 189); font-weight: bold; "><BR class="khtml-block-placeholder"></B></FONT></DIV><DIV><FONT class="Apple-style-span" color="#066CBD"><B style="color: rgb(6, 108, 189); font-weight: bold; "><BR class="khtml-block-placeholder"></B></FONT></DIV><DIV><FONT class="Apple-style-span" color="#FF4300"><B style="color: rgb(255, 67, 0); font-weight: bold; "><SPAN class="Apple-style-span" style="color: rgb(255, 67, 0); font-weight: bold; ">pingVision, LLC</SPAN></B></FONT></DIV><DIV><FONT class="Apple-style-span" color="#FF4300"><SPAN class="Apple-style-span" style="color: rgb(255, 67, 0); ">4450 Arapahoe Ave, Suite 100</SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" color="#FF4300"><SPAN class="Apple-style-span" style="color: rgb(255, 67, 0); ">Boulder, CO 80303</SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" color="#FF4300"><BR class="khtml-block-placeholder"></FONT></DIV><DIV><A href="http://www.pingv.com"><FONT class="Apple-style-span" color="#FF4300"><SPAN class="Apple-style-span" style="color: rgb(255, 67, 0); -khtml-text-decorations-in-effect: underline; ">www.pingv.com</SPAN></FONT></A></DIV><DIV><FONT class="Apple-style-span" color="#FF4300"><SPAN class="Apple-style-span" style="color: rgb(255, 67, 0); ">303.415.2559</SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" color="#FF4300"><SPAN class="Apple-style-span" style="color: rgb(255, 67, 0); "><A href="mailto:inquiry@pingv.com">inquiry@pingv.com</A></SPAN></FONT></DIV><DIV><BR class="khtml-block-placeholder"></DIV><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Verdana; font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "></SPAN><BR class="Apple-interchange-newline"></SPAN> </DIV><BR><DIV><DIV>On May 29, 2006, at 8:54 PM, <A href="mailto:blogdiva@culturekitchen.com">blogdiva@culturekitchen.com</A> wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite">And of course, there's an error message (those who've heard of me know I'm jinxed)<DIV><BR class="khtml-block-placeholder"></DIV><BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Fatal error: Unknown column 'severity' in 'field list' query: INSERT INTO civsp_watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (1, 'php', 'Table &#039;liza_dailygotham_2.civsp_queue&#039; doesn&#039;t exist\nquery: SELECT uid, vote FROM civsp_queue WHERE nid = 1856 in /home/liza/domains/dailygotham.com/public_html/NEW/includes/database.mysql.inc on line 66.', 2, '', '/NEW/index.php', '207.237.24.22', 1148953436) in /home/liza/domains/dailygotham.com/public_html/NEW/includes/database.mysql.inc on line 66</DIV></BLOCKQUOTE><BR><DIV>I've followed the following instructions to the t : </DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><A href="http://drupal.org/node/30699">http://drupal.org/node/30699</A></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>And here's where I got in trouble : When I read step #6, I assumed it meant the latest version of 4.6 not the actual 4.6.0. is this a correct assumption? That I will have to upgrade to 4.6.0 first before going on to 4.6.7?</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>What do I do now? I did not get any blaring red messages after the DB upgrade; but, am I supposed to get an update after each date annotated by the program?</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Also, would it be possible to fix this extremely important page by linking each version to the actual download page I'd have to go to? </DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Thanks, </DIV><DIV> <SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><B style="font-weight: bold; "><SPAN class="Apple-style-span" style="font-weight: bold; "><SPAN class="Apple-style-span" style="font-weight: bold; "><SPAN class="Apple-style-span" style="font-weight: bold; "><SPAN class="Apple-style-span" style="font-weight: bold; "><SPAN class="Apple-style-span" style="font-weight: bold; ">Liza Sabater, Publisher</SPAN></SPAN></SPAN></SPAN></SPAN></B></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">www.culturekitchen.com</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">www.dailygotham.com</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><BR class="khtml-block-placeholder"></DIV></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></DIV><BR><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">--<SPAN class="Apple-converted-space"> </SPAN></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">[ Drupal support list | <A href="http://lists.drupal.org">http://lists.drupal.org</A>/ ]</DIV> </BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>