https://www.icyphoenix.com/viewtopic.php?f=35&t=9016&p=58763#p58763
-----------------------------------
spirit22
Fri 26 Apr, 2013 17:57

Re: Problem Update To 2.0 Version
-----------------------------------
The error say:

An error has occurred during installation
An error occurred trying to update the database
Table 'ip_acronyms' already exists



The table  'ip_acronyms'  in phpmy admin have this

	 1	acronym_id	mediumint(9)			No	Ninguna	AUTO_INCREMENT	  Cambiar	  Eliminar	  Navegar los valores distintivos	 Primaria	  Único	 Más
	 2	acronym	varchar(80)	latin1_swedish_ci		No			  Cambiar	  Eliminar	  Navegar los valores distintivos	  Primaria	  Único	 Más
	 3	description	varchar(255)	latin1_swedish_ci		No			  Cambiar	  Eliminar	  Navegar los valores distintivos	  Primaria	  Único	 Más



In the step 9: i had some errors


[code linenumbers=false]The following SQL have not been executed:
Spoiler: [ Hide ]
CREATE TABLE `ip_3tickets_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_3tickets_cat' already exists

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('forum_limit_edit_time_interval', '1440')
+++ Error: Duplicate entry 'forum_limit_edit_time_interval' for key 'PRIMARY'

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

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

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

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('ftr_disable', '1')
+++ Error: Duplicate entry 'ftr_disable' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('allow_html_only_for_admins', '0')
+++ Error: Duplicate entry 'allow_html_only_for_admins' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('display_tags_box', '0')
+++ Error: Duplicate entry 'display_tags_box' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('allow_moderators_edit_tags', '0')
+++ Error: Duplicate entry 'allow_moderators_edit_tags' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('enable_custom_bbcodes', '0')
+++ Error: Duplicate entry 'enable_custom_bbcodes' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('forum_tags_type', '0')
+++ Error: Duplicate entry 'forum_tags_type' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('smtp_port', '25')
+++ Error: Duplicate entry 'smtp_port' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('disable_likes_posts', '1')
+++ Error: Duplicate entry 'disable_likes_posts' for key 'PRIMARY'

UPDATE ip_3cms_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_3cms_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_3cms_blocks` CHANGE `block_settings_id` `bs_id` INT(10) UNSIGNED NOT NULL
+++ Error: Unknown column 'block_settings_id' in 'ip_3cms_blocks'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('cron_birthdays_interval', '0')
+++ Error: Duplicate entry 'cron_birthdays_interval' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('robots_index_topics_no_replies', '1')
+++ Error: Duplicate entry 'robots_index_topics_no_replies' for key 'PRIMARY'

INSERT INTO `___sessions___` SELECT s.session_id, s.session_user_id, s.session_start, s.session_time, s.session_ip, s.session_user_agent, s.session_page, s.session_logged_in, 0, 0, '', 1, 0, s.session_admin FROM `ip_3sessions` s ORDER BY s.session_id
+++ Error: Column count doesn't match value count at row 1

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('active_sessions', '0')
+++ Error: Duplicate entry 'active_sessions' for key 'PRIMARY'

ALTER TABLE `ip_3referers` CHANGE `ip` `ip` varchar(40) NOT NULL DEFAULT ''
+++ Error: Table 'kungfuma_kungfu.ip_3referers' doesn't exist

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

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

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

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

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

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('site_meta_keywords', 'your keywords, comma, separated')
+++ Error: Duplicate entry 'site_meta_keywords' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('site_meta_keywords_switch', '1')
+++ Error: Duplicate entry 'site_meta_keywords_switch' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('site_meta_description', 'Your Site Description')
+++ Error: Duplicate entry 'site_meta_description' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('site_meta_description_switch', '1')
+++ Error: Duplicate entry 'site_meta_description_switch' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('site_meta_author', 'Author')
+++ Error: Duplicate entry 'site_meta_author' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('site_meta_author_switch', '1')
+++ Error: Duplicate entry 'site_meta_author_switch' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('site_meta_copyright', 'Copyright')
+++ Error: Duplicate entry 'site_meta_copyright' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('site_meta_copyright_switch', '1')
+++ Error: Duplicate entry 'site_meta_copyright_switch' for key 'PRIMARY'

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

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('spam_posts_number', '5')
+++ Error: Duplicate entry 'spam_posts_number' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('spam_disable_url', '1')
+++ Error: Duplicate entry 'spam_disable_url' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('spam_hide_signature', '1')
+++ Error: Duplicate entry 'spam_hide_signature' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('spam_post_edit_interval', '60')
+++ Error: Duplicate entry 'spam_post_edit_interval' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('mobile_style_disable', '0')
+++ Error: Duplicate entry 'mobile_style_disable' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('session_last_visit_reset', '0')
+++ Error: Duplicate entry 'session_last_visit_reset' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('check_dnsbl', '0')
+++ Error: Duplicate entry 'check_dnsbl' for key 'PRIMARY'

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('check_dnsbl_posting', '0')
+++ Error: Duplicate entry 'check_dnsbl_posting' for key 'PRIMARY'

UPDATE `ip_3config` SET `config_name` = 'disable_referers' WHERE `config_name` = 'disable_referrers'
+++ Error: Duplicate entry 'disable_referers' for key 'PRIMARY'

INSERT INTO ip_3config VALUES ('ip_version', '2.0.0.86')
+++ Error: Duplicate entry 'ip_version' for key 'PRIMARY'[/code]


but now say this:

 [img]http://www.icyphoenix.com/files/images/11000/update.jpg[/img]




One thing I've noticed is that to run the 'install / database_update.php' I have to put the old config.php of the backup my files, if not I have the blank page with the new config.php version 2.0, and to run the 'install / install.php'  I have to put the config.php of the version 2.0 on my root of ip in filezilla, if I put the old does not work the 'install / install.php' I left the blank page . 

sorry, I'm using the google translator.



Install page 1:

 [img]http://www.icyphoenix.com/files/images/11000/install_page1.jpg[/img] 



Install page 2:

 [img]http://www.icyphoenix.com/files/images/11000/install_page2.jpg[/img] 



Install page 3:

 [img]http://www.icyphoenix.com/files/images/11000/install_page3_1366993721_447941.jpg[/img]


