Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Fatal Error when using phpbb Bridge  (Read 6392 times)

0 Members and 1 Guest are viewing this topic.

asterix

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Fatal Error when using phpbb Bridge
« on: September 04, 2005, 06:58:48 am »

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.
(http://img376.imageshack.us/img376/3420/error6yv.gif)

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



« Last Edit: October 21, 2005, 11:54:55 pm by GauGau »
Logged

Nibbler

  • Guest
Re: Fatal Error when using phpbb Bridge
« Reply #1 on: September 04, 2005, 06:59:54 am »

Enable debug mode and post the actual error.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Fatal Error when using phpbb Bridge
« Reply #2 on: September 04, 2005, 10:22:52 pm »

...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.
Logged

asterix

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Re: Fatal Error when using phpbb Bridge
« Reply #3 on: September 05, 2005, 06:00:40 am »

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)
 
Quote
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: ;
Quote
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
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: Fatal Error when using phpbb Bridge
« Reply #4 on: September 05, 2005, 06:46:51 am »

You still haven't posted the actual SQL error message.  Don't post debug output unless we request it.
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

asterix

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Re: Fatal Error when using phpbb Bridge
« Reply #5 on: September 05, 2005, 03:43:52 pm »

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

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Fatal Error when using phpbb Bridge
« Reply #6 on: September 05, 2005, 05:15:04 pm »

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.
Logged

asterix

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Re: Fatal Error when using phpbb Bridge
« Reply #7 on: September 05, 2005, 08:36:05 pm »

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 :
(http://img278.imageshack.us/img278/6379/error14ow.jpg)

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

Quote
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
Quote
that you have the most recent cvs checkout.
I don't know how to get these? CVS?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Fatal Error when using phpbb Bridge
« Reply #8 on: September 06, 2005, 07:09:22 am »

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.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Fatal Error when using phpbb Bridge
« Reply #9 on: October 21, 2005, 11:54:38 pm »

marking as "Invalid" - not knowing about cvs means that you're using an outdated version, so you're not qualified as beta tester, sorry.
Logged
Pages: [1]   Go Up
 

Page created in 0.023 seconds with 19 queries.