Icy Phoenix

Old Support Topics - Icy Phoenix Spain - Blank page after update

ThE KuKa [ Mon 30 Jul, 2012 17:59 ]
Post subject: Icy Phoenix Spain - Blank page after update

Icy Phoenix Spain - Blank page after update Upgrade from IP 1.3.0.53 or above to Icy Phoenix 2.0

Searching and read some topics:
http://www.icyphoenix.com/viewtopic.php?f=4&t=1514
http://www.icyphoenix.com/viewtopic.php?t=1520
Etc.

/cache/ folder clear
ANALYZE, REPAIR y OPTIMIZE tables.
Do not know what else... :oops:

Regards.

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.

Mighty Gorgon wrote: [View Post]
Try to run again this: database_update.php?mode=update_13053.

This part not work, blank page, and blank page index, portal, ACP, etc.

Mighty Gorgon wrote: [View Post]
Then try to rename install into install2 for example and then run again install2/install.php

:doc:

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:

Code: [Hide] [Select]

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 :

Code: [Hide]

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

Code: [Hide]

blocks/recent_topics.php

FIND

Code: [Hide]

LIMIT " . $cms_config_vars['md_num_recent_topics'][$block_id];

REPLACE WITH

Code: [Hide]

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... :x

Go KuKa Go!!! :mrgreen:

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. :cry:

ThE KuKa [ Tue 31 Jul, 2012 16:32 ]
Post subject: Re: Icy Phoenix Spain - Blank page after update

Working...???
Some images missing :lol:

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)

Code: [Hide]

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... :roll:

m740 [ Tue 31 Jul, 2012 16:40 ]
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

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

m740 wrote: [View Post]
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 :shock:
Sorry, I love you! :mrgreen:

Thanks!

@ MG - No problem, you will work with the code.
Thanks! :wink:

ThE KuKa [ Tue 31 Jul, 2012 21:06 ]
Post subject: Re: [SOLVED] Icy Phoenix Spain - Blank page after update

Icy Phoenix Spain working again!!! :D

Thanks for all, thank you friends! :drink_08:

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. :roll:

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 :oops: