Icy Phoenix

feelbeen wrote: [View Post]

Code: [Hide] [Select]

Code: [Show]

ALTER TABLE `ip_cms_blocks` DROP `cache`
+++ Error: Can't DROP 'cache'; check that column/key exists

ALTER TABLE `ip_cms_blocks` DROP `cache_time`
+++ Error: Can't DROP 'cache_time'; check that column/key exists

DELETE FROM `ip_cms_config` WHERE `config_name` = 'portal_header'
+++ Successfull

DELETE FROM `ip_cms_config` WHERE `config_name` = 'portal_tail'
+++ Successfull

DELETE FROM `ip_cms_config` WHERE `config_name` = 'cache_enabled'
+++ Successfull

DELETE FROM `ip_cms_config` WHERE `config_name` = 'md_cache_file_locking'
+++ Successfull

DELETE FROM `ip_cms_config` WHERE `config_name` = 'md_cache_write_control'
+++ Successfull

DELETE FROM `ip_cms_config` WHERE `config_name` = 'md_cache_read_control'
+++ Successfull

DELETE FROM `ip_cms_config` WHERE `config_name` = 'md_cache_read_type'
+++ Successfull

DELETE FROM `ip_cms_config` WHERE `config_name` = 'md_cache_filename_protect'
+++ Successfull

DELETE FROM `ip_cms_config` WHERE `config_name` = 'md_cache_serialize'
+++ Successfull

DELETE FROM `ip_cms_block_variable` WHERE `config_name` = 'portal_header'
+++ Successfull

DELETE FROM `ip_cms_block_variable` WHERE `config_name` = 'portal_tail'
+++ Successfull

DELETE FROM `ip_cms_block_variable` WHERE `config_name` = 'cache_enabled'
+++ Successfull

DELETE FROM `ip_cms_block_variable` WHERE `config_name` = 'md_cache_file_locking'
+++ Successfull

DELETE FROM `ip_cms_block_variable` WHERE `config_name` = 'md_cache_write_control'
+++ Successfull

DELETE FROM `ip_cms_block_variable` WHERE `config_name` = 'md_cache_read_control'
+++ Successfull

DELETE FROM `ip_cms_block_variable` WHERE `config_name` = 'md_cache_read_type'
+++ Successfull

DELETE FROM `ip_cms_block_variable` WHERE `config_name` = 'md_cache_filename_protect'
+++ Successfull

DELETE FROM `ip_cms_block_variable` WHERE `config_name` = 'md_cache_serialize'
+++ Successfull

UPDATE ip_album_config SET config_value = '.0.56' WHERE config_name = 'album_version'
+++ Successfull

INSERT INTO ip_config (config_name, config_value) VALUES ('digests_php_cron_lock', '0')
+++ Error: Duplicate entry 'digests_php_cron_lock' for key 1

INSERT INTO ip_config (config_name, config_value) VALUES ('allow_only_id2_admin', '0')
+++ Error: Duplicate entry 'allow_only_id2_admin' for key 1

INSERT INTO ip_config VALUES ('ip_version', '1.1.0.15')
+++ Error: Duplicate entry 'ip_version' for key 1

UPDATE ip_config SET config_value = '1.1.0.15' WHERE config_name = 'ip_version'
+++ Successfull

UPDATE ip_config SET config_value = '.0.22' WHERE `config_name` = 'version'
+++ Successfull

UPDATE ip_album_config SET config_value = '1.4.2' WHERE config_name = 'fap_version'
+++ Successfull

UPDATE ip_config SET `config_value` = '3.0.7' WHERE `config_name` = 'upi2db_version'
+++ Successfull




CHMOD Files



CHMOD 0777: cache
+++ Error CHMOD 0777: cache

CHMOD 0777: ctracker/logfiles/logfile_attempt_counter.txt
+++ Error CHMOD 0777: ctracker/logfiles/logfile_attempt_counter.txt

CHMOD 0777: ctracker/logfiles/logfile_blocklist.txt
+++ Error CHMOD 0777: ctracker/logfiles/logfile_blocklist.txt

CHMOD 0777: ctracker/logfiles/logfile_debug_mode.txt
+++ Error CHMOD 0777: ctracker/logfiles/logfile_debug_mode.txt

CHMOD 0777: ctracker/logfiles/logfile_malformed_logins.txt
+++ Error CHMOD 0777: ctracker/logfiles/logfile_malformed_logins.txt

