https://www.icyphoenix.com/viewtopic.php?f=35&t=8580
-----------------------------------
Dimo
Mon 16 Jul, 2012 14:49

Problem: Actualitation De 1.3.0.53b A 2.0.0.84 RC1
-----------------------------------
[b][size=18]I writte this post in spa lang coz my eng lang is very bad and the support on the spanish page icy phoenix is down.

Sorry for everithing[/size][/b]

=================================================

[b]Buenos días familia.

Tengo un problemilla cuando intento actualizar a 2.0.0.84 RC1
[spoiler]
[size=12][color=#bb5588][b]How To Upgrade From Older Icy Phoenix Versions[/b][/color][/size]
[list=1][*]Lock the site from ACP
[*]Make a full backup of your website (both files and DB)
[*]Remove all old Icy Phoenix files, but [highlight]make sure you are not deleting other stuff you may need![/highlight]
[*]When deleting files, pay particular attention to custom files and folders like these:[list][*][b]config.php[/b]
[*][b]backup/[/b]
[*][b]downloads/[/b]
[*][b]images/[/b]
[*][b]files/[/b]
[*][b]logs/[/b][/list]
[*]Copy all new Icy Phoenix files into your root
[*]Make sure you apply the right CHMOD permissions as listed in the [color=#224488][b]Fresh Installation[/b][/color] section above
[*]Copy [b]install/convert_utf8_nodbal.php[/b] to your website root and launch it (this is needed to convert your old DB to UTF-8)
[*]Delete [b]convert_utf8_nodbal.php[/b] from your root
[*]Launch [b]install/database_update.php[/b] and update your DB
[*]Delete or rename [b]install[/b] folder
[*]Customize what needs to be customized in files and db (some files needs to be edited manually, while most of the options may be set in ACP and CMS)
[*]Enjoy your New Site  :up:  [/list][/spoiler]

Cuando llego al punto "7. Copy install/convert_utf8_nodbal.php to your website root and launch it (this is needed to convert your old DB to UTF-8)"

me sale este mensaje: [code linenumbers=false]Warning: require(./config.php) [function.require]: failed to open stream: No such file or directory in /homepages/2/d422102349/htdocs/laforo/install/convert_utf8_nodbal.php on line 32

Fatal error: require() [function.require]: Failed opening required './config.php' (include_path='.:/usr/lib/php5') in /homepages/2/d422102349/htdocs/laforo/install/convert_utf8_nodbal.php on line 32[/code]

Ya que luego, cuando me paso al punto 9

Me sale esto:
[spoiler]Las siguientes consultas SQL no se han podido ejecutar:
[spoiler]
CREATE TABLE `ip_tickets_cat` ( ticket_cat_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT, ticket_cat_title VARCHAR(255) NOT NULL DEFAULT '', ticket_cat_des TEXT NOT NULL, ticket_cat_emails TEXT NOT NULL, PRIMARY KEY (ticket_cat_id) )
+++ Error: Table 'ip_tickets_cat' already exists

ALTER TABLE `ip_users` ADD `username_clean` varchar(255) DEFAULT '' NOT NULL AFTER `username`
+++ Error: Duplicate column name 'username_clean'

CREATE TABLE `ip_topics_tags_list` ( `tag_text` varchar(50) binary NOT NULL DEFAULT '', `tag_id` mediumint(8) unsigned NOT NULL auto_increment, `tag_count` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`tag_text`), KEY `tag_id` (`tag_id`) )
+++ Error: Table 'ip_topics_tags_list' already exists

CREATE TABLE `ip_topics_tags_match` ( `tag_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0', KEY `tag_id` (`tag_id`), KEY `topic_id` (`topic_id`) )
+++ Error: Table 'ip_topics_tags_match' already exists

RENAME TABLE `ip_xs_news_cfg` TO `_old_ip_xs_news_cfg`
+++ Error: Table '_old_ip_xs_news_cfg' already exists

ALTER TABLE `ip_ina_scores` ADD `user_plays` int(6) default '0' AFTER `score`
+++ Error: Table 'db422231725.ip_ina_scores' doesn't exist

ALTER TABLE `ip_ina_scores` ADD `play_time` int(11) default '0' AFTER `user_plays`
+++ Error: Table 'db422231725.ip_ina_scores' doesn't exist

CREATE TABLE `ip_bbcodes` ( bbcode_id mediumint(8) UNSIGNED NOT NULL auto_increment, bbcode_tag varchar(16) DEFAULT '' NOT NULL, bbcode_helpline varchar(255) DEFAULT '' NOT NULL, display_on_posting tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, bbcode_match text NOT NULL, bbcode_tpl mediumtext NOT NULL, first_pass_match mediumtext NOT NULL, first_pass_replace mediumtext NOT NULL, second_pass_match mediumtext NOT NULL, second_pass_replace mediumtext NOT NULL, PRIMARY KEY (bbcode_id), KEY display_on_post (display_on_posting) )
+++ Error: Table 'ip_bbcodes' already exists

CREATE TABLE `ip_plugins` ( plugin_name VARCHAR(255) NOT NULL DEFAULT '', plugin_dir VARCHAR(255) NOT NULL DEFAULT '', plugin_enabled tinyint(2) NOT NULL DEFAULT 0, PRIMARY KEY (plugin_name) )
+++ Error: Table 'ip_plugins' already exists

CREATE TABLE `ip_plugins_config` ( `config_name` varchar(255) NOT NULL DEFAULT '', `config_value` TEXT NOT NULL, PRIMARY KEY (`config_name`) )
+++ Error: Table 'ip_plugins_config' already exists

CREATE TABLE `ip_acl_groups` ( `group_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `auth_option_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `auth_role_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `auth_setting` tinyint(2) NOT NULL DEFAULT '0', KEY `group_id` (`group_id`), KEY `auth_opt_id` (`auth_option_id`), KEY `auth_role_id` (`auth_role_id`) )
+++ Error: Table 'ip_acl_groups' already exists

CREATE TABLE `ip_acl_options` ( `auth_option_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `auth_option` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '', `is_global` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_local` tinyint(1) unsigned NOT NULL DEFAULT '0', `founder_only` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`auth_option_id`), UNIQUE KEY `auth_option` (`auth_option`) )
+++ Error: Table 'ip_acl_options' already exists

CREATE TABLE `ip_acl_roles` ( `role_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `role_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `role_description` text COLLATE utf8_bin NOT NULL, `role_type` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '', `role_order` smallint(4) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`role_id`), KEY `role_type` (`role_type`), KEY `role_order` (`role_order`) )
+++ Error: Table 'ip_acl_roles' already exists

CREATE TABLE `ip_acl_roles_data` ( `role_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `auth_option_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `auth_setting` tinyint(2) NOT NULL DEFAULT '0', PRIMARY KEY (`role_id`,`auth_option_id`), KEY `ath_op_id` (`auth_option_id`) )
+++ Error: Table 'ip_acl_roles_data' already exists

CREATE TABLE `ip_acl_users` ( `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `auth_option_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `auth_role_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `auth_setting` tinyint(2) NOT NULL DEFAULT '0', KEY `user_id` (`user_id`), KEY `auth_option_id` (`auth_option_id`), KEY `auth_role_id` (`auth_role_id`) )
+++ Error: Table 'ip_acl_users' already exists

ALTER TABLE `ip_plugins` ADD `plugin_version` VARCHAR(255) NOT NULL DEFAULT '' AFTER `plugin_name`
+++ Error: Duplicate column name 'plugin_version'

CREATE TABLE `ip_cms_block_settings` ( `bs_id` int(10) NOT NULL AUTO_INCREMENT, `user_id` int(10) NOT NULL, `name` varchar(255) NOT NULL default '', `content` text NOT NULL , `blockfile` varchar(255) NOT NULL default '', `view` tinyint(1) NOT NULL default 0, `type` tinyint(1) NOT NULL default 1, `groups` tinytext NOT NULL, `locked` tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (`bs_id`) )
+++ Error: Table 'ip_cms_block_settings' already exists

INSERT INTO `ip_cms_block_settings` SELECT b.bid, 0, b.title, b.content, b.blockfile, b.view, b.type, b.groups, 1 FROM `ip_cms_blocks` b ORDER BY b.bid
+++ Error: Duplicate entry '1' for key 1

CREATE TABLE `ip_poll_options` ( poll_option_id tinyint(4) DEFAULT '0' NOT NULL, topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, poll_option_text text NOT NULL, poll_option_total mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, KEY poll_opt_id (poll_option_id), KEY topic_id (topic_id) )
+++ Error: Table 'ip_poll_options' already exists

CREATE TABLE `ip_poll_votes` ( topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, poll_option_id tinyint(4) DEFAULT '0' NOT NULL, vote_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, vote_user_ip varchar(40) DEFAULT '' NOT NULL, KEY topic_id (topic_id), KEY vote_user_id (vote_user_id), KEY vote_user_ip (vote_user_ip) )
+++ Error: Table 'ip_poll_votes' already exists

CREATE TABLE `ip_posts_likes` ( topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, like_time int(11) UNSIGNED DEFAULT '0' NOT NULL, KEY topic_id (topic_id), KEY post_id (post_id), KEY user_id (user_id) )
+++ Error: Table 'ip_posts_likes' already exists

UPDATE ip_cms_block_settings` SET `content` = REPLACE(`content`, '\\"', '\"')
+++ Error: 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 'content` = REPLACE(`content`, '\\"', '\"')' at line 1

UPDATE ip_cms_block_settings` SET `content` = REPLACE(`content`, "\'", "\'")
+++ Error: 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 'content` = REPLACE(`content`, "\'", "\'")' at line 1

ALTER TABLE `ip_cms_blocks` CHANGE `block_settings_id` `bs_id` INT(10) UNSIGNED NOT NULL
+++ Error: Unknown column 'block_settings_id' in 'ip_cms_blocks'

CREATE TABLE `ip_log` ( `log_id` mediumint(8) UNSIGNED NOT NULL auto_increment, `log_type` tinyint(4) DEFAULT '0' NOT NULL, `user_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `forum_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `topic_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `reportee_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `log_ip` varchar(40) DEFAULT '' NOT NULL, `log_time` int(11) UNSIGNED DEFAULT '0' NOT NULL, `log_operation` text NOT NULL, `log_data` mediumtext NOT NULL, PRIMARY KEY (`log_id`), KEY log_type (`log_type`), KEY forum_id (`forum_id`), KEY topic_id (`topic_id`), KEY reportee_id (`reportee_id`), KEY user_id (`user_id`) )
+++ Error: Table 'ip_log' already exists

ALTER TABLE `ip_blogs_posts` CHANGE `poster_ip` `poster_ip` varchar(40) NOT NULL DEFAULT ''
+++ Error: Table 'db422231725.ip_blogs_posts' doesn't exist

ALTER TABLE `ip_guestbooks_posts` CHANGE `poster_ip` `poster_ip` varchar(40) NOT NULL DEFAULT ''
+++ Error: Table 'db422231725.ip_guestbooks_posts' doesn't exist

UPDATE `ip_blogs_posts` ip SET ip.poster_ip = INET_NTOA(CONV(ip.poster_ip, 16, 10))
+++ Error: Table 'db422231725.ip_blogs_posts' doesn't exist

UPDATE `ip_guestbooks_posts` ip SET ip.poster_ip = INET_NTOA(CONV(ip.poster_ip, 16, 10))
+++ Error: Table 'db422231725.ip_guestbooks_posts' doesn't exist

CREATE TABLE `ip_moderator_cache` ( `forum_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `user_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `username` varchar(255) DEFAULT '' NOT NULL, `group_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `group_name` varchar(255) DEFAULT '' NOT NULL, `display_on_index` tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, KEY `disp_idx` (`display_on_index`), KEY `forum_id` (`forum_id`) )
+++ Error: Table 'ip_moderator_cache' already exists

CREATE TABLE `ip_modules` ( `module_id` mediumint(8) UNSIGNED NOT NULL auto_increment, `module_enabled` tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, `module_display` tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, `module_basename` varchar(255) DEFAULT '' NOT NULL, `module_class` varchar(10) DEFAULT '' NOT NULL, `parent_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `left_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `right_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `module_langname` varchar(255) DEFAULT '' NOT NULL, `module_mode` varchar(255) DEFAULT '' NOT NULL, `module_auth` varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (`module_id`), KEY `left_right_id` (`left_id`, `right_id`), KEY `module_enabled` (`module_enabled`), KEY `class_left_id` (`module_class`, `left_id`) )
+++ Error: Table 'ip_modules' already exists

ALTER TABLE `ip_cms_block_settings` DROP `edit_auth`
+++ Error: Can't DROP 'edit_auth'; check that column/key exists

CREATE TABLE `ip_referers` ( `id` INT(11) NOT NULL auto_increment, `host` VARCHAR(255) NOT NULL DEFAULT '', `url` VARCHAR(255) NOT NULL DEFAULT '', `t_url` VARCHAR(255) NOT NULL DEFAULT '', `ip` VARCHAR(40) NOT NULL DEFAULT '', `hits` INT(11) NOT NULL DEFAULT '1', `firstvisit` INT(11) NOT NULL DEFAULT '0', `lastvisit` INT(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) )
+++ Error: Table 'ip_referers' already exists

INSERT INTO ip_config VALUES ('ip_version', '2.0.0.84RC1')
+++ Error: Duplicate entry 'ip_version' for key 1[/spoiler][/spoiler]

Ya la finalizar con lo que parece ser la actualización me sale todo esto cuando ejecuto el comando de acceso a la web:
[spoiler]Critical Error!
message_die() was called multiple times.
 Error #1
SQL ERROR [ mysql4 ]

Unknown column 'session_last_visit' in 'field list' [1054]

SQL

INSERT INTO ip_sessions (session_user_id, session_logged_in, session_start, session_last_visit, session_time, session_browser, session_forwarded_for, session_ip, session_autologin, session_admin, session_viewonline, session_page, session_forum_id, session_topic_id, session_id) VALUES (-1, 0, 1342405912, 1342405912, 1342405912, 'Mozilla/5.0 (Windows NT 5.1; rv:13.0) Gecko/20100101 Firefox/13.0.1', '', '62.43.228.30', 0, 0, 1, 'index.php', 0, 0, '2ea2e4576d352c3616411654387f1c55')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 295
CALL: sql_db->sql_error()

FILE: includes/sessions.php
LINE: 583
CALL: sql_db->sql_query()

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')



Line : 906
File : /homepages/2/d422102349/htdocs/laforo/includes/db/mysql.php
  Error #2
Could not open ./templates/pearl/pearl.cfg

Line : 2452
File : /homepages/2/d422102349/htdocs/laforo/includes/functions.php [/spoiler]

¿Sabéis como puedo solucionar este problemilla? :([/b]


-----------------------------------
Joshua203
Mon 16 Jul, 2012 15:13

Re: Problem: Actualitation De 1.3.0.53b A 2.0.0.84 RC1
-----------------------------------
Dimo, I have asked you this before and I will do it once more...

Please post in English or go to Spanish support, if i look at your previous (old) posts ..your English is just fine (or you could try using google translator).
[color=red]If I go to Spanish Icy forum it is [u]NOT down[/u].[/color] ( Hoy a las 13:10 » Dimo )

[color=red]Please just follow the rules!![/color]


-----------------------------------
spydie
Mon 16 Jul, 2012 19:54

Re: Problem: Actualitation De 1.3.0.53b A 2.0.0.84 RC1
-----------------------------------
Icy .es is´nt down for shure.

I look every Day for new posts.

Seems like, if you don´t answer immediately, some users think, that support is dead.

They forget everytime, THAT WE DO HAVE OUR NORMAL JOB´S AND FAMILIYS ASWELL.

so we can´t spend our hole live in front of PC  :P


-----------------------------------
Costa
Mon 16 Jul, 2012 20:45

Re: Problem: Actualitation De 1.3.0.53b A 2.0.0.84 RC1
-----------------------------------
the Mediterranean temperament creates impatience ... :mrgreen:


-----------------------------------
TheSteffen
Mon 16 Jul, 2012 20:46

Re: Problem: Actualitation De 1.3.0.53b A 2.0.0.84 RC1
-----------------------------------
[quote user="Dimo" post="55946"]7. Copy install/convert_utf8_nodbal.php to your website root and launch it (this is needed to convert your old DB to UTF-8)[/quote]

You should copy it to your [b]ROOT[/b] don´t leave it in install/ folder 

I dont understand spanish, but that should help


-----------------------------------
Dimo
Tue 17 Jul, 2012 00:35

Re: Problem: Actualitation De 1.3.0.53b A 2.0.0.84 RC1
-----------------------------------
[quote user="Joshua203" post="55947"]Dimo, I have asked you this before and I will do it once more...

Please post in English or go to Spanish support, if i look at your previous (old) posts ..your English is just fine (or you could try using google translator).
[color=red]If I go to Spanish Icy forum it is [u]NOT down[/u].[/color] ( Hoy a las 13:10 » Dimo )

[color=red]Please just follow the rules!![/color][/quote]

[b]Dear Joshua203 I want say that spanish icy phoenix page don't give anybody support because anybody answer the questions. 

Now, do you know answer my question? 

Thanks neng[/b]

[quote user="Costa" post="55949"]the Mediterranean temperament creates impatience ... :mrgreen:[/quote]

[b]Realmente true...[/b]

[quote user="spydie" post="55948"]Icy .es is´nt down for shure.

I look every Day for new posts.

Seems like, if you don´t answer immediately, some users think, that support is dead.

They forget everytime, THAT WE DO HAVE OUR NORMAL JOB´S AND FAMILIYS ASWELL.

so we can´t spend our hole live in front of PC  :P[/quote]

[b]Spydie... today for today the unique page that give support to icy phoenix in spanish is www.Januweb.com ;)[/b]


-----------------------------------
Joshua203
Tue 17 Jul, 2012 01:59

Re: Problem: Actualitation De 1.3.0.53b A 2.0.0.84 RC1
-----------------------------------
I don't know what you are trying to say Dimo...

Your last thread at http://www.icyphoenix.es/ ( Official IcyPhoenix support site in Spanish! ) was "[Solucionado] Problema: Mail ID And Mail Session ID Do Not Match."

[quote=Dimo]Arreglado... esta es la configuración que funciona. 


[i]English translation: Fixed ... This is the configuration that works[/i].[/quote]
So you do get help there!! [u]and[/u] it was SOLVED by Spydie (Solucionado)

[quote=Dimo]Now, do you know answer my question? [/quote]
The correct answer was given by TheSteffen (please read the replies)

You are free to ask support at Janu's site but if you post here you should post in English, please don't forget that.

EDIT: AND if you ask a question somewhere (http://www.januweb.com/foro/problema-actualizacion-de-1-3-0-53b-a-2-0-0-84-rc1-vt4766.html) please wait for an answer instead of double post and waste everyone's time


-----------------------------------
Dimo
Tue 17 Jul, 2012 02:44

Re: Problem: Actualitation De 1.3.0.53b A 2.0.0.84 RC1
-----------------------------------
[spoiler][quote user="Joshua203" post="55952"]I don't know what you are trying to say Dimo...

Your last thread at http://www.icyphoenix.es/ ( Official IcyPhoenix support site in Spanish! ) was "[Solucionado] Problema: Mail ID And Mail Session ID Do Not Match."

[quote=Dimo]Arreglado... esta es la configuración que funciona. 


[i]English translation: Fixed ... This is the configuration that works[/i].[/quote]
So you do get help there!! [u]and[/u] it was SOLVED by Spydie (Solucionado)

[quote=Dimo]Now, do you know answer my question? [/quote]
The correct answer was given by TheSteffen (please read the replies)

You are free to ask support at Janu's site but if you post here you should post in English, please don't forget that.

EDIT: AND if you ask a question somewhere (http://www.januweb.com/foro/problema-actualizacion-de-1-3-0-53b-a-2-0-0-84-rc1-vt4766.html) please wait for an answer instead of double post and waste everyone's time[/quote][/spoiler]

[b]Said BenJa - KuMo in post http://www.januweb.com/foro/urlrw-vt4764.html [/b]

[quote user="BenJa - KuMo" post="38678"]Mejor edita y quita tu email ya que con los bots que hay aquí...

Puede que lo tenga, creo que Icy España hace un tiempo que está dejado...[/quote]


-----------------------------------
Joshua203
Tue 17 Jul, 2012 02:58

Re: Problem: Actualitation De 1.3.0.53b A 2.0.0.84 RC1
-----------------------------------
[quote=Spydie]Icy .es is´nt down for shure.
 
I look [u]every Day[/u] for new posts.[/quote]


-----------------------------------
spydie
Tue 17 Jul, 2012 17:09

Re: Problem: Actualitation De 1.3.0.53b A 2.0.0.84 RC1
-----------------------------------
Dimo

I´m MOD of icyphoenix.es

If nobody askes for support, then there´s no support. Don´t know what happens exactly, but for shure, it´s very quiet around


