https://www.icyphoenix.com/viewtopic.php?f=35&t=9016
-----------------------------------
spirit22
Fri 26 Apr, 2013 15:30

[SOLVED] Problem Update To 2.0 Version
-----------------------------------
Hello, I do all the steps fine but when I put the install/install.php screen stays blank browser and nothing happens. Can you help me? Thanks.

Sorry my english is bad.

Solved this error: I put the old config.php and now operates the instalation.




Other error  :? 


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

Can you help me? Thanks.




Site: kungfumania.es
Version of Apache: 2.2.24
Version of PHP: 5.3.23
Version of MySQL: 5.1.68-cll
Hosting: evalice (payment server)


-----------------------------------
Limun
Fri 26 Apr, 2013 15:46

Re: (Solved) Problem Update To 2.0 Version
-----------------------------------
i dont get blank page on your site
i can start install on your site 
see image -[b][color=red]this is your site[/color][/b]- 
 [img]http://www.icyphoenix.com/files/images/3336/01_1366983792_104730.jpg[/img] 

try clear cache in your browser or try other one ..opera,firefox
[hr]
EDIT: ups, you solved your problem while i was posting this post  :P


-----------------------------------
spirit22
Fri 26 Apr, 2013 15:48

Re: Problem Update To 2.0 Version
-----------------------------------
Thanks Limun, now i have other error  :( 


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

Can you help me? Thanks.


I have the next database configuration:

Database Configuration

Database Type: 5.x/4.x
Database Server Hostname / DSN: localhost
Prefix for tables in database: ip_


-----------------------------------
Limun
Fri 26 Apr, 2013 15:54

Re: Problem Update To 2.0 Version
-----------------------------------
what is your version of icy phoenix?
did you made Step [highlight=#FFFFAA]9.Launch install/database_update.php and update your DB[/highlight] ?


-----------------------------------
spirit22
Fri 26 Apr, 2013 15:59

Re: Problem Update To 2.0 Version
-----------------------------------
Mi version of icy phoenix is: 1.3.0.53

Yes, i think i doing all steps correctly without any failures.


-----------------------------------
Limun
Fri 26 Apr, 2013 16:27

Re: Problem Update To 2.0 Version
-----------------------------------
i m sorry , i m not at home now on my computer where i have all what i need 
the problem you have its not so complicated but i cant help you from here where i m now
important is that you have backuped all icyphoenix files and database

its only thing of double entry (in this case acronyms' table)


-----------------------------------
spirit22
Fri 26 Apr, 2013 16:30

Re: Problem Update To 2.0 Version
-----------------------------------
Limun, in this post solved the problem. but i dont understad if i have delete all tables of db?


http://www.icyphoenix.com/viewtopic.php?f=35&t=3529


-----------------------------------
Limun
Fri 26 Apr, 2013 16:36

Re: Problem Update To 2.0 Version
-----------------------------------
[quote user="spirit22" post="58758"]Limun, in this post solved the problem. but i dont understad if i have delete all tables of db?

http://www.icyphoenix.com/viewtopic.php?f=35&t=3529[/quote]
you dont have and you [b]dont delete tables[/b] when you updating !

that post is old and its for fresh instalation (that user made a mistake when instaling new forum)


-----------------------------------
Joshua203
Fri 26 Apr, 2013 17:52

Re: Problem Update To 2.0 Version
-----------------------------------
If the error says that the table already exists, I would try and remember if I ever activated and created any acronyms... I would take a close look at the acronyms table.

If it is there and it has content it should be ok imho :wink:

EDIT: the only tables you could delete are the OLD tables, but only do that after extensive testing or a long time of running ok.


-----------------------------------
Limun
Fri 26 Apr, 2013 17:57

Re: Problem Update To 2.0 Version
-----------------------------------
[quote user="Joshua203" post="58761"]If the error says that the table already exists, I would try and remember if I ever activated and created any acronyms... I would take a close look at the acronyms table.

If it is there and it has content it should be ok imho :wink:[/quote]
The problem is i think that he get when lunching install/install.php he get the main instalation page , and i think he must get something like [b]Add Uploaded Images To DB[/b] page when lunching install/install.php.(i m not sure because i cant do tests because i m not at my PC )


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


-----------------------------------
Joshua203
Fri 26 Apr, 2013 18:32

Re: Problem Update To 2.0 Version
-----------------------------------
After updating you SHOULD overwrite the new config.php with the old backed up file, and compare the htaccess for your old private changes.

Try reading this list
http://www.icyphoenix.com/docs/readme_english.html#upgrade_ip
 ...maybe it will be more informative than the post content ;)

I have a feeling you tried updating more than once :?:


-----------------------------------
Limun
Fri 26 Apr, 2013 18:34

Re: Problem Update To 2.0 Version
-----------------------------------
[quote user="Joshua203" post="58764"]
I have a feeling you tried updating more than once :?:[/quote]

me to have this feeling 
also in his previos post i see some latin1_swedish_ci and it have to be UTF-8  so maybe also this step is failed


-----------------------------------
spirit22
Fri 26 Apr, 2013 18:42

Re: Problem Update To 2.0 Version
-----------------------------------
Sorry guys, today is the fisrt time i try update my forum to version 2.0.

I'll try doing all from the step one. I'll upload the last backup and i'll do all now other time.


-----------------------------------
spydie
Fri 26 Apr, 2013 18:53

Re: Problem Update To 2.0 Version
-----------------------------------
looks like someone did´nt use convert_utf8_nodbal.php


-----------------------------------
Joshua203
Fri 26 Apr, 2013 19:20

Re: Problem Update To 2.0 Version
-----------------------------------
that's a good one too yeah, wb Spydie :wink:

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


-----------------------------------
spirit22
Fri 26 Apr, 2013 19:57

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

Re: Problem Update To 2.0 Version
-----------------------------------
From what I read in the "step-list" ..you should only have to [b]rename the folder[/b] and not replace or delete the images.
[quote=Upgrade Step-List]8.Rename the following folder: 
◦files/posted_images ==> files/images
[/quote]


PS you could always try something other than filezilla


-----------------------------------
spirit22
Fri 26 Apr, 2013 21:13

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 linenumbers=false]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[/code]



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 :cry:


-----------------------------------
Limun
Fri 26 Apr, 2013 21:27

Re: Problem Update To 2.0 Version
-----------------------------------
[quote user="spirit22" post="58773"]New error when i try launch install/convert_utf8_nodbal.php

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


[code linenumbers=false]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[/code]



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 :cry:[/quote]
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

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

Re: Problem Update To 2.0 Version
-----------------------------------
[quote user="spirit22" post="58775"]He had CHMOD 644


I put him 666 and does not work either.[/quote]
clear cache , and also check if your config.php is not empty


-----------------------------------
Joshua203
Fri 26 Apr, 2013 21:46

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

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 linenumbers=false]<?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);

