Hallo Thomas,

ich habe es jetzt wie folgt gelöst:

Das Verzeichnis und die Datenbank auf den Rechner geladen.
Das Automatische Update gemacht.
Dann auf dem Server ein neues Verzeichnis erstellt, und die Daten den hochgeladen.
Dann habe ich die Datenbank wieder vom Rechner Exportritt und auf dem Server eine NEUE Datenbank erstellt.

Wenn denn alles läuft wie gewünscht kann man die alte Galerie löschen und die neue freigeben.

Gruß Claus!

Deine Links sind zur Zeit nicht erreichbar.......

„No upgrade required, the database structure is up to date“ bedeutet, das deine Datenbankstruktur sich auf der aktuellen Version befindet.

Die Tabellenzeilen piwigo_themes und piwigo_languages müssen aber irgendwo vorhanden sein. Wenn du magst, kannst du mir die Zugangsdaten mailen und ich schaue es mir einmal an.

scheint jetzt zu funktionieren. Falls es noch Probleme geben sollte, lösche in der Mysql-Tabelle die Zeilen piwigo_themes und piwigo_languages.

Hallo,

ich wollt meine Homepage auf den neusten stand bringen. Jetzt habe ich folgen Fehler Meldung: „No upgrade required, the database structure is up to date“ auf der upgrade.php Seite und auf der index Seite steht folgendes:
Warning: [mysql error 1054] Unknown column 'ui.theme' in 'on clause'

SELECT
    ui.*,
    uc.*,
    t.name AS theme_name
  FROM sf_2009_user_infos AS ui
    LEFT JOIN sf_2009_user_cache AS uc ON ui.user_id = uc.user_id
    LEFT JOIN sf_2009_themes AS t ON t.id = ui.theme
  WHERE ui.user_id = 1
; in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/dblayer/functions_mysql.inc.php on line 656
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/dblayer/functions_mysql.inc.php on line 155 Warning: array_merge(): Argument #2 is not an array in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/functions_user.inc.php on line 330 Warning: Invalid argument supplied for foreach() in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/functions_user.inc.php on line 332 Notice: Undefined index: id in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/functions_user.inc.php on line 361 Notice: Undefined index: status in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/functions_user.inc.php on line 361
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

SELECT cat_id
  FROM sf_2009_user_access
  WHERE user_id =
; in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/dblayer/functions_mysql.inc.php on line 656
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/dblayer/functions_mysql.inc.php on line 202
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

SELECT cat_id
  FROM sf_2009_user_group AS ug INNER JOIN sf_2009_group_access AS ga
    ON ug.group_id = ga.group_id
  WHERE ug.user_id =
; in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/dblayer/functions_mysql.inc.php on line 656
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/dblayer/functions_mysql.inc.php on line 202 Notice: Undefined index: level in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/functions_user.inc.php on line 369
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

SELECT DISTINCT(id)
  FROM sf_2009_images INNER JOIN sf_2009_image_category ON id=image_id
  WHERE category_id NOT IN (74,57,58,60,64,66,67,100,76,77,78,79,80,82,84,85,86,87,88,89,90,92,93,96,97,98,99,103,104,106,107,108,109,110)
    AND level> in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/dblayer/functions_mysql.inc.php on line 656
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/dblayer/functions_mysql.inc.php on line 202 Notice: Undefined index: level in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/functions_user.inc.php on line 689
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE c.id NOT IN (74,57,58,60,64,66,67,100,76,77,78,79,80,82,84,85,86,87,88,89,' at line 8
SELECT c.id AS cat_id, global_rank,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM sf_2009_categories as c
  LEFT JOIN sf_2009_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN sf_2009_images AS i
    ON ic.image_id = i.id
      AND i.level<=
  WHERE c.id NOT IN (74,57,58,60,64,66,67,100,76,77,78,79,80,82,84,85,86,87,88,89,90,92,93,96,97,98,99,103,104,106,107,108,109,110)
  GROUP BY c.id, c.global_rank in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/dblayer/functions_mysql.inc.php on line 656
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/dblayer/functions_mysql.inc.php on line 155 Notice: Undefined index: status in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/functions_user.inc.php on line 390 Notice: Undefined index: id in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/functions_user.inc.php on line 417
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

DELETE FROM sf_2009_user_cache_categories
  WHERE user_id =  in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/dblayer/functions_mysql.inc.php on line 656
Notice: Undefined index: id in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/functions_user.inc.php on line 436
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

DELETE FROM sf_2009_user_cache
  WHERE user_id =  in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/dblayer/functions_mysql.inc.php on line 656
Notice: Undefined index: id in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/functions_user.inc.php on line 444
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''false',1287514306,'74,57,58,60,64,66,67,100,76,77,78,79,80,82,84,85,86,87,88,89' at line 5

INSERT INTO sf_2009_user_cache
  (user_id, need_update, cache_update_time, forbidden_categories, nb_total_images,
    image_access_type, image_access_list)
  VALUES
  (,'false',1287514306,'74,57,58,60,64,66,67,100,76,77,78,79,80,82,84,85,86,87,88,89,90,92,93,96,97,98,99,103,104,106,107,108,109,110',440,'NOT IN','0') in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/dblayer/functions_mysql.inc.php on line 656
Notice: Undefined index: nb_image_line in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/functions_user.inc.php on line 246 Notice: Undefined index: nb_line_page in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/functions_user.inc.php on line 246
Warning: [mysql error 1054] Unknown column 'theme' in 'field list'

UPDATE sf_2009_user_infos
  SET theme = 'Sylvia'
  WHERE user_id = '2' in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/dblayer/functions_mysql.inc.php on line 656
Notice: Undefined index: language in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/common.inc.php on line 129 Notice: Undefined index: language in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/common.inc.php on line 133 Warning: Cannot modify header information - headers already sent by (output started at /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/dblayer/functions_mysql.inc.php:155) in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/functions_html.inc.php on line 483 Warning: Cannot modify header information - headers already sent by (output started at /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/dblayer/functions_mysql.inc.php:155) in /srv/www/vhosts/suedbahn-fuzzy.de/httpdocs/de/include/common.inc.php on line 189 Die Galerie ist gesperrt wegen Wartungsarbeiten. Bitte besuchen Sie uns später wieder.

Was muss ich tun das die Seite wieder Läuft?
Hier noch der Link zur Seite: http://suedbahn-fuzzy.de/de/