CHMOD 0777: ctracker/logfiles/logfile_spammer.txt
+++ Error CHMOD 0777: ctracker/logfiles/logfile_spammer.txt

CHMOD 0777: ctracker/logfiles/logfile_worms.txt
+++ Error CHMOD 0777: ctracker/logfiles/logfile_worms.txt

CHMOD 0777: files
+++ Error CHMOD 0777: files

CHMOD 0777: files/album
+++ Error CHMOD 0777: files/album

CHMOD 0777: files/album/cache
+++ Error CHMOD 0777: files/album/cache

CHMOD 0777: files/album/med_cache
+++ Error CHMOD 0777: files/album/med_cache

CHMOD 0777: files/album/wm_cache
+++ Error CHMOD 0777: files/album/wm_cache

CHMOD 0777: files/posted_images
+++ Error CHMOD 0777: files/posted_images

CHMOD 0777: files/thumbs
+++ Error CHMOD 0777: files/thumbs

CHMOD 0777: images/avatars
+++ Error CHMOD 0777: images/avatars

CHMOD 0777: logs
+++ Error CHMOD 0777: logs

CHMOD 0777: pafiledb/uploads
+++ Error CHMOD 0777: pafiledb/uploads

CHMOD 0777: pafiledb/cache
+++ Error CHMOD 0777: pafiledb/cache

CHMOD 0777: pafiledb/cache/templates
+++ Error CHMOD 0777: pafiledb/cache/templates

CHMOD 0777: pafiledb/cache/templates/ca_aphrodite
+++ Error CHMOD 0777: pafiledb/cache/templates/ca_aphrodite

CHMOD 0777: pafiledb/cache/templates/mg_themes
+++ Error CHMOD 0777: pafiledb/cache/templates/mg_themes

CHMOD 0666: includes/def_themes.php
+++ Error CHMOD 0666: includes/def_themes.php

CHMOD 0666: includes/def_tree.php
+++ Error CHMOD 0666: includes/def_tree.php

CHMOD 0666: includes/def_words.php
+++ Error CHMOD 0666: includes/def_words.php

CHMOD 0666: language/lang_english/lang_extend.php
+++ Error CHMOD 0666: language/lang_english/lang_extend.php

after I lanuched update_to_ip.php this is the page... I have 1.0.14.14 and I choose the fourth option of upgrade...

what's happen?

Zuker wrote: [View Post]

No mate... he is upgrading
No need to do fresh install

feelbeen wrote: [View Post]

I don't understand anything...

1. Can't DROP 'cache'; check that column/key exists .... what does it mean?

2. the files in the list I wrote in the first post are already chmodded... I mean: I checked for example files/album (and also others) and the folder is chmodded 777... like it says in the list...

gearhead wrote: [View Post]

feelbeen wrote: [View Post]

I don't understand anything...

1. Can't DROP 'cache'; check that column/key exists .... what does it mean?

2. the files in the list I wrote in the first post are already chmodded... I mean: I checked for example files/album (and also others) and the folder is chmodded 777... like it says in the list...

I am thinking that the sql file "cache" holds data that your previous install had. It needs to be there....

The same thing happened to me. I found everything to work good. One thing I always notice;

If you use a program to FTP, sometimes depending on the .htacess file, you can only change CHMOD from your site FTP...

hope this helps. My site is running fine.

After reading your post, I am going to double check my CHMODS to make sure they are correct from the site FTP.

check my site: http://www.portal.thegtsaga.net/main/index.php

Zuker wrote: [View Post]

A little issue i don't understand

what is the problem about your upgrade? is it your site running?

Quote:

Remember that this file have to be in your root!


Upgrading options:
Update to latest Icy Phoenix from phpBB or any older phpBB XS version

Update to latest Icy Phoenix from phpBB XS 058

Update to latest Icy Phoenix from Icy Phoenix 1.0.5.5 beta

Update to latest Icy Phoenix from Icy Phoenix 1.0.11.11 RC (or higher)

Zuker wrote: [View Post]

Some errors are because some db changes are listed to have a safe upgrade. I'd also errors, but are because that field on my db is also there.

If files are chmoded, don't worry and enjoy icy phoenix

Quote:

I don't understand your help... I check my chmods by FTP...
what I have to do to have a right upgrade?

 

Off Topic

:

Please, when posting long code use the spoiler tag... and when quoting, please, delete long code from quotes... there is no need to add all those things.