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: 43259
Total Topics: 7518
Most Online Today: 201
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 193
Total: 193

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

0 Members and 1 Guest are viewing this topic.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • 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

  • Member
  • *
  • 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

  • Member
  • *
  • 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: 16436
    • 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

  • Member
  • *
  • 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: 16436
    • 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

  • Member
  • *
  • 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: 16436
    • 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

  • Member
  • *
  • 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: 16436
    • 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

  • Member
  • *
  • 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: 16436
    • 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

  • Member
  • *
  • 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: 16436
    • 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

  • Member
  • *
  • 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
3541 Views
Last post February 26, 2007, 05:46:33 am
by Alanmelon
0 Replies
3285 Views
Last post May 25, 2008, 07:30:30 pm
by M3TAL
0 Replies
4040 Views
Last post July 30, 2008, 04:58:54 pm
by -SyN-
2 Replies
2439 Views
Last post February 26, 2018, 09:48:44 pm
by UCAPhantom
18 Replies
4780 Views
Last post September 12, 2018, 12:12:02 pm
by SMFHacks

+- Recent Topics

No thumbnails on new uploads by SMFHacks
March 27, 2024, 02:10:41 pm

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

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

Powered by EzPortal