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

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.