Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 4
Goto page 1, 2, 3, 4  Next
 
Reply with quote Download Post 
Post [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 
spirit22Send private message  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post 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-
 01_1366983792_104730

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!
 
LimunSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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_
 



 
spirit22Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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!
 
LimunSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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 
spirit22Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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!
 
LimunSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 



 
spirit22Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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)
 




____________
We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!
 
LimunSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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?¿?)
 
Joshua203Send private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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 )
 




____________
We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!
 
LimunSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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: [Download] [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:

 update




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_page1



Install page 2:

 install_page2



Install page 3:

 install_page3_1366993721_447941
 



 
spirit22Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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
Joshua203Send private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 




____________
We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!
 
LimunSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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.
 



 
spirit22Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Problem Update To 2.0 Version 
 
looks like someone did´nt use convert_utf8_nodbal.php
 




____________
Out of Order
 
spydieSend private messageVisit poster's website  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 4
Goto page 1, 2, 3, 4  Next


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
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