Icy Phoenix

Old Support Topics - Upgrading To Icy Phoenix

oscarxp [ Tue 09 Jan, 2007 11:25 ]
Post subject: Upgrading To Icy Phoenix

Need instructions of how to upgrade to icy phoenix without loosing anything on my forums.

Zuker [ Tue 09 Jan, 2007 12:45 ]
Post subject: Re: Upgrading To Icy Phoenix

did you try to run update_to_ip ?

sonoangelo [ Tue 09 Jan, 2007 13:34 ]
Post subject: Re: Upgrading To Icy Phoenix

when i upload the files it gice me a lot of ctracker's errors, and do the same if i run that file on the main directory

andrea75 [ Tue 09 Jan, 2007 14:31 ]
Post subject: Re: Upgrading To Icy Phoenix

sonoangelo wrote: [View Post]
when i upload the files it gice me a lot of ctracker's errors, and do the same if i run that file on the main directory

You HAVE to run it from root... are you logged as admin before run that file?

sonoangelo [ Tue 09 Jan, 2007 14:39 ]
Post subject: Re: Upgrading To Icy Phoenix

what means, i have to run it from root?

i open my site in the home page, but it give me errors and after i run that file, but give me always the same errors.
Before now i have update the XS 049 to 058b in this way and all right, but now...

Zuker [ Tue 09 Jan, 2007 15:12 ]
Post subject: Re: Upgrading To Icy Phoenix

U have to be logged as admin and run the update like this http://www.themusicplanet.eu/update_to_ip.php

z3d0 [ Tue 09 Jan, 2007 15:35 ]
Post subject: Re: Upgrading To Icy Phoenix

Mighty Gorgon wrote:
This beta release is meant for having some flavour of what the Icy Phoenix is going to be, fixing the bugs and maybe obtain some good suggestions to be implemented in the final release... Even if this package is quite stable I would suggest you to install it on live environments only if you are quite good PHP and phpBB.

Might Gorgon wrote:
If you are trying to upgrade your existing sites to this release you should consider that the final release may not contain upgrading instructions from this beta. You have been warned...

I suggest you to wait for the first stable relase

sonoangelo [ Tue 09 Jan, 2007 16:18 ]
Post subject: Re: Upgrading To Icy Phoenix

Zuker wrote: [View Post]
U have to be logged as admin and run the update like this http://www.themusicplanet.eu/update_to_ip.php

i'v done this but nothing

tell me some errors, now i reupload the files and you see with your eyes "

sonoangelo [ Tue 09 Jan, 2007 16:29 ]
Post subject: Re: Upgrading To Icy Phoenix

look i'v uploaded all to root see here

http://www.themusicplanet.eu/public/ ----> Home Page

http://www.themusicplanet.eu/public/update_to_ip.php ----> Update Page

If someone have the solution please post here

Zuker [ Tue 09 Jan, 2007 16:36 ]
Post subject: Re: Upgrading To Icy Phoenix

Yes, that's because you have upload first the files and you MUST run the update first

run this sql and check

Code: [Hide]

ALTER TABLE `phpbb_users` ADD `ct_search_time` INT( 11 ) NULL DEFAULT 1 AFTER `user_newpasswd`;
 
ALTER TABLE `phpbb_users` ADD `ct_search_count` MEDIUMINT( 8 ) NULL DEFAULT 1 AFTER `ct_search_time`;
 
ALTER TABLE `phpbb_users` ADD `ct_last_mail` INT( 11 ) NULL DEFAULT 1 AFTER `ct_search_count`;
 
ALTER TABLE `phpbb_users` ADD `ct_last_post` INT( 11 ) NULL DEFAULT 1 AFTER `ct_last_mail`;
 
ALTER TABLE `phpbb_users` ADD `ct_post_counter` MEDIUMINT( 8 ) NULL DEFAULT 1 AFTER `ct_last_post`;
 
ALTER TABLE `phpbb_users` ADD `ct_last_pw_reset` INT( 11 ) NULL DEFAULT 1 AFTER `ct_post_counter`;
 
ALTER TABLE `phpbb_users` ADD `ct_enable_ip_warn` TINYINT( 1 ) NULL DEFAULT 1 AFTER `ct_last_pw_reset`;
 
ALTER TABLE `phpbb_users` ADD `ct_last_used_ip` VARCHAR( 16 ) NULL DEFAULT '0.0.0.0' AFTER `ct_enable_ip_warn`;
 
ALTER TABLE `phpbb_users` ADD `ct_last_ip` VARCHAR( 16 ) NULL DEFAULT '0.0.0.0' AFTER `ct_last_used_ip`;
 
ALTER TABLE `phpbb_users` ADD `ct_login_count` MEDIUMINT( 8 ) NULL DEFAULT 1 AFTER `ct_last_used_ip`;
 
ALTER TABLE `phpbb_users` ADD `ct_login_vconfirm` TINYINT( 1 ) NULL DEFAULT 0 AFTER `ct_login_count`;
 
ALTER TABLE `phpbb_users` ADD `ct_last_pw_change` INT( 11 ) NULL DEFAULT 1 AFTER `ct_login_vconfirm`;
 
ALTER TABLE `phpbb_users` ADD `ct_global_msg_read` TINYINT( 1 ) NULL DEFAULT 0 AFTER `ct_last_pw_change`;
 
ALTER TABLE `phpbb_users` ADD `ct_miserable_user` TINYINT( 1 ) NULL DEFAULT 0 AFTER `ct_global_msg_read`;
 
CREATE TABLE `phpbb_ctracker_config` (
 
	`ct_config_name` varchar(255) NOT NULL,
 
	`ct_config_value` varchar(255) NOT NULL,
 
	PRIMARY KEY  (`ct_config_name`)
 
	);
 
CREATE TABLE `phpbb_ctracker_filechk` (
 
	`filepath` text,
 
	`hash` varchar(32) default NULL
 
	);
 
CREATE TABLE `phpbb_ctracker_filescanner` (
 
	`id` smallint(5) NOT NULL,
 
	`filepath` text,
 
	`safety` smallint(1) NOT NULL default '0',
 
	PRIMARY KEY  (`id`)
 
	);
 
CREATE TABLE `phpbb_ctracker_ipblocker` (
 
	`id` mediumint(8) unsigned NOT NULL,
 
	`ct_blocker_value` varchar(250) default NULL,
 
	PRIMARY KEY  (`id`)
 
	);
 
CREATE TABLE `phpbb_ctracker_loginhistory` (
 
	`ct_user_id` int(10) default NULL,
 
	`ct_login_ip` varchar(16) default NULL,
 
	`ct_login_time` int(11) NOT NULL default '0'
 
	);

sonoangelo [ Tue 09 Jan, 2007 16:40 ]
Post subject: Re: Upgrading To Icy Phoenix

oh damn

reupload the old or run this sql query? xcuse me for the time tha you lose for me

Zuker [ Tue 09 Jan, 2007 16:44 ]
Post subject: Re: Upgrading To Icy Phoenix

run that sql and try to run update first

sonoangelo [ Tue 09 Jan, 2007 16:51 ]
Post subject: Re: Upgrading To Icy Phoenix

now tell me this error

the update went right , but now i have a block problem

Zuker [ Tue 09 Jan, 2007 16:52 ]
Post subject: Re: Upgrading To Icy Phoenix

what problem?

sonoangelo [ Tue 09 Jan, 2007 17:01 ]
Post subject: Re: Upgrading To Icy Phoenix

look now

Template->make_filename(): Error - template file not found: portal_page_headerleft.tpl

i HAVE that file

Zuker [ Tue 09 Jan, 2007 17:12 ]
Post subject: Re: Upgrading To Icy Phoenix

Elimina le cartelle install/ e contrib/ dal tuo server

did you upload all the files? footer says Powered by phpBB XS 2 based on phpBB © phpBB Group

sonoangelo [ Tue 09 Jan, 2007 17:14 ]
Post subject: Re: Upgrading To Icy Phoenix

you saw the site, in the few seconds when i uploded casually the install folder

please see now

i've also reuploaded ALL the files and folders

Zuker [ Tue 09 Jan, 2007 17:22 ]
Post subject: Re: Upgrading To Icy Phoenix

Template->make_filename(): Error - template file not found: portal_page_tailcenter.tpl

Make sure that the templates/mg_themes folder is fully uploaded and there aren't 0 size files

sonoangelo [ Tue 09 Jan, 2007 17:23 ]
Post subject: Re: Upgrading To Icy Phoenix

yeah ALL uploaded and are big some kbs

sonoangelo [ Tue 09 Jan, 2007 17:28 ]
Post subject: Re: Upgrading To Icy Phoenix

i also uploaded these files one by one, but doesn' work

Zuker [ Tue 09 Jan, 2007 17:29 ]
Post subject: Re: Upgrading To Icy Phoenix

i don't think so...
check the box where styles are managed at forum page, there are only shown old themes

check if you can install new icyphoenix theme at acp

