Sub Menu
Links Menu
Online Users

In total there are 304 users online :: 4 registered, 0 hidden and 300 guests

Most users ever online was 1091 on Wed Aug 16, 2023 5:27 pm

Registered users: Bing [Bot], Google [Bot], Helter, Majestic-12 [Bot] based on users active over the past 60 minutes

141 feedback

Support for IntegraMOD 141

Moderator: Integra Moderator

PostAuthor: sanji » Wed Jan 17, 2007 12:36 am

Thanks Teelk,

I could find and download the update package.

But now, another problem occurs. As many others, I have modified my forum by adding (a limited numbers of) mods and changing some parameters. All of this would be lost if I directly overwrite the old files with the 1.4.1 ones.

Is either:
- a package with only the modified files (to compare with WinMerge, for example)
- a step by step procedure to upgrade manually the 1.4.0 files
available ?

Otherwise, I have no idea how to start the upgrading...

Thanks,

sanji
Last edited by sanji on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
[img]http://www.secret-japan.com/forum/images/banners/fuji%20secret-japan%2088x31.gif[/img] [url=http]Secret Japan[/url] : discover Japan off the beaten tracks

sanji
Sr Integra Member
Sr Integra Member
 
Posts: 291
Likes: 0 post
Liked in: 0 post
Joined: Wed Apr 12, 2006 8:18 pm
Cash on hand: 0.00

Re: 141 feedback

PostAuthor: Teelk » Wed Jan 17, 2007 12:50 am

I'm going to give you the gist of the ct thing. Cause I'm without screenshot software at the moment, so I can't finish a proper article and I'm trying to do about 50 things at once lol.

Open ctracker/engines/ct_security.php
FIND
Code: Select all
define('CT_DEBUG_MODE', false);
Change false to true and save and upload.

Now try to do what you did before to get the CT block message.

Then change the true back to false(this is important as protection is turned off in debug mode).

Go to ACP>CrackerTracker>Logmanager and view the debug entries log.

It'll show you what you have to do to unblock the var that's being blocked. It's in MOD installation instruction format, so it's easy to read. It's not 100% as it will tell you to add the code after define('IN_PHPBB', 1); which could sometimes be written as define('IN_PHPBB', true);.

For the theme problem, try the following...

I noticed that after updating a board the default theme in eXtreme styles ACP is called fisubice, but the theme of the board is actually Integra2. I don't know precisely what's happening at the moment. But, if you go to ACP>eXtreme Styles>Styles Management and install Integra2(because for some reason it's not installed, even though it's the board style), set Integra2 as default. Then uninstall all other styles other then Integra2. Now, you should be able to re-install or install any theme you want without a problem.
Last edited by Teelk on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
User avatar
Teelk
Dev Team
Dev Team
 
Posts: 1309
Likes: 0 post
Liked in: 0 post
Joined: Tue Mar 14, 2006 5:25 pm
Cash on hand: 0.00
Location: Canada

PostAuthor: Teelk » Wed Jan 17, 2007 1:01 am

"sanji";p="19570" wrote:Thanks Teelk,

I could find and download the update package.

But now, another problem occurs. As many others, I have modified my forum by adding (a limited numbers of) mods and changing some parameters. All of this would be lost if I directly overwrite the old files with the 1.4.1 ones.

Is either:
- a package with only the modified files (to compare with WinMerge, for example)
- a step by step procedure to upgrade manually the 1.4.0 files
available ?

Otherwise, I have no idea how to start the upgrading...

Thanks,

sanji
I honestly think it would be easier to overwrite your forum and then add the MODs back in then to do a file by file search of changes. Even with a changelog it would take you weeks to do it. There were approximately 370 SVN revisions of the code. By revisions I mean uploaded code changes, many of which changed dozens of files at a time. And there were changes even before the SVN server went up. This is the reason there's no manual update as it would be an enormous task to do that many file edits.

And that's why, in the future, updates will be much smaller and more frequent. And manual updates for those will be available. I know this doesn't help you much now, but all I can do is offer my help if it's needed.

PM'ing is always available.
Last edited by Teelk on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
User avatar
Teelk
Dev Team
Dev Team
 
Posts: 1309
Likes: 0 post
Liked in: 0 post
Joined: Tue Mar 14, 2006 5:25 pm
Cash on hand: 0.00
Location: Canada

Re: 141 feedback

PostAuthor: Teelk » Wed Jan 17, 2007 2:57 am

KB Article about how to change CrackerTracker to unblock pages.

http://www.integramod.com/forum/kb.php? ... ticle&k=22
Last edited by Teelk on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
User avatar
Teelk
Dev Team
Dev Team
 
Posts: 1309
Likes: 0 post
Liked in: 0 post
Joined: Tue Mar 14, 2006 5:25 pm
Cash on hand: 0.00
Location: Canada

Re: 141 feedback

PostAuthor: Whisky » Wed Jan 17, 2007 4:41 am

Hi all

I've just installed the pack on my test site and followed all instructions
There was a small problem during the DB scema update:
Code: Select all
Updating IntegraMOD database schema  Progress ]
I had [b]User Group Color[/b] installed before so this is probably related and effectively "nothing to worry about"

However, after having completed all the installation step, I receive the same error message then Zak when accessing my board:
[code]  Warning]: failed to open stream: No such file or directory in /homepages/28/d163712120/htdocs/roltest/includes/functions.php on line 818  Warning: init_userprefs() [function.include]: Failed opening './language/lang_francais/lang_cback_ctracker.php' for inclusion (include_path='.:/usr/local/lib/php') in /homepages/28/d163712120/htdocs/roltest/includes/functions.php on line 818phpBB : Critical Error  Could not get theme data for themes_id [11]

http://rebirthoflight.net/roltest/

So I can't login to my board and ACP at all

i tried to reload the def_themes.php like Zak said but nothing change.

the fact is that we are using our own themes and the default IM themes are not even installed at all.
I have not yet changed anything in my thmes template coz I don't what the 1.41 changes are yet (if they exist)
I am looking now for a solution on my own but any advices would be apprecied 8)
Last edited by Whisky on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
I am the Lizard King, I can do anything

Whisky
Sr Integra Member
Sr Integra Member
 
Posts: 256
Likes: 0 post
Liked in: 0 post
Joined: Thu May 18, 2006 1:28 am
Cash on hand: 0.00
Location: Brussels

Re: 141 feedback

PostAuthor: JohnnyTheOne » Wed Jan 17, 2007 4:58 am

Hi Whisky,

I have seen your site at http://rebirthoflight.net/roltest/
That Warning is what I have See
Code: Select all
Warning]: failed to open stream: No such file or directory in /homepages/28/d163712120/htdocs/roltest/includes/functions.php on line 818  Warning: init_userprefs() [function.include]: Failed opening './language/lang_francais/lang_cback_ctracker.php' for inclusion (include_path='.:/usr/local/lib/php') in /homepages/28/d163712120/htdocs/roltest/includes/functions.php on line 818  Warning: Cannot modify header information - headers already sent by (output started at /homepages/28/d163712120/htdocs/roltest/includes/functions.php:818) in /homepages/28/d163712120/htdocs/roltest/includes/functions.php on line 205  Warning: Cannot modify header information - headers already sent by (output started at /homepages/28/d163712120/htdocs/roltest/includes/functions.php:818) in /homepages/28/d163712120/htdocs/roltest/includes/page_header.php on line 1156  Warning: Cannot modify header information - headers already sent by (output started at /homepages/28/d163712120/htdocs/roltest/includes/functions.php:818) in /homepages/28/d163712120/htdocs/roltest/includes/page_header.php on line 1158  Warning: Cannot modify header information - headers already sent by (output started at /homepages/28/d163712120/htdocs/roltest/includes/functions.php:818) in /homepages/28/d163712120/htdocs/roltest/includes/page_header.php on line 1159Template->make_filename(): Error - template file not found: blocks/ts_block.tpl

