Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12400
Latest: mikel
New This Month: 5
New This Week: 0
New Today: 0
Stats
Total Posts: 40609
Total Topics: 7132
Most Online Today: 121
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 120
Total: 120

Author Topic: Need Help with Coppermine Conversion  (Read 1015 times)

0 Members and 1 Guest are viewing this topic.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15291
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #15 on: October 31, 2020, 10:32:13 pm »
Backup your coppermine database first.

Then go into the coppermine databasae table for CPG_users
And update either username or email to the forum one.

I can then write a script to match based on username or email and match it to the SMF memberid
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline justinbowser

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 23
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #16 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

Offline justinbowser

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 23
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #17 on: October 31, 2020, 10:52:27 pm »
Oh, what should I put if there is no match?

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15291
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #18 on: October 31, 2020, 10:55:50 pm »
I would just leave it as is.
I will make them a guest user in that case.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline justinbowser

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 23
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #19 on: November 01, 2020, 07:59:45 am »
Cool!  I will also delete Coppermine users that don't have any content/images.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15291
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #20 on: November 01, 2020, 08:08:19 am »
That's not required though. Since I am not looking at users just their content.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline justinbowser

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 23
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #21 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.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15291
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #22 on: November 01, 2020, 06:33:31 pm »
Yes, but I can make a change to the script to clear the contents of SMF Gallery
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline justinbowser

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 23
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #23 on: November 02, 2020, 03:01:36 pm »
Great, I should be ready to go whenever you are...

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15291
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #24 on: November 02, 2020, 11:22:19 pm »
Give this a try and see if it helps
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline justinbowser

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 23
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #25 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.
« Last Edit: November 03, 2020, 09:38:46 am by justinbowser »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15291
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #26 on: November 03, 2020, 11:17:11 am »
Hmm try this
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline justinbowser

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 23
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #27 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

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15291
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #28 on: November 03, 2020, 08:34:59 pm »
Try this added more debugging
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline justinbowser

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 23
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #29 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

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
2992 Views
Last post February 26, 2007, 05:46:33 am
by Alanmelon
0 Replies
2627 Views
Last post May 25, 2008, 07:30:30 pm
by M3TAL
0 Replies
3220 Views
Last post July 30, 2008, 04:58:54 pm
by -SyN-
2 Replies
1052 Views
Last post February 26, 2018, 09:48:44 pm
by UCAPhantom
18 Replies
2326 Views
Last post September 12, 2018, 12:12:02 pm
by SMFHacks

+- Recent Topics

Forum ToolBox by Monocero
January 23, 2021, 11:47:48 am

Gallery Pro v8.0 and PHP 7.4 by SMFHacks
January 20, 2021, 10:21:25 pm

[Mod] Tagging System by SMFHacks
January 13, 2021, 08:43:33 pm

Using Alternate PayPal Address by KKOG
January 13, 2021, 07:24:46 pm

Assigning a BuyNow Button to a product by SMFHacks
January 12, 2021, 04:59:32 pm

SMF Links by Nicole
January 10, 2021, 12:02:39 pm

Error on the latest version by davejo
January 06, 2021, 08:04:05 am

Recent topics on board index by eugen
January 01, 2021, 11:08:16 am

Parser by swayforth
December 31, 2020, 12:24:23 am

Show Gallery in Users Profile by swayforth
December 29, 2020, 10:37:17 pm

Powered by EzPortal