Icy Phoenix
Old Support Topics - Icy Phoenix Spain - Blank page after update
Informpro [ Mon 30 Jul, 2012 19:07 ]
Post subject: Re: Icy Phoenix Spain - Blank Page After Update
Hi,
do you have access to any error log ?
Mighty Gorgon [ Mon 30 Jul, 2012 20:33 ]
Post subject: Re: Icy Phoenix Spain - Blank page after update
Hi, can you tell which step you performed before the site went blank?
ThE KuKa [ Mon 30 Jul, 2012 20:50 ]
Post subject: Re: Icy Phoenix Spain - Blank page after update
No errors, only blank page, into folder /logs/ all files blank (no text, no errors)
Step 18 Luca
Quote:
Run install/install.php since you need to run Add Uploaded Images To DB (Upgrading from Icy Phoenix 1.3 or above) to add all uploaded images to DB (i.e.
http://www.mysite.com/ip/install/install.php).
Mighty Gorgon [ Mon 30 Jul, 2012 21:07 ]
Post subject: Re: Icy Phoenix Spain - Blank page after update
Try to run again this: database_update.php?mode=update_13053.
Then try to rename install into install2 for example and then run again install2/install.php
Let me know if it works.
ThE KuKa [ Mon 30 Jul, 2012 23:19 ]
Post subject: Re: Icy Phoenix Spain - Blank page after update
This part, works fine.
Try to run again this: database_update.php?mode=update_13053.
This part not work, blank page, and blank page index, portal, ACP, etc.
Then try to rename install into install2 for example and then run again install2/install.php

Mighty Gorgon [ Tue 31 Jul, 2012 09:18 ]
Post subject: Re: Icy Phoenix Spain - Blank page after update
Very strange, you should try to debug step by step to understand what's wrong... just as a test, can you try to perform a clean install on the same server?
Joshua203 [ Tue 31 Jul, 2012 10:10 ]
Post subject: Re: Icy Phoenix Spain - Blank page after update
Maybe this will help a bit?
First time I hit the spanish portal page I got this error:
SQL ERROR [ mysql4 ]
Unknown column 'url' in 'field list' [1054]
SQL
SELECT url FROM minerva_referers WHERE url = 'http://www.icyphoenix.com/forum.php' AND t_url = 'index.php' LIMIT 1
BACKTRACE
FILE: includes/db/mysql.php
LINE: 295
CALL: sql_db->sql_error()
FILE: includes/sessions.php
LINE: 1405
CALL: sql_db->sql_query()
FILE: includes/sessions.php
LINE: 434
CALL: session->process_referer()
FILE: includes/sessions.php
LINE: 316
CALL: session->session_create()
FILE: includes/new_page_common.php
LINE: 43
CALL: session->session_begin()
FILE: index.php
LINE: 17
CALL: include('includes/new_page_common.php')
after this I hit forum and all pages went blank
ThE KuKa [ Tue 31 Jul, 2012 10:38 ]
Post subject: Re: Icy Phoenix Spain - Blank page after update
@ MG - Uploading new Icy Test (in other folder)
@ Joshua - Thanks, I'm review schema SQL
m740 [ Tue 31 Jul, 2012 11:41 ]
Post subject: Re: Icy Phoenix Spain - Blank Page After Update
The problem is the Spanish translation of install.php
Do not click on upgrade from 1.3 to 2.0
"Run install / install.php since you need to run Add Images Uploaded To DB (Upgrading from Icy Phoenix 1.3 or above)"
ThE KuKa [ Tue 31 Jul, 2012 12:38 ]
Post subject: Re: Icy Phoenix Spain - Blank page after update
@ MG - New Icy Phoenix Test works fine.
Other error Icy Phoenix Spain:
Quote:
SQL ERROR [ mysql4 ]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 9 [1064]
SQL
SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username, u.user_active, u.user_color FROM minerva_topics AS t, minerva_posts AS p, minerva_users AS u WHERE t.forum_id NOT IN (2,7,9,10,11,20,36,41,44,59,60,69,70,71,72,73,74,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96) AND t.topic_status <> 2 AND p.post_id = t.topic_last_post_id AND p.poster_id = u.user_id AND t.topic_time <= 1343725485 ORDER BY p.post_time DESC LIMIT
BACKTRACE
FILE: includes/db/mysql.php
LINE: 295
CALL: sql_db->sql_error()
FILE: blocks/recent_topics.php
LINE: 45
CALL: sql_db->sql_query()
FILE: blocks/recent_topics.php
LINE: 85
CALL: cms_block_recent_topics()
FILE: includes/class_cms.php
LINE: 385
CALL: include('blocks/recent_topics.php')
FILE: includes/new_page_common.php
LINE: 189
CALL: ip_cms->cms_parse_blocks()
FILE: index.php
LINE: 17
CALL: include('includes/new_page_common.php')
Informpro [ Tue 31 Jul, 2012 14:11 ]
Post subject: Re: Icy Phoenix Spain - Blank Page After Update
The query is missing LIMIT's parameter.
Here is the code :
- LIMIT " . $cms_config_vars['md_num_recent_topics'][$block_id];
So it looks like this bloc isn't configured
You can either config it (if you put the block only on a few pages, you can probably access the cms admin. You can also delete the block.
You can do that to fix it for now
OPEN
FIND
- LIMIT " . $cms_config_vars['md_num_recent_topics'][$block_id];
REPLACE WITH
- LIMIT " . isset($cms_config_vars['md_num_recent_topics'][$block_id]) ? $cms_config_vars['md_num_recent_topics'][$block_id] : 1;
ThE KuKa [ Tue 31 Jul, 2012 14:38 ]
Post subject: Re: Icy Phoenix Spain - Blank page after update
Blank page again...

ThE KuKa [ Tue 31 Jul, 2012 16:08 ]
Post subject: Re: Icy Phoenix Spain - Blank page after update
Restore DB and repeat...
Go KuKa Go!!!

ThE KuKa [ Tue 31 Jul, 2012 16:24 ]
Post subject: Re: Icy Phoenix Spain - Blank page after update
DB Restored.
Step 7, 8 and 9 perfect.
Step 10 = Blank page on my site.

ThE KuKa [ Tue 31 Jul, 2012 16:32 ]
Post subject: Re: Icy Phoenix Spain - Blank page after update
Working...???
Some images missing
My problem.
After Step 7, 8, 9, and blank page Step 10.
Show error "session_last_visit" no exist.
phpMyAdmin and SQL tab (into Icy DB)
- DROP TABLE `phpbb_sessions`;
-
- CREATE TABLE `phpbb_sessions` (
- `session_id` VARCHAR(32) NOT NULL DEFAULT '',
- `session_user_id` MEDIUMINT(8) NOT NULL DEFAULT '0',
- `session_start` INT(11) NOT NULL DEFAULT '0',
- `session_time` INT(11) NOT NULL DEFAULT '0',
- `session_ip` VARCHAR(40) NOT NULL DEFAULT '0',
- `session_browser` VARCHAR(255) DEFAULT '' NOT NULL,
- `session_page` VARCHAR(255) NOT NULL DEFAULT '',
- `session_logged_in` TINYINT(1) NOT NULL DEFAULT '0',
- `session_forum_id` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
- `session_topic_id` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
- `session_last_visit` INT(11) UNSIGNED DEFAULT '0' NOT NULL,
- `session_forwarded_for` VARCHAR(255) DEFAULT '' NOT NULL,
- `session_viewonline` TINYINT(1) UNSIGNED DEFAULT '1' NOT NULL,
- `session_autologin` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL,
- `session_admin` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
- PRIMARY KEY (`session_id`),
- KEY `session_user_id` (`session_user_id`),
- KEY `session_fid` (`session_forum_id`)
- );
-
- DROP TABLE `phpbb_sessions_keys`;
-
- CREATE TABLE `phpbb_sessions_keys` (
- `key_id` VARCHAR(32) NOT NULL DEFAULT '0',
- `user_id` MEDIUMINT(8) NOT NULL DEFAULT '0',
- `last_ip` VARCHAR(40) NOT NULL DEFAULT '',
- `last_login` INT(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`key_id`,`user_id`),
- KEY `last_login` (`last_login`)
- );
-
- ## `phpbb_sessions_keys`
And working...

Mighty Gorgon [ Tue 31 Jul, 2012 16:47 ]
Post subject: Re: Icy Phoenix Spain - Blank page after update
If you don't solve your issues, I can have a look at it tonight. Just let me know if you need my help.
ThE KuKa [ Tue 31 Jul, 2012 16:50 ]
Post subject: Re: Icy Phoenix Spain - Blank Page After Update
Have you done this?
Quote:
Rename the following folder:
files/posted_images ==> files/images
http://www.icyphoenix.com/docs/readme_english.html#upgrade_ip
Ohhhhhhhhhhhhhh
Sorry, I love you!
Thanks!
@ MG - No problem, you will work with the code.
Thanks!

ThE KuKa [ Tue 31 Jul, 2012 21:06 ]
Post subject: Re: [SOLVED] Icy Phoenix Spain - Blank page after update
Icy Phoenix Spain working again!!!
Thanks for all, thank you friends!

Mighty Gorgon [ Wed 01 Aug, 2012 08:55 ]
Post subject: Re: [SOLVED] Icy Phoenix Spain - Blank page after update
I'm glad you solved.
It was very strange that the folder with a different name was causing blank pages.

Informpro [ Wed 01 Aug, 2012 13:21 ]
Post subject: Re: [SOLVED] Icy Phoenix Spain - Blank Page After Update
The error was that the table "session_last_visit" did not exist. (the image problem came after)
ThE KuKa [ Wed 01 Aug, 2012 15:16 ]
Post subject: Re: [SOLVED] Icy Phoenix Spain - Blank page after update
Yes, there were several errors in the database
Joshua203 [ Sat 27 Apr, 2013 20:25 ]
Post subject: Re: Icy Phoenix Spain - Blank page after update
ooopZ SORRY
