Icy Phoenix Spain - Blank page after update »  Show posts from    to     

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]
  1. 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]
  1. blocks/recent_topics.php 

FIND
Code: [Hide]
  1. LIMIT " . $cms_config_vars['md_num_recent_topics'][$block_id]; 

REPLACE WITH
Code: [Hide]
  1. 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]
  1. DROP TABLE `phpbb_sessions`; 
  2.  
  3. CREATE TABLE `phpbb_sessions` ( 
  4. `session_id` VARCHAR(32) NOT NULL DEFAULT '', 
  5. `session_user_id` MEDIUMINT(8) NOT NULL DEFAULT '0', 
  6. `session_start` INT(11) NOT NULL DEFAULT '0', 
  7. `session_time` INT(11) NOT NULL DEFAULT '0', 
  8. `session_ip` VARCHAR(40) NOT NULL DEFAULT '0', 
  9. `session_browser` VARCHAR(255) DEFAULT '' NOT NULL, 
  10. `session_page` VARCHAR(255) NOT NULL DEFAULT '', 
  11. `session_logged_in` TINYINT(1) NOT NULL DEFAULT '0', 
  12. `session_forum_id` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL, 
  13. `session_topic_id` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL, 
  14. `session_last_visit` INT(11) UNSIGNED DEFAULT '0' NOT NULL, 
  15. `session_forwarded_for` VARCHAR(255) DEFAULT '' NOT NULL, 
  16. `session_viewonline` TINYINT(1) UNSIGNED DEFAULT '1' NOT NULL, 
  17. `session_autologin` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL, 
  18. `session_admin` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', 
  19. PRIMARY KEY (`session_id`), 
  20. KEY `session_user_id` (`session_user_id`), 
  21. KEY `session_fid` (`session_forum_id`) 
  22. ); 
  23.  
  24. DROP TABLE `phpbb_sessions_keys`; 
  25.  
  26. CREATE TABLE `phpbb_sessions_keys` ( 
  27. `key_id` VARCHAR(32) NOT NULL DEFAULT '0', 
  28. `user_id` MEDIUMINT(8) NOT NULL DEFAULT '0', 
  29. `last_ip` VARCHAR(40) NOT NULL DEFAULT '', 
  30. `last_login` INT(11) NOT NULL DEFAULT '0', 
  31. PRIMARY KEY (`key_id`,`user_id`), 
  32. KEY `last_login` (`last_login`) 
  33. ); 
  34.  
  35. ## `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:




Powered by Icy Phoenix