ahaa ok, ich hatte gedacht es hätte vielleicht was mit rechten zu tun und weil es ohne bridge geht.
habe alles gemacht wie es beschrieben stand. nun wurde auch eine fehlermeldung erzeugt.
Kritischer Fehler
Beim Ausführen einer Datenbank-Abfrage ist ein Fehler aufgetreten.
While executing query "SELECT aid, CONCAT('(', username, ') ', a.title) AS title
FROM cpg143_albums AS a
INNER JOIN `usr_web37_1`.phpbb_users AS u
ON category = (10000 + user_id)
ORDER BY title" on 0
mySQL error: Illegal mix of collations for operation 'concat'
die datenbank vom board ist die usr_web37_1
und vom album die usr_web37_2
###### fehlerskript ##########################
USER:
------------------
Array
(
[ID] => b794755958c04d0b8f94734392b7b864
[am] => 1
[lang] => german
[liv] => Array
(
)
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 2
[user_name] => admin
[groups] => Array
(
)
[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 0
[can_send_ecards] => 0
[ufc_max] => 0
[ufc_min] => 0
[custom_user_upload] => 0
[num_file_upload] => 1
[num_URI_upload] => 0
[can_post_comments] => 0
[can_upload_pictures] => 0
[can_create_albums] => 0
[has_admin_access] => 1
[pub_upl_need_approval] => 1
[priv_upl_need_approval] => 1
[group_name] => Administrators
[upload_form_config] => 0
[group_quota] => 0
[can_see_all_albums] => 1
[group_id] => 102
)
==========================
Queries:
------------------
Array
(
- => SELECT extension, mime, content, player FROM cpg143_filetypes; (0s)
[1] => select * from cpg143_plugins order by priority asc; (0s)
[2] => SELECT * FROM cpg143_bridge (0s)
[3] => SELECT u.user_id AS user_id, u.user_password AS password, u.user_level FROM `usr_web37_1`.phpbb_users AS u, `usr_web37_1`.phpbb_sessions AS s WHERE u.user_id=s.session_user_id AND s.session_id = '4318b8d34c8ecb8e500bd52f5144bdf8' AND u.user_id > 0 (0s)
[4] => SELECT u.user_id AS id, u.username AS username, u.user_password AS password, ug.group_id AS group_id FROM `usr_web37_1`.phpbb_users AS u, `usr_web37_1`.phpbb_user_group AS ug WHERE u.user_id=ug.user_id AND u.user_id='2' (0s)
[5] => SELECT ug.group_id+100 AS group_id FROM `usr_web37_1`.phpbb_users AS u, `usr_web37_1`.phpbb_user_group AS ug, `usr_web37_1`.phpbb_groups as g WHERE u.user_id=ug.user_id AND u.user_id='2' AND g.group_id = ug.group_id AND group_single_user = 0 (0s)
[6] => 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 cpg143_usergroups WHERE group_id in (102) (0s)
[7] => SELECT group_name FROM cpg143_usergroups WHERE group_id= 102 (0s)
[8] => SELECT user_favpics FROM cpg143_favpics WHERE user_id = 2 (0.001s)
[9] => DELETE FROM cpg143_banned WHERE expiry < '2006-03-05 12:28:47' (0s)
[10] => SELECT * FROM cpg143_banned WHERE (ip_addr='84.174.141.201' OR ip_addr='84.174.141.201' OR user_id=2) AND brute_force=0 (0s)
[11] => SELECT * FROM cpg143_albums WHERE aid='4' (0s)
[12] => SELECT COUNT(*) FROM cpg143_pictures WHERE approved = 'NO' (0s)
[13] => SELECT aid, title FROM cpg143_albums WHERE category < '10000' ORDER BY title (0s)
[14] => SELECT aid, CONCAT('(', username, ') ', a.title) AS title
FROM cpg143_albums AS a
INNER JOIN `usr_web37_1`.phpbb_users AS u
ON category = (10000 + user_id)
ORDER BY title (0s)
)
==========================
GET :
------------------
Array
(
[album] => 4
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 4.3.10-16 - OK
------------------
mySQL version: 4.1.11-Debian_4sarge2-log
------------------
Coppermine version: 1.4.4(stable)
==========================
Module: GD
------------------
GD Version: 2.0 or higher
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
XBM Support:
JIS-mapped Japanese Font Support:
==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 1
Active Links 2
Client API version 4.0.24
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.2.2
Linked Version 1.2.2
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | On | On
safe_mode_exec_dir | /home/www/empty/ | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | /home/www/empty/ | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | . | .:/usr/share/php:/usr/share/pear
open_basedir | /home/www/web37/html/:/home/www/web37/phptmp/:/home/www/web37/files/:/home/www/web37/atd/ | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 32M | 32M
post_max_size | 32M | 32M
==========================
Page generated in 0.315 seconds - 15 queries in 0.001 seconds - Album set : ; Meta set: ;
############# fehlerskript ende ################
danke noch mal für die superschnelle hilfe... und das noch am sonntag ;-)
gruss maik