Totally frustrated - Blank screen on upgrade

[thumbsucker]

Everytime I try to upgrade my site, I get a blank screen on index.php.  Same with the admin page.

I replaced every file and ran upgrade.  Didn't work.  So I ran install (not overwriting the existing tables).

Nothing is working.  Anyone having problems?

[Ted]

In config.php, do you have mysql or mysqli as your database driver?


What version are you upgrading from?  What version of php?

[thumbsucker]

I have mysql as the DB driver.

PHP Version 4.3.11

Upgrading from 0.11.2

[thumbsucker]

Sigh

[ccp1111]

having the same problem.
php 4.4.1
mysql 4.1.14-standard
upgrading from 0.11.2
Previously I backup the database, so I compare and I notice that the table "cms_contents" was not correctly upgraded. I see some fields like metadata and others that are missing.

[thumbsucker]

Continuing to sigh.

[Ted]

If you look in the version table, what number is there?

[ccp1111]

before upgrade version=14
after version=18

Procedure:
First I backup database,
Backup the web
Then untar the cms.tar.gz in a directory
Copy config.conf from old directory to the new one
Then go to ../new/install/upgrade.php
Upgrading.... done
Then I see:
----------------------
Not Found

The requested URL was not found on this server.
----------------------
The structure of content table V14 remains the same of V18
V14:
CREATE TABLE `cms_content` (
  `content_id` int(11) NOT NULL default '0',
  `content_name` varchar(255) default NULL,
  `type` varchar(25) default NULL,
  `owner_id` int(11) default NULL,
  `parent_id` int(11) default NULL,
  `template_id` int(11) default NULL,
  `item_order` int(11) default NULL,
  `hierarchy` varchar(255) default NULL,
  `default_content` tinyint(4) default NULL,
  `menu_text` varchar(255) default NULL,
  `content_alias` varchar(255) default NULL,
  `show_in_menu` tinyint(4) default NULL,
  `markup` varchar(25) default NULL,
  `active` tinyint(4) default NULL,
  `cachable` tinyint(4) default NULL,
  `last_modified_by` int(11) default NULL,
  `create_date` datetime default NULL,
  `modified_date` datetime default NULL,
  `collapsed` tinyint(4) default NULL,
  PRIMARY KEY  (`content_id`),
  KEY `content_alias` (`content_alias`,`active`),
  KEY `content_alias_2` (`content_alias`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

The new table (v18):
CREATE TABLE `cms_content` (
  `content_id` int(11) NOT NULL default '0',
  `content_name` varchar(255) default NULL,
  `type` varchar(25) default NULL,
  `owner_id` int(11) default NULL,
  `parent_id` int(11) default NULL,
  `template_id` int(11) default NULL,
  `item_order` int(11) default NULL,
  `hierarchy` varchar(255) default NULL,
  `default_content` tinyint(4) default NULL,
  `menu_text` varchar(255) default NULL,
  `content_alias` varchar(255) default NULL,
  `show_in_menu` tinyint(4) default NULL,
  `markup` varchar(25) default NULL,
  `active` tinyint(4) default NULL,
  `cachable` tinyint(4) default NULL,
  `last_modified_by` int(11) default NULL,
  `create_date` datetime default NULL,
  `modified_date` datetime default NULL,
  `collapsed` tinyint(4) default NULL,
  PRIMARY KEY  (`content_id`),
  KEY `content_alias` (`content_alias`,`active`),
  KEY `content_alias_2` (`content_alias`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

[ccp1111]

Hello,
I found the error. My database user hasn´t had alter,modify structure privileges.
So the database structure remaind the same...
So sorry 
Cristian.

[thumbsucker]

I'm still getting the same blank screen on upgrade with 12.1

When I check the cms version table, I see type int(11).  Does that mean the database tables are not upgrading?

I have no clue what to do...

[Ted]

I'm still getting the same blank screen on upgrade with 12.1

When I check the cms version table, I see type int(11).  Does that mean the database tables are not upgrading?

I have no clue what to do...

PM or email me some login details, if possible.  Sounds like a bit of deep debugging is in order here.  I can probably look it over later today.