Icy Phoenix

Old Support Topics - [SOLVED] Problem Update To 2.0 Version

Joshua203 [ Fri 26 Apr, 2013 19:20 ]
Post subject: Re: Problem Update To 2.0 Version

that's a good one too yeah, wb Spydie

EDIT: yes I think doing it all again is the best you can do Spirit, try using the other "steps-list" posted above

spirit22 [ Fri 26 Apr, 2013 19:57 ]
Post subject: Re: Problem Update To 2.0 Version

Filezilla is very slow :S

I have 14.000 images to upload... will take about a day to upload all... and my connection speed is 10mb donwload/1mb upload

I'm going crazy

Edit: I stop upload the images of posts, i will continue tomorrow uploading it. I continue with the instalation.

Joshua203 [ Fri 26 Apr, 2013 20:25 ]
Post subject: Re: Problem Update To 2.0 Version

From what I read in the "step-list" ..you should only have to rename the folder and not replace or delete the images.

Upgrade Step-List wrote:
8.Rename the following folder:
◦files/posted_images ==> files/images

PS you could always try something other than filezilla

spirit22 [ Fri 26 Apr, 2013 21:13 ]
Post subject: Re: Problem Update To 2.0 Version

New error when i try launch install/convert_utf8_nodbal.php

In the first installation didn't show me this error.

Code: [Hide] [Select]

Warning: require(./config.php) [function.require]: failed to open stream: No such file or directory in /home/kungfuma/public_html/install/convert_utf8_nodbal.php on line 32

Warning: require(./config.php) [function.require]: failed to open stream: No such file or directory in /home/kungfuma/public_html/install/convert_utf8_nodbal.php on line 32

Fatal error: require() [function.require]: Failed opening required './config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/kungfuma/public_html/install/convert_utf8_nodbal.php on line 32

I have the old config.php and with the new config.php say the same error.

Now i can't doing anything. I'm starting to despair

Limun [ Fri 26 Apr, 2013 21:27 ]
Post subject: Re: Problem Update To 2.0 Version

spirit22 wrote: [View Post]
New error when i try launch install/convert_utf8_nodbal.php

In the first installation didn't show me this error.

Code: [Hide] [Select]
Code: [Show]
Warning: require(./config.php) [function.require]: failed to open stream: No such file or directory in /home/kungfuma/public_html/install/convert_utf8_nodbal.php on line 32

Warning: require(./config.php) [function.require]: failed to open stream: No such file or directory in /home/kungfuma/public_html/install/convert_utf8_nodbal.php on line 32

Fatal error: require() [function.require]: Failed opening required './config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/kungfuma/public_html/install/convert_utf8_nodbal.php on line 32

I have the old config.php and with the new config.php say the same error.

Now i can't doing anything. I'm starting to despair

check if your old original config.php is in root dir and if is set to CHMOD 666

spirit22 [ Fri 26 Apr, 2013 21:29 ]
Post subject: Re: Problem Update To 2.0 Version

He had CHMOD 644

I put him 666 and does not work either.

Limun [ Fri 26 Apr, 2013 21:34 ]
Post subject: Re: Problem Update To 2.0 Version

spirit22 wrote: [View Post]
He had CHMOD 644

I put him 666 and does not work either.

clear cache , and also check if your config.php is not empty

Joshua203 [ Fri 26 Apr, 2013 21:46 ]
Post subject: Re: Problem Update To 2.0 Version

Have you moved the nodbal file to the root before running it?

spirit22 [ Fri 26 Apr, 2013 21:46 ]
Post subject: Re: Problem Update To 2.0 Version

I cleaned all the cache with ccleaner and still show me that error, with google chrome, firefox and ie.

The config.php not is empty and contains the following:

Code: [Hide] [Select]

<?php

// Icy Phoenix auto-generated config file

// Do not change anything in this file!

$dbms = 'mysql4';

$dbhost = 'localhost';

$dbname = 'kungfuma_kungfu';

$dbuser = 'editedbyspirit22'; USER EDITED 

$dbpasswd = 'editedbyspirit22'; PASSWORD EDITED 

$table_prefix = 'ip_3';

define('PHPBB_INSTALLED', true);

?>

Limun [ Fri 26 Apr, 2013 21:53 ]
Post subject: Re: Problem Update To 2.0 Version

edit your config.php to this

Code: [Hide] [Select]

<?php

 // Icy Phoenix auto-generated config file

 // Do not change anything in this file!

 $dbms = 'mysql4';

 $dbhost = 'localhost';

 $dbname = 'kungfuma_kungfu';

 $dbuser = 'editedbyspirit22'; USER EDITED 

 $dbpasswd = 'editedbyspirit22'; PASSWORD EDITED 

 $table_prefix = 'ip_3';

 define('IP_INSTALLED', true);

 ?>

