Need Help with Coppermine Conversion

[SMFHacks]

Can you run this query on your coppermine database via phpmyadmin i want to see what happens/returned

Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2

[justinbowser]

Sure thing, here's a partial screen shot.

[SMFHacks]

Try this

[justinbowser]

Got another boo-boo immediately:

Beginning importing of Coppermime information.
Importing Albums..
Running: Select a.aid, a.title, a.description, a.alb_password, a.category FROM cpg_albums AS a
Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2
Notice: Undefined index: email in /home/bmwrorg/public_html/smf/galleryimport.php on line 741
An Error Has Occurred!
The database value you're trying to insert does not exist: email
Back

[justinbowser]

I glanced at the php code and on line 741 it is:

   'email' => $row['email'],

Should it be?

   'email' => $row['user_email'],

If so I can make the change and re-run...

[SMFHacks]

Yes just make that change!

[justinbowser]

I think we are almost there!!!!

The import ran, converted all pics, they appear to have the correct users associated with them but... - there's always a but. right?

- On the main gallery page, under "User Galleries" the number of images is listed as zero.

- When you open up a user's gallery each of their galleries/albums show 0 images but when you open it up all of the pics are there!

I think if these two things get ironed out we will be perfect!

Here's the conversion results with a couple of errors at the end:

Beginning importing of Coppermime information.
Importing Albums..
Running: Select a.aid, a.title, a.description, a.alb_password, a.category FROM cpg_albums AS a
Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2Found SMF MEM ID: 1Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 5Found SMF MEM ID: 231Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 7Found SMF MEM ID: 2Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 4Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 13Found SMF MEM ID: 18Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 20Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 21Found SMF MEM ID: 7Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 8Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 24Found SMF MEM ID: 8Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 26Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 23Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 27Found SMF MEM ID: 4Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 6Found SMF MEM ID: 23Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 31Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 22Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 33Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 29Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 34Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 37Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 39Found SMF MEM ID: 3Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 43Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 30Found SMF MEM ID: 6Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 58Found SMF MEM ID: 43Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 64Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 93Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 116Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 121Found SMF MEM ID: 28Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 150Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 65Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 66Found SMF MEM ID: 31Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 1241Found SMF MEM ID: 39Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2058Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2561Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2783Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3122Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2322Found SMF MEM ID: 67Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2829Found SMF MEM ID: 38Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3138Found SMF MEM ID: 300Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3602Found SMF MEM ID: 89Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3076Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3605Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3613Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3633Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3646Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3652Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 1064Found SMF MEM ID: 55Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3661Found SMF MEM ID: 169Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3664Found SMF MEM ID: 179Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3677Found SMF MEM ID: 240Importing Pictures...
Running Select pid,aid, title,caption,hits,filesize,pheight,pwidth,filename,filepath,ctime,owner_id,keywords FROM cpg_pictures

Notice: Undefined offset: 1 in /home/bmwrorg/public_html/smf/galleryimport.php on line 382

Notice: Undefined offset: 1 in /home/bmwrorg/public_html/smf/galleryimport.php on line 382

Notice: Undefined offset: 1 in /home/bmwrorg/public_html/smf/galleryimport.php on line 382
Importing Comments...
Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 1Found SMF MEM ID: 1Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 0
An Error Has Occurred!
The database value you're trying to insert does not exist: username
Back

[SMFHacks]

Open the script find

Code: [Select]

