🌍
Deutsch
so...bin einen Schritt weiter.
Nach der Anleitung:
http://piwigo.org/forum/viewtopic.php?id=27923
Habe ich die beiden Felder eingefühgt.
Jetzt sieht die Fehlermeldung noch so aus:
Warning: [mysql error 1054] Unknown column 'lastmodified' in 'field list'
UPDATE piwigo_user_infos
SET last_visit = NOW(),
lastmodified = lastmodified
WHERE user_id = 1
in /homepages/31/d276404869/htdocs/piwigo/include/dblayer/functions_mysqli.inc.php on line 845
bzw beim Foto Hinzufügen:
Warning: [mysql error 1054] Unknown column 'lastmodified' in 'field list'
SELECT CONCAT(
UNIX_TIMESTAMP(MAX(lastmodified)),
"_",
COUNT(*)
)
FROM piwigo_categories
; in /homepages/31/d276404869/htdocs/piwigo/include/dblayer/functions_mysqli.inc.php on line 845
Fatal error: Uncaught Error: Call to a member function fetch_row() on boolean in /homepages/31/d276404869/htdocs/piwigo/include/dblayer/functions_mysqli.inc.php:231 Stack trace: #0 /homepages/31/d276404869/htdocs/piwigo/admin/include/functions.php(2988): pwg_db_fetch_row(false) #1 /homepages/31/d276404869/htdocs/piwigo/admin/include/photos_add_direct_prepare.inc.php(183): get_admin_client_cache_keys(Array) #2 /homepages/31/d276404869/htdocs/piwigo/admin/photos_add_direct.php(64): include_once('/homepages/31/d...') #3 /homepages/31/d276404869/htdocs/piwigo/admin/photos_add.php(88): include('/homepages/31/d...') #4 /homepages/31/d276404869/htdocs/piwigo/admin.php(302): include('/homepages/31/d...') #5 {main} thrown in /homepages/31/d276404869/htdocs/piwigo/include/dblayer/functions_mysqli.inc.php on line 231
???
Gruß
Jochen
Hallo Ludwig,
Danke für die Hilfestellung!
Ich habe gestern bestimmt 2 Std oder mehr damit verbracht, im Forum etwas darüber zu finden. Aber wahrscheinlich stelle ich die falschen Fragen.
Die ersten Meldungen sind erledigt, aber ab:
Warning: [mysql error 1054] ...
(siehe Post 1 unten)
Mein Suchen hat zwar einige Fundstellen zu ERR1054 gezeigt, aber mit anderen Bezügen bzw. einige Jahre alt.
Geändert hat sich die letzte Fatal error Meldung:
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /homepages/31/d276404869/htdocs/piwigo/include/dblayer/functions_mysqli.inc.php:911 Stack trace: #0 /homepages/31/d276404869/htdocs/piwigo/admin/include/functions_history.inc.php(195): query2array('\nSELECT\n *\n ...') #1 /homepages/31/d276404869/htdocs/piwigo/include/functions.inc.php(502): history_summarize(50000) #2 /homepages/31/d276404869/htdocs/piwigo/index.php(374): pwg_log() #3 {main} thrown in /homepages/31/d276404869/htdocs/piwigo/include/dblayer/functions_mysqli.inc.php on line 911
schon mal vielen Dank für die Unterstützung!
Gruß
Jochen
P.S. Jetzt verstehe ich auch Deine Hinweis "Schau doch mal...."
Warum mir der Beitrag nicht aufgefallen ist???wahre die Gedanke wahrscheinlich woanders....Sorry
In der /include/commom.inc.php bitte folgendes einfügen, am Besten ganz am Anfang nach <?php :
date_default_timezone_set('Europe/Berlin');
LG Ludwig
PS: Schau doch mal auf den Eintrag unter deinem Eintrag hier - sollte man schon ab und zu mal lesen.
Medungen wenn ich piwigo aufrufe.
Beider Installtion ist alles durchgelaufen.
Provider: 1und1
Strict Standards: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier.
We selected 'Europe/Berlin' for 'CEST/2.0/DST' instead in /homepages/31/d276404869/htdocs/piwigo/include/common.inc.php on line 141
Strict Standards: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CEST/2.0/DST' instead in /homepages/31/d276404869/htdocs/piwigo/include/common.inc.php on line 141
Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /homepages/31/d276404869/htdocs/piwigo/include/common.inc.php:141) in /homepages/31/d276404869/htdocs/piwigo/include/common.inc.php on line 156
Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /homepages/31/d276404869/htdocs/piwigo/include/common.inc.php:141) in /homepages/31/d276404869/htdocs/piwigo/include/common.inc.php on line 156
Warning: Cannot modify header information - headers already sent by (output started at /homepages/31/d276404869/htdocs/piwigo/include/common.inc.php:141) in /homepages/31/d276404869/htdocs/piwigo/include/page_header.php on line 101
Jetzt kommt "Meine Piwigo-Fotogalerie
Willkommen!" usw..
Aber dann:
Warning: [mysql error 1054] Unknown column 'last_visit' in 'field list'
UPDATE piwigo_user_infos
SET last_visit = NOW(),
lastmodified = lastmodified
WHERE user_id = 2
in /homepages/31/d276404869/htdocs/piwigo/include/dblayer/functions_mysqli.inc.php on line 845
Warning: [mysql error 1054] Unknown column 'format_id' in 'field list'
INSERT INTO piwigo_history
(
date,
time,
user_id,
IP,
section,
category_id,
image_id,
image_type,
format_id,
auth_key_id,
tag_ids
)
VALUES
(
CURRENT_DATE,
CURRENT_TIME,
2,
'87.189.141.92',
'categories',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL
)
; in /homepages/31/d276404869/htdocs/piwigo/include/dblayer/functions_mysqli.inc.php on line 845
Warning: [mysql error 1054] Unknown column 'history_id_to' in 'where clause'
SELECT
*
FROM piwigo_history_summary
WHERE history_id_to IS NOT NULL
ORDER BY history_id_to DESC
LIMIT 1
; in /homepages/31/d276404869/htdocs/piwigo/include/dblayer/functions_mysqli.inc.php on line 845
Fatal error: Call to a member function fetch_assoc() on a non-object in /homepages/31/d276404869/htdocs/piwigo/include/dblayer/functions_mysqli.inc.php on line 911
...und absoluter Neuling....
Dank an alle die sich damit auseinadersetzten!!!
Gruß aus dem Neanderthal
Jochen