Sub Menu
Links Menu
Online Users

In total there are 307 users online :: 3 registered, 0 hidden and 304 guests

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

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

A content Migration Question

Support for IntegraMOD 141

Moderator: Integra Moderator

A content Migration Question

PostAuthor: stokes » Fri Nov 20, 2009 9:02 pm

I have a site (non integramod) running phpbb 2.0.18. It's been up and running for a long time and has a lot of posts/users/etc. I have recently loaded and have been configuring an Integramod 1.4.1 with phpbb 2.0.23 on the same server (linux) in a different directory. Both are up and running fine. Can you give me some help or point me at some instructions on how to migrate the posts/users/ et. from the old non integramod site into the new integramod site. Thanks in advance for your help.

stokes
Newbie
Newbie
 
Posts: 27
Likes: 0 post
Liked in: 0 post
Joined: Mon Nov 16, 2009 1:54 pm
Cash on hand: 0.00

Re: A content Migration Question

PostAuthor: CaNNon » Sat Nov 21, 2009 6:04 am

IF: you have no mods you can just update the old site to phpbb 2.0.23 http://sourceforge.net/projects/phpbb/files/phpBB%202/phpBB%20v2.0.23/phpBB-2.0.23.zip/download Then Back up the data base and bring the old DB into the new install. But if the data base is over 2 megs you need to get bigdump http://www.ozerov.de/bigdump.php
install it as directed put your DB in the dump folder and run bigdump.

IF: you have mods installed it's best to list them here and give Helter a chance to see this in case of a conflict, as those mods may need to be pre installed to work. As the import will over wright existing tables make sure the default phpbb2 table names are the same in both installs.

You can also Just choose the default phpbb2 tables and only import that data in case of a mod conflict.
Image
Image
User avatar
CaNNon
Sr Integra Member
Sr Integra Member
 
Posts: 750
Likes: 0 post
Liked in: 0 post
Joined: Thu Apr 19, 2007 11:15 am
Cash on hand: 0.00

Re: A content Migration Question

PostAuthor: stokes » Sat Nov 21, 2009 12:25 pm

Just to make sure I understand, I would upgrade the old instance(that does not have integramod -I assume this would make some database changes). Then I would take a backup from the old instance I just upgraded and restore it into the new instance (wth integramod). Then my new instance with integrmod would have the data from the original instance. I assume I could delete the PHPBB instance I just upgraded?

I assume also that it would not work to just restore a database backup from the non-integramod site into the new integramod site.

BTW, I have no mods. Thanks again for your help and time.

stokes
Newbie
Newbie
 
Posts: 27
Likes: 0 post
Liked in: 0 post
Joined: Mon Nov 16, 2009 1:54 pm
Cash on hand: 0.00

Re: A content Migration Question

PostAuthor: CaNNon » Sat Nov 21, 2009 12:44 pm

Yea update the old one, the sql script will look after tables and schema. Then you should have no problems importing as the versions match.

I assume also that it would not work to just restore a database backup from the non-integramod site into the new integramod site
well that's what we're up too, but sql tables and schema need to match if you want a trouble free update. <img>
Image
Image
User avatar
CaNNon
Sr Integra Member
Sr Integra Member
 
Posts: 750
Likes: 0 post
Liked in: 0 post
Joined: Thu Apr 19, 2007 11:15 am
Cash on hand: 0.00

Re: A content Migration Question

PostAuthor: stokes » Sat Nov 21, 2009 10:38 pm

Ok, good news and bad news. I got the old site updated and it works fine with the 2.0.23 version of PHPBB. I took the backup and restored it with big dump. When I go to the new site where I restored the DB, I get this error..

Could not obtain topics information

DEBUG MODE

SQL Error : 1054 Unknown column 't.topic_calendar_time' in 'where clause'

SELECT t.*, p.poster_id, p.post_username, p.enable_bbcode, p.enable_html, p.enable_smilies, u.username, pt.post_text, pt.bbcode_uid, lp.poster_id AS lp_poster_id, lu.username AS lp_username, lp.post_username AS lp_post_username, lp.post_time AS lp_post_time FROM phpbb_topics AS t, phpbb_posts AS p, phpbb_posts_text AS pt, phpbb_users AS u, phpbb_posts AS lp, phpbb_users lu WHERE t.forum_id IN (1) AND p.post_id = t.topic_first_post_id AND pt.post_id = t.topic_first_post_id AND u.user_id = p.poster_id AND lp.post_id = t.topic_last_post_id AND lu.user_id = lp.poster_id AND t.topic_calendar_time <1259388000>= 1258783200 AND t.topic_status <> 2 ORDER BY t.topic_calendar_time, t.topic_calendar_duration DESC, t.topic_last_post_id DESC

Line : 398
File : functions_calendar.php


It then thows me to the old site to log in. Any Ideas?

stokes
Newbie
Newbie
 
Posts: 27
Likes: 0 post
Liked in: 0 post
Joined: Mon Nov 16, 2009 1:54 pm
Cash on hand: 0.00

Re: A content Migration Question

PostAuthor: Helter » Sun Nov 22, 2009 12:27 am

did you adjust config.php to point to the new database? Also youll have to update your database.
open phpbb_config, find and edit
cookie_path: "/forum" (if in your web root "/")
cookie_domain]integramod.com[/color]"
script_path: "/forum/" (if in your web root "/")
server_name" ( full domain name) "www.integramod.com"

Note* the red text is our settings for reference. Do not include the quotes.
Always use Protection
Image


Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4167
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Sat Mar 11, 2006 3:46 pm
Cash on hand: 172.60
Location: Seattle Wa
IntegraMOD version: IM 3

Re: A content Migration Question

PostAuthor: stokes » Sun Nov 22, 2009 8:51 am

I did all of that and it didn't change anything...Still getting same error. See Below
Last edited by stokes on Sun Nov 22, 2009 9:09 am, edited 1 time in total.

stokes
Newbie
Newbie
 
Posts: 27
Likes: 0 post
Liked in: 0 post
Joined: Mon Nov 16, 2009 1:54 pm
Cash on hand: 0.00

Re: A content Migration Question

PostAuthor: stokes » Sun Nov 22, 2009 9:08 am

Ok - More information shows that the SQL script pulled from the newly updated (but not integramoded site) dosen't have 9 fields that are in the Integramod database - in the phpbb_topics table - amoung them, the afore mentioned date reflected in the SQL error. I guess the question now is "Are there PHPBB2 2.0.23 basic tables supposed to match the Intgramod141 tables?

stokes
Newbie
Newbie
 
Posts: 27
Likes: 0 post
Liked in: 0 post
Joined: Mon Nov 16, 2009 1:54 pm
Cash on hand: 0.00

Re: A content Migration Question

PostAuthor: CaNNon » Sun Nov 22, 2009 10:12 am

"Are there PHPBB2 2.0.23 basic tables supposed to match the Intgramod141 tables?


It's phppbb basic + IM tables.
Image
Image
User avatar
CaNNon
Sr Integra Member
Sr Integra Member
 
Posts: 750
Likes: 0 post
Liked in: 0 post
Joined: Thu Apr 19, 2007 11:15 am
Cash on hand: 0.00

Re: A content Migration Question

PostAuthor: stokes » Sun Nov 22, 2009 11:29 am

I'm sorry, now Im getting confused,,, Did I not install the right thing? What is it that will add these new fields so I can import the data from my non-integramod into my integramod. The whole idea is to import the users, posts, etc into my juzzy portal site.

stokes
Newbie
Newbie
 
Posts: 27
Likes: 0 post
Liked in: 0 post
Joined: Mon Nov 16, 2009 1:54 pm
Cash on hand: 0.00

Re: A content Migration Question

PostAuthor: CaNNon » Sun Nov 22, 2009 12:16 pm

Could you go over what you did step by step in the same order?
Image
Image
User avatar
CaNNon
Sr Integra Member
Sr Integra Member
 
Posts: 750
Likes: 0 post
Liked in: 0 post
Joined: Thu Apr 19, 2007 11:15 am
Cash on hand: 0.00

Re: A content Migration Question

PostAuthor: Helter » Sun Nov 22, 2009 12:21 pm

upgrading from phpBB2.x to IM141 requires this
http://www.integramod.com/forum/downloa ... l&df_id=49
there is a readme file that will explain how to do this
Always use Protection
Image


Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4167
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Sat Mar 11, 2006 3:46 pm
Cash on hand: 172.60
Location: Seattle Wa
IntegraMOD version: IM 3

Re: A content Migration Question

PostAuthor: stokes » Sun Nov 22, 2009 8:29 pm

Ok, in order to simplify things, I got everything restored and working properly without the IM's. Life was good, two sites (one prod) and one for my testing. THey are poth phpbb2.0.23 each has it's own Database and each has a full compliment of data (posts/users/etc.)

Just to clarify what I'm trying to accomplish is to add the mods to my test site and have all of the existing data migrated as part of the process. (I have been able to install the IM's into a empty database - but converting that much data is a pain.

Anyway, I downloaded the PHP to IM141.zip you guys recommended. I followed the directions very carefully.

When I ran the upgrade.php, it gave me the following:

Information
Database type :: mysql4
Previous version :: 2.0.23
Updated version :: 2.0.22

Updated IM version :: 1.4.1

Updating database schema
Progress :: No updates required

Updating to IntegraMOD2 1.4.1
Progress :: No updates were required

Migrating Personal Albums


And then it just stopped.

When I try to log onto the system, I get:

Critical Error!
message_die() was called multiple times.

--------------------------------------------------------------------------------
Error #1


Line : 60
File : /home/mtdr/html/phpBB21/ctracker/classes/class_ct_database.php
SQL : SELECT * FROM phpbb_ctracker_config

--------------------------------------------------------------------------------
Error #2
Could not add key sub_forum in config table

Line : 55
File : /home/mtdr/html/phpBB21/includes/functions_mods_settings.php
SQL : INSERT INTO phpbb_config (config_name,config_value) VALUES('sub_forum','1')

--------------------------------------------------------------------------------
Please, contact the webmaster. Thank you.
--------------------------------------------------------------------------------

I checked the config.php file and it has username and password. It looks like the conversions didn't run. HELP PLEASE!

stokes
Newbie
Newbie
 
Posts: 27
Likes: 0 post
Liked in: 0 post
Joined: Mon Nov 16, 2009 1:54 pm
Cash on hand: 0.00

Re: A content Migration Question

PostAuthor: Helter » Sun Nov 22, 2009 9:49 pm

did you set all your file permissions (chmods)?
http://www.integramod.com/forum/web.php ... install_p1
Always use Protection
Image


Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4167
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Sat Mar 11, 2006 3:46 pm
Cash on hand: 172.60
Location: Seattle Wa
IntegraMOD version: IM 3

Re: A content Migration Question

PostAuthor: stokes » Mon Nov 23, 2009 6:52 am

yes

stokes
Newbie
Newbie
 
Posts: 27
Likes: 0 post
Liked in: 0 post
Joined: Mon Nov 16, 2009 1:54 pm
Cash on hand: 0.00

Next

Return to IntegraMOD 141

Who is online

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