https://www.icyphoenix.com/viewtopic.php?f=35&t=7678&p=51828#p51828
-----------------------------------
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]


