blank screen after variant selection

[Alauddin]

Hi,

I have tried to install this profile but running info some issues.

1) the default 'theme' when intalling this script is Garland, I think this can be the cause of the issue I am noticing.

2) the main problem I am facing is during the install - when selecting the 'variant', the screen blanks out.
at this point I go back to the main page and I see Garland as default theme, which I switch to the Rev2 but then I see these error msg on the dashboard.

user warning: Table 'domainname.content_type_story' doesn't exist query: SELECT COUNT(*) FROM node LEFT JOIN content_type_story ON node.vid = content_type_story.vid WHERE node.type = 'story' AND content_type_story.field_extended_status_value = '0' in /home/domainname/public_html/sites/all/modules/prosepoint/pp.admin.inc on line 87.
user warning: Table 'domainname.content_type_story' doesn't exist query: SELECT COUNT(*) FROM node LEFT JOIN content_type_story ON node.vid = content_type_story.vid WHERE node.type = 'story' AND content_type_story.field_extended_status_value = '2' in /home/domainname/public_html/sites/all/modules/prosepoint/pp.admin.inc on line 87.
user warning: Table 'domainname.content_type_story' doesn't exist query: SELECT COUNT(*) FROM node LEFT JOIN content_type_story ON node.vid = content_type_story.vid WHERE node.type = 'story' AND content_type_story.field_extended_status_value = '3' in /home/domainname/public_html/sites/all/modules/prosepoint/pp.admin.inc on line 87.
user warning: Table 'domainname.content_type_story' doesn't exist query: SELECT COUNT(*) FROM node LEFT JOIN content_type_story ON node.vid = content_type_story.vid WHERE node.type = 'story' AND content_type_story.field_extended_status_value = '1' in /home/domainname/public_html/sites/all/modules/prosepoint/pp.admin.inc on line 87.
user warning: Table 'domainname.content_type_story' doesn't exist query: SELECT COUNT(*) FROM node LEFT JOIN content_type_story ON node.vid = content_type_story.vid WHERE node.type = 'story' AND content_type_story.field_extended_status_value = '4' in /home/domainname/public_html/sites/all/modules/prosepoint/pp.admin.inc on line 87.
The content access permissions need to be rebuilt. Please visit this page.

here is my server info
MySQL database 5.0.45
PHP 5.1.6
PHP memory limit 512M
PHP register globals Disabled
Unicode library PHP Mbstring Extension
Update notifications Enabled
Web server Apache/2.2.3 (CentOS)

Thanks for looking into this, I think this is an awesome profile for news site.
I have been playing around with innovation news last couple week, I think this is way more robust and customizeable.

look forward to helping you with testing, as I am not a programer.

Alauddin

[bengtan (bengtan)]

Hi, this bug has been confirmed. I tried installing on a server with PHP 5.1.6, and also got a blank screen like you reported. I didn't observe your symptom 1, but that's likely a minor point.

Let me get back to you on this.

[bengtan (bengtan)]

Okay, got some more information, and a potential fix.

Firstly, you shouldn't be seeing Garland as the theme during installation. You should be seeing ProsePoint's base theme which is tma2. However, this may not be relevant, so let's put that aside for now.

There is a bug in ProsePoint 0.04 and 0.05 which causes the installation process to crash if your server uses PHP 5.1.x or earlier ie. any PHP other than 5.2.x.

You can either try to fix this yourself (with my help, I provide instructions below), or you can wait for the next version of ProsePoint to be released with this fix.

I'd prefer that you try to fix this, so that if there is anything else that may cause problems (like the theme being incorrect), we can uncover them now rather than later.

It's a simple one liner change to two files.

In the file .../profiles/prosepoint/variants/prosepoint-variant-demo.php, line 11 is:

  $months = array_fill_keys(array('now', '-1 month', '-2 month', '-3 month', '-4 month', '+1 month'), '');

Edit and change this to

  $months = array('now' => '', '-1 month' => '', '-2 month' => '', '-3 month' => '', '-4 month' => '', '+1 month' => '');

And then in the file .../profiles/prosepoint/variants/prosepoint-variant-minimal.php, line 11 is:

  $months = array('now' => '', '-1 month' => '', '-2 month' => '', '-3 month' => '', '-4 month' => '', '+1 month' => '');

Edit and change this to

  $months = array_fill_keys(array('now', '-1 month', '-2 month', '-3 month', '-4 month'), '');

In other words, replace with the same line again.

When you try this, don't type in the code. Do a copy and paste of the entire line from here.

If you are using a shared host, you may have to re-upload these two changed files.

After doing that, you will have to clear out your database and redo the installation process from the beginning.

Earlier, the installation process stopped in the middle, and the database only had some of the necessary data. That's why you were getting error messages.

Please give it a go, and let me know the results.

Thank you.

[bengtan (bengtan)]

My bad. I got those lines mixed up :(

Let me try again.

For .../profiles/prosepoint/variants/prosepoint-variant-demo.php, change line 11 from

  $months = array_fill_keys(array('now', '-1 month', '-2 month', '-3 month', '-4 month', '+1 month'), '');

to

  $months = array('now' => '', '-1 month' => '', '-2 month' => '', '-3 month' => '', '-4 month' => '', '+1 month' => '');

[bengtan (bengtan)]

And for .../profiles/prosepoint/variants/prosepoint-variant-minimal.php, change line 11 from:

  $months = array_fill_keys(array('now', '-1 month', '-2 month', '-3 month', '-4 month'), '');

to

  $months = array('now' => '', '-1 month' => '', '-2 month' => '', '-3 month' => '', '-4 month' => '', '+1 month' => '');

[bengtan (bengtan)]

Yes, I got those lines correct the second time.

[Alauddin (allahuddin-ahmed)]

Hi,

Thank you so much for the updates. I saw the first comment on the php version issue and had been busy working to upgrade to php 5.2.

Just came back to report that I have upgraded successfully on my CentOS even though there are no simple upgrades via yum.

Finally, I found this site
http://www.jasonlitka.com/
http://www.jasonlitka.com/yum-repository/
that helped me update to php 5.2.6 on the CentOS - only change I did was 'yum -y install php' rather than full update. As 'yum update' was failing on language files.

Now, that said...I am going to revert back to php 5.1.6 later today and get back to you on how your fix works :)

[Alauddin (allahuddin-ahmed)]

reverted back to php 5.1.6 and updated line 11 on the variant php files and successfully installed Both variants of prosepoint.

issue solved :)

[bengtan (bengtan)]

Sounds good. Thanks for this.

Programmer or not, you know enough of your way around servers to be of great help.

[bengtan (bengtan)]

ProsePoint 0.06 has been released which fixes this bug. Thank you.