Fehlermeldung

  • Notice: Only variables should be passed by reference in anzeige() (Zeile 22 von /WWWROOT/91127/htdocs/modules/php/php.module(80) : eval()'d code).
  • Notice: Only variables should be passed by reference in anzeige() (Zeile 22 von /WWWROOT/91127/htdocs/modules/php/php.module(80) : eval()'d code).
  • Notice: Only variables should be passed by reference in anzeige() (Zeile 22 von /WWWROOT/91127/htdocs/modules/php/php.module(80) : eval()'d code).
  • Notice: Only variables should be passed by reference in anzeige() (Zeile 22 von /WWWROOT/91127/htdocs/modules/php/php.module(80) : eval()'d code).
  • Notice: Only variables should be passed by reference in anzeige() (Zeile 22 von /WWWROOT/91127/htdocs/modules/php/php.module(80) : eval()'d code).
  • Notice: Only variables should be passed by reference in anzeige() (Zeile 22 von /WWWROOT/91127/htdocs/modules/php/php.module(80) : eval()'d code).
  • Notice: Only variables should be passed by reference in anzeige() (Zeile 22 von /WWWROOT/91127/htdocs/modules/php/php.module(80) : eval()'d code).
  • Notice: Only variables should be passed by reference in anzeige() (Zeile 22 von /WWWROOT/91127/htdocs/modules/php/php.module(80) : eval()'d code).
  • Notice: Only variables should be passed by reference in anzeige() (Zeile 22 von /WWWROOT/91127/htdocs/modules/php/php.module(80) : eval()'d code).
  • Notice: Only variables should be passed by reference in anzeige() (Zeile 22 von /WWWROOT/91127/htdocs/modules/php/php.module(80) : eval()'d code).

Test der PHP-Starseite Drupal 7


Das war los in Niederfrohna

CLT 2022

Startseite NF

<?php

function anzeige_ohne_caption($sql){
$result = db_query_range($sql,0,10);
foreach ($result as $record) {
$node=node_load($record->nid);
$node->title = '';
$anzeige = node_view($node, 'full');
$rendered = render($anzeige);
print $rendered;
echo '<hr />';
}
}

function anzeige($sql,$caption=''){
$result = db_query_range($sql,0,10);
if (($result->rowCount()>0) and ($caption<>'')) {
echo '<hr />';
echo '<h2>'.$caption.'</h2>';
echo '<hr />';
}
foreach ($result as $record) {
$node=node_load($record->nid);
$anzeige = node_view($node, 'teaser');
$rendered = render($anzeige);
print $rendered;
}
}

// Das Intro anzeigen
$sql = "SELECT * FROM {node} WHERE nid=1 ORDER BY created ASC";
anzeige_ohne_caption($sql);

// Die oben in Listen Termine anzeigen
$sql = "SELECT * FROM {node} WHERE type = 'article' AND status = 1 AND nid<>1 AND promote=1 AND sticky=1 ORDER BY created ASC";
anzeige($sql,'');

// Die heutigen Termine anzeigen
$sql = "SELECT * FROM {node} WHERE type = 'article' AND status = 1 AND nid<>1 AND promote=1 AND sticky=0 AND DATE(FROM_UNIXTIME(created))=CURDATE() ORDER BY created DESC";
anzeige($sql,'Heute in Niederfrohna');

//Zukunft anzeigen 28 Tage
$sql = "SELECT * FROM {node} WHERE type = 'article' AND status = 1 AND nid<>1 AND promote=1 AND sticky=0 AND DATE(FROM_UNIXTIME(created))>CURDATE() AND FROM_UNIXTIME(created)<DATE_ADD(CURDATE(),INTERVAL 28 DAY)
ORDER BY created ASC";
anzeige($sql,'Demnächst in Niederfrohna');

//Vergangenheit anzeigen
$sql = "SELECT * FROM {node} WHERE type = 'article' AND status = 1 AND nid<>1 AND promote=1 AND DATE(FROM_UNIXTIME(created))<CURDATE() AND sticky<>1 ORDER BY created DESC";
anzeige($sql,'Das war los in Niederfrohna');

?>

Tags: 

Docker

svn checkout https://svn.wlsoft.de/web/docker

$ sudo docker ps -a

$ docker image prune

$ docker image list

cd ~/Entwicklung/docker/lizenz
sudo docker build . -t wnf_lizenz

sudo docker-compose down

$ sudo docker-compose up -d

$ sudo docker exec -it lizenz_lizenz_1 /bin/bash

Tastatur mit Hintergrundbeleuchtung

In der Bedienungsanleitung steht, dass die Beleuchtung mit der SL-Taste eingeschaltet wird.

Das funktioniert unter Linux nicht.

Die Suche nach linux keyboard backlight control erbrachte

$ xset led 3

Redmine unter Docker

docker-compose.yml

version: '3.3'

services:

  redmine:
    image: redmine
    restart: always
    ports:
      - 8080:3000
    secrets:
      - mysql_root
      - mysql_user
    environment:
      REDMINE_DB_MYSQL: db
      REDMINE_DB_PASSWORD_FILE: /run/secrets/mysql_root
      REDMINE_SECRET_KEY_BASE_FILE: /run/secrets/mysql_user
    volumes:
      - ./files:/usr/src/redmine/files

  db:
    image: mariadb:latest
    restart: always
    secrets:
      - mysql_root
    environment:
      MYSQL_ROOT_PASSWORD_FILE: /run/secrets/mysql_root
      MYSQL_DATABASE: redmine
    volumes:
      - ./db:/var/lib/mysql
      - ./init:/docker-entrypoint-initdb.d
      - ./backup:/var/backups

secrets:
  mysql_root:
    file: ./mysql_root.txt
  mysql_user:
    file: ./mysql_user.txt

FirebirdSql Too many Contexts of Relation/Procedure/Views. Maximum allowed is 255.

Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements.
SQL error state =54001
Dynamic SQL Error.
Too many Contexts of Relation/Procedure/Views. Maximum allowed is 255.

Dieser Fehler tritt auf, obwohl der EXECUTE BLOCK definitiv nur 250 Update Anweisungen enthält.

Was ich nicht bedacht hatte, war dass durch die Update-Anweisungen Trigger ausgelöst wurden …

Deshalb habe ich die Anzahl der Anweisungen im Execute-Block auf 60 begrenzt und der Fehler wird nicht mehr ausgelöst.