sonoangelo [ Tue 09 Jan, 2007 17:31 ]
Post subject: Re: Upgrading To Icy Phoenix

i didn't understand

which box?

sonoangelo [ Tue 09 Jan, 2007 17:49 ]
Post subject: Re: Upgrading To Icy Phoenix

noone have a soluction?

UP UP

sonoangelo [ Tue 09 Jan, 2007 19:04 ]
Post subject: Re: Upgrading To Icy Phoenix

i upgraded correctly to IP, but in the ACP in some module it give me some sql errors

Code: [Hide] [Select]

Errore Generale

CBACK CrackerTracker non può eseguire correttamente le operazioni sul database.

DEBUG MODE

SQL Error : 1064 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 'TheMusicPlanet.eu"")' at line 1

INSERT INTO phpbb_TMPctracker_backup (`config_name`, `config_value`) VALUES ("board_email_sig", "Grazie Lo Staff Di "TheMusicPlanet.eu"")

Line : 637

File : class_ct_adminfunctions.php

Code: [Hide] [Select]

Critical Error

Could not query portal config table

DEBUG MODE

SQL Error : 1146 Table 'Sql114717_1.PORTAL_CONFIG_TABLE' doesn't exist

SELECT config_value FROM PORTAL_CONFIG_TABLE WHERE config_name = 'default_portal'

Line : 81

File : admin_layout.php

Code: [Hide] [Select]

Could not query portal config information

DEBUG MODE

SQL Error : 1146 Table 'Sql114717_1.BLOCK_VARIABLE_TABLE' doesn't exist

SELECT * FROM BLOCK_VARIABLE_TABLE ORDER BY bvid

Line : 49

File : admin_portal.php

Code: [Hide] [Select]

Critical Error

Could not query blocks variables information

DEBUG MODE

SQL Error : 1146 Table 'Sql114717_1.BLOCK_VARIABLE_TABLE' doesn't exist

SELECT * FROM BLOCK_VARIABLE_TABLE ORDER BY block, bvid

Line : 338

File : admin_blocks_var.php

and in others blocks

Zuker [ Tue 09 Jan, 2007 19:31 ]
Post subject: Re: Upgrading To Icy Phoenix

the "update_to_ip.php" was done correct?

sonoangelo [ Tue 09 Jan, 2007 19:51 ]
Post subject: Re: Upgrading To Icy Phoenix

yes but doesn't work very good, can you try to open my site? may be that give you the template error

please tell me if i have to run an sql query thanks a lot

Zuker [ Tue 09 Jan, 2007 19:58 ]
Post subject: Re: Upgrading To Icy Phoenix

u must uninstall old xs templates and use the new themes that icy got

buldo [ Tue 09 Jan, 2007 21:24 ]
Post subject: Re: Upgrading To Icy Phoenix

sonoangelo wrote: [View Post]
look now
Template->make_filename(): Error - template file not found: portal_page_headerleft.tpl
i HAVE that file

This happen because there are too many difference between phpBBXS 2 and Icy Phoenix in the way they manage blocks of variuos page.
I suggest you to create new page, from CMS menu, from scratch.

sonoangelo wrote: [View Post]
i upgraded correctly to IP, but in the ACP in some module it give me some sql errors
...

I think those problems also are related to older XS files on "adm" folder, try to delete old "adm" folder and upload the new one...

I have some of this problems during testing IP alfa releases (old Area 69) and the quickest way to solve them, in my opinion, is:

Make a backup of old DB
Install Icy Phoenix from scratch
Import from old DB backup ONLY the tables you need: Posts, Users, Album, etc...

sonoangelo [ Tue 09 Jan, 2007 22:13 ]
Post subject: Re: Upgrading To Icy Phoenix

lol i have to do a fresh install ?

e import database?, if is so i'll wait the new release to update toa stable version

Zuker [ Tue 09 Jan, 2007 22:22 ]
Post subject: Re: Upgrading To Icy Phoenix

this is an stable version, but read what MG sayd

MG wrote:
This beta release is meant for having some flavour of what the Icy Phoenix is going to be, fixing the bugs and maybe obtain some good suggestions to be implemented in the final release... Even if this package is quite stable I would suggest you to install it on live environments only if you are quite good PHP and phpBB. During the beta testing period only a limited support (focused on fixing bugs) will be given on Icy Phoenix.

buldo [ Tue 09 Jan, 2007 22:24 ]
Post subject: Re: Upgrading To Icy Phoenix

sonoangelo wrote: [View Post]
lol i have to do a fresh install ? e import database?, if is so i'll wait the new release to update toa stable version

I gave you just a suggestion...

