Page 1 of 1

1.2.2 Database upgrade failing

Posted: Fri Dec 07, 2007 4:38 pm
by bmeuwis
I have just upgraded a 1.0.5-install to 1.2.2. When I get to the database upgrade and press the link to upgrade the database, no errors are raised so I think all is fine. When I then go to the admin-section though, it tells me  :

Warning: CMSMS is in need of an upgrade.
You are now running schema version 28 and you need to be upgraded to version 29.
Please click the following link: Start upgrade process.

While I did this several times, it always has the same effect : none ! WHen I check the table cms_version, it indeed still has the value 28 in there.

Running on Fedora 4 & PHP 5.0.4 .

Any thoughts anyone ? Txs !

Bart.

Re: 1.2.2 Database upgrade failing

Posted: Fri Dec 07, 2007 5:50 pm
by alby
bmeuwis wrote: I have just upgraded a 1.0.5-install to 1.2.2. When I get to the database upgrade and press the link to upgrade the database, no errors are raised so I think all is fine. When I then go to the admin-section though, it tells me  :

Warning: CMSMS is in need of an upgrade.
You are now running schema version 28 and you need to be upgraded to version 29.
Please click the following link: Start upgrade process.

While I did this several times, it always has the same effect : none ! WHen I check the table cms_version, it indeed still has the value 28 in there.

Running on Fedora 4 & PHP 5.0.4 .

Any thoughts anyone ? Txs !
Update 28->29 install FileManager and Printing modules
There are many messages between single steps. Nothing messages/errors in html source?
Is it complete html source (end with ) or broke?

Alby

Re: 1.2.2 Database upgrade failing

Posted: Sat Dec 08, 2007 6:23 am
by bmeuwis
There are no useful error messages I noted. Could the database upgrade be done manually ?

Re: 1.2.2 Database upgrade failing

Posted: Sat Dec 08, 2007 7:51 am
by alby
bmeuwis wrote: There are no useful error messages I noted. Could the database upgrade be done manually ?
upgrade.28.to.29.php:

Code: Select all

<?php

echo '<p>Installing new FileManager module... ';

$modops =& $gCms->GetModuleOperations();
$result = $modops->InstallModule('FileManager',false);
if( $result[0] == false )
{
    echo '[failed]</p>';
}
else
{
    echo '[done]</p>';
    echo '<p class="okmessage">'.$gCms->modules['FileManager']['object']->InstallPostMessage().'</p>';
}

echo '<p>Installing new Printing module... ';

$modops =& $gCms->GetModuleOperations();
$result = $modops->InstallModule('Printing',false);
if( $result[0] == false )
{
    echo '[failed]</p>';
}
else
{
    echo '[done]</p>';
    echo '<p class="okmessage">'.$gCms->modules['Printing']['object']->InstallPostMessage().'</p>';
}

echo '<p>Updating schema version... ';
$query = 'UPDATE '.cms_db_prefix().'version SET version = 29';
$db->Execute($query);
echo '[done]</p>';  
?>

- rename install folder to _install
- login in admin
- install FileManager and Printing modules
- logout
- with phpmyadmin sql query: UPDATE cms_version SET version = 29  (change cms_ with your prefix table)
- rename _install folder to install
- recheck and if work delete install folder

Alby