function ReturnSMFUserID($userID)
{
global $db2, $prefix, $smcFunc, $db_prefix;
$finalID = 0;
$userID = (int) $userID;

Add after

Code: [Select]

if (empty($userID))
return;


[justinbowser]

Same results as before as far as image counts.  If these counts are stored somewhere I can just add them up and make a DB change.

Beginning importing of Coppermime information.
Importing Albums..
Running: Select a.aid, a.title, a.description, a.alb_password, a.category FROM cpg_albums AS a
Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2Found SMF MEM ID: 1Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 5Found SMF MEM ID: 231Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 7Found SMF MEM ID: 2Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 4Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 13Found SMF MEM ID: 18Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 20Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 21Found SMF MEM ID: 7Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 8Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 24Found SMF MEM ID: 8Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 26Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 23Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 27Found SMF MEM ID: 4Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 6Found SMF MEM ID: 23Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 31Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 22Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 33Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 29Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 34Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 37Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 39Found SMF MEM ID: 3Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 43Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 30Found SMF MEM ID: 6Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 58Found SMF MEM ID: 43Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 64Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 93Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 116Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 121Found SMF MEM ID: 28Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 150Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 65Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 66Found SMF MEM ID: 31Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 1241Found SMF MEM ID: 39Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2058Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2561Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2783Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3122Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2322Found SMF MEM ID: 67Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2829Found SMF MEM ID: 38Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3138Found SMF MEM ID: 300Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3602Found SMF MEM ID: 89Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3076Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3605Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3613Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3633Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3646Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3652Found SMF MEM ID: 0Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 1064Found SMF MEM ID: 55Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3661Found SMF MEM ID: 169Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3664Found SMF MEM ID: 179Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3677Found SMF MEM ID: 240Importing Pictures...
Running Select pid,aid, title,caption,hits,filesize,pheight,pwidth,filename,filepath,ctime,owner_id,keywords FROM cpg_pictures

Notice: Undefined offset: 1 in /home/bmwrorg/public_html/smf/galleryimport.php on line 382

Notice: Undefined offset: 1 in /home/bmwrorg/public_html/smf/galleryimport.php on line 382

Notice: Undefined offset: 1 in /home/bmwrorg/public_html/smf/galleryimport.php on line 382
Importing Comments...
Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 1Found SMF MEM ID: 1
An Error Has Occurred!
The database value you're trying to insert does not exist: id_member
Back

[SMFHacks]

Yeah just failing on comment imports now...
There might be a setting to recount them not sure though.

Try this file trying to narrow down the issue.
And also can you run this sql query in phpmyadmin on SMF and report back results

describe smf_gallery_comment;

[justinbowser]

I re-ran the conversion with your latest file and looking at the converted gallery all pics seem to be there, user associations correct, image counts are there, and the random comments I've checked seem to be OK.  I'm not sure why the conversion is complaining at the end!

The only thing I noticed in the gallery was that if you did a search for a user's gallery and you entered a user that doesn't exist it comes back with the complete list of images.  Not a biggie but seems like it should report "User not found" or something like that...

Unless you want to continue debugging this script in order to get it to complete without any "Notices" I'm happy unless my users discover something glaring.

Here's the DB query:

Error
SQL query:


describe smf_gallery_comment
MySQL said: Documentation

#1146 - Table 'bmwrorg_SMF_BU.smf_gallery_comment' doesn't exist

Results from new conversion:

Beginning importing of Coppermime information.
Importing Albums..
Running: Select a.aid, a.title, a.description, a.alb_password, a.category FROM cpg_albums AS a
Found SMF MEM ID: 1Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Insert USER ID:Insert USER ID:Insert USER ID:Found SMF MEM ID: 231Insert USER ID:Found SMF MEM ID: 2Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 18Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 7Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Insert USER ID:Found SMF MEM ID: 8Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Insert USER ID:Found SMF MEM ID: 4Insert USER ID:Found SMF MEM ID: 23Insert USER ID:Insert USER ID:Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Insert USER ID:Insert USER ID:Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Insert USER ID:Found SMF MEM ID: 3Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 6Insert USER ID:Found SMF MEM ID: 43Insert USER ID:Insert USER ID:Insert USER ID:Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Insert USER ID:Insert USER ID:Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 28Insert USER ID:Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Insert USER ID:Found SMF MEM ID: 31Insert USER ID:Found SMF MEM ID: 39Insert USER ID:Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Insert USER ID:Found SMF MEM ID: 67Insert USER ID:Found SMF MEM ID: 38Insert USER ID:Found SMF MEM ID: 300Insert USER ID:Found SMF MEM ID: 89Insert USER ID:Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Insert USER ID:Insert USER ID:Insert USER ID:Found SMF MEM ID: 0Insert USER ID:Found SMF MEM ID: 55Insert USER ID:Found SMF MEM ID: 169Insert USER ID:Found SMF MEM ID: 179Insert USER ID:Found SMF MEM ID: 240Insert USER ID:Importing Pictures...
Running Select pid,aid, title,caption,hits,filesize,pheight,pwidth,filename,filepath,ctime,owner_id,keywords FROM cpg_pictures

Notice: Undefined offset: 1 in /home/bmwrorg/public_html/smf/galleryimport.php on line 383

Notice: Undefined offset: 1 in /home/bmwrorg/public_html/smf/galleryimport.php on line 383

Notice: Undefined offset: 1 in /home/bmwrorg/public_html/smf/galleryimport.php on line 383
Importing Comments...
Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Found SMF MEM ID: 1Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Comment test:Recounting User Galleries...
Coppermime information Imported!
Visit imported Gallery https://bmwr65.org/smf/index.php?action=gallery

[SMFHacks]

Looks good! Notices where just for us to troubleshoot and find any issues. But looks good above.

[justinbowser]

As we used to say in the military, "Outfu%^*ngstanding!"  I guess you now have a standalone Coppermine conversion program! 

I am PMing you about a different issue you might be able to point me in the right direction on.

I appreciate the help more than you can imagine.

[SMFHacks]

Glad to help!