IMHO, at the moment, it's the quickest way to get everythings working!

anicio [ Tue 09 Jan, 2007 23:46 ]
Post subject: Re: Upgrading To Icy Phoenix

Hi all!

...what about the problems could arise for a migration from phpBB Plus 1.53a, Win2K/MySql 5/PHP4 based to Icy Phoenix (btw, this sounds so cool!) ?
I've just update the forum I admin to phpBBplus, but you know, nothing is really aweful like a new forum platform migration...

So I would like to verify this CMS on my local server, and I'm guessing about possible troubles and problems.
Any special care before trying?

TIA.

P.S.: Luca, ottimo lavoro, come al solito...

sonoangelo [ Wed 10 Jan, 2007 07:46 ]
Post subject: Re: Upgrading To Icy Phoenix

buldo wrote: [View Post]
sonoangelo wrote: [View Post]
lol i have to do a fresh install ? e import database?, if is so i'll wait the new release to update toa stable version

I gave you just a suggestion...
IMHO, at the moment, it's the quickest way to get everythings working!

thanks i'm doing what that you suggest me, i'll tell you the result in the afternoon

buldo [ Wed 10 Jan, 2007 08:34 ]
Post subject: Re: Upgrading To Icy Phoenix

sonoangelo wrote: [View Post]

thanks i'm doing what that you suggest me, i'll tell you the result in the afternoon

Ok... Good luck!!

Ciao,

Zuker [ Wed 10 Jan, 2007 11:51 ]
Post subject: Re: Upgrading To Icy Phoenix

anicio wrote: [View Post]
Hi all!

...what about the problems could arise for a migration from phpBB Plus 1.53a, Win2K/MySql 5/PHP4 based to Icy Phoenix (btw, this sounds so cool!) ?
I've just update the forum I admin to phpBBplus, but you know, nothing is really aweful like a new forum platform migration...
So I would like to verify this CMS on my local server, and I'm guessing about possible troubles and problems.
Any special care before trying?

TIA.

P.S.: Luca, ottimo lavoro, come al solito...

You coud TRY (read well this word) to move to phpbb from plus and later from phpbb to Icy

sonoangelo [ Wed 10 Jan, 2007 14:18 ]
Post subject: Re: Upgrading To Icy Phoenix

now i've done a fresh install and ran the important sql queries (forums,post,topics,users,categories). Works all perfectly but i don't see the forums and the relatives posts

in which table are included? thanks another time

you are fantastic

ps. i've the backup of all the old sql

Zuker [ Wed 10 Jan, 2007 14:25 ]
Post subject: Re: Upgrading To Icy Phoenix

resync topics table

sonoangelo [ Wed 10 Jan, 2007 14:52 ]
Post subject: Re: Upgrading To Icy Phoenix

now work well and is very very very very excellent, TOP SPEED, thanks a lot to all you are fantastic again

Zuker [ Wed 10 Jan, 2007 15:00 ]
Post subject: Re: Upgrading To Icy Phoenix

Finally Solved Mate

buldo [ Wed 10 Jan, 2007 15:27 ]
Post subject: Re: Upgrading To Icy Phoenix

Great sonoangelo!
It has been easy, isn't it?

sonoangelo [ Wed 10 Jan, 2007 18:27 ]
Post subject: Re: SOLVED -Upgrading To Icy Phoenix

yeah, at moment i died

Mighty Gorgon [ Thu 11 Jan, 2007 02:14 ]
Post subject: Re: SOLVED -Upgrading To Icy Phoenix

Nice work...

plasma [ Thu 11 Jan, 2007 21:40 ]
Post subject: Re: Upgrading To Icy Phoenix

yop forgot to read page 2

anicio [ Sat 17 Mar, 2007 15:14 ]
Post subject: Re: Upgrading To Icy Phoenix

Zuker wrote: [View Post]
anicio wrote: [View Post]
Hi all!

...what about the problems could arise for a migration from phpBB Plus 1.53a, Win2K/MySql 5/PHP4 based to Icy Phoenix?
...
Any special care before trying?

You coud TRY (read well this word) to move to phpbb from plus and later from phpbb to Icy

Yuo mean:
a) downgrade PHPBB Plus 1.53a to 2.last and then
b) upgrade PHPBB 2.last to IP?

But in this way I could loose a lot of features and user data... expecially those related to user profiles... isn't?

.

Zuker [ Sat 17 Mar, 2007 16:30 ]
Post subject: Re: SOLVED - Upgrading To Icy Phoenix

i don't think that u will lose profile data...

the best way to know it is giving a try