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: 100
Total: 100

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

0 Members and 1 Guest are viewing this topic.

Offline justinbowser

  • SMF Gallery Pro Customer
  • Newbie
  • *****
  • Posts: 23
    • View Profile
Need Help with Coppermine Conversion
« on: October 31, 2020, 11:16:23 am »
Just purchased and installed the Gallery Pro and need converter and help to port Coppermine Gallery to SMF Gallery.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15291
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #1 on: October 31, 2020, 11:28:02 am »
Go to this topic:
https://www.smfhacks.com/index.php/topic,2839.0.html

Download copperminephp7.0.zip

Extract the files then upload the files to your SMF forum main directory.

Visit the script in your browser of your site to begin the conversion process.
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 #2 on: October 31, 2020, 01:14:41 pm »
I downloaded and extracted the conversion script and ran it.  I get the following error:

Error: Can not find the config.inc.php in http://www.suraklyn.com/r65_forum_gallery/include/config.inc.php
Please make sure you have the right coppermime path.

I have confirmed that the file exists at this location on the other host.  I am needing to convert the coppermine on one host to the SMF gallery on a different host.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15291
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #3 on: October 31, 2020, 01:22:43 pm »
The path should be a filename path not a weburl for instance

/home/public_html/r65_forum_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 #4 on: October 31, 2020, 01:35:45 pm »
The Coppermine installation is on a different host then the SMF installation.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15291
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #5 on: October 31, 2020, 01:48:53 pm »
The files and database needs to be copied to the SMF host. or the SMF Host needs to be copied to the coppermine location
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 #6 on: October 31, 2020, 04:50:12 pm »
I was afraid of that - nothing is ever easy!

I moved the coppermine installation over to the new host using the procedure at the coppermine forum:

https://documentation.coppermine-gallery.net/en/export.htm#backup_file_complete

1.  I zipped up the entire Coppermine installation on the old host and extracted it on to my new host.
2.  Exported the database to a file through phpMyAdmin.
3.  Created a new mysql database on the target host.
4.  Imported the backup file into the new DB on new host.
5.  Modified the config.inc.php file with the new DB name, DB username, and password.

When I try to do the conversion I get:


Warning: mysqli_connect(): (28000/1045): Access denied for user 'bmwrorg_cpm_adm'@'localhost' (using password: YES) in /home/bmwrorg/public_html/smf/galleryimport.php on line 232
Could not connect to the MySQL server.

I did notice that when I was updating the config.inc.php file that the existing password looked like it was encrypted and the password I replaced it with was in plain text.  Is there a switch I need to set somewhere to accept a plain test PW or is something else FUBAR?

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15291
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #7 on: October 31, 2020, 06:13:46 pm »
It looks like the bmwrorg_cpm_adm user needs to be added to database of coppermine. I would also give it access to the SMF forum as well. Make sure to grant rights to it.
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 #8 on: October 31, 2020, 06:20:36 pm »
OK, got everything sorted with the DB connection and converted the Coppermine data.  It looks like all of the pics got pulled in BUT all of the user associations that I have looked at are wrong!  :( I pull up someone's gallery and all of the pictures belong to somebody else...

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15291
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #9 on: October 31, 2020, 06:28:22 pm »
How was coppermine bridged before? Was it tied to an SMF forum or standalone?
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 #10 on: October 31, 2020, 07:58:56 pm »
It was standalone.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15291
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #11 on: October 31, 2020, 08:28:11 pm »
Where any users on your coppermine gallery part of the forum?
If not we can just reset the owners of all pictures/comments to guests.
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 #12 on: October 31, 2020, 08:53:55 pm »
Yes, they were all members of the YaBB forum.  Looking at the DB it seems that the conversion took the user id number from the coppermine DB and assumed the user ID was the same in the SMF DB.  I am going to have to figure out who had what album in coppermine and then cross the user id and then do a search and replace in the SMF DB.  Unfortunately I an not an SQL person so I'll need to do it one by one in phpMyAdmin.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15291
    • View Profile
Re: Need Help with Coppermine Conversion
« Reply #13 on: October 31, 2020, 09:23:21 pm »
I can try to modify the conversion scrpit to do a better search you would need to rerun the conversion though. This is the first time converting a nonbridged gallery.

If you just want to reset all the pictures and comments to a guest user try this sql on the database
Code: [Select]
UPDATE smf_gallery_pic SET id_member = 0;
UPDATE smf_gallery_comment SET id_member = 0;


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 #14 on: October 31, 2020, 10:26:08 pm »
I wouldn't be opposed to re-running the conversion.  I would like to say that the majority of the user names would be very close between the forum and coppermine but not all.  In retrospect I should have forced users to have the same name on both platforms but at the time I didn't think it would matter. 

Maybe I could compare coppermine to smf and possibly rename coppermine users to match smf users?  Also, there will be users on coppermine that are no longer on the forum which will also complicate things.

Could a global search and replace on all tables in the coppermine db be performed for something like replace username1 with username2?  I could then make the vast majority of the username match between the two and maybe simplify the conversion.

 

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
2324 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