Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

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

0 Members and 1 Guest are viewing this topic.

sindbad5

  • Contributor
  • Coppermine frequent poster
  • ***
  • Country: de
  • Offline Offline
  • Posts: 215
    • 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: 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.