Icy Phoenix

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

spirit22 [ Fri 26 Apr, 2013 15:30 ]
Post subject: [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 ]
Post subject: 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 -this is your site-

try clear cache in your browser or try other one ..opera,firefox

EDIT: ups, you solved your problem while i was posting this post

spirit22 [ Fri 26 Apr, 2013 15:48 ]
Post subject: 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 ]
Post subject: Re: Problem Update To 2.0 Version

what is your version of icy phoenix?
did you made Step 9.Launch install/database_update.php and update your DB ?

spirit22 [ Fri 26 Apr, 2013 15:59 ]
Post subject: 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 ]
Post subject: 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 ]
Post subject: 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 ]
Post subject: Re: Problem Update To 2.0 Version

spirit22 wrote: [View Post]
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

you dont have and you dont delete tables 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 ]
Post subject: 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

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 ]
Post subject: Re: Problem Update To 2.0 Version

Joshua203 wrote: [View Post]
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

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 Add Uploaded Images To DB 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 ]
Post subject: 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: [Hide] [Select]

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'

but now say this:

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:

Install page 2:

Install page 3:

Joshua203 [ Fri 26 Apr, 2013 18:32 ]
Post subject: 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 ]
Post subject: Re: Problem Update To 2.0 Version

Joshua203 wrote: [View Post]

I have a feeling you tried updating more than once

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 ]
Post subject: 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 ]
Post subject: Re: Problem Update To 2.0 Version

looks like someone did´nt use convert_utf8_nodbal.php

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?