|
Page 2 of 3
|
mort
Spam Basher
Joined: August 2010
Posts: 998
Location: Up a tree
|
Re: Some Errors After Upgrade?
EDIT 3:
Just got the IP running and will see how it goes
So what was different this time.
|
#16 Sun 27 Feb, 2011 05:20 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
|
batman
Karl
Joined: February 2011
Posts: 162
Location: Cornwall UK
|
Re: Some Errors After Upgrade?
EDIT 3:
Just got the IP running and will see how it goes
So what was different this time.
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. _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
This is the test board upgraded http://www.british-birds-in-avicult...stest/index.php
Table structure below
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
|
#17 Sun 27 Feb, 2011 06:09 |
|
mort
Spam Basher
Joined: August 2010
Posts: 998
Location: Up a tree
|
Re: Some Errors After Upgrade?
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.
|
#18 Sun 27 Feb, 2011 07:07 |
|
batman
Karl
Joined: February 2011
Posts: 162
Location: Cornwall UK
|
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
Much appreciate this mate
Last edited by batman on Sun 27 Feb, 2011 12:57; edited 1 time in total |
#19 Sun 27 Feb, 2011 08:21 |
|
spydie
Joined: December 2008
Posts: 1796
Location: In the Boxes
|
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
____________ Out of Order
|
#20 Sun 27 Feb, 2011 09:06 |
|
batman
Karl
Joined: February 2011
Posts: 162
Location: Cornwall UK
|
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
Last edited by batman on Sun 27 Feb, 2011 11:35; edited 3 times in total |
#21 Sun 27 Feb, 2011 09:42 |
|
spydie
Joined: December 2008
Posts: 1796
Location: In the Boxes
|
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
____________ Out of Order
|
#22 Sun 27 Feb, 2011 11:02 |
|
batman
Karl
Joined: February 2011
Posts: 162
Location: Cornwall UK
|
Re: Some Errors After Upgrade?
I have a plan but not sure how to do it 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
Does anybody know how I can merge these tables?
phpbb_posts
phpbb_posts_text
|
#23 Sun 27 Feb, 2011 11:38 |
|
mort
Spam Basher
Joined: August 2010
Posts: 998
Location: Up a tree
|
Re: Some Errors After Upgrade?
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.
And while I typed this - your download is finished - So you can remove it.
It's also 10-30pm here - So it looks like a morning job after I see what your latest development is.
|
#24 Sun 27 Feb, 2011 12:47 |
|
batman
Karl
Joined: February 2011
Posts: 162
Location: Cornwall UK
|
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
Hya spydie, were can I get a copy of 1.2.0.27c in the downloads it just redirects to latest
|
#25 Sun 27 Feb, 2011 23:06 |
|
spydie
Joined: December 2008
Posts: 1796
Location: In the Boxes
|
Re: Some Errors After Upgrade?
____________ Out of Order
|
#26 Mon 28 Feb, 2011 00:24 |
|
batman
Karl
Joined: February 2011
Posts: 162
Location: Cornwall UK
|
Re: Some Errors After Upgrade?
Thanks spydie, Im going to give this a try
|
#27 Mon 28 Feb, 2011 00:40 |
|
mort
Spam Basher
Joined: August 2010
Posts: 998
Location: Up a tree
|
Re: Some Errors After Upgrade?
Thanks spydie, Im going to give this a try
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.
|
#28 Mon 28 Feb, 2011 02:51 |
|
batman
Karl
Joined: February 2011
Posts: 162
Location: Cornwall UK
|
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.
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
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
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
|
#29 Mon 28 Feb, 2011 03:30 |
|
spydie
Joined: December 2008
Posts: 1796
Location: In the Boxes
|
Re: Some Errors After Upgrade?
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
That will change some thing´s probably
give it a try.
does´nt matter, if users have to put their sig´s in again
____________ Out of Order
|
#30 Mon 28 Feb, 2011 09:13 |
|
|
Page 2 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
|
|
|
|