|
Page 1 of 3
|
batman 
Karl
Joined: February 2011
Posts: 162
Location:  Cornwall UK
|
 Some Errors After Upgrade?
Hya fellas I managed to downgrade my other integra site and then upgraded it to IP.
Had a fiew initial problems with these below for some reason they didn't get inserted?
So have inserted them from my DB backup
These are the ones that didn't get inserted, as you can see the file names had gotten changed somewhere in the process so couldn't insert
_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,729 MyISAM latin1_swedish_ci 18.2 MiB -
_old_phpbb_posts_text 176,728 MyISAM latin1_swedish_ci 96.5 MiB -
_old_phpbb_privmsgs 33,811 MyISAM latin1_swedish_ci 3.1 MiB -
_old_phpbb_privmsgs_text 33,811 MyISAM latin1_swedish_ci 7.8 MiB -
Below is an error I'm getting, I'm also now using the latest ip_20110224_13053b, would it be best to start the upgrade from the beginning or try to sort these errors?
Couldn't access list of unread posts from forums
DEBUG MODE
SQL Error : 1054 Unknown column 't.title_compl_infos' in 'field list'
SELECT p.forum_id, p.topic_id, p.post_time, p.post_username, u.username, u.user_id, u.user_active, u.user_color, t.topic_poster, t.topic_last_post_id, t.topic_title, t.title_compl_infos FROM ((phpbb_posts p LEFT JOIN phpbb_topics t ON t.topic_id = p.topic_id AND t.forum_id = p.forum_id AND t.topic_moved_id = 0) LEFT JOIN phpbb_users u ON u.user_id = p.poster_id) WHERE (p.post_time > 1298700797 OR p.post_id IN (214806, 214910, 90190, 215322, 215335, 215334, 214970, 215064, 213787, 215148, 215114, 208918, 150591, 144366, 152579, 214627, 215303, 214615, 215091, 208462, 212351, 215157, 214018, 215090, 214640, 199369, 212735, 215299, 113171, 72744, 85963, 194340, 189708, 213402, 109088, 85151, 101741, 75157, 117031, 141286, 166935, 214668, 211341, 159186, 212774, 214663, 212930, 161082, 214333, 215041, 203483, 102439, 215252, 184918, 116584, 121869, 126718, 129163, 129120, 131762, 127537, 130005, 119460, 127386, 125650, 127566, 123167, 125490, 116970, 126717, 127299, 129133, 119203, 214016, 215321, 215337, 214936, 214886, 215165, 11731, 212329, 105024, 140095, 169402, 104874, 118468, 212362, 152640, 196077, 215253, 206214, 215050, 213706, 149864, 160587, 154118, 156337, 164900, 167654, 197713, 182923, 167715, 166017, 152853, 167636, 167408, 166677, 151307, 154410, 212315, 214650, 214400, 214607, 201573, 214679, 166293, 167628, 163663, 168872, 214865, 182549, 177610, 215244, 214558, 208479, 193887, 187171, 194142, 188336, 183514, 192578, 194262, 187180, 192340, 184461, 188122, 188096, 184878, 190342, 192153, 193729, 215009, 214900, 191841, 197478, 190788, 195305, 191092, 194003, 215174, 193011, 192861, 215092, 215329, 215258, 215316, 211995, 213467, 210797, 208359, 208042, 207998, 213729, 214732, 205836, 211232, 215331, 211819, 214933, 211383, 211242, 215330, 212973)) AND p.post_id = t.topic_last_post_id
Line : 575
File : functions_categories_hierarchy.php
|
#1 Sat 26 Feb, 2011 09:28 |
|
Sponsors

|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
|
mort 
 Spam Basher

Joined: August 2010
Posts: 998
Location:  Up a tree
|
 Re: Some Errors After Upgrade?
Did you per chance:
Log in as Admin
Lock your forum
Install you modified Db with phpMyAdmin
Go to /install/database_update.php
Rename /install/ to /_install/
Go to /_install/install.php
And follow the prompts?
|
#2 Sat 26 Feb, 2011 10:06 |
|
batman 
Karl
Joined: February 2011
Posts: 162
Location:  Cornwall UK
|
 Re: Some Errors After Upgrade?
