Fatal error, then not Fatal error, then not
 

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

Main Menu

Fatal error, then not

Started by Stormdancing, October 06, 2004, 05:36:31 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Stormdancing

I'm very new at this and I need some help. I've created a mess.  I followed the instruction for integrating with my phpBB2
This is what I get
Fatal error :

There was an error while processing a database query.
While executing query "SELECT user_id, username as user_name, user_level FROM `phpbb`.phpbb_sessions INNER JOIN `phpbb`.phpbb_users ON session_user_id = user_id WHERE session_id='e81331ceca9e0d0de96ffa968156f871' AND session_user_id ='2' AND user_active='1'" on 0

mySQL error: Access denied for user: 'storm@localhost' to database 'phpbb'
I know my login and pass to the db are correct as I am logged into phpmyadmin with same.

I searched and found  post that solved part of my problem
http://forum.coppermine-gallery.net/index.php?topic=5234.0

// database configuration
define('PHPBB_DB_NAME', 'phpbb'); // The name of the database used by the board
Change
define('PHPBB_DB_NAME', 'phpbb'); // The name of the database used by the board
to
define('PHPBB_DB_NAME', ''); // The name of the database used by the board

I get the gallery, but now I get

Notice: Undefined index: offline in /home/virtual/site20/fst/var/www/html/gallery/include/init.inc.php on line 381

Debug

USER:
------------------
Array
(
    [ID] => 563aaaab67b149996affb59df1af35f6
    [am] => 1
    [liv] => Array
        (
           
  • => 1
                [1] => 2
                [2] => 4
                [3] => 6
            )

    )

    ==========================
    USER DATA:
    ------------------
    Array
    (
        [disk_max] => 0
        [disk_min] => 0
        [can_rate_pictures] => 1
        [can_send_ecards] => 0
        [ufc_max] => 0
        [ufc_min] => 0
        [custom_user_upload] => 0
        [num_file_upload] => 5
        [num_URI_upload] => 3
        [can_post_comments] => 0
        [can_upload_pictures] => 0
        [can_create_albums] => 0
        [has_admin_access] => 0
        [pub_upl_need_approval] => 1
        [priv_upl_need_approval] => 1
        [group_name] => Anonymous
        [upload_form_config] => 0
        [group_quota] => 0
        [can_see_all_albums] => 0
        [group_id] => 3
        [groups] => Array
            (
               
  • => 3
            )

    )

    ==========================
    Queries:
    ------------------
    Array
    (
       
  • => SELECT extension, mime, content FROM cpg132_filetypes;
        [1] => SELECT user_id, username as user_name, user_level FROM phpbb_sessions INNER JOIN phpbb_users ON session_user_id = user_id WHERE session_id='e81331ceca9e0d0de96ffa968156f871' AND session_user_id ='2' AND user_active='1'
        [2] => 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 cpg132_usergroups WHERE group_id in (3)
        [3] => SELECT group_name FROM  cpg132_usergroups WHERE group_id= 3
        [4] => DELETE FROM cpg132_banned WHERE expiry < 1097047980
        [5] => SELECT * FROM cpg132_banned WHERE ip_addr='69.128.29.163' OR ip_addr='69.128.29.163' OR user_id=0
        [6] => SELECT aid FROM cpg132_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3)
        [7] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = ''  ORDER BY pos
        [8] => SELECT aid FROM cpg132_albums as a WHERE category>=10000
        [9] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND category >= 10000
        [10] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '1'  ORDER BY pos
        [11] => SELECT aid FROM cpg132_albums as a WHERE category = '0'
        [12] => SELECT count(*) FROM cpg132_albums as a WHERE 1
        [13] => SELECT count(*) FROM cpg132_pictures as p LEFT JOIN cpg132_albums as a ON a.aid=p.aid WHERE 1
        [14] => SELECT count(*) FROM cpg132_comments as c LEFT JOIN cpg132_pictures as p ON c.pid=p.pid LEFT JOIN cpg132_albums as a ON a.aid=p.aid WHERE 1
        [15] => SELECT count(*) FROM cpg132_categories WHERE 1
        [16] => SELECT sum(hits) FROM cpg132_pictures as p LEFT JOIN cpg132_albums as a ON p.aid=a.aid WHERE 1
        [17] => SELECT count(*) FROM cpg132_albums as a WHERE category = '0'
        [18] => SELECT COUNT(*) from cpg132_pictures WHERE approved = 'YES'
        [19] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, aid FROM cpg132_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 8
        [20] => SELECT COUNT(*) from cpg132_pictures WHERE approved = 'YES'
        [21] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid,title, caption, owner_id, owner_name, aid FROM cpg132_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,8
    )

    ==========================
    GET :
    ------------------
    Array
    (
    )

    ==========================
    POST :
    ------------------
    Array
    (
    )

    ==========================
    Page generated in 0.037 seconds - 22 queries in 0.006 seconds - Album set : [/color]

Joachim Müller

switch off notices display in debug mode - go to coppermine config, look at the very bottom.

Joachim

Stormdancing

You're kidding, how simple!!!!
You're great and I love this program.
Still got a lot of studying to do to get it the way I want, but I'll get there.
Thanks for your quick support.
On to making links - already read your post on how to do that.