Upgrade fails: 0.11 beta1 to 0.12 beta1

[martin42]

My test server has FreeBSD 6.0, PostgreSQL 8.1.2, PHP 4.4.2, Mathopd 1.5p5.
config.php has dmbs='postgres7' but 'postgres8' also works.
CMSMS 0.11 beta1 works fine, but now it's time to upgrade...
The web server process user owns all the files, and has full read/write access to all files and all database tables...

OK, so we load up /install/upgrade.php in the web browser (Firefox 1.5.0.1 on FreeBSD 6.0).  It begins well enough...

Code: Select all

Welcome to the CMS Upgrade System!

In order to upgrade properly, upgrade needs to have write access to your config.php file. This is so any extra settings that have been introduced in this version can be set to their defaults.

Upgrading config.php...[done]
Cleaning cache dirs...[done]
CMS is in need of an upgrade.

You are now running schema version 12 and you need to be upgraded to version 18.
Please click here to complete it.

... but "click here to complete" doesn't seem to work...

Code: Select all

Upgrade System

Upgrading config.php...[done]
Cleaning cache dirs...[done]
Converting templates using headtags... 

The page doesn't hang - it just stops.

Server error log shows:

Code: Select all

PHP Fatal error:  Call to undefined function:  rowcount() in /usr/testweb/www.example.com/install/upgrades/upgrade.12.to.13.php on line 8

Any thoughts?

Thanks!!

[Albert]

I've noticed this also - this happens because 0.12 uses the 'lite' edition of adodb. I used the following workaround:
- copy the lib/adodb dir from version 0.11 to your current version
- change the var use_adodb_lite to false in config.php
- run the upgrade script (which will run nicely now)
- cleanup: change the var in config.php back to true and remove the lib/adodb dir

The upgrade script should be fixed though...

[Ted]

I'm going to have to test the upgrades in postgres.  I believe there could be another potential problem as well.

[martin42]

Thanks both... Upgrade script completes OK now.

I guess 'use_adodb_lite' should default to false (certainly for dbms == postgres7 or postgres8).

I'll carry on testing the upgraded site and report any further issues.  First thing I must fix is the broken CSSMenu.

Many thanks!

[Ted]

I think the main issue is that I didn't port a couple of functions over to postgres8 (including RowCount).

I'll have to do that and then get a good install of postgres going and start testing.

[martin42]

I've got a dedicated test box here, so I'm happy to test your updates when they're ready!

Cheers,

- Martin.

[tamlyn]

I have the same problem (rowcount() undefined when upgrading) but I am using MySQL 4.0. Albert's adodb 'heavy' workaround worked for me though.