https://www.icyphoenix.com/viewtopic.php?f=35&t=5759 ----------------------------------- Yros Wed 22 Apr, 2009 01:48 Help On Adaptation ----------------------------------- Hello, My forum actually is under CH ( Category Hierarchy, a great mod for phpBB2 ) and I tried to update it to IP but I didn't found the solution until now. That's why I tried to downgrade my CH forum to a phpBB2 forum, what I've successfuly done, but when I started the upgrading from phpBB2 to IP there was something wrong because, at the end, the adaptation wasn't successful. That's the reason why I now come here, to find some help on my adaptation. All I want is make safe : the forums and sub-forums, every posts / topics and users' access. I think I sucessfully adapted the following tables : phpbb_users phpbb_posts phpbb_privmsgs My problem, I think, is with the phpbb_forums table ... Because when I let the original table, there's no problem. But when I let my forums' table, it give me a blank page when I show the forum ! My friend, Informpro, think it's because of the _auth table and think there is a problem with auth access on forums =/ So if someone could try to take a look to my problem, it really could help me ... Here you will find my full table that I try to adapt : [url=http://superuploader.net/f555b3498245-Yros-tables-sql.html]LINK PS : be careful with phpbb_posts table : this only one table do 4.1mo ^^' Thanks for your help. ----------------------------------- DWho Thu 23 Apr, 2009 10:26 Re: Help On Adaptation ----------------------------------- are you saying after you upgraded to icy all your pages are blank...? ----------------------------------- Yros Thu 23 Apr, 2009 20:43 Re: Help On Adaptation ----------------------------------- Yes. index.php, /adm/, etc ... Except /adm/erc.php ( but that's normal ^^' ). My friend Informpro linked to me some threads about this blank page problems but any solutions given in didn't help me. As I said, the problem seems to be with the sub-forums as if I don't know why because it seems rightly adapted ... I made some test and finaly, with the original _forums table ( of the installation of IP ), there's no problems. But when I copy my table adapted, I get every pages blank =/ ----------------------------------- Limun Sun 26 Apr, 2009 20:10 Re: Help On Adaptation ----------------------------------- i m playing with ur database maybe i can find soltuion maybe not but if i dont try i will never know so i added your database and also table forums [img]http://www.icyphoenix.com/files/images/3336/inf1.png[/img] but i cant see them , i need your [b]def_tree.php[/b] and [b]def_auth.php[/b] maybe also [b]def_tree_def.tpl[/b] (this last i even dont know what is it in RC1 ) also i need password for this user [img]http://www.icyphoenix.com/files/images/3336/inf2.png[/img] so if you wish send me in PM this files and pass :wink: ----------------------------------- Yros Mon 27 Apr, 2009 02:36 Re: Help On Adaptation ----------------------------------- Weelll ... About the files, it's simply original files ( I replaced it many times without any change to notice ). ----------------------------------- Limun Mon 27 Apr, 2009 10:01 Re: Help On Adaptation ----------------------------------- [quote user="Yros" post="38829"]Weelll ... About the files, it's simply original files ( I replaced it many times without any change to notice ).[/quote] well withot them i dont get forums ...thats why i need them [img]http://www.icyphoenix.com/files/images/3336/inf3.png[/img] ----------------------------------- Informpro Mon 27 Apr, 2009 18:12 Re: Help On Adaptation ----------------------------------- It's because he have put all topic on categories = 0, but there is any categories with 0 ^^' it's 1 to begin .. (On his server, he could'n't see adm/erc.php ...) ----------------------------------- Limun Mon 27 Apr, 2009 19:03 Re: Help On Adaptation ----------------------------------- never mind ... as i sad your forum tables , users are on in my local database but i cant see forums without def_three , i see only one forum and its mine from fresh instalation... ----------------------------------- Yros Tue 28 Apr, 2009 01:55 Re: Help On Adaptation ----------------------------------- Let me explain some things : First of all this forum is originaly created on phpBB 2.x.x and modded with Category Hierarchy. This last changed a lot of things in the forums that's why, before upgrading to IP, I put my forum on phpBB 2.x.x WITHOUT CH ( category hierarchy ). As you said, every forums have a cat_id = 0 but nevermind because in the categories' table I changed the value to 0 too then in phpBB 2.x.x I got every forums in the same root BUT it was displayed. Here you will find a screen of my forum under phpBB ( simply ) : The Index : http://d4.e-loader.net/roWKgBOHea.png ADM Pannel : http://d7.e-loader.net/AzStm84aZF.png ( be careful there's many sub-forums so it make very long screenshots because, as I said, every sub-forums are now on the same root ). [...] I just thought about something ... You talk about def_tree.php and I just opened it : it's very similar of the conception of full_tree.php ( in the cache ). Then I tried to replace def_tree.php with full_tree.php but it did nothing. I think the solution is close of something else but I don't know where =( Then I put my files here : /common.php = http://d5.e-loader.net/i8LN3vDRlI.txt /includes/def_auth.php = http://d12.e-loader.net/Ip1AzGihse.txt /includes/def_tree.php = http://d12.e-loader.net/kc4kcd6b32.txt /cache/full_tree.php = http://d13.e-loader.net/CTKlB8umJb.txt I hope that will help you ( to help me >.<' ). Thanks for your help and your patience =/ EDIT : My version of IP is this one : http://code.assembla.com/icy_phoenix/subversion/nodes/ip/trunk => Isn't it possible to create manually every sub-forums and to change every id for make it ok ? =/ ----------------------------------- Limun Wed 29 Apr, 2009 17:15 Re: Help On Adaptation ----------------------------------- finaly i got some results seems that problem was in [b](15, 1, 'c', 'Spirit-Magic'[/b] this column so i edited description [b]Ici c''est la partie concernant le forum lui-m?me. Vous aurez, entre autre, l''histoire ( faut bien qu''il y en ait une ^^ ) ainsi que des informations détaillées sur l''hébergement ( si ça vous intéresse ), la configuration du forum ( bizarro?de au possible x) ) et surement d''autres topics que vous trouverez parfois inutile sauf pour certains *.* En gros ici c''est le Forum dans toute sa splendeur XD\r\n
/-! Histoire !-\\\r\n
/-! Tutoriaux sur les divers Modules (- ? lire -) !-\\
[/b] to [b]ici[/b] because i dunno what that mean but there was problem .. and here we go see this picture of your forums in my local [img]http://www.icyphoenix.com/files/images/3336/ici.png[/img] i didnt added posts because they are too big that you will do it here the phpbb_forums repaired and full_three if you need it dont forghet to empty main cache and forums cache ----------------------------------- Yros Wed 29 Apr, 2009 20:14 Re: Help On Adaptation ----------------------------------- First of all, THANK YOU a lot because that's it : everything is ok now ^^ ! Now there's just 2 things I would like to know : 1) how this only one table could bug like that ? ( I mean only that description ) ( And how you found it was from there ? ^^' ) 2) I've, in every posts, some code I would like to cut off : in every bbcodes, there's some " uid " like [b:########] and I would like to know how to cut off this uid of every posts in same time. I know there is something for it in " install.php " but when I use it it tell me " error in editing posts " ='( So how remove this uid to make every bbcodes ok ? =/ But really thanks again for your help =D ----------------------------------- Limun Wed 29 Apr, 2009 20:56 Re: Help On Adaptation ----------------------------------- [quote user="Yros" post="38916"]First of all, THANK YOU a lot because that's it : everything is ok now ^^ ! Now there's just 2 things I would like to know : 1) how this only one table could bug like that ? ( I mean only that description ) ( And how you found it was from there ? ^^' ) 2) I've, in every posts, some code I would like to cut off : in every bbcodes, there's some " uid " like [b:########] and I would like to know how to cut off this uid of every posts in same time. I know there is something for it in " install.php " but when I use it it tell me " error in editing posts " ='( So how remove this uid to make every bbcodes ok ? =/ But really thanks again for your help =D[/quote] 1. belive me it maded me a headtouch :mrblue: 2. open phpbb_posts.sql in notepad go to replace in input find what put [b:########] in replace leave it blank click replace all save it and add it in database also change now pass for Yros i dont want to know it :wink: btw i m glad that i helped you with forum tables :wink: ----------------------------------- Yros Thu 30 Apr, 2009 08:48 Re: Help On Adaptation ----------------------------------- I found another problem : I can't CREATE a topic =/ To reply there's no probs but when I start a topic, the topic is paste to another one existant =/ I think I really need to FIX my POSTS. Take a look to the Install path of IP : run install.php in an installed forum and you will come to IP tools. One of these is " Fix Posts " :[quote]This feature will allow you to fix all posts in your forums. You can use this feature to: find and replace any text in your posts, remove all BBCode UID, automatically adjust the address of posted images.[/quote] That's exactly what I need BUT it seems to bug =/ It tell me " Error in editing posts ... " Then I tried the same thing with " Fix Signatures " ( signs bug also with BBcode uid ) and It bugged with some signs and I think it bugged only with empty signs =/ Maybe it can help you to help me ^^' ----------------------------------- Limun Thu 30 Apr, 2009 10:54 Re: Help On Adaptation ----------------------------------- [quote user="Yros" post="38927"]I found another problem : I can't CREATE a topic =/ To reply there's no probs but when I start a topic, the topic is paste to another one existant =/ I think I really need to FIX my POSTS. Take a look to the Install path of IP : run install.php in an installed forum and you will come to IP tools. One of these is " Fix Posts " :[quote]This feature will allow you to fix all posts in your forums. You can use this feature to: find and replace any text in your posts, remove all BBCode UID, automatically adjust the address of posted images.[/quote] That's exactly what I need BUT it seems to bug =/ It tell me " Error in editing posts ... " Then I tried the same thing with " Fix Signatures " ( signs bug also with BBcode uid ) and It bugged with some signs and I think it bugged only with empty signs =/ Maybe it can help you to help me ^^'[/quote] can you send me final database..with posts inside i have that old ----------------------------------- Yros Thu 30 Apr, 2009 23:20 Re: Help On Adaptation ----------------------------------- Well everything is FINALY ok =) I would thanks a lot Limun and Informpro for their great help all along my troubles ^.^ Really thanks =)