I did Mort  but didn't go _install/install.php were does it say to do that mate?
I followed this, with one exception when I did that it just kept redirecting to install even though I had renamed install to installdone, then I had to reopen the install so I could run those links it gives, that's probably whats messed it up?
Ill try another day, got all the backups and now reinstated the integra until I get another chance to have a play.
How To Upgrade From phpBB 2
Readme[/quote]
|
#3 Sat 26 Feb, 2011 10:46 |
|
spydie 
Joined: December 2008
Posts: 1796
Location:  In the Boxes
|
 Re: Some Errors After Upgrade?
have a look at config.php
if it say´s
define('IP_INSTALLED', true);
____________ Out of Order
|
#4 Sat 26 Feb, 2011 12:14 |
|
mort 
 Spam Basher

Joined: August 2010
Posts: 998
Location:  Up a tree
|
 Re: Some Errors After Upgrade?
I did Mort  but didn't go _install/install.php were does it say to do that mate?
Description: |
|
Filesize: |
170.62 KB |
Viewed: |
293 Time(s) |

|
|
#5 Sat 26 Feb, 2011 18:10 |
|
batman 
Karl
Joined: February 2011
Posts: 162
Location:  Cornwall UK
|
 Re: Some Errors After Upgrade?
Hya mort, I followed what MG posted on the upgrade thread I posted.
Agreed though best to read everything
|
#6 Sat 26 Feb, 2011 18:47 |
|
spydie 
Joined: December 2008
Posts: 1796
Location:  In the Boxes
|
 Re: Some Errors After Upgrade?
_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,729 MyISAM latin1_swedish_ci 18.2 MiB -
_old_phpbb_posts_text 176,728 MyISAM latin1_swedish_ci 96.5 MiB -
_old_phpbb_privmsgs 33,811 MyISAM latin1_swedish_ci 3.1 MiB -
_old_phpbb_privmsgs_text 33,811 MyISAM latin1_swedish_ci 7.8 MiB -
this is old data. the new data ( posts and posts_text get merged to posts, privmsgs and privmsgs_text merged in privmsgs) should be in phpbb_posts, phpbb_categories and phpbb_privmsgs .
you should try to do quicksettings after update.
____________ Out of Order
|
#7 Sat 26 Feb, 2011 19:01 |
|
batman 
Karl
Joined: February 2011
Posts: 162
Location:  Cornwall UK
|
 Re: Some Errors After Upgrade?
If your used to doing these kinds of tasks or being a coder may help then most things are probably self explanatory.
Most people using IP just want to run a website and are not coders or used to doing all the tech stuff.
I'm fortunate that I have a reasonable basic understanding of how some of it works, but am struggling with a lot of it, maybe its the way its worded/explained? I think this will put the majority of site owners off from using IP
Don't get me wrong, once IP is up and running and set out the way you like it (installed from a fresh install and a new site with nothing to import to it), it is an awesome platform to use, I love it, but many wont get that far especially if they already have a site they want to convert over to IP.
I think the problem is this below needs to be more detailed in exactly what you need to do as this is what I followed.
How To Upgrade From phpBB 2
Readme
Last edited by batman on Sat 26 Feb, 2011 20:15; edited 1 time in total |
#8 Sat 26 Feb, 2011 19:38 |
|
spydie 
Joined: December 2008
Posts: 1796
Location:  In the Boxes
|
 Re: Some Errors After Upgrade?
number 10 means all files in root folder(main folder) but not the folders nor config.php
and folder pafield_db disapeared in .53 , it´s in downloads now i think
____________ Out of Order
|
#9 Sat 26 Feb, 2011 19:41 |
|
batman 
Karl
Joined: February 2011
Posts: 162
Location:  Cornwall UK
|
 Re: Some Errors After Upgrade?
