Critical error

[Hythshade]

Sorry if this has already been explained, but I have searched this forum a billion times and still I must be missing something.

I have cpg and phpbb bridged with Joomla. I installed the bridged modpack 1.4.10 twice to make sure I didn't miss anything the first time, I added information to the bridgemgr.php file relating to mehdis joomcpg bridge files keeping the stramm mod part intact. I am using stramms oranje theme integrated.

The PM window comes up, when you select send pm, but the persons name doesn't appear in the window.

The site url is http://paintersblock.net/gallery
test account has been setup user:test pass: password



Here is the debug info when I click a users name.
While executing query "SELECT *, username AS user_name,
                                                                                email AS user_email,
                                                                                UNIX_TIMESTAMP(registerDate) AS user_regdate,
                                                                                '' AS user_location,
                                                                                '' AS user_website,
                                                            id AS user_id,
                                                             AS notify,
                                                             AS avatar_url

                                                                                FROM  `*****_paintersblock`.jos_users WHERE id = '67'" on Resource id #32

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 'AS notify,
                                                             AS avatar_url

                                 ' at line 7
USER:
------------------
Array
(
    [ID] => e1b3d823471a620bfa84b0b6ea9c1e7c
    [am] => 1
    [lang] => english
    [liv] => Array
        (
           

• => 32
          )
  
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [user_id] => 62
      [user_name] => admin
      [groups] => Array
          (
             
• => 1
          )
  
      [disk_max] => 0
      [disk_min] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 1
      [ufc_max] => 3
      [ufc_min] => 3
      [custom_user_upload] => 0
      [num_file_upload] => 5
      [num_URI_upload] => 3
      [can_post_comments] => 1
      [can_upload_pictures] => 1
      [can_create_albums] => 1
      [has_admin_access] => 1
      [pub_upl_need_approval] => 0
      [priv_upl_need_approval] => 0
      [group_name] => Administrators
      [upload_form_config] => 3
      [group_quota] => 0
      [can_see_all_albums] => 1
      [group_id] => 1
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM cpg1410_filetypes; (0s)
      [1] => select * from cpg1410_plugins order by priority asc; (0s)
      [2] => SELECT * FROM cpg1410_bridge (0s)
      [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 cpg1410_usergroups WHERE group_id in (1) (0s)
      [4] => SELECT group_name FROM  cpg1410_usergroups WHERE group_id= 1 (0s)
      [5] => SELECT user_favpics FROM cpg1410_favpics WHERE user_id = 62 (0s)
      [6] => SELECT name, value FROM cpg1410_config where name REGEXP '^plugin_displayfields_' (0s)
      [7] => SHOW TABLES LIKE 'cpg1410_cms_config' (0.002s)
      [8] => SELECT * FROM cpg1410_cms_config (0s)
      [9] => SELECT count(*) FROM  cpg1410_pms WHERE owner=62 (0s)
      [10] => SELECT count(*) FROM  cpg1410_pms WHERE owner=62 AND showed='0' (0s)
      [11] => SELECT count(*) FROM  cpg1410_buddy WHERE user_id=62 (0s)
      [12] => SELECT count(*) FROM  cpg1410_buddy_req WHERE buddy_to=62 (0s)
      [13] => DELETE FROM cpg1410_banned WHERE expiry < '2007-05-29 15:46:42' (0s)
      [14] => SELECT * FROM cpg1410_banned WHERE (ip_addr='72.193.158.128' OR ip_addr='72.193.158.128' OR user_id=62) AND brute_force=0 (0s)
      [15] => SELECT *, username AS user_name,
                                                                                  email AS user_email,
                                                                                  UNIX_TIMESTAMP(registerDate) AS user_regdate,
                                                                                  '' AS user_location,
                                                                                  '' AS user_website,
                                                              id AS user_id,
                                                               AS notify,
                                                               AS avatar_url
  
                                                                                  FROM  `cdw1bce_paintersblock`.jos_users WHERE id = '67' (0s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
      [uid] => 67
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.4.4 - OK
  ------------------
  mySQL version: 4.1.21-standard
  ------------------
  Coppermine version: 1.4.10 modpack v1(stable)
  ==========================
  Module: GD
  ------------------
  GD Version: bundled (2.0.28 compatible)
  FreeType Support: 1
  FreeType Linkage: with freetype
  T1Lib Support:
  GIF Read Support: 1
  GIF Create Support: 1
  JPG Support: 1
  PNG Support: 1
  WBMP Support: 1
  XBM Support: 1
  JIS-mapped Japanese Font Support:
  
  ==========================
  Module: mysql
  ------------------
  MySQL Supportenabled
  Active Persistent Links 0
  Active Links 2
  Client API version 4.1.21
  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.2.1.2
  Linked Version 1.2.1.2
  ==========================
  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 | dl | dl
  file_uploads | On | On
  include_path | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
  open_basedir | no value | 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 | 10M | 10M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.278 seconds - 16 queries in 0.002 seconds - Album set : ; Meta set: ;
  
  
  Thanks for your help

[Stramm]

looks to me as if the bridge file you modded doesn't contain all necessary info to run the modpack

First try without joomla. If CPG and phpbb work together smoothly. Then use a diff viewer like winmerge to find all differences of the standard and either the modpack modified or joomla modified bridge files. That way you probably will catch them all.