Fatal Error when using phpbb Bridge

[asterix]

I have successfully installed CPG 1.4 in the same database with my phpbb,and the standalone gallery ran well. Howerver,  at the final step, the error occured when I hit the 'Start bridging wizard' tab.
(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Fimg376.imageshack.us%2Fimg376%2F3420%2Ferror6yv.gif&hash=3d8711e965ff326fa1f1f4c483850c1b5bbc2acd)

I tried to access Coppermine by using bridgemgr.php but the error message was still fatal error.
Then I had to delete gallery tables in the database , and installed the gallery once again, but there 's still the same problem.

My site info:
Operating system     Linux
PHP version     4.4.0
MySQL version     4.0.25

My board: http://diendansaomai.net/forums/
Gallery: http://diendansaomai.net/gallery/

Thanks

[Nibbler]

Enable debug mode and post the actual error.

[Joachim Müller]

...and make sure that you have the most recent cvs checkout. It wouldn't have been necessary to delete and start over - accessing the database directly (using a tool like phpMyAdmin) and disabling bridging there would have been enough.

[asterix]

thanks, but I didn't the column to set in order to disable the bridge.
I did fresh install again (standalone, in the same database with my phpbb board); and when I enable the debug mod, I got the error message.
(still standalone version, not intergrated with phpbb)

USER:
------------------
Array
(
    [ID] => 539a16cdd893868800fad91ed342072a
    [am] => 1
    [lang] => english
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => onlytime
    [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 cpg140_filetypes; (0s)
      [1] => select * from cpg140_plugins order by priority asc; (0s)
      [2] => delete from `diendan_***`.cpg140_sessions where time<1125888246 and remember=0; (0s)
      [3] => delete from `diendan_***`.cpg140_sessions where time<1124682246; (0s)
      [4] => select user_id from `***`.cpg140_sessions where session_id=md5("0b4c8e7e0a4f0164025c1c6d916a08073454c6846b0b2bd7351e698fce1bd839"); (0s)
      [5] => select user_id as id, user_password as password from `diendan_***`.cpg140_users where user_id=1 (0s)
      [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `diendan_***`.cpg140_users AS u INNER JOIN `diendan_***`.cpg140_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
      [7] => SELECT user_group_list FROM `diendan_***`.cpg140_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
      [8] => 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 cpg140_usergroups WHERE group_id in (1) (0s)
      [9] => SELECT group_name FROM  cpg140_usergroups WHERE group_id= 1 (0s)
      [10] => update `diendan_***`.cpg140_sessions set time='1125891846' where session_id=md5('0b4c8e7e0a4f0164025c1c6d916a08073454c6846b0b2bd7351e698fce1bd839'); (0s)
      [11] => SELECT user_favpics FROM cpg140_favpics WHERE user_id = 1 (0s)
      [12] => DELETE FROM cpg140_banned WHERE expiry < '2005-09-05 03:44:06' (0s)
      [13] => SELECT * FROM cpg140_banned WHERE (ip_addr='***' OR ip_addr='***' OR user_id=1) AND brute_force=0 (0s)
      [14] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = ''  ORDER BY pos (0s)
      [15] => SELECT aid FROM cpg140_albums as a WHERE category>=10000 (0s)
      [16] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category >= 10000 (0s)
      [17] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '1'  ORDER BY pos (0s)
      [18] => SELECT aid FROM cpg140_albums as a WHERE category = '0' (0s)
      [19] => SELECT count(*) FROM cpg140_albums as a WHERE 1 (0s)
      [20] => SELECT count(*) FROM cpg140_pictures as p LEFT JOIN cpg140_albums as a ON a.aid=p.aid WHERE 1 (0s)
      [21] => SELECT count(*) FROM cpg140_comments as c LEFT JOIN cpg140_pictures as p ON c.pid=p.pid LEFT JOIN cpg140_albums as a ON a.aid=p.aid WHERE 1 (0s)
      [22] => SELECT count(*) FROM cpg140_categories WHERE 1 (0s)
      [23] => SELECT sum(hits) FROM cpg140_pictures as p LEFT JOIN cpg140_albums as a ON p.aid=a.aid WHERE 1 (0s)
      [24] => SELECT COUNT(*) FROM cpg140_pictures WHERE approved = 'NO' (0s)
      [25] => SELECT count(*) FROM cpg140_albums as a WHERE category = '0' (0s)
      [26] => SELECT COUNT(*) from cpg140_pictures WHERE approved = 'YES'  (0s)
      [27] => SELECT * FROM cpg140_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 8 (0s)
      [28] => SELECT COUNT(*) from cpg140_pictures WHERE approved = 'YES'  (0s)
      [29] => SELECT * FROM cpg140_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,8 (0s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.4.0 - OK
  ------------------
  mySQL version: 4.0.25-standard
  ------------------
  Coppermine version: 1.4.1(beta)
  ==========================
  Module: GD
  ------------------
  GD Version: bundled (2.0.28 compatible)
  FreeType Support:
  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
  ------------------
  module doesn't exist
  ==========================
  Module: zlib
  ------------------
  module doesn't exist
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value |  |  |  |  |  |  |  |
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value |  |  |  |  |  |  |  |
  ==========================
  Page generated in 0.078 seconds - 30 queries in 0 seconds - Album set : ; Meta set: ;
  

Notices
/index.php

    * Notice line 726: Undefined variable: file

/include/functions.inc.php

    * Warning line 2225: phpinfo() has been disabled for security reasons
    * Warning line 2225: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons
    * Warning line 2329: phpinfo() has been disabled for security reasons

Thanks for your support

[kegobeer]

You still haven't posted the actual SQL error message.  Don't post debug output unless we request it.

[asterix]

thanks,
but where is the "the actual SQL error message" ? I don't know where it is.

[Joachim Müller]

The one you refered to in your first posting:

Howerver,  at the final step, the error occured when I hit the 'Start bridging wizard' tab.

What error occured exactly? If you have no idea what the actual error message is, attach a screenshot to your posting. Make sure to disable notices_display in coppermine's config, we only need the plain debug_out option turned on.

[asterix]

sorry for making you confused.

Here's the details:

First the error occured when I installed the gallery and tried to intergrate it to the board right after. At the final step as refered in the screenshot in the first post, when I hit the start bridging wizard, the message  occured :
(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Fimg278.imageshack.us%2Fimg278%2F6379%2Ferror14ow.jpg&hash=af7e10cf14bfb43ef71086c01c804ffca0cd0242)

I loged in first as admin (of the phpbb) and I received the error message :

Fatal error :
While executing query "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 cpg140_usergroups WHERE group_id in ()" on 0

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 ')' at line 1

I didn't know how to disable the bridge. First, I tried to used bridgemgr.php, but the same error message occured (I loged in with account when installing the gallery). Then  I did go to the database, looking for the cpg140_bridge and the cpg140_config , but didn't know exactly what column's values to set).

Regards



p.s

that you have the most recent cvs checkout.

I don't know how to get these? CVS?

[Joachim Müller]

Read the sticky thread on this board to find out about CVS, particularly http://forum.coppermine-gallery.net/index.php?topic=7947.msg77748#msg77748
Please note that cpg1.4.x goes unsupported and it is meant for experienced users only on non-production environments for testing.

[Joachim Müller]

marking as "Invalid" - not knowing about cvs means that you're using an outdated version, so you're not qualified as beta tester, sorry.