tried to reload the ./language/lang_xxxx/lang_cback_ctracker.php
Last edited by JohnnyTheOne on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
JohnnyTheOne
Development and exploitation of Websites
http://www.johnnytheone.com
User avatar
JohnnyTheOne
Members
Members
 
Posts: 78
Likes: 0 post
Liked in: 0 post
Joined: Tue Apr 18, 2006 7:35 am
Cash on hand: 0.00
Location: Hengelo (ov)

Re: 141 feedback

PostAuthor: Whisky » Wed Jan 17, 2007 5:02 am

Ok forgot about my previous message I've found the fix, I had to adapt the def_theme.php to match the values of at least one of my theme recorded in my `phpbb_themes` table, like this:
Code: Select all
$themes_style = array(                 11 => array('themes_id' => '7', 'template_name' => 'roldruid', 'style_name' => 'ROLdruid', 'head_stylesheet' => 'roldruid.css', 'body_background' => '', 'body_bgcolor' => '', 'body_text' => '', 'body_link' => '', 'body_vlink' => '', 'body_alink' => '', 'body_hlink' => '', 'tr_color1' => '', 'tr_color2' => '', 'tr_color3' => '', 'tr_class1' => '', 'tr_class2' => '', 'tr_class3' => '', 'th_color1' => '', 'th_color2' => '', 'th_color3' => '', 'th_class1' => '', 'th_class2' => '', 'th_class3' => '', 'td_color1' => '', 'td_color2' => '', 'td_color3' => '', 'td_class1' => 'row1', 'td_class2' => 'row2', 'td_class3' => '', 'fontface1' => '', 'fontface2' => '', 'fontface3' => '', 'fontsize1' => '0', 'fontsize2' => '0', 'fontsize3' => '0', 'fontcolor1' => '', 'fontcolor2' => '006600', 'fontcolor3' => 'ff0000', 'span_class1' => '', 'span_class2' => '', 'span_class3' => '', 'img_size_poll' => '0', 'img_size_privmsg' => '0'),         );

<img>
Last edited by Whisky on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
I am the Lizard King, I can do anything

Whisky
Sr Integra Member
Sr Integra Member
 
Posts: 256
Likes: 0 post
Liked in: 0 post
Joined: Thu May 18, 2006 1:28 am
Cash on hand: 0.00
Location: Brussels

Re: 141 feedback

PostAuthor: Whisky » Wed Jan 17, 2007 5:08 am

Thank you Johnny that worked I don't receive any warning anymore.
I just put this new lang_cback_ctracker.php in my french language folder <img>
Last edited by Whisky on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
I am the Lizard King, I can do anything

Whisky
Sr Integra Member
Sr Integra Member
 
Posts: 256
Likes: 0 post
Liked in: 0 post
Joined: Thu May 18, 2006 1:28 am
Cash on hand: 0.00
Location: Brussels

Re: 141 feedback

PostAuthor: JohnnyTheOne » Wed Jan 17, 2007 4:52 pm

I have updated my 1.4.0 to 1.4.1 successfully. :mrgreen:
Last edited by JohnnyTheOne on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
JohnnyTheOne
Development and exploitation of Websites
http://www.johnnytheone.com
User avatar
JohnnyTheOne
Members
Members
 
Posts: 78
Likes: 0 post
Liked in: 0 post
Joined: Tue Apr 18, 2006 7:35 am
Cash on hand: 0.00
Location: Hengelo (ov)

PostAuthor: richiebgood » Wed Jan 17, 2007 5:33 pm

Upgrade went perfect. Minior adjustments with crack tracker needed but other than that i am loving it.

Great Work
Last edited by richiebgood on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.

richiebgood
Sr Integra Member
Sr Integra Member
 
Posts: 329
Likes: 0 post
Liked in: 0 post
Joined: Tue Aug 08, 2006 12:01 am
Cash on hand: 0.00
Location: Ireland

PostAuthor: Steven72555 » Wed Jan 17, 2007 8:27 pm

I tried upgrade my 1.40 to 1.41 and met with disaster.. I am glad it was on test site.
It was error involving cttracker.
I am going to try ahain, and update this message afterwards.

Question:Should I have my phpbb version up to a minimum of 2.20 ?
Last edited by Steven72555 on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.

Steven72555
Newbie
Newbie
 
Posts: 10
Likes: 0 post
Liked in: 0 post
Joined: Tue Nov 07, 2006 6:54 pm
Cash on hand: 0.00

PostAuthor: mmcguire » Thu Jan 18, 2007 4:42 pm

"Steven72555";p="19652" wrote:I tried upgrade my 1.40 to 1.41 and met with disaster.. I am glad it was on test site.
It was error involving cttracker.
I am going to try ahain, and update this message afterwards.

Question:Should I have my phpbb version up to a minimum of 2.20 ?


I started with 2.0.17 and everything upgraded fine.
Last edited by mmcguire on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.

mmcguire
Newbie
Newbie
 
Posts: 1
Likes: 0 post
Liked in: 0 post
Joined: Wed Jan 17, 2007 9:29 am
Cash on hand: 0.00

PostAuthor: Fubie » Thu Jan 18, 2007 8:48 pm

"mmcguire";p="19706" wrote:
"Steven72555";p="19652" wrote:I tried upgrade my 1.40 to 1.41 and met with disaster.. I am glad it was on test site.
It was error involving cttracker.
I am going to try ahain, and update this message afterwards.

Question:Should I have my phpbb version up to a minimum of 2.20 ?


I started with 2.0.17 and everything upgraded fine.


I think everyones hosts have a big part into the problems, so some things may take some tweaking.
Last edited by Fubie on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
[url=http][img=left]http://www.myhorrorstories.com/files/bannerexchange.gif[/img][/url]

[url=http][img=left]http://www.fubie.net/images/geekstufflarge.jpg[/img][/url]

Fubie
Dev Team
Dev Team
 
Posts: 742
Likes: 0 post
Liked in: 0 post
Joined: Sat Mar 11, 2006 6:52 pm
Cash on hand: 0.00

PostAuthor: Dioncecht » Fri Jan 19, 2007 10:44 am

"sanji";p="19570" wrote:Thanks Teelk,

I could find and download the update package.

But now, another problem occurs. As many others, I have modified my forum by adding (a limited numbers of) mods and changing some parameters. All of this would be lost if I directly overwrite the old files with the 1.4.1 ones.

Is either:
- a package with only the modified files (to compare with WinMerge, for example)
- a step by step procedure to upgrade manually the 1.4.0 files
available ?

Otherwise, I have no idea how to start the upgrading...

Thanks,

sanji



Sanji,

Here's what I did.. I installed 141 in a new directory, reinstalled my mods then used a .script I wrote a couple weeks ago. It may need a littel tweaking, but I'm basically using bits and pieces like users, categories, topics, forums, etc...

Hope it helps. It should be mostly right. basically you empty the tables you wanna copy the data into, then you copy pieces of this into your SQL commands and it will pull the data out of the old database and dump it into teh rigth spots in the new database. It worked pretty good for me. Don't use the whole thing at once.. Thats why I labeled each section.. and if it errors, just pull out the offending column, but it should mostly work

Code: Select all
#phpbb_account_hist  INSERT INTO YOURDATABASE_rpghq141.phpbb_account_hist (user_id, lw_post_id, lw_money, lw_plus_minus, MNY_CURRENCY, lw_date, comment, status, txn_id, lw_site) SELECT user_id, lw_post_id, lw_money, lw_plus_minus, MNY_CURRENCY, lw_date, comment, status, txn_id, lw_site FROM YOURDATABASE_rpghq140.phpbb_account_hist;  #phpbb_acronyms  INSERT INTO YOURDATABASE_rpghq141.phpbb_acronyms (acronym_id, acronym, de.scription) SELECT acronym_id, acronym, de.scription FROM YOURDATABASE_rpghq140.phpbb_acronyms;  #phpbb_admin_pm  INSERT INTO YOURDATABASE_rpghq141.phpbb_admin_pm (admin_id, admin_redirect_id, admin_deny) SELECT admin_id, admin_redirect_id, admin_deny FROM YOURDATABASE_rpghq140.phpbb_admin_pm;  #phpbb_album  INSERT INTO YOURDATABASE_rpghq141.phpbb_album (pic_id, pic_filename, pic_thumbnail, pic_title, pic_desc, pic_user_id, pic_username, pic_user_ip, pic_time, pic_cat_id, pic_view_count, pic_lock, pic_approval) SELECT pic_id, pic_filename, pic_thumbnail, pic_title, pic_desc, pic_user_id, pic_username, pic_user_ip, pic_time, pic_cat_id, pic_view_count, pic_lock, pic_approval FROM YOURDATABASE_rpghq140.phpbb_album;  #phpbb_album_cat  INSERT INTO YOURDATABASE_rpghq141.phpbb_album_cat (cat_id, cat_title, cat_desc, cat_order, cat_view_level, cat_upload_level, cat_rate_level, cat_comment_level, cat_edit_level, cat_delete_level, cat_view_groups, cat_upload_groups, cat_rate_groups, cat_comment_groups, cat_edit_groups, cat_delete_groups, cat_moderator_groups, cat_approval, cat_parent) SELECT cat_id, cat_title, cat_desc, cat_order, cat_view_level, cat_upload_level, cat_rate_level, cat_comment_level, cat_edit_level, cat_delete_level, cat_view_groups, cat_upload_groups, cat_rate_groups, cat_comment_groups, cat_edit_groups, cat_delete_groups, cat_moderator_groups, cat_approval, cat_parent FROM YOURDATABASE_rpghq140.phpbb_album_cat;  #phpbb_album_comment  INSERT INTO YOURDATABASE_rpghq141.phpbb_album_comment (comment_id, comment_pic_id, comment_cat_id, comment_user_id, comment_username, comment_user_ip, comment_time, comment_text, comment_edit_time, comment_edit_count, comment_edit_user_id) SELECT comment_id, comment_pic_id, comment_cat_id, comment_user_id, comment_username, comment_user_ip, comment_time, comment_text, comment_edit_time, comment_edit_count, comment_edit_user_id  FROM YOURDATABASE_rpghq140.phpbb_album_comment;  #phpbb_album_rate  INSERT INTO YOURDATABASE_rpghq141.phpbb_album_rate (rate_pic_id, rate_user_id, rate_user_ip, rate_point, rate_hon_point) SELECT rate_pic_id, rate_user_id, rate_user_ip, rate_point, rate_hon_point FROM YOURDATABASE_rpghq140.phpbb_album_rate;  #phpbb_approve_forums  INSERT INTO YOURDATABASE_rpghq141.phpbb_approve_forums (forum_id, enabled, approve_posts, approve_topics, approve_users, approve_poste, approve_topice, approve_notify, approve_notify_approval, approve_notify_type, approve_notify_message, approve_notify_message_len, approve_moderators, approve_notify_posts, approve_notify_poste, approve_notify_topics, approve_notify_topice, forum_hide_unapproved_topics, forum_hide_unapproved_posts) SELECT forum_id, enabled, approve_posts, approve_topics, approve_users, approve_poste, approve_topice, approve_notify, approve_notify_approval, approve_notify_type, approve_notify_message, approve_notify_message_len, approve_moderators, approve_notify_posts, approve_notify_poste, approve_notify_topics, approve_notify_topice, forum_hide_unapproved_topics, forum_hide_unapproved_posts FROM YOURDATABASE_rpghq140.phpbb_approve_forums;  #phpbb_approve_posts  INSERT INTO YOURDATABASE_rpghq141.phpbb_approve_posts (approval_id, topic_id, post_id, is_topic, is_post, poster_id) SELECT approval_id, topic_id, post_id, is_topic, is_post, poster_id FROM YOURDATABASE_rpghq140.phpbb_approve_posts;  #phpbb_approve_topics  INSERT INTO YOURDATABASE_rpghq141.phpbb_approve_topics (topic_id, approve_moderate) SELECT topic_id, approve_moderate FROM YOURDATABASE_rpghq140.phpbb_approve_topics;  #phpbb_approve_users  INSERT INTO YOURDATABASE_rpghq141.phpbb_approve_users (user_id, approve_moderate) SELECT user_id, approve_moderate FROM YOURDATABASE_rpghq140.phpbb_approve_users;  #phpbb_attachments  INSERT INTO YOURDATABASE_rpghq141.phpbb_attachments (attach_id, post_id, privmsgs_id, user_id_1, user_id_2) SELECT attach_id, post_id, privmsgs_id, user_id_1, user_id_2 FROM YOURDATABASE_rpghq140.phpbb_attachments;  #phpbb_attachments_desc  INSERT INTO YOURDATABASE_rpghq141.phpbb_attachments_desc (attach_id, physical_filename, real_filename, download_count, comment, extension, mimetype, filesize, filetime, thumbnail) SELECT attach_id, physical_filename, real_filename, download_count, comment, extension, mimetype, filesize, filetime, thumbnail FROM YOURDATABASE_rpghq140.phpbb_attachments_desc;  #phpbb_attach_quota  INSERT INTO YOURDATABASE_rpghq141.phpbb_attach_quota (user_id, group_id, quota_type, quota_limit_id) SELECT user_id, group_id, quota_type, quota_limit_id FROM YOURDATABASE_rpghq140.phpbb_attach_quota;  #phpbb_auth_access  INSERT INTO YOURDATABASE_rpghq141.phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_global_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod, auth_download, auth_news, auth_cal, auth_ban, auth_greencard, auth_bluecard, auth_delayedpost) SELECT group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_global_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod, auth_download, auth_news, auth_cal, auth_ban, auth_greencard, auth_bluecard, auth_delayedpost FROM YOURDATABASE_rpghq140.phpbb_auth_access;  #phpbb_banlist  INSERT INTO YOURDATABASE_rpghq141.phpbb_banlist (ban_id, ban_userid, ban_ip, ban_email) SELECT ban_id, ban_userid, ban_ip, ban_email FROM YOURDATABASE_rpghq140.phpbb_banlist;  #phpbb_banner  INSERT INTO YOURDATABASE_rpghq141.phpbb_banner (banner_id, banner_name, banner_spot, banner_forum, banner_de.scription, banner_url, banner_owner, banner_click, banner_view, banner_weigth, banner_active, banner_timetype, time_begin, time_end, date_begin, date_end, banner_level, banner_level_type, banner_comment, banner_type, banner_width, banner_height, banner_filter, banner_filter_time) SELECT banner_id, banner_name, banner_spot, banner_forum, banner_de.scription, banner_url, banner_owner, banner_click, banner_view, banner_weigth, banner_active, banner_timetype, time_begin, time_end, date_begin, date_end, banner_level, banner_level_type, banner_comment, banner_type, banner_width, banner_height, banner_filter, banner_filter_time FROM YOURDATABASE_rpghq140.phpbb_banner;  #phpbb_banner_stats  INSERT INTO YOURDATABASE_rpghq141.phpbb_banner_stats (banner_id, click_date, click_ip, click_user, user_duration) SELECT banner_id, click_date, click_ip, click_user, user_duration FROM YOURDATABASE_rpghq140.phpbb_banner_stats;  #phpbb_blocks  INSERT INTO YOURDATABASE_rpghq141.phpbb_blocks (bid, title, content, bposition, weight, active, blockfile, view, layout, cache, cache_time, block_bbcode_uid, type, border, titlebar, background, local, groups) SELECT bid, title, content, bposition, weight, active, blockfile, view, layout, cache, cache_time, block_bbcode_uid, type, border, titlebar, background, local, groups FROM YOURDATABASE_rpghq140.phpbb_blocks;  #phpbb_block_position  INSERT INTO YOURDATABASE_rpghq141.phpbb_block_position (bpid, pkey, bposition, layout) SELECT bpid, pkey, bposition, layout FROM YOURDATABASE_rpghq140.phpbb_block_position;  #phpbb_block_variable  INSERT INTO YOURDATABASE_rpghq141.phpbb_block_variable (bvid, label, sub_label, config_name, field_options, field_values, type, block) SELECT bvid, label, sub_label, config_name, field_options, field_values, type, block FROM YOURDATABASE_rpghq140.phpbb_block_variable;  #phpbb_bookmarks  INSERT INTO YOURDATABASE_rpghq141.phpbb_bookmarks (topic_id, user_id) SELECT topic_id, user_id FROM YOURDATABASE_rpghq140.phpbb_bookmarks;    #phpbb_bots  INSERT INTO YOURDATABASE_rpghq141.phpbb_bots (bot_id, bot_name, bot_agent, last_visit, bot_visits, bot_pages, pending_agent, pending_ip, bot_ip) SELECT bot_id, bot_name, bot_agent, last_visit, bot_visits, bot_pages, pending_agent, pending_ip, bot_ip FROM YOURDATABASE_rpghq140.phpbb_bots;  #phpbb_buddy  INSERT INTO YOURDATABASE_rpghq141.phpbb_buddy (user_id, buddy_id, buddy_ignore, buddy_visible) SELECT user_id, buddy_id, buddy_ignore, buddy_visible FROM YOURDATABASE_rpghq140.phpbb_buddy;  #phpbb_categories  INSERT INTO YOURDATABASE_rpghq141.phpbb_categories (cat_id, cat_title, cat_order, cat_main_type, cat_main, cat_desc, icon) SELECT cat_id, cat_title, cat_order, cat_main_type, cat_main, cat_desc, icon FROM YOURDATABASE_rpghq140.phpbb_categories;  #phpbb_chatspot_messages  INSERT INTO YOURDATABASE_rpghq141.phpbb_chatspot_messages (message_id, room_id, username, msg, msg_type, timestamp, to_user_id, FROM_user_id) SELECT message_id, room_id, username, msg, msg_type, timestamp, to_user_id, FROM_user_id FROM YOURDATABASE_rpghq140.phpbb_chatspot_messages;  #phpbb_chatspot_rooms  INSERT INTO YOURDATABASE_rpghq141.phpbb_chatspot_rooms (room_id, room_name, room_type, room_access, room_password, room_creator_id) SELECT room_id, room_name, room_type, room_access, room_password, room_creator_id FROM YOURDATABASE_rpghq140.phpbb_chatspot_rooms;  #phpbb_chatspot_sessions  INSERT INTO YOURDATABASE_rpghq141.phpbb_chatspot_sessions (user_id, username, room_id, last_active, last_status) SELECT user_id, username, room_id, last_active, last_status FROM YOURDATABASE_rpghq140.phpbb_chatspot_sessions;  #phpbb_confirm  INSERT INTO YOURDATABASE_rpghq141.phpbb_confirm (confirm_id, session_id, code) SELECT confirm_id, session_id, code FROM YOURDATABASE_rpghq140.phpbb_confirm;  #phpbb_contact_list  INSERT INTO YOURDATABASE_rpghq141.phpbb_contact_list (user_id, contact_id, user_ignore, alert, alert_status, disallow, display_name) SELECT user_id, contact_id, user_ignore, alert, alert_status, disallow, display_name FROM YOURDATABASE_rpghq140.phpbb_contact_list;  #phpbb_digest  INSERT INTO YOURDATABASE_rpghq141.phpbb_digest (user_id, digest_frequency, last_digest, format, show_text, show_mine, new_only, send_on_no_messages, text_length) SELECT user_id, digest_frequency, last_digest, format, show_text, show_mine, new_only, send_on_no_messages, text_length FROM YOURDATABASE_rpghq140.phpbb_digest;  #phpbb_digest_forums  INSERT INTO YOURDATABASE_rpghq141.phpbb_digest_forums (user_id, forum_id) SELECT user_id, forum_id FROM YOURDATABASE_rpghq140.phpbb_digest_forums;  #phpbb_disallow  INSERT INTO YOURDATABASE_rpghq141.phpbb_disallow (disallow_id, disallow_username) SELECT disallow_id, disallow_username FROM YOURDATABASE_rpghq140.phpbb_disallow;  #phpbb_email_users  INSERT INTO YOURDATABASE_rpghq141.phpbb_email_users (user_id, user_email) SELECT user_id, user_email FROM YOURDATABASE_rpghq140.phpbb_email_users;  #phpbb_extensions  INSERT INTO YOURDATABASE_rpghq141.phpbb_extensions (ext_id, group_id, extension, comment) SELECT ext_id, group_id, extension, comment FROM YOURDATABASE_rpghq140.phpbb_extensions;  #phpbb_extension_groups  INSERT INTO YOURDATABASE_rpghq141.phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) SELECT group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions FROM YOURDATABASE_rpghq140.phpbb_extension_groups;  #phpbb_flags  INSERT INTO YOURDATABASE_rpghq141.phpbb_flags (flag_id, flag_name, flag_image) SELECT flag_id, flag_name, flag_image FROM YOURDATABASE_rpghq140.phpbb_flags;  #phpbb_forbidden_extensions  INSERT INTO YOURDATABASE_rpghq141.phpbb_forbidden_extensions (ext_id, extension) SELECT ext_id, extension FROM YOURDATABASE_rpghq140.phpbb_forbidden_extensions;  #phpbb_force_read  INSERT INTO YOURDATABASE_rpghq141.phpbb_force_read (topic_number, message, install_date, active, effected) SELECT topic_number, message, install_date, active, effected FROM YOURDATABASE_rpghq140.phpbb_force_read;  #phpbb_forums  INSERT INTO YOURDATABASE_rpghq141.phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_global_announce, auth_vote, auth_pollcreate, auth_attachments, auth_download, auth_news, forum_link, forum_link_internal, forum_link_hit_count, forum_link_hit, icon, main_type, auth_cal, auth_ban, auth_greencard, auth_bluecard, auth_delayedpost) SELECT forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_global_announce, auth_vote, auth_pollcreate, auth_attachments, auth_download, auth_news, forum_link, forum_link_internal, forum_link_hit_count, forum_link_hit, icon, main_type, auth_cal, auth_ban, auth_greencard, auth_bluecard, auth_delayedpost FROM YOURDATABASE_rpghq140.phpbb_forums;  #phpbb_forum_prune  INSERT INTO YOURDATABASE_rpghq141.phpbb_forum_prune (prune_id, forum_id, prune_days, prune_freq) SELECT prune_id, forum_id, prune_days, prune_freq FROM YOURDATABASE_rpghq140.phpbb_forum_prune;  #phpbb_forum_tour  INSERT INTO YOURDATABASE_rpghq141.phpbb_forum_tour (page_id, page_subject, page_text, page_sort, bbcode_uid) SELECT page_id, page_subject, page_text, page_sort, bbcode_uid FROM YOURDATABASE_rpghq140.phpbb_forum_tour;  #phpbb_groups  INSERT INTO YOURDATABASE_rpghq141.phpbb_groups (group_id, group_type, group_name, group_de.scription, group_moderator, group_single_user, group_count, group_count_max, group_count_enable, group_amount, group_period, group_period_basis, group_first_trial_fee, group_first_trial_period, group_first_trial_period_basis, group_second_trial_fee, group_second_trial_period, group_second_trial_period_basis, group_sub_recurring, group_sub_recurring_stop, group_sub_recurring_stop_num, group_sub_reattempt) SELECT group_id, group_type, group_name, group_de.scription, group_moderator, group_single_user, group_count, group_count_max, group_count_enable, group_amount, group_period, group_period_basis, group_first_trial_fee, group_first_trial_period, group_first_trial_period_basis, group_second_trial_fee, group_second_trial_period, group_second_trial_period_basis, group_sub_recurring, group_sub_recurring_stop, group_sub_recurring_stop_num, group_sub_reattempt FROM YOURDATABASE_rpghq140.phpbb_groups;  #phpbb_im_prefs  INSERT INTO YOURDATABASE_rpghq141.phpbb_im_prefs (user_id, user_allow_ims, user_allow_shout, user_allow_chat, user_allow_network, admin_allow_ims, admin_allow_shout, admin_allow_chat, admin_allow_network, new_ims, unread_ims, read_ims, total_sent, attach_sig, refresh_rate, success_close, refresh_method, auto_launch, popup_ims, list_ims, show_controls, list_all_online, default_mode, current_mode, mode1_height, mode1_width, mode2_height, mode2_width, mode3_height, mode3_width, prefs_width, prefs_height, read_height, read_width, send_height, send_width, play_sound, default_sound, sound_name, themes_id, network_user_list, open_pms, auto_delete, use_frames, user_override) SELECT user_id, user_allow_ims, user_allow_shout, user_allow_chat, user_allow_network, admin_allow_ims, admin_allow_shout, admin_allow_chat, admin_allow_network, new_ims, unread_ims, read_ims, total_sent, attach_sig, refresh_rate, success_close, refresh_method, auto_launch, popup_ims, list_ims, show_controls, list_all_online, default_mode, current_mode, mode1_height, mode1_width, mode2_height, mode2_width, mode3_height, mode3_width, prefs_width, prefs_height, read_height, read_width, send_height, send_width, play_sound, default_sound, sound_name, themes_id, network_user_list, open_pms, auto_delete, use_frames, user_override FROM YOURDATABASE_rpghq140.phpbb_im_prefs;  #phpbb_im_sessions  INSERT INTO YOURDATABASE_rpghq141.phpbb_im_sessions (session_user_id, session_id, session_time, session_popup) SELECT session_user_id, session_id, session_time, session_popup FROM YOURDATABASE_rpghq140.phpbb_im_sessions;  #phpbb_im_sites  INSERT INTO YOURDATABASE_rpghq141.phpbb_im_sites (site_id, site_name, site_url, site_phpex, site_profile, site_enable) SELECT site_id, site_name, site_url, site_phpex, site_profile, site_enable FROM YOURDATABASE_rpghq140.phpbb_im_sites;  #phpbb_jr_admin_users  INSERT INTO YOURDATABASE_rpghq141.phpbb_jr_admin_users (user_id, user_jr_admin, start_date, update_date, admin_notes, notes_view) SELECT user_id, user_jr_admin, start_date, update_date, admin_notes, notes_view FROM YOURDATABASE_rpghq140.phpbb_jr_admin_users;  #phpbb_kb_articles  INSERT INTO YOURDATABASE_rpghq141.phpbb_kb_articles (article_id, article_category_id, article_title, article_de.scription, article_date, article_author_id, username, bbcode_uid, article_body, article_type, approved, topic_id, views, article_rating, article_totalvotes) SELECT article_id, article_category_id, article_title, article_de.scription, article_date, article_author_id, username, bbcode_uid, article_body, article_type, approved, topic_id, views, article_rating, article_totalvotes FROM YOURDATABASE_rpghq140.phpbb_kb_articles;  #phpbb_kb_categories  INSERT INTO YOURDATABASE_rpghq141.phpbb_kb_categories (category_id, category_name, category_details, number_articles, parent, cat_order) SELECT category_id, category_name, category_details, number_articles, parent, cat_order  FROM YOURDATABASE_rpghq140.phpbb_kb_categories;  #phpbb_kb_results  INSERT INTO YOURDATABASE_rpghq141.phpbb_kb_results (search_id, session_id, search_array) SELECT search_id, session_id, search_array FROM YOURDATABASE_rpghq140.phpbb_kb_results;  #phpbb_kb_types  INSERT INTO YOURDATABASE_rpghq141.phpbb_kb_types (id, type) SELECT id, type FROM YOURDATABASE_rpghq140.phpbb_kb_types;  #phpbb_kb_votes  INSERT INTO YOURDATABASE_rpghq141.phpbb_kb_votes (votes_ip, votes_userid, votes_file) SELECT votes_ip, votes_userid, votes_file FROM YOURDATABASE_rpghq140.phpbb_kb_votes;  #phpbb_kb_wordlist  INSERT INTO YOURDATABASE_rpghq141.phpbb_kb_wordlist (word_text, word_id, word_common) SELECT word_text, word_id, word_common FROM YOURDATABASE_rpghq140.phpbb_kb_wordlist;  #phpbb_kb_wordmatch  INSERT INTO YOURDATABASE_rpghq141.phpbb_kb_wordmatch (article_id, word_id, title_match) SELECT article_id, word_id, title_match FROM YOURDATABASE_rpghq140.phpbb_kb_wordmatch;  #phpbb_layout  INSERT INTO YOURDATABASE_rpghq141.phpbb_layout (lid, name, template, forum_wide, view, groups) SELECT lid, name, template, forum_wide, view, groups FROM YOURDATABASE_rpghq140.phpbb_layout;    #phpbb_modules  INSERT INTO YOURDATABASE_rpghq141.phpbb_modules (module_id, short_name, update_time, module_order, active, perm_all, perm_reg, perm_mod, perm_admin) SELECT module_id, short_name, update_time, module_order, active, perm_all, perm_reg, perm_mod, perm_admin FROM YOURDATABASE_rpghq140.phpbb_modules;  #phpbb_module_cache  INSERT INTO YOURDATABASE_rpghq141.phpbb_module_cache (module_id, module_cache_time, db_cache, priority) SELECT module_id, module_cache_time, db_cache, priority FROM YOURDATABASE_rpghq140.phpbb_module_cache;  #phpbb_module_group_auth  INSERT INTO YOURDATABASE_rpghq141.phpbb_module_group_auth (module_id, group_id) SELECT module_id, group_id FROM YOURDATABASE_rpghq140.phpbb_module_group_auth;  #phpbb_module_info  INSERT INTO YOURDATABASE_rpghq141.phpbb_module_info (module_id, long_name, author, email, url, version, update_site, extra_info) SELECT module_id, long_name, author, email, url, version, update_site, extra_info FROM YOURDATABASE_rpghq140.phpbb_module_info;  #phpbb_news  INSERT INTO YOURDATABASE_rpghq141.phpbb_news (news_id, news_category, news_image) SELECT news_id, news_category, news_image FROM YOURDATABASE_rpghq140.phpbb_news;  #phpbb_optimize_db  INSERT INTO YOURDATABASE_rpghq141.phpbb_optimize_db (cron_enable, cron_every, cron_next, cron_count, cron_lock, show_begin_for, show_not_optimized) SELECT cron_enable, cron_every, cron_next, cron_count, cron_lock, show_begin_for, show_not_optimized FROM YOURDATABASE_rpghq140.phpbb_optimize_db;  #phpbb_pa_auth  INSERT INTO YOURDATABASE_rpghq141.phpbb_pa_auth (group_id, cat_id, auth_view, auth_read, auth_view_file, auth_edit_file, auth_delete_file, auth_upload, auth_download, auth_rate, auth_email, auth_view_comment, auth_post_comment, auth_edit_comment, auth_delete_comment, auth_mod, auth_search, auth_stats, auth_toplist, auth_viewall) SELECT group_id, cat_id, auth_view, auth_read, auth_view_file, auth_edit_file, auth_delete_file, auth_upload, auth_download, auth_rate, auth_email, auth_view_comment, auth_post_comment, auth_edit_comment, auth_delete_comment, auth_mod, auth_search, auth_stats, auth_toplist, auth_viewall FROM YOURDATABASE_rpghq140.phpbb_pa_auth;  #phpbb_pa_cat  INSERT INTO YOURDATABASE_rpghq141.phpbb_pa_cat (cat_id, cat_name, cat_desc, cat_parent, parents_data, cat_order, cat_allow_file, cat_allow_ratings, cat_allow_comments, cat_files, cat_last_file_id, cat_last_file_name, cat_last_file_time, auth_view, auth_read, auth_view_file, auth_edit_file, auth_delete_file, auth_upload, auth_download, auth_rate, auth_email, auth_view_comment, auth_post_comment, auth_edit_comment, auth_delete_comment) SELECT cat_id, cat_name, cat_desc, cat_parent, parents_data, cat_order, cat_allow_file, cat_allow_ratings, cat_allow_comments, cat_files, cat_last_file_id, cat_last_file_name, cat_last_file_time, auth_view, auth_read, auth_view_file, auth_edit_file, auth_delete_file, auth_upload, auth_download, auth_rate, auth_email, auth_view_comment, auth_post_comment, auth_edit_comment, auth_delete_comment FROM YOURDATABASE_rpghq140.phpbb_pa_cat;  #phpbb_pa_comments  INSERT INTO YOURDATABASE_rpghq141.phpbb_pa_comments (comments_id, file_id, comments_text, comments_title, comments_time, comment_bbcode_uid, poster_id) SELECT comments_id, file_id, comments_text, comments_title, comments_time, comment_bbcode_uid, poster_id FROM YOURDATABASE_rpghq140.phpbb_pa_comments;  #phpbb_pa_custom  INSERT INTO YOURDATABASE_rpghq141.phpbb_pa_custom (custom_id, custom_name, custom_de.scription, data, field_order, field_type, regex) SELECT custom_id, custom_name, custom_de.scription, data, field_order, field_type, regex FROM YOURDATABASE_rpghq140.phpbb_pa_custom;  #phpbb_pa_customdata  INSERT INTO YOURDATABASE_rpghq141.phpbb_pa_customdata (customdata_file, customdata_custom, data) SELECT customdata_file, customdata_custom, data FROM YOURDATABASE_rpghq140.phpbb_pa_customdata;  #phpbb_pa_download_info  INSERT INTO YOURDATABASE_rpghq141.phpbb_pa_download_info (file_id, user_id, downloader_ip, downloader_os, downloader_browser, browser_version) SELECT file_id, user_id, downloader_ip, downloader_os, downloader_browser, browser_version FROM YOURDATABASE_rpghq140.phpbb_pa_download_info;  #phpbb_pa_files  INSERT INTO YOURDATABASE_rpghq141.phpbb_pa_files (file_id, user_id, poster_ip, file_name, file_size, unique_name, real_name, file_dir, file_desc, file_creator, file_version, file_longdesc, file_ssurl, file_sshot_link, file_dlurl, file_time, file_update_time, file_catid, file_posticon, file_license, file_dls, file_last, file_pin, file_docsurl, file_approved, file_broken) SELECT file_id, user_id, poster_ip, file_name, file_size, unique_name, real_name, file_dir, file_desc, file_creator, file_version, file_longdesc, file_ssurl, file_sshot_link, file_dlurl, file_time, file_update_time, file_catid, file_posticon, file_license, file_dls, file_last, file_pin, file_docsurl, file_approved, file_broken FROM YOURDATABASE_rpghq140.phpbb_pa_files;  #phpbb_pa_license  INSERT INTO YOURDATABASE_rpghq141.phpbb_pa_license (license_id, license_name, license_text) SELECT license_id, license_name, license_text FROM YOURDATABASE_rpghq140.phpbb_pa_license;  #phpbb_pa_mirrors  INSERT INTO YOURDATABASE_rpghq141.phpbb_pa_mirrors (mirror_id, file_id, unique_name, file_dir, file_dlurl, mirror_location) SELECT mirror_id, file_id, unique_name, file_dir, file_dlurl, mirror_location FROM YOURDATABASE_rpghq140.phpbb_pa_mirrors;  #phpbb_pa_votes  INSERT INTO YOURDATABASE_rpghq141.phpbb_pa_votes (user_id, votes_ip, votes_file, rate_point, voter_os, voter_browser, browser_version) SELECT user_id, votes_ip, votes_file, rate_point, voter_os, voter_browser, browser_version FROM YOURDATABASE_rpghq140.phpbb_pa_votes;  #phpbb_posts  INSERT INTO YOURDATABASE_rpghq141.phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, post_icon, post_bluecard, rating_rank_id) SELECT post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, post_icon, post_bluecard, rating_rank_id FROM YOURDATABASE_rpghq140.phpbb_posts;  #phpbb_posts_text  INSERT INTO YOURDATABASE_rpghq141.phpbb_posts_text (post_id, bbcode_uid, post_subject, post_text) SELECT post_id, bbcode_uid, post_subject, post_text FROM YOURDATABASE_rpghq140.phpbb_posts_text;  #phpbb_privmsgs  INSERT INTO YOURDATABASE_rpghq141.phpbb_privmsgs (privmsgs_id, privmsgs_type, privmsgs_subject, privmsgs_FROM_userid, privmsgs_to_userid, privmsgs_date, privmsgs_ip, privmsgs_enable_bbcode, privmsgs_enable_html, privmsgs_enable_smilies, privmsgs_attach_sig, privmsgs_attachment) SELECT privmsgs_id, privmsgs_type, privmsgs_subject, privmsgs_FROM_userid, privmsgs_to_userid, privmsgs_date, privmsgs_ip, privmsgs_enable_bbcode, privmsgs_enable_html, privmsgs_enable_smilies, privmsgs_attach_sig, privmsgs_attachment FROM YOURDATABASE_rpghq140.phpbb_privmsgs;  #phpbb_privmsgs_archive  INSERT INTO YOURDATABASE_rpghq141.phpbb_privmsgs_archive (privmsgs_id, privmsgs_type, privmsgs_subject, privmsgs_FROM_userid, privmsgs_to_userid, privmsgs_date, privmsgs_ip, privmsgs_enable_bbcode, privmsgs_enable_html, privmsgs_enable_smilies, privmsgs_attach_sig) SELECT privmsgs_id, privmsgs_type, privmsgs_subject, privmsgs_FROM_userid, privmsgs_to_userid, privmsgs_date, privmsgs_ip, privmsgs_enable_bbcode, privmsgs_enable_html, privmsgs_enable_smilies, privmsgs_attach_sig FROM YOURDATABASE_rpghq140.phpbb_privmsgs_archive;  #phpbb_privmsgs_text  INSERT INTO YOURDATABASE_rpghq141.phpbb_privmsgs_text (privmsgs_text_id, privmsgs_bbcode_uid, privmsgs_text) SELECT privmsgs_text_id, privmsgs_bbcode_uid, privmsgs_text FROM YOURDATABASE_rpghq140.phpbb_privmsgs_text;  #phpbb_quota_limits  INSERT INTO YOURDATABASE_rpghq141.phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) SELECT quota_limit_id, quota_desc, quota_limit FROM YOURDATABASE_rpghq140.phpbb_quota_limits;  #phpbb_ranks  INSERT INTO YOURDATABASE_rpghq141.phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, rank_image) SELECT rank_id, rank_title, rank_min, rank_max, rank_special, rank_image FROM YOURDATABASE_rpghq140.phpbb_ranks;  #phpbb_rating  INSERT INTO YOURDATABASE_rpghq141.phpbb_rating (post_id, user_id, rating_time, option_id) SELECT post_id, user_id, rating_time, option_id FROM YOURDATABASE_rpghq140.phpbb_rating;  #phpbb_rating_bias  INSERT INTO YOURDATABASE_rpghq141.phpbb_rating_bias (bias_id, user_id, target_user, bias_status, bias_time, post_id, option_id) SELECT bias_id, user_id, target_user, bias_status, bias_time, post_id, option_id FROM YOURDATABASE_rpghq140.phpbb_rating_bias;  #phpbb_rating_option  INSERT INTO YOURDATABASE_rpghq141.phpbb_rating_option (option_id, points, label, weighting, user_type) SELECT option_id, points, label, weighting, user_type FROM YOURDATABASE_rpghq140.phpbb_rating_option;  #phpbb_rating_rank  INSERT INTO YOURDATABASE_rpghq141.phpbb_rating_rank (rating_rank_id, type, average_threshold, sum_threshold, label, icon, user_rank) SELECT rating_rank_id, type, average_threshold, sum_threshold, label, icon, user_rank FROM YOURDATABASE_rpghq140.phpbb_rating_rank;  #phpbb_rating_temp  INSERT INTO YOURDATABASE_rpghq141.phpbb_rating_temp (topic_id, points) SELECT topic_id, points FROM YOURDATABASE_rpghq140.phpbb_rating_temp;  #phpbb_referers  INSERT INTO YOURDATABASE_rpghq141.phpbb_referers (referer_id, referer_host, referer_url, referer_ip, referer_hits, referer_firstvisit, referer_lastvisit) SELECT referer_id, referer_host, referer_url, referer_ip, referer_hits, referer_firstvisit, referer_lastvisit FROM YOURDATABASE_rpghq140.phpbb_referers;  #phpbb_rules  INSERT INTO YOURDATABASE_rpghq141.phpbb_rules (date, rules, pm_subject, pm_message) SELECT date, rules, pm_subject, pm_message FROM YOURDATABASE_rpghq140.phpbb_rules;  #phpbb_search_results  INSERT INTO YOURDATABASE_rpghq141.phpbb_search_results (search_id, session_id, search_array, search_time) SELECT search_id, session_id, search_array, search_time FROM YOURDATABASE_rpghq140.phpbb_search_results;  #phpbb_search_wordlist  INSERT INTO YOURDATABASE_rpghq141.phpbb_search_wordlist (word_text, word_id, word_common) SELECT word_text, word_id, word_common FROM YOURDATABASE_rpghq140.phpbb_search_wordlist;  #phpbb_search_wordmatch  INSERT INTO YOURDATABASE_rpghq141.phpbb_search_wordmatch (post_id, word_id, title_match) SELECT post_id, word_id, title_match FROM YOURDATABASE_rpghq140.phpbb_search_wordmatch;  #phpbb_serverload  INSERT INTO YOURDATABASE_rpghq141.phpbb_serverload (time) SELECT time FROM YOURDATABASE_rpghq140.phpbb_serverload;  #phpbb_sessions  INSERT INTO YOURDATABASE_rpghq141.phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_robot, session_admin) SELECT session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_robot, session_admin FROM YOURDATABASE_rpghq140.phpbb_sessions;  #phpbb_sessions_keys  INSERT INTO YOURDATABASE_rpghq141.phpbb_sessions_keys (key_id, user_id, last_ip, last_login) SELECT key_id, user_id, last_ip, last_login FROM YOURDATABASE_rpghq140.phpbb_sessions_keys;  #phpbb_smilies  INSERT INTO YOURDATABASE_rpghq141.phpbb_smilies (smilies_id, code, smile_url, emoticon) SELECT smilies_id, code, smile_url, emoticon FROM YOURDATABASE_rpghq140.phpbb_smilies;  #phpbb_stats_smilies_index  INSERT INTO YOURDATABASE_rpghq141.phpbb_stats_smilies_index (code, smile_url, smile_count) SELECT code, smile_url, smile_count FROM YOURDATABASE_rpghq140.phpbb_stats_smilies_index;  #phpbb_stats_smilies_info  INSERT INTO YOURDATABASE_rpghq141.phpbb_stats_smilies_info (last_post_id, last_update_time, update_time) SELECT last_post_id, last_update_time, update_time FROM YOURDATABASE_rpghq140.phpbb_stats_smilies_info;  #phpbb_topics  INSERT INTO YOURDATABASE_rpghq141.phpbb_topics (topic_id, forum_id, topic_title, topic_desc, topic_poster, topic_time, topic_views, topic_replies, topic_status, topic_info, topic_vote, topic_type, topic_first_post_id, topic_last_post_id, topic_moved_id, topic_attachment, news_id, topic_announce_duration, topic_calendar_time, topic_calendar_duration, topic_icon, topic_calendar_repeat, rating_rank_id) SELECT topic_id, forum_id, topic_title, topic_desc, topic_poster, topic_time, topic_views, topic_replies, topic_status, topic_info, topic_vote, topic_type, topic_first_post_id, topic_last_post_id, topic_moved_id, topic_attachment, news_id, topic_announce_duration, topic_calendar_time, topic_calendar_duration, topic_icon, topic_calendar_repeat, rating_rank_id FROM YOURDATABASE_rpghq140.phpbb_topics;  #phpbb_topics_watch  INSERT INTO YOURDATABASE_rpghq141.phpbb_topics_watch (topic_id, user_id, notify_status) SELECT topic_id, user_id, notify_status FROM YOURDATABASE_rpghq140.phpbb_topics_watch;  #phpbb_users  INSERT INTO YOURDATABASE_rpghq141.phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_setbm, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_skype, user_occ, user_interests, user_actkey, user_newpasswd, user_realname, user_gender, user_birthday, user_last_birthday, user_home_phone, user_home_fax, user_work_phone, user_work_fax, user_cellular, user_pager, user_summer_time, user_list_option, user_allow_email, user_allow_website, user_allow_messenger, user_allow_real, user_allow_sig, user_viewpm, user_viewwebsite, user_viewmessenger, user_viewreal, user_viewavatar, user_viewsig, user_viewimg, user_buddy_friend_display, user_buddy_ignore_display, user_buddy_friend_of_display, user_buddy_ignored_by_display, user_watched_topics_per_page, user_privmsgs_per_page, user_sub_forum, user_split_cat, user_last_topic_title, user_sub_level_links, user_display_viewonline, user_announcement_date_display, user_announcement_display, user_announcement_display_forum, user_announcement_split, user_announcement_forum, user_calendar_display_open, user_calendar_header_cells, user_fdow, user_calendar_nb_row, user_calendar_birthday, user_calendar_forum, user_last_topics_from_started, user_last_topics_from_replied, user_last_topics_from_ended, user_last_topics_from_split, user_last_topics_from_forum, user_split_global_announce, user_split_announce, user_split_sticky, user_split_topic_split, user_points, user_unread_topics, user_topics_last_per_page, user_flag, user_holidays, user_warnings, user_rules, rating_status, user_photo, user_extra, user_allowsignature, user_actviate_date, user_expire_date, user_inactive_emls, user_inactive_last_eml, user_state, user_country, phpBBSecurity_answer, phpBBSecurity_question, phpBBSecurity_login_tries, phpBBSecurity_pm_sent, user_login_tries, user_last_login_try) SELECT user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_setbm, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_skype, user_occ, user_interests, user_actkey, user_newpasswd, user_realname, user_gender, user_birthday, user_last_birthday, user_home_phone, user_home_fax, user_work_phone, user_work_fax, user_cellular, user_pager, user_summer_time, user_list_option, user_allow_email, user_allow_website, user_allow_messenger, user_allow_real, user_allow_sig, user_viewpm, user_viewwebsite, user_viewmessenger, user_viewreal, user_viewavatar, user_viewsig, user_viewimg, user_buddy_friend_display, user_buddy_ignore_display, user_buddy_friend_of_display, user_buddy_ignored_by_display, user_watched_topics_per_page, user_privmsgs_per_page, user_sub_forum, user_split_cat, user_last_topic_title, user_sub_level_links, user_display_viewonline, user_announcement_date_display, user_announcement_display, user_announcement_display_forum, user_announcement_split, user_announcement_forum, user_calendar_display_open, user_calendar_header_cells, user_fdow, user_calendar_nb_row, user_calendar_birthday, user_calendar_forum, user_last_topics_from_started, user_last_topics_from_replied, user_last_topics_from_ended, user_last_topics_from_split, user_last_topics_from_forum, user_split_global_announce, user_split_announce, user_split_sticky, user_split_topic_split, user_points, user_unread_topics, user_topics_last_per_page, user_flag, user_holidays, user_warnings, user_rules, rating_status, user_photo, user_extra, user_allowsignature, user_actviate_date, user_expire_date, user_inactive_emls, user_inactive_last_eml, user_state, user_country, phpBBSecurity_answer, phpBBSecurity_question, phpBBSecurity_login_tries, phpBBSecurity_pm_sent, user_login_tries, user_last_login_try FROM YOURDATABASE_rpghq140.phpbb_users;  #phpbb_user_group  INSERT INTO YOURDATABASE_rpghq141.phpbb_user_group (group_id, user_id, user_pending, group_moderator) SELECT group_id, user_id, user_pending, group_moderator FROM YOURDATABASE_rpghq140.phpbb_user_group;  #phpbb_vote_desc  INSERT INTO YOURDATABASE_rpghq141.phpbb_vote_desc (vote_id, topic_id, vote_text, vote_start, vote_length, vote_max, vote_voted, vote_hide, vote_tothide) SELECT vote_id, topic_id, vote_text, vote_start, vote_length, vote_max, vote_voted, vote_hide, vote_tothide FROM YOURDATABASE_rpghq140.phpbb_vote_desc;  #phpbb_vote_results  INSERT INTO YOURDATABASE_rpghq141.phpbb_vote_results (vote_id, vote_option_id, vote_option_text, vote_result) SELECT vote_id, vote_option_id, vote_option_text, vote_result FROM YOURDATABASE_rpghq140.phpbb_vote_results;  #phpbb_vote_voters  INSERT INTO YOURDATABASE_rpghq141.phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) SELECT vote_id, vote_user_id, vote_user_ip FROM YOURDATABASE_rpghq140.phpbb_vote_voters;  #phpbb_words  INSERT INTO YOURDATABASE_rpghq141.phpbb_words (word_id, word, replacement) SELECT word_id, word, replacement FROM YOURDATABASE_rpghq140.phpbb_words;  #phpbb_wpm  INSERT INTO YOURDATABASE_rpghq141.phpbb_wpm (name, value) SELECT name, value FROM YOURDATABASE_rpghq140.phpbb_wpm;  
Last edited by Dioncecht on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
'We keep moving forward, opening new doors, and doing new things, because we're curious and curiosity keeps leading us down new paths.' - Walt Disney

