Icy Phoenix :: View topic - Some Errors After Upgrade?

mort [ Sun 27 Feb, 2011 05:20 ]
Post subject: Re: Some Errors After Upgrade?

batman wrote: [View Post]

EDIT 3:

Just got the IP running and will see how it goes

So what was different this time. :?: :mryellow:

batman [ Sun 27 Feb, 2011 06:09 ]
Post subject: Re: Some Errors After Upgrade?

mort wrote: [View Post]
batman wrote: [View Post]

EDIT 3:

Just got the IP running and will see how it goes

So what was different this time. :?: :mryellow:

Hya mate nothing still no phpbb_posts_text
When you do the innitial db update as in the install folder, for some reason its renaming some tables i.e.

Code: [Hide] [Select]

_old_phpbb_categories        8 MyISAM latin1_swedish_ci 3.5 KiB - 

 _old_phpbb_forums        228 MyISAM latin1_swedish_ci 42.7 KiB - 

 _old_phpbb_posts        176,797 MyISAM latin1_swedish_ci 18.2 MiB - 

 _old_phpbb_posts_text        176,796 MyISAM latin1_swedish_ci 96.6 MiB - 

 _old_phpbb_privmsgs        33,726 MyISAM latin1_swedish_ci 3.1 MiB - 

 _old_phpbb_privmsgs_text        33,726 MyISAM latin1_swedish_ci 7.8 MiB -

For some strange reason though its not creating a new phpbb_posts_text so obviously no text is inserted.
I just cant way it up as all the text was in place on the phpbb2 board so should still be in place? but isn't :( Do you think if I rename _old_phpbb_posts_text >>> phpbb_posts_text that would work, or even export it rename then insert? but to be honest I reckon I'm going to get the errors like post#1 of this thread :?
Just noticed there is no phpbb_privmsgs_text either :roll:

This is the test board upgraded http://www.british-birds-in-avicult...stest/index.php
Table structure below

Spoiler: [ Show ]

mort [ Sun 27 Feb, 2011 07:07 ]
Post subject: Re: Some Errors After Upgrade?

batman wrote: [View Post]

When you do the innitial db update as in the install folder, for some reason its renaming some tables i.e. _old_phpbb_categories

It's supposed to do that - cache the old - write the new - rename the original to old.

Did you run through the _/install/install.php bit, and if so, I'm not sure what's going on now. :(

Send me a dump, that may be the easiest way. :P

batman [ Sun 27 Feb, 2011 08:21 ]
Post subject: Re: Some Errors After Upgrade?

Hya Mort, yes I ran the _/install/install.php and did most of the procedures except the posts and signatures as I wasn't sure what to do with those 2.

I have included a link for the SQL file, its quite large 30MB and is the full db for the upgraded IP

Let me know when you have it then I can remove the link 8)
Much appreciate this mate

spydie [ Sun 27 Feb, 2011 09:06 ]
Post subject: Re: Some Errors After Upgrade?

Batman

posts_text and posts are soposed to be merged in one posts table.

same should happen with pivmsgs and privmsgs_text

The update is sopposed to merge these tables

batman [ Sun 27 Feb, 2011 09:42 ]
Post subject: Re: Some Errors After Upgrade?

Hya spydie, that would explain why its not inserted the tables, but at a loss to why its not inserted any text.
Do you know the procedure to merge them manually?

EDIT:
Just checked and the pm text is in there, so just the post text not inserted :roll:

spydie [ Sun 27 Feb, 2011 11:02 ]
Post subject: Re: Some Errors After Upgrade?

are you trying to move directly from phpBB2 to 1.3.0.53a??

try doing the conversion phpbb2 - 1.2.0.27c - 1.3.0.53a

i had similar problems converting an phpbb2 site of a client

batman [ Sun 27 Feb, 2011 11:38 ]
Post subject: Re: Some Errors After Upgrade?

I have a plan but not sure how to do it :mrgreen: I have exported the _old_phpbb_posts table and imported it to another database.
The plan is to rename to phpbb_posts then export as an update or replace as it has all the post text within it.
Trouble is I'm not sure how to rename it, any ideas?

EDIT:
Well I'm halfway there, I managed to rename the table and then inserted it, I have all the posts now but the posts don't have any text in them :rotfl_01:

Does anybody know how I can merge these tables?
phpbb_posts
phpbb_posts_text

mort [ Sun 27 Feb, 2011 12:47 ]
Post subject: Re: Some Errors After Upgrade?

batman wrote: [View Post]
I have included a link for the SQL file, its quite large 30MB and is the full db for the upgraded IP

30mb is a "small" file with the speed I use and what I'm connected to. ;)

Mate - NEVER make your db available in public - Even part time Hackers will love you for it. :shock:

And while I typed this - your download is finished - So you can remove it. :P

It's also 10-30pm here - So it looks like a morning job after I see what your latest development is. :mryellow:

batman [ Sun 27 Feb, 2011 23:06 ]
Post subject: Re: Some Errors After Upgrade?

spydie wrote: [View Post]
are you trying to move directly from phpBB2 to 1.3.0.53a??

try doing the conversion phpbb2 - 1.2.0.27c - 1.3.0.53a

i had similar problems converting an phpbb2 site of a client

Hya spydie, were can I get a copy of 1.2.0.27c in the downloads it just redirects to latest :?

