Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43261
Total Topics: 7519
Most Online Today: 297
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 282
Total: 283

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - justinbowser

Pages: [1] 2
1
Support / Re: Need Help with Coppermine Conversion
« on: November 04, 2020, 01:23:22 pm »
As we used to say in the military, "Outfu%^*ngstanding!"  I guess you now have a standalone Coppermine conversion program!  ;D

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.

2
Support / Re: Need Help with Coppermine Conversion
« on: November 04, 2020, 12:55:39 pm »
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

3
Support / Re: Need Help with Coppermine Conversion
« on: November 04, 2020, 11:39:26 am »
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

4
Support / Re: Need Help with Coppermine Conversion
« on: November 04, 2020, 11:18:38 am »
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

5
Support / Re: Need Help with Coppermine Conversion
« on: November 04, 2020, 09:59:48 am »
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...

6
Support / Re: Need Help with Coppermine Conversion
« on: November 04, 2020, 09:44:30 am »
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

7
Support / Re: Need Help with Coppermine Conversion
« on: November 03, 2020, 11:30:30 pm »
Sure thing, here's a partial screen shot.

8
Support / Re: Need Help with Coppermine Conversion
« on: November 03, 2020, 09:24:30 pm »
OK, here we go!  Now the gallery_pic table count has doubled so I guess the "new" data was appended.  Here's are the post conversion messages:

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 = 2Query Failed lookup user: 2Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3Query Failed lookup user: 3Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 5Query Failed lookup user: 5Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 7Query Failed lookup user: 7Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 4Query Failed lookup user: 4Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 13Query Failed lookup user: 13Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 20Query Failed lookup user: 20Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 21Query Failed lookup user: 21Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 8Query Failed lookup user: 8Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 24Query Failed lookup user: 24Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 26Query Failed lookup user: 26Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 23Query Failed lookup user: 23Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 27Query Failed lookup user: 27Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 6Query Failed lookup user: 6Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 31Query Failed lookup user: 31Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 22Query Failed lookup user: 22Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 33Query Failed lookup user: 33Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 29Query Failed lookup user: 29Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 34Query Failed lookup user: 34Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 37Query Failed lookup user: 37Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 39Query Failed lookup user: 39Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 43Query Failed lookup user: 43Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 30Query Failed lookup user: 30Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 58Query Failed lookup user: 58Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 64Query Failed lookup user: 64Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 93Query Failed lookup user: 93Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 116Query Failed lookup user: 116Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 121Query Failed lookup user: 121Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 150Query Failed lookup user: 150Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 65Query Failed lookup user: 65Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 66Query Failed lookup user: 66Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 1241Query Failed lookup user: 1241Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2058Query Failed lookup user: 2058Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2561Query Failed lookup user: 2561Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2783Query Failed lookup user: 2783Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3122Query Failed lookup user: 3122Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2322Query Failed lookup user: 2322Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 2829Query Failed lookup user: 2829Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3138Query Failed lookup user: 3138Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3602Query Failed lookup user: 3602Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3076Query Failed lookup user: 3076Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3605Query Failed lookup user: 3605Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3613Query Failed lookup user: 3613Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3633Query Failed lookup user: 3633Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3646Query Failed lookup user: 3646Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3652Query Failed lookup user: 3652Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 1064Query Failed lookup user: 1064Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3661Query Failed lookup user: 3661Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3664Query Failed lookup user: 3664Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 3677Query Failed lookup user: 3677Importing 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 = 1Query Failed lookup user: 1Select u.user_name,u.user_email FROM cpg_users AS u WHERE u.user_id = 0Query Failed lookup user: 0Recounting User Galleries...
Coppermime information Imported!
Visit imported Gallery https://bmwr65.org/smf/index.php?action=gallery

9
Support / Re: Need Help with Coppermine Conversion
« on: November 03, 2020, 07:01:03 pm »
Getting closer.  It looks like all of the pics were converted, albums created, but the user id is zero on all entries.  There were also a few 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
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 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...
Recounting User Galleries...
Coppermime information Imported!
Visit imported Gallery https://bmwr65.org/smf/index.php?action=gallery

10
Support / Re: Need Help with Coppermine Conversion
« on: November 03, 2020, 09:34:33 am »
Started out nice but got the following error:

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
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 382
An Error Has Occurred!
The database value you're trying to insert does not exist: ID_CAT
Back


The smf gallery DB table for pictures now has 5 files and user id is all zero.

11
Support / Re: Need Help with Coppermine Conversion
« on: November 02, 2020, 03:01:36 pm »
Great, I should be ready to go whenever you are...

12
Support / Re: Need Help with Coppermine Conversion
« on: November 01, 2020, 05:31:58 pm »
OK.  Will I need to delete the contents of the smf gallery tables to avoid dups?  I had already "fixed" two users albums before I decided to ask for help.

13
Support / Re: Need Help with Coppermine Conversion
« on: November 01, 2020, 07:59:45 am »
Cool!  I will also delete Coppermine users that don't have any content/images.

14
Support / Re: Need Help with Coppermine Conversion
« on: October 31, 2020, 10:52:27 pm »
Oh, what should I put if there is no match?

15
Support / Re: Need Help with Coppermine Conversion
« on: October 31, 2020, 10:50:20 pm »
Sounds like a plan.  It will take me a while to accomplish this as I have some "real" work I need to get done.  I doubt customers would appreciate me playing with a photo gallery while they waited for their stuff to get fixed!  :o

Pages: [1] 2

+- Recent Topics

Problems SMF 2.0.19 > 2.1.4 SMF Gallery Pro - Recents Images to overall header by Michel68
Today at 08:27:36 am

No thumbnails on new uploads by Tonyvic
Today at 06:26:18 am

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Powered by EzPortal