Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-8848

sql error in cache_moderators() function

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 3.0.6
    • 3.0.x
    • None
    • PHP Environment: 5.3.0
      Database: PostgresQL 8.4

      (3.0.6RC4)
      In functions_admin.php on line ~2361 need to change:

      			'FROM'		=> array(
      				ACL_OPTIONS_TABLE	=> 'o',
      				USER_GROUP_TABLE	=> 'ug',
      				ACL_GROUPS_TABLE	=> 'a',
      				GROUPS_TABLE		=> 'g',
      			),

      on this

      			'FROM'		=> array(
      				ACL_OPTIONS_TABLE	=> 'o',
      				USER_GROUP_TABLE	=> 'ug',
      				GROUPS_TABLE		=> 'g',
      				ACL_GROUPS_TABLE	=> 'a',
      			),

      because:

      SQL ERROR [ postgres ]
       
      ERROR: invalid reference to FROM-clause entry for table "a" LINE 1: ... a, pb_groups g LEFT JOIN pb_acl_roles_data r ON (a.auth_rol... ^ HINT: There is an entry for table "a", but it cannot be referenced from this part of the query. []
       
      SQL
       
      SELECT a.forum_id, ug.user_id, g.group_id FROM pb_acl_options o, pb_user_group ug, pb_acl_groups a, pb_groups g LEFT JOIN pb_acl_roles_data r ON (a.auth_role_id = r.role_id) WHERE (o.auth_option_id = a.auth_option_id OR o.auth_option_id = r.auth_option_id) AND ((a.auth_setting = 0 AND r.auth_setting IS NULL) OR r.auth_setting = 0) AND a.group_id = ug.group_id AND g.group_id = ug.group_id AND NOT (ug.group_leader = 1 AND g.group_skip_auth = 1) AND ug.user_id = 2 AND ug.user_pending = 0 AND o.auth_option LIKE 'm\\_%'
       
      BACKTRACE
       
      FILE: includes/db/postgres.php
      LINE: 177
      CALL: dbal->sql_error()
       
      FILE: includes/functions_admin.php
      LINE: 2385
      CALL: dbal_postgres->sql_query()
       
      FILE: includes/acp/acp_main.php
      LINE: 344
      CALL: cache_moderators()
       
      FILE: includes/functions_module.php
      LINE: 507
      CALL: acp_main->main()
       
      FILE: adm/index.php
      LINE: 74
      CALL: p_master->load_active()

            Acyd Burn Meik Sievertsen [X] (Inactive)
            vbart vbart
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: