CMS Made Simple Forums

I had a site go down from some hacker, well one that I worked on a long time ago 4 free, charity site, and I got it back up and running and upgraded it to 1.2.3 "Black Rock" but I keep getting an error...

Warning: CMSMS is in need of an upgrade.

You are now running schema version 25 and you need to be upgraded to version 29.

Please click the following link: Start upgrade process.

I've clicked the link and ran the upgrade 5 times with the same results...

mark wrote: I had a site go down from some hacker, well one that I worked on a long time ago 4 free, charity site, and I got it back up and running and upgraded it to 1.2.3 "Black Rock" but I keep getting an error...

Warning: CMSMS is in need of an upgrade.

You are now running schema version 25 and you need to be upgraded to version 29.

Please click the following link: Start upgrade process.

I've clicked the link and ran the upgrade 5 times with the same results...

Make a check if these files are missing or old:
- lib/classes/class.events.inc.php
- install/upgrades/*

Alby

Nope not that...

Could someone have used an injection to take over the DB, not allowing an upgrade?...

Someone else set up the DB and CMSMS for them and no longer available & I can't get into myPHPadmin now...

Another possibility is that the provider changed the permission of your db user and now you can't do create/alter table commands.
Try to access to the db with a local gui client and execute the following query
CREATE TABLE `test` (
  `test_field` VARCHAR(20) NOT NULL
);

This should create a table, if it work, normally, should work also the alter table command, it is very uncommon to disable the alter and keep the create.

I have no gui client to access the DB, the bottom of the page says it's 1.2.3...

I've downloaded CMSMS1.2.3 again and uploaded reran upgrade with the same results...

Downloading 1.2.3 didn't work so well, zip or tar both were corrupt, using Firefox, had to use IE6 and tell it to open it, not save it, before I had an uncorrupted folder...

I have no gui client to access the DB.....

Here is the link to the mysql gui tools
http://dev.mysql.com/downloads/gui-tools/5.0.html
one of them is for executing query, quite basic but for the test is fine
MySQL Query Browser 1.2
Otherwise with a search you can find some other:
http://webyog.com/en/downloads.php (the community edition is free)
http://www.navicat.com/download.html (trial for 30 days)
http://www.aquafold.com/downloads.html (actual version is 6.5 but the 4.7 is free)

... the bottom of the page says it's 1.2.3...

The version is plain in the  code and is in the file:
version.php ---> $CMS_VERSION_NAME = "Black Rock";
and the db schema version is in the db table cms_version

If you doubt that the zip was downloaded correctly try to upgrade again
I downloaded the zip and it didn't give me any corruption problem, here is the md5sum it gave me
6aad1a0c1a625d408f53edd438a8b21a  cmsmadesimple-1.2.3.zip
and md5 command line tool for windows is at
http://www.etree.org/md5com.html
from the directory where you downloaded the cms zip
md5sum cmsmadesimple-1.2.3.zip
it should give you as result
6aad1a0c1a625d408f53edd438a8b21a