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: 177
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 200
Total: 200

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

0 Members and 1 Guest are viewing this topic.

Offline justinbowser

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

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

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

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

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

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

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

  • Member
  • *
  • 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
3541 Views
Last post February 26, 2007, 05:46:33 am
by Alanmelon
0 Replies
3284 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
4779 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