Hya spydie, any ideas were the install and upgrade documents are located, I have checked in documentation but not in there.
The link should be included in the install files for reference?
|
#10 Sat 26 Feb, 2011 20:36 |
|
mort 
 Spam Basher

Joined: August 2010
Posts: 998
Location:  Up a tree
|
 Re: Some Errors After Upgrade?
Hya mort, I followed what MG posted on the upgrade thread I posted.
Agreed though best to read everything 
I owe you an apology.
I had read those docs and from memory I believed that the same rules applied for all because simply altering the "old" database with the upgrade file doesn't appear to finish it off properly when a few other things also need to be done.
But the upgrade from phpBB2 doesn't say that when those extra options should be applied to finish the whole thing off.
Quote: Hya spydie, any ideas were the install and upgrade documents are located
They are released with the download of Icy Phoenix. - They're in the IP .zip folder you downloaded from here in the sub-folder /docs/*.*
Only if you wish- Zip up a copy of your ORIGINAL Inegra mod database and make it available for me to have a look at. I don't need passwords or admin name etc, just the Dump.
From my point of view, this should have taken less than a couple of hours at the most - not a week....
|
#11 Sat 26 Feb, 2011 21:11 |
|
spydie 
Joined: December 2008
Posts: 1796
Location:  In the Boxes
|
 Re: Some Errors After Upgrade?
if everything runs fine, it should take 30 minutes max ( depending on DB size).
the template edits, come afterwards.
____________ Out of Order
|
#12 Sat 26 Feb, 2011 21:46 |
|
batman 
Karl
Joined: February 2011
Posts: 162
Location:  Cornwall UK
|
 Re: Some Errors After Upgrade?
yeh it didn't take long at all to do, its just when I followed all the steps on the guide that MG posted, it says that's all you have to do but all was getting was this page.
The only way I could make the site work was rename install so it would open again as I had renamed it installdone, then run a couple of the links it provides in the pick below, think I did posts and something ells possibly related to functions?, o yes also rename the image paths etc or whatever it says its going to do.
I assumed these were what needed to be changed manually as mentioned last step in the upgrade guide?
|
#13 Sat 26 Feb, 2011 23:30 |
|
spydie 
Joined: December 2008
Posts: 1796
Location:  In the Boxes
|
 Re: Some Errors After Upgrade?
run the constants thing in install, afterwards go to the ACP and do the quicksettings
____________ Out of Order
|
#14 Sun 27 Feb, 2011 00:09 |
|
batman 
Karl
Joined: February 2011
Posts: 162
Location:  Cornwall UK
|
 Re: Some Errors After Upgrade?
I will give that a go, thanks
Mort ill see how I go with a second go and if it still plays up ill send you the DB mate, cheers
EDIT:
Just reading the upgrade procedures again, I would say the only part that needs more details on exactly what you need to do is
13.Customize what needs to be customized in files and db (some files needs to be edited manually, while most of the options may be set in ACP and CMS).
That section should explain exactly what should/may require editing and just as important (what not to do) when on the install page I posted, Im just guessing but I think me running some of those procedures were what set some of my files to old so intern were not inserted in to the database.
The last thing you should have to do with step by step procedures is to have to assume how to do something.
EDIT AGAIN:
It appears that when I'm doing a full export of my integra DB its not exporting everything as some categories are missing when I insert what I have in the basic phpbb2, either that or phpbb2 isn't inserting the data?
The integra categories from original site
PHPBB2 after inserting categories, topics, forums users post text etc. etc. but some categories are missing
Think ill start right from the beginning with a new install of the pfpbb2 rather than from the backup files of it and then drop and reinsert the same files from integra, see if there is any difference
EDIT 3:
Just got the IP running and will see how it goes
|
#15 Sun 27 Feb, 2011 00:14 |
|
|
Page 1 of 3
|
Was this topic useful?
Was this topic useful?
Link this topic |
URL |
|
BBCode |
|
HTML |
|
You cannot post new topics You cannot reply to topics You cannot edit your posts You cannot delete your posts You cannot vote in polls You cannot attach files You can download files You cannot post calendar events
|
|
|
|