News:

CRITICAL UPGRADE CPG RELEASE 1.6.30
Version 1.6.30 removes a serious security issue that could allow unauthorized access to modify your site. Upgrade as soon as possible.

Main Menu

Leere Alben löschen

Started by sindbad5, April 15, 2017, 08:36:31 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

sindbad5

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

Αndré

Führe folgende SQL-Abfrage in einem Tool deiner Wahl (z.B. phpMyAdmin) aus:
DELETE FROM cpg15x_albums WHERE aid NOT IN (SELECT aid FROM cpg15x_pictures)

Ggf. muss der Tabellenpräfix (cpg15x_) an beiden Stellen angepasst werden.