I am getting the following error once i activated the module. Please help in solving this issue.

    user warning: Unknown column 'n.nid' in 'on clause' query: block_morelink_preprocess_block /* generic_user : block_morelink_preprocess_block */ SELECT DISTINCT url, title FROM block_morelink INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'nodeaccess_rid') OR (na.gid = 3 AND na.realm = 'nodeaccess_uid') OR (na.gid = 3 AND na.realm = 'nodeaccess_author'))) AND ( module = 'user_status'AND delta = '1') in C:\xampp\htdocs\ecentral\modules\block_morelink\block_morelink.module on line 78.
    user warning: Unknown column 'n.nid' in 'on clause' query: block_morelink_preprocess_block /* generic_user : block_morelink_preprocess_block */ SELECT DISTINCT url, title FROM block_morelink INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'nodeaccess_rid') OR (na.gid = 3 AND na.realm = 'nodeaccess_uid') OR (na.gid = 3 AND na.realm = 'nodeaccess_author'))) AND ( module = 'user'AND delta = '1') in C:\xampp\htdocs\ecentral\modules\block_morelink\block_morelink.module on line 78.
    user warning: Unknown column 'n.nid' in 'on clause' query: block_morelink_preprocess_block /* generic_user : block_morelink_preprocess_block */ SELECT DISTINCT url, title FROM block_morelink INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'nodeaccess_rid') OR (na.gid = 3 AND na.realm = 'nodeaccess_uid') OR (na.gid = 3 AND na.realm = 'nodeaccess_author'))) AND ( module = 'views'AND delta = 'Forum_dept-block_1') in C:\xampp\htdocs\ecentral\modules\block_morelink\block_morelink.module on line 78.
    user warning: Unknown column 'n.nid' in 'on clause' query: block_morelink_preprocess_block /* generic_user : block_morelink_preprocess_block */ SELECT DISTINCT url, title FROM block_morelink INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'nodeaccess_rid') OR (na.gid = 3 AND na.realm = 'nodeaccess_uid') OR (na.gid = 3 AND na.realm = 'nodeaccess_author'))) AND ( module = 'views'AND delta = 'Uploads_depts-block_1') in C:\xampp\htdocs\ecentral\modules\block_morelink\block_morelink.module on line 78.
    user warning: Unknown column 'n.nid' in 'on clause' query: block_morelink_preprocess_block /* generic_user : block_morelink_preprocess_block */ SELECT DISTINCT url, title FROM block_morelink INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'nodeaccess_rid') OR (na.gid = 3 AND na.realm = 'nodeaccess_uid') OR (na.gid = 3 AND na.realm = 'nodeaccess_author'))) AND ( module = 'views'AND delta = 'calendar_dept-calendar_block_1') in C:\xampp\htdocs\ecentral\modules\block_morelink\block_morelink.module on line 78.

Comments

vikramaditya234’s picture

vikramaditya234 commented

There is an error in the creation and execution of SQL statement.
file: block_morelink.module
function: block_morelink_preprocess_block
replace: $result = db_query(db_rewrite_sql($sql),$variables['block']->module,$variables['block']->delta);
with : $result = db_query(db_rewrite_sql($sql,"url","title"),$variables['block']->module,$variables['block']->delta);