Advanced search  


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.

Pages: [1]   Go Down

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

0 Members and 1 Guest are viewing this topic.


  • Contributor
  • Coppermine frequent poster
  • ***
  • Country: de
  • Offline Offline
  • Posts: 207
    • 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: 15530
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.017 seconds with 20 queries.