|
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
1
« 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! 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
« 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
« 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
« 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
« 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
« 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
« on: November 03, 2020, 11:30:30 pm »
Sure thing, here's a partial screen shot.
8
« 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
« 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
« 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
« on: November 02, 2020, 03:01:36 pm »
Great, I should be ready to go whenever you are...
12
« 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
« on: November 01, 2020, 07:59:45 am »
Cool! I will also delete Coppermine users that don't have any content/images.
14
« on: October 31, 2020, 10:52:27 pm »
Oh, what should I put if there is no match?
15
« 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!
|
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
|
|
|