IntegraMOD

Your phpBB Version: 2.0.22
phpBB Type: Integramod 141
MODs: No
Your knowledge: Basic Knowledge
Board URL: http://www.knee-draggers.com

PHP Version:
MySQL Version:


What was done before the problem appeared?
Used to be running MX-Portal (mxBB) on the site. Due to problems with mxBB, removed it (clean install of phpBB 2.0.22, keeping existing db). Then performed a phpbb to Integra upgrade. Now no album.


What was done to try to solve the problem?




De.scription and Message

I was running mxBB for 1.5 years on the site. We have hundreds of photos in the album (mxBB uses smartor web photo album + clown sp addon). I still have all of the graphics files and all other data that was in the old album dir. The database should also still contain all of the data from the previous album.

When I did the phpBB to Integra upgrade, I did see a message about attempting to upgrade the album as well. it failed for reasons unknown to me. Can someone please point me in the right direction on how I can migrate all f the old album data, etc to the new one integrated with Integra.

This is huge for my users, so i really appreciate your help.

Any direction/advice is greatly appreciated!! I just don't really know where to begin.

I have established at least which tables are used by my old portal for the album. Maybe this helps:

mx_smartor_album
mx_smartor_album_cat
mx_smartor_album_comment
mx_smartor_album_config
mx_smartor_album_rate
mx_smartor_album_sp_config

try running the FAP update by itself

thx

When I run the .script, the following error is returned:
Fatal error: Call to undefined function: session_pagestart() in ...album_hierarchy_pg_migrate.php on line 15

hmmm...looks like a job for Teelk! ....lol
I hate to keep dropping everything in his lap, but his understanding of php/mysql functions are way beyond me.
btw, what versions of php & mysql are you using?

PHP Version 4.4.4
MySQL 4.0.27

Is it possible to just export the data from the old tables, and then re-import them into the newer, corresponding tables. I'm not very familiar with mysql. But, this seems like a fairly logical thing I could.

Browsing the data in the tables, it appears that some fo the data has been successfully migrated over, possibly as a result of the FAP update. However, I also see some data that has not made it over.

For example:
mx_smartor_album_cat is the old table storing the data for the categories. There are 7 lines (categories) with the following header columns:

Code: Select all

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

phpbb_album_cat is the new table (I think) that should be populated with data. There are zero lines with the following header columns]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      cat_user_id[/code]

With the exception of cat_parent and cat_user_id, the two tables seem to have the same structure. Can I do something like a JOIN to merge the data into one table? Or, should I export the old data and then manually insert all of the entries into the new table (not so bad with only 7 categories, very bad with 400-500 pictures).

I don't know mysql. But, I can piece together just enough, and have enough confidence... that I will try this on my own and likely destroy everything. <img>

Can anyone out there who knows mysql can tell me if this is a good/bad idea, etc? Advice on syntax would be greatly appreciated!

Woo hoo.

I was able to export mx_smartor_album_cat to a flat file, ensuring to export complete inserts. I then did a find/replace of mx_smartor_album_cat with phpbb_album_cat. I took the resultant inserts, and ran them through phpmyadmin... walah!

I double checked the Album Catgories through the ACP, and they are all there with the correct permissions, etc.

I know this is probably pretty basic stuff. But damn, it still feels good to muscle your way through it.

yes.... I just like the site of my own text. <img>
I completed the migration successfully.

1) Using the export/import method above, I migrated the following tables:
mx_smartor_album_cat > phpbb_album_cat
mx_smartor_album_comment > phpbb_album_comment
mx_smartor_album_rate > phpbb_album_rate

2) I manually configured (instead of importing the tables) the Photo Album via the ACP. Since there are more features in IM1.4.1, I figured this would be the best way to become more familiar with them.

3) After configuring the album, I then exported/imported:
mx_smartor_album > phpbb_album

4) Finally, I just copied all of the images from the old directory to /album_mod/upload.