[img=left]http://rpghq.org/banner2.jpg[/img]
[url=http]The RPG Headquarters. The RPG capitol of the net![/url]
User avatar
Dioncecht
Sr Integra Member
Sr Integra Member
 
Posts: 244
Likes: 0 post
Liked in: 0 post
Joined: Sun Apr 09, 2006 4:23 pm
Cash on hand: 0.00

Re: 141 feedback

PostAuthor: sirap » Fri Jan 19, 2007 6:28 pm

Hi, I just upgrade from 140 to 141...I've followed the instruction from 132_and_140_update_to_141.zip.

Then I got this Crictical Error :
Code: Select all
Critical Error!message_die() was called multiple times.  Error #1    Line : 60File : /usr/local/www/apache22/data/integrmod141/ctracker/classes/class_ct_database.php SQL : SELECT * FROM phpbb_ctracker_config  Error #2 Could not add key sub_forum in config table  Line : 55File : /usr/local/www/apache22/data/integrmod141/includes/functions_mods_settings.php SQL : INSERT INTO phpbb_config (config_name,config_value) VALUES('sub_forum','1')  

Please help me..
Last edited by sirap on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.

sirap
Newbie
Newbie
 
Posts: 10
Likes: 0 post
Liked in: 0 post
Joined: Sat Apr 15, 2006 7:25 pm
Cash on hand: 0.00

PreviousNext

Return to IntegraMOD 141

Who is online

Registered users: Bing [Bot], Google [Bot], Helter, Majestic-12 [Bot]