OXID: “OXPICSGENERATED” füllen
Seid ihr auch voll angenervt von der neuen Spalte ‘OXPICSGENERATED’ bei OXID? Hier ein kleiner SQL-Schnipsel der euch dieses Feld einmal füllt:
Nachtrag: vergesst was da oben steht, anscheinend muss oxpicsgenerated die Nummer des letzen Bildes enthalten (wenn kein bild #1 sondern nur #2 und #3 vorhanden, dann muss es nicht 2 sondern 3 enthalten!)
Bitte nutzt diesen SQL:
UPDATE oxarticles set oxpicsgenerated = 0;
UPDATE oxarticles set oxpicsgenerated = 1 WHERE OXPIC1 != ” AND OXPIC1 != ‘nopic.jpg’;
UPDATE oxarticles set oxpicsgenerated = 2 WHERE OXPIC2 != ” AND OXPIC2 != ‘nopic.jpg’;
UPDATE oxarticles set oxpicsgenerated = 3 WHERE OXPIC3 != ” AND OXPIC3 != ‘nopic.jpg’;
UPDATE oxarticles set oxpicsgenerated = 4 WHERE OXPIC4 != ” AND OXPIC4 != ‘nopic.jpg’;
UPDATE oxarticles set oxpicsgenerated = 5 WHERE OXPIC5 != ” AND OXPIC5 != ‘nopic.jpg’;
UPDATE oxarticles set oxpicsgenerated = 6 WHERE OXPIC6 != ” AND OXPIC6 != ‘nopic.jpg’;
UPDATE oxarticles set oxpicsgenerated = 7 WHERE OXPIC7 != ” AND OXPIC7 != ‘nopic.jpg’;
UPDATE oxarticles set oxpicsgenerated = 8 WHERE OXPIC8 != ” AND OXPIC8 != ‘nopic.jpg’;
UPDATE oxarticles set oxpicsgenerated = 9 WHERE OXPIC9 != ” AND OXPIC9 != ‘nopic.jpg’;
UPDATE oxarticles set oxpicsgenerated = 10 WHERE OXPIC10 != ” AND OXPIC10 != ‘nopic.jpg’;
UPDATE oxarticles set oxpicsgenerated = 11 WHERE OXPIC11 != ” AND OXPIC11 != ‘nopic.jpg’;
UPDATE oxarticles set oxpicsgenerated = 12 WHERE OXPIC12 != ” AND OXPIC12 != ‘nopic.jpg’;
