ok so here it goes.
(i did do a search on here first to see if i could solve this myself, but didnt see what i needed)
I was hosting my friends site on my server, i will be shutting down my server end of month so he had to get hosting from another company. He got all set up, i moved his forum and db over fine, his Invision Power Board is running fine now, all users and data are back.
He also was using the coppermine gallery v1.3.2 and it was bridged to use the IPB users. It was working fine on the other site.
I moved all his coppermine data to the new server keeping the structure the same.
I then created a new DB on the new server and installed coppermine. All is well, copper is running fine, no albums listed.
I then imported the old copper db to the new one.
Nlow when i go to the site i see on the main page "27 albums 177 pics" but when i go into where the list of albums are there is only three listed.
if i check last uploads or favorites etc.. i see pictures from the other albums and the name of the album after the level Mr.X.
I then turned to the bridge since i thought because it wasnt pulling the user list from IPB that it wont show the albums.
SO i edited the to init file and the invision board files and when i try to get to the site after that it says it could not connect to my db.
now so you know the db host is not able to be localhost, with this new hosting it has to be nefgallery.newenglandfishing.net, would this be an issue?
So my question is how do i get all the albums back so we can all see them and how do i get it so it pulls the user db from the forum again? Im thinking that fixing the user issue will fix the albums.
thanks in advance!!
Does include/config.inc.php have the correct mysql info?
i just double checked and it is correct. the gallery software works and i can see a couple of albums, but i cannot see the other 25, even though it shows them.
when i edit the init and the ipb file and refresh i get the following error accessing the gallery:
Coppermine critical error:
Unable to connect to Invision Board database !
MySQL said: Unknown MySQL server host 'copper.newenglandfishing.net ' (1)
so i commented the init file back so it doesnt use the IPB user db, so if you go to http://www.newenglandfishing.net/coppermine/index.php you can see what im seeing about the missing albums
bump, anyone?
Get the bridge working again and verify that the db backup contained all the albums.
use phpMyadmin and browse the
albums table to confirm that all the albums exist in the database.
also the
pictures table to confirm that all the paths are correct.
and the
users table to confirm that all users exist.
Dennis
Quote from: Nibbler on November 20, 2005, 08:50:16 PM
Get the bridge working again and verify that the db backup contained all the albums.
everytime i try to enable the bridge i get a sql error when i try to get to the gallery that it cannot find the host i put in for mysql, although what i put in is correct.
I read that if the host is something like mysql.yoursite.com then it will not work with coppermine, is this correct?
Quote from: madeinhawaii on November 20, 2005, 08:52:45 PM
use phpMyadmin and browse the
albums table to confirm that all the albums exist in the database.
also the
pictures table to confirm that all the paths are correct.
and the
users table to confirm that all users exist.
Dennis
i see all the albums and pics, but the only users i see are the three that were created before the forum before was bridged to the ipb board.
should all the users be in there now, or will they only show when the bridge works?
Did you make sure that the mysql server is allowing remote access to it?
i went back to the old server where it is up and working fine and i looked at the users tables and it only had the two from the oriinal install. since it uses the IPB user table it would be populated right?
Quote from: TranzNDance on November 21, 2005, 01:26:47 AM
Did you make sure that the mysql server is allowing remote access to it?
im able to log into it from the command line, and my forum connects to it fine.
how else would i check?
If it's using the IPB user table, it will not be populated by registrations done via IPB. Bridging bypasses Coppermine's user table.
right, so i would need to get the bridge working in order for all the albums to be visible on the main page of the gallery.
so how do i do that, i have tried several times
Post a support request in the bridging board then. Read the sticky before you post.