Kritischer Fehler
Beim Ausführen einer Datenbank-Abfrage ist ein Fehler aufgetreten.
While executing query "select count(user_id) from **ERROR** where UPPER(user_name) = UPPER('Test')" on 0
mySQL error: 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 '**ERROR** where UPPER(user_name) = UPPER('Test')' at line 1
Datei: /home/www/web1/html/PORTAL/modules/Gallery/include/functions.inc.php - Zeile: 281
Zeile 281: cpg_die(CRITICAL_ERROR, $out, __FILE__, __LINE__);
Debug-Info
USER:
------------------
Array
(
[ID] => 0c0ca6dc2b692ea99943b6bba8f0afef
[am] => 1
[lang] => german
[liv] => Array
(
[0] => 22687
)
)
==========================
USER DATA:
------------------
Array
(
[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 1
[ufc_max] => 3
[ufc_min] => 3
[custom_user_upload] => 1
[num_file_upload] => 5
[num_URI_upload] => 3
[can_post_comments] => 1
[can_upload_pictures] => 0
[can_create_albums] => 0
[has_admin_access] => 0
[pub_upl_need_approval] => 0
[priv_upl_need_approval] => 0
[group_name] => -GAST
[upload_form_config] => 3
[group_quota] => 0
[can_see_all_albums] => 0
[group_id] => 3
[groups] => Array
(
[0] => 3
)
[user_id] => 0
[user_name] => GAST
)
==========================
Queries:
------------------
Array
(
[0] => SELECT extension, mime, content, player FROM mx37894_cpg133_filetypes; (0.004s)
[1] => select * from mx37894_cpg133_plugins order by priority asc; (0.001s)
[2] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as priv_upl_need_approval FROM mx37894_cpg133_usergroups WHERE group_id in (3) (0.002s)
[3] => SELECT group_name FROM mx37894_cpg133_usergroups WHERE group_id= 3 (0.001s)
[4] => DELETE FROM mx37894_cpg133_banned WHERE expiry < '2006-03-12 23:15:07' (0.001s)
[5] => SELECT * FROM mx37894_cpg133_banned WHERE (ip_addr='84.160.176.193' OR ip_addr='84.160.176.193' OR user_id=0) AND brute_force=0 (0.001s)
[6] => SELECT comments FROM mx37894_cpg133_pictures, mx37894_cpg133_albums WHERE mx37894_cpg133_pictures.aid = mx37894_cpg133_albums.aid AND pid='22687' (0.002s)
[7] => select count(user_id) from **ERROR** where UPPER(user_name) = UPPER('Test') (0.001s)
)
==========================
GET :
------------------
Array
(
[name] => Gallery
[act] => db_input
)
==========================
POST :
------------------
Array
(
[name] => Gallery
[act] => db_input
[msg_author] => Test
[msg_body] => Test
[event] => comment
[pid] => 22687
[submit] => OK
)
==========================
Page generated in 0.647 seconds - 8 queries in 0.013 seconds - Album set : ; Meta set: ;
und nun?
Fehler erst nach Umstellen auf pragmaMX und Update auf coppermine 1.4.2. und nach Update 1.4.3. immer noch da.
Angemeldete User können problemlos schreiben.
Vor großen Crossgrade ging es.
MySQL 4.0.21
PHP Version 4.3.3
steht hier in der Doku:
http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#group_cp
habe ich alle auf ERLAUBT gesetzt!!!!
Geht trotzdem nicht!
Solche Dinge überprüfe ich al erstes, bevor ich hier rein schreibe.
Öhm,
weiß keiner, woran das liegt? Ist jemand am Bugfix?
Sieht ganz nach diesem Problem (http://www.pragmamx.org/modules.php?name=Forum&topic=15557.msg107382#msg107382) hier aus, oder?
Gruß
Arne
Hi :)
:gucken: http://www.pragmamx.org/forum-topic-15919.0.html
gerade eben veröffentlicht ;)
Jetzt überraschst du mich aber ^^***
Werds heute abend gleich ausprobieren