Advanced search  


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.

Pages: [1]   Go Down

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

0 Members and 1 Guest are viewing this topic.


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

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


  • Administrator
  • Coppermine addict
  • ****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
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.
Pages: [1]   Go Up

Page created in 0.03 seconds with 19 queries.