Integration problems

[ian ditch]

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

[Nibbler]

You are using a mod that doesn't support bridging - possibly the 'users online' mod.