IntegraMOD

Please post any feedback you may have on the release version of IntegraMOD141 here. Thank you, The IntegraMOD Team

I am just so glad to see that it has been released!

I haven't had a chance to implement, but am sitting on pins and needles waiting until I am able to.

To all who were involved in development and testing - Thank you for all the hard work!

just a question, in the announcement it says

IntegraMOD 1.4.1 is a modded version of the latest stable release from phpBB, which is phpBB 2.0.21.

the latest version of phpBB is 2.0.22, was this a typo?

Well done everyone who has worked so hard on getting this released.

"cleo";p="19523" wrote:just a question, in the announcement it says

IntegraMOD 1.4.1 is a modded version of the latest stable release from phpBB, which is phpBB 2.0.21.

the latest version of phpBB is 2.0.22, was this a typo?

lol...yes this is a typo, and that is why we were glad to have on the beta testing team <img>

"gffb";p="19525" wrote:Well done everyone who has worked so hard on getting this released.

yes, i think everyone did a great job getting this version released.

"HelterSkelter";p="19526" wrote:

"cleo";p="19523" wrote:just a question, in the announcement it says

IntegraMOD 1.4.1 is a modded version of the latest stable release from phpBB, which is phpBB 2.0.21.

the latest version of phpBB is 2.0.22, was this a typo?

lol...yes this is a typo, and that is why we were glad to have on the beta testing team but knew you would get alot of questions about it if it was not addressed <img>

Thank you IntegraMOD Team for the hard work

Congrats everyone on getting this version completed.

couple of things I noticed
In the Install Doc, under the CHMOD section, I couldn't find the following files/directories:
cgi-bin/tmp
includes/def_*.php
modules/cache
modules/cache/explain
pafiledb/cache/templates/XXXXXX/admin

also, in the download file, everything is duplicated. It is all in the root (seperated correctly into respective subfolders) and under a subfolder called IM141. Of course this makes the download file 23MB instead of 11MB...

But it looks great!!!! Thanks to the entire Dev and Beta Teams hard work.

You beat me Dragonsys was just about to mention the repeat folder.... <img>

A question?

In the download there is an upgrade folder that states the following.

Step 2.
Upload all files from the IntegraMOD 1.4.1 package...
Note: this package SHOULD NOT contain a copy of config.php or any prill files or directories (check to ensure).

These files are included and could lead to complications when people overwright there config.php it might be worth have a full version and a download version to avoid problems later.

Perhaps this text

It is also advisable to remove all installed styles and re install them. Also remember to sync you forums as you may to see them otherwise...

Should be put at the top of the upgrade instructions in case errors occur

Also on the portal page of this site it says

Download IntegraMOD 1.4.1 latest beta

Are we releasing a beta version or is the a full release version not in beta?

It appears that there may have been an old version of 141 already on Source Forge, because I just dl'd it and it is not the file I uploaded. I have updated the dl link to point to our local dl directory and the correct file. I appologize for the inconvenience to the 30 users who dl'd the wrong file

I've released the IntegraMOD 1.4.1 port of Advanced Group Color Management. It is highly recommended that if you're going to install this that you install it before installing any other MODs, so that you can use the premodded files. It's a biggy...

http://www.integramod.com/forum/viewtop ... 9536#19536

upgrade instructions have disappeared ? <img>
can find it in the Last Updated Wed 17 Jan 2007, 2:08

i don't see upgrade instructions either, and the rev text says

IntegraMOD 1.4.1 Beta Revision 1

April 21st, 2006

There were upgrade instructions on the first download.... is that the same as what I need to use for this updated download location?

I'm going to install a fresh version of 141 for a new project I'm working on, but I have a few forums that I'd like to test this upgrade path on.

Zac

dont use the updgrade info from the first dl because im not sure of its origin.

I'm sorry, but this is very confusing. I downloaded the 1.4.1 version from the download section of this site, but many files contain information stating "beta version"...

... plus there is no information on upgrade procedure. Can we upgrade from 1.4.0 to 1.4.1 ??

Thanks,

sanji

Updates are available in the downloads section. I'm having a few technical difficulties and haven't posted in the official release post yet. But, they are ready for download.

If you have the current download, please ignore any beta messages right now. If you're not sure you have the correct version, please redownload now. The current download is up to date and only the documentation should have any mention of beta, function of the board won't be affected.

I didn't catch all the beta messages before release. I've found the one in the install instructions which I forgot to remove, where are the others?

I removed the references to the beta from the _install_instuctions/integramod_install_guide_page1.html
so if your version says Beta in the header of this file then you should re-download

