|
Page 1 of 4
|
spirit22
Joined: April 2013
Posts: 51
|
[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)
Last edited by spirit22 on Sun 28 Apr, 2013 14:52; edited 2 times in total |
#1 Fri 26 Apr, 2013 15:30 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
|
Limun
Joined: January 2008
Posts: 1334
Location: [Censor]
|
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
____________ We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!
|
#2 Fri 26 Apr, 2013 15:46 |
|
spirit22
Joined: April 2013
Posts: 51
|
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_
|
#3 Fri 26 Apr, 2013 15:48 |
|
Limun
Joined: January 2008
Posts: 1334
Location: [Censor]
|
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 ?
____________ We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!
|
#4 Fri 26 Apr, 2013 15:54 |
|
spirit22
Joined: April 2013
Posts: 51
|
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.
Last edited by spirit22 on Sat 27 Apr, 2013 16:05; edited 1 time in total |
#5 Fri 26 Apr, 2013 15:59 |
|
Limun
Joined: January 2008
Posts: 1334
Location: [Censor]
|
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)
____________ We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!
|
#6 Fri 26 Apr, 2013 16:27 |
|
Limun
Joined: January 2008
Posts: 1334
Location: [Censor]
|
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
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)
____________ We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!
|
#8 Fri 26 Apr, 2013 16:36 |
|
Joshua203
Joshua 203
Dutch A Go Go
Joined: August 2008
Posts: 1754
Location: Earth, Europe, the Netherlands, Rotterdam
|
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.
____________ www.DutchaGoGo.com (development/under construction ...Forever?¿?)
|
#9 Fri 26 Apr, 2013 17:52 |
|
Limun
Joined: January 2008
Posts: 1334
Location: [Censor]
|
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
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 )
____________ We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!
|
#10 Fri 26 Apr, 2013 17:57 |
|
spirit22
Joined: April 2013
Posts: 51
|
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
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:
|
#11 Fri 26 Apr, 2013 17:57 |
|
Joshua203
Joshua 203
Dutch A Go Go
Joined: August 2008
Posts: 1754
Location: Earth, Europe, the Netherlands, Rotterdam
|
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
____________ www.DutchaGoGo.com (development/under construction ...Forever?¿?)
Edited by Joshua203, Fri 26 Apr, 2013 18:38: EDITS EDITS EDITS |
#12 Fri 26 Apr, 2013 18:32 |
|
Limun
Joined: January 2008
Posts: 1334
Location: [Censor]
|
Re: Problem Update To 2.0 Version
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
____________ We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!
|
#13 Fri 26 Apr, 2013 18:34 |
|
spirit22
Joined: April 2013
Posts: 51
|
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.
|
#14 Fri 26 Apr, 2013 18:42 |
|
spydie
Joined: December 2008
Posts: 1796
Location: In the Boxes
|
Re: Problem Update To 2.0 Version
looks like someone did´nt use convert_utf8_nodbal.php
____________ Out of Order
|
#15 Fri 26 Apr, 2013 18:53 |
|
|
Page 1 of 4
|
Was this topic useful?
Was this topic useful?
Link this topic |
URL |
|
BBCode |
|
HTML |
|
You cannot post new topics You cannot reply to topics You cannot edit your posts You cannot delete your posts You cannot vote in polls You cannot attach files You can download files You cannot post calendar events
|
|
|
|