Created on 1 December 2014, over 10 years ago
Updated 8 March 2025, 27 days ago

Hi i was able to get work this module on 7.x-1.2 version over a oracle backend (please see this issue β†’ related) , this is the patch:

diff -ENwbur sites/all/modules/contrib/forum_access/forum_access.install /Users/directordrupal/Desktop/forum_access/forum_access.install
--- sites/all/modules/contrib/forum_access/forum_access.install	2014-11-28 15:50:47.000000000 -0500
+++ /Users/directordrupal/Desktop/forum_access/forum_access.install	2012-09-15 11:47:00.000000000 -0500
@@ -163,7 +163,7 @@
  * Change our {acl} table records from 'name' to 'number' (D6 legacy).
  */
 function forum_access_update_6106() {
-  db_update('acl')->expression('number_acl', 'name')->condition('module', 'forum_access')->isNotNull('name')->execute();
+  db_update('acl')->expression('number', 'name')->condition('module', 'forum_access')->isNotNull('name')->execute();
   db_update('acl')->fields(array('name' => NULL))->condition('module', 'forum_access')->isNotNull('name')->execute();
 }
 
diff -ENwbur sites/all/modules/contrib/forum_access/forum_access.module /Users/directordrupal/Desktop/forum_access/forum_access.module
--- sites/all/modules/contrib/forum_access/forum_access.module	2014-12-01 15:57:46.000000000 -0500
+++ /Users/directordrupal/Desktop/forum_access/forum_access.module	2012-09-15 11:47:00.000000000 -0500
@@ -167,7 +167,7 @@
     $query = db_select('acl', 'acl');
     $query->join('acl_user', 'aclu', "acl.acl_id = aclu.acl_id");
     $count = $query
-      ->fields('acl', array('number_acl'))
+      ->fields('acl', array('number'))
       ->condition('acl.module', 'forum_access')
       ->condition('aclu.uid', $account->uid)
       ->countQuery()
@@ -324,14 +324,9 @@
   foreach ($tables as $talias => $tableinfo) {
     $table = $tableinfo['table'];
     if (!($table instanceof SelectQueryInterface) && $table == 'taxonomy_term_data') {
-      //support oracle driver
-      if ('oracle' == db_driver()) {
-        $query->addField($tableinfo['alias'], 'name');
-        $query->addField($tableinfo['alias'], 'weight');
-      }
       // The node_access table has the access grants for any given node.
       $access_alias = $query->leftJoin('forum_access', 'fa', '%alias.tid = ' . $talias . '.tid');
-      $acl_alias = $query->leftJoin('acl', 'acl', "%alias.number_acl = $talias.tid AND %alias.module = 'forum_access'");
+      $acl_alias = $query->leftJoin('acl', 'acl', "%alias.number = $talias.tid AND %alias.module = 'forum_access'");
       $aclu_alias = $query->leftJoin('acl_user', 'aclu', "%alias.acl_id = $acl_alias.acl_id AND %alias.uid = $account->uid");
       $query->condition(db_or()
         ->isNull("$access_alias.rid")
@@ -745,7 +740,6 @@
     $subselect
       ->fields('n', array('nid'))
       ->condition('n.tid', $tid);
-
     acl_add_nodes($subselect, $acl_id, 1, 1, 1);
   }
   return $acl_id;
diff -ENwbur sites/all/modules/contrib/forum_access/forum_access.node.inc /Users/directordrupal/Desktop/forum_access/forum_access.node.inc
--- sites/all/modules/contrib/forum_access/forum_access.node.inc	2014-11-28 15:51:59.000000000 -0500
+++ /Users/directordrupal/Desktop/forum_access/forum_access.node.inc	2012-09-15 11:47:00.000000000 -0500
@@ -108,7 +108,7 @@
   }
 
   // Also get all forums they happen to be able to moderate.
-  $result = db_query("SELECT a.number_acl AS tid FROM {acl} a INNER JOIN {acl_user} u ON a.acl_id = u.acl_id WHERE a.module = 'forum_access' AND u.uid = :uid", array(
+  $result = db_query("SELECT a.number AS tid FROM {acl} a INNER JOIN {acl_user} u ON a.acl_id = u.acl_id WHERE a.module = 'forum_access' AND u.uid = :uid", array(
     ':uid' => $user->uid,
   ));
   foreach ($result as $obj) {
πŸ› Bug report
Status

Closed: outdated

Version

1.0

Component

Code

Created by

πŸ‡¨πŸ‡΄Colombia metallized

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024