Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Fatal Error when using phpbb Bridge  (Read 6391 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.025 seconds with 19 queries.