Advanced search  

News:

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

Pages: [1]   Go Down

Author Topic: Leere Alben löschen  (Read 559 times)

0 Members and 1 Guest are viewing this topic.

sindbad5

  • Contributor
  • Coppermine frequent poster
  • ***
  • Country: de
  • Offline Offline
  • Posts: 203
    • My Images - medienarchiv.com
Leere Alben löschen
« on: April 15, 2017, 08:36:31 PM »

Hallo, kann man viele leere Alben auf einmal löschen? 
Tom
Logged

Αndré

  • Administrator
  • Coppermine addict
  • ****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15381
Re: Leere Alben löschen
« Reply #1 on: June 28, 2017, 05:07:17 PM »

Führe folgende SQL-Abfrage in einem Tool deiner Wahl (z.B. phpMyAdmin) aus:
Code: [Select]
DELETE FROM cpg15x_albums WHERE aid NOT IN (SELECT aid FROM cpg15x_pictures)
Ggf. muss der Tabellenpräfix (cpg15x_) an beiden Stellen angepasst werden.
Logged
Pages: [1]   Go Up
 

Page created in 0.075 seconds with 21 queries.