My new host recently directly transferred coppermine files from my previous host for me. I did not create a dump file before previous account was terminated. I have changed the config.inc.php file to reflect new host info, (confirmed as correct). I imported basic.sql info into new database...still getting this error message:
While executing query "SELECT * FROM cpg148_config" on 0
mySQL error: Table 'Mister_net_photo.cpg148_config' doesn't exist
Did I import the correct file? Any new suggestions?, I have searched the forums
SOS
Was the previous installation made with an auto installer?
Doesn't matter much. If you or the webhost (whoever was in charge of transfering the gallery) haven't done what is needed (create a dump of the database on the old webserver and restore that dump on the new one), your data is lost. Trusting your webhost to accomplish the task without checking the result before the old server goes down (i.e. the old contract is terminated) is not a bright idea. There's little we could do to provide help. Actually, thinking about this: there's nothing we could do to help. If your backup/transfer was incomplete, there is nothing you could do to bring your data back.
In this case, it doesn't matter if the old install was performed by an auto-installer or not in my opinion.
Not related to initial install, moving accordingly.
If the auto installer question doesn't matter... [off topic:] Where come this table from? "'Mister_net_photo.cpg148_config'" Could someone give some light to me in this topic? I think I'm missing something.[/off topic]
cpg148_config is the table name. Mister_net_photo is the database name that shows through in the error message. The database name often corresponds to the domain name on shared webhosting. As the thread starter has failed to post a link to his gallery we can only guess. However, that's not an indication of an install performed by an auto-installer nor does it mean something special in this aspect. It definitely is not related to auto-installers, as it's not a result of particular auto-installer related issue, but just how mySQL queries work: the database name is prepended using a dot. That's why you're not allowed to use dots in database names nor table names: the queries would stop working.
I knew some things you explained, but:
Quote from: Joachim Müller on June 16, 2009, 09:03:02 AM
Mister_net_photo is the database name that shows through in the error message.
I was just assuming that!
So, thanks for the clarification, as always, great explanation. :D
FYI...My previous host did use an auto-installer, and yes, I made the mistake of assuming my files would remain intact. I thought I could just do a bit of reconfiguring and all would be good. Now I know about creating a dump first... Too bad because I had over 1,000 pictures involved. Here is the linkhttp://escapedigitalart.com/photography/index.php (http://escapedigitalart.com/photography/index.php)(not that it makes any difference now)
Another question- I imported the images I used in Coppermine into FileMaker, and there is a lot of Coppermine data embedded in the files. Can I do anything with this info, other than maybe save myself some work when re-importing them back into a fresh install of Coppermine?
Thanks again for your help. I can stop pulling my hair out now
I have no idea what FileMaker is (and I'm not going to look that up because I'm not interessted in it), but it falls into the category "third party app that goes unsupported here". Additionally, we have a strict "one question per thread" policy that you agreed to respect when signing up.
Locking