Coppermine Import

[BPnet]

Originally Posted by Brian

This script will import the images from your current Coppermine installation and convert them for use with vBadvanced Gallery.

[snip]

Please note that at this time these import scripts have only been tested on a few installations. If you experience any problems please post here and we will be happy to help and make sure you get your files imported properly.

Question: We have just migrated our site from one host to another, and from a PostNuke/pnphpbb2/Coppermine setup to a vBulletin/vbPortal/vbAdvanced Gallery setup. Well, all but the last part, really. I am wondering whether this script is going to be able to handle a Coppermine conversion if I don't actually have Coppermine set up and working.

In other words, if I replace all the userid's in the Coppermine data with the new userid's from the conversion to vBulletin, can I upload/insert this to my temporary database that I ran the other imports against and have it not choke on the fact that there are two different databases involved (it doesn't look like it)? Or is there a hack you can give me that would allow for the source data to reside in a different MySQL database from the destination tables?

Thanks!

As long as the Coppermine files are there and the config options set then it should work without a problem.

[BPnet]

Well, for what it's worth, the answer is no, it definitely will not work. I didn't see any way that it could, since there was nowhere to provide values for database userid, host, password for either source or destination database, but I gave it a shot just in case, since you said it should work (I hadn't read all the way through the script at that point).

I'm trying to find exactly where the script gets its database login information, and it seems to go through Coppermine's init.inc.php, which seems to then connect to functions.inc.php, and from there to connect to the MySQL server through an existing PostNuke connection, which is, of course, broken since there is no PostNuke install on our new server as I mentioned. I downloaded the install package for the Coppermine version we were running on the old server to try and track down where this info would be in the filesystem, and it refers to writing these variables to a file, but it is unclear what file it is (config file '{$DFLT['cfg_f']}'), and a search of my full backups for either the keys or the values comes up empty.

Can you give us a hack for this import script that will allow for specification of MySQL server (or localhost default is fine), database name, database username, and password as variables passed to or added in to the script? I'm sure we're not the only site that would prefer to be able to set up directly without having to import each photo singly or set up a PostNuke/Coppermine site and hack the gallery install somehow to deal with a non-vBulletin setup. It would be great if you would.

It uses that info, so that's why I said it would work as long as you have the files uploaded and your config options set. Is there any reason you can't change the Coppermine config file and set the proper db/username/password there?

[BPnet]

Originally Posted by Brian

It uses that info, so that's why I said it would work as long as you have the files uploaded and your config options set. Is there any reason you can't change the Coppermine config file and set the proper db/username/password there?

Yes. I can't find what file '{$DFLT['cfg_f']}') refers to, and none of the files in the filesystem appear to contain either the Coppermine config variables (such as "$CONFIG['dbserver']") or the values to which those should refer (in that example, localhost) on a search for files containing the text.

This is a Coppermine install that was working on another host and server under PostNuke and was transferred directly to a new server -- not expecting it to act as a working install -- with the file system structure left intact and the SQL tables imported with no changes except renaming to remove the nuke_ prefix and owner_id of the photos changed to reflect the owner's userid under vB instead of PN. It is not possible to install this script on the old server with PostNuke and Coppermine -- we left that host for very good reasons including reliability and uptime issues.

There appears to be no way to set the script to work with the relevant values, and there is no way to set them as "config options" in the import script as it currently exists.

[BPnet]

I am sure you are busy, but it would be great to know if you intend to follow up on providing options or a hack to specify source connection options, such as server, database name, username, password, and possibly table prefix.

Either way, a quick response would be very helpful to us in determining our next necessary course of action.

I don't have plans anytime soon to change the import script. As I said before, as long as you have Coppermine set up and working properly (as most will), then the import will work fine.

[BPnet]

Thanks for responding so that we know now we have to ditch the import script and rebuild everything by hand to use this app. Those 5 days we lost waiting to find out would have been useful.

How do you figure 5 days? I said from the beginning that it would work if you had the files uploaded and your config file set properly. If you just set up a regular installation of Coppermine then it will work.

[BPnet]

5 days since I started trying to find out from you if such a hack would be something you'd be willing to provide and you first responded. My files are uploaded and the import script options have been set properly, and there seems to be no external configuration file from Coppermine to work with.

It seems rather overboard, work-wise, to install an app we're trying to get away from and import into it (since the tables would be naturally overwritten) in order to be able to run an import into this app. In fact, it seems like writing the script hack would be a good bit less work, so maybe I'll just do that.

If the options and such in your config file for Coppermine have been set properly and you have a running installation of Coppermine (as 99% of the people using the import will have), then there would be no problems. I'll agree that it may not have been the best way to set up the import script, but it was the quickest and easiest at the time, and should work just fine for 99% of the people using it. At a later time I may change the import scripts, but right now creating newer and better versions of our products and providing support are higher priority.

[jlaine]

I'm unable to get my user gallerys to integrate - all the external non-user gallerys pulled over... Seems to be an issue with the categories? The images are listed - the thumbnails are there, but if I try to click on a thumbnail I get a permission denied page, and the category doesn't seem to be listed.

Any suggestions as to where to start? Has anyone imported from a coppermine that was using the vB bridge or was it just standalone?

Would you mind just submitting a support ticket so I can have a look? Please be sure to specify a specific image or two that you're having a problem with in the ticket as well.

[jlaine]

Originally Posted by Brian

Would you mind just submitting a support ticket so I can have a look? Please be sure to specify a specific image or two that you're having a problem with in the ticket as well.

Sure thing brian, I'll do that right now.

[sunnycher]

Not sure why this is not working for me! I have uploaded the edited file.

Errors I get


Warning: chdir(): No such file or directory (errno 2) in /home/content/c/h/e/cher123/html/coppermine/import_coppermine.php on line 25
Gathering albums...
Gathering categories...



Warning: chdir(): No such file or directory (errno 2) in /home/content/c/h/e/cher123/html/coppermine/import_coppermine.php on line 235

Warning: main(./includes/init.php): failed to open stream: No such file or directory in /home/content/c/h/e/cher123/html/coppermine/import_coppermine.php on line 238

Fatal error: main(): Failed opening required './includes/init.php' (include_path='.:/usr/local/lib/php') in /home/content/c/h/e/cher123/html/coppermine/import

That means your paths are set incorrectly.

[sunnycher]

Corrected them Thank you!
Now I'm importing but...problems.
Can't find any of the images.
Are there only certain extensions that this will import? It left out all of my PSD, PDF, DOC.

There shouldn't be any reason it would have a problem with them. How do you figure that it left them out?

[sunnycher]

It shows errors when importing.

ERROR:
Gathering images (Page 12 of 13)...

Warning: copy(/home/content/c/h/e/cher123/html/coppermine/albums/userpics/thumb_12x12 4x5 Template.psd): failed to open stream: No such file or directory in /home/content/c/h/e/cher123/html/bb/gallery/import_coppermine.php on line 193

Warning: copy(/home/content/c/h/e/cher123/html/coppermine/albums/userpics/thumb_5x10 Template.psd): failed to open stream: No such file or directory in /home/content/c/h/e/cher123/html/bb/gallery/import_coppermine.php on line 193

Warning: copy(/home/content/c/h/e/cher123/html/coppermine/albums/userpics/thumb_10x20 collage template.psd): failed to open stream: No such file or directory in /home/content/c/h/e/cher123/html/bb/gallery/import_coppermine.php on line 193

Warning: copy(/home/content/c/h/e/cher123/html/coppermine/albums/userpics/thumb_10x20 collage template~0.psd): failed to open stream: No such file or directory in /home/content/c/h/e/cher123/html/bb/gallery/import_coppermine.php on line 193

[sunnycher]

Gathering images (Page 3 of 13)...

Warning: copy(/home/content/c/h/e/cher123/html/coppermine/albums/userpics/thumb_crazycardshoot112604.psd): failed to open stream: No such file or directory in /home/content/c/h/e/cher123/html/bb/gallery/import_coppermine.php on line 193


Importing images...