https://www.icyphoenix.com/viewtopic.php?f=35&t=7678
-----------------------------------
batman
Sat 26 Feb, 2011 09:28

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 :shock: 

[code linenumbers=false]_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 - [/code]


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?


[code linenumbers=false]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[/code]


-----------------------------------
mort
Sat 26 Feb, 2011 10:06

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?


-----------------------------------
batman
Sat 26 Feb, 2011 10:46

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. :(  


[size=12][color=#bbaa55][b]How To Upgrade From phpBB 2[/b][/color][/size]
[url=docs/readme_english.html#upgrade_phpbb]Readme[/quote]


-----------------------------------
spydie
Sat 26 Feb, 2011 12:14

Re: Some Errors After Upgrade?
-----------------------------------
have a look at config.php

if it say´s 

define('IP_INSTALLED', true);


-----------------------------------
mort
Sat 26 Feb, 2011 18:10

Re: Some Errors After Upgrade?
-----------------------------------
[quote user="batman" post="51810"]I did Mort :? but didn't go _install/install.php were does it say to do that mate?[/quote]


-----------------------------------
batman
Sat 26 Feb, 2011 18:47

Re: Some Errors After Upgrade?
-----------------------------------
Hya mort, I followed what MG posted on the upgrade thread I posted.
Agreed though best to read everything  :mrgreen:


-----------------------------------
spydie
Sat 26 Feb, 2011 19:01

Re: Some Errors After Upgrade?
-----------------------------------
[spoiler]_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 -[/spoiler]

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.


-----------------------------------
batman
Sat 26 Feb, 2011 19:38

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.

[spoiler][size=12][color=#bbaa55][b]How To Upgrade From phpBB 2[/b][/color][/size]
[url=docs/readme_english.html#upgrade_phpbb]Readme[/spoiler]


-----------------------------------
spydie
Sat 26 Feb, 2011 19:41

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


-----------------------------------
batman
Sat 26 Feb, 2011 20:36

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?


-----------------------------------
mort
Sat 26 Feb, 2011 21:11

Re: Some Errors After Upgrade?
-----------------------------------
[quote user="batman" post="51816"]Hya mort, I followed what MG posted on the upgrade thread I posted.
Agreed though best to read everything  :mrgreen:[/quote]

I owe you an apology.  :oops: 

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[/quote]

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/*.*

[b][i]Only if you wish[/i][/b]- Zip up a copy of your [b][u]ORIGINAL[/u][/b] 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....  :mryellow:


-----------------------------------
spydie
Sat 26 Feb, 2011 21:46

Re: Some Errors After Upgrade?
-----------------------------------
if everything runs fine, it should take 30 minutes max ( depending on DB size).

the template edits, come afterwards.


-----------------------------------
batman
Sat 26 Feb, 2011 23:30

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? 

  [img]http://www.icyphoenix.com/files/images/9166/26_02_2011_03_55_41_1298759025_186868.png[/img]


-----------------------------------
spydie
Sun 27 Feb, 2011 00:09

Re: Some Errors After Upgrade?
-----------------------------------
run the constants thing in install, afterwards go to the ACP and do the quicksettings


-----------------------------------
batman
Sun 27 Feb, 2011 00:14

Re: Some Errors After Upgrade?
-----------------------------------
I will give that a go, thanks  8) 

Mort ill see how I go with a second go and if it still plays up ill send you the DB mate, cheers  8)

[b]EDIT:[/b]

Just reading the upgrade procedures again, I would say the only part that needs more details on exactly what you need to do is 

[code linenumbers=false]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).[/code]

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.

[b]EDIT AGAIN:[/b]

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?  :? 

[b]The integra categories from original site[/b]

 [img]http://www.icyphoenix.com/files/images/9166/27_02_2011_00_16_22.png[/img] 

[b]PHPBB2 after inserting categories, topics, forums users post text etc. etc. but some categories are missing [/b]

 [img]http://www.icyphoenix.com/files/images/9166/27_02_2011_00_18_12.png[/img] 
 [img]http://www.icyphoenix.com/files/images/9166/27_02_2011_00_18_52.png[/img] 
 [img]http://www.icyphoenix.com/files/images/9166/27_02_2011_00_19_59.png[/img] 

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




[b]EDIT 3:[/b]

Just got the IP running and will see how it goes


-----------------------------------
mort
Sun 27 Feb, 2011 05:20

Re: Some Errors After Upgrade?
-----------------------------------
[quote user="batman" post="51825"]
[b]EDIT 3:[/b]

Just got the IP running and will see how it goes[/quote]

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


-----------------------------------
batman
Sun 27 Feb, 2011 06:09

Re: Some Errors After Upgrade?
-----------------------------------
[quote user="mort" post="51827"][quote user="batman" post="51825"]
[b]EDIT 3:[/b]

Just got the IP running and will see how it goes[/quote]

So what was different this time. :?:  :mryellow:[/quote]

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 linenumbers=false]_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 - [/code]

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-aviculture.info/bbia-forumstest/index.php
[b]Table structure below[/b]

[spoiler]Table   Action  Records 1  Type  Collation  Size  Overhead  
 phpbb_acronyms        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_adminedit        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_ads        2 MyISAM latin1_swedish_ci 2.6 KiB - 
 phpbb_ajax_shoutbox        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_ajax_shoutbox_sessions        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_album        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_album_cat        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_album_comment        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_album_comment_watch        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_album_config        118 MyISAM latin1_swedish_ci 9.9 KiB - 
 phpbb_album_rate        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_attachments        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_attachments_config        34 MyISAM latin1_swedish_ci 3.8 KiB - 
 phpbb_attachments_desc        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_attachments_stats        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_attach_quota        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_auth_access        2,443 MyISAM latin1_swedish_ci 111.8 KiB - 
 phpbb_autolinks        1 MyISAM latin1_swedish_ci 2.1 KiB - 
 phpbb_banlist        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_bookmarks        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_bots        90 MyISAM latin1_swedish_ci 9.8 KiB - 
 phpbb_captcha_config        17 MyISAM latin1_swedish_ci 3.4 KiB - 
 phpbb_cash        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_cash_events        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_cash_exchange        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_cash_groups        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_cash_log        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_categories        8 MyISAM latin1_swedish_ci 3.5 KiB - 
 phpbb_cms_blocks        14 MyISAM latin1_swedish_ci 3.3 KiB 52 B  
 phpbb_cms_block_position        25 MyISAM latin1_swedish_ci 2.5 KiB - 
 phpbb_cms_block_variable        22 MyISAM latin1_swedish_ci 4.1 KiB - 
 phpbb_cms_config        21 MyISAM latin1_swedish_ci 2.7 KiB - 
 phpbb_cms_layout        2 MyISAM latin1_swedish_ci 2.1 KiB - 
 phpbb_cms_layout_special        24 MyISAM latin1_swedish_ci 5.0 KiB - 
 phpbb_cms_nav_menu        30 MyISAM latin1_swedish_ci 4.8 KiB - 
 phpbb_config        412 MyISAM latin1_swedish_ci 28.4 KiB 20 B  
 phpbb_confirm        11 MyISAM latin1_swedish_ci 2.8 KiB - 
 phpbb_ctracker_backup        413 MyISAM latin1_swedish_ci 28.2 KiB - 
 phpbb_ctracker_config        42 MyISAM latin1_swedish_ci 4.0 KiB - 
 phpbb_ctracker_filechk        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_ctracker_filescanner        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_ctracker_ipblocker        32 MyISAM latin1_swedish_ci 2.7 KiB - 
 phpbb_ctracker_loginhistory        1 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_digest_subscribed_forums        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_digest_subscriptions        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_disallow        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_dl_auth        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_dl_banlist        1 MyISAM latin1_swedish_ci 2.0 KiB - 
 phpbb_dl_bug_history        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_dl_bug_tracker        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_dl_comments        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_dl_config        52 MyISAM latin1_swedish_ci 4.2 KiB - 
 phpbb_dl_ext_blacklist        15 MyISAM latin1_swedish_ci 1.3 KiB - 
 phpbb_dl_favorites        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_dl_hotlink        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_dl_notraf        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_dl_ratings        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_dl_stats        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_downloads        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_downloads_cat        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_drafts        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_extensions        26 MyISAM latin1_swedish_ci 2.5 KiB 40 B  
 phpbb_extension_groups        7 MyISAM latin1_swedish_ci 2.2 KiB - 
 phpbb_flags        241 MyISAM latin1_swedish_ci 12.1 KiB - 
 phpbb_forbidden_extensions        7 MyISAM latin1_swedish_ci 2.1 KiB - 
 phpbb_force_read        1 MyISAM latin1_swedish_ci 1.1 KiB - 
 phpbb_force_read_users        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_forums        228 MyISAM latin1_swedish_ci 41.0 KiB - 
 phpbb_forums_rules        228 MyISAM latin1_swedish_ci 8.5 KiB - 
 phpbb_forums_watch        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_google_bot_detector        1 MyISAM latin1_swedish_ci 2.1 KiB - 
 phpbb_groups        1,473 MyISAM latin1_swedish_ci 120.8 KiB - 
 phpbb_hacks_list        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_jr_admin_users        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_kb_articles        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_kb_categories        1 MyISAM latin1_swedish_ci 2.1 KiB - 
 phpbb_kb_config        26 MyISAM latin1_swedish_ci 3.6 KiB - 
 phpbb_kb_custom        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_kb_customdata        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_kb_results        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_kb_search        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_kb_types        1 MyISAM latin1_swedish_ci 2.0 KiB - 
 phpbb_kb_votes        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_kb_wordlist        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_kb_wordmatch        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_links        6 MyISAM latin1_swedish_ci 2.7 KiB - 
 phpbb_link_categories        8 MyISAM latin1_swedish_ci 3.2 KiB - 
 phpbb_link_config        12 MyISAM latin1_swedish_ci 1.3 KiB - 
 phpbb_liw_cache        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_logins        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_logs        16 MyISAM latin1_swedish_ci 3.3 KiB - 
 phpbb_megamail        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_news        1 MyISAM latin1_swedish_ci 2.0 KiB - 
 phpbb_notes        1 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_pa_auth        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_pa_cat        2 MyISAM latin1_swedish_ci 2.1 KiB - 
 phpbb_pa_comments        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_pa_config        32 MyISAM latin1_swedish_ci 3.9 KiB - 
 phpbb_pa_custom        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_pa_customdata        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_pa_download_info        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_pa_files        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_pa_license        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_pa_mirrors        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_pa_votes        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_posts        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_privmsgs        33,724 MyISAM latin1_swedish_ci 9.5 MiB 340 B  
 phpbb_privmsgs_archive        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_profile_fields        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_profile_view        1 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_quota_limits        3 MyISAM latin1_swedish_ci 2.1 KiB - 
 phpbb_ranks        18 MyISAM latin1_swedish_ci 2.8 KiB - 
 phpbb_rate_results        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_referrers        1 MyISAM latin1_swedish_ci 2.1 KiB - 
 phpbb_registration        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_registration_desc        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_search_results        1 MyISAM latin1_swedish_ci 3.3 KiB - 
 phpbb_search_wordlist        12 MyISAM latin1_swedish_ci 3.2 KiB - 
 phpbb_search_wordmatch        13 MyISAM latin1_swedish_ci 3.1 KiB - 
 phpbb_sessions        3 MyISAM latin1_swedish_ci 4.6 KiB 64 B  
 phpbb_sessions_keys        19,073 MyISAM latin1_swedish_ci 2.3 MiB - 
 phpbb_shout        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_site_history        2 MyISAM latin1_swedish_ci 2.0 KiB - 
 phpbb_smilies        42 MyISAM latin1_swedish_ci 3.5 KiB - 
 phpbb_stats_config        5 MyISAM latin1_swedish_ci 2.1 KiB - 
 phpbb_stats_modules        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_sudoku_sessions        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_sudoku_solutions        20 MyISAM latin1_swedish_ci 5.4 KiB - 
 phpbb_sudoku_starts        20 MyISAM latin1_swedish_ci 5.5 KiB - 
 phpbb_sudoku_stats        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_sudoku_users        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_thanks        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_themes        2 MyISAM latin1_swedish_ci 2.2 KiB - 
 phpbb_tickets_cat        2 MyISAM latin1_swedish_ci 2.0 KiB - 
 phpbb_title_infos        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_topics        16,472 MyISAM latin1_swedish_ci 3.1 MiB - 
 phpbb_topics_watch        18,662 MyISAM latin1_swedish_ci 748.8 KiB - 
 phpbb_topic_view        303,732 MyISAM latin1_swedish_ci 4.3 MiB - 
 phpbb_upi2db_always_read        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_upi2db_last_posts        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_upi2db_unread_posts        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_users        1,463 MyISAM latin1_swedish_ci 2.0 MiB 52 B  
 phpbb_user_group        3,040 MyISAM latin1_swedish_ci 121.5 KiB - 
 phpbb_vote_desc        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_vote_results        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_vote_voters        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_words        20 MyISAM latin1_swedish_ci 6.0 KiB - 
 phpbb_xs_news        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 phpbb_xs_news_cfg        5 MyISAM latin1_swedish_ci 3.1 KiB - 
 phpbb_xs_news_xml        3 MyISAM latin1_swedish_ci 2.3 KiB - 
 phpbb_zebra        0 MyISAM latin1_swedish_ci 1.0 KiB - 
 _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 - 
 157 table(s)  Sum 823,768 MyISAM latin1_swedish_ci 148.3 MiB 568 B [/spoiler]


-----------------------------------
mort
Sun 27 Feb, 2011 07:07

Re: Some Errors After Upgrade?
-----------------------------------
[quote user="batman" post="51828"]
When you do the innitial db update as in the install folder, for some reason its renaming some tables i.e. _old_phpbb_categories [/quote]

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

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

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

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?

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


-----------------------------------
spydie
Sun 27 Feb, 2011 11:02

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

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?

[b]EDIT:[/b]
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

Re: Some Errors After Upgrade?
-----------------------------------
[quote user="batman" post="51830"]I have included a link for the SQL file, its quite large 30MB and is the full db for the upgraded IP[/quote]

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

Re: Some Errors After Upgrade?
-----------------------------------
[quote user="spydie" post="51833"]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[/quote]

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

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

Re: Some Errors After Upgrade?
-----------------------------------
Thanks spydie, Im going to give this a try :roll:


-----------------------------------
mort
Mon 28 Feb, 2011 02:51

Re: Some Errors After Upgrade?
-----------------------------------
[quote user="batman" post="51845"]Thanks spydie, Im going to give this a try :roll:[/quote]

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 [b][u]ORIGINAL COPY[/u][/b] 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

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]Could not obtain post/user information.

DEBUG MODE

SQL Error : 1054 Unknown column 'u.user_sig_bbcode_uid' in 'field list'

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_from_flag, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_skype, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_rank2, u.user_rank3, u.user_rank4, u.user_rank5, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_allow_viewonline, u.user_session_time, u.user_warnings, u.user_level, u.user_birthday, u.user_next_birthday_greeting, u.user_gender, u.user_personal_pics_count, u.user_style, u.user_lang, u.ct_miserable_user, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, pt.edit_notes, t.topic_poster, t.title_compl_infos FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt, phpbb_topics t WHERE p.topic_id = 4890 AND t.topic_id = p.topic_id AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 30

Line : 1006
File : viewtopic.php[/spoiler]

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:  :)

[b]EDIT:[/b]
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

Re: Some Errors After Upgrade?
-----------------------------------
[quote user="batman" post="51848"]
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:[/quote]

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

Re: Some Errors After Upgrade?
-----------------------------------
[quote user="batman" post="51848"]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.[/quote]

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, [b][i]or going to do[/i][/b] [i](Where the forum is an ADD-On rather than the main attraction) [/i] - 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]"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?"[/i] 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

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

Re: Some Errors After Upgrade?
-----------------------------------
This is an old Topic, 

and already Fixed


-----------------------------------
mort
Wed 18 May, 2011 13:47

Re: Some Errors After Upgrade?
-----------------------------------
[quote user="spydie" post="52726"]This is an old Topic, 

and already Fixed[/quote]


And [b]chenyixiu[/b] is a [u]SPAMMER![/u] Check out the links it's posted?  :censored:


-----------------------------------
Joshua203
Wed 18 May, 2011 15:13

Re: Some Errors After Upgrade?
-----------------------------------
Spammer posts removed and banned.. thanks for reporting :wink:


