[phpBT-dev] Logging the upgrade process

[Ulf E. <ulf...@fa...>]

Hoi,

There are two fairly new threads about failures with upgrading:
   http://sourceforge.net/forum/message.php?msg_id=2664123
   http://sourceforge.net/forum/message.php?msg_id=3000998

Both reports indicate that upgrade.php doesn't change the database as 
intended, and one of them that the problem is that v0.9 doesn't have a 
DB_VERSION field.

My first attempt would be to count the number of fields before querying 
for the DB_VERSION. (just in case it is possible to have a setup that 
throws an error or returns a big positive "value" when the field doesn't 
exists)

My next suggestion would be to log all queries and replies. That would 
make it quite simple to spot any issues of this kind. You probably want 
something similar for install.php.

The alternative upgrade.php attached implements these two ideas. 
Unfortunately is a full log a bit too much text.. Your comment about 
manually changes needed for closed states gets a bit lost. Somewhat 
better might be to show the log in a textarea but only if there has been 
an error? Still I think a log would greatly help debugging this issue.

Thoughts? Comments?

-- 
Ulf