https://www.icyphoenix.com/viewtopic.php?f=35&t=816 ----------------------------------- oscarxp Tue 09 Jan, 2007 11:25 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 Re: Upgrading To Icy Phoenix ----------------------------------- did you try to run update_to_ip ? ----------------------------------- sonoangelo Tue 09 Jan, 2007 13:34 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 Re: Upgrading To Icy Phoenix ----------------------------------- [quote user="sonoangelo" post="6620"]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 :([/quote] You HAVE to run it from root... are you logged as admin before run that file? ----------------------------------- sonoangelo Tue 09 Jan, 2007 14:39 Re: Upgrading To Icy Phoenix ----------------------------------- what means, i have to run it from root? :shock: 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... :( :cry: ----------------------------------- Zuker Tue 09 Jan, 2007 15:12 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 Re: Upgrading To Icy Phoenix ----------------------------------- [quote="Mighty Gorgon"]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 [b]I would suggest you to install it on live environments only if you are quite good PHP and phpBB.[/b][/quote] [quote="Might Gorgon"]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...[/quote] I suggest you to wait for the first stable relase :wink: ----------------------------------- sonoangelo Tue 09 Jan, 2007 16:18 Re: Upgrading To Icy Phoenix ----------------------------------- [quote user="Zuker" post="6626"]U have to be logged as admin and run the update like this http://www.themusicplanet.eu/update_to_ip.php[/quote] i'v done this but nothing :( tell me some errors, now i reupload the files and you see with your eyes " :shock: " :lol: ----------------------------------- sonoangelo Tue 09 Jan, 2007 16:29 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 :cry: ----------------------------------- Zuker Tue 09 Jan, 2007 16:36 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]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' ); [/code] ----------------------------------- sonoangelo Tue 09 Jan, 2007 16:40 Re: Upgrading To Icy Phoenix ----------------------------------- oh damn :cry: 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 Re: Upgrading To Icy Phoenix ----------------------------------- run that sql and try to run update first ----------------------------------- sonoangelo Tue 09 Jan, 2007 16:51 Re: Upgrading To Icy Phoenix ----------------------------------- now tell me this error :shock: the update went right , but now i have a block problem :? ----------------------------------- Zuker Tue 09 Jan, 2007 16:52 Re: Upgrading To Icy Phoenix ----------------------------------- what problem? :roll: ----------------------------------- sonoangelo Tue 09 Jan, 2007 17:01 Re: Upgrading To Icy Phoenix ----------------------------------- look now :shock: Template->make_filename(): Error - template file not found: portal_page_headerleft.tpl i HAVE that file :shock: ----------------------------------- Zuker Tue 09 Jan, 2007 17:12 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 Re: Upgrading To Icy Phoenix ----------------------------------- you saw the site, in the few seconds when i uploded casually the install folder :mryellow: please see now i've also reuploaded ALL the files and folders :shock: ----------------------------------- Zuker Tue 09 Jan, 2007 17:22 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 Re: Upgrading To Icy Phoenix ----------------------------------- yeah ALL uploaded and are big some kbs :) ----------------------------------- sonoangelo Tue 09 Jan, 2007 17:28 Re: Upgrading To Icy Phoenix ----------------------------------- i also uploaded these files one by one, but doesn' work :( ----------------------------------- Zuker Tue 09 Jan, 2007 17:29 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 Re: Upgrading To Icy Phoenix ----------------------------------- i didn't understand :shock: which box? :shock: ----------------------------------- sonoangelo Tue 09 Jan, 2007 17:49 Re: Upgrading To Icy Phoenix ----------------------------------- noone have a soluction? :cry: :cry: UP UP ----------------------------------- sonoangelo Tue 09 Jan, 2007 19:04 Re: Upgrading To Icy Phoenix ----------------------------------- i upgraded correctly to IP, but in the ACP in some module it give me some sql errors :? [code linenumbers=false]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] [code linenumbers=false]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] [code linenumbers=false] 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] [code linenumbers=false]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[/code] and in others blocks :( :cry: ----------------------------------- Zuker Tue 09 Jan, 2007 19:31 Re: Upgrading To Icy Phoenix ----------------------------------- the "update_to_ip.php" was done correct? ----------------------------------- sonoangelo Tue 09 Jan, 2007 19:51 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 :D ----------------------------------- Zuker Tue 09 Jan, 2007 19:58 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 Re: Upgrading To Icy Phoenix ----------------------------------- [quote user="sonoangelo" post="6655"]look now :shock: Template->make_filename(): Error - template file not found: portal_page_headerleft.tpl i HAVE that file :shock:[/quote] 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. [quote user="sonoangelo" post="6677"]i upgraded correctly to IP, but in the ACP in some module it give me some sql errors :? ... [/quote] 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... :wink: 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: [list][*] Make a backup of old DB [*] Install Icy Phoenix from scratch [*] Import from old DB backup [b]ONLY[/b] the tables you need: Posts, Users, Album, etc...[/list] ----------------------------------- sonoangelo Tue 09 Jan, 2007 22:13 Re: Upgrading To Icy Phoenix ----------------------------------- lol i have to do a fresh install ? :shock: e import database?, if is so i'll wait the new release to update toa stable version :D ----------------------------------- Zuker Tue 09 Jan, 2007 22:22 Re: Upgrading To Icy Phoenix ----------------------------------- this is an stable version, but read what MG sayd [quote="MG"]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... [b]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[/b]. During the beta testing period only a limited support (focused on fixing bugs) will be given on Icy Phoenix. [/quote] ----------------------------------- buldo Tue 09 Jan, 2007 22:24 Re: Upgrading To Icy Phoenix ----------------------------------- [quote user="sonoangelo" post="6732"]lol i have to do a fresh install ? :shock: e import database?, if is so i'll wait the new release to update toa stable version :D[/quote] I gave you just a suggestion... :lol: IMHO, at the moment, it's the quickest way to get everythings working! :wink: ----------------------------------- anicio Tue 09 Jan, 2007 23:46 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... :lol: 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... :wink: ----------------------------------- sonoangelo Wed 10 Jan, 2007 07:46 Re: Upgrading To Icy Phoenix ----------------------------------- [quote user="buldo" post="6741"][quote user="sonoangelo" post="6732"]lol i have to do a fresh install ? :shock: e import database?, if is so i'll wait the new release to update toa stable version :D[/quote] I gave you just a suggestion... :lol: IMHO, at the moment, it's the quickest way to get everythings working! :wink:[/quote] thanks i'm doing what that you suggest me, i'll tell you the result in the afternoon :mryellow: ----------------------------------- buldo Wed 10 Jan, 2007 08:34 Re: Upgrading To Icy Phoenix ----------------------------------- [quote user="sonoangelo" post="6840"] thanks i'm doing what that you suggest me, i'll tell you the result in the afternoon :mryellow:[/quote] Ok... Good luck!! :wink: Ciao, ----------------------------------- Zuker Wed 10 Jan, 2007 11:51 Re: Upgrading To Icy Phoenix ----------------------------------- [quote user="anicio" post="6782"]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... :lol: 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... :wink:[/quote] You coud [b]TRY[/b] (read well this word) to move to phpbb from plus and later from phpbb to Icy ----------------------------------- sonoangelo Wed 10 Jan, 2007 14:18 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 :shock: in which table are included? thanks another time :mryellow: you are fantastic :D ps. i've the backup of all the old sql ----------------------------------- Zuker Wed 10 Jan, 2007 14:25 Re: Upgrading To Icy Phoenix ----------------------------------- resync topics table ;) ----------------------------------- sonoangelo Wed 10 Jan, 2007 14:52 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 :mryellow: :mrviolet: :mrorange: :mrblue: :mrgreen: ----------------------------------- Zuker Wed 10 Jan, 2007 15:00 Re: Upgrading To Icy Phoenix ----------------------------------- Finally Solved Mate ;) ----------------------------------- buldo Wed 10 Jan, 2007 15:27 Re: Upgrading To Icy Phoenix ----------------------------------- Great sonoangelo! It has been easy, isn't it? :lol: ----------------------------------- sonoangelo Wed 10 Jan, 2007 18:27 Re: SOLVED -Upgrading To Icy Phoenix ----------------------------------- yeah, at moment i died :evil: ----------------------------------- Mighty Gorgon Thu 11 Jan, 2007 02:14 Re: SOLVED -Upgrading To Icy Phoenix ----------------------------------- Nice work... :lol: ----------------------------------- plasma Thu 11 Jan, 2007 21:40 Re: Upgrading To Icy Phoenix ----------------------------------- yop forgot to read page 2 ----------------------------------- anicio Sat 17 Mar, 2007 15:14 Re: Upgrading To Icy Phoenix ----------------------------------- [quote user="Zuker" post="6854"][quote user="anicio" post="6782"]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? [/quote] You coud [b]TRY[/b] (read well this word) to move to phpbb from plus and later from phpbb to Icy[/quote] 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 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