spydie [ Mon 28 Feb, 2011 00:24 ]
Post subject: Re: Some Errors After Upgrade?

http://www.icyphoenix.es/icy-phoenix-1-2-0-27c-df131.html

comes in spanish and default english

batman [ Mon 28 Feb, 2011 00:40 ]
Post subject: Re: Some Errors After Upgrade?

Thanks spydie, Im going to give this a try :roll:

mort [ Mon 28 Feb, 2011 02:51 ]
Post subject: Re: Some Errors After Upgrade?

batman wrote: [View Post]
Thanks spydie, Im going to give this a try :roll:

I doubt that it is going to be that simple because inserts have been either dropped, added or moved. :(

But,

This should give you some idea as to where to start cleaning up the "old" tables.

ALTER TABLE `_old_phpbb_posts_text` DROP `bbcode_uid`;

And ONLY upload the INSERT values to your test forum - AFTER you have dropped any inserts that may currently be there.

There will or may be other things that need to be done. But I did ask for an ORIGINAL COPY of your Integra Mod DB and not something that you have been playing with and changing.

For me to do it it will cost you some dollars, so I wish you the best of luck. :mryellow:

batman [ Mon 28 Feb, 2011 03:30 ]
Post subject: Re: Some Errors After Upgrade?

I have 2 version installed on different test sites now lol
The one upgraded to the latest IP phpBB2 >> 1.3.0.53a were I'm having trouble inserting the text.

The second is phpbb2 >> 1.2.0.27c all looks good other than the error below, Id say I need to drop a few bits? but the posts are there just cant access them due to the error.

Spoiler: [ Show ]

Mort I can send the original no problem, Ive been in and out of so many things I thought that was the original I sent, but just checked and is in fact the DB for the upgraded phpBB2 >> 1.3.0.53a.

I may be interested in paying to have this sorted but depends on price mate as this is a free site I run, pm me a price and we can go from there.
I don't mind doing the hard work or putting the time in its just a case of knowing exactly what I need to do, I'm on my 3rd sleepless night now trying to sort this :roll: :)

EDIT:
Just remembered on integra there is a little feature called drop all user signatures within the general configuration, I'm going to try see if that sorts anything :roll:

spydie [ Mon 28 Feb, 2011 09:13 ]
Post subject: Re: Some Errors After Upgrade?

batman wrote: [View Post]

Just remembered on integra there is a little feature called drop all user signatures within the general configuration, I'm going to try see if that sorts anything :roll:

That will change some thing´s probably

give it a try.

does´nt matter, if users have to put their sig´s in again

mort [ Mon 28 Feb, 2011 10:43 ]
Post subject: Re: Some Errors After Upgrade?

batman wrote: [View Post]
I may be interested in paying to have this sorted but depends on price mate as this is a free site I run, pm me a price and we can go from there.

It may be a free site, but there's no such thing as a free hobby! :mryellow:

As for paying - Take that up with MG, as I've decided that Icy Phoenix is too heavy for what I'm doing, or going to do (Where the forum is an ADD-On rather than the main attraction) - So I'll give it a miss. ;)

But it has been some kind of an experience that I'll remember - - :P

Just some friendly advice.

Your first question here should have been something like "I want to migrate from Integra Mod to Icy Phoenix, has anyone ever done this here, and if not how should I go about it?" instead of telling people what you have done that doesn't work and asking how one should go about fixing it?

Free help - not only has time constraints on those supplying it, it also has its limits of patience.

Sometimes, it's better to pay someone to do it for you. :|

batman [ Mon 28 Feb, 2011 13:50 ]
Post subject: Re: Some Errors After Upgrade?

Mort you have totally lost me, I did ask about initially converting and was advised to do it from a phpbb2 setup, so I downgraded the integra to a phpbb2

Titled "Converting From Other Portal System To Icy?"
http://www.icyphoenix.com/viewtopic.php?f=2&t=7658

As you may know most PHPBB2 portals are pretty standard with a few mods so the upgrade from integra would have been pretty straight forward as the structure is the same, icy is different as its heavily edited as well as a few mods, this is why Ive had some problems.
All Ive done is tried to be honest with what I have done and the results.
I'm new to IP so going to have some teething problems.

The point is though I don't claim to be a know it all, the only way to learn is by asking and reading and more importantly if you have a basic idea then have a go yourself, its the only way to learn.
You offered to look at the db, yes my fault I sent the wrong one and then DID say I would pay but stated the fact it is a free site I run and just being realistic.

IP is a lot different to what I'm used to using so bound to get some teething problems
I wish "I" lived in a perfect world :roll:
Lets not forget this is in the support section, so people are going to have basic support questions.

spydie [ Wed 18 May, 2011 13:33 ]
Post subject: Re: Some Errors After Upgrade?

This is an old Topic,

and already Fixed

mort [ Wed 18 May, 2011 13:47 ]
Post subject: Re: Some Errors After Upgrade?

spydie wrote: [View Post]
This is an old Topic,

and already Fixed

And chenyixiu is a SPAMMER! Check out the links it's posted? :censored:

Joshua203 [ Wed 18 May, 2011 15:13 ]
Post subject: Re: Some Errors After Upgrade?

Spammer posts removed and banned.. thanks for reporting :wink:

Icy Phoenix

Old Support Topics - Some Errors After Upgrade?