I have a coppermine gallery and a phpbb board (called orion), the coppermine is in the main root directory, the board is in 'orion' directory
The board is an altered version of the phpbb system with has the tables on the database as orion_ and not phpbb_
I now get the 'There was an error while processing a database query.' on my index page
I have run the debug mode on my gallery and get this...
USER:
------------------
Array
(
[ID] => 18fe5d801a891f2a6b9ef06994e76121
[am] => 1
[liv] => Array
(
- => 582
[1] => 170
[2] => 498
[3] => 581
[4] => 518
)
)
==========================
USER DATA:
------------------
Array
(
- => 2
[user_id] => 2
[1] => British-Babes-Admin
[user_name] => British-Babes-Admin
[2] => 1
[user_level] => 1
[groups] => Array
(
- => 1
[1] => 2
[2] => 29
)
[group_quota] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 1
[can_post_comments] => 1
[can_upload_pictures] => 1
[can_create_albums] => 1
[pub_upl_need_approval] => 0
[priv_upl_need_approval] => 0
[upload_form_config] => 3
[num_file_upload] => 10
[num_URI_upload] => 3
[custom_user_upload] => 0
[disk_max] => 1024
[disk_min] => 0
[ufc_max] => 3
[ufc_min] => 3
[has_admin_access] => 1
[group_name] => Admin
[can_see_all_albums] => 1
[group_id] => 1
)
==========================
Queries:
------------------
Array
(
- => SELECT extension, mime, content FROM cmfiletypes;
[1] => SELECT user_id, username as user_name, user_level FROM `rvfnlqtq`.orion_sessions INNER JOIN `rvfnlqtq`.orion_users ON session_user_id = user_id WHERE session_id='b82d77fc44d53dadb159c4333c0b3643' AND session_user_id ='2' AND user_active='1'
[2] => SELECT (ug.group_id + 5) as group_id FROM `rvfnlqtq`.orion_user_group as ug LEFT JOIN `rvfnlqtq`.orion_groups as g ON ug.group_id = g.group_id WHERE user_id = 2 AND user_pending = 0 AND group_single_user = 0
[3] => 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 cmusergroups WHERE group_id in (1,2,29)
[4] => SELECT group_name FROM cmusergroups WHERE group_id= 1
[5] => DELETE FROM cmbanned WHERE expiry < 1109537729
[6] => SELECT * FROM cmbanned WHERE ip_addr='80.5.160.7' OR ip_addr='81.97.164.227' OR user_id=2
[7] => DELETE FROM cmonline WHERE last_action < NOW() - INTERVAL 60 MINUTE
[8] => SELECT * FROM cmonline WHERE user_id='2'
[9] => UPDATE cmonline SET last_action = NOW() WHERE user_id = '2' LIMIT 1
[10] => SELECT cid, name, description, thumb FROM cmcategories WHERE parent = '' ORDER BY pos
[11] => SELECT aid FROM cmalbums as a WHERE category>=10000
[12] => SELECT count(*) FROM cmpictures as p, cmalbums as a WHERE p.aid = a.aid AND category >= 10000
[13] => SELECT cid, name, description, thumb FROM cmcategories WHERE parent = '1' ORDER BY pos
[14] => SELECT aid FROM cmalbums as a WHERE category = '0'
[15] => SELECT count(*) FROM cmalbums as a WHERE 1
[16] => SELECT count(*) FROM cmpictures as p LEFT JOIN cmalbums as a ON a.aid=p.aid WHERE 1
[17] => SELECT count(*) FROM cmcomments as c LEFT JOIN cmpictures as p ON c.pid=p.pid LEFT JOIN cmalbums as a ON a.aid=p.aid WHERE 1
[18] => SELECT count(*) FROM cmcategories WHERE 1
[19] => SELECT sum(hits) FROM cmpictures as p LEFT JOIN cmalbums as a ON p.aid=a.aid WHERE 1
[20] => SELECT count(*) FROM cmalbums as a WHERE category = '0'
[21] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cmalbums as a LEFT JOIN cmpictures as p ON a.thumb=p.pid WHERE category=0 ORDER BY a.pos LIMIT 0,34
[22] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload, sum(hits) as viewcount FROM cmpictures WHERE aid IN (51, 21, 24, 25, 26, 27, 19, 29, 30, 31, 32, 33, 34, 35, 37, 54, 43, 38, 39, 40, 41, 42, 44, 45, 46, 55, 47, 58, 48, 49, 50, 52, 61, 53) AND approved = 'YES' GROUP BY aid
[23] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='499'
[24] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='175'
[25] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='188'
[26] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='199'
[27] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='212'
[28] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='225'
[29] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='539'
[30] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='240'
[31] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='256'
[32] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='285'
[33] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='320'
[34] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='536'
[35] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='337'
[36] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='360'
[37] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='393'
[38] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='579'
[39] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='553'
[40] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='573'
[41] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='482'
[42] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='488'
[43] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='512'
[44] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='589'
[45] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cmpictures WHERE pid='518'
[46] => SELECT COUNT(*) from cmpictures WHERE approved = 'YES'
[47] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, aid FROM cmpictures WHERE approved = 'YES' ORDER BY RAND() LIMIT 4
[48] => SELECT COUNT(*) FROM **ERROR**
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 4.3.9 - OK
------------------
mySQL version: 4.0.20-standard
------------------
Coppermine version: 1.3.2
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.28 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
==========================
Module: mysql
------------------
Active Persistent Links 3
Active Links 4
Client API version 4.0.18
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.1.4
Linked Version 1.1.4
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | shell_exec,exec,system,passthru,popen,dlopen | shell_exec,exec,system,passthru,popen,dlopen
file_uploads | On | On
include_path | .:/usr/share/pear | .:/usr/share/pear
open_basedir | /tmp:/usr/share/pear:/home/fhlinux199/b/british-babes.co.uk/user | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | postmaster@british-babes.co.uk | 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 | 8M | 8M
post_max_size | 8M | 8M
==========================
Page generated in 1.008 seconds - 49 queries in 0.035 seconds - Album set :
Please help as this is getting annoying
You are using a mod that doesn't support bridging - possibly the 'users online' mod.