save it and try

spirit22 [ Fri 26 Apr, 2013 22:04 ]
Post subject: Re: Problem Update To 2.0 Version

The same error

Joshua203 [ Fri 26 Apr, 2013 22:23 ]
Post subject: Re: Problem Update To 2.0 Version

Joshua203 wrote: [View Post]
Have you moved the nodbal file to the root before running it?

please try it

spirit22 [ Fri 26 Apr, 2013 22:38 ]
Post subject: Re: Problem Update To 2.0 Version

Sorry guys

I was doing wrong that step because it ran from

www.kungfumania.es/install/convert_utf8_nodbal.php (bad)

and is:

www.kungfumania.es/convert_utf8_nodbal.php (good)

Now I have my DB in UTF-8

I continue with the update...

EDIT:

Step 17: done, but with some problems I think.

Says:

Code: [Hide] [Select]

The following SQL have not been executed:

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'

CREATE TABLE `ip_3topics_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_3topics_tags_list' already exists

CREATE TABLE `ip_3topics_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_3topics_tags_match' already exists

RENAME TABLE `ip_3xs_news_cfg` TO `_old_ip_3xs_news_cfg`

+++ Error: Table '_old_ip_3xs_news_cfg' already exists

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'

CREATE TABLE `ip_3bbcodes` ( 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_3bbcodes' already exists

CREATE TABLE `ip_3plugins` ( 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_3plugins' already exists

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('forum_tags_type', '0')

+++ Error: Duplicate entry 'forum_tags_type' for key 'PRIMARY'

CREATE TABLE `ip_3plugins_config` ( `config_name` varchar(255) NOT NULL DEFAULT '', `config_value` TEXT NOT NULL, PRIMARY KEY (`config_name`) )

+++ Error: Table 'ip_3plugins_config' already exists

CREATE TABLE `ip_3acl_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_3acl_groups' already exists

CREATE TABLE `ip_3acl_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_3acl_options' already exists

CREATE TABLE `ip_3acl_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_3acl_roles' already exists

CREATE TABLE `ip_3acl_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_3acl_roles_data' already exists

CREATE TABLE `ip_3acl_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_3acl_users' already exists

INSERT INTO `ip_3config` (`config_name`, `config_value`) VALUES ('smtp_port', '25')

+++ Error: Duplicate entry 'smtp_port' for key 'PRIMARY'

ALTER TABLE `ip_3plugins` ADD `plugin_version` VARCHAR(255) NOT NULL DEFAULT '' AFTER `plugin_name`

+++ Error: Duplicate column name 'plugin_version'

CREATE TABLE `ip_3cms_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_3cms_block_settings' already exists

INSERT INTO `ip_3cms_block_settings` SELECT b.bid, 0, b.title, b.content, b.blockfile, b.view, b.type, b.groups, 1 FROM `ip_3cms_blocks` b ORDER BY b.bid

+++ Error: Duplicate entry '19' for key 'PRIMARY'

CREATE TABLE `ip_3poll_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_3poll_options' already exists

CREATE TABLE `ip_3poll_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_3poll_votes' already exists

CREATE TABLE `ip_3posts_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_3posts_likes' already exists

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 `ip_3config` (`config_name`, `config_value`) VALUES ('active_sessions', '0')

+++ Error: Duplicate entry 'active_sessions' for key 'PRIMARY'

CREATE TABLE `ip_3log` ( `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_3log' already exists

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_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

CREATE TABLE `ip_3moderator_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_3moderator_cache' already exists

CREATE TABLE `ip_3modules` ( `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_3modules' already exists

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'

CREATE TABLE `ip_3referers` ( `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_3referers' already exists

CREATE TABLE `ip_3images` ( `pic_id` INT(11) unsigned NOT NULL auto_increment, `pic_filename` VARCHAR(255) NOT NULL DEFAULT '', `pic_size` INT(15) unsigned NOT NULL DEFAULT '0', `pic_title` VARCHAR(255) NOT NULL DEFAULT '', `pic_desc` TEXT NOT NULL, `pic_user_id` MEDIUMINT(8) NOT NULL DEFAULT '0', `pic_user_ip` VARCHAR(40) NOT NULL DEFAULT '0', `pic_time` INT(11) unsigned NOT NULL DEFAULT '0', `pic_approval` TINYINT(3) NOT NULL DEFAULT '1', PRIMARY KEY (`pic_id`), KEY `pic_user_id` (`pic_user_id`), KEY `pic_time` (`pic_time`) )

+++ Error: Table 'ip_3images' already exists

INSERT INTO ip_3config VALUES ('ip_version', '2.0.0.86')

+++ Error: Duplicate entry 'ip_version' for key 'PRIMARY'

but, in the end says: 'Updated completed!'

And the step 18 I run: http://www.kungfumania.es/install/install.php and I get the blank page in google chrome, mozilla and ie, does nothing

If i put: http://www.kungfumania.es/ip/install/install.php with the change in the config.php file change 'define('PHPBB_INSTALLED', true);' by 'define('IP_INSTALLED', true);' show me this

Somebody can help me please?

Joshua203 [ Sat 27 Apr, 2013 15:51 ]
Post subject: Re: Problem Update To 2.0 Version

I still see this path in your errors... /home/kungfuma/public_html/install/convert_utf8_nodbal.php

This is telling me you are still or again NOT launching it from the ROOT of the forum

Am I hallucinating or did you remove a post?

spirit22 [ Sat 27 Apr, 2013 16:17 ]
Post subject: Re: Problem Update To 2.0 Version

I ran the http://www.kungfumania.es/convert_utf8_nodbal.php with the file convert_utf8_nodbal.php in the root of icy phoenix in the ftp. I think the problem is in the blank page when i run http://www.kungfumania.es/install/install.php

spirit22 wrote: [View Post]

Now I have my DB in UTF-8

I continue with the update...

EDIT:

Step 17: done, but with some problems I think.

but, in the end says: 'Updated completed!'

And the step 18 I run: http://www.kungfumania.es/install/install.php and I get the blank page in google chrome, mozilla and ie, does nothing

Joshua203 [ Sat 27 Apr, 2013 17:34 ]
Post subject: Re: Problem Update To 2.0 Version

Quote:
If i put: http://www.kungfumania.es/ip/install/install.php with the change in the config.php file change 'define('PHPBB_INSTALLED', true);' by 'define('IP_INSTALLED', true);'

Why would you run anything from the ip directory?... it should not even exist in your setup

spirit22 [ Sat 27 Apr, 2013 18:06 ]
Post subject: Re: Problem Update To 2.0 Version

Joshua203 wrote: [View Post]
Why would you run anything from the ip directory?... it should not even exist in your setup

I only try run that because here http://www.icyphoenix.com/docs/readme_english.html#upgrade_ip

says:

Code: [Hide] [Select]

18. 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).

I've tried both ways and neither works. I only get a blank page, it does nothing

Joshua203 [ Sat 27 Apr, 2013 18:37 ]
Post subject: Re: Problem Update To 2.0 Version

public_html/config.php exists?

spirit22 [ Sat 27 Apr, 2013 18:40 ]
Post subject: Re: Problem Update To 2.0 Version

Yes, is the last config.php of my forum with data access to db.

Joshua203 [ Sat 27 Apr, 2013 18:52 ]
Post subject: Re: Problem Update To 2.0 Version

config.php should be the old one from the old forum.

Please point your browser to adm/erc.php and clear the cache.

spirit22 [ Sat 27 Apr, 2013 19:04 ]
Post subject: Re: Problem Update To 2.0 Version

Cache cleared.

And now when i try www.kungfumania.es/install/instal.php says:

Code: [Hide] [Select]

config.php could not be found.

Click here to install Icy Phoenix

Joshua203 [ Sat 27 Apr, 2013 19:32 ]
Post subject: Re: Problem Update To 2.0 Version

Please try again to re-upload/overwrite with the old config.php
For some reason it stays missing, even if you say it is there ( public_html/config.php ).

spirit22 [ Sat 27 Apr, 2013 19:43 ]
Post subject: Re: Problem Update To 2.0 Version

I reupload and rewrite the old config.php but i have the same error.

And the file is there good.

Joshua203 [ Sat 27 Apr, 2013 19:55 ]
Post subject: Re: Problem Update To 2.0 Version

content of config.php is PHPBB_INSTALLED again?

spirit22 [ Sat 27 Apr, 2013 20:03 ]
Post subject: Re: Problem Update To 2.0 Version

Yes

It's bad?

Joshua203 [ Sat 27 Apr, 2013 20:07 ]
Post subject: Re: Problem Update To 2.0 Version

Limun wrote: [View Post]
edit your config.php to this

Code: [Hide] [Select]
Code: [Show]
<?php

// Icy Phoenix auto-generated config file
// Do not change anything in this file!

$dbms = 'mysql4';

$dbhost = 'localhost';
$dbname = 'xxx';
$dbuser = 'editedbyspirit22'; USER EDITED
$dbpasswd = 'editedbyspirit22'; PASSWORD EDITED
$table_prefix = 'ip_3';

define('IP_INSTALLED', true);

?>

save it and try

spirit22 [ Sat 27 Apr, 2013 20:12 ]
Post subject: Re: Problem Update To 2.0 Version

And I get many errors of 'Resource Limit Is Reached' but the personal of hosting says it's script error of the instalation.

Joshua203 [ Sat 27 Apr, 2013 20:26 ]
Post subject: Re: Problem Update To 2.0 Version

ThE KuKa wrote: [View Post]
Show error "session_last_visit" no exist.

phpMyAdmin and SQL tab (into Icy DB)

Code: [Hide]
Code: [Show]
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...

spirit22 [ Sat 27 Apr, 2013 20:40 ]
Post subject: Re: Problem Update To 2.0 Version

Don't work

Joshua203 [ Sat 27 Apr, 2013 20:52 ]
Post subject: Re: Problem Update To 2.0 Version

ok ..I took a better look at this image

Please try running the suggested SQL insert query

spirit22 [ Sat 27 Apr, 2013 21:24 ]
Post subject: Re: Problem Update To 2.0 Version

Joshua203 wrote: [View Post]
Please try running the suggested SQL insert query

I Insert all that code here?

And wath table have I select?

Joshua203 [ Sat 27 Apr, 2013 21:38 ]
Post subject: Re: Problem Update To 2.0 Version

You should be on the SQL tab, just like the previous Query, I can't reach my own phpmyadmin to compare and I don't read spannish (especially when it's text in an image

)

spirit22 [ Sat 27 Apr, 2013 22:17 ]
Post subject: Re: Problem Update To 2.0 Version

Don't work.

Joshua203 [ Sat 27 Apr, 2013 22:46 ]
Post subject: Re: Problem Update To 2.0 Version

That query in your last image is not the query in the image..

spirit22 [ Sat 27 Apr, 2013 23:03 ]
Post subject: Re: Problem Update To 2.0 Version

EDIT: I fin this:

http://www.icyphoenix.com/viewtopic.php?f=35&t=8580&p=55952

http://www.icyphoenix.com/viewtopic.php?p=52262#p52262

It's the same error?

Joshua203 [ Sat 27 Apr, 2013 23:45 ]
Post subject: Re: Problem Update To 2.0 Version

Well since we are making a mess already ... try running this

Code: [Hide] [Select]

DROP TABLE `ip_3sessions`; 

CREATE TABLE `ip_3sessions` ( 

    `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 `ip_3sessions_keys`; 

CREATE TABLE `ip_3sessions_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`) 

); 

## `ip_3sessions_keys`

spirit22 [ Sat 27 Apr, 2013 23:58 ]
Post subject: Re: Problem Update To 2.0 Version

The query work without problems, but now I get this page after trying 20 times because it always appeared ?Resurce limit is reached:

EDIT: It seems that it works. if not for the problem of limit reached... I think my hosting has blocked access because in my cpanel say: Entry Processes 20 / 20 (in red).

Thanks Joshua203.

Joshua203 [ Sun 28 Apr, 2013 00:19 ]
Post subject: Re: Problem Update To 2.0 Version

Well I would ask your hosting support first about the resource usage, eventhough a few could have been quering the DB to wrong info (creating resourse usage).

You should do some of the repairs mentioned in the last (by you) screenshot btw.
If it is too late... these tools are also in acp>>DB tools etc etc

spirit22 [ Sun 28 Apr, 2013 00:35 ]
Post subject: Re: Problem Update To 2.0 Version

My cpanel show this error:

I think the error of 'Resource Limit Is Reached' is problem of my hosting. 20 times I try to go to my website just go one.

I'll talk to my hosting support. Thanks again

Joshua203 [ Sun 28 Apr, 2013 00:44 ]
Post subject: Re: Problem Update To 2.0 Version

first try the acp db tools ..just don't reset anything

spirit22 [ Sun 28 Apr, 2013 03:39 ]
Post subject: Re: Problem Update To 2.0 Version

Is normal this?

Edit: I block that ip from cpanel, and now my web work fine

Problems solved, thanks guys

Joshua203 [ Sun 28 Apr, 2013 12:04 ]
Post subject: Re: Problem Update To 2.0 Version

spirit22 wrote: [View Post]
Is normal this?

No that looks like someone in Spain really missed your site alot or he's trying to do a "solo ddos attack".

You're welcome Spirit, it's not perfect yet but at least you have a workable situation now (personally I would start from scratch though)

PS..
If your thread is solved, please use the Title Edit button (right bottom of your page)