[WebGUI] Nasty upgrade problem 6.2.11 - 6.3.0 script

[Susan Baur]

So, am I the 3rd member of this list? :-)

I've run into a problem upgrading from 6.2.11 to 6.6.5. I get the  
following error when the 6.2.11-6.3.0.

I start seeing things like

>                 Finding wobjects on page 1087
>                         Converting wobject 273
>                         Migrating attachments for Article 273
>                         Converting wobject 241
>                         Migrating attachments for Article 241
>                         Converting wobject 299
> DBD::mysql::st fetchrow_hashref failed: fetch() without execute()  
> at ../../lib/WebGUI/SQL.pm line 412.
> DBD::mysql::st fetchrow_hashref failed: fetch() without execute()  
> at ../../lib/WebGUI/SQL.pm line 412.
> DBD::mysql::st fetchrow_hashref failed: fetch() without execute()  
> at ../../lib/WebGUI/SQL.pm line 412.
> DBD::mysql::st fetchrow_hashref failed: fetch() without execute()  
> at ../../lib/WebGUI/SQL.pm line 412.
>                         Converting wobject 208
>                         Migrating Message Board forums
>                                  Migrating forum 1278
>                                          Migrating subscriptions  
> for forum 1278
>                                          Migrating threads for  
> forum 1278
>                                                  Migrating thread 5
>                                                  Migrating posts  
> for thread 5
>                                                          Setting  
> oldest post for thread 5
>                                                  Migrating thread 13
>                                                  Migrating posts  
> for thread 13
>                                                          Setting  
> oldest post for thread 13
>                                                  Migrating thread 18
>                                                  Migrating posts  
> for thread 18
>                                                          Setting  
> oldest post for thread 18
>                                                  Migrating thread 12
>                                                  Migrating posts  
> for thread 12
>                                                          Migrating  
> post 26
>                                                                   
> Migrating ratings for post 26
>                                                          Migrating  
> post 28
>                                                                   
> Migrating ratings for post 28
>                                                          Migrating  
> post 30
>                                                                   
> Migrating ratings for post 30
>                                                          Migrating  
> post 31
>                                                                   
> Migrating ratings for post 31
>                                                          Migrating  
> post 39
>                                                                   
> Migrating ratings for post 39
>                                                          Migrating  
> post 41
>                                                                   
> Migrating ratings for post 41
>                                                          Setting  
> oldest post for thread 12
>                                  WARNING: Couldn't finish  
> processing threads for 1278 because something nasty occured in the  
> database. Setting oldest post for forum 1278

The upgrade process continues and eventually finishes, but the  
"upgraded" site needs a lot of hand fixing afterwards, especially  
with the templates. I've run the pagetree-bruteforce-fix, and have  
had to manually restore the home page to nameless_root as well as  
recreate my clipboard on this site. The site is being actively  
developed and being on 6.2.11 is causing some other problems, so  
sticking with this version is not an option. The first webobject it's  
choked on is a sql report, but it converts a different sql report on  
the same page apparently without hiccups later on in the process.

Any ideas what I can do to get this thing upgraded?

Luckily, I have a copy of the site (3 sites actually, but only 1 is  
having this problem) that I can blow away repeatedly on a second non- 
production server, so radical suggestions for testing are ok.

Susan

--
Susan Baur
System Administrator
Center for Distributed Learning
707-664-4408
susan at cdl.edu