Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: I need to tidy up the database  (Read 3359 times)

0 Members and 1 Guest are viewing this topic.

NatalieFord

  • Coppermine newbie
  • Offline Offline
  • Gender: Female
  • Posts: 9
    • My photo gallery
I need to tidy up the database
« on: November 17, 2004, 01:35:16 pm »

...because it seems to contain links to files that no longer exist (e.g. http://natalieford.com/photos/thumbnails.php?album=2&page=3). How should I remove these links from the database? ???
Logged

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: I need to tidy up the database
« Reply #1 on: November 17, 2004, 04:50:03 pm »

This happens when you remove things by ftp, or you used a database dump when you moved from another server, but did not bring all the pics with you.

If you still have those pics, ftp them into the folder they used to be in.  Then use coppermine to delete them.  otherwise, you will have to edit the database pictures table, and manually remove the entries for these pics.
Logged
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

NatalieFord

  • Coppermine newbie
  • Offline Offline
  • Gender: Female
  • Posts: 9
    • My photo gallery
Re: I need to tidy up the database
« Reply #2 on: November 17, 2004, 07:58:12 pm »

This happens when you remove things by ftp

Yep. I learnt the hard way.

Quote
If you still have those pics, ftp them into the folder they used to be in.

They no longer exist.

Quote
Otherwise, you will have to edit the database pictures table, and manually remove the entries for these pics.

That is what I thought. How do I do that? What access do I need? What tools?
Logged

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: I need to tidy up the database
« Reply #3 on: November 17, 2004, 08:42:27 pm »

Whatever tool your host provides for your use, something like phpMyAdmin.

With that you can do anything you want to the database.  Be aware, it is very easy to cock it all up when you don't know what you're doing.

Before you do anything else, you should make a backup(dump) of the database, so you can restore everything if it goes wrong.

You should regularly make a back-up anyway.
Logged
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here
Pages: [1]   Go Up
 

Page created in 0.023 seconds with 19 queries.