Home :: Projects :: ProjectPier Project :: ProjectPier :: Issues

Error when installing

By sethzora - Posted on November 22nd, 2010
Project:ProjectPier
Version:0.8.6-beta2
Component:Code
Category:bug report
Priority:critical
Assigned:phpfreak
Status:closed - won't fix/other
Description

I uploaded the new files and changed the config file to reflect my old PP SQL DB. Now when I try to load the index.php, its just a white screen.

#1
Submitted by phpfreak on Mon, 11/22/2010 - 19:42.
Assigned to:Visitor» phpfreak
Status:new» closed - won't fix/other

The database has changed between beta 1 and beta 2. Someone wanted due dates on tasks and task lists ;-). That is the cause of the white screen.

Closed.

#2
Submitted by sethzora on Mon, 11/22/2010 - 20:54.

Is there a way to upgrade my old database so that it can be used with beta 2?

#3
Submitted by phpfreak on Mon, 11/22/2010 - 22:26.

If you run this in phpMyAdmin on your beta 1 database, you should be fine for beta 2.

ALTER TABLE `PP_users` ADD `use_gravatar` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `avatar_file`;
ALTER TABLE `PP_project_task` ADD `due_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `text`;
ALTER TABLE `PP_project_task_lists` ADD `due_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `description`;

Ofc, substitute PP_ with your prefix.

#4
Submitted by joho on Mon, 11/22/2010 - 23:25.

The second line should read

ALTER TABLE `PP_project_tasks` ADD `due_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `text`;

(with an 's' at the end of PP_project_task)

#5
Submitted by sethzora on Mon, 11/22/2010 - 23:35.

Still just a white screen of death.

#6
Submitted by sethzora on Tue, 11/23/2010 - 00:03.

I even tried a new install to a new SQL DB and it is still showing a white screen.

#7
Submitted by phpfreak on Tue, 11/23/2010 - 00:47.

You got a complete install procedure? If not, remove /config/config.php and try again.

#8
Submitted by sethzora on Tue, 11/23/2010 - 01:47.

Yeah it's still doing it when config.pho was not there.

#9
Submitted by phpfreak on Tue, 11/23/2010 - 08:30.

This is very unclear for me.

First: Remove all cookies and cache from your browser.
Then tell me:
1) If you surf to a freshly deployed install, do you see the "PP is not installed." message?
2) If yes, what happens when you click public/install?
3) If no, then config/config.php is present or the files are not readable. Check the permissions on your directories. Check if config/config.php is present in the fresh install (should not be the case). Also check if your browser is pointing to the right version and not to an existing version.

#10
Submitted by sethzora on Tue, 11/23/2010 - 14:48.

It appears the only way I could get this to work was to install fresh and make a new DB. Then in phpmyadmin, drop all the tables out of the new and import tables from the old. Then it let me in and pulled everything.