🌍
Deutsch
Beim berechnen einiger Thumbnails kam kurz vor Ende die nachfolgende Fehlermeldung, seit dem habe ich keinen Zugriff mehr:
Fatal error:
Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND level > 2 AND level <= 8 GROUP BY category_id' at line 5 in /usr/www/users/gxxxxs/piwigo/include/dblayer/functions_mysqli.inc.php:132 Stack trace: #0 /usr/www/users/gxxxxs/piwigo/include/dblayer/functions_mysqli.inc.php(132): mysqli->query() #1 /usr/www/users/gxxxxs/piwigo/include/dblayer/functions_mysqli.inc.php(888): pwg_query() #2 /usr/www/users/gxxxxs/piwigo/include/functions.inc.php(1633): query2array() #3 /usr/www/users/gxxxxs/piwigo/plugins/community/include/functions_community.inc.php(197): hash_from_query() #4 /usr/www/users/gxxxxs/piwigo/plugins/community/main.inc.php(49): community_get_user_permissions() #5 /usr/www/users/gxxxxs/piwigo/include/functions_plugins.inc.php(264): community_init() #6 /usr/www/users/gxxxxs/piwigo/include/common.inc.php(341): trigger_notify() #7 /usr/www/users/gxxxxs/piwigo/index.php(11): include_once('/usr/www/users/...') #8 {main} thrown in /usr/www/users/gxxxxs/piwigo/include/dblayer/functions_mysqli.inc.php on line 132
Offline
Ohne irgendwelche Info über Version/Hosting/Plugins ist das reines raten. Wenn ich das sehe „ community_get_user_permissions() #5“ würde ich auf das Community Plugin tippen. Was heißt keinen Zugriff? Keine Anmeldung? Funktioniert die Galerie garnicht mehr?
Offline
Hi drlecter und Danke!
Version 15.3.0
Kein Zugriff heisst dass ich mich über den Web-Browser nicht mehr in die Datenbank anmelden kann oder Bilder sehe. Auch die nicht die quasi öffentlich sind, es kommt sofort die angeführte Fehlermeldung.
Ich habe auch keinen direkten Zugriff auf den Server der wird von einem Kollegen administriert der mir gerade mitgeteilt hat dass er das Community Plugin deaktiviert hat, war auch sein erster Gedanke, aber das hat offenbar nicht geholfen. Der Kollege ist nur gerade in Thailand und wir haben eine 6 Stunden Zeitverschiebung.
Er kennt sich definitiv besser aus und wird sich hier melden, vielleicht heute noch.
Er weiss aber auch noch nicht wo er ansetzen soll. Wir sind also für jeden Tipp dankbar!!!
Vielen Dank!
Offline
Hallo,
Ein paar weitere infos zu dem Problem:
mariadb Ver 15.1 Distrib 10.11.6-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper
php 8.3
Server version: Apache/2.4.62 (Debian)
Die Fehlermeldung meines Kollegen beinhaltete nicht mehr das community plugin nachdem ich es entfernt hatte.
Seine Piwigo Instanz beinhaltet ~150000 Fotos und Videos, rund 750 gb an Daten. Gehostet auf einem Managed Server bei Hetzner.
Falls Sie eine Lösung haben, wäre ich ihnen sehr dankbar.
MfG,
Tom Wagner
SELECT @@SESSION.sql_mode SELECT param, value FROM piwigo_config ;
Warning: session_start(): Session cannot be started after headers have already been sent in /usr/www/users/georges/piwigo/include/common.inc.php on line 155
SELECT * FROM piwigo_plugins WHERE state='active' SELECT id, name FROM piwigo_languages ORDER BY name ASC ;SELECT id, name FROM `piwigo_groups` ORDER BY name SELECT id, name FROM piwigo_languages ORDER BY name ASC ;SELECT state FROM piwigo_plugins WHERE id = 'ContactForm';SELECT state FROM piwigo_plugins WHERE id = 'ContactForm'; SELECT image_id, date_available, NOW() AS dbnow FROM piwigo_lounge JOIN piwigo_images ON image_id = id ORDER BY image_id ASC LIMIT 1 ; SELECT id AS id , username AS username , password AS password , mail_address AS email FROM piwigo_users WHERE id = '2' SELECT ui.*, uc.*, t.name AS theme_name FROM piwigo_user_infos AS ui LEFT JOIN piwigo_user_cache AS uc ON ui.user_id = uc.user_id LEFT JOIN piwigo_themes AS t ON t.id = ui.theme WHERE ui.user_id = 2 ; SELECT id, name FROM piwigo_languages ORDER BY name ASC ; SELECT * FROM piwigo_user_infos WHERE user_id = 2 ; SELECT cf.name AS cf_name, cf.email AS cf_email, u.username AS u_name, u.mail_address AS u_email FROM piwigo_contact_form AS cf LEFT JOIN piwigo_users AS u ON cf.user_id = u.id SELECT group_id FROM piwigo_user_group WHERE user_id = 2 ; SELECT `id`, `type`, `category_id`, `user_album`, `recursive`, `create_subcategories`, `nb_photos`, `storage` FROM piwigo_community_permissions WHERE (`type` = 'any_visitor') ; SELECT id FROM piwigo_categories WHERE status = 'private' ; SELECT cat_id FROM piwigo_user_access WHERE user_id = 2 ; SELECT cat_id FROM piwigo_user_group AS ug INNER JOIN piwigo_group_access AS ga ON ug.group_id = ga.group_id WHERE ug.user_id = 2 ; SELECT id FROM piwigo_categories WHERE visible = 'false' ; SELECT category_id FROM piwigo_image_category JOIN piwigo_images ON image_id = id WHERE category_id IN (9544,9562,9563,9564,9565,9566,9567,9568,9569,9570,9571,9572,9573,9574,9575,9576,9577,9579,9580,9581,9582,9583,9584,9585,9586,9587,9588,9590,9591,9592,9596,9597,9598,9599,9600,9601,9602,9603,9604,9605,9607,9608,9609,9610,9629,9630,9631,9633,9634,9635,9636,9637,9639,9640,9641,10718,13231,13232,13233,13770,13771,13850,13851,13941,13942,14082,14083,14084,14085,14161,14216,14234,14235,14236,14237,14238,14282,14283,14284,14285,14286,14287,14288,14289,14290,14291,14292,14293,14294,14295,14296,14297,14298,14299,14300,14301,14302,14303,14304,14240,14305,13838,13839,13840,13841,13842,13727,10156,11259,11668,12028,12776,) AND level > 2 AND level <= 8 GROUP BY category_id ;
Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND level > 2 AND level <= 8 GROUP BY category_id' at line 5 in /usr/www/users/georges/piwigo/include/dblayer/functions_mysqli.inc.php:133 Stack trace: #0 /usr/www/users/georges/piwigo/include/dblayer/functions_mysqli.inc.php(133): mysqli->query() #1 /usr/www/users/georges/piwigo/include/dblayer/functions_mysqli.inc.php(889): pwg_query() #2 /usr/www/users/georges/piwigo/include/functions.inc.php(1633): query2array() #3 /usr/www/users/georges/piwigo/plugins/community/include/functions_community.inc.php(197): hash_from_query() #4 /usr/www/users/georges/piwigo/plugins/community/main.inc.php(49): community_get_user_permissions() #5 /usr/www/users/georges/piwigo/include/functions_plugins.inc.php(264): community_init() #6 /usr/www/users/georges/piwigo/include/common.inc.php(341): trigger_notify() #7 /usr/www/users/georges/piwigo/index.php(11): include_once('/usr/www/users/...') #8 {main} thrown in /usr/www/users/georges/piwigo/include/dblayer/functions_mysqli.inc.php on line 133
Offline
Wie wurde das Plugin entfern? Kann man sich noch m Backend anmelden? Falls die Meldung unten aktuell ist, dann stimmt da noch etwas nicht:
/usr/www/users/georges/piwigo/plugins/community/include/functions_community.inc.php(197): hash_from_query() #4 /usr/www/users/georges/piwigo/plugins/community/main.inc.php(49): community_get_user_permissions() #5 /usr/www/users/georges/piwigo/include/functions_plugins.inc.php(264): community_init() #6
Man kann AFAIK (ich habe das selber noch nicht ausprobiert) direkt in der DB deaktivieren (https://piwigo.org/forum/viewtopic.php?id=31946)
Sind unter _data/logs Logfiles wo etwas drin steht?
Offline
Aktuell ist die letzte Fehlermeldung die ich geposted habe. Dies sieht mir eher nach einem Datenbankproblem aus. Das community plugin hatte ich einfach in einen anderen Ordner verschoben. Aber das dürfte nicht das problem sein. Jetzt habe ich es mit phpmyadmin uber die Datenbanktabelle piwigo_plugins ausgeschaltet. Hat so oder so aber nichts geholfen.
Wahrscheinlicher Fehler:
Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) GROUP BY tag_id' at line 6
Beim Versuch die Seite anzuzeigen kommt unter anderem obige fehlermeldung. Die ganze mit den sqlkommandos ist in meinem 1. Post.
Die seite wird nicht angezeigt und es ist kein login möglich.
Danke,
Tom
Offline
Kannst du schauen, von wann die Datein sind? Die mit den SQL Anweisungen?
Es ist nur ein Vermutung, aber es kann ggf. auch sein, dass das Plugin die Scripte mit angepasst hat.
Wurde etwas an der Datenbank geändert? Neue Version?
Offline
Der Einfachheit halber, hier die Fehlermeldung von heute, beim Versuch die erste Seite aufzurufen. Das Community plugin ist da nicht mehr enthalten.
Auf demselben server habe ich noch 3 andere piwigoinstallationen, die dieses Problem nicht haben. (15.3.0)
___________________________________________________________________
SELECT @@SESSION.sql_mode SELECT param, value FROM piwigo_config ;
Warning: session_start(): Session cannot be started after headers have already been sent in /usr/www/users/georges/piwigo/include/common.inc.php on line 155
SELECT * FROM piwigo_plugins WHERE state='active' SELECT id, name FROM piwigo_languages ORDER BY name ASC ;SELECT id, name FROM `piwigo_groups` ORDER BY name SELECT id, name FROM piwigo_languages ORDER BY name ASC ;SELECT state FROM piwigo_plugins WHERE id = 'ContactForm';SELECT state FROM piwigo_plugins WHERE id = 'ContactForm'; SELECT image_id, date_available, NOW() AS dbnow FROM piwigo_lounge JOIN piwigo_images ON image_id = id ORDER BY image_id ASC LIMIT 1 ; SELECT id AS id , username AS username , password AS password , mail_address AS email FROM piwigo_users WHERE id = '2' SELECT ui.*, uc.*, t.name AS theme_name FROM piwigo_user_infos AS ui LEFT JOIN piwigo_user_cache AS uc ON ui.user_id = uc.user_id LEFT JOIN piwigo_themes AS t ON t.id = ui.theme WHERE ui.user_id = 2 ; SELECT id, name FROM piwigo_languages ORDER BY name ASC ; SELECT * FROM piwigo_user_infos WHERE user_id = 2 ; SELECT cf.name AS cf_name, cf.email AS cf_email, u.username AS u_name, u.mail_address AS u_email FROM piwigo_contact_form AS cf LEFT JOIN piwigo_users AS u ON cf.user_id = u.id SELECT mail_address FROM piwigo_users WHERE id = 1 ;SELECT pt.id, pt.visible, pt.nfo, ptl.lang, ptl.title, ptl.content FROM piwigo_amm_personalised pt LEFT JOIN piwigo_amm_personalised_langs ptl ON pt.id=ptl.id WHERE (ptl.lang = '*' OR ptl.lang = 'de_DE') AND ptl.content != '' ORDER BY pt.id, ptl.lang ASC SELECT id, name FROM piwigo_languages ORDER BY name ASC ;SELECT id, name FROM `piwigo_groups` ORDER BY nameSELECT pt.id, pt.visible, pt.nfo, ptl.lang, ptl.title, ptl.content FROM piwigo_amm_personalised pt LEFT JOIN piwigo_amm_personalised_langs ptl ON pt.id=ptl.id WHERE (ptl.lang = '*' OR ptl.lang = 'de_DE') AND ptl.content != '' ORDER BY pt.id, ptl.lang ASC SELECT id, name FROM piwigo_languages ORDER BY name ASC ;SELECT COUNT(id) AS nbGroup FROM `piwigo_groups`;SELECT group_id FROM piwigo_user_group WHERE user_id = '2';SELECT id, `order`, users, `groups` FROM piwigo_amm_blocks ORDER BY `order`;SELECT id, uppercats FROM piwigo_categories WHERE name LIKE "%%" SELECT id, name, permalink, nb_images, global_rank, date_last, max_date_last, count_images, count_categories FROM piwigo_categories INNER JOIN piwigo_user_cache_categories ON id = cat_id and user_id = 2 WHERE (id_uppercat IS NULL OR uppercats REGEXP '^[0-9]+,[0-9]+$') ; SELECT SUBDATE(CURRENT_DATE,INTERVAL 99 DAY) SELECT tag_id, COUNT(DISTINCT(it.image_id)) AS counter FROM piwigo_image_category ic INNER JOIN piwigo_image_tag it ON ic.image_id=it.image_id WHERE 1=1 AND (category_id NOT IN (9540,9544,9562,9563,9564,9565,9566,9567,9568,9569,9570,9571,9572,9573,9574,9575,9576,9577,9579,9580,9581,9582,9583,9584,9585,9586,9587,9588,9590,9591,9592,9596,9597,9598,9599,9600,9601,9602,9603,9604,9605,9607,9608,9609,9610,9629,9630,9631,9633,9634,9635,9636,9637,9639,9640,9641,10718,12426,12427,12428,12429,12430,12431,12432,12433,12434,12435,12436,12437,12438,12439,12440,12441,12442,12443,12444,12445,12446,12447,12448,12449,12450,12451,12452,12453,12454,12455,12456,12457,12514,12515,12516,12517,12518,12519,12520,12521,12522,12523,12524,12525,12527,12528,12529,12530,12531,12532,12533,12534,12535,12536,12537,12538,12539,12540,12541,12542,12543,12556,12557,12558,12559,12560,12561,12562,12743,12744,12745,12846,12877,12878,12879,12880,12881,12882,12883,12884,12885,12886,12887,12888,12889,12890,12891,12892,12893,12894,12895,12896,12897,12898,12899,12900,12901,12902,12903,12904,12905,12906,12907,12908,12909,12910,12911,12912,12913,12914,12915,12916,12917,12918,12919,12920,12921,12922,12923,12924,12925,12926,12927,12928,12929,12930,12931,12932,12933,12934,12935,12936,12937,12938,12939,12940,12941,12942,12943,12944,12945,12946,12947,12948,12949,12950,12951,12952,12953,12954,12955,12956,12957,13100,13101,13102,13103,13104,13105,13106,13107,13108,13109,13110,13111,13112,13113,13114,13115,13116,13117,13118,13119,13120,13121,13122,13123,13124,13125,13126,13127,13128,13129,13130,13131,13132,13133,13134,13135,13136,13137,13138,13139,13140,13141,13142,13143,13144,13145,13146,13147,13148,13149,13150,13151,13152,13153,13154,13155,13156,13157,13158,13159,13160,13161,13162,13163,13164,13165,13166,13167,13168,13169,13170,13171,13172,13173,13174,13175,13176,13177,13178,13179,13180,13181,13182,13183,13184,13185,13186,13187,13188,13189,13190,13191,13192,13193,13194,13195,13196,13197,13198,13199,13200,13201,13202,13203,13204,13205,13206,13207,13208,13209,13210,13211,13212,13213,13214,13215,13216,13217,13218,13219,13220,13221,13222,13223,13224,13225,13226,13228,13230,13231,13232,13233,13234,13235,13236,13237,13238,13239,13240,13241,13242,13243,13244,13245,13246,13247,13248,13249,13250,13251,13252,13253,13254,13255,13256,13257,13258,13259,13260,13261,13262,13263,13264,13265,13266,13267,13268,13269,13270,13271,13272,13273,13274,13275,13276,13277,13278,13279,13280,13281,13282,13283,13284,13285,13286,13287,13288,13289,13290,13291,13292,13293,13294,13295,13296,13297,13298,13299,13300,13301,13302,13303,13304,13305,13306,13307,13308,13309,13310,13311,13312,13313,13314,13315,13316,13317,13318,13319,13320,13321,13322,13323,13324,13325,13326,13327,13328,13329,13330,13331,13332,13333,13334,13335,13336,13337,13338,13339,13340,13341,13342,13343,13344,13345,13346,13347,13348,13349,13350,13351,13352,13353,13354,13355,13356,13357,13358,13359,13360,13361,13362,13363,13364,13365,13366,13367,13368,13369,13370,13371,13372,13373,13374,13375,13376,13377,13378,13379,13380,13381,13382,13383,13384,13385,13386,13387,13388,13389,13390,13391,13392,13393,13394,13395,13396,13397,13398,13399,13400,13401,13402,13403,13404,13405,13406,13407,13408,13409,13410,13411,13412,13413,13414,13415,13416,13417,13418,13419,13420,13421,13422,13423,13424,13425,13426,13427,13428,13429,13430,13431,13432,13433,13434,13435,13436,13437,13438,13439,13440,13441,13442,13443,13444,13445,13446,13447,13448,13449,13450,13451,13452,13453,13454,13455,13456,13457,13458,13459,13460,13461,13462,13463,13658,13659,13660,13661,13662,13663,13664,13665,13669,13670,13671,13672,13673,13674,13675,13676,13677,13678,13679,13680,13681,13682,13683,13684,13685,13686,13721,13722,13723,13726,13731,13733,13734,13740,13742,13743,13748,13749,13754,13756,13757,13758,13759,13760,13762,13764,13765,13770,13771,13773,13778,13781,13782,13784,13786,13787,13788,13789,13790,13791,13792,13799,13800,13801,13802,13803,13804,13805,13811,13812,13813,13814,13815,13816,13818,13830,13831,13832,13833,13834,13850,13851,13852,13853,13854,13859,13860,13871,13873,13896,13901,13908,13909,13913,13914,13917,13918,13919,13920,13922,13923,13924,13925,13926,13927,13928,13929,13931,13932,13941,13942,13944,13945,13946,13950,13951,13952,13953,13954,13955,13956,13959,13960,13965,13966,13967,13968,13969,13970,13971,13973,13974,13989,13990,13991,13992,13996,13998,13999,14000,14001,14003,14005,14006,14007,14008,14009,14010,14011,14012,14013,14014,14015,14016,14017,14023,14030,14035,14036,14037,14043,14059,14060,14061,14062,14064,14065,14066,14067,14071,14072,14073,14074,14075,14076,14077,14078,14079,14080,14082,14083,14084,14085,14087,14088,14089,14090,14096,14097,14098,14099,14100,14101,14102,14110,14111,14112,14114,14115,14116,14117,14118,14119,14120,14121,14122,14123,14124,14133,14134,14136,14139,14140,14141,14143,14144,14145,14146,14147,14148,14149,14151,14152,14153,14154,14157,14158,14159,14160,14161,14162,14163,14165,14166,14167,14168,14169,14170,14171,14172,14174,14175,14195,14196,14197,14198,14199,14200,14211,14212,14214,14215,14216,14218,14219,14220,14223,14226,14227,14229,14230,14231,14232,14233,14234,14235,14236,14237,14238,14239,14243,14244,14247,14261,14262,14267,14270,14272,14282,14283,14284,14285,14286,14287,14288,14289,14290,14291,14292,14293,14294,14295,14296,14297,14298,14299,14300,14301,14302,14303,14304,14306,14307,14308,14240,14305,13838,13839,13840,13841,13842,13727,10156,11259,11668,12028,12776,14309,14310,14311,14312,14313,14314,14315,14316,14317,14318,14319,14320,14321,14322,14323,14324,14325,14326,14327,14328,14329,14330,14331,14332,14333,14334,14335,14336,14337,14338,14339,14340,14341,14342,14343,14344,14345,14346,14347,14348,14349,14350,14351,14352,14353,14354,14355,14356,14357,14358,14359,14360,14361,14362,14363,14364,14365,14366,14367,14368,14369,14370,14371,14372,14373,14374,14375,14376,14377,14378,14379,14380,14381,14382,14383,14384,14385,14386,14387,14388,14389,14390,14391,14392,14393,14394,14395,14396,14397,14398,14399,14400,14401,14402,14403,14404,14405,14406,14407,)) GROUP BY tag_id ;
Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) GROUP BY tag_id' at line 6 in /usr/www/users/georges/piwigo/include/dblayer/functions_mysqli.inc.php:133 Stack trace: #0 /usr/www/users/georges/piwigo/include/dblayer/functions_mysqli.inc.php(133): mysqli->query() #1 /usr/www/users/georges/piwigo/include/dblayer/functions_mysqli.inc.php(889): pwg_query() #2 /usr/www/users/georges/piwigo/include/functions_tag.inc.php(80): query2array() #3 /usr/www/users/georges/piwigo/include/menubar.inc.php(178): get_available_tags() #4 /usr/www/users/georges/piwigo/include/menubar.inc.php(15): initialize_menu() #5 /usr/www/users/georges/piwigo/index.php(103): include('/usr/www/users/...') #6 {main} thrown in /usr/www/users/georges/piwigo/include/dblayer/functions_mysqli.inc.php on line 133
Offline
Hm bei der Anweisung ist am Ende wohl das , zuviel. Das ist nur eine Vermutung. Ich weiss aber nicht wo das generiert wird.
"AND (category_id NOT IN (9540,9544,9562,9563,9564,9565,9566,9567,9568,9569,9570,9571,9572,9573,9574,9575,9576,9577,9579,9580,9581,9582,9583,9584,9585,9586,9587,9588,9590,9591,9592,9596,9597,9598,9599,9600,9601,9602,9603,9604,9605,9607,9608,9609,9610,9629,9630,9631,9633,9634,9635,9636,9637,9639,9640,9641,10718,12426,12427,12428,12429,12430,12431,12432,12433,12434,12435,12436,12437,12438,12439,12440,12441.....14402,14403,14404,14405,14406,14407,)) GROUP BY tag_id ;"
Offline