?>[/code]


-----------------------------------
Limun
Fri 26 Apr, 2013 21:53

Re: Problem Update To 2.0 Version
-----------------------------------
edit your config.php to this 

[code linenumbers=false]<?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);

 ?>[/code]

save it and try


-----------------------------------
spirit22
Fri 26 Apr, 2013 22:04

Re: Problem Update To 2.0 Version
-----------------------------------
The same error  :cry:


-----------------------------------
Joshua203
Fri 26 Apr, 2013 22:23

Re: Problem Update To 2.0 Version
-----------------------------------
[quote user="Joshua203" post="58778"]Have you moved the nodbal file to the root before running it?[/quote]
please try it :mrorange:


-----------------------------------
spirit22
Fri 26 Apr, 2013 22:38

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


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


I continue with the update...



[b]EDIT: [/b]

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


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


Says: 

[code linenumbers=false]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'[/code]


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  :?


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



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


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



Somebody can help me please?


-----------------------------------
Joshua203
Sat 27 Apr, 2013 15:51

Re: Problem Update To 2.0 Version
-----------------------------------
I still see this path in your errors... /home/kungfuma/public_html/[color=red]install[/color]/convert_utf8_nodbal.php

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

 :shock: Am I hallucinating or did you remove a post? :shock:


-----------------------------------
spirit22
Sat 27 Apr, 2013 16:17

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



[quote user="spirit22" post="58784"]

Now I have my DB in UTF-8


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


I continue with the update...



[b]EDIT: [/b]

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


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


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  :?


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


[/quote]


-----------------------------------
Joshua203
Sat 27 Apr, 2013 17:34

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);' [/quote]
Why would you run anything from the ip directory?... it should not even exist  in your setup :shock:


-----------------------------------
spirit22
Sat 27 Apr, 2013 18:06

Re: Problem Update To 2.0 Version
-----------------------------------
[quote user="Joshua203" post="58791"]Why would you run anything from the ip directory?... it should not even exist  in your setup :shock:[/quote]


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