Wow, beta team is getting after it here

my board currently running IM1.40 with phpbb 2.0.21..
I've downloaded both files (132_and_140_update_to_141.zip & phpbb_to_im141.zip).

Which files should I install first?

download the IM 141 files from the download section sirap, and use the 132_and_140_update_to_141 instructions.

thank you cleo.

I have updated my 1.4.0 to 1.4.1 successfully.

As of right now, I see no errors.

One thing that might be worth mentioning in the install instructions is that when you are running the upgrade SQL .script, it took around 5 minutes and I thought early on that it might have stopped responding. I can envision a lot of people being impatient and closing the screen before the .script has finished running.

Outside of that, everything looks great. I will be uploading my theme now and checking everything over again <img>

THANKS GUYS!

Zac

whoah, found an error.

When viewing the "forum" page, I get these errors and the forums do not show:


Warning: main(./mods/netclectic/mini_cal/mini_cal_.php): failed to open stream: No such file or directory in /home/crunderg/public_html/mods/netclectic/mini_cal/mini_cal.php on line 80

Warning: main(): Failed opening './mods/netclectic/mini_cal/mini_cal_.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/crunderg/public_html/mods/netclectic/mini_cal/mini_cal.php on line 80

Fatal error: Call to undefined function: getminicalforumsauth() in /home/crunderg/public_html/mods/netclectic/mini_cal/mini_cal.php on line 83

Any ideas? I've checked and all those files are there...they do exist. I even tried re-uploading them. Nothin..

Zac

A follow-up to my last post,

I replaced all the files in the "mods/netclectic/mini_cal/" with the files I had in a backup from before I upgraded to 1.4.1 and this at least works as a band-aid because now my forums are showing.

New problem: CrackerTracker is not letting me alter my forum configuration. I was trying to disable to board when I noticed there was an error, but I kept getting a crackertracker error message telling me they suspected a worm or something.

Zac

The mini_cal files weren't changed from 1.4.0 version. Probably was just a corrupt file. You should be good with those files.

CrackerTracker blocking you is actually a feature, I know I know, some feature if it blocks me from performing admin duties... but, I'm writing up a knowledge base article on how to deal with this issue. It will block differently depending on what you've input in the fields. It probably doesn't like something in your domain name or something else that is specific to your site, as I didn't get blocked adding anything to this site. So, people will run into this problem from time to time, and since all forum information is different from site to site, we'll see different vars that need to be unblocked. The knowledge base article I'm writing will show you how to unblock those vars using CrackerTracker's debug mode.

I'll post it when it's finished.

Thanks Teelk,

One last issue that really has me stumped...

I went into extreme templates and clicked to install "Fisubice_Black" theme. When I clicked on that, I started getting this error:

phpBB : Critical Error

Could not get theme data for themes_id [1]

I'm digging through my phpmyadmin trying to figure this out but nothing I try seems to work. This causes everything to be inaccessible on the site.

Zac

Nevermind. I'm not completely sure why this is a problem (installing new themes) but if this happens to anyone, re-upload this file from the 141 download:

includes/def_themes.php

That will do the trick.

Zac

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'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.

"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.

KB Article about how to change CrackerTracker to unblock pages.

http://www.integramod.com/forum/kb.php? ... ticle&k=22

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

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

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>

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>

I have updated my 1.4.0 to 1.4.1 successfully.

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

Great Work

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 ?

"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.

"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.

"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;  

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

Thanks Teelk and Dioncecht for those information. No chance so far with the update.

First, I copied a fresh version of the 1.4.1 files on a test server, run the installation .script, deleted the newly created 1.4.1 database, uploaded my 1.4.0 database and tried to run the update .script. I got the following error message : "I am sorry, but your database type is not supported."

Then I tried to use the .script written by Dioncecht. Apart from some problems (my host does not allow to copy from one database to another), I finally could change a little the .script after copying all 1.4.0 tables with a temporary name (old_TABLENAME) in the same database as the 1.4.1 tables. But when I run the .script, I get on most of the tables the error "entry already exists". If I first empty the 1.4.1 tables, I obviously would loose data (for example, the new config table is larger than the 1.4.0 one)...

Any idea on how to proceed?

I am thinking of giving up the upgrade, as it seems that it will require too much troubles... I am afraid that if just copying the old database into the new one is co complicated, then adding all mods again might prove much too difficult...

Thanks for your help,

sanji

I agree

"sirap";p="19841" wrote: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..

I found the answer at
http://www.integramod.com/forum/viewtop ... d+multiple

I changed the permission for config to 666 as mentioned by Teelk then rerun the db_update_to_141.php .script.
It seems to be ok...for now...

Thanks anyway.

ok, having a blond moment here, where do you enable gzip?

acp/general admin/configuration/ Enable GZip Compression - yes

ACP
General Admin
Configuration
Right above the Logo Setting

(I'm too slow)

wow, i really am getting tired eyes, i looked there and could not see it

it is not always there. Ive noticed that it disappears when your tired, or you really need it quickly <img>

:[quote=""HelterSkelter";p="19872""]
it is not always there. Ive noticed that it disappears when your tired, or you really need it quickly ya think so?

Can anyone point me in the direction of a list of differences between 1.4.0 and 1.4.1 please? Is it just an update of security and stability or are there new features and mods?


Also, the link on the homepage to this topic ("For questions, comments and feedback, please post here." ) has a broken URL which seems to be because some of the address is duplicated:

http://www.integrmod.com/html/www.integra ... hp?p=19520

i think Teelk explained about the "differences" here

http://integramod.com/forum/viewtopic.php?p=19572#19572

just off the top of my head there was

the crackertracker
the lo-fi
the advanced visual confirmation
the cash mod
the full album pak
the KB was updated
the advanced bbcode mod

and i am sure there is lots that i don't remember
not to mention thousands of other code changes.

edit - oops.

I thank the Devs for their hard work on this project but I will never be upgrading to 141. The development of Integramod has gone in a direction I do not wish to follow.
All I wanted was bug fixes and updates to what I had and with all the changes got more hassle than I wish to deal with.

"Neva";p="19975" wrote:I thank the Devs for their hard work on this project but I will never be upgrading to 141. The development of Integramod has gone in a direction I do not wish to follow.
All I wanted was bug fixes and updates to what I had and with all the changes got more hassle than I wish to deal with.

There are a lot of improvements and updates with the upgrade, and though I won't try to talk you into upgrading, I just hope you know that there are a lot of us here that would be more than willing to help you along the way and solve any problems you might run across.

"cleo";p="19892" wrote:i think Teelk explained about the "differences" here

http://integramod.com/forum/viewtopic.php?p=19572#19572

just off the top of my head there was

the crackertracker
the lo-fi
the advanced visual confirmation
the cash mod
the full album pak
the KB was updated
the advanced bbcode mod

and i am sure there is lots that i don't remember
not to mention thousands of other code changes.

Thanks for the help Cleo, but I can't see list of differences - is this the right link?

I can't seem to save my knowledge Base configuration. I make the changes just fine and it looks like it saved and everything but when I go back in and look, everything is the still at the default and nome of my changes took place. I changed admin/admin_kb_config.php to 666, still nothing, and then 777, and still didn't do it.

What am i missing here?

After going through the initial trauma of dealing with Cracker Tracker, deciding I hate it, then deciding that if I hate it, then anyone trying to hack my site will hate it more than I do, I finally calmed down enough from my insane bout of frustration enough tro think rationally.

So far I like very much, just kind of frustrating dealing with CT, and dealing with my knowledge Base that doesn't work (still broke). It seem to run faster and smoother and I keep finding these little new things that I am totally digging. Great job guys, just a little bumpy with CT, but I'm sure everything will eventually work itself out.

I submitted a ticket (started a thread) in the help section for the KB thing. I'm sure it's somethng to do with copying my databases over or a CHMOD issue and not a problem with 1.4.1 itself.

Kudos guys.. <img>

I've got some failures will post them later


i have updated from itegramod 1.4.0 phpbb 2.0.2.22 with the update .script

one failure was a missing the last column in album

...

another bug???

i have added the above code in the php BBCODE !

is this another bug here?

order of phpbb_auth_access
wasn't create right

i have fixed with that ...

Code: Select all

create table phpbb_auth_access_neu as (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 phpbb_auth_access);ALTER TABLE `phpbb_auth_access_neu` ADD INDEX `group_id` ( `group_id` );ALTER TABLE `phpbb_auth_access_neu` ADD INDEX `forum_id` ( `forum_id` );drop table phpbb_auth_access;ALTER TABLE phpbb_auth_access_neu RENAME phpbb_auth_access;

i have a lot of mysql errors... there are columns that were not created any hints?


FU. dont do that !!!


IS there a DOWNGRADING .script??????
OR plz post me howto upgrade from 1.4.0 phpbb 22 to integrmod 1.41. 22
PLEASE

making new thread

Firstly..... [flash=,:2l6jb5pb]http://img263.imageshack.us/img263/2918/emotions4ex3.gif[/flash:2l6jb5pb] thanks guys loving the new upgrade... Ctracker was a pain at first but once we figured out the debug mode that was cool... and reading the Ctracker site in german was entertaining if nothing else...

And yeah we downloaded and installed all the mods we have from scratch... which took some time.. but as yet we have had no problems, not like huge problems we had a tiny issue with Teelk's forum text colour mod, but Methos looked at the mod.. and it turns out a variable was renamed in the new version once he renamed it it works fine yippeeeee!!!

... no issues everything seems to be rolling over nicely since we downloaded it on the 19th so much love and have lots of Kudos guys.

$this to $ch_this in includes/functions_categories_hierarchy.php... I'm working my way through my MODs, haven't hit this one yet, but I'm assuming that was the problem.

Glad things are workin' out for you.

I just wanted to say that you guys did a great job with IM 1.4.1!!!

The initial update was a little frustrating, but after figuring out how to get my ACP functioning again, and how to work with Cracker Tracker on my site, everything seems to be going good.

Pages seem to load twice as fast, and dont seem to hang (unless Im Debugging).

Some members of my site have even commented on how they like the update.

Good Job!!!

I don't think this is a IM problem... I did notice Helter said some people had jumped the gun too fast with downloads of the IM 1.4.1 and was wondering if there is a way he (being a darling can check the download list to see if we have one. the IP it would have been downloaded on is this 24.81.101.35.)

Tell you why.. up till last night IM was working fine no hitches no problems nothing like some people were reporting... it was in perfectly good working order.. then something happened and I don't know what.. but the result is we have the googlebot sending out PMs... yeah I know that sounds totally bizarre but the ip is the googlebot and user is anonymous.. trouble is Mr googlebot messages are obviously from someone.. in one it goes on to say that *they don't want to be called because they are having a relationship with someone on the board and it is inappropriate.* Which you know amused me.. who is having a fling with the googlebot I wonder. lol But it is not funny really that someone is sending what they think are private messages that are being sent to users wily nily so far I have 6 users with that pm.. another batch of pm's that looked like I sent but I have no recollection of sending them, and the best one by far every member is receiving phpbb security updates.

So I think this is a database table error as opposed to a IM error...

the other thing.. yep another.. my daily backup are a complete mess.. anyone speak klingon? cos that is what they look like.

like I said we had no problems until last night.. at the moment I have the whole board disabled and well I don't really know what to do.

check in phpmyadmin that your founder account is still set to user id#2 and that Anonymous is set to #-1 and inactive=0

you might also check with your host to see if they ave made any software udates

I'd also check the crackertracker logs for any suspicious looking activity. That definitely sounds like an intentional malfunction.

I cannot set my security question and stuff after installing the board, CrackerTracker says have made a security exploit attempt, what do i do, i do have access to the ACP though, if that helps

Follow [url=http]this[/url] KB article.

ok the 'phpBBSecurity_answer' is missing from the $ignorepvars array

here is what it should look like (so far, lol)

$ct_ignorepvar = array('helpbox', 'delete', 'deleteall', 'phpBBSecurity_question', 'phpBBSecurity_answer', 'user_interests');

I have this message:
--------------------------------------------------------
phpBB : Critical Error

Could not open Integra2 template config file

DEBUG MODE

Line : 1155
File : functions.php

---------------------------------------------------------
....all the three times (the first time was an update from 1.4.0) that I tried to install 1.4.1 right after the end of the installation.

How can I fix this

Warning: main(./mods/netclectic/mini_cal/mini_cal_.php) [function.main]: failed to open stream: No such file or directory in /home/cowoneon/www/forums/mods/netclectic/mini_cal/mini_cal2.php on line 82

Warning: main() [function.include]: Failed opening './mods/netclectic/mini_cal/mini_cal_.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/cowoneon/www/forums/mods/netclectic/mini_cal/mini_cal2.php on line 82

Fatal error: Call to undefined function: getminicalforumsauth() in /home/cowoneon/www/forums/mods/netclectic/mini_cal/mini_cal2.php on line 85

Just quickly wanted to mention that I had to get the "phpbbintegramod.jpg" with the "1.41" on it of this website, as the installer still includes the picture of the 1.40 version <img>

I thought I had replaced that at one time. Thx for the heads up

Tried to download 141 but it fails

No probs with the other 2 downloads in th e 141 area

Any suggestions where or how to get the full install?

rollo

Something's amiss...

Upon clicking 'I agree' I get the following:

Forbidden
You don't have permission to access /forum/pafiledb/uploads/4705d458268baef2432b0afac12bdd4e.zip on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

That's more detailed what I wrote above

i just successfully downloaded several files, including integramod141