Coppermine Import issues...

TEAMBAJAMARINE · June 20th, 2005, 01:41 PM

I ran the importer, however some of the info is in my new gallery and some is not, specifically the photos. Here is a link to my site and can anyone offer some insight?

PHOTO GALLERY

Chuck S · June 20th, 2005, 06:52 PM

well pretty straight forward did you enter the proper path to the photos? Was your coppermine version the version noted that the importer was written for?

TEAMBAJAMARINE · June 20th, 2005, 09:57 PM

As far as I know all was fine, It was very wierd, it said everything was imported however I didnt end up with any photos, just a few orphaned comments, categorys with no photos in them and a few orphaned empty thumnails. I checked my Administartion and it said there were over 3,000 photos enetered. I did upgrade to Coppermine 1.3.3 before I ran the conversion. How can I get custom help on the import? I want to try again as I have deleted the mess I made, but am still stuck with a few orphaned comments on the board.

Chuck S · June 21st, 2005, 08:31 AM

You need to be entering a path or something wrong to grab the files and you should see errors.

We can do the import for an install fee if you choose.

vegascoug · October 5th, 2005, 11:56 AM

I called my host for help with Server Path to Coppermine Data Directory and they said that they cannot provide me with that information and it would require shell access.

Is that true? I am doing this for a customer of mine and know very little about PHP.

She has contacted PP about doing the install for a fee and all she got in reply was the link and instructions to download the tool.

So we are stuck. We cannot hire PP to do it, and I don't know how to do it, so right now we sit with a wasted purchase.

Is there ANYONE the can help me run the import tool?

import at go-cougs dot com

Chuck S · October 5th, 2005, 12:29 PM

If you run Photopost you should know your path to photopost like say this

/var/www/html/photopost

so if you have say coppermine in a directory called say cpg133 the path would be something like this

/var/www/html/cpg133/albums or something like that

easy way is to ftp to your server and place a phpinfo.php file in the data directory of coppermine and call it in your browser this will give you the path

vegascoug · October 5th, 2005, 01:14 PM

Okay, I ran it, twice, and no pictures were moved over.

Not sure why. It said it was finished, I received warnings but no "errors" and I am still seeing the same data, one samply picture that was there when the install was completed for PP

Mike

WARNINGS:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in /home/thescrap/public_html/gallery/coppermine.php on line 321
Importing 1 users .... please wait

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in /home/thescrap/public_html/gallery/coppermine.php on line 380
Importing 1 usergroups .... please wait

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in /home/thescrap/public_html/gallery/coppermine.php on line 441
Importing 1 Categories.... please wait

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in /home/thescrap/public_html/gallery/coppermine.php on line 506
Importing 1 Albums.... please wait

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in /home/thescrap/public_html/gallery/coppermine.php on line 597
Importing 1 Photos .... Please wait

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in /home/thescrap/public_html/gallery/coppermine.php on line 674
Importing 1 comments .... please wait

vegascoug · October 5th, 2005, 01:18 PM

The install was done to integrate with phpBB so I am wondering if that is causing a problem. All the warnings seem to be relating to lines looking for users, but there is not a user list as far as I know since Coppermine is using the user database from phpBB

I think this tool is looking for members to move the files and it's not finding any because the members/users is part of phpBB not Coppermine. Could that be the issue?

Has this tool ever been used to import Coppermine albums that are sharing a user/member DB with phpBB?

Mike

Chuck S · October 5th, 2005, 01:31 PM

Your database information to connect to coppermine is incorrect thats why nothing is being imported

vegascoug · October 5th, 2005, 01:32 PM

I think I must have the table prefix wrong then, I swore it was bb_ but that could be wrong. How can I find that out? It's not in the information given by phpinfo.php. Can phpMyAdmin tell me?

Chuck S · October 5th, 2005, 01:40 PM

if you look at the table yes usually something like this

cpg133_ or so

vegascoug · October 5th, 2005, 01:43 PM

Hallelujah Praise the Lord!

Thanks for shedding a little light on a not so bright mind