says: 

[code linenumbers=false]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).[/code]


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


-----------------------------------
Joshua203
Sat 27 Apr, 2013 18:37

Re: Problem Update To 2.0 Version
-----------------------------------
public_html/config.php exists?


-----------------------------------
spirit22
Sat 27 Apr, 2013 18:40

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

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

Re: Problem Update To 2.0 Version
-----------------------------------
Cache cleared.


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



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


[code linenumbers=false]config.php could not be found.

Click here to install Icy Phoenix[/code]


-----------------------------------
Joshua203
Sat 27 Apr, 2013 19:32

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

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.



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



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


-----------------------------------
Joshua203
Sat 27 Apr, 2013 19:55

Re: Problem Update To 2.0 Version
-----------------------------------
content of config.php is PHPBB_INSTALLED again? :shock:


-----------------------------------
spirit22
Sat 27 Apr, 2013 20:03

Re: Problem Update To 2.0 Version
-----------------------------------
Yes  :?  It's bad?


-----------------------------------
Joshua203
Sat 27 Apr, 2013 20:07

Re: Problem Update To 2.0 Version
-----------------------------------
[quote user="Limun" post="58781"]edit your config.php to this 

[code linenumbers=false]<?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);

 ?>[/code]

save it and try[/quote]


-----------------------------------
spirit22
Sat 27 Apr, 2013 20:12

Re: Problem Update To 2.0 Version
-----------------------------------
[img]http://www.icyphoenix.com/files/images/11000/install4.jpg[/img] 


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

Re: Problem Update To 2.0 Version
-----------------------------------
[quote user="ThE KuKa" post="56058"]Show error "session_last_visit" no exist.

phpMyAdmin and SQL tab (into Icy DB)

[code]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`[/code]
And working... :roll:[/quote]


-----------------------------------
spirit22
Sat 27 Apr, 2013 20:40

Re: Problem Update To 2.0 Version
-----------------------------------
Don't work  :? 



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


-----------------------------------
Joshua203
Sat 27 Apr, 2013 20:52

Re: Problem Update To 2.0 Version
-----------------------------------
ok ..I took a better look at this image
[img]http://www.icyphoenix.com/files/images/11000/install4.jpg[/img]

Please try running the suggested SQL insert query :wink:


-----------------------------------
spirit22
Sat 27 Apr, 2013 21:24

Re: Problem Update To 2.0 Version
-----------------------------------
[quote user="Joshua203" post="58806"]Please try running the suggested SQL insert query :wink:[/quote]


I Insert all that code here?

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


And wath table have I select?


-----------------------------------
Joshua203
Sat 27 Apr, 2013 21:38

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  :lol: )


-----------------------------------
spirit22
Sat 27 Apr, 2013 22:17

Re: Problem Update To 2.0 Version
-----------------------------------
Don't work.


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


-----------------------------------
Joshua203
Sat 27 Apr, 2013 22:46

Re: Problem Update To 2.0 Version
-----------------------------------
That query in your last image is not the query in the image.. 
[img]http://www.icyphoenix.com/files/images/11000/install4.jpg[/img]


-----------------------------------
spirit22
Sat 27 Apr, 2013 23:03

Re: Problem Update To 2.0 Version
-----------------------------------
[img]http://www.icyphoenix.com/files/images/11000/insertquery2.jpg[/img]



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

Re: Problem Update To 2.0 Version
-----------------------------------
Well since we are making a mess already ... try running this

[code linenumbers=false]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`[/code]


-----------------------------------
spirit22
Sat 27 Apr, 2013 23:58

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: 

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



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

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

Re: Problem Update To 2.0 Version
-----------------------------------
My cpanel show this error:

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

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.


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


I'll talk to my hosting support. Thanks again


-----------------------------------
Joshua203
Sun 28 Apr, 2013 00:44

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

Re: Problem Update To 2.0 Version
-----------------------------------
Is normal this?


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



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


[b][color=seagreen]Problems solved, thanks guys[/color][/b]  :loveit:


-----------------------------------
Joshua203
Sun 28 Apr, 2013 12:04

Re: Problem Update To 2.0 Version
-----------------------------------
[quote user="spirit22" post="58817"]Is normal this?[/quote]
No that looks like someone in Spain really missed your site alot or he's trying to do a "solo ddos attack".  :lol: 

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) :wink:


