Sorry for everithing
=================================================
Buenos días familia.
Tengo un problemilla cuando intento actualizar a 2.0.0.84 RC1
Spoiler: [ Show ]
Spoiler: [ Hide ]
How To Upgrade From Older Icy Phoenix Versions
- Lock the site from ACP
- Make a full backup of your website (both files and DB)
- Remove all old Icy Phoenix files, but make sure you are not deleting other stuff you may need!
- When deleting files, pay particular attention to custom files and folders like these:
- config.php
- backup/
- downloads/
- images/
- files/
- logs/
- config.php
- Copy all new Icy Phoenix files into your root
- Make sure you apply the right CHMOD permissions as listed in the Fresh Installation section above
- Copy install/convert_utf8_nodbal.php to your website root and launch it (this is needed to convert your old DB to UTF-8)
- Delete convert_utf8_nodbal.php from your root
- Launch install/database_update.php and update your DB
- Delete or rename install 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
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:
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
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
Ya que luego, cuando me paso al punto 9
Me sale esto:
Spoiler: [ Show ]
Spoiler: [ Hide ]
Las siguientes consultas SQL no se han podido ejecutar:
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: [ Show ]
Spoiler: [ Hide ]
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
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: [ Show ]
Spoiler: [ Hide ]
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
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
¿Sabéis como puedo solucionar este problemilla?