forum.coppermine-gallery.net
Support => Deutsch (German) => Language Specific Support => cpg1.5.x Deutsch (German) => Topic started by: topictyper on December 18, 2010, 09:37:10 pm
-
Guten abend zusammen,
nachdem ich nun meine kleine Galerie ins laufen bekommen habe, hat sich ein bekannter von mir vesucht dort zu registrieren.
ich habe als admin eine mail bekommen ihn freizuschalten, was ich auch getan habe. Hat auch alles wunderbar geklappt.
DOCH wenn ich mich als Administrator einlogge und mir meine user anzeigen will bekomme ich immer folgenden fehler:
Kritischer Fehler
Beim Ausführen einer Datenbank-Abfrage ist ein Fehler aufgetreten
Nun kenn ich mich ja etwas aus, der datei "usermgr.php" habe ich 777 als rechte erteilt.
Geht immernoch nicht. In diversen foren und webseiten habe ich mich dann informiert und via php myadmin alle tabellen geprüft und auch repariert.
Wobei keine Tabelle beschädigt war, somit gabs auch nichts zu reparieren...
Hat jemand eine Idee was ich noch tun könnte?
Vielen Dank im Vorraus
Topictyper
-
Bitte aktivere in den Einstellungen den Debug-Modus und poste die ausführliche Fehlermeldung.
-
Ich hoffe Ihr könnt da etwas raus lesen.
USER:
------------------
Array
(
[ID] => cf0344da73fb0026594c01b19b1ee9dc
[am] => 1
[lang] => german
[theme] => curve
[liv] => Array
(
[0] => 11
)
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_name] => topictyper
[groups] => Array
(
[0] => 1
)
[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 1
[can_post_comments] => 1
[can_upload_pictures] => 1
[can_create_albums] => 1
[has_admin_access] => 1
[access_level] => 3
[pub_upl_need_approval] => 0
[priv_upl_need_approval] => 0
[group_name] => Administrators
[can_create_public_albums] => 0
[group_quota] => 0
[can_see_all_albums] => 1
[group_id] => 1
[allowed_albums] => Array
(
)
)
==========================
Queries:
------------------
Array
(
[0] => SELECT name, value FROM cpg15x_config [include/init.inc.php:181] (0 ms)
[1] => SELECT COUNT(*) FROM cpg15x_pictures WHERE approved = 'NO' [include/functions.inc.php:2418] (0 ms)
[2] => SELECT lang_id, abbr FROM cpg15x_languages WHERE available='YES' AND enabled='YES' [include/themes.inc.php:2315] (0 ms)
[3] => DELETE FROM cpg15x_temp_messages WHERE time < 1292772381 [include/functions.inc.php:4927] (0 ms)
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
[gallery_name] => Topictype
[gallery_description] =>
[gallery_admin_email] => info@topictype.de
[ecards_more_pic_target] => http://topictype.de/
[home_target] => index.php
[enable_zipdownload] => 0
[time_offset] => 0
[enable_help] => 1
[clickable_keyword_search] => 1
[keyword_separator] => ;
[enable_plugins] => 1
[browse_batch_add] => 1
[batch_proc_limit] => 2
[display_thumbs_batch_add] => 1
[form_token_lifetime] => 900
[lang] => english
[language_autodetect] => 1
[charset] => utf-8
[theme] => curve
[display_sidebar_user] => 1
[display_sidebar_guest] => 1
[custom_lnk_name] =>
[custom_lnk_url] =>
[enable_menu_icons] => 2
[show_bbcode_help] => 1
[custom_header_path] =>
[custom_footer_path] =>
[display_redirection_page] => 0
[main_table_width] => 100%
[subcat_level] => 2
[albums_per_page] => 12
[album_list_cols] => 2
[alb_list_thumb_size] => 50
[main_page_layout] => breadcrumb/catlist/alblist/random,2/lastup,2
[first_level] => 1
[link_pic_count] => 1
[thumbcols] => 4
[thumbrows] => 3
[max_tabs] => 12
[tabs_dropdown] => 1
[caption_in_thumbview] => 1
[views_in_thumbview] => 1
[alb_desc_thumb] => 1
[default_sort_order] => na
[min_votes_for_rating] => 1
[picture_table_width] => 100%
[picinfo_movie_download_link] => 1
[max_img_desc_length] => 512
[max_film_strip_items] => 7
[slideshow_interval] => 5000
[slideshow_hits] => 1
[transparent_overlay] => 1
[rating_stars_amount] => 5
[filter_bad_words] => 1
[enable_smilies] => 1
[max_com_lines] => 10
[max_com_size] => 512
[max_com_wlength] => 38
[comments_sort_descending] => 0
[comments_per_page] => 20
[comments_anon_pfx] => Guest_
[comment_approval] => 0
[comment_placeholder] => 1
[comment_user_edit] => 1
[comment_captcha] => 1
[comment_akismet_api_key] =>
[comment_akismet_enable] => 0
[comment_akismet_group] => 0
[contact_form_guest_enable] => 0
[contact_form_guest_name_field] => 2
[contact_form_guest_email_field] => 2
[contact_form_registered_enable] => 1
[contact_form_subject_content] => Coppermine gallery contact form
[contact_form_subject_field] => 0
[contact_form_sender_email] => 1
[thumb_use] => any
[thumb_width] => 128
[thumb_height] => 128
[thumb_pfx] => thumb_
[unsharp_amount] => 120
[unsharp_radius] => 0.5
[unsharp_threshold] => 3
[jpeg_qual] => 100
[picture_use] => thumb
[picture_width] => 400
[max_upl_size] => 102400
[max_upl_width_height] => 2048
[auto_resize] => 1
[fullsize_padding_x] => 1
[fullsize_padding_y] => 3
[allow_private_albums] => 1
[forbiden_fname_char] => $/\\:*?"'<>|` &#@
[allowed_img_types] => jpeg/jpg/png/gif
[allowed_mov_types] => asf/asx/mpg/mpeg/wmv/swf/avi/mov
[media_autostart] => 1
[allowed_snd_types] => mp3/midi/mid/wma/wav/ogg
[allowed_doc_types] => doc/txt/rtf/pdf/xls/pps/ppt/zip/gz/mdb
[thumb_method] => gd2
[impath] => /usr/bin/
[im_options] => -antialias
[fullpath] => albums/
[userpics] => userpics/
[normal_pfx] => normal_
[default_dir_mode] => 0777
[default_file_mode] => 0666
[enable_thumb_watermark] => 1
[where_put_watermark] => southeast
[which_files_to_watermark] => both
[watermark_file] => images/watermark.png
[watermark_transparency] => 40
[reduce_watermark] => 0
[watermark_transparency_featherx] => 0
[watermark_transparency_feathery] => 0
[allow_user_registration] => 1
[global_registration_pw] =>
[user_registration_disclaimer] => 1
[registration_captcha] => 1
[reg_requires_valid_email] => 1
[reg_notify_admin_email] => 1
[admin_activation] => 1
[allow_unlogged_access] => 3
[upload_mechanism] => swfupload
[allow_user_upload_choice] => 1
[allow_duplicate_emails_addr] => 0
[login_method] => username
[login_threshold] => 5
[login_expiry] => 10
[purge_expired_bans] => 1
[rate_own_files] => 0
[user_profile1_name] => Location
[user_profile2_name] => Interests
[user_profile3_name] => Website
[user_profile4_name] => Occupation
[user_profile5_name] =>
[user_profile6_name] => Biography
[user_field1_name] =>
[user_field2_name] =>
[user_field3_name] =>
[user_field4_name] =>
[cookie_name] => cpg15x
[cookie_path] => /
[smtp_host] =>
[smtp_username] =>
[smtp_password] =>
[log_mode] => 0
[display_stats_on_index] => 1
[count_file_hits] => 1
[count_album_hits] => 1
[debug_mode] => 2
[update_config] => Neue Einstellungen speichern
[form_token] => 675703987f744b114fa8574cb6b22e06
[timestamp] => 1292775972
)
==========================
COOKIE :
------------------
Array
(
[cpg15x_data] => YTo1OntzOjI6IklEIjtzOjMyOiJjZjAzNDRkYTczZmIwMDI2NTk0YzAxYjE5YjFlZTlkYyI7czoyOiJhbSI7aToxO3M6NDoibGFuZyI7czo2OiJnZXJtYW4iO3M6NToidGhlbWUiO3M6NToiY3VydmUiO3M6MzoibGl2IjthOjE6e2k6MDtzOjI6IjExIjt9fQ==
[4eb4aebce936d6bff551127f3ad1e7a0] => 0091a64f1452474c239234660a644191
[PHPSESSID] => oebpo06misfihra6p1fv9qto72
)
==========================
SESSION :
------------------
Array
(
[php_captcha] => 8de2479470b6e6c1f9e600f2472886c4
)
==========================
VERSION INFO :
------------------
PHP version 5.2.14 OK
MySQL version 5.1.49-3~bpo50+1-log OK
Coppermine version 1.5.10 stable
==========================
Module: GD
------------------
Exact version 2.0.34
GD Version bundled (2.0.34 compatible)
FreeType Support 1
FreeType Linkage with freetype
T1Lib Support 1
GIF Read Support 1
GIF Create Support 1
JPG Support 1
PNG Support 1
WBMP Support 1
XPM Support
XBM Support 1
JIS-mapped Japanese Font Support
==========================
Key config settings
------------------
site_url http://topictype.de/
charset utf-8
allow_private_albums 1
cookie_name cpg15x
cookie_path /
impath /usr/bin/
lang english
main_page_layout breadcrumb/catlist/alblist/random,2/lastup,2
silly_safe_mode 0
smtp_host
theme curve
thumb_method gd2
==========================
Plugins
------------------
==========================
Server restrictions
------------------
safe_mode
safe_mode_exec_dir
safe_mode_gid
safe_mode_include_dir
sql.safe_mode
disable_functions
file_uploads 1
include_path .:/usr/share/pear/php5
open_basedir /is/htdocs/user_tmp/wp10478380_Z7TKV1K3TP:/tmp:/dev/null:/dev/urandom:/bin:/usr:/is/default.errors:/is/htdocs/wp10478380_Z7TKV1K3TP
allow_url_fopen 0
max_execution_time 30
max_input_time 60
upload_max_filesize 8M
post_max_size 8M
memory_limit 128M
suhosin.post.max_vars 800
suhosin.request.max_vars 800
==========================
Page (performance)
------------------
Parameter Current Peak
Memory usage 3,58 MB 4,49 MB
Page generation 169 ms 169 ms
Page query time 0 ms 0 ms
Page query count 4 4
==========================
-
Das ist nicht die erweiterte Fehlermeldung, sondern der Debug-Output. Schau dir nochmal genau die Fehlermeldung an. Da steht jetzt mehr als nur
Kritischer Fehler
Beim Ausführen einer Datenbank-Abfrage ist ein Fehler aufgetreten
-
sorry ^^
also:
Kritischer Fehler
Beim Ausführen einer Datenbank-Abfrage ist ein Fehler aufgetreten.
----
While executing query 'SELECT user_id AS user_id, user_name AS user_name, user_email AS user_email, UNIX_TIMESTAMP(user_regdate) AS user_regdate, UNIX_TIMESTAMP(user_lastvisit) AS user_lastvisit, user_active AS user_active, COUNT(pid) AS pic_count, ROUND(SUM(total_filesize)/1024) AS disk_usage, group_name, group_quota FROM `db10478380-copper`.cpg15x_users AS u INNER JOIN db10478380-copper.cpg15x_usergroups AS g ON u.user_group = g.group_id LEFT JOIN db10478380-copper.cpg15x_pictures AS p ON p.owner_id = u.user_id GROUP BY user_id ORDER BY user_regdate DESC LIMIT 0, 25;' in bridge/udb_base.inc.php on line 230
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 '-copper.cpg15x_usergroups AS g ON u.user_group = g.group_id LEFT JOIN db10478380' at line 1
---
Datei: /is/htdocs/wp10478380_Z7TKV1K3TP/www/coppermine/include/functions.inc.php - Zeile: 270
-
http://forum.coppermine-gallery.net/index.php/topic,68843.msg340262.html#msg340262
-
Dankeschön hat geklappt.