Page 1 of 1

Totally frustrated - Blank screen on upgrade

Posted: Wed Mar 29, 2006 10:22 am
by 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?

Re: Totally frustrated - Blank screen on upgrade

Posted: Wed Mar 29, 2006 10:52 am
by Ted
In config.php, do you have mysql or mysqli as your database driver?


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

Re: Totally frustrated - Blank screen on upgrade

Posted: Wed Mar 29, 2006 12:11 pm
by thumbsucker
I have mysql as the DB driver.

PHP Version 4.3.11

Upgrading from 0.11.2

Re: Totally frustrated - Blank screen on upgrade

Posted: Wed Mar 29, 2006 11:58 pm
by thumbsucker
Sigh

Re: Totally frustrated - Blank screen on upgrade

Posted: Thu Mar 30, 2006 1:12 am
by 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.

Re: Totally frustrated - Blank screen on upgrade

Posted: Fri Mar 31, 2006 9:42 am
by thumbsucker
Continuing to sigh.

Re: Totally frustrated - Blank screen on upgrade

Posted: Fri Mar 31, 2006 11:35 am
by Ted
If you look in the version table, what number is there?

Re: Totally frustrated - Blank screen on upgrade

Posted: Fri Mar 31, 2006 11:10 pm
by 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;

Re: Totally frustrated - Blank screen on upgrade

Posted: Mon Apr 03, 2006 12:23 am
by 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  ;D
Cristian.

Re: Totally frustrated - Blank screen on upgrade

Posted: Wed Apr 26, 2006 12:14 pm
by 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...

Re: Totally frustrated - Blank screen on upgrade

Posted: Wed Apr 26, 2006 2:42 pm
by Ted
thumbsucker wrote: 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.