photo gallery upgrade script-smartors phpbb2 to my phpBB3

[Handyman]

Smartors Photo Gallery (phpBB2) to Handymans Photo Gallery (phpBB3) upgrade script is finally here.
Instructions are below.
I will add a troubleshooting section as problems arise and I get details on what causes the issue and what fixes it.
I'll also upgrade the script as needed.

1. Make sure you have the photo gallery mod already installed. If you don't, you can find it here: f27-mods/t3139-beta-photo-gallery.html
   
2. Download the upgrade script and unpackage it.
   
3. copy the config.php from your phpbb2 forum (image 1), rename it phpbb2_config.php and place it in the root directory of your phpbb3 forum (image 2)
   image 1:
   
   image 2:
   
   
4. copy upgrade.php to your phpbb3 forum root folder (image 3)
   image 3:
   
   
5. Open upgrade.php in a text editor and edit the top 2 variables as seen here:
   to match the paths to the respective folders
   
6. open your web browser and browse to yourforum/upgrade.php (image 4)
   image 4:
   
   
7. wait for the script to finish, then click the link that says "Click here to continue".
   
8. This will happen about 5 times until it says: "You have successfully completed the photo gallery phpBB2 to phpBB3 upgrade script, enjoy your gallery."
   
   If there are any errors along the way, please be sure to report it here.
   
9. Don?t forget to donate, as I have spent a lot of time working on this script and your support will enable me to provide future upgrades to the photo gallery, as there are many features that I still need to add

[darkon]

Still no result....

But now i get this:

Fatal error: SQL ERROR [ mysql4 ]

[]

BACKTRACE

FILE: includes/db/dbal.php
LINE: 239
CALL: dbal_mysql->sql_error()

FILE: includes/session.php
LINE: 1423
CALL: dbal_mysql->sql_transaction()

FILE: includes/functions.php
LINE: 3815
CALL: user->setup()

FILE:
LINE:
CALL: msg_handler()

FILE: upgrade.php
LINE: 594
CALL: trigger_error()

in /home/httpd/vhosts/darkon.de/httpdocs/_test/includes/db/dbal.php on line 581

[Handyman]

Still no result....

But now i get this:

Fatal error: SQL ERROR [ mysql4 ]

[]

BACKTRACE

FILE: includes/db/dbal.php
LINE: 239
CALL: dbal_mysql->sql_error()

FILE: includes/session.php
LINE: 1423
CALL: dbal_mysql->sql_transaction()

FILE: includes/functions.php
LINE: 3815
CALL: user->setup()

FILE:
LINE:
CALL: msg_handler()

FILE: upgrade.php
LINE: 594
CALL: trigger_error()

in /home/httpd/vhosts/darkon.de/httpdocs/_test/includes/db/dbal.php on line 581

that seems like a bug in phpbb3, as that line is "trigger_error", which should not be causing a problem.
It may have been something they fixed recently, as they recently made a bunch of features regarding msg_handler? not sure.
Maybe try it with the latest CVS and see what you get.

[darkon]

No, it´s exactly the same.

[Geisthund]

General Error
SQL ERROR [ mysql4 ]

Table 'wftv_phpbb.phpbb3_users' doesn't exist [1146]

SQL

SELECT user_id, username_clean FROM phpbb3_users WHERE username_clean IN ('gareth', 'aileen', 'joan', 'clare', 'ann', 'diana', 'debbie wallwork', 'cressy', 'joanna', 'marylb', 'diane melchert', 'beggy', 'wendy', 'lisa coull', 'cathy', 'mpark', 'weimardan', 'mariy johnson')

BACKTRACE


FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: upgrade.php
LINE: 132
CALL: dbal_mysql->sql_query()

phpMyAdmin = Server: localhost Database: wftv_phpbb Table: phpbb_users
My phpBB2 database is called: wftv_phpbb
$table_prefix = 'phpbb_';

phpMyAdmin = Server: localhost Database: wftv_phpbb3 Table: phpbb3_users
My phpBB3 database wftv_phpbb
$table_prefix = 'phpbb3_';

The usernames in SELECT user_id, already exist in phpBB3 database.
The board has 825 members of which 129 have Albums in phpBB2.

HTH

Gareth

[Geisthund]

Hi

I've just downloaded your updated version of upgrade.php and the error message has now changed to:

Fatal error: SQL ERROR [ mysql4 ]

Table 'wftv_phpbb.phpbb3_users' doesn't exist [1146]

SQL

SELECT u.username, u.username_clean, u.user_id, u.user_type, u.user_allow_viewonline, u.user_colour, s.session_ip, s.session_viewonline FROM phpbb3_users u, phpbb3_sessions s WHERE s.session_time >= 1188727291 AND u.user_id = s.session_user_id ORDER BY u.username_clean ASC, s.session_ip ASC

BACKTRACE


FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/functions.php
LINE: 3984
CALL: dbal_mysql->sql_query()

FILE: includes/functions.php
LINE: 3861
CALL: page_header()

FILE:
LINE:
CALL: msg_handler()

FILE: upgrade.php
LINE: 594
CALL: trigger_error()


in /home/wftv/public_html/phpBB3/includes/db/dbal.php on line 581

Also can you confirm the paths below are in the corrrect form:

//make sure these vars are correct before moving on
//path to your phpbb2 photo gallery. Make sure to include trailing slash
$phpbb2_gallery_path = '/home/mysite/public_html/album_mod/upload/';

//path to your phpbb2 photo gallery thumbnails path. Make sure to include trailing slash
$phpbb2_thumbs_path = '/home/mysite/public_html/album_mod/upload/cache/';
//do not edit anything below this line unless you know what you are doing

HTH
Gareth

[penrod]

I am trying to import data from phpbb2. I see this error when attempting to run...

Any thoughts as to the cause?

Note: I am using Mysql5

Code: Select all


http://<mysite>/upgrade.php?mode=1

===cut===

General Error
SQL ERROR [ mysql4 ]

Column 'parent_id' cannot be null [1048]

SQL

INSERT INTO phpbb3_gallery (parent_id, gallery_name, user_id) VALUES (NULL, 'arwinnett', '35')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 133
CALL: dbal->sql_error()

FILE: upgrade.php
LINE: 138
CALL: dbal_mysql->sql_query()



Thanks in advance,

John P.

[penrod]

Same type of errro when I go to upload a pic. Is this related to Mysql5?

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Column 'thumbnail' cannot be null [1048]

SQL

INSERT INTO phpbb3_gallery_photos (poster_id, is_orphan, physical_filename, real_filename, photo_comment, extension, mimetype, filesize, filetime, thumbnail, photo_name, gallery_id) VALUES ('2', 0, 'photo_2_0cf1579455fc9dd4777bbcf2b0d20c22', 'dst.gif', 'Test', 'gif', 'image/gif', 3421, 1188759712, NULL, 'TestPic', '2')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 133
CALL: dbal->sql_error()

FILE: includes/functions_gallery.php
LINE: 914
CALL: dbal_mysql->sql_query()

FILE: includes/gallery/gallery_main.php
LINE: 645
CALL: upload_attachment()

FILE: includes/functions_module.php
LINE: 460
CALL: gallery_main->main()

FILE: gallery.php
LINE: 52
CALL: p_master->load_active()

[Handyman]

I highly doubt it's related to MySQL 5.
I'll check it out later.

I develop everything on php5 and mysql5? I have no idea how it works in php4 and mysql 4 and earlier

[darkon]

Hmmm.. that could be clue.

I have php 4.3.10 